Abstract
Data storage, in various SQL and NoSQL systems brings complexity to data querying when entities are fragmented because data is not always stored in the same system, plus heterogeneous structures can appear for entities. A unique query language is not sufficient to address data distribution and heterogeneity. Considering vertically distributed data, this work implements a framework capable of rewriting a user query addressed over a unified view to access all data and provide results with transparency. Our framework works with a conceptual model producing unified views to guarantee polystore querying without having to know data distribution nor data heterogeneity. It complements the initial query with intermediate operations. It is applied on an e-commerce scenario (UniBench benchmark) distributed vertically between relational and document-oriented databases. Performance results and the low impact of query rewriting process are illustrated in this work.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Kolev, B., Valduriez, P., Bondiombouy, C., et al.: CloudMdsQL: querying heterogeneous cloud data stores with a common language. Distrib. Parallel Datab. 34, 463–503 (2016)
Bogyeong, K., Kyoseung, K., Undraa, E., Sohyun, K., Juhun, K., Bongki, M.: M2Bench: a database benchmark for multi-model analytic workloads. PVLDB 16(4), 747–759 (2022)
Duggan, J., Elmore, A.J., Stonebraker, M., et al.: The bigdawg polystore system. ACM Sigmod Rec. 44(2), 11–16 (2015)
Karnitis, G., Arnicans, G.: Migration of relational database to document-oriented database: Structure denormalization and data transformation. In: 7th International Conference on Computational Intelligence, Communication Systems and Networks, pp. 113–118. IEEE (2015)
Candel, C.J.F., Ruiz, D.S., García-molina, J.J.: A unified metamodel for NoSQL and relational databases. Inf. Syst. 104, 101898 (2022)
Barret, N., Manolescu, I., Upadhyay, P.: Abstra: toward generic abstractions for data of any model. In: 31st ACM International Conference on Information & Knowledge Management, pp. 4803–4807 (2022)
Ben Hamadou, H., Gallinucci, E., Golfarelli, M.: Answering GPSJ queries in a polystore: a dataspace-based approach. In: Laender, A.H.F., Pernici, B., Lim, E.-P., de Oliveira, J.P.M. (eds.) ER 2019. LNCS, vol. 11788, pp. 189–203. Springer, Cham (2019). https://doi.org/10.1007/978-3-030-33223-5_16
Hai, R., Quix, C., Zhou, C.: Query rewriting for heterogeneous data lakes. In: Benczúr, A., Thalheim, B., Horváth, T. (eds.) ADBIS 2018. LNCS, vol. 11019, pp. 35–49. Springer, Cham (2018). https://doi.org/10.1007/978-3-319-98398-1_3
Papakonstantinou, Y.: Polystore query rewriting: the challenges of variety. In: EDBT/ICDT Workshops (2016)
Gobert, M., Meurice, L., Cleve, A.: HyDRa a framework for modeling, manipulating and evolving hybrid polystores. In: IEEE International Conference on Software Analysis, Evolution and Reengineering (SANER), pp. 652–656. IEEE (2022)
Zhang, C., Lu, J., Xu, P., Chen, Y.: UniBench: a benchmark for multi-model database management systems. In: Proceedings of the Technology Conference on Performance Evaluation and Benchmarking (TPCTC 2018), Rio de Janeiro, Brazil, pp. 7–23 (2018)
Forresi, C., Gallinucci, E., Golfarelli, M., Hamadou, H.B.: A dataspace-based framework for OLAP analyses in a high-variety multistore. VLDB J. 30(6), 1017–1040 (2021). https://doi.org/10.1007/s00778-021-00682-5
Acknowledgments
This work was supported by the French Gov. in the framework of the Territoire d’Innovation program, an action of the Grand Plan d’Investissement backed by France 2030, Toulouse Métropole and the GIS neOCampus.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
El Ahdab, L., Teste, O., Megdiche, I., Peninou, A. (2023). Unified Views for Querying Heterogeneous Multi-model Polystores. In: Wrembel, R., Gamper, J., Kotsis, G., Tjoa, A.M., Khalil, I. (eds) Big Data Analytics and Knowledge Discovery. DaWaK 2023. Lecture Notes in Computer Science, vol 14148. Springer, Cham. https://doi.org/10.1007/978-3-031-39831-5_29
Download citation
DOI: https://doi.org/10.1007/978-3-031-39831-5_29
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-39830-8
Online ISBN: 978-3-031-39831-5
eBook Packages: Computer ScienceComputer Science (R0)