Low-impact refresh mechanism for production databases

Details Low-impact refresh mechanism for production databases Low-impact refresh mechanism for production databases

2011-07-26

2011-07-26

Lu, Charles E (Department: 2161)

Data processing: database and file management or data structures

File or database maintenance

Database backup

Reexamination Certificate

active

07987157

ABSTRACT:
System and method for refreshing databases. A refresh mechanism may allow a data warehouse to remain available to users while the data is being refreshed. Embodiments may be used to perform low impact off-host data loading for databases including, but not limited to, data warehouses and to reduce the data loading window. A checkpoint of the production database may be generated. A database clone may be generated from the checkpoint. In one embodiment, the generated database clone includes references to data in the production database and not the data itself, and is thus storage space-efficient. Data may be loaded to the database clone. The checkpoint may then be switched to be the entry point to the production database after the loading is complete.

REFERENCES:
patent: 5956713 (1999-09-01), Bamford et al.
patent: 6014674 (2000-01-01), McCargar
patent: 6105030 (2000-08-01), Syed et al.
patent: 6578041 (2003-06-01), Lomet
patent: 6636876 (2003-10-01), Ishihara et al.
patent: 6957362 (2005-10-01), Armangau
patent: 6978282 (2005-12-01), Dings et al.
patent: 7003694 (2006-02-01), Anderson, Jr. et al.
patent: 2002/0032883 (2002-03-01), Kampe et al.
patent: 2003/0005120 (2003-01-01), Mutalik et al.
patent: 2003/0092438 (2003-05-01), Moore et al.
patent: 2003/0217119 (2003-11-01), Raman et al.
patent: 2004/0030739 (2004-02-01), Yousefi'zadeh
Ralph Kimball, “The Operational Data Warehouse,” www.dbsmag.com, Jan. 1998. (5 Pages).
Labio et al., Efficient Snapshot Differential Algorithms for Data Warehousing, http://www-db.stanford.edu/pub/papers/window-short.ps, 1996, (25 pages).

Affiliated with

Also associated with

Rating

Low-impact refresh mechanism for production databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Low-impact refresh mechanism for production databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Low-impact refresh mechanism for production databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2629269