Abstract
To handle data variety in one project, some researchers proposed using multiple databases or one multi-model database to manage various data. However, considering that the predominated Relational Database Management Systems (RDBMSs) in the current market have powerful capabilities such as query optimization and transaction management, we propose using an RDBMS as a unified platform to store and query multi-model data. But the mismatch between the complexity of multi-model data structure and the simplicity of flat relational tables imposes a grand challenge. To address this challenge, we adopt the reinforcement learning method to design a workload-aware approach that could directly learn a relational schema to store multi-model data by interacting with an RDBMS with the given queries and data. To choose the right actions in the learning process, we propose a variant Q-learning algorithm (Double Q-tables) along with functions for updating the tables, which could reduce the dimension of the original Q-table and improve learning efficiency. Experimental results show that our approach could generate a relational schema with superior performance in terms of query response time and storage space cost over a multi-model storage schema.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
What is a multi-model database and why use it? [white paper]. ArangoDB (2020). www.arangodb.com/resources/white-paper/multi-model-database/
Bellman, R.E.: Dynamic programming (1957)
Chasseur, C., Li, Y., Patel, J.M.: Enabling json document stores in relational systems. In: WebDB, vol. 13, pp. 14–15 (2013)
Copeland, G.P., Khoshafian, S.N.: A decomposition storage model. ACM SIGMOD Rec. 14(4), 268–279 (1985)
Florescu, D., Kossmann, D.: Storing and querying XML data using an RDMBS. IEEE Data Eng. Bull. 22, 3 (1999)
Lu, J., Holubová, I.: Multi-model databases: a new journey to handle the variety of data. ACM Comput. Surv. (CSUR) 52(3), 1–38 (2019)
Yuan, G., Lu, J.: MORTAL: a tool of automatically designing relational storage schemas for multi-model data through reinforcement learning. In: Proceedings of the ER Demos and Posters 2021, CEUR Workshop Proceedings, vol. 2958, pp. 7–12. CEUR-WS.org (2021)
Yuan, G., Lu, J., Zhang, S., Yan, Z.: Storing multi-model data in RDBMSs based on reinforcement learning. In: Proceedings of the 30th ACM International Conference on Information and Knowledge Management. ACM (2021)
Acknowledgements
The work is partially supported by the China Scholarship Council and the Academy of Finland project (No. 310321). We would also like to thank all the reviewers for their valuable comments and helpful suggestions.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Yuan, G., Lu, J., Yan, Z. (2022). Effective Generation of Relational Schema from Multi-Model Data with Reinforcement Learning. In: Ralyté, J., Chakravarthy, S., Mohania, M., Jeusfeld, M.A., Karlapalem, K. (eds) Conceptual Modeling. ER 2022. Lecture Notes in Computer Science, vol 13607. Springer, Cham. https://doi.org/10.1007/978-3-031-17995-2_16
Download citation
DOI: https://doi.org/10.1007/978-3-031-17995-2_16
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-17994-5
Online ISBN: 978-3-031-17995-2
eBook Packages: Computer ScienceComputer Science (R0)