On-demand multi-version denormalized data dictionary to...

Details On-demand multi-version denormalized data dictionary to... On-demand multi-version denormalized data dictionary to...

2007-06-26

2007-06-26

Rimell, Sam (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

10414027

ABSTRACT:
A method, system, and computer program product provides a data dictionary that can represent multiple versions of the schema objects, and which provides improved performance, reduced computing costs, and more accurate results in a variety of applications, such as in a database redo log mining system. A method of providing a data dictionary comprises the steps of determining whether information about the data object is present in a denormalized data dictionary history table, and if the information about the data object is not present in the denormalized data dictionary history table, then querying a normalized data dictionary to obtain the information about the data object, including a version identifier of the data object, and storing the version identifier and the obtained information about the data object including the version identifier in the denormalized data dictionary history table.

REFERENCES:
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 2002/0103819 (2002-08-01), Duvillier et al.
Technical Work Paper Oracle9i LogMiner Jan. 2002 22 pages.
Oracle 9I Database Administrator;s Guide Release 1 (9.0.1) Jun. 2001 pp. 9-1 to 9-22.

Affiliated with

Also associated with

Rating

On-demand multi-version denormalized data dictionary to... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with On-demand multi-version denormalized data dictionary to..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and On-demand multi-version denormalized data dictionary to... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3858324