Abstract
Graph databases have been developed to meet data persistence requirements, notably from social networks. They are, like the other NoSQL databases, often schemaless. This paper describes an incremental approach deriving a conceptual model from a graph database by analyzing a Cypher flow of queries. This reverse engineering approach embeds three main contributions: (1) a set of transformation rules of Cypher queries into chunks of conceptual schemas, (2) an incremental approach based on these rules, (3) an illustration on an example. This contribution enables, from a Cypher code, to generate a conceptual model that will facilitate the evolution of the existing graph database. This research is part of a project aiming at building an environment enabling round-trip engineering of relational and NoSQL databases.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Klettke, M., Störl, U., Scherzinger, S.: Schema extraction and structural outlier detection for JSON-based NoSQL data stores. Datenbanksysteme für Business, Technologie und Web (BTW 2015) (2015)
Vera, H., Wagner Boaventura, M.H., Holanda, M., Guimaraes, V., Hondo, F.: Data modeling for NoSQL document oriented databases. In: CEUR Workshop Proceeding, pp. 129–135 (2015)
Banerjee, S., Sarkar, A.: Logical level design of NoSQL databases. In: IEEE Region 10 Conference (TENCON) (2016)
Aggarwal, D., Davis, K.C.: Employing graph databases as a standardization model towards addressing heterogeneity. In: 17th International Conference on Information Reuse and Integration. IEEE (2016)
Daniel, G., Sunyé, G., Cabot, J.: UMLtoGraphDB: mapping conceptual schemas to graph databases. In: Comyn-Wattiau, I., Tanaka, K., Song, I.-Y., Yamamoto, S., Saeki, M. (eds.) ER 2016. LNCS, vol. 9974, pp. 430–444. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-46397-1_33
Abdelhedi, F., Ait Brahim, A., Atigui, F., Zurfluh, G.: Logical unified modeling for NoSQL DataBases. In: 19th International Conference on Enterprise Information Systems (ICEIS 2017), Porto, Portugal, pp. 249–256, April 2017
Li, Y., Gu, P., Zhang, C.: Transforming UML class diagrams into HBase based on meta-model. In: International Conference on Information Science, Electronics & Electrical Engineering, pp. 720–724 (2014)
Chevalier, M., El Malki, M., Kopliku, A., Teste, O., Tournier, R.: Implementation of multidimensional databases with document-oriented NoSQL. In: Madria, S., Hara, T. (eds.) DaWaK 2015. LNCS, vol. 9263, pp. 379–390. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-22729-0_29
Sevilla Ruiz, D., Morales, S.F., García Molina, J.: Inferring versioned schemas from NoSQL databases and its applications. In: Johannesson, P., Lee, M.L., Liddle, S.W., Opdahl, A.L., Pastor López, Ó. (eds.) ER 2015. LNCS, vol. 9381, pp. 467–480. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-25264-3_35
Lamhaddab, K., Elbaamrani, K.: Model driven reverse engineering: graph modeling for mobiles platforms. In: 15th International Conference on Intelligent Systems DeSign and Applications (ISDA) (2015)
Comyn-Wattiau, I., Akoka, J.: Model driven reverse engineering of NoSQL property graph databases: the case of Neo4j. In: 2017 IEEE International Conference on Big Data (Big Data), Boston, MA, pp. 453–458 (2017)
Demeyer, S., Ducasse, S., Tichelaar, S.: Why unified is not universal. In: France, R., Rumpe, B. (eds.) UML 1999. LNCS, vol. 1723, pp. 630–644. Springer, Heidelberg (1999). https://doi.org/10.1007/3-540-46852-8_44
Kellokoski, P.: Round-trip engineering. MA thesis, University of Tampere, Finland ((2000))
Akoka, J., Comyn-Wattiau, I.: Roundtrip engineering of NoSQL databases. Enterp. Model. Inf. Syst. Archit. (EMISAJ) 13, 281–292 (2018)
Angles, R., Gutierrez, C.: Survey of graph database models. ACM Comput. Surv. (CSUR) 40(1), 1 (2008)
Wood, P.T.: Query languages for graph databases. ACM SIGMOD Rec. 41(1), 50–60 (2012)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Comyn-Wattiau, I., Akoka, J. (2019). Query-Based Reverse Engineering of Graph Databases – From Program to Model. In: Welzer, T., et al. New Trends in Databases and Information Systems. ADBIS 2019. Communications in Computer and Information Science, vol 1064. Springer, Cham. https://doi.org/10.1007/978-3-030-30278-8_22
Download citation
DOI: https://doi.org/10.1007/978-3-030-30278-8_22
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-30277-1
Online ISBN: 978-3-030-30278-8
eBook Packages: Computer ScienceComputer Science (R0)