Tracking space usage in a database

Details Tracking space usage in a database Tracking space usage in a database

2011-02-22

2011-02-22

Lie, Angela M (Department: 2163)

Data processing: database and file management or data structures

Database design

Database and data structure management

Reexamination Certificate

active

07895247

ABSTRACT:
A method and apparatus for determining the usage of space in a database is provided. A first set of space usage data that reflects the amount of free space associated with one or more tablespaces of a database is stored at a first database server. A second set of space usage data is retrieved from one or more other database servers. The first set of space usage data and the second set of space usage data are both updated based on changes made to the database by the particular database server storing the space usage data. The first set of space usage data is updated at the first database server with the second set of space usage data. The first database server may evaluate the usage of space in the database based on the updated first set of space usage data.

REFERENCES:
patent: 4680859 (1987-07-01), Johnson
patent: 4935750 (1990-06-01), Hawkins
patent: 5435961 (1995-07-01), Micciche
patent: 5450113 (1995-09-01), Childers et al.
patent: 5478700 (1995-12-01), Gaynes et al.
patent: 5515089 (1996-05-01), Herko et al.
patent: 5538586 (1996-07-01), Swanson et al.
patent: 5539153 (1996-07-01), Schwiebert et al.
patent: 5627108 (1997-05-01), Alibocus et al.
patent: 5736998 (1998-04-01), Caren et al.
patent: 5807606 (1998-09-01), Mould et al.
patent: 5905513 (1999-05-01), Brandon et al.
patent: 6035306 (2000-03-01), Lowenthal et al.
patent: 6076912 (2000-06-01), Murthy
patent: 6098257 (2000-08-01), Koido et al.
patent: 6244696 (2001-06-01), Tran et al.
patent: 6267472 (2001-07-01), Maher et al.
patent: 6290340 (2001-09-01), Kitahara et al.
patent: 6328423 (2001-12-01), Wong et al.
patent: 6361152 (2002-03-01), Fujisawa
patent: 6371017 (2002-04-01), Yamazaki et al.
patent: 6386434 (2002-05-01), Wong
patent: 6495199 (2002-12-01), Kaiser et al.
patent: 6508170 (2003-01-01), Katsuoka et al.
patent: 6879995 (2005-04-01), Chinta et al.
patent: 2001/0015744 (2001-08-01), Feinn et al.
patent: 2001/0043252 (2001-11-01), Feder et al.
patent: 2002/0051042 (2002-05-01), Takagi et al.
patent: 2002/0105562 (2002-08-01), Miyagawa et al.
patent: 2002/0128340 (2002-09-01), Young et al.
patent: 2002/0185482 (2002-12-01), Cobb et al.
patent: 2003/0115244 (2003-06-01), Molloy et al.
patent: 2003/0191909 (2003-10-01), Asano et al.
patent: 2004/0019662 (2004-01-01), Viswanath et al.
patent: 2004/0089171 (2004-05-01), Jiang et al.
patent: 2004/0158573 (2004-08-01), Bradley et al.
patent: 2005/0066134 (2005-03-01), Tormasov et al.
patent: 0518574 (1992-12-01), None
patent: WO 03/047217 (2003-06-01), None
International Searching Authority, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Searching Authority , or the Declaration,” PCT/US2004/036122, dated Jan. 5, 2006, 13 pages.
Current Claims, PCT/US2004/036122, dated Jan. 24, 2006, 4 pages.
Oracle Corporation, “Oracle9i—Database Concepts, Release 2 (9.2),” part No. A96524-01, Mar. 2002, XP002360772, 70 pages.
Oracle Corporation, “Oracle9i—Database Performance Tuning Guide and Reference Release 2 (9.2),” Part No. A96533-01, Mar. 2002, XP002360773, 52 pages.
Oracle Corporation, “The Self-Managing Database: Proactive Space & Schema Object Management,” An Oracle White Paper, Nov. 2003, XP002360725, pp. 3-20.
European Patent Office, “Communication Pursuant to Article 96(2) EPC,” App. No. 04796828.4, received Oct. 27, 2006, 3 pages.
Claims, EP App. No. 04796828.4, 3 pages.
International Preliminary Examining Authority, “Notification of Transmittal of the International Preliminary Examination Report,” PCT/US2004/036122, dated Jun. 9, 2006, 7 pages.
Claims, PCT/US2004/036122, 3 pages (attached).

Affiliated with

Also associated with

Rating

Tracking space usage in a database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Tracking space usage in a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Tracking space usage in a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2619167