Abstract
Database systems have been designed to manage business critical information and provide this information on request to connected clients, a passive model. Increasingly, applications need to share information actively with clients and/or external systems, so that they can react to relevant information as soon as it becomes available. Event-driven architecture (EDA) is a software architectural pattern that models these requirements based on the production of, consumption of, and reaction to events. Publish/subscribe provides a loosely-coupled communication paradigm between the components of a system, through many-to-many, push-based event delivery. In this paper, we describe our work integrating distributed content-based publish/subscribe functionality into a database system. We have extended existing database technology with new capabilities to realise EDA in a reliable, scalable, and secure manner. We discuss the design, architecture, and implementation of PostgreSQL-PS, a prototype built on the PostgreSQL open-source database system.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Luckham, D.: The Power of Events: An Introduction to Complex Event Processing in Distributed Enterprise Systems. Addison-Wesley Professional, Reading (2002)
Eugster, P., Felber, P., Guerraoui, R., Kermarrec, A.: The Many Faces of Publish/Subscribe. ACM Computing Surveys 35(2), 114–131 (2003)
The PostgreSQL Global Development Group (2008), www.postgresql.org
Mühl, G., Fiege, L., Pietzuch, P.: Distributed Event-Based Systems. Springer, Heidelberg (2006)
Pesonen, L.I.W., Bacon, J.: Secure Event Types in Content-Based, Multi-domain Publish/Subscribe Systems. In: Proc.of the 5th International Workshop on Software Engineering and Middleware, pp. 98–105 (2005)
American National Standards Institute: Standard x3.135-1992 (1992)
Carzaniga, A., Rosenblum, D., Wolf, A.: Design and Evaluation of a Wide-Area Event Notification Service. ACM Tran. on Computer Systems 19(3), 332–383 (2001)
Paton, N.W., Díaz, O.: Active Database Systems. ACM Computing Surveys 31(1), 63–103 (1999)
Comer, D.E.: Internetworking with TCP/IP vol II. ANSI C Version: Design, Implementation, and Internals. Prentice-Hall, Englewood Cliffs (1998)
Gray, J.: Queues are Databases. In: Proc. of the 7th High Performance Transaction Processing Workshop (1995)
Aschenbrenner, K.: SQL Server 2005 Service Broker. Apress (2007)
Oracle: 11g Streams Replication Administrator’s Guide (2007)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vargas, L., Bacon, J., Moody, K. (2008). Event-Driven Database Information Sharing. In: Gray, A., Jeffery, K., Shao, J. (eds) Sharing Data, Information and Knowledge. BNCOD 2008. Lecture Notes in Computer Science, vol 5071. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-70504-8_11
Download citation
DOI: https://doi.org/10.1007/978-3-540-70504-8_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-70503-1
Online ISBN: 978-3-540-70504-8
eBook Packages: Computer ScienceComputer Science (R0)