Abstract
This paper presents techniques for reverse engineering of relational database applications. The target of such an effort is the definition of a fully equipped object-oriented view of the relational database, including methods and constraints. Such views can be seen as a full specification of the database semantics, aiding for example in the identification of semantic heterogeneity among interoperable databases.
The general problem of translating from an imperative programming language environment to a declarative context such as provided by our target OODML is very hard. However, we show that the specific features of database application software allow for the development of a framework geared towards the particular problems encountered in this context.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
H. Balsters, R. A. de By & R. Zicari, “Typed sets as a basis for object-oriented database schemas,” in Proceedings Seventh European Conference on Object-Oriented Programming, July 26–30, 1993, Kaiserslautern, Germany, LNCS #707, O. M. Nierstrasz, ed., Springer-Verlag, New York-Heidelberg-Berlin, 1993, 161–184, See also http://wwwis.cs.utwente.nl:8080/oodm.html.
M. Castellanos, “A methodology for semantically enriching interoperable databases,” in Advances in Database — BNCOD 11, Springer-Verlag, New York-Heidelberg-Berlin, 1993, 58–75.
R. H. L. Chiang, T. M. Barron & V. C. Storey, “Reverse engineering of relational databases: Extraction of an EER model from a relational database,” Data & Knowledge Engineering 12 (March 1994), 107–142.
U. Dayal, “Of nests and trees: A unified approach to processing queries that contain nested subqueries, aggregates, and quantifiers,” in Proceedings of Thirteenth International Conference on Very Large Data Bases, Brighton, England, September 1–4, 1987, P. M. Stocker, W. Kent & P. Hammersley, eds., Morgan Kaufmann Publishers, Los Altos, CA, 1987, 197–207.
P. Drew, R. King, D. McLeod, M. Rusinkiewicz & A. Silberschatz, “Report of the workshop on semantic heterogeneity and interoperation in multidatabase systems,” SIGMOD RECORD 22 (September 1993), 47–55.
J. Flokstra, M. van Keulen & J. Skowronek, “The IMPRESS DDT: A database design toolbox based on a formal specification language,” in Proceedings ACM-SIGMOD 1994 International Conference on Management of Data, ACM Press, New York, NY, 1994, 506.
P. Johannesson, “A method for transforming relational schemas into conceptual schemas,” in Proceedings Tenth International Conference on Data Engineering, IEEE Computer Society Press Los Alamitos, CA, 1994, 190–201.
W. Meng, C. Yu, W. Kim, G. Wang, T. Pham & S. Dao, “Construction of a relational frontend for object oriented database systems,” in Proceedings Ninth International Conference on Data Engineering, Vienna, Austria, April 19–23, 1993, IEEE Computer Society Press, Washington, DC, 1993, 476–483.
S. Y. W. Su, H. Lam & D. H. Lo, “Transformation of data traversais and operations in application programs to account for semantic changes of databases,” ACM Transactions on Database Systems 6 (June 1981), 255–294.
M. W. W. Vermeer & P. M. G. Apers, “Object-oriented views of relational databases incorporating behaviour,” in Fourth International Conference on Database Systems for Advanced Applications (DASFAA'95), Singapore, April 10–13 1995, T. W. Ling & Y. Masunaga, eds., World Scientific Publishing Co., 1995, 26–35.
M. W. W. Vermeer & P. M. G. Apers, “A framework for reverse engineering of relational database applications,” Universiteit Twente, 95–24, Enschede, The Netherlands, 1995, Memoranda Informatica.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1995 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vermeer, M.W.W., Apers, P.M.G. (1995). Reverse engineering of relational database applications. In: Papazoglou, M.P. (eds) OOER '95: Object-Oriented and Entity-Relationship Modeling. ER 1995. Lecture Notes in Computer Science, vol 1021. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0020523
Download citation
DOI: https://doi.org/10.1007/BFb0020523
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60672-7
Online ISBN: 978-3-540-48527-8
eBook Packages: Springer Book Archive
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.