Abstract
Nowadays, one of the most important problems of software engineering continues to be the maintenance of both databases and applications. It is clear that any method that can reduce the impact that database modifications produce on application programs is valuable for software engineering processes. We have proposed such a method, by means of a database evolution architecture (MeDEA) that makes use of database views. By using views, changes in the structure of the database schema can be delayed until absolutely necessary. However, some conditions oblige modifications to be made. In this paper we present an approach to detect when the restructuring process must be realized and how to carry out this restructuring process.
This work has been partially supported by the Ministry of Science and Innovation, project TIN2009-13584, by the Ministry of Industry, Tourism and Commerce, project LISBioBank (TSI-020302-2008-8) and by the Government of Aragon, project LIS (PI108/08).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Dayal, U., Bernstein, P.A.: On the Correct Translation of Update Operations on Relational Views. ACM Transactions on Database Systems 7(3), 381–416 (1982)
Domínguez, E., Lloret, J., Rubio, A.L., Zapata, M.A.: MeDEA: A database evolution architecture with traceability. Data & Knowledge Engin. 65(3), 419–441 (2008)
Domínguez, E., Lloret, J., Rubio, A.L., Zapata, M.A.: Model–Driven, View–Based Evolution of Relational Databases. In: Bhowmick, S.S., Küng, J., Wagner, R. (eds.) DEXA 2008. LNCS, vol. 5181, pp. 822–836. Springer, Heidelberg (2008)
Domínguez, E., Lloret, J., Rubio, A.L., Zapata, M.A.: Stones falling in water: When and how to restructure a view–based relational database (2010) (extended version), http://www.unizar.es/ccia/articulos.htm
Ling, T.W., Lee, M.L.: View Update in Entity-Relationship Approach. Data & Knowledge Engin. 19(2), 135–169 (1996)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Domínguez, E., Lloret, J., Rubio, Á.L., Zapata, M.A. (2010). Stones Falling in Water: When and How to Restructure a View–Based Relational Database. In: Catania, B., Ivanović, M., Thalheim, B. (eds) Advances in Databases and Information Systems. ADBIS 2010. Lecture Notes in Computer Science, vol 6295. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15576-5_45
Download citation
DOI: https://doi.org/10.1007/978-3-642-15576-5_45
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-15575-8
Online ISBN: 978-3-642-15576-5
eBook Packages: Computer ScienceComputer Science (R0)