Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-08-22
1999-12-14
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707200, 364578, G06F 1730
Patent
active
060030224
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.
patent: 5724569 (1998-03-01), Andres
IBM Database2 Version 2 SQL Reference Release 2, 1989, Chapter 6, "Statements", pp. 95-246.
IBM Database2 Version 2 SQL Reference Release 2, 1989, Chapter 5, "Queries", pp. 83-94.
IBM Database2 Version 2 Release 1, Appendix C, 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.
Lavenberg, Stephen S., Computer Performance Modeling Handbook, Academics Press, 1983, chapter 3 (p. 94).
BGS Systems, DB2 Support Facility Demo Oct. 1992.
BGS Systems, Crystal Products Demo Jan. 1992.
Duppel, N., "Modeling and Optimization of Complex Database 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 in parent), Dec. 1991.
Eberhard Rainer
Hall Harold
Lakshmi Seetha
Black Thomas G.
Choules Jack M.
International Buisness Machines Corporation
LandOfFree
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.
Profile ID: LFUS-PAI-O-873527