Techniques for cross referencing data
AssigneeTeradata US, Inc.
InventorsThomas Kevin Ryan, Carl Lewis Christofferson, Neelesh Bansode, Santosh Kumar Singh, Latesh Pant, Ankit Khare
Life of this patent
Estimating the term…
Abstract
Techniques for cross referencing data are presented. A first database object and a second database object are linked together. The linkage is automatically cross referenced to a third database object. Access to any of the database objects can be achieved via any of the remaining database objects and vice versa. Additionally, the link and cross reference can be visualized and visually manipulated and modified.
Claims12
A method implemented in a computer-readable storage medium and executed on a processing device, the method comprising:
- interacting, via the processing device, with a user to identify a link between a first element of a first database table, a second element from a second database table, and a third element from a third database table, wherein interacting further includes interacting with the user via a Graphical User Interface (GUI) tool that includes user-guided fields to receive the link, the user-guided field represented as graphic shapes, inspecting, by said processing device, metadata associated with the link to identify the first element and the second element and their relationship to one another;
- cross referencing, via the processing device, the first element, the second element, and the third element to a master element in a master table;
- and
- assigning, via the processing device, a new attribute to the master element, the new attribute is just associated with the master element and is not associated with the first element, the second element, or the third element, the user directing that the new attribute not be associated with the first, second, and third elements and their respective tables, and assigning additional attributes to the master element, by the user through the GUI tool, the additional attributes including an effective start date and an effective end date, and permitting interaction by the user with the GUI tool to edit table attributes for the first element, the second element, and the third element through access to the master element within the GUI tool.
A method implemented in a computer-readable storage medium and executed by a processor, the method comprising:
- presenting, via the processor, a graphical presentation showing a link between a first database object from a first database table to a second database object from a second database table and to a third database object from a third database table, each of the objects represented as graph objects within the graphical presentation;
- receiving, by the processor as directed by a user, a cross reference between the link and a master database object from a master database table;
- automatically updating, by the processor, metadata in the master database table to associate the first database object, the second database object, and the third database object with the master database object;
- and
- assigning, via the processing, a new attribute to the master database object, the new attribute is just associated with the master database object and is not associated with the first database object, the second database object, or the third database object, the user directing that the new attribute not be associated with the first, second, and third objects and their respective tables, and assigning, from the user, an additional attribute to the master database object, the additional attribute includes:
- an approved by value, an approved date, and a status, and permitting interaction from the user to edit table attributes for the first database object, the second database object, and the third database object through access to the master database element.
Dependencies are inferred from the claim text.