Abstract
Recently XML has become a standard for data representation and the preferred method of encoding structured data for exchange over the Internet. Moreover it is frequently used as a logical format to store structured and semi-structured data in databases. We propose a model-driven and configurable approach for modeling hierarchical XML data using object role modeling (ORM) as a flat conceptual model. First a non-hierarchical conceptual schema of the problem domain is built using ORM and then different hierarchical views of the conceptual schema or parts of it are specified by the designer using transformation rules. A hierarchical modeling notation called H-ORM is proposed to show these hierarchical views and model more complex semi-structured data constructs and constraints. We also propose an algorithm to map hierarchical H-ORM views to XML schema language.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
References
Halpin T. A logical analysis of information systems: static aspects of the data-oriented perspective. PhD dissertation. University of Queensland, 1989
Halpin T A, Morgan A J, Morgan T. Information modeling and relational databases. Morgan Kaufmann, 2008
Halpin T, Bloesch A. Data modeling in UML and ORM: a comparison. IDEA Group Publishing Company, 1999, 4–13
Bloesch A C, Halpin T A. Conceptual queries using ConQuer-II. Conceptual modeling-ER’97. Springer, 1997, 113–126
Halpin T, Morgan T. Information modeling and relational databases. Morgan Kaufmann Publishers Inc., 2008
Sengupta A, Wilde E. The case for conceptual modeling for XML. TIK Report 244. 2006
Necaský M. Conceptual modeling for XML: a survey. In: Proceedings of the DATESO 2006 Annual International Workshop on Databases, Texts, Specifications and Objects (DATESO 2006). 2006, 40–53
Badia A. Conceptual modeling for semistructured data. In: Proceedings of the 3rd International Conference on Web Information Systems Engineering (Workshops) (WISEw’02). 2002, 170–177
Mani M. EReX: a conceptual model for XML. In: Bellahsène Z, Milo T, Rys M, Suciu D, Unland R, eds. Database and XML technologies. Springer Berlin Heidelberg, 2004, 128–142
Sengupta A, Mohan S, Doshi R. XER-extensible entity relationship modeling. In: Proceedings of the XML 2003 Conference. 2003, 140–154
Psaila G. ERX: a conceptual model for XML documents. In: Proceedings of the 2000 ACM Symposium on Applied Computing, Volume 2. 2000, 898–903
Necaský M. XSEM: a conceptual model for XML. In: Proceedings of the 4th Asia-Pacific Conference on Comceptual Modelling, Volume 67. 2007, 37–48
Narayanan K, Ramaswamy S. Specifications for mapping UML models to XML schemas. In: Proceedings of the 4th Workshop in Software Model Engineering. Montego Bay, Jamaica, 2005
Routledge N, Bird L, Goodchild A. UML and XML schema. In: Proceedings of the 13th Australasian Database Conference, Volume 5. 2002, 157–166
Dobbie G, Xiaoying W, Ling T W, Lee M L. ORA-SS: An object-relationship-attribute model for semi-structured data. 2000
Al-Kamha R, Embley D, Liddle S. Augmenting traditional conceptual models to accommodate XML structural constructs. In: Parent C, Schewe K-D, Storey V, Thalheim B, eds. Conceptual modeling — ER 2007. Springer Berlin Heidelberg, 2007, 518–533
Embley D W, Kurtz B, Woodfield S. Object-oriented systems analysis: a model-driven approach. Englewood Cliffs, New Jersey: Prentice Hall, 1992
Ganguly R, Sarkar A. Evaluations of conceptual models for semistructured database system. International Journal of Computer Applications, 2012, 50(18): 5–12
Bird L, Goodchild A, Halpin T. Object role modelling and XMLschema. In: Laender A F, Liddle S, Storey V, eds. Conceptual modeling — ER 2000: Springer Berlin Heidelberg, 2000, 309–322
Curland M, Halpin T. The NORMA software tool for ORM 2. In: Soffer P, Proper E, eds. Information systems evolution. Springer Berlin Heidelberg, 2011, 190–204
Gao S, Sperberg-McQueen C M, Thompson H S. W3C XML schema definition language (XSD) 1.1 Part 1: structures. 2012
Thompson H S, Mendelsohn N, Beech D, Maloney M. XML schema Part 1: structures. 2nd ed. 2004
Author information
Authors and Affiliations
Corresponding author
Additional information
Amir Jahangard-Rafsanjani is currently working on his PhD in Software Engineering at Sharif University of Technology, Iran. He received an MSc in Software Engineering at Sharif University of Technology, Iran in 2008. His research is focused on model driven development, semi-structured data and formal methods.
Seyed-Hassan Mirian-Hosseinabadi received the BSc in software engineering from Shahid Beheshti University, Iran in 1984, and the MSc also in Software Engineering from Sharif University of Technology, Iran in 1987. He started his PhD program in 1993 and received the PhD in computer science (Formal Methods) from the University of Essex, UK in 1996. He joined Sharif University of Technology in 1996, and is currently an associate professor in the Department of Computer Engineering. His current research interests include application of formal methods in software specification and software development, type theory and constructive mathematics, software metrics and measurement, reconfigurable software architecture, formal specification and verification of software architecture, and XML databases.
Rights and permissions
About this article
Cite this article
Jahangard-Rafsanjani, A., Mirian-Hosseinabadi, SH. A model-driven approach to semi-structured database design. Front. Comput. Sci. 9, 237–252 (2015). https://doi.org/10.1007/s11704-014-3358-5
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s11704-014-3358-5