Relationship management in a data abstraction model
AssigneeInternational Business Machines Corporation
InventorsRichard D. Dettinger, Daniel P. Kolz, Richard J. Stevens, Shannon E. Wenzel
Life of this patent
Estimating the term…
Abstract
A method, system and article of manufacture for managing relationships in a data abstraction model abstractly describing data in a database. One embodiment provides a method of linking logical branches of data in a database based on the relationships. The method includes accessing a data abstraction model abstractly describing the data in the database. The data abstraction model defines a logical tree structure having a plurality of logical branches. Relationships between logical fields of different logical branches are identified and logical links abstractly describing the identified relationships are created.
Claims17
A method of managing relationships between logical fields in a data abstraction model, wherein the logical fields correspond to physical fields in a database, comprising:
- providing a structure with links between logical branches of the data abstraction model defining logical fields, some of which share a common name, wherein the links allow for the joining of data structures containing the physical fields when executing an abstract query containing a reference to a common name shared by multiple logical fields, and wherein each link defines a path between different data structures of a physical representation of the data in the database;
- and
- constructing, by operation of one or more computer processors, an executable query from the abstract query using the provided structure, wherein constructing comprises generating logic to join a plurality of the data structures as defined by the one or more links.
A computer readable storage medium containing a program which, when executed by one or more processors, performs a method for managing relationships between logical fields in a data abstraction model, wherein the logical fields correspond to physical fields in a database, the operation comprising:
- accessing a structure with links between logical branches of the data abstraction model defining logical fields, wherein some of logical fields share a common name, wherein the links allow for the joining of data structures containing the physical fields when executing an abstract query containing a reference to a common name shared by multiple logical fields, and wherein each link defines a path between different data structures of a physical representation of the data in the database;
- and
- transforming the abstract query into an executable query using the accessed structure, wherein transforming comprises generating logic to join a plurality of the data structures as defined by the one or more links.
A computer system, comprising:
- a memory containing a program for managing relationships between logical fields in a data abstraction model, wherein the logical fields correspond to physical fields in a database;
- and
- a computer processor, which when executing the program, performs an operation comprising:
- accessing a structure with links between logical branches of the data abstraction model defining logical fields, wherein some of logical fields share a common name, and wherein the links allow for the joining of data structures containing the physical fields when executing an abstract query containing a reference to a common name shared by multiple logical fields, and wherein each link defines a path between different data structures of a physical representation of the data in the database;
- and
- transforming the abstract query into an executable query using the accessed structure, wherein transforming comprises generating logic to join a plurality of the data structures as defined by the one or more links.
Dependencies are inferred from the claim text.