Database monitoring system

作者: Vivek Narasayya , Arnd Christian Konig , Surajit Chaudhuri

DOI:

关键词:

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

参考文章(13)
Praveen Seshadri, Building Notification Services with Microsoft SQLServer. international conference on management of data. pp. 635- 636 ,(2003)
Daniel P. Miranker, TREAT: a better match algorithm for AI production systems national conference on artificial intelligence. pp. 42- 47 ,(1987)
Mukesh Kumar Mohania, Manish Anand Bhide, Mukul Madhukar Joshi, Ajay Kumar Gupta, Optimal use of triggers for detecting database events ,(2003)
Vivek R. Narasayya, Surajit Chaudhuri, An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server very large data bases. pp. 146- 155 ,(1997)
U. Dayal, B. Blaustein, A. Buchmann, U. Chakravarthy, M. Hsu, R. Ledin, D. McCarthy, A. Rosenthal, S. Sarin, M. J. Carey, M. Livny, R. Jauhari, The HiPAC project: combining active databases and timing constraints international conference on management of data. ,vol. 17, pp. 51- 70 ,(1988) , 10.1145/44203.44208
Gerhard Weikum, Axel Moenkeberg, Christof Hasse, Peter Zabback, Self-tuning Database Technology and Information Services VLDB '02: Proceedings of the 28th International Conference on Very Large Databases. pp. 20- 31 ,(2002) , 10.1016/B978-155860869-6/50011-1
Charles L. Forgy, Rete: a fast algorithm for the many pattern/many object pattern match problem Artificial Intelligence. ,vol. 19, pp. 17- 37 ,(1982) , 10.1016/0004-3702(82)90020-0
Don Carney, Uğur Çetintemel, Mitch Cherniack, Christian Convey, Sangdon Lee, Greg Seidman, Nesime Tatbul, Stan Zdonik, Michael Stonebraker, Monitoring streams: a new class of data management applications very large data bases. pp. 215- 226 ,(2002) , 10.1016/B978-155860869-6/50027-5