Abstract—The paper deals with reconstructing the conceptual model from the implemented database. Sometimes the conceptual model of the implemented database is missing and is appropriate to reconstruct the conceptual model from the implemented database to understand the content of the database and for effective additional development or maintance. We propose algorithm for reconstruction the conceptual model from the implemented database using JDBC methods. Reconstructed conceptual model is represented by XML document and then is transformed to CDM file supported by CASE tool called Sybase Power Designer. Finally, reconstructed conceptual model imported to Sybase Power Designer can be used for vizualization, transformation to logical and physical model, and in other various ways. Proposed algorithm is verified on specific implemented database and the reconstructed conceptual model is shown in CASE tool Sybase Power Designer.

Index Terms—Conceptual model, database, relational database, reconstruction.

The authors are with the Department of Informatics and Computers,University of Ostrava, Ostrava, Czech Republic (email:bogdan.walek@osu.cz, cyril.klimes@osu.cz).

Cite: Bogdan Walek and Cyril Klimeš, "Reconstruction of the Conceptual Model from the Implemented Database," International Journal of Computer and Communication Engineering vol. 1, no. 3, pp. 266-268 , 2012.