Redundant version information in history table that enables...

Details Redundant version information in history table that enables... Redundant version information in history table that enables...

2011-08-30

2011-08-30

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

File or database maintenance

Synchronization

C707S649000, C707S695000, C707S806000

Reexamination Certificate

active

08010492

ABSTRACT:
A system for efficient snapshot querying include: providing a first version value for each data in a history table, where the first version value indicates a beginning of a period in which the data is valid; providing at least a second version value for each data in the history table, where the second version value indicates an end of the period in which the data is valid; receiving a request for a version of a database; and retrieving the data with the first version value less than or equal to the requested version and the second version value greater than or equal to the requested version. By maintaining a history table with redundant version information, the system is able to provide efficient snapshot querying while also avoiding the overhead burden of conventional approaches. No aggregates, joins, or sub-queries are required to retrieve a snapshot.

REFERENCES:
patent: 5623661 (1997-04-01), Hon
patent: 5675802 (1997-10-01), Allen et al.
patent: 5870758 (1999-02-01), Bamford et al.
patent: 5870759 (1999-02-01), Bauer et al.
patent: 5950210 (1999-09-01), Nelson
patent: 5956713 (1999-09-01), Bamford et al.
patent: 5956731 (1999-09-01), Bamford et al.
patent: 5963959 (1999-10-01), Sun et al.
patent: 5999931 (1999-12-01), Breitbart et al.
patent: 6092086 (2000-07-01), Martin et al.
patent: 6289335 (2001-09-01), Downing et al.
patent: 6295541 (2001-09-01), Bodnar et al.
patent: 6377960 (2002-04-01), Qiu et al.
patent: 6415299 (2002-07-01), Baisley et al.
patent: 6460052 (2002-10-01), Thomas et al.
patent: 6516327 (2003-02-01), Zondervan et al.
patent: 6631374 (2003-10-01), Klein et al.
patent: 6665815 (2003-12-01), Goldstein et al.
patent: 6799189 (2004-09-01), Huxoll
patent: 2002/0029218 (2002-03-01), Bentley et al.
patent: 2002/0174416 (2002-11-01), Bates et al.
patent: 2002/0178146 (2002-11-01), Akella et al.
patent: 2003/0131025 (2003-07-01), Zondervan et al.
patent: 2003/0149702 (2003-08-01), Saffer et al.
patent: 2004/0010487 (2004-01-01), Prahlad et al.
patent: 2004/0019614 (2004-01-01), Wang
patent: 2005/0086263 (2005-04-01), Ngai et al.
patent: 2005/0131964 (2005-06-01), Saxena
patent: 2005/0144198 (2005-06-01), Bergstraesser et al.
patent: 2006/0101092 (2006-05-01), Ishida et al.

Affiliated with

Also associated with

Rating

Redundant version information in history table that enables... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Redundant version information in history table that enables..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Redundant version information in history table that enables... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2763121