Automatic tuning of undo retention

Details Automatic tuning of undo retention Automatic tuning of undo retention

2004-05-13

2009-08-11

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07574419

ABSTRACT:
A method and apparatus for data recovery are disclosed. A plurality of queries executing in a database system are tracked. A query with a longest duration is selected and undo retention duration is calculated for supporting the longest query.

REFERENCES:
patent: 5907848 (1999-05-01), Zaiken et al.
patent: 6574717 (2003-06-01), Ngai et al.
patent: 6587847 (2003-07-01), Stier et al.
patent: 6694340 (2004-02-01), Lyle et al.
patent: 6976022 (2005-12-01), Vemuri et al.
patent: 6981004 (2005-12-01), Ganesh et al.
patent: 7047386 (2006-05-01), Ngai et al.
patent: 7110998 (2006-09-01), Bhandari et al.
patent: 7127456 (2006-10-01), Brown et al.
patent: 2004/0054643 (2004-03-01), Vemuri et al.
patent: 2004/0054644 (2004-03-01), Ganesh et al.
patent: 2005/0015563 (2005-01-01), Yang 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.
patent: 2005/0125430 (2005-06-01), Souder et al.
patent: 2005/0240633 (2005-10-01), Krishnaswamy et al.
patent: 2005/0256829 (2005-11-01), Yang et al.
patent: 2007/0083488 (2007-04-01), Krishnaswamy
patent: 2007/0083566 (2007-04-01), Krishnaswamy et al.
Burke, M. “An Interval-Based Approach to Exhaustive and Incremental Interprocedural Data-Flow Analysis” ACM Transactions on Programming Languages and Systems, Jul. 1990, vol. 12, No. 3, pp. 341-395.
Chin, R.S. et al. “Distributed Object-Based Programming Systems” ACM Computing Surveys, Mar. 1991, vol. 23, No. 1, pp. 91-124.
Chiueh, T. et al. “Zodiac: A History-Based Interactive Video Authoring System” Proceedings of the 6th ACM International Conference on Multimedia (Multimedia '98), Bristol, UK, Sep. 1998, pp. 435-443.
Hudson, S.E. et al. “Object-Oriented Database Support for Software Environments” Proceedings of the 1987 ACM SIGMOD International Conference on Management of Data (SIGMOD '87), San Francisco, CA, May 27-29, 1987, vol. 16, No. 3, pp. 491-503.
Kunz, T. et al. “Fast Detection of Communication Patterns in Distributed Executions” Proceedings of the 1997 Conference of the Centre for Advanced Studies on Collaborative Research, Nov. 1997, pp. 1-13.
Leehane, T. “Level II Technical Support in a Distributed Computing Environment” Proceedings of the 24th Annual ACM SIGUCCS Conference on User Services, Sep. 1996, pp. 95-99.
Lomet, D.B. “MLR: A Recovery Method for Multi-level Systems” Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data (SIGMOD '92), San Diego, CA, Jun. 2-5, 1992, vol. 21, No. 2, pp. 185-194.
Randell, B. et al. “Reliability Issues in Computing System Design” ACM Computing Surveys, Jun. 1978, vol. 10, No. 2, pp. 123-165.
Santry, D.S et al. “Deciding when to forget in the Elephant file system” Proceedings of the 17th ACM Symposium on Operating Systems Principles (SOSP '99), Kiawah Island, SC, Dec. 1999, vol. 33, No. 5, pp. 110-123.
Soares, P.G. “On Remote Procedure Call” Proceedings of the 1992 Conference of the Centre for Advanced Studies on Collaborative Research, Nov. 1992, vol. 2, pp. 215-267.
Thatte, S.M. “Persistent Memory: A Storage Architecture for Object-Oriented Database Systems” Proceedings on the 1986 International Workshop on Object-Oriented Database Systems, Sep. 1986, pp. 148-159.

Affiliated with

Also associated with

Rating

Automatic tuning of undo retention does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Automatic tuning of undo retention, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automatic tuning of undo retention will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4129751