Re-engineering of the forest stand database: case study of Bilahe Forestry Bureau, Inner Mongolia of China

Abstract

The forest stand database of Bilahe Forestry Bureau, Inner Mongolia of China was taken as an example to demonstrate the whole process of building a temporal geodatabase by means of reengineering. The process was composed of establishing a conceptual data model from the initial database, constructing a logical database by means of mapping, and building a temporal geodatabase with the help of Computer-Aided Software Engineering (CASE) tool and Unified Markup Language (UML). The results showed that as the reengineered forest stand geodatabase was dynamic, it could easily store the historical data and answer time related questions by Structured Query Language (SQL), meanwhile, it maintains the integrity of database and eliminates the redundancy.

Keywords

re-engineering / spatial-temporal database / CASE tool / forest stand

References

[1] Alhajj R. Extracting the extended entity-relationship model from a legacy relational database Information System, 2003, 28: 597-618.

[2] Chen K.Y., Lu S.S. A Petri-net and entity-relationship diagram based object-oriented design method for manufacturing systems control International Journal of Computer Integrated Manufacturing, 1997, 10(1–4): 17-28.

[3] Cohen Y., Feldman Y.A. Automatic high-quality reengineering of database programs by abstraction, transformation and reimplementation ACM Transactions on Software Engineering and Methodology, 2003, 12(3): 285-316.

[4] de Guzman I.G.R., Polo M., Piattini M. A methodology for database reengineering to Web Services, Model Driven Architecture — Foundations and Applications Lecture Notes in Computer Science, 2006, 4066: 226-240.

[5] Dey D., Barron T.M., Storey V.C. A complete temporal relational algebra The VLDB journal, 1996, 5(3): 167-180.

[6] Liao S.Y., Wang H.Q., Liu W.Y. Stability constraints and stability normal forms for temporal relational databases Information and Software Technology, 1999, 41: 131-138.

[7] Liu W.Y., Song N. A logical design method for temporal databases based on the stability constraint and the generalization semantics Information Sciences, 2000, 124: 153-171.

[8] Sotnykova A., Vangenot C., Cullot N., Bennacer N., Aufaure M.A. Semantic mappings in description logics for spatio-temporal database schema integration Journal on Data Semantics III (Lecture Notes in Computer Science), 2005, 3534: 143-167.

[9] Zhou X., Chen J., Jiang J., Zhu J., Li Z. Event-based incremental updating of spatio-temporal database Journal of Central South University of Technology, 2004, 11(2): 192-198.