|
ABSTRACT
Active database systems support mechanisms that enable them to respond automatically to events that are taking place either inside or outside the database system itself. Considerable effort has been directed towards improving understanding of such systems in recent years, and many different proposals have been made and applications suggested. This high level of activity has not yielded a single agreed-upon standard approach to the integration of active functionality with conventional database systems, but has led to improved understanding of active behavior description languages, execution models, and architectures. This survey presents the fundamental characteristics of active database systems, describes a collection of representative systems within a common framework, considers the consequences for implementations of certain design decisions, and discusses tools for developing active applications.
REFERENCES
Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.
 |
1
|
|
| |
2
|
|
 |
3
|
Alexander Aiken , Jennifer Widom , Joseph M. Hellerstein, Behavior of database production rules: termination, confluence, and observable determinism, ACM SIGMOD Record, v.21 n.2, p.59-68, June 1, 1992
|
| |
4
|
AMOUROUX, R. 1995. Reactive services for supporting tool integration in a development environment. In Proceedings on Technology of Object-Oriented Languages and Systems (TOOLS), 61-70.
|
| |
5
|
|
| |
6
|
|
| |
7
|
|
 |
8
|
|
 |
9
|
|
| |
10
|
BAYER, P. AND JONKER, W. 1994. A framework for supporting triggers in deductive databases. In Proceedings of the First International Workshop on Rules in Database Systerns, N. Paton and M. Williams, Eds., Springer-Verlag, 316-330.
|
| |
11
|
|
| |
12
|
|
| |
13
|
BICHLER, P. AND SCHREFL, M. 1994. Active object-oriented database using active object/behaviour diagrams. In Proceedings of the Fourth International Workshop on Research Issues in Data Engineering (RIDE-ADS'94), 163-171.
|
| |
14
|
BLUE, A., BROWN, B., AND GRAY, W. 1988. An implementation of alerters for health district management. In Proceedings of the Sixth British National Conference on Databases (BN- COD), W. Gray, Ed., 125-140.
|
| |
15
|
BRANDING, H., BUCHMANN, A., KUDRASS, T., AND ZIMMERMANN, J. 1994. Rules in an open system: The REACH rule system. In Rules in Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag, 111-126.
|
 |
16
|
|
| |
17
|
BUCHMANN, A. 1994. Current trends in active databases: Are we solving the right problems. In Information Systems Design and Multimedia, Proceedings of the Basque International Workshop on IT, C. Chrisment, Ed., Cepadues Editions, 121-133.
|
| |
18
|
Alejandro P. Buchmann , Jürgen Zimmermann , José A. Blakeley , David L. Wells, Building an Integrated Active OODBMS: Requirements, Architecture, and Design Decisions, Proceedings of the Eleventh International Conference on Data Engineering, p.117-128, March 06-10, 1995
|
| |
19
|
CAMPIN, J., PATON, N., AND WILLIAMS, M. 1997. Specifying active database systems in an object-oriented framework. Softw. Eng. Knowl. Eng. 7(1), 101-123.
|
| |
20
|
CERI, S. AND FRATERNALI, P. 1997. Designing Applications with Objects and Rules: The IDEA Methodology. International Series on Database Systems and Applications, Addison- Wesley Longman, Reading, MA.
|
| |
21
|
|
| |
22
|
|
| |
23
|
CERI, S., FRATERNALI, P., PARABOSCHI, S., AND TANCA, L. 1996. Active rule management in Chimera. In Active Database Systems: Triggers and Rules for Active Database Processing, J. Widom and S. Ceri, Eds., Morgan-Kaufmann, San Mateo, CA, 151-175.
|
| |
24
|
|
 |
25
|
|
| |
26
|
CHAKRAVARTHY, S., ANWAR, E., MAUGIS, L., AND MISHRA, D. 1994a. Design of Sentinel: An object-oriented DBMS with event-based rules. Inf. Softw. Technol. 36, 9, 555-568.
|
| |
27
|
|
| |
28
|
|
| |
29
|
CHANDRA, R. AND SEGEV, A. 1994. Active databases for financial applications. In Proceedings of the Fourth International Workshop on Research in Data Engineering (RIDE-ADS), J. Widom and S. Chakravarthy, Eds., IEEE, 46- 52.
|
| |
30
|
COLLET, C. AND MANCHADO, J. 1995. Optimization of active rules with parallelism. In Proceedings of Active and Real Time Database Systems (ARTDB), M. Berndtsson and J. Hansson, Eds., Springer-Verlag, 82-103.
|
| |
31
|
|
| |
32
|
|
| |
33
|
DAYAL, U. 1989. Active database management systems. SIGMOD Rec. 18, 3, 150-169.
|
| |
34
|
|
 |
35
|
Umeshwar Dayal , Meichun Hsu , Rivka Ladin, Organizing long-running activities with triggers and transactions, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.204-214, May 23-26, 1990, Atlantic City, New Jersey, United States
|
| |
36
|
|
| |
37
|
DIAZ, O. 1992. Deriving rules for constraint maintenance in an object-oriented database. In Proceedings of the International Conference on Databases and Expert Systems DEXA, I. R. A. M. Tjoa, Ed., Springer-Verlag, 332- 337.
|
| |
38
|
|
| |
39
|
DIAZ, O., JAIME, A., AND PATON, N. 1994a. DEAR: A DEbugger for Active Rules in an object-oriented context. In Proceedings of the First International Workshop on Rules in Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag, 180-193.
|
 |
40
|
|
| |
41
|
|
| |
42
|
|
| |
43
|
DITTRICH, A.K. 1993. Adding active functionality to an object-oriented database--a layered approach. In Proceedings of Datenbanksysteme in Buro (Braunschweig, Germany).
|
| |
44
|
|
 |
45
|
|
| |
46
|
ETZION, O., GAL, A., AND SEGEV, A. 1994. Data driven and temporal rules in PARDES. In Proceedings of the First International Workshop on Rules in Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag, 92- 108.
|
| |
47
|
|
| |
48
|
|
| |
49
|
|
| |
50
|
FORGY, C. 1982. Rete: A fast algorithm for the many pattern/many object pattern match problem. Artif. Intell. 19, 17-37.
|
 |
51
|
|
| |
52
|
GATZIU, S. AND DITTRICH, K. 1994. Events in an active object-oriented database. In Proceedings of the First International Workshop on Rules in Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag, 23-39.
|
| |
53
|
|
| |
54
|
|
 |
55
|
|
| |
56
|
GEPPERT, A. AND DITTRICH, K. 1994. Rule-based implementation of transaction model specifications. In Proceedings of the First International Workshop on Rules in Database Systerns, N. Paton and M. Williams, Eds., Springer-Verlag, 127-142.
|
| |
57
|
|
 |
58
|
|
| |
59
|
HANSON, E. N. AND WIDOM, J. 1993. An overview of production rules in database systems. Knowl. Eng. Rev. 8, 2, 121-143.
|
| |
60
|
|
| |
61
|
HARRISON, J. AND DIETRICH, S. 1994. Integrating active and deductive rules. In Proceedings of the First International Workshop on Rules In Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag, 288-305.
|
| |
62
|
Hsu, M., LADIN, R., AND MCCARTHY, D. 1988. An execution model for active data base management systems. In Proceedings of the International Conference on Data and Knowledge Bases, 171-179.
|
 |
63
|
G. Kiernan , C. de Maindreville , E. Simon, Making deductive databases a practical technology: a step forward, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.237-246, May 23-26, 1990, Atlantic City, New Jersey, United States
|
| |
64
|
KIM, W., LEE, Y., AND SEO, J. 1992. A framework for supporting triggers in object-oriented database systems. Int. J. Intel. Coop. Inf. Syst. 1, 1, 127-143.
|
| |
65
|
KOSCHEL, A., KRAMER, R., VON BULTZINGSLOEWEN, G., BLEIBEL, T., KRUMLINDE, P., SCHMUCK, S., AND WEINAND, C. 1997. Configurable active functionality for Corba. In Proceedings of the Eleventh ECOOP Workshop 7 on CORBA.
|
| |
66
|
|
| |
67
|
KULKARNI, K., MATTOS, N., AND COCHRANE, R. 1999. Active database features in SQL-3. In Active Rules in Database Systems. N. Paton, Ed., Springer-Verlag.
|
| |
68
|
|
| |
69
|
MIRANKER, D. 1987. TREAT: A better match algorithm for AI production systems. In Proceedings of AAAI, 42-47.
|
| |
70
|
|
| |
71
|
NAQVI, W. AND IBRAHAM, M. 1994. Rule and knowledge management in an active database system. In Proceedings of the First International Workshop on Rules in Database Systerns, N. Paton and M. Williams, Eds., Springer-Verlag, 58-69.
|
| |
72
|
NAVATHE, S., TANAKA, A., MADHAVAN, R., AND GAN, Y.H. 1995. A methodology for application design using active database technology. Tech. Report RL-TR-95-41, Rome Laboratory.
|
| |
73
|
|
| |
74
|
|
| |
75
|
|
| |
76
|
PATON, N., DIAZ, O., WILLIAMS, M., CAMPIN, J., DINN, A., AND JAIME, A. 1994. Dimensions of active behaviour. In Proceedings of the First International Workshop on Rules in Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag, 40-57.
|
| |
77
|
PATON, N., DOAN, D., DIAZ, O., AND JAIME, A. 1996. Exploitation of object-oriented and active constructs in database interface development. In Proceedings of the Third International Workshop on Interfaces to Database Systems, J. Kennedy and P. Barclay, Eds., Springer-Verlag.
|
| |
78
|
|
| |
79
|
SCHWIDERSKI, S. 1996. Monitoring the behaviour of distributed systems. Ph.D. Thesis, University of Cambridge, United Kingdom.
|
| |
80
|
|
| |
81
|
|
 |
82
|
|
 |
83
|
Michael Stonebraker , Anant Jhingran , Jeffrey Goh , Spyros Potamianos, On rules, procedure, caching and views in data base systems, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.281-290, May 23-26, 1990, Atlantic City, New Jersey, United States
|
| |
84
|
|
| |
85
|
VAN DER VOORT, L. AND SIEBES, A. 1994. Enforcing confluence of rule execution. In Proceedings of the First International Workshop on Rules in Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag, 194-207.
|
| |
86
|
VON BUELTZINGSLOEWEN, G., KOSCHEL, A.,LOCK- EMANN, P., AND WALTER, H. 1999. ECA functionality in a distributed environment. In Active Rules in Database Systems. Springer- Verlag.
|
| |
87
|
|
| |
88
|
WEIK, T. AND HEURER, A. 1995. An algorithm for the analysis of termination of large trigger sets in an OODBMS. In Proceedings of Active Real Time Database Systems (ARTDB), M. Berndtsson and J. Hansson, Eds., Springer- Verlag, 158-169.
|
| |
89
|
|
 |
90
|
|
 |
91
|
|
| |
92
|
|
| |
93
|
|
| |
94
|
ZANIOLO, C. 1994. A unified semantics for active and deductive databases. In Rules in Database Systems, N. Paton and M. Williams, Eds., Springer-Verlag.
|
CITED BY 50
|
|
|
|
|
Paul Dourish , W. Keith Edwards , Jon Howell , Anthony LaMarca , John Lamping , Karin Petersen , Michael Salisbury , Doug Terry , Jim Thornton, A programming model for active documents, Proceedings of the 13th annual ACM symposium on User interface software and technology, p.41-50, November 06-08, 2000, San Diego, California, United States
|
|
|
|
|
|
Paul Dourish , W. Keith Edwards , Anthony LaMarca , John Lamping , Karin Petersen , Michael Salisbury , Douglas B. Terry , James Thornton, Extending document management systems with user-specific active properties, ACM Transactions on Information Systems (TOIS), v.18 n.2, p.140-170, April 2000
|
|
|
Dolores Cuadra , Carlos Nieto , Paloma Martínez , Elena Castro , Manuel Velasco, Preserving relationship cardinality constraints in relational schemata, Database integrity: challenges and solutions, Idea Group Publishing, Hershey, PA, 2002
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AnnMarie Ericsson , Paul Pettersson , Mikael Berndtsson , Marco Seiriö, Seamless formal verification of complex event processing applications, Proceedings of the 2007 inaugural international conference on Distributed event-based systems, June 20-22, 2007, Toronto, Ontario, Canada
|
|
|
|
|
|
|
|
|
|
|
|
Don Carney , Uǧur Çetintemel , Mitch Cherniack , Christian Convey , Sangdon Lee , Greg Seidman , Michael Stonebraker , Nesime Tatbul , Stan Zdonik, Monitoring streams: a new class of data management applications, Proceedings of the 28th international conference on Very Large Data Bases, p.215-226, August 20-23, 2002, Hong Kong, China
|
|
|
|
|
|
Daniel J. Abadi , Don Carney , Ugur Çetintemel , Mitch Cherniack , Christian Convey , Sangdon Lee , Michael Stonebraker , Nesime Tatbul , Stan Zdonik, Aurora: a new model and architecture for data stream management, The VLDB Journal — The International Journal on Very Large Data Bases, v.12 n.2, p.120-139, August 2003
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Andrew Witkowski , Srikanth Bellamkonda , Hua-Gang Li , Vince Liang , Lei Sheng , Wayne Smith , Sankar Subramanian , James Terry , Tsae-Feng Yu, Continuous queries in oracle, Proceedings of the 33rd international conference on Very large data bases, September 23-27, 2007, Vienna, Austria
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
REVIEW
"Lia-Maria Pasculescu : Reviewer"
Database systems are beginning to be applied to domains that
involve more complex information processing, resulting in applications
with more comprehensive facilities for modeling their structural and
behavioral aspects.
This paper
more...
|