Associated information propagation system

• US 9,063,998 B2
• Filed: 03/14/2013
• Issued: 06/23/2015
• Est. Priority Date: 10/18/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Kozina, Ludmila, Rees, John K.
• Primary Examiner(s): Spieler, William
• Application Number:
  US13/804,049
• Publication Number:
  US 20140114905A1
• Time in Patent Office: 831 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

An associated information system is provided that propagates visibility of associated information. The associated information system traces a data lineage of a data warehouse. The associated information system further identifies an association between a primary data element and an associated object, where the association between the primary data element and the associated object is identified as a primary link. The associated information system further stores a first associated object mapping system record within an associated object mapping system table that represents the primary link. The associated information system further identifies an association between a secondary data element and the associated object using the data lineage, where the association between the secondary data element and the associated object is identified as a secondary link, and where the secondary data element is related to the primary data element within the data lineage. The associated information system further stores a second associated object mapping record within the associated object mapping system table that represents the secondary link.

Claims

1. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to propagate visibility of associated information, the propagating comprising:

tracing a data lineage of a data warehouse comprising one or more data tables;

storing a first associated object mapping system record within an associated object mapping system table that represents an association between a primary data element of the data lineage and an associated object, wherein the association between the primary data element and the associated object is identified as a primary link;

identifying an association between a secondary data element and the associated object using the data lineage, wherein the secondary data element is related to the primary data element within the data lineage; and

storing a second associated object mapping record within the associated object mapping system table that represents the association between the secondary data element of the data lineage and the associated object and that represents an association between the primary data element and the secondary data element, wherein the association between the secondary data element and the associated object is identified as a secondary link;

wherein the associated object comprises information other than a data element of the data lineage.

2. The non-transitory computer-readable medium of claim 1,

wherein each data table comprises one or more data records;

wherein the primary data element comprises a column of a primary data record;

wherein the associated object comprises associated information;

wherein the first associated object mapping system record comprises an identity of the primary data element, an identity of the associated object, and a primary link indicator;

wherein the secondary data element comprises a column of a secondary data record; and

wherein the second associated object mapping record comprises an identity of the secondary data element, an identity of the associated object, and a secondary link indicator.

3. The non-transitory computer-readable medium of claim 2,

wherein the primary data element comprises the primary data record;

and

wherein the secondary data element comprises the secondary data record.

4. The non-transitory computer-readable medium of claim 1, the propagating further comprising:

displaying the primary data element or the secondary data element within a user interface;

selecting either the primary data element or the secondary data element; and

displaying the associated object within the user interface using either the first associated object mapping system record or the second associated object mapping system record.

5. The non-transitory computer-readable medium of claim 4, wherein the display of the associated object is filtered by an associated object type.

6. The non-transitory computer-readable medium of claim 1,

wherein the first associated object mapping system record comprises a data element model identity that identifies a data model of the primary data element, a data element table identity that identifies a data table of the primary data element, and a data element column identity that identifies a column of the primary data element;

and

wherein the second associated object mapping system record comprises a data element model identity that identifies a data model of the secondary data element, a data element table identity that identifies a data table of the secondary data element, and a data element column identity that identifies a column of the secondary data element.

7. The non-transitory computer-readable medium of claim 1, wherein the associated object is one of:

a discrepancy, a comment, a status flag, a state indicator, a tag, an image, a recording, a file, a link, or a document.

8. The non-transitory computer-readable medium of claim 1, wherein the secondary data element is a source data element of the primary data element.

9. The non-transitory computer-readable medium of claim 8, wherein the second associated object mapping record comprises an indication that the secondary data element is a preferred source data element.

10. The non-transitory computer-readable medium of claim 1, wherein the identity of the primary data element and the identity of the secondary data element are each surrogate keys.

11. The non-transitory computer-readable medium of claim 1, the propagating further comprising:

deleting the primary data element;

deleting the first associated object mapping record;

deleting the second associated object mapping record; and

modifying a state of the associated object to a closed state.

12. A computer-implemented method for propagating visibility of associated information, the computer-implemented method comprising:

tracing a data lineage of a data warehouse comprising one or more data tables;

storing a first associated object mapping system record within an associated object mapping system table that represents an association between a primary data element of the data lineage and an associated object, wherein the association between the primary data element and the associated object is identified as a primary link;

identifying an association between a secondary data element and the associated object using the data lineage, wherein the secondary data element is related to the primary data element within the data lineage; and

storing a second associated object mapping record within the associated object mapping system table that represents the association between the secondary data element of the data lineage and the associated object and that represents an association between the primary data element and the secondary data element, wherein the association between the secondary data element and the associated object is identified as a secondary link;

wherein the associated object comprises information other than a data element of the data lineage.

13. The computer-implemented method of claim 12,

wherein each data table comprises one or more data records;

wherein the primary data element comprises a column of a primary data record;

wherein the associated object comprises associated information;

wherein the first associated object mapping system record comprises an identity of the primary data element, an identity of the associated object, and a primary link indicator;

wherein the secondary data element comprises a column of a secondary data record;

wherein the secondary data element is related to the primary data element within the data lineage, and

wherein the second associated object mapping record comprises an identity of the secondary data element, an identity of the associated object, and a secondary link indicator.

14. The computer-implemented method of claim 12, further comprising:

displaying the primary data element or the secondary data element within a user interface;

selecting either the primary data element or the secondary data element; and

displaying the associated object within the user interface using either the first associated object mapping system record or the second associated object mapping system record.

15. The computer-implemented method of claim 14, wherein the display of the associated object is filtered by an associated object type.

16. The computer-implemented method of claim 12,

wherein the first associated object mapping system record comprises a data element model identity that identifies a data model of the primary data element, a data element table identity that identifies a data table of the primary data element, and a data element column identity that identifies a column of the primary data element;

and

wherein the second associated object mapping system record comprises a data element model identity that identifies a data model of the secondary data element, a data element table identity that identifies a data table of the secondary data element, and a data element column identity that identifies a column of the secondary data element.

17. The computer-implemented method of claim 12, wherein the associated object is one of:

a discrepancy, a comment, a status flag, a state indicator, a tag, an image, a recording, a file, a link, or a document.

18. A system for propagating visibility of associated information, the system comprising:

a processor;

a memory configured to store one or more instructions;

a data lineage module configured to trace a data lineage of a data warehouse comprising one or more data tables;

an associated information storage module configured to store a first associated object mapping system record within an associated object mapping system table that represents an association between a primary data element of the data lineage and an associated object, wherein the association between the primary data element and the associated object is identified as a primary link;

an associated information identification module configured to identify an association between a secondary data element and the associated object using the data lineage, wherein the secondary data element is related to the primary data element within the data lineage; and

wherein the associated information storage module is further configured to store a second associated object mapping record within the associated object mapping system table that represents the association between the secondary data element of the data lineage and the associated object and that represents an association between the primary data element and the secondary data element, wherein the association between the secondary data element and the associated object is identified as a secondary link;

wherein the associated object comprises information other than a data element of the data lineage.

19. The system of claim 18,

wherein each data table comprises one or more data records;

wherein the primary data element comprises a column of a primary data record;

wherein the associated object comprises associated information;

wherein the first associated object mapping system record comprises an identity of the primary data element, an identity of the associated object, and a primary link indicator;

wherein the secondary data element comprises a column of a secondary data record;

wherein the secondary data element is related to the primary data element within the data lineage, and

wherein the second associated object mapping record comprises an identity of the secondary data element, an identity of the associated object, and a secondary link indicator.

20. The system of claim 18, further comprising:

a data element display module configured to display the primary data element or the secondary data element within a user interface;

a data element selection module configured to select either the primary data element or the secondary data element; and

an associated object display module configured to display the associated object within the user interface using either the first associated object mapping record or the second associated object mapping record.

21. The system of claim 20, wherein the display of the associated object is filtered by an associated object type.

22. The system of claim 18,

wherein the first associated object mapping system record comprises a data element model identity that identifies a data model of the primary data element, a data element table identity that identifies a data table of the primary data element, and a data element column identity that identifies a column of the primary data element;

and

wherein the second associated object mapping system record comprises a data element model identity that identifies a data model of the secondary data element, a data element table identity that identifies a data table of the secondary data element, and a data element column identity that identifies a column of the secondary data element.

23. The system of claim 18, wherein the associated object is one of:

a discrepancy, a comment, a status flag, a state indicator, a tag, an image, a recording, a file, a link, or a document.

24. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to propagate visibility of associated information, the propagating comprising:

tracing a data lineage of a data warehouse comprising one or more data tables;

storing a first associated object mapping system record within an associated object mapping system table that represents an association between a primary data element of the data lineage and an associated object, wherein the association between the primary data element and the associated object is identified as a primary link;

identifying an association between a secondary data element and the associated object using the data lineage, wherein the secondary data element is related to the primary data element within the data lineage;

storing a second associated object mapping record within the associated object mapping system table that represents the association between the secondary data element of the data lineage and the associated object and that represents an association between the primary data element and the secondary data element, wherein the association between the secondary data element and the associated object is identified as a secondary link;

deleting the primary data element;

deleting the first associated object mapping record;

deleting the second associated object mapping record; and

modifying a state of the associated object to a closed state.