Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-11-24
2000-03-07
Lintz, Paul R.
Data processing: database and file management or data structures
Database design
Data structure types
39520031, 39520049, 39520054, 39520068, 395675, 707 2, 707 3, 707 4, 707 10, 707104, 707200, 707201, G06F 1730
Patent
active
060353066
ABSTRACT:
The present invention provides a tool with which a DBA can analyze a VLDB at all levels of data storage, both logical and physical, to analyze performance problems. The invention is particularly applicable to systems in which database files are striped over multiple disk drives. In the present invention, storage of information is monitored at three levels: database files, file system files, and individual disk drives Parameters indicating the activity and performance level of each of the levels of storage are taken at selected intervals and stored. An analysis tool is provided that allows a DBA to select a time window during which the database performance is be assessed. The analysis tool has a map of the logical and physical arrangement of the database being monitored and allows a DBA to move from level to level of both logical and physical structures involved in storing the data while displaying I/O activity in an easily understood manner.
REFERENCES:
patent: 4849879 (1989-07-01), Chinnaswamy et al.
patent: 5086386 (1992-02-01), Islam
patent: 5245638 (1993-09-01), Gustafson
patent: 5303166 (1994-04-01), Amalfitano et al.
patent: 5337258 (1994-08-01), Dennis
patent: 5347647 (1994-09-01), Allt et al.
patent: 5544313 (1996-08-01), Shachnai et al.
patent: 5617567 (1997-04-01), Doktor
patent: 5768500 (1998-06-01), Agrawal et al.
patent: 5794229 (1998-08-01), French et al.
"OS/2 Database manager Database Event Monitor," IBM Technical Disclosure Bulletin, vol. 34, No. 4A, Sep. 1, 1991, New York, USA. pp. 150-151.
"Table Activity/Reor Indicator for the OS/2 Database Manager," IBM technical Disclosure Bulletin, vol. 34, No. 10A, Mar. 1992, New York, USA, pp. 163-164.
Bennett, Robert "Jovian: A Framework for Optimizing parallel I/O", Proceedings of the 1994 Scalable Parallel Libraries Conference, 1994., Oct. 12-14, 1994, pp. 10-20.
Chen, P. M., "Storage performance-metrics and benchmarks", Proceedings of the IEEE, Aug. 1993, vol. 81, Issue: 8, pp. 1151-1165.
Hall, J. E., "Performance evaluations of a parallel, scalable and expandable database computer", Proceedings of the Twenty-Fourth Annual Hawaii International Conference on System Sciences, 1991., Jan. 8-11, 1991, vol. 1, pp. 85-97.
Hall, J. E., "The Multibackend Database System (MDBS): A Performance Study", International Conference on Databases, Parallel Architectures and Their Applications, PARBASE-90, Mar. 7-9, 1990 pp. 139-143.
Keane, J.A., "Benchmarking Financial Database Queries on a Parallel Machine", Proceedings of the Twenty-Eight Hawaii International Conference on System Sciences, 1995. vol. III, Jan. 3-6, 1995., pp. 402-411.
Seng, Jia-Lang, "Comparing object-oriented database systems benchmark methods", Proceedings of the Thirty-First Hawaii International Conference on System Science, 1998., vol. 6., Jan. 6-9, 1998, pp. 455-463.
Suh, Byung-Hoon, "Development of a benchmark to measure system robustness: experiences and lessons learned", Proceedings of the Third International Symposium on Software Reliability Engineering, 1992, Oct. 7-10, 1992, pp. 237-245.
Thakkar, S.S., "Performance of an OLTP application on Symmetry Multiprocessor system", Proceedings of the 17th Annual International Symposium on Computer Architecture, 1990, May 28-31, 1990, pp. 228-238.
Farnham Mark W.
Lowenthal Sheldon
Sharpe Gary E.
Alam Shahid
Lintz Paul R.
Terascape Software Inc.
LandOfFree
Method for improving performance of large 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 Method for improving performance of large databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for improving performance of large databases will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-372519