Apparatus and method for capturing and propagating changes from

Data processing: database and file management or data structures – Database design – Data structure types

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

707 10, G06F 1730

Patent

active

06032158&

ABSTRACT:
A method for updating a target table of a data mart in response to changes made by a transaction to data stored in a source table of an operational database. Data that was changed in the source table by the transaction is stored in a dynamic image table of a change capture database. Data that was not changed in the source table by the transaction, but which is nevertheless required to be mapped to the target table, is stored in a static image table of the change capture database. The change capture database also contains relevant information regarding the transaction. Once the dynamic and static image tables are properly staged, the changes are propagated from the change capture database to the target tables of the data marts. In other words, data is extracted from the change capture database and subsequently transformed and loaded, thereby minimizing the impact to the operational database. Thereupon, the tables of the change capture database are truncated to discard data which is now no longer needed.

REFERENCES:
patent: 5603024 (1997-02-01), Goldring
patent: 5675785 (1997-10-01), Hall et al.
patent: 5781911 (1998-07-01), Young et al.
patent: 5787415 (1998-07-01), Jacobson et al.
Chan, R. "12 Steps of Creating a Successful Data Warehouse." Proceedings of the 8th International Database Workshop (Industrial Volume), Proceedings of the 8th International Hong Kong Computer Society Database Workshop. Data Mining, Data Warehousing and CLI, pp.227-248, XP002074804. ISBN 981-3083-53-0, 1997, Singapore, Springer-Verlag Singapore, Singapore.
Anand, V. J. et al. "Data Warehouse Architecture for DDS Applications." Australian Journal of Information Systems. Sep. 1996, AJIS Publishing, Australia, vol. 4, No. 1, pp. 43-53, XP002074805 ISSN 10399-7841.
Weyman, P. J. "The Case for a Process-Driven Approach to Data Warehousing." Database and Network Journal, Feb. 1997, A. P. Publications, UK, vol. 27, No. 1, pp. 3-6, XP002074806, ISSN 0265-4490.
Mumick I. S. et al. "Maintenance of Data Cubes and Summary Tables in a Warehouse." SIGMOD 1997. ACM SIGMOD International Conference on Management of Data, Tucson, AZ, USA, 13-15, May 1997, vol. 26, No. 2, pp. 100-111, XP002074807, ISSN 0163-5808, SIGMOD Record, Jun. 1997, ACM, USA.
Curley, K. et al. "The Rationale for Developing a Corporate Data Warehouse Environment." OOIS '95. 1995 International Conference on Object Oriented Information Systems Proceedings, Proceedings of 1995, International Conference on Object Oriented Infromation Systems, Dublin, Ireland, Dec. 18-20, 1995, pp. 351-366, XP002074808, ISBN 3-540-76010-5, 1996, Berlin Gemany, Springer-Verlag, Germany.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Apparatus and method for capturing and propagating changes from does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for capturing and propagating changes from , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for capturing and propagating changes from will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-692320

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.