Skip to main content

Reweaving the Tapestry: Integrating Database and Messaging Systems in the Wake of New Middleware Technologies

  • Chapter

Part of the Lecture Notes in Computer Science book series (LNISA,volume 3551)

Abstract

Modern business applications involve a lot of distributed data processing and inter-site communication, for which they rely on middleware products. These products provide the data access and communication framework for the business applications.

Integrated messaging seeks to integrate messaging operations into the database, so as to provide a single API for data processing and messaging. Client applications will be much easier to write, because all the logic of sending and receiving messages is within the database. System configuration, application deployment, and message warehousing are simplified, because we don’t have to manage and fine-tune multiple products.

Integrating messaging into a database also provides features like backup, restore, transactionality & recoverability to messages. In this paper, we’ll look at some aspects of messaging systems, and the challenges involved in integrating messaging such as message delivery semantics, transaction management and impact on query processing.

Keywords

  • Database System
  • Messaging Data
  • Messaging System
  • Message Queue
  • User Transaction

These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (Canada)
  • 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. Behm, A., Rielau, S., Swagerman, R.: Returning Modified Rows—SELECT Statements with Side Effects. In: VLDB 2004, Toronto, Canada (September 2004)

    Google Scholar 

  2. BEA Weblogic Platform, http://www.bea.com/

  3. Gawlick, D., Mishra, S.: Information sharing with the Oracle database. In: Jacobsen, H.-A. (ed.) 2nd Intl. Workshop on Distributed Event-Based Systems (DEBS 2003), San Diego, CA, USA, June 2003, ACM Press, New York (2003)

    Google Scholar 

  4. Brown, D.H.: Associates, IBM WebSphere Application Server, Version 6 Delivers Business Flexibility. White Paper (September 2004), http://www-306.ibm.com/software/webservers/appserv/was/WAS_V6_DH_Brown.pdf

  5. Gray, J.: The Next Database Revolution. In: Proc. of the ACM SIGMOD Int. Conf. on Management of Data, Paris, France, June 13-18 (2004)

    Google Scholar 

  6. Gray, J.: THESIS: Queues are Databases (January 1995), http://research.microsoft.com/research/pubs/view.aspx?pubid=496

  7. Java 2 Platform, Enterprise Edition (J2EE), http://java.sun.com/j2ee/

  8. Hanlon, M., Klein, J., Linden, R.V., Zeller, H.: Publish/Subscribe in NonStop SQL: Transactional Streams in a Relational Context. In: 20th International Conference on Data Engineering, Boston, Massachusetts (April 2004)

    Google Scholar 

  9. Microsoft .NET, http://www.microsoft.com/net/

  10. Natis, Y. V.: Gartner: Predicts 2004: Application Integration and Middleware (December 2003), http://ww4.gartner.com/resources/119000/119085/119085.pdf

  11. IBM DB2 UDB Manuals: How to use WebSphere MQ functions within DB2, http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.ii.doc/ad/ciiwsmqf.htm

  12. J2EE Java Message Service (JMS), http://java.sun.com/products/jms/

  13. Sonic Software, http://www.sonicsoftware.com/products/sonicmq/index.ssp

  14. Sybase Real-Time Data Services, http://www.sybase.com/products/informationmanagement/realtimedataservices

  15. TIBCO Messaging Solutions, http://www.tibco.com/software/enterprise_backbone/messaging.jsp

  16. Web Services Activity, http://www.w3.org/2002/ws/

  17. WebSphere Application server V6.0, http://www-306.ibm.com/software/webservers/appserv/was/

  18. WebSphere Information Integrator, http://www-306.ibm.com/software/data/integration/

  19. WebSphere MQ, http://www-306.ibm.com/software/integration/wmq/

  20. Wolter, R.: A First Look at SQL Server 2005 Service Broker (July 2004), http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlsvcbroker.asp

  21. X/Open, CAE Specification; Distributed Transaction Processing: The XA Specification, http://www.opengroup.org/onlinepubs/009680699/toc.pdf110

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Doraiswamy, S. et al. (2005). Reweaving the Tapestry: Integrating Database and Messaging Systems in the Wake of New Middleware Technologies. In: Härder, T., Lehner, W. (eds) Data Management in a Connected World. Lecture Notes in Computer Science, vol 3551. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11499923_6

Download citation

  • DOI: https://doi.org/10.1007/11499923_6

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-26295-4

  • Online ISBN: 978-3-540-31654-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics