Method and mechanism for row versioning

Details Method and mechanism for row versioning Method and mechanism for row versioning

2004-09-03

2011-10-04

Mofiz, Apu (Department: 2161)

Data processing: database and file management or data structures

File or database maintenance

Database recovery

C707S695000

Reexamination Certificate

active

08032496

ABSTRACT:
Disclosed are algorithms, mechanisms, processes, mechanisms, and systems to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions.

REFERENCES:
patent: 5347653 (1994-09-01), Flynn et al.
patent: 5504879 (1996-04-01), Eisenberg et al.
patent: 5613113 (1997-03-01), Goldring
patent: 5701457 (1997-12-01), Fujiwara
patent: 5890166 (1999-03-01), Eisenberg et al.
patent: 5950210 (1999-09-01), Nelson
patent: 6125371 (2000-09-01), Bohannon et al.
patent: 6671689 (2003-12-01), Papierniak
patent: 6754657 (2004-06-01), Lomet
patent: 6882994 (2005-04-01), Yoshimura et al.
patent: 7225208 (2007-05-01), Midgley et al.
patent: 7233947 (2007-06-01), Lomet
patent: 7334004 (2008-02-01), Ganesh et al.
patent: 2002/0007363 (2002-01-01), Vaitzblit
patent: 2003/0154191 (2003-08-01), Fish et al.
patent: 2004/0030954 (2004-02-01), Loaiza et al.
patent: 2004/0088334 (2004-05-01), Klein
patent: 2005/0086195 (2005-04-01), Tan et al.
patent: 2005/0114409 (2005-05-01), Sinha et al.
patent: 2005/0120062 (2005-06-01), Sinha et al.
patent: 2005/0120064 (2005-06-01), Sinha et al.
Bolour, A. et al. “The Role of Time in Information Processing: A Survey” ACM SIGMOD Record, Apr. 1982, vol. 12, No. 3, pp. 27-50.
Bolour, A. et al. “The Role of Time in Information Processing: A Survey” ACM SIGART Bulletin, Apr. 1982, Issue 80, pp. 28-46.
Clifford, J. “Natural Language Querying of Historical Databases” Computational Linguistics, Dec. 1988, vol. 14, No. 4, pp. 10-34.
Derthick, M. et al. “Data Exploration across Temporal Contexts” Proceedings of the 5th International Conference on Intelligent User Interfaces, New Orleans, LA, 2000, pp. 60-67.
Lahiri, T. et al. “Fast-Start: Quick Fault Recovery in Oracle” Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data (SIGMOD '01), Santa Barbara, CA, May 21-24, 2001, pp. 593-598.
Mohan, C. et al. “ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Along Logging” ACM Transactions on Database Systems (TODS), Mar. 1992, vol. 17, No. 1, pp. 94-162.
Nakayama, K. et al. “I-Regular Expression: Regular Expression with Continuous Interval Constraints” Conference on Information and Knowledge Management (CIKM 97), La Vegas, NV, 1997, pp. 40-50.
Office Action dated Feb. 12, 2007 for U.S. Appl. No. 10/934,079.
Office Action dated Sep. 25, 2007 for U.S. Appl. No. 10/934,079.
Office Action dated Jan. 29, 2007 for U.S. Appl. No. 10/933,828.
Office Action dated Sep. 25, 2007 for U.S. Appl. No. 10/933,828.
Office Action dated May 15, 2008 for U.S. Appl. No. 10/934,079.
Office Action dated Nov. 4, 2008 for U.S. Appl. No. 10/934,079.
Office Action dated Oct. 16, 2008 for U.S. Appl. No. 10/933,828.
Office Action dated May 28, 2009 for U.S. Appl. No. 10/933,828.
Office Action dated May 13, 2009 for U.S. Appl. No. 10/934,079.
Varman et al., “Optimal Storage and Access to Multiversion Data”, Proc. ICCI'94, 1994, pp. 1605-1620.
Non-Final Office Action dated Dec. 16, 2009 for U.S. Appl. No. 10/934,079.
Non-Final Office Action dated Dec. 16, 2009 for U.S. Appl. No. 10/933,828.
Final Office Action dated Jul. 27, 2010 for U.S. Appl. No. 10/933,828.
Final Office Action dated Jul. 27, 2010 for U.S. Appl. No. 10/934,079.
Notice of Allowance dated Dec. 29, 2010 for U.S. Appl. No. 10/934,079.
Notice of Allowance dated Mar. 4, 2011 for U.S. Appl. No. 10/933,828.

Affiliated with

Also associated with

Rating

Method and mechanism for row versioning does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and mechanism for row versioning, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and mechanism for row versioning will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4278140