Data processing: database and file management or data structures – File or database maintenance – Database recovery
Reexamination Certificate
2011-05-10
2011-05-10
Padmanabhan, Kavita (Department: 2161)
Data processing: database and file management or data structures
File or database maintenance
Database recovery
Reexamination Certificate
active
07941408
ABSTRACT:
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. Also disclosed are algorithms, mechanisms, and processes that are employed 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 process for determining one or more life intervals when given a key.
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, vo. 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 Jan. 18, 2007 for U.S. Appl. No. 10/933,832.
Office Action dated Nov. 7, 2007 for U.S. Appl. No. 10/933,832.
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 Jan. 29, 2008 for U.S. Appl. No. 10/933,832.
Office Action dated May 14, 2008 for U.S. Appl. No. 10/933,832.
Office Action dated Nov. 18, 2008 for U.S. Appl. No. 10/933,832.
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 21, 2009 for U.S. Appl. No. 10/933,832.
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/933,832.
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 Nov. 18, 2010 for U.S. Appl. No. 10/933,832.
Notice of Allowance dated Mar. 4, 2011 for U.S. Appl. No. 10/933,828.
Ganesh Amit
Jacobs Kenneth R.
Raja Vivekanandhan
Sinha Bipul
Oracle International Corporation
Padmanabhan Kavita
Vista IP Law Group LLP.
LandOfFree
System, structure, interface, and semantics for implementing... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System, structure, interface, and semantics for implementing..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System, structure, interface, and semantics for implementing... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2701966