DEXA 1999: Database and Expert Systems Applications pp 678-687 | Cite as
Generation of Conceptual Wrappers for Legacy Databases
Abstract
One way to solve the heterogeneity problem of distributed legacy databases consists in wrapping them as objects that can be queried for retrieval and updating. This paper presents the InterDB approach for the generation of conceptual wrappers for legacy databases. The generated wrapper is a software layer that offers a conceptual interface based on the conceptual schema of the wrapped database. The InterDB approach provides a complete methodology for conceptual schema recovery (through reverse engineering) and mapping building. The methodology is supported by the DB-MAIN CASE tool that helps generate the wrapper.
Keywords
Reverse Engineering Conceptual Schema Logical Schema Schema Transformation Physical SchemaPreview
Unable to display preview. Download preview PDF.
References
- 1.Batini, C., Ceri, S., Navathe, S., Structuring Primitives for a Dictionary of Entity Relationship Data Schemas, IEEE TSE, 19(4) (1993)Google Scholar
- 2.Bouguettaya, A., Benattallah, B., Elmagarmid, A., Interconnecting Heterogeneous Information Systems, Kluwer Academic Publishers, USA (1998)Google Scholar
- 3.Hainaut, J-L., Chandelon, M., Tonneau, C., Joris, M. Contribution to a Theory of Database Reverse Engineering, in Proc. of the IEEE Working Conf. on Reverse Engineering, IEEE Computer Society Press, Baltimore (1993)Google Scholar
- 4.Hainaut, J-L. Specification preservation in schema transformations-Application to semantics and statistics, Data & Knowledge Engineering, Elsevier Science Publish, 16(1) (1996)Google Scholar
- 5.Hainaut J-L., Henrard J., Hick J-M., Roland D., Englebert V., Database Design Recovery, in Proc. of the 8th Conf. on Advanced Information Systems Engineering (CAISE’96), Springer-Verlag (1996)Google Scholar
- 6.Hick J-M., Englebert V., Henrard, J., Roland, D., Hainaut, J-L. The DB-MAIN Database Engineering CASE Tool (version 4)-Functions Overview, DB-MAIN Technical manual, Institut d’informatique, University of Namur (1998)Google Scholar
- 7.Mowbray, T., and Zahavi, R., The Essential CORBA: Systems Integration Using Distributed Objects, Wiley, New-York (1995)Google Scholar
- 8.Reese, Database Programming with JDBC and JAVA, O’Reilly, Sebastopol (1997)Google Scholar
- 9.Sheth, A.P., Larson, J.A., Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases, ACM Computing Surveys, 22(3) (1993)Google Scholar
- 10.Thiran, Ph., Hainaut, J-L., Hick, J-M., Bodart, S., Deflorenne A., Interoperation of Independent, Heterogeneous and Distributed Databases. Methodology and CASE Support: the InterDB Approach, in Proc. of the Coopis’98 Conference, New-York (1998)Google Scholar
- 11.Wiederhold, G., “Mediators in the Architecture of Future Information Systems”, IEEE Computers, pages 38–49 (1992)Google Scholar