Skip to main content
SpringerLink
Log in
Book cover

British International Conference on Databases

BICOD 2017: Data Analytics pp 49–61Cite as

Database Processes for Application Integration

  • Conference paper
  • First Online:

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

Abstract

Recent technology trends such as Cloud and Mobile Computing generate huge amounts of heterogeneous data to be processed by business and analytic applications. Currently, the data is stored in (relational) databases, before being queried by these applications. The heterogeneity of sender and application formats requires integration processes for decoupling sender from receiver (i. e., no shared schema), routing (i. e., “which application receives which parts of the data?”) and format transformations. We argue that this kind of database (integration) process does not exist and propose a suitable processing model that fits the general integration semantics. The analysis is conducted for a real-world integration scenario on a well-established relational database system.

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.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

Notes

  1. 1.

    e. g., SAP “Vehicles Insights”, visited 04/2017: https://www.sap.com/product/analytics/vehicle-insights.html.

References

  1. Act-Net Consortium, C.: The active database management system manifesto: a rulebase of ADBMS features. SIGMOD 25(3), 40–49 (1996)

    Article  Google Scholar 

  2. Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Comput. Surv. 18(4), 323–364 (1986)

    Article  Google Scholar 

  3. Bernstein, P.A., Newcomer, E.: Principles of Transaction Processing. Morgan Kaufmann, Burlington (2009)

    MATH  Google Scholar 

  4. Böhm, A., Kanne, C.: Demaq/transscale: automated distribution and scalability for declarative applications. Inf. Syst. 36(3), 565–578 (2011)

    Article  Google Scholar 

  5. Cafarella, M.J., Halevy, A., Khoussainova, N.: Data integration for the relational web. VLDB 2(1), 1090–1101 (2009)

    Google Scholar 

  6. Carney, D., Çetintemel, U., Rasin, A., Zdonik, S.B., Cherniack, M., Stonebraker, M.: Operator scheduling in a data stream manager. In: VLDB, pp. 838–849 (2003)

    Google Scholar 

  7. Gawlick, D., Mishra, S.: Information sharing with the oracle database. In: DEBS (2003)

    Google Scholar 

  8. Haas, L.M., Kossmann, D., Wimmers, E.L., Yang, J.: Optimizing queries across diverse data sources. In: VLDB, pp. 276–285 (1997)

    Google Scholar 

  9. Härder, T., Meyer-Wegener, K., Mitschang, B., Sikeler, A.: Prima - a DBMS prototype supporting engineering applications. In: VLDB (1987)

    Google Scholar 

  10. Hergula, K.: Daten- und Funktionsintegration durch föderierte Datenbanksysteme. Ph.D. thesis, University of Kaiserslautern (2003)

    Google Scholar 

  11. Hohpe, G., Woolf, B., Patterns, E.I.: Designing, Building, and Deploying Messaging Solutions. Addison-Wesley Longman, Boston (2003)

    Google Scholar 

  12. Ibsen, C., Anstey, J.: Camel in Action (2010)

    Google Scholar 

  13. Linthicum, D.S.: Enterprise Application Integration. Addison-Wesley, Boston (2000)

    Google Scholar 

  14. Reimann, P., Schwarz, H., et al.: Datenmanagementpatterns in simulationsworkflows. In: BTW, pp. 279–293 (2013)

    Google Scholar 

  15. Ritter, D.: What about database-centric enterprise application integration? In: ZEUS (2014)

    Google Scholar 

  16. Ritter, D.: Towards more data-aware application integration. In: Maneth, S. (ed.) BICOD 2015. LNCS, vol. 9147, pp. 16–28. Springer, Cham (2015). doi:10.1007/978-3-319-20424-6_3

    Chapter  Google Scholar 

  17. Ritter, D., May, N., Rinderle-Ma, S.: Patterns for emerging application integration scenarios: a survey. Inf. Syst. 67, 36–57 (2017)

    Article  Google Scholar 

  18. Ritter, D., May, N., Sachs, K., Rinderle-Ma, S.: Benchmarking integration pattern implementations. In: DEBS, pp. 125–136 (2016)

    Google Scholar 

  19. Ritter, D., Sosulski, J.: Exception handling in message-based integration systems and modeling using BPMN. Int. J. Coop. Inf. Syst. 25, 1–38 (2016)

    Article  Google Scholar 

  20. Russell, N., Hofstede, A.H.M., Edmond, D., der Aalst, W.M.P.: Workflow data patterns: identification, representation and tool support. In: Delcambre, L., Kop, C., Mayr, H.C., Mylopoulos, J., Pastor, O. (eds.) ER 2005. LNCS, vol. 3716, pp. 353–368. Springer, Heidelberg (2005). doi:10.1007/11568322_23

    Chapter  Google Scholar 

  21. Vrhovnik, M., Schwarz, H., Suhre, O., Mitschang, B., Markl, V., Maier, A., Kraft, T.: An approach to optimize data processing in business processes. In: VLDB, pp. 615–626 (2007)

    Google Scholar 

Download references

Acknowledgments

We thank Dr Fredrik Nordvall Forsberg and Dr Norman May for valuable comments and discussions.

Author information

Authors and Affiliations

  1. Faculty of Computer Science, University of Vienna, Vienna, Austria

    Daniel Ritter

Authors
  1. Daniel Ritter
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Daniel Ritter .

Editor information

Editors and Affiliations

  1. Birkbeck, University of London, London, United Kingdom

    Andrea Calì

  2. Birkbeck, University of London, London, United Kingdom

    Peter Wood

  3. Birkbeck, University of London, London, United Kingdom

    Nigel Martin

  4. Birkbeck, University of London, London, United Kingdom

    Alexandra Poulovassilis

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Ritter, D. (2017). Database Processes for Application Integration. In: Calì, A., Wood, P., Martin, N., Poulovassilis, A. (eds) Data Analytics. BICOD 2017. Lecture Notes in Computer Science(), vol 10365. Springer, Cham. https://doi.org/10.1007/978-3-319-60795-5_5

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-60795-5_5

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-60794-8

  • Online ISBN: 978-3-319-60795-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation