Data processing: software development – installation – and managem – Software program development tool – Testing or debugging
Reexamination Certificate
2000-12-01
2004-08-03
Das, Chameli C. (Department: 2122)
Data processing: software development, installation, and managem
Software program development tool
Testing or debugging
C717S124000, C717S125000, C717S130000, C717S131000, C707S793000, C707S793000, C714S012000
Reexamination Certificate
active
06772411
ABSTRACT:
BACKGROUND OF THE INVENTION
This invention is related in general to digital processing systems and more specifically to a system for monitoring and improving the performance of software such as a database system.
It is important, often vitally so, to improve the performance of software programs. This is particularly true in applications where large and complex software systems experience decreased execution speed, or other inefficiencies, due to lack of resources. Such resources are typically central processing unit (CPU) time, or cycles, and memory space, or other storage capacity.
For example, database systems need to provide fast, accurate, and efficient searching, presentation and other manipulation, of data in databases. An example of a popular database system is the “DB
2
” database engine. A common query language for a DB
2
system is SQL. Such a system is a relational database that allows users to make queries of the database using relational operators such as AND, OR, NOT, etc. Different types of records can be defined and associated with other records. The records can be sorted, or otherwise processed, intermittently. Also, a DB
2
system can be accessed by many simultaneous human users, or automated software processes, either in a parallel or timeshared fashion.
Many levels of complexity exist in database systems. Much of this complexity is due to the sheer size of the database, and to relationships between records and other data structures in the database. The time needed to execute a query, and return the desired results, is due to many factors that include the type of query, the design of the database, the allocation and type of resources, the number of users in a system, the design of the query engine, the design of the query; and other factors. For example, a system typically has a limited amount of random-access memory (RAM). Such memory is of a high-speed and should, ideally, be used to store items that are currently needed by the CPU, which will be needed in the near future, or which will be needed relatively often. However, allocating the right amount of RAM to a database system (e.g., in the form of “buffer pools”) is a complex problem whose solution may change frequently as the processing conditions of the overall system change. Although the problem is complex, it is important to be able to resolve the problem since allocation of resources in the form of buffer pools can greatly improve the performance of a database system.
Another important factor in analyzing the performance of database systems is execution time. Software executing in a database system, such as DB
2
, can include many large applications. Each application, in turn, can include packages, sections and other organizations of SQL text, or statements. It is important for a database administrator to be able to detect which portions of SQL text are consuming an undue amount of resources, such as CPU time, as this might indicate an improperly, or inefficiently, programmed query or database task. There are other factors of importance to database performance such as determining when a task, or query, will end based on system costs, estimated cardinality and delta delivery rates of data.
Thus, it is desirable to provide an effective performance monitoring and management system.
SUMMARY OF THE INVENTION
The present invention allows precise determination of resource use within the database system. One embodiment of the invention allows a user to investigate resource usage by SQL statement. The invention is capable of efficiently identifying unique dynamic SQL statements (i.e., Equalized I.D.).
The invention provides a global view which efficiently presents to a user, or database administrator, resource costs irrespective of other often-provided misleading characteristics such as Connection, Program, AuthID, ApplID. The invention can provide predictions for when a query, or other database task, will end based on selectable parameters such as optimizer cost, estimated cardinality, and delta delivery rates of data. In a preferred embodiment, a user interface is provided whereby a user can create or select event monitors to acquire statistical data on a database task. The results of activating the event monitor are presented to the user such that the user can progressively examine portions of an application, package, section and even individual statements. The user interface allows a user to efficiently and precisely identify processing shortcomings so that the performance of a database task can be improved. The interface also allows a user to sort, or otherwise organize, the statistical data so that analysis of the data is improved.
In one embodiment, the invention provides a method for analyzing the performance of an application in a database system. The method includes steps of accepting first signals from the user input device to select the application; displaying at least a portion of the first-level statement groups; accepting second signals from the user input device to select a first-level statement group; displaying at least a portion of second-level statement groups associated with the first-level statement group; and displaying statistical data on statements within at least one of the second-level statement groups associated with the first-level statement group.
REFERENCES:
patent: 4509119 (1985-04-01), Gumaer et al.
patent: 4845710 (1989-07-01), Nakamura et al.
patent: 5093912 (1992-03-01), Dong et al.
patent: 5412781 (1995-05-01), Lukas et al.
patent: 5432932 (1995-07-01), Chen et al.
patent: 5440692 (1995-08-01), Janicek
patent: 5450586 (1995-09-01), Kuzara et al.
patent: 5475843 (1995-12-01), Halviatti et al.
patent: 5483468 (1996-01-01), Chen et al.
patent: 5506955 (1996-04-01), Chen et al.
patent: 5680573 (1997-10-01), Rubin et al.
patent: 5784698 (1998-07-01), Brady et al.
patent: 5812996 (1998-09-01), Rubin et al.
patent: 5954829 (1999-09-01), McLain, Jr. et al.
patent: 6044477 (2000-03-01), Jordan et al.
patent: 6058393 (2000-05-01), Meier et al.
patent: 6324683 (2001-11-01), Fuh et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 6502102 (2002-12-01), Haswell et al.
patent: 6526044 (2003-02-01), Cookmeyer et al.
Title: Continuous profiling: where have all the cycles gone?, author: Anderson et al, ACM, 1997.*
Title: Performance, preference, and visual scan patterns on a menu□based system: implications for interface design, author: J. J. Hendrickson, ACM, 1989.*
Title: Selectively materializing data in mediators by analyzing user queries, author:Ashish, N.; Knoblock, C.A.; Shahabi, C.; IEEE, 1989.*
Title: High-Level language debugging for concurrent programs, author: Goldszmidt et al, ACM, 1990.*
Title: Reconciling System Requirement s and Runtime Behavior, author: Feather et al, ACM, Apr. 1998.*
“4.0 Chapter 4. Monitoring Your Database,” Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995, 1 page.
“4.1 Choosing Snapshot of Event Monitoring,” Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995, 1 page.
“4.2 Tuning Configuration Parameters,” Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995 2 pages.
“4.2.1 Buffer Pool Size (buffpage), ”Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995, 2 pages.
“NotesBench Disclosure Report for Lotus Notes on OS/2 Warp Server,” Lotus Product Information Database, http://www.groupware.com.au/prodinfo/2736.htm, May 18, 1996, 21 pages.
Chiesa, Dino P., “Configuring Buffer Pool Size,” TRANSARC©, http://www.transarc.com/library/whitepapers/tg
ode51.html, Sep. 5. 1996, 2 pages.
Chiesa, Dino P., “vmstat Example, ” TRANSARC©, http://www.transarc.com/library/whitepapers/tg
ode51.html, Sep. 5, 1996, 3 pages.
Chiesa, Dino P., “iostat Example,” TRANSARC©, http;//www.transarc.com/library/whitepapers/tg
ode51.html, Sep. 5, 1996, 3 pages.
Chiesa, Dino P., “Vender Specific Performance Tools,” TRANSARC
Born Christopher J.
Hayes Scott R.
BMC Software Inc.
Das Chameli C.
Wong, Cabello, Lutsch, Rutherford & Brucculeri L.L.P.
LandOfFree
Software performance and management system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Software performance and management system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Software performance and management system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3344525