John K Rees

US Patent:

8078579, Dec 13, 2011

Filed:

Jul 14, 2007

Appl. No.:

11/778033

Inventors:

Michael Grossman - Marlborough MA, US
John Rees - Brookline MA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00
G06F 17/00
G06F 9/46

US Classification:

707625, 718106

Abstract:

A method and system for determining currency of data in a data processing system. The processing steps along a dependency chain used to populate a data reporting program are back tracked recursively through each processing step until a first originating set of processing steps are reached. The currency of each data source for the programs is identified and it is determined whether the program has run since that time. If any one of the sources for the program of the processing step is more recent than a last run time of the program associated with the processing step, the program is re-run and outputs updated. The same process is executed moving forward along the dependency chain, to each other processing step.

US Patent:

8205189, Jun 19, 2012

Filed:

Jul 13, 2007

Appl. No.:

11/777568

Inventors:

Michael Grossman - Marlborough MA, US
John Rees - Brookline MA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 9/44
G06F 7/00

US Classification:

717120, 717100, 707600

Abstract:

A method and system for definition control in a data repository application. Each structure for the repository application is defined. Each structure and a corresponding definition for the structure are stored in a library. An object is created for each structure stored in the library that points to the definition. The structures are interconnected as the application is built. The repository application is built for a specific use includes each of the interconnected structures and provides automatic tracking of each use of each definition and automatic cascading of definition changes to each use.

US Patent:

20140114905, Apr 24, 2014

Filed:

Mar 14, 2013

Appl. No.:

13/804049

Inventors:

- Redwood Shores CA, US
John K. REES - Brookline MA, US

Assignee:

ORACLE INTERNATIONAL CORPORATION - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707600

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.

US Patent:

20140114907, Apr 24, 2014

Filed:

Mar 14, 2013

Appl. No.:

13/803883

Inventors:

- Redwood Shores CA, US
John K. REES - Brookline MA, US
Abhishek NARAYAN - Sunnyvale CA, US

International Classification:

G06F 17/30

US Classification:

707602

Abstract:

A data lineage system is provided that traces a data lineage of a data warehouse. The data lineage system maps a target data element to one or more source data elements. The data lineage system further stores one or more source surrogate keys within one or more auxiliary columns of a target data record. The data lineage system further stores, for each source data element, a data lineage mapping system record within a data lineage mapping system table that represents the mapping of the target data element and the corresponding source data element. The data lineage system further maps a source data element to one or more target data elements. The system further stores, for each target data element, a shadow system record within a shadow system table that represents the mapping of the source data element and the corresponding target data element.