Abstract
In big data contexts, the performance of relational databases can get overwhelmed, usually by numerous concurrent connections over large volumes of data. In these cases, the support of ACID transactions is dropped in favour of NoSQL data stores, which offer quick responses and high data availability. Although NoSQL systems solve this concrete performance problem, they also present some issues. For instance, the NoSQL spectrum covers a wide range of database paradigms, such as key-value, column-oriented or document stores. These paradigms differ too much from the relational model, provoking that it is not possible to make use of existent, well-known practices from relational database design. Moreover, the existence of that paradigm heterogeneity makes difficult the definition of general design practices for NoSQL data stores. We present Mortadelo, a framework devised for the automatic design of NoSQL databases. Mortadelo offers a model-driven transformation process, which starts from a technology-agnostic data model and provides an automatically generated design and implementation for the desired NoSQL data store. The main strength of our framework is its generality, i.e., Mortadelo can be extended to support any kind of NoSQL database. The validity of our approach has been checked through the implementation of a tool, which currently supports the generation of column family data stores and offers preliminary support of document-based ones.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Agrawal, S., Chaudhuri, S., Narasayya, V.: Automated selection of materialized views and indexes in SQL databases. In: 26th Conference on Very Large Data Bases, pp. 496–505 (2000)
Alur, N.: IBM Infosphere Datastage Data Flow and Job Design. Vervante (2008)
Atzeni, P., Bugiotti, F., et al.: Data Modeling in the NoSQL World. Comput. Stand. Interfaces (2016)
Atzeni, P., Bugiotti, F., Rossi, L.: Uniform access to NoSQL systems. Inf. Syst. 43, 117–133 (2014)
Carpenter, J., Hewitt, E.: Cassandra: The Definitive Guide: Distributed Data at Web Scale. O’Reilly, Modesto (2016)
Cattell, R.: Scalable SQL and NoSQL Data Stores. SIGMOD Records 39(4), 12–27 (2011)
Chandra, D.G.: BASE analysis of NoSQL database. Futur. Gener. Comput. Syst. 52, 13–21 (2015)
Chebotko, A., Kashlev, A., Lu, S.: A big data modeling methodology for apache Cassandra. In: International Congress on Big Data, pp. 238–245. IEEE (2015)
Chen, P.P.S.: The entity relationship model – toward a unified view of data. ACM Trans. Database Syst. 1(1), 9–36 (1976)
Chodorow, K.: MongoDB: The Definitive Guide: Powerful and Scalable Data Storage. O’Reilly Media, Sebastopol (2013)
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
Eysholdt, M., Behrens, H.: Xtext: implement your language faster than the quick and dirty way. In: 25th Annual Conference on Object-Oriented Programming, Systems, Languages, and Applications, pp. 307–309 (2010)
Gessert, F.: NoSQL database systems: a survey and decision guidance. Comput. Sci. Res. Dev. 32(3), 353–365 (2017)
Haerder, T., Reuter, A.: Principles of transaction-oriented database recovery. ACM Comput. Surv. 15, 287–317 (1983)
Hecht, R., Jablonski, S.: NoSQL evaluation: a use case oriented survey. In: International Conference on Cloud and Service Computing (CSC), pp. 336–341. IEEE (2011)
Herrero, V., Abelló, A., Romero, O.: NOSQL design for analytical workloads: variability matters. In: Comyn-Wattiau, I., Tanaka, K., Song, I.-Y., Yamamoto, S., Saeki, M. (eds.) ER 2016. LNCS, vol. 9974, pp. 50–64. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-46397-1_4
Hills, T.: NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software. Technics Publications, Basking Ridge (2016)
Kleppe, A.: Software Language Engineering: Creating Domain-Specific Languages Using Metamodels. Addison-Wesley Professional, Upper Saddle River (2008)
Li, C.: Transforming relational database into HBase: a case study. In: IEEE International Conference on Software Engineering and Service Sciences. pp. 683–687, July 2010
Li, L., Zhao, X.: UML specification and relational database. J. Object Technol. 2(5), 87–100 (2003)
Mior, M.J., Salem, K.: NoSE: schema design for NoSQL applications. IEEE Trans. Knowl. Data Eng. 29(10), 2275–2289 (2017)
Rose, L.M., Paige, R.F., Kolovos, D.S., Polack, F.A.C.: The epsilon generation language. In: Schieferdecker, I., Hartman, A. (eds.) ECMDA-FA 2008. LNCS, vol. 5095, pp. 1–16. Springer, Heidelberg (2008). https://doi.org/10.1007/978-3-540-69100-6_1
Steinberg, D., Budinsky, F., Paternostro, M., Merks, E.: EMF: Eclipse Modeling Framework, 2nd edn. Addison-Wesley Professional, Reading (2009)
Vajk, T., Fehr, P., et al.: Denormalizing data into schema-free databases. In: 4th International Conference on Cognitive Infocommunications, pp. 747–752. IEEE (2013)
Walker, S.J.: Big data: a revolution that will transform how we live, work, and think. Int. J. Advert. 33(1), 181–183 (2014)
Acknowledgements
This work has been partially funded by the Government of Cantabria (Spain) under the doctoral studentship program from the University of Cantabria, and by the Spanish Government under grant TIN2014-56158-C4-2-P (M2C2) and TIN2017-86520-C3-3_R.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Switzerland AG
About this paper
Cite this paper
de la Vega, A., García-Saiz, D., Blanco, C., Zorrilla, M., Sánchez, P. (2018). Mortadelo: A Model-Driven Framework for NoSQL Database Design. In: Abdelwahed, E., Bellatreche, L., Golfarelli, M., Méry, D., Ordonez, C. (eds) Model and Data Engineering. MEDI 2018. Lecture Notes in Computer Science(), vol 11163. Springer, Cham. https://doi.org/10.1007/978-3-030-00856-7_3
Download citation
DOI: https://doi.org/10.1007/978-3-030-00856-7_3
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-00855-0
Online ISBN: 978-3-030-00856-7
eBook Packages: Computer ScienceComputer Science (R0)