Database execution cost and system performance estimator

Details Database execution cost and system performance estimator Database execution cost and system performance estimator

1994-06-24

1998-05-26

Black, Thomas G.

395616, G06F 1730

Patent

active

057581444

ABSTRACT:
The software tool of this invention estimates the costs of an application program accessing a database. These costs may be execution costs of the application or of a transaction, SQL statement, and/or a utility. Execution costs include CPU time, I/O time and minimum elapsed time. For estimating the execution costs, the tool receives simplified and partial definitions of tables, utilities, SQL statements, transactions, and applications. The estimator tool requires only a minimal amount of information to calculate the various execution costs.

REFERENCES:
patent: 4829427 (1989-05-01), Green
patent: 4956774 (1990-09-01), Shibamiya et al.
patent: 5043872 (1991-08-01), Cheng et al.
patent: 5091852 (1992-02-01), Tsuchida et al.
patent: 5301317 (1994-04-01), Lohman et al.
patent: 5325525 (1994-06-01), Shan et al.
patent: 5412806 (1995-05-01), Du et al.
Duppel, N., "Modeling and Optimization of Complex Queries in a Shared-Nothing System", IEEE, pp. 52-59, Jan. 1991.
"Crystal Product Family Demonstration", BGS Systems, Inc. (printout of a slide show provided by the applicant with PTO 1949) Dec. 1491.
IBM Database 2 Version 2 SOl Reference Release 2, 1989, Chapter 6, "Statements", pp. 95-246.
IBM Database2 Version 2 SOL Reference Release 2, 1989, Chapter 5, "Queries", pp. 83-94.
Appendix C of IBM Database2 Version 2 Release 1, Application Programming Guide, 1988.
IBM Database2 Version 2 Administration Guide vol. 1, Release 2, Sep. 1989, pp. 2-24 to 2-28.
"DB2 Cost Formula", Shibamiya, A., Yeung, M.Y., IBM Technical Disclosure Bulletin, vol. 34, No. 12, May 1992, pp. 389-394.
Computer Performance Modeling Handbook, Lavenberg, Stephen S., Academics Press, 1983, chapter 3 (p. 94).
BGS Systems, DB2 Support Facility Demo Oct. 1992.
BGS Systems, Crystal Products Demo Jan. 1992.

Affiliated with

Also associated with

Rating

Database execution cost and system performance estimator 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 execution cost and system performance estimator, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database execution cost and system performance estimator will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1976350