Abstract
To deal with issues of data model transformation and to make combined use of different data models, this paper proposed a database reengineering scheme which includes schema translation and data conversion from object-oriented data model to flattened XML data model with is-a and cardinality data semantics preservation. In this paper, conceptual schema of object-oriented data model and flattened XML data model are elaborated by UML class diagram and XML Schema Definition(XSD) graph respectively. Logical schema is described by UNISQL class definition and XSD respectively. This paper firstly analyzes class definitions from OODB and sorts them from most independent classes to most dependent classes. Secondly schema translation is processed by mapping class to complexType and then creating element definitions in XSD file. Thirdly data conversion is processed automatically. Performance tests have shown that the proposed database reengineering scheme is reliable and efficient.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Stajano, F.: A Gentle Introduction to Relational and Object Oriented Databases. ORL Technical Report TR-98-2 (1998)
Bray, T., et al.: Extensible Markup Language (XML) 1.0 (Fourth Edition), pp. 115–146 (2006)
Maatuk, A.M.: Migrating relational databases into object-based and XML databases. J. Object Technol. 9(9), 145–161 (2009)
Fong, J., Pang, F., Bloor, C.: Converting relational database into XML document. In: Proceedings of 12th International Workshop on Database and Expert Systems Applications 2001. IEEE (2001)
Carey, M., Florescu, D., Ives, Z., Lu, Y., Shanmugasundaram, J., Shekita, E., Subramanian, S.: XPERANTO: publishing object-relational data as XML. In: Workshop on the Web and Databases, Informal Proceedings (2000)
Ahmad, U., et al.: An integrated approach for extraction of objects from XML and transformation to heterogeneous object oriented databases. arXiv preprint cs/0402007 (2004)
Chung, T.-S., et al.: Extracting object-oriented database schemas from XML DTDs using inheritance. In: Bauknecht, K., Madria, S.K., Pernul, G. (eds.) EC-Web 2001. LNCS, vol 2115, pp. 49–59. Springer, Heidelberg. https://doi.org/10.1007/3-540-44700-8_5
Naser, T., et al.: Transforming object-oriented databases into XML. In: IEEE International Conference on Information Reuse and Integration, IRI 2007. IEEE (2007)
Naser, T., AlHajj, R., Ridley, M.J.: Reengineering XML into object-oriented database. In: IEEE International Conference on Information Reuse and Integration, IRI 2008. IEEE (2008)
Naser, T., Alhajj, R., Ridley, M.J.: Two-way mapping between object-oriented databases and XML. Informatica (Slovenia) 33(3), 297–308 (2009)
Acknowledgement
This work was jointly supported by Natural Science Foundation of China (61773296), the Education Department of Jiangxi Province of China Science and Technology research projects with the Grant No. GJJ151433, GJJ161687, GJJ161688 and GJJ161691.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Liu, Y., Wu, X. (2018). Database Reengineering Scheme from Object-Oriented Model to Flattened XML Data Model. In: Li, K., Li, W., Chen, Z., Liu, Y. (eds) Computational Intelligence and Intelligent Systems. ISICA 2017. Communications in Computer and Information Science, vol 873. Springer, Singapore. https://doi.org/10.1007/978-981-13-1648-7_22
Download citation
DOI: https://doi.org/10.1007/978-981-13-1648-7_22
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-13-1647-0
Online ISBN: 978-981-13-1648-7
eBook Packages: Computer ScienceComputer Science (R0)