Predicting database system performance

Details Predicting database system performance Predicting database system performance

2011-08-30

2011-08-30

Ly, Cheyne D (Department: 2168)

Data processing: structural design, modeling, simulation, and em

Simulating electronic device or electrical system

Software program

C707S705000

Reexamination Certificate

active

08010337

ABSTRACT:
A prediction system may perform capacity planning for one or more resources of a database systems, such as by understanding how different workloads are using the system resources and/or predicting how the performance of the workloads will change when the hardware configuration of the resource is changed and/or when the workload changes. The prediction system may use a detailed, low-level tracing of a live database system running an application workload to monitor the performance of the current database system. In this manner, the current monitoring traces and analysis may be combined with a simulation to predict the workload's performance on a different hardware configuration. More specifically, performance may be indicated as throughput and/or latency, which may be for all transactions, for a particular transaction type, and/or for an individual transaction. Database system performance prediction may include instrumentation and tracing, demand trace extraction, cache simulation, disk scaling, CPU scaling, background activity prediction, throughput analysis, latency analysis, visualization, optimization, and the like.

REFERENCES:
patent: 6035306 (2000-03-01), Lowenthal et al.
patent: 6038391 (2000-03-01), Kawaba
patent: 6145121 (2000-11-01), Levy et al.
patent: 6751583 (2004-06-01), Clarke et al.
patent: 2003/0139918 (2003-07-01), Hardwick et al.
patent: 2004/0148152 (2004-07-01), Horikawa
patent: 2004/0172220 (2004-09-01), Prekeges et al.
patent: 2006/0025985 (2006-02-01), Vinberg et al.
Martin et al., Proceedings of the 30th Annual International Symposium on Computer Architecture (ISCA'03), pp. 1-12, 2003.
Ramirez et al., International Journal of Parallel Programming, vol. 30, No. 5, Oct. 2002 ( © 2002), pp. 373-395, 2002.
Skadron et al., IEEE Transactions on Computers, vol. 48, No. 11, Nov. 1999, pp. 1260-1281.
Uysal et al., D. O'Hallaron (Ed.): LCR'98, LNCS 1511, pp. 243-258, 1998.
Thomasian, A., G. Haring et al. (Eds.): Performance Evaluation, LNCS 1769, pp. 305-327, 2000.
Lo et al., Proceedings of the 25th Annual International Symposium on Computer Architecture, pp. 1-12, Jun. 1998.
Barham, et al.; “Using Magpie for request extraction and workload modeling”; Proc. 6thSymp. On Operating System Design and Implementation; San Francisco, CA; Dec. 2004.
Mattson, et al.; “Evaluation techniques for storage hierarchies”; IBM Systems Journal; vol. 9, No. 2; 1970; pp. 78-117.
Denehy, et al.; “Deconstructing storage arrays”; Proc. Of the Architectural Support for Programming Languages and Operating Systems Conference; Cot. 2004.
Schindler, et al.; “Lachesis: Robust Database Storage Management Based on Device-Specific Performance Characteristics”; Proc. 29thVLDB Conference; Sep. 2003.
Seltzer, et al.; “Disk Scheduling Revisited”; Proc. 1990 USENIX Winter Conference; Sep. 2003.
Anderson, et al.; “Simple Table-Based Modeling of Storage Devices”; Hewlett-Packard Laboratories; 2001; SSP Technical Report HPL-SSP-2001-4.
Wang, et al.; “Storage Device Performance Prediction with Cart Models”; Proc. 12thMeeting of the IEEE/ACM International Symposium on Modeling, Analysis and Simulation of Computer and Telecommunications Systems; Oct. 2004.
Ailamaki et al.; “DBMSs on a modern processor: where does time go?”; Proc. 25thVLDB Conference; Sep. 1999.
Barroso, et al.; “Memory system characterization of commercial workloads”; Proc. 25thInternational Symposium on Computer Architecture; Jun. 1998.
Marin, et al.; “Cross-architecture performance predictions for scientific applications using parameterized models”; Proc. International Conference on Measurements and Modeling of Computer Systems 2004; Jun. 2004.
Rosenblum, et al.; “The impact of architectural trends on operating system performance”; Proc. 15thACM Symposium on Operating Systems Principles; Dec. 1995.

Affiliated with

Also associated with

Rating

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

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2770187