Abstract
Condition monitoring typically has a high processing overhead and can thus disrupt the processing of business transactions by the monitored systems. Time-tabled condition monitoring aims to overcome this disadvantage by allowing the system owners to specify the times at which condition monitoring may take place, and the times when the system is too busy with revenue generating (or otherwise mission critical) processing. Unfortunately, however, when this approach is applied to a distributed system, the complex interactions between the component sites during monitoring mean that some interference with normal business processing does occur. In this paper, we present five methods for reducing this interference at the expense of the accuracy of the results of condition monitoring. We describe the outcome of an experimental evaluation that has helped us to characterise each method in terms of its effect on disruption and accuracy. We conclude by presenting heuristics to help in choosing which method to adopt in a given situation.
Chapter PDF
References
R. Barquin, and H. Edelstein. Building, Using, and Managing the Data Warehouse. Prentice Hall, 1997.
Philip A. Bernstein, Barbara T. Blaustein, and Edmund M. Clarke. Fast maintenance of semantic integrity assertions using redundant aggregate data. In Sixth International Conference on Very Large Data Bases, October 1–3, 1980, Montreal, Quebec, Canada, Proceedings, pages 126–136. IEEE Computer Society, 1980.
Stephanie J. Cammarata, Prasadram Ramachandra, and Darrell Shane. Extendeing a relational database with deferred referential integrity checking and intelligent joins. In James Clifford, Bruce G. Lindsay, and David Maier, editors, Proceedings of the 1989 ACM SIGMOD International Conference on Management of Data, Portland, Oregon, May 31–June 2, 1989, pages 88–97. ACM Press, 1989.
Stefano Ceri and Jennifer Widom. Deriving production rules for constraint maintainance. In Dennis McLeod, Ron Sacks-Davis, and Hans-Jorg Schek, editors, 16th International Conference on Very Large Data Bases, August 13–16, 1990, Brisbane, Queensland, Australia, Proceedings, pages 566–577. Morgan Kaufmann, 1990.
Surajit Chaudhuri, Ravi Krishnamurthy, Spyros Potamianos, and Kyuseok Shim. Optimizing queries with materialized views. In Philip S. Yu and Arbee L. P. Chen, editors, Proceedings of the Eleventh International Conference on Data Engineering, March 6–10, 1995, Taipei, Taiwan, pages 190–200. IEEE Computer Society, 1995.
Latha S. Colby, Timothy Griffin, Leonid Libkin, Inderpal Singh Mumick, and Howard Trickey. Algorithms for deferred view maintenance. In H. V. Jagadish and Inderpal Singh Mumick, editors, Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, Montreal, Quebec, Canada, June 4–6, 1996, pages 469–480. ACM Press, 1996.
Armin B. Cremers and G. Doman. Aim — an integrity monitor for the database system ingres. In Mario Schkolnick and Costantino Thanos, editors, 9th International Conference on Very Large Data Bases, October 31–November 2, 1983, Florence, Italy, Proceedings, pages 167–170. Morgan Kaufmann, 1983.
Stefan Grufman, Fredrik Samson, Suzanne M. Embury, Peter M. D. Gray, and Tore Risch Distributing semantic constraints between heterogeneous databases. In Alex Gray and Per-Åke Larson, editors, Proceedings of the Thirteenth International Conference on Data Engineering, April 7–11, 1997 Birmingham U.K., pages 33–42. IEEE Computer Society, 1997.
Ashish Gupta. Partial Information Based Integrity Constraint Checking, PhD. Thesis. Stanford University, USA, 1994.
Ashish Gupta and Jennifer Widom. Local verification of global integrity constraints in distributed databases. In Peter Buneman and Sushil Jajodia, editors, Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, Washington, D.C., May 26–28, 1993, pages 49–58. ACM Press, 1993.
Binling Jin and Suzanne M. Embury. Non-intrusive assessment of organisational data quality. In E.M. Pierce and R. Katz-Haas, editors, The 6th International Conference on Information Quality (IQ-2002), Cambridge, MA, USA, November 2001, pages 398–411, 2001.
Binling Jin and Suzanne M. Embury. Increasing the accuracy of time-tabled condition monitoring. In Integrity and Internal Control in Information Systems V, IFIP TC11/WG11.5 Fifth Working Conference on Integrity and Internal Control in Information Systems (IICIS), November 11–12, 2002, Bonn, Germany, volume 251 of IFIP Conference Proceedings, pages 21–35. Kluwer, 2003.
Subhasish Mazumdar. Optimizing distributed integrity constraints. In Song C. Moon and Hideto Ikeda, editors, Proceedings of the 3rd International Conference on Database Systems for Advanced Applications (DASFAA), Daejeon, Korea, April 6–8, 1993, volume 4 of Advanced Database Research and Development Series, pages 327–334. World Scientific, 1993.
Jean-Marie Nicolas. Logic for improving integrity checking in relational databases. Acta Informatica, 18(3):227–253, 1982.
Xiaolei Qian. Distribution design of integrity constraints. In Larry Kerschberg, editor, Expert Database Systems, Proceedings From the Second International Conference, Vienna, Virginia, USA, April 25–27, 1988, pages 205–226. Benjamin Cummings, 1989.
Xiaolei Qian and Gio Wiederhold. Incremental recomputation of active relational bdexpressions. IEEE Transactions on Knowledge and Date Engineering, 3(3):337–341, September 1991.
Eric Simon and Patrick Valduriez. Design and implementation of an extendible integrity subsystem. In Beatrice Yormark, editor, SIGMOD’84, Proceedings of Annual Meeting, Boston, Massachusetts, June 18–21, 1984, pages 9–17. ACM Press, 1984
Divesh Srivastava, Shaul Dar, H. V. Jagadish, and Alon Y. Levy. Answering queries with aggregation using views. In T. M. Vijayaraman, Alejandro P. Buchmann, C. Mohan, and Nandlal L. Sarda, editors, VLDB’96, Proceedings of 22th International Conference on Very Large Data Bases, September 3–6 1996, Mumbai (Bombay), India, pages 318–329. Morgan Kaufmann, 1996.
Michael Stonebraker. Implementation of integrity constraints and views by query modification. In W. Frank King, editor, Proceedings of the 1975 ACM SIGMOD International Conference on Management of Data, San Jose, California, May 14–16, 1975, pages 65–78. ACM Press, 1975.
Jennifer Widom, Roberta Cochrane, and Bruce G. Lindsay. Implementing setoriented production rules as an extension to starburst. In Guy M. Lohman, Amilcar Sernadas, and Rafael Camps, editors, 17th International Conference on Very Large Data Bases, September 3–6, 1991, Barcelona, Catalonia, Spain, Proceedings, pages 275–285. Morgan Kaufmann, 1991.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Kluwer Academic Publishers
About this chapter
Cite this chapter
Jin, B., Embury, S.M. (2004). Reducing Disruption in Time-Tabled Condition Monitoring. In: Jajodia, S., Strous, L. (eds) Integrity and Internal Control in Information Systems VI. IICIS 2003. IFIP International Federation for Information Processing, vol 140. Springer, Boston, MA. https://doi.org/10.1007/1-4020-7901-X_11
Download citation
DOI: https://doi.org/10.1007/1-4020-7901-X_11
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4020-7900-9
Online ISBN: 978-1-4020-7901-6
eBook Packages: Springer Book Archive