Abstract
Document stores are frequently used as representation format in many applications. It is often necessary to transform a set of data stored in a relational database (RDB) into a document store. However, it is difficult to evaluate which target document structure is the most appropriate for each scenario. In this article, we present a tool, called QBMetrics (Query-based Metrics), that assists on an RDB to NoSQL document conversion process or even to design a NoSQL database, by calculating a set of query-based metrics for evaluating and comparing the created schemas against a set of existing queries. We represent the schemas and the queries as DAGs (Directed Acyclic Graphs), which are used to calculate the metrics. The metrics allow to evaluate if a given target document schema is adequate to answer the queries. We demonstrate the tool in an RDB to NoSQL conversion scenario, involving the creation of the schemas, queries and the metrics calculation.
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.
The tool is available for download at: https://github.com/evandrokuszera/nosql-query-based-metrics.
References
Freitas, M.C.d., Souza, D.Y., Salgado, A.C.: Conceptual mappings to convert relational into NoSQL databases. In: Proceedings of the 18th ICEIS (2016)
Gómez, P., Roncancio, C., Casallas, R.: Towards Quality Analysis for Document Oriented Bases. In: Trujillo, J.C., et al. (eds.) ER 2018. LNCS, vol. 11157, pp. 200–216. Springer, Cham (2018). https://doi.org/10.1007/978-3-030-00847-5_16
Jia, T., Zhao, X., Wang, Z., Gong, D., Ding, G.: Model transformation and data migration from relational database to MongoDB. In: IEEE BigData, pp. 60–67 (2016)
Karnitis, G., Arnicans, G.: Migration of relational database to document-oriented database: Structure denormalization and data transformation. In: 2015 7th ICCICSN, pp. 113–118 (2015)
Kuszera, E.M., Peres, L.M., Didonet Del Fabro, M.: Query-based metrics for evaluating and comparing document schemas. In: Dustdar, S., Yu, E., Salinesi, C., Rieu, D., Pant, V. (eds.) CAiSE 2020. LNCS, vol. 12127, pp. 530–545. Springer, Cham (2020). https://doi.org/10.1007/978-3-030-49435-3_33
Kuszera, E.M., Peres, L.M., Fabro, M.D.D.: Toward RDB to NoSQL: transforming data with metamorfose framework. In: Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing, pp. 456–463. SAC 2019 (2019)
Sadalage, P.J., Fowler, M.: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, 1st edn. Addison-Wesley Professional, Boston (2012)
Stanescu, L., Brezovan, M., Burdescu, D.D.: Automatic mapping of MySQL databases to NoSQL MongoDB. In: 2016 FedCSIS, pp. 837–840, September 2016
Stonebraker, M., Madden, S., Abadi, D.J., Harizopoulos, S., Hachem, N., Helland, P.: The end of an architectural era (it’s time for a complete rewrite). In: Proceedings of 33rd VLDB, University of Vienna, Austria, 23–27 September 2007, pp. 1150–1160 (2007)
Zhao, G., Lin, Q., Li, L., Li, Z.: Schema conversion model of SQL database to NoSQL. In: 2014 Ninth 3PGCIC, pp. 355–362 (2014)
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Kuszera, E.M., Peres, L.M., Didonet Del Fabro, M. (2020). QBMetrics: A Tool for Evaluating and Comparing Document Schemas. In: Herbaut, N., La Rosa, M. (eds) Advanced Information Systems Engineering. CAiSE 2020. Lecture Notes in Business Information Processing, vol 386. Springer, Cham. https://doi.org/10.1007/978-3-030-58135-0_7
Download citation
DOI: https://doi.org/10.1007/978-3-030-58135-0_7
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-58134-3
Online ISBN: 978-3-030-58135-0
eBook Packages: Computer ScienceComputer Science (R0)