Practical applications of triggers and constraints: Successes and lingering issues

Proceedings of the 26th International Conference on Very Large Data Bases, VLDB'00

Volumn , Issue , 2000, Pages 254-262

  Ceri, Stefano ^a   Cochrane, Roberta J ^b   Widom, Jennifer ^c  

^a POLITECNICO DI MILANO   (Italy)

^b IBM ALMADEN RESEARCH CENTER   (United States)

^c STANFORD UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

APPLICATION DEVELOPMENT TOOLS; INTEGRITY CONSTRAINTS; PERFORMANCE ISSUES; TRIGGER PROCESSING;

DATABASE SYSTEMS;

DIGITAL STORAGE;

EID: 84877347730     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (26)

1. [ACL9II R. Agrawal, R.J. Cochrane, and B. Lindsay. On maintaining priorities in a production rule system. In Proceedings of the Seventeenth international Conference on Very Large Data Bases, pages 479-487, Barcelona, Spain, September 1991.
2. [BBC971 P. Bernstein, M. Brodie, S. Ceri, et al. The Asilomar report on database research. SIGMOD Record. 27(4):74-80, December 1997.
3. [BDD98l R. Bello, K. Dias, A, Downing, et al. Materiatized views in Oracle. In Proceedings of the Twenrv.Fourth International Conference on Very Large Data Bases. pages 659-664, New York, New York, August 1998.
4. [CF97] S. Ceri and P. Fraternali. Designing Database Applications with Objects and Rules. The IDEA Methodology. Addison-Wesley, 1997.
5. ICPM96J R.J. Cochrane, H. Pirahesh, and N.M. Mattos. Integrating triggers and declarath'e constraints in SQL database sytems. In Proceedings of the Twenty- Second international Conferenceon Very Large Data Bases, pages 567-578, Mumbai, India, September 1996.
6. ICW9OI S. Ceri and J. Widoni. Deriving production rules for constraint maintenance. In Proceedings of the Sixteenth international Conference on Very Large Data Bases, pages 566-577, Brisbane, Australia, August 1990.
7. [CW9IJ S. Ceri and I. Widom. Deriving production rules for incremental view maintenance. In Proceedings of the Seventeenth International Conference on Very Large Data Bases, pages 577-589, Barcelona, Spain, September 1991.
8. (CW931 S. Ccii and J. Widom. Managing semantic heterogeneity with production rules and persistent queues. In Proceedings of the Nineteenth International Conference on Very Large Data Bases, pages 108-119. Dublin, Ireland, August 1993.
9. [DHL9O] U. Dayal. M. Hsu, and R. Ladin. Organizing long-running activities with triggers and transactions. In Proceedings of the ACM S1GMOD international Conference on Management of Data, pages 204-214, Atlantic City, New Jersey, May 1990.
10. EC75J K.P. Eswaran and D.D. Chamberlin. Functional specifications of a subsystem for data base integrity. In Proceedings of the First International Conference on Very Large Data Bases, pages 48-67, Framingham, Massachusetts, September 1975.
11. [Esw761 KR Eswaran. Specifications, implementations and interactions of a trigger subsystem in an integrated database system. IBM Research Report RI 1820, iBM San Jose Research Laboratory, San Jose, California, August 1976.
12. lHan92i E.N. Hanson. Rule condition testing and action execution in Ariel. in Proceedings of the ACM SIGMOD international Conference on Management of Data, pages 49-58, San Diego, California, June 1992.
13. [HM751 M. Hammer and D. McLeod. Semantic integrity in a relational data base system. In Proceedings of the First International Conference on Very Large Data Bases. pages 25-47, Framingham, Massachusetts, September 1975.
14. (Hor921 B. Horowitz. A run-time execution model for referential integrity maintenance. In Proceedings of the Eighth International Conference on Data Engineering. pages 548-556, Phoenix, Arizona, February 1992.
15. tnIO01 Informix Software. Informut Media3fiO, 2000. Available at http:l/www.informix.comimedia36O.
16. [LLPS9I] G.M. Lohman. B. Lindsay, H. Pirahesh, and KB. Schiefer. Extensions to Starburst: Objects, types, functions, and rules. Conwwnications of the ACM, 34(10):94-l09, October 1991.
17. [LSPCOOI W. Lehner, R. Sidle, H. Pirahesh, and R.J. Colza Maintenance of automatic summary tables. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 512-513 Dallas, Texas. May 2000.
18. [OraOO} Oracle Corporation. Oracle Workflow Technical Configuration in Oracle Applications Release Ii 2000. Available at httP:IIwww.oracle.comjsup
19. (Ros97J R.G. Ross. The Business Rule Book: Clas.c!fying, Defining and Modeling Rules. Business Rule Solu tions Inc., February 1997.
20. [SK9IJ M. Stonebraker and G. Kemnitz. The POSTGRES next-generation database management System. Communications of the ACM. 34(10):78-92 October 1991.
21. (SKD95J E. Simon and A. Kotz-Dittrich. and realities of active database systems. In Proceedings of the Twenty-First International Conference on Very Large Data Bases, pages 642-653, ZOrich, Switzerland. September 1995.
22. [SRL90J M. Stonebraker, L.A. Rowe, B.G. Lindsay, J. Gray. M.J. Carey. ML. Brxlie, P.A. Bernstein, and D. Beech. Third-generation database system manifesto - The committee fur advanced DBMS function. S1GMOD Record. 19(3):3 1-44, September 1990.
23. [Sto751 M. Stonebraker. Implementation of integrity con straints and views by query modification. in Proceed ings of the ACM SIGMOD International Conference on Management of Data, pages 65-78, San Jose, Cal ifornia, May 1975.
24. [Tho97] C. Thompson. Database replication. DBMS Maga zine, 10(5), May 1997.
25. UW971 J.D. Uliman and J. Widom. A First Course in Database Systems. Prentice Hall, Upper Saddle River, New Jersey, 1997.
26. [WC961 J. Widom and S. Ccii. Active Database Systems. Triggers and Rules for Advanced Database Processing. Morgan Kaufmann, San Francisco, California, 1996.