Abstract
This paper presents a flexible database schema transformational framework. Flexibility is achieved by adopting a generic model for describing database schemas and a transformational language able to represent all the correctness preserving schema transformations. This framework, originally defined for schema design, is also applicable for supporting other activities related to the database life-cycle. As an illustrative example, this paper shows how it can be used to support a database reverse engineering process.
Preview
Unable to display preview. Download preview PDF.
References
J.R. Abrial. The B-Book. Cambridge University Press, 1996.
P. Assenova and P. Johannssen. Improving Quality in Conceptual Modelling by the Use of Schema Transformation. Lecture Notes in Computer Science, n.1157, pp.277–291, Springer-Verlag, 1996.
C. Batini, G. Di Battista and G. Santucci. Structuring Primitives for a Dictionary of Entity Relationship Data Schemas. IEEE Transactions on Software Engineering, 19(4), April 1993.
P. Van Bommel. Database design by computer-aided schema transformations. Software Engineering Journal, pp.125–132, July 1995.
P. Mc. Brien and A. Poulovassilis. A Formal Framework for ER Schema Transformation. Lecture Notes in Computer Science, n.1331, pp.408–421, Springer-Verlag, 1997.
D. Castelli and E. Locuratolo. ASSO: A Formal Database Design Methodology. Information Modelling and Knowledge Bases VI, H. Jaakkaola et al.eds., IOS-Press, 1995.
D. Castelli and S. Pisani. A Transformational Approach to Database Design. IEICNR Technical Report, 1998.
D. Castelli and S. Pisani. Ensuring Correctness of personalised schema refinement transformations. Proc. International Workshop on Verification, Validation and Integrity Issue in Expert and Database Systems, 1998, to appear.
D. Castelli. A strategy for Reducing the Effort for Database Schema Maintenance. Proc. Second Euromicro Conf. on Software Maintenance and Reengineering, pp.29–35, Florence, 1998.
S. Ghannouchi, H. Ghezala and F. Kamoun. A Generic Approach for Data Reverse Engineering taking into Account Application Domain Knowledge. Proc. Second Euromicro Conf. on Software Maintenance and Reengineering, pp.21–28, Florence, 1998.
Illustra Server Release 3.2, 1995.
K.J. Lieberherr, W.L. Hürsch and C. Xiao. Object-Extending Class Transformations. Formal Aspects of Computing, 6, pp.391–416, 1994.
MIAOW Multimedia Database: Revised Design and Implementation. MIAOWCNR-REP-001-007. 1996.
W. J. Premerlani and M. R. Blaha. An Approach for Reverse Engineering of Relational Databases. Communication of the ACM, 37(5), pp.42–49, 1994.
J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy and W. Lorensen. Object-Oriented Modeling and Design. Prentice Hall, Englewood Cliffs, New Jersey 07632, 1991.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Castelli, D., Pisani, S. (1998). A flexible framework for a correct database design. In: Litwin, W., Morzy, T., Vossen, G. (eds) Advances in Databases and Information Systems. ADBIS 1998. Lecture Notes in Computer Science, vol 1475. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0057745
Download citation
DOI: https://doi.org/10.1007/BFb0057745
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-64924-3
Online ISBN: 978-3-540-68309-4
eBook Packages: Springer Book Archive