Workload analysis tool for relational databases

Details Workload analysis tool for relational databases Workload analysis tool for relational databases

2007-10-09

2007-10-09

Gaffin, Jeffrey (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10161397

ABSTRACT:
A method for providing workload information in a structured workload information data structure format that is organized according to a workload schema to be conducive to a given end usage of the information. The structured workload information can be made accessible using standard database analytical server applications to facilitate ad-hoc querying of the structured workload information to summarize and analyze the database workload or to facilitate exchange of workload information. A structured workload information (SWI) is constructed according to a SWI schema to facilitate a desired end usage of the workload information. The query information is extracted from the workload and stored in a structured workload information (SWI) data structure according to the schema based on the desired end usage of the information such as ad hoc querying or information exchange. The query information may be stored in a relational database having query information organized as a central fact table and a collection of hierarchical dimension tables or as an OLAP cube featuring hierarchical dimensions that arrange the query information in dimensions having objects ordered as a function of granularity or the information may be stored according to an XML schema wherein units of query information are separated by XML tags that identify a type of workload information.

REFERENCES:
patent: 5960423 (1999-09-01), Chaudhuri et al.
patent: 6598038 (2003-07-01), Guay et al.
patent: 6601062 (2003-07-01), Deshpande et al.
patent: 2001/0037345 (2001-11-01), Kiernan et al.
patent: 2003/0065648 (2003-04-01), Driesch et al.
Gunderloy, M., “Precise/Indepth for SQL Server”, Aug. 2002, Redmondmag.com.
Woodie, A., “Centerfield Addresses DASD Spikes at Protective Shell”, May 28, 2002, vol. 2, No. 20, OS/400 Edition, Midrange Stuff.
Arbi, Z., “BMC's ‘PATROL’good for your applications”, Jun. 5, 2000, Jakarta Post 9.
“CA's New Unicenter Database Management Solutions Greatly Simplify Management of Enterprise-Wide Database Environments”, 2002, PR Newswire, Computer Associates International,.
“The Paradyn Parallel Performance Measurement Tool”, Barton P. Miller, Mark D. Callaghan, Jonathan M. Cargille, et al., University of Wisconsin, Madison, Nov. 1995, pp. 37-46, from IEEE.
Data Management, Exploration & Mining, “AutoAdmin: Self-Tuning and Self-Administering Databases”, Sanjay Agrawal, et al.
“DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes”, Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy Lohman and Alan Skelley, IEEE, pp. 101-110, copyright 2000.

Affiliated with

Also associated with

Rating

Workload analysis tool for relational databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Workload analysis tool for relational databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Workload analysis tool for relational databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3838820