A Universal Cuboid-Based Integration Architecture for Polyglotic Querying of Heterogeneous Datasources
Fortunately, the industry has eventually abandoned the old “one-size fits all” relational dream and started to develop task-oriented storage solutions. Nowadays, in a big project a devotion to a single persistence mechanism usually leads to suboptimal architectures. A combination of appropriate storage engines is often the best solution. However, such a combination implies a significant growth of data integrity maintenance. In this paper we describe a solution to this problem, i.e. a cuboid-based universal integration architecture. It allows hiding the peculiarities of integration so that it is transparent to the application programmer. We use graphs as an example of data that needs a task-oriented database in order to be efficiently processed. We show how graph queries can be effectively executed with the help of a graph database assisting a relational database. The proposed solution does not impose any additional complexity for programmers.
Unable to display preview. Download preview PDF.
- 4.Chromiak, M., Stencel, K.: A data model for heterogeneous data integration architecture. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B. (eds.) BDAS 2014. CCIS, vol. 424, pp. 547–556. Springer, Heidelberg (2014), http://dx.doi.org/10.1007/978-3-319-06932-6_53 CrossRefGoogle Scholar
- 5.Chromiak, M., Wisniewski, P., Stencel, K.: Exploiting order dependencies on primary keys for optimization. In: Proceedings of the 23rd International Workshop on Concurrency, Specification and Programming, Chemnitz, Germany, September 29 - October 1, pp. 58–68 (2014), http://ceur-ws.org/Vol-1269/paper58.pdf (accessed: February 06, 2015)
- 6.Cloudkick: 4 months with Cassandra, a love story (March 2010), https://www.cloudkick.com/blog/2010/mar/02/4_months_with_cassandra/ (accessed: November 12, 2013)
- 9.Hunger, M.: Load csv with success (2014), http://jexp.de/blog/2014/10/load-cvs-with-success/(accessed: February 06, 2015)
- 10.Neo4j: Load csv into neo4j quickly and successfully (2014), http://jexp.de/blog/2014/06/load-csv-into-neo4j-quickly-and-successfully/ (accessed: February 06, 2015)
- 13.Przymus, P., Boniewicz, A., Burzańska, M., Stencel, K.: Recursive query facilities in relational databases: A survey. In: FGIT-DTA/BSBT, pp. 89–99 (2010)Google Scholar
- 14.Szumowska, A., Burzańska, M., Wiśniewski, P., Stencel, K.: Efficient implementation of recursive queries in major object relational mapping systems. In: Kim, T.-h., Adeli, H., Slezak, D., Sandnes, F.E., Song, X., Chung, K.-i., Arnett, K.P. (eds.) FGIT 2011. LNCS, vol. 7105, pp. 78–89. Springer, Heidelberg (2011)CrossRefGoogle Scholar
- 16.Van Bruggen, R.: Learning Neo4j. Packt, Birmingham (2014)Google Scholar
- 17.Wiśniewski, P., Szumowska, A., Burzańska, M., Boniewicz, A.: Hibernate the recursive queries - defining the recursive queries using Hibernate ORM. In: ADBIS (2), pp. 190–199 (2011)Google Scholar