Skip to main content

Inter-system Triggering for Heterogeneous Database Systems

  • Conference paper
  • First Online:
  • 1375 Accesses

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2453))

Abstract

Most of the research in database triggers focused on the centralised active database systems. Because of the requirements from electronic commerce and Web applications, there are growing demands for inter-system level’s triggers between different information sources. As a result, systems can interact with each other and react on the events happening on others. This paper proposes the concept of inter-system triggering, and discusses our implementation efforts. It also describes our proposed architecture, namely Advanced Triggering Database System (ATDS), for implementing inter-system triggers. Finally an application example of our preliminary prototype is presented.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. S. Ceri, R. Cochrane, and J. Widom. Practical applications of triggers and constraints: Successes and lingering issues. In Proceedings of the 26th International Conference on Very Large Data Bases, Cairo,Egypt, 2000.

    Google Scholar 

  2. S. Ceri and J. Widom. Deriving Production Rules for Incremental View Maintenancehttp:// www.vldb.org/conf/1991/P577.PDF. In Proceedings of the 17th International Conference on Very Large Data Bases, pages 577–589. Morgan Kaufmann, 1991.

  3. U. Dayal, E. Hanson, and J. Widom. Active database systems. In Modern Database System: The Object Model, Interoperability, and Beyond, Reading. Addison-Wesley, Massachusetts, 1994.

    Google Scholar 

  4. N. H. Gehani and H. V. Jagadish. Ode as an Active Database: Constraints and Triggers. In Proceedings of the 17th International Conference on Very Large Data Bases, pages 327–336, 1991.

    Google Scholar 

  5. W Guan and R Wong. Advanced triggering database system. Technical report, University of New South Wales, Sydney, Australia, 2002.

    Google Scholar 

  6. E. N. Hanson. An Initial Report on the Design of Ariel: A DBMS With an Integrated Production Rule System. SIGMOD Record, 18(3):12–19, September 1989.

    Article  Google Scholar 

  7. A. Koschel and Peter C. Lockemann. Distributed Events in Active Database Systems-Letting the Genie out of the Bottle. Journal of Data and Knowledge Engineering (DKE), 25, 1998. Special Issue for the 25th Vol. of DKE.

    Google Scholar 

  8. D. R. McCarthy and U. Dayal. The Architecture of an Active Data Base Management System. In Proceedings of the 1989 ACM SIGMOD International Conference on Management of Data, pages 215–224, 1989.

    Google Scholar 

  9. S. Schwiderski. Monitoring the behaviour of distributed systems. PhD thesis, University of Cambridge, April 1996.

    Google Scholar 

  10. M. Stonebraker and G. Kemnitz. The Postgres next-generation database management system. Communication of the ACM, 34(10):78–92, 1991.

    Article  Google Scholar 

  11. A. P. J. M. Siebes, M. H. Voort, and M. L. Kersten. Towards a design theory for Database triggers. In Proceedings of the 3rd International Conference on Database and Expert Systems Applications, pages 338–344. Springer, 1992.

    Google Scholar 

  12. J. Widom, R. J. Cochrane, and B. G. Lindsay. Implementing Set-Oriented Production Rules as an Extension of Starburst. In Proceedings of the 17th International Conference on Very Large Data Bases, pages 275–285, 1991.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Guan, W., Wong, R.K. (2002). Inter-system Triggering for Heterogeneous Database Systems. In: Hameurlain, A., Cicchetti, R., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2002. Lecture Notes in Computer Science, vol 2453. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46146-9_57

Download citation

  • DOI: https://doi.org/10.1007/3-540-46146-9_57

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-44126-7

  • Online ISBN: 978-3-540-46146-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics