Abstract
In recent years, a lot of variety of Database Management Systems have been created. Despite of the considerable progress in this area, the most popular are still relational databases (RDB). Designing a relational database requires a lot of experience - not only in computer science. The initial database structure depends on the current customer expectations. These expectations, however, change during operation of the application. Changes in the application usually lead to changes of table structures or field types in the working database. This induce the use of redundant storage space on unneeded data or loss of data archives. The article presents the concept of flexible structures in relational databases. These structures enable the implementation of inheritance, creation of polymorphic tuples within one entity, and the creation of attributes with a variable type of value. Along with the description of structures, a modified version of SQL queries that operate on these structures was proposed.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Stonebraker, M., Rowe, L.A.: The POSTGRES data model (PDF). In: Proceedings of the 13th International Conference on Very Large Data Bases, pp. 83–96. Morgan Kaufmann, Brighton (1987). ISBN 0-934613-46-X
Ambler, S.W.: Agile Database Techniques: Effective Strategies for the Agile Software Developer, pp. 223–268. Wiley, Indianapolis (2003). ISBN-13: 978-0471202837
Dykstra, T., Anderson, R., Schonning, N., Addie, S., Parente, J., Pasic, A., Warren, G., Latham, L.: Implementing Inheritance with the Entity Framework 6 in an ASP.NET MVC 5 Application (11 of 12), (AspNetDocs) (2015)
King, G., Bauer, C., Andersen, M.R., Bernard, E., Ebersole, S.: Hibernate ORM documentation (5.0), Chapter 9. Inheritance mapping, Red Hat, Inc (2015)
Sun, W., Guo, S., Arafi, F.: Supporting inheritance in relational database systems. In: Proceedings Fourth International Conference on Software Engineering and Knowledge Engineering, Capri, Italy, pp. 511–518 (1992). https://doi.org/10.1109/seke.1992.227910
Gottlob, G., Schrefl, M., Stumptner, M.: Selective inheritance of attribute values in relational databases. Discrete Appl. Math. 40, 187–216 (1992). https://doi.org/10.1016/0166-218X(92)90029-A
Awang, M.K.: Transfering object oriented data model to relational data model. Int. J. New Comput. Architectures Appl. (IJNCAA) 3, 403–410 (2012)
Pokrajac, D., Patel, H., Rasamny, M.: Inheritance constraints implementation in PostrgreSQL (2004)
Alashqur, A., Su, S.Y.W., Lam, H.: OQL: A query language for manipulating object-oriented databases. In: International Conference on Very Large Data Bases, pp. 433–442 (1989)
Assaf, M.A., Badr, Y., Barbar, K., Amghar, Y.: AQL: A Declarative Artifact Query Language, pp. 119–133 (2016). https://doi.org/10.1007/978-3-319-44039-2_9
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Pokuta, W. (2020). The Concept of a Flexible Database - Implementation of Inheritance and Polymorphism. In: Borzemski, L., Świątek, J., Wilimowska, Z. (eds) Information Systems Architecture and Technology: Proceedings of 40th Anniversary International Conference on Information Systems Architecture and Technology – ISAT 2019. ISAT 2019. Advances in Intelligent Systems and Computing, vol 1050. Springer, Cham. https://doi.org/10.1007/978-3-030-30440-9_12
Download citation
DOI: https://doi.org/10.1007/978-3-030-30440-9_12
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-30439-3
Online ISBN: 978-3-030-30440-9
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)