Patent ID: 7650357

Claim:
A data storage and accessing system including computer executable instructions on a computer storage media and a processor configured to implement the computer executable instructions to implement one or more components comprising a translator configured to receive an entity based query including entities with inheritance and translate the entity based query to a relational database query and the translator generating a data structure comprises a query tree corresponding to an inheritance tree structure of the entities of the entity based query and the query tree comprising one or more entity group nodes for the entities of the inheritance tree structure wherein the one or more entity group nodes comprise a merger of at least one entity node in the inheritance tree structure and another related entity node in the inheritance tree structure that is mapped to a common table in a relational database as the least one entity node wherein the one or more entity group nodes include at least one entity group node comprising the merger of a base node and a child node descendent from the base node wherein the merger of the child node and the base node comprises removal of the child node from a descendent list of the base node and insertion of a child class list in a class list of the at least one entity group node and the one or more entity group nodes of the query tree being traversable to generate a query statement to the relational database.