Database performance baselines

Details Database performance baselines Database performance baselines

2004-09-03

2010-02-16

Jalil, Neveen Abel (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C712S001000, C709S217000, C709S223000, C709S238000, C709S201000

Reexamination Certificate

active

07664798

ABSTRACT:
Systems and methods to define and store performance baselines. A baseline may be defined as a pair of snapshots, each snapshot containing the same set of statistics and having a timestamp value associated therewith. The present invention allows for the designation, automatically or manually, of statistics collected over a certain period of time to be stored and used for comparison. Baselines may be used, for example, to manually or automatically compare with current system performance, compare difference-difference values and set thresholds to monitor current system performance.

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), Amalifitano 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), Chaudhuri 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), Chaudhuri 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), Kaler 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/0178416 (2002-11-01), Chen 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: 55091036 (1980-07-01), None
patent: 02-232795 (1990-09-01), None
patent: WO 02/06949 (2002-01-01), None
patent: WO 02/37061 (2002-03-01), None
Chaudhuri, Surajit “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 R/3—,” ACM, 1997, pp. 123-134.
Hagmann et al. “Performance Analysis of Several Back-End Database Architectures,” ACM, 1986, vol. 11, No. 1, pp. 1-26.
IBM Technical Disclosure Bulletin, “Software Monitor for Performance Tuning a Virtual Memory Computer System,” 1973, vol. 15, Issue No. 12. pp. 3730-3733.
Lightsone et al. “Toward Autonomic Computing with DB2 Universal Database,” Sigmod Record, 2002, vol. 31, No. 3, pp. 55-61.
Lightstone et al. “Autonomic Computing for Relational Databases: The Ten-Year Vision,” IEEE, 2003, pp. 419-424.
Lohman et al “Smart: Making DB2 (More) Autonomic,” Proceedings of the 28thVLDB Conference, Hong Kong, China, 2002, 3 pages.
Ryu et al. “Analysis of Database Performance with Dynamic Locking,” Journal of the Associates for Computing Machinery, 1990, vol. 37, No. 3, pp. 491-523.
Stonebraker, Michael et al. “Performance Enhancements to a Relational Database System,” ACM Transactions on Database Systems, 1983, vol. 8, No. 2, pp. 167-185.

Affiliated with

Also associated with

Rating

Database performance baselines does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database performance baselines, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database performance baselines will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4221671