research-article

Relational database support for event-based middleware functionality

Authors:

David M. Eyers,

Jatinder Singh,

Jean BaconAuthors Info & Claims

DEBS '10: Proceedings of the Fourth ACM International Conference on Distributed Event-Based Systems

Pages 160 - 171

https://doi.org/10.1145/1827418.1827455

Published: 12 July 2010 Publication History

Abstract

Many of the popular relational database management systems (RDBMS) provide features for operating in a distributed environment, such as remote table queries and updates, and support for distributed transactions. In practice, however, much application software targets a more minimal set of functionality than is offered by the SQL standards. Independently of the database tier, engineering concepts such as the enterprise service bus and service oriented architecture have led to the development of communication middleware to support distributed applications. For applications that require reliable delivery of messages, complex event processing, and integrated archiving of data, impedance mismatches are likely to emerge between the database system and the communications middleware---for example with respect to data-types, event filtering that is based on information in the database, and in terms of coordinating access control policy. This paper describes event-based middleware functionality that is supported directly within the database system. In contrast to previous approaches (e.g. being able to name remote tables in SQL statements), the programming of event-based communication operations within the database is explicit. We present initial performance results that compare an augmented PostgreSQL database system to an environment in which a database and an event-based middleware package are used side-by-side. These results demonstrate the viability of our approach.

References

[1]

American National Standards Institute. Standard x3.135-1992, 1992.

[2]

Apache Software Foundation. ActiveMQ. http://activemq.apache.org/, Last Accessed 2010.

[3]

K. Aschenbrenner. SQL Server 2005 Service Broker. Apress, 2007.

Digital Library

[4]

A. Belokosztolszki. Role-Based Access Control policy administration. Technical Report UCAM-CL-TR-586, University of Cambridge, Computer Laboratory, Mar. 2004.

[5]

A. Carzaniga, D. S. Rosenblum, and A. L. Wolf. Design and Evaluation of a Wide-Area Event Notification Service. ACM Transactions on Computer Systems, 19(3):332--383, 2001.

Digital Library

[6]

D. C. Clark and D. R. Wilson. A comparison of commercial and military security policies. In Proceedings of the IEEE Symposium on Security and Privacy, Washington DC, 1987.

[7]

D. E. Comer. Internetworking with TCP/IP Vol II. Design, Implementation, and Internals, 3rd edition. Prentice Hall, 1998.

Digital Library

[8]

N. Connecting for Health. The electronic prescription service. http://www.connectingforhealth.nhs.uk/systemsandservices/eps, Last Accessed 2010.

[9]

G. Cugola, M. Migliavacca, and A. Monguzzi. On adding replies to publish-subscribe. In DEBS '07: Proceedings of the 2007 inaugural international conference on Distributed event-based systems, pages 128--138, New York, NY, USA, 2007. ACM.

Digital Library

[10]

O. P. Department of Health and D. Division. Building Telecare in England. http://www.dh.gov.uk/en/Publicationsandstatistics/Publications/PublicationsPolicyAndGuidance/DH_4115303, 2005.

[11]

U. Department of Health. Confidentiality: NHS Code of Practice. http://www.dh.gov.uk/en/PublicationsAndStatistics/Publications/PublicationsPolicyAndGuidelines/DH_4069253, 2003.

[12]

P. Eugster, P. A. Felber, R. Guerraoui, and A.-M. Kermarrec. The Many Faces of Publish/Subscribe. ACM Computing Surveys, 35(2):114--131, 2003.

Digital Library

[13]

J. Gray. Queues are Databases. In Proceedings of the 7th High Performance Transaction Processing Workshop, 1995.

[14]

J.-H. Hwang, S. Cha, U. Cetintemel, and S. Zdonik. Borealis-r: a replication-transparent stream processing system for wide-area monitoring applications. In SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of data, pages 1303--1306, New York, NY, USA, 2008. ACM.

Digital Library

[15]

D. Luckham. The Power of Events: An Introduction to Complex Event Processing in Distributed Enterprise Systems. Addison-Wesley Professional, 2002.

Digital Library

[16]

NHS Care Record Development Board. The care record guarantee---our guarantee for NHS Care Records in England. http://www.nigb.nhs.uk/guarantee/2009-nhs-crg.pdf, 2009.

[17]

Oracle. Oracle 11g Streams Replication Administrator's Guide, 2007.

[18]

N. W. Paton and O. Díaz. Active Database Systems. ACM Computing Surveys, 31(1):63--103, 1999.

Digital Library

[19]

L. I. W. Pesonen and J. Bacon. Secure Event Types in Content-Based, Multi-domain Publish/Subscribe Systems. In Proceedings of the 5th International Workshop on Software Engineering and Middleware (SEM'05), pages 98--105. ACM, 2005.

Digital Library

[20]

L. I. W. Pesonen, D. M. Eyers, and J. Bacon. Encryption-Enforced Access Control in Dynamic Multi-Domain Publish/Subscribe Networks. In Proceedings of the International Conference on Distributed Event-Based Systems (DEBS'07), pages 104--115. ACM Press, June 2007.

Digital Library

[21]

Y. Shatsky and E. Gudes. TOPS - A New Design for Transactions in Publish/Subscribe Middleware. In 201--210, pages Proceedings of the 2nd International Conference on Distributed Event-Based Systems (DEBS'08). ACM, 2008.

Digital Library

[22]

J. Singh, D. M. Eyers, and J. Bacon. Controlling historical information dissemination in publish/subscribe. In MidSec '08: Proceedings of the 2008 workshop on Middleware security, pages 34--39, New York, NY, USA, 2008. ACM.

Digital Library

[23]

J. Singh, L. Vargas, and J. Bacon. A Model for Controlling Data Flow in Distributed Healthcare Environments. In Proceedings of the 2nd International Conference on Pervasive Computing Technologies for Healthcare (Pervasive Health'08), pages 188--191. IEEE Computer Society, 2008.

[24]

J. Singh, L. Vargas, J. Bacon, and K. Moody. Policy-Based Information Sharing in Publish/Subscribe Middleware. In Proceedings of the 9th International Workshop on Policies for Distributed Systems and Networks (Policy'08), pages 137--144. IEEE Computer Society, 2008.

Digital Library

[25]

M. Stonebraker and U. Cetintemel. "One size fits all": An idea whose time has come and gone. Data Engineering, International Conference on, 0:2--11, 2005.

Digital Library

[26]

M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos. On rules, procedures, caching and views in database systems. Readings in Database Systems (2nd edition), pages 363--372, 1994.

Digital Library

[27]

The PostgreSQL Global Development Group. www.postgresql.org, 2008.

[28]

UK Crown. The Controlled Drugs (Supervision of Management and Use) Regulations, 2006.

[29]

L. Vargas, J. Bacon, and K. Moody. Integrating Databases with Publish/Subscribe. In Proceedings of the Fourth International Workshop on Distributed Event-Based Systems (DEBS'05). In conjunction with the 25th International Conference on Distributed Computing Systems (ICDCS'05), pages 392--397. IEEE Computer Society, 2005.

Digital Library

[30]

L. Vargas, J. Bacon, and K. Moody. Event-Driven Database Information Sharing. In Proceedings of the 25th British National Conference on Databases (BNCOD'08), volume 5071 of Lecture Notes in Computer Science (LNCS), pages 113--125. Springer, 2008.

Digital Library

[31]

L. Vargas, L. I. W. Pesonen, E. Gudes, and J. Bacon. Transactions in Content-Based Publish/Subscribe Middleware. In Proceedings of the 1st International Workshop on Distributed Event Processing, Systems and Applications (DEPSA'07). In conjunction with the 27th International Conference on Distributed Computing Systems (ICDCS'07), pages 68--78. IEEE Computer Society, 2007.

Digital Library

Cited By

Docking MUzunov AFiddyment CBrain RHewett SBlucher L(2015)UNISONProceedings of the 2015 24th Australasian Software Engineering Conference (ASWEC)10.1109/ASWEC.2015.29(203-212)Online publication date: 28-Sep-2015
https://dl.acm.org/doi/10.1109/ASWEC.2015.29
Li MMani MRundensteiner ELin TEyers DEtzion OGal AZdonik SVincent P(2011)Complex event pattern detection over streams with interval-based temporal semanticsProceedings of the 5th ACM international conference on Distributed event-based system10.1145/2002259.2002297(291-302)Online publication date: 11-Jul-2011
https://dl.acm.org/doi/10.1145/2002259.2002297
Singh JEyers DBacon JEyers DEtzion OGal AZdonik SVincent P(2011)Disclosure control in multi-domain publish/subscribe systemsProceedings of the 5th ACM international conference on Distributed event-based system10.1145/2002259.2002283(159-170)Online publication date: 11-Jul-2011
https://dl.acm.org/doi/10.1145/2002259.2002283

Index Terms

Relational database support for event-based middleware functionality

Recommendations

Enhancing functionality of relational database systems
Middleware Support for Pluggable Non-Functional Properties in Wireless Sensor Networks
SERVICES '08: Proceedings of the 2008 IEEE Congress on Services - Part I

Wireless sensor networks (WSN) imposes stringent constraints on efficiency, memory footprint and power consumption. Since the need to satisfy these constraints often results in tightly coupled designs, WSN applications tend to be inflexible; it is hard ...
Relational database: a practical foundation for productivity

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

DEBS '10: Proceedings of the Fourth ACM International Conference on Distributed Event-Based Systems

July 2010

303 pages

ISBN:9781605589275

DOI:10.1145/1827418

Co-chair:
Peter Pietzuch
Imperial College London, UK
,
Conference Chair:
Jean Bacon
University of Cambridge, UK
,
Program Chairs:
Joe Sventek
University of Glasgow, UK
,
Ugur Cetintemel
Brown University, Rhode Island

Copyright © 2010 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 12 July 2010

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

DEBS '10

Sponsor:

DEBS '10: The 4th ACM International Conference on Distributed Event-based Systems

July 12 - 15, 2010

Cambridge, United Kingdom

Acceptance Rates

Overall Acceptance Rate 145 of 583 submissions, 25%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

3
Total Citations
View Citations
424
Total Downloads

Downloads (Last 12 months)6
Downloads (Last 6 weeks)0

Reflects downloads up to 22 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

Docking MUzunov AFiddyment CBrain RHewett SBlucher L(2015)UNISONProceedings of the 2015 24th Australasian Software Engineering Conference (ASWEC)10.1109/ASWEC.2015.29(203-212)Online publication date: 28-Sep-2015
https://dl.acm.org/doi/10.1109/ASWEC.2015.29
Li MMani MRundensteiner ELin TEyers DEtzion OGal AZdonik SVincent P(2011)Complex event pattern detection over streams with interval-based temporal semanticsProceedings of the 5th ACM international conference on Distributed event-based system10.1145/2002259.2002297(291-302)Online publication date: 11-Jul-2011
https://dl.acm.org/doi/10.1145/2002259.2002297
Singh JEyers DBacon JEyers DEtzion OGal AZdonik SVincent P(2011)Disclosure control in multi-domain publish/subscribe systemsProceedings of the 5th ACM international conference on Distributed event-based system10.1145/2002259.2002283(159-170)Online publication date: 11-Jul-2011
https://dl.acm.org/doi/10.1145/2002259.2002283

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents