High-performance change capture for data warehousing

Details High-performance change capture for data warehousing High-performance change capture for data warehousing

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2485936

A method and software for change data capture is described, in which change data is extracted from a recovery log in a single pass and stored into multiple database objects, such as change tables. The change data indicates modifications that has been performed to multiple source objects that correspond to the multiple database objects. In a preferred embodiment, this can be accomplished with a single multi-table insert SQL statement.

L'invention concerne un procédé et un logiciel de capture de données de changement. Selon cette invention, des données de changement sont extraites d'un journal de reprise en une seule passe et mémorisées dans plusieurs objets de base de données, tels que des tables de changement. Ces données de changement indiquent des modifications qui ont été apportées à plusieurs objets sources correspondant auxdits objets de base de données. Dans un mode de réalisation préféré, cette opération peut être accomplie avec un seul ordre SQL d'insertion dans plusieurs tables.

Affiliated with

Also associated with

Rating

High-performance change capture for data warehousing does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with High-performance change capture for data warehousing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and High-performance change capture for data warehousing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-2029500