Database monitoring system

Details Database monitoring system Database monitoring system

2007-03-20

2007-03-20

LeRoux, Etienne P. (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

10788077

ABSTRACT:
A framework is provided within a database system for specifying database monitoring rules that will be evaluated as part of the execution code path of database events being monitored. The occurrence of a selected database event triggers a rule that evaluates some parameter of an object related to the event against a condition in the rule. If the condition is met, a specified action is taken that can alter the execution of the database event or database system performance. Lightweight aggregation tables are utilized to enable aggregation of object parameter values so that presently occurring events can be compared to a summary of the object parameter values from previously occurring database events. Signatures are assigned to queries based on the structure of the query plan so that information in the lightweight aggregation tables can be grouped according to query signature.

REFERENCES:
patent: 5819288 (1998-10-01), De Bonet
patent: 2003/0028631 (2003-02-01), Rhodes
patent: 2005/0125371 (2005-06-01), Bhide et al.
U. Dayal et al, The HiPAC project: combining active databases and timing constraints, 1988, ACM SIGMOD Record, vol. 17, Issue 1, (Mar. 1988) pp. 51-70.
Carney D., Cetintemel U., Chemiack M., Convey C., Lee S., Seidman G., Stonebraker M., Tatbul N., Zdonik S. Monitoring Streams—A new class of Data Management Application., Proceedings of the VLDB 2002.
C. Forgy. RETE: A fast algorithm for the many patterns/many objects problem. Artificial Intelligence. 19(1): 17-37, 1982.
Chaudhuri S., Narasayya V. An Efficient, Cost-driven Index Selection Tool for Microsoft SQL Server. Proc. of VLDB 1997.
Dobra A., Garofalakis M., Gehrke J., Rastogi R. Processing Complex Aggregate Queries over Data Streams. Proc. of SIGMOD 2002.
“The HiPAC Project: Combining Active Databases and Timing Constraints” by U. Dayal, B. Blaustein, A. Buchman, U. Chakravarthy, M. Hsu, R. Ledin, D. McVarthy, A. Rosenthal, S. Sarin, M.J. Carey, M. Livny and R. Jauhari published in SIGMOD Record, vol. 17, No. 1, Mar. 1988.
IBM DB2 Universal Database: System Monitor Guide and Reference. ftp://ftp.software.ibm.com/ps/products/db2/info/vr8/pdf/letter/db2f0e80.pdf.
Goldstein J., Larson P. Optimizing Queries Using Materialized Views: A Practical, Scalable Solution. Proc. of SIGMOD 2001.
Lohman G., Lightstone S. SMART: Making DB2 (More) Autonomic. Proc. of VLDB 2002.
Madden S., Shah M., Hellerstein J., Raman V. Continuously Adaptive Continuous Queries over Streams. Proc. of SIGMOD 2002.
D.P. Miranker. TREAT: A Better Match Algorithm for AI Production Systems. Proceedings of the National Conference on AI, 42-47, Aug. 1987.
Praveen Seshadri: Building Notification Services with Microsoft SQLServer—abstract, and SQL Server Notification Services—presentation. SIGMOD Conference 2003.
Weikum G., Moenkeberg A., Hasse C., Zabback P. Self- tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering. Proc. of VLDB 2002.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3791885