Patent ID: 7925672

Claim:
A non-transitory computer-readable storage medium containing a program which, when executed by a processor, performs operations for generating metadata describing objects of a data abstraction model with logical fields that define abstract views of physical data in a database, the operations comprising: traversing a logical tree structure representing the data abstraction model, the logical tree structure having a plurality of nodes; determining a node type for each node of the plurality of nodes, wherein the node type specifies whether the node is a logical field and a category; identifying metadata from the data abstraction model describing the plurality of nodes; storing, for each node of the plurality of nodes, the node type and the identified metadata in a queryable database; and processing a query issued against the queryable database to identify objects in the data abstraction model available to be used to construct an abstract query; wherein storing the identified metadata in a queryable database comprises: creating a first database table configured to allow unique identification of each node contained in the logical tree structure; and creating a second database table configured to provide detail information for at least a portion of the nodes identified in the first database table.