ACM SIGMOD Anthology VLDB dblp.uni-trier.de

Promises and Realities of Active Database Systems.

Eric Simon, Angelika Kotz Dittrich: Promises and Realities of Active Database Systems. VLDB 1995: 642-653
@inproceedings{DBLP:conf/vldb/SimonD95,
  author    = {Eric Simon and
               Angelika Kotz Dittrich},
  editor    = {Umeshwar Dayal and
               Peter M. D. Gray and
               Shojiro Nishio},
  title     = {Promises and Realities of Active Database Systems},
  booktitle = {VLDB'95, Proceedings of 21th International Conference on Very
               Large Data Bases, September 11-15, 1995, Zurich, Switzerland},
  publisher = {Morgan Kaufmann},
  year      = {1995},
  isbn      = {1-55860-379-4},
  pages     = {642-653},
  ee        = {db/conf/vldb/SimonD95.html},
  crossref  = {DBLP:conf/vldb/95},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

We confront the promises of active database systems with the result of their use by application developers. The main problems encountered are insufficient methodological support in analysis and design, the lack of standardization, missing development and administration tools for triggers, and weak performance. We concentrate on performance because we discovered it is one the main reasons that makes users reluctant to use active rules in the development of large applications. We show, using simple concrete examples, that optimizing large applications is rendered difficult by the separation of transactions and triggers andthe misunderstanding of their subtle interactions. We argue that tools, which provide assistance to programmers, database administrators, and database designers to optimize their applications and master application evolution is strongly needed.

Copyright © 1995 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.


Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Umeshwar Dayal, Peter M. D. Gray, Shojiro Nishio (Eds.): VLDB'95, Proceedings of 21th International Conference on Very Large Data Bases, September 11-15, 1995, Zurich, Switzerland. Morgan Kaufmann 1995, ISBN 1-55860-379-4
Contents BibTeX

References

[BCMP94]
Elena Baralis, Stefano Ceri, Gabriella Monteleone, Stefano Paraboschi: An Intelligent Database System Application: The Design of EMS. ADB 1994: 172-189 BibTeX
[CS94]
Rakesh Chandra, Arie Segev: Active Databases for Financial Applications. RIDE-ADS 1994: 46-52 BibTeX
[CW90]
Stefano Ceri, Jennifer Widom: Deriving Production Rules for Constraint Maintainance. VLDB 1990: 566-577 BibTeX
[Day88]
Umeshwar Dayal: Active Database Management Systems. JCDKB 1988: 150-169 BibTeX
[DHL90]
Umeshwar Dayal, Meichun Hsu, Rivka Ladin: Organizing Long-Running Activities with Triggers and Transactions. SIGMOD Conference 1990: 204-214 BibTeX
[Esw76]
...
[GR93]
Jim Gray, Andreas Reuter: Transaction Processing: Concepts and Techniques. Morgan Kaufmann 1993, ISBN 1-55860-190-2
Contents BibTeX
[HKMS94]
...
[Hor94]
Bruce M. Horowitz: Intermediate States as Source of Non-Deterministic Behavior in Triggers. RIDE-ADS 1994: 148-155 BibTeX
[ISO94]
...
[LS95]
François Llirbat, Eric Simon: Optimizing Active Database Transactions: A New Perspective. ARTDB 1995: 23-45 BibTeX
[Sha92]
Dennis Shasha: Database Tuning - A Principled Approach. Prentice-Hall 1992, ISBN 0-13-205246-6
Contents BibTeX
[SLSV95]
Dennis Shasha, François Llirbat, Eric Simon, Patrick Valduriez: Transaction Chopping: Algorithms and Performance Studies. ACM Trans. Database Syst. 20(3): 325-363(1995) BibTeX
[Sto92]
Michael Stonebraker: The Integration of Rule Systems and Database Systems. IEEE Trans. Knowl. Data Eng. 4(5): 415-423(1992) BibTeX
[TKL90]
Aphrodite Tsalgatidou, V. Karakostas, Pericles Loucopoulos: Rule-Based Requirements Specification and Validation. CAiSE 1990: 251-263 BibTeX
[WCD95]
Jennifer Widom, Stefano Ceri (Eds.): Active Database Systems: Triggers and Rules For Advanced Database Processing. Morgan Kaufmann 1996, ISBN 1-55860-304-2
Contents BibTeX

Referenced by

  1. Stefano Ceri, Roberta Cochrane, Jennifer Widom: Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award). VLDB 2000: 254-262
  2. Jianjun Chen, David J. DeWitt, Feng Tian, Yuan Wang: NiagaraCQ: A Scalable Continuous Query System for Internet Databases. SIGMOD Conference 2000: 379-390
  3. Stella Gatziu, Arne Koschel, Günter von Bültzingsloewen, Hans Fritschi: Unbundling Active Functionality. SIGMOD Record 27(1): 35-40(1998)
  4. Stefan Grufman, Fredrik Samson, Suzanne M. Embury, Peter M. D. Gray, Tore Risch: Distributing Semantic Constraints Between Heterogeneous Databases. ICDE 1997: 33-42
  5. Roberta Cochrane, Hamid Pirahesh, Nelson Mendonça Mattos: Integrating Triggers and Declarative Constraints in SQL Database Sytems. VLDB 1996: 567-578
  6. Gerti Kappel, S. Rausch-Schott, Werner Retschitzegger: A Transaction Model For Handling Composite Events. ADBIS 1996: 116-125
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:46:07 2009