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.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
e. g., SAP “Vehicles Insights”, visited 04/2017: https://www.sap.com/product/analytics/vehicle-insights.html.
References
Act-Net Consortium, C.: The active database management system manifesto: a rulebase of ADBMS features. SIGMOD 25(3), 40–49 (1996)
Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Comput. Surv. 18(4), 323–364 (1986)
Bernstein, P.A., Newcomer, E.: Principles of Transaction Processing. Morgan Kaufmann, Burlington (2009)
Böhm, A., Kanne, C.: Demaq/transscale: automated distribution and scalability for declarative applications. Inf. Syst. 36(3), 565–578 (2011)
Cafarella, M.J., Halevy, A., Khoussainova, N.: Data integration for the relational web. VLDB 2(1), 1090–1101 (2009)
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)
Gawlick, D., Mishra, S.: Information sharing with the oracle database. In: DEBS (2003)
Haas, L.M., Kossmann, D., Wimmers, E.L., Yang, J.: Optimizing queries across diverse data sources. In: VLDB, pp. 276–285 (1997)
Härder, T., Meyer-Wegener, K., Mitschang, B., Sikeler, A.: Prima - a DBMS prototype supporting engineering applications. In: VLDB (1987)
Hergula, K.: Daten- und Funktionsintegration durch föderierte Datenbanksysteme. Ph.D. thesis, University of Kaiserslautern (2003)
Hohpe, G., Woolf, B., Patterns, E.I.: Designing, Building, and Deploying Messaging Solutions. Addison-Wesley Longman, Boston (2003)
Ibsen, C., Anstey, J.: Camel in Action (2010)
Linthicum, D.S.: Enterprise Application Integration. Addison-Wesley, Boston (2000)
Reimann, P., Schwarz, H., et al.: Datenmanagementpatterns in simulationsworkflows. In: BTW, pp. 279–293 (2013)
Ritter, D.: What about database-centric enterprise application integration? In: ZEUS (2014)
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
Ritter, D., May, N., Rinderle-Ma, S.: Patterns for emerging application integration scenarios: a survey. Inf. Syst. 67, 36–57 (2017)
Ritter, D., May, N., Sachs, K., Rinderle-Ma, S.: Benchmarking integration pattern implementations. In: DEBS, pp. 125–136 (2016)
Ritter, D., Sosulski, J.: Exception handling in message-based integration systems and modeling using BPMN. Int. J. Coop. Inf. Syst. 25, 1–38 (2016)
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
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)
Acknowledgments
We thank Dr Fredrik Nordvall Forsberg and Dr Norman May for valuable comments and discussions.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)