A model-driven approach to semi-structured database design

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.

Keywords

semi-structured database design / object role modeling / model driven approach

References

[1] Halpin T. A logical analysis of information systems: static aspects of the data-oriented perspective. PhD dissertation. University of Queensland, 1989

[2] Halpin T A, Morgan A J, Morgan T. Information modeling and relational databases. Morgan Kaufmann, 2008

[3] Halpin T, Bloesch A. Data modeling in UML and ORM: a comparison. IDEA Group Publishing Company, 1999, 4-13

[4] Bloesch A C, Halpin T A. Conceptual queries using ConQuer-II. Conceptual modeling—ER’97. Springer, 1997, 113-126

[5] Halpin T, Morgan T. Information modeling and relational databases. Morgan Kaufmann Publishers Inc., 2008

[6] Sengupta A, Wilde E. The case for conceptual modeling for XML. TIK Report 244. 2006

[7] 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

[8] 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

[9] 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

[10] Sengupta A, Mohan S, Doshi R. XER-extensible entity relationship modeling. In: Proceedings of the XML 2003 Conference. 2003, 140-154

[11] Psaila G. ERX: a conceptual model for XML documents. In: Proceedings of the 2000 ACM Symposium on Applied Computing, Volume 2. 2000, 898-903

[12] Necaský M. XSEM: a conceptual model for XML. In: Proceedings of the 4th Asia-Pacific Conference on Comceptual Modelling, Volume 67. 2007, 37-48

[13] 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

[14] Routledge N, Bird L, Goodchild A. UML and XML schema. In: Proceedings of the 13th Australasian Database Conference, Volume 5. 2002, 157-166

[15] Dobbie G, Xiaoying W, Ling T W, Lee M L. ORA-SS: An objec-trelationship- attribute model for semi-structured data. 2000

[16] 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

[17] Embley D W, Kurtz B, Woodfield S. Object-oriented systems analysis: a model-driven approach. Englewood Cliffs , New Jersey: Prentice Hall, 1992

[18] Ganguly R, Sarkar A. Evaluations of conceptual models for semistructured database system. International Journal of Computer Applications, 2012, 50(18): 5-12

[19] 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

[20] 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

[21] Gao S, Sperberg-McQueen C M, Thompson H S. W3C XML schema definition language (XSD) 1.1 Part 1: structures. 2012

[22] Thompson H S, Mendelsohn N, Beech D, Maloney M. XML schema Part 1: structures. 2nd ed. 2004

RIGHTS & PERMISSIONS

2014 Higher Education Press and Springer-Verlag Berlin Heidelberg