Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-09-03
2009-10-13
Cottingham, John R. (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
07603340
ABSTRACT:
A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.
REFERENCES:
patent: 2883255 (1959-04-01), Anderson
patent: 3324458 (1967-06-01), MacArthur
patent: 3344408 (1967-09-01), Singer et al.
patent: 3351910 (1967-11-01), Miller et al.
patent: 4654806 (1987-03-01), Poyser et al.
patent: 4849879 (1989-07-01), Chinnaswamy et al.
patent: 4994986 (1991-02-01), Cihiwsky et al.
patent: 5303166 (1994-04-01), Amalfitano et al.
patent: 5349662 (1994-09-01), Johnson et al.
patent: 5488648 (1996-01-01), Womble
patent: 5729736 (1998-03-01), Gomi et al.
patent: 5734884 (1998-03-01), Eberhard et al.
patent: 5778350 (1998-07-01), Adams et al.
patent: 5781703 (1998-07-01), Desai et al.
patent: 5796633 (1998-08-01), Burgess et al.
patent: 5872976 (1999-02-01), Yee et al.
patent: 5905868 (1999-05-01), Baghai et al.
patent: 5960423 (1999-09-01), Chadhuri et al.
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6029163 (2000-02-01), Ziauddin
patent: 6035306 (2000-03-01), Lowenthal et al.
patent: 6052694 (2000-04-01), Bromberg
patent: 6223171 (2001-04-01), Chadhuri et al.
patent: 6282570 (2001-08-01), Leung et al.
patent: 6311175 (2001-10-01), Adriaans et al.
patent: 6363282 (2002-03-01), Nichols et al.
patent: 6389430 (2002-05-01), Parker
patent: 6434714 (2002-08-01), Lewis et al.
patent: 6467052 (2002-10-01), Kaler et al.
patent: 6510419 (2003-01-01), Gatto
patent: 6553369 (2003-04-01), Guay et al.
patent: 6615222 (2003-09-01), Hornibrook et al.
patent: 6665815 (2003-12-01), Goldstein et al.
patent: 6671830 (2003-12-01), Lowell et al.
patent: 6691254 (2004-02-01), Kaler et al.
patent: 6766318 (2004-07-01), Guay et al.
patent: 6775676 (2004-08-01), Briam et al.
patent: 6792460 (2004-09-01), Oulu et al.
patent: 6801903 (2004-10-01), Brown et al.
patent: 6804627 (2004-10-01), Marokhovsky et al.
patent: 6901582 (2005-05-01), Harrison
patent: 6952692 (2005-10-01), Bhattiprolu et al.
patent: 6954717 (2005-10-01), Boldt et al.
patent: 6955302 (2005-10-01), Erdman, Jr.
patent: 6983257 (2006-01-01), Gatto
patent: 7051013 (2006-05-01), Horman et al.
patent: 7085786 (2006-08-01), Carlson et al.
patent: 7089347 (2006-08-01), Mogi et al.
patent: 7093169 (2006-08-01), Merriam
patent: 7139749 (2006-11-01), Bossman et al.
patent: 7292961 (2007-11-01), Dias et al.
patent: 7376682 (2008-05-01), Ramacher et al.
patent: 2002/0065833 (2002-05-01), Litvin
patent: 2002/0087587 (2002-07-01), Vos et al.
patent: 2002/0091708 (2002-07-01), Vos et al.
patent: 2002/0173997 (2002-11-01), Menard et al.
patent: 2002/0178146 (2002-11-01), Akella et al.
patent: 2003/0120620 (2003-06-01), Fromherz et al.
patent: 2004/0044500 (2004-03-01), Lu
patent: 2004/0044700 (2004-03-01), Fisher et al.
patent: 2004/0059704 (2004-03-01), Hellerstein et al.
patent: 2004/0064544 (2004-04-01), Barsness et al.
patent: 2004/0098265 (2004-05-01), Kelly et al.
patent: 2005/0055673 (2005-03-01), Dias et al.
patent: 2005/0086195 (2005-04-01), Tan et al.
patent: 2005/0086246 (2005-04-01), Wood et al.
patent: 2005/0086263 (2005-04-01), Ngai et al.
patent: 2005/0103874 (2005-05-01), Erdman, Jr.
patent: 2005/0278381 (2005-12-01), Diao et al.
patent: 2006/0218450 (2006-09-01), Malik et al.
patent: 2007/0022192 (2007-01-01), Nguyen et al.
patent: 55-091036 (1980-07-01), None
patent: 02-232795 (1990-09-01), None
patent: WO 02/06949 (2002-01-01), None
patent: WO 02/37061 (2002-05-01), None
Chadhuri et al., “Self Managing DBMS Technology at Microsoft,” Microsoft Research, Sep. 1, 2004, 35 pages.
Doppelhammer et al., “Database performance in the Real World: TPC-D and SAP RI3,” 1997, ACM, p. 123-124.
Hagmann et al., “Performance Analysis of Several Back-End Database Architectures,” ACM Transactions on Database Systems, Mar. 1986, p. 1-26, vol. 11, No. 1, ACM.
Lightstone et al., “Autonomic Computing for Relational Databases: The Ten-Year Vision,” IEEE, Aug. 2003, pp. 419-424.
Lightstone, S.S. et al., “Toward Autonomic Computing With DB2 Universal Database,” SIGMOND Record, Sep. 2002, vol. 31, No. 3, pp. 55-61.
Lohman, G.M. et al., “SMART: Making DB2 (More) Autonomic,” Proceedings of the 28th VLDB Conference, Hong Kong, China, 2002, 3 pages.
Ryu et al., “Analysis of Database Performance with Dynamic Locking,” Journal of the Association for Computing Machinery, Jul. 3, 1990, p. 491-523, vol. 37, No. 3, ACM.
Stonebraker et al., “Performance Enhancements to a Relational Database System,” ACM Transactions on Database Systems, Jun. 2, 1983, p. 167-185, vol. 8, No. 2, ACM.
International Search Report mailed on Jan. 4, 2005, for PCT Application No. PCT/US04/29069, filed on Sep. 3, 2004, 1 page.
“Software Monitor for Performance Tuning a Virtual Memory Computer System”, IBM Technical Disclosure Bulletin, May 1973, vol. 15, Issue 12, p. 3730-3733, IBM.
Dageville Benoit
Dias Karl
Feng Michael
Green Connie
Ngai Gary
Cottingham John R.
Oracle International Corporation
Pham Michael
Townsend and Townsend / and Crew LLP
LandOfFree
Automatic workload repository battery of performance statistics 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 workload repository battery of performance statistics, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automatic workload repository battery of performance statistics will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4112749