Mapping XML Schema to Entity Relationship and Extended Entity Relationship Models

International Journal of Intelligent Information and Database Systems

Volumn 1, Issue 3-4, 2007, Pages 325-345

  Bagui, Sikha ^a  

^a UNIVERSITY OF WEST FLORIDA   (United States)

Author keywords

conceptual modelling; database design; entity relationship model; extended entity relationship model; XML Schema

Indexed keywords

EID: 67650207658     PISSN: 17515858     EISSN: 17515866     Source Type: Journal    
DOI: 10.1504/ijiids.2007.016684     Document Type: Article

References (25)

1. Bagui, S. and Earp, R. (2003) Database Design Using Entity-Relationship Diagrams, Auerbach Publications, A CRC Press Company, New York.
2. Bagui, S. (2007) ‘A formal definition for translating XML documents to the entity relationship model’, International Journal of Metadata, Semantics and Ontologies, Vol. 2, No. 1, pp.54–66.
3. Bourret, R., Bornhovd, C. and Buchmann, A.P. (2000) ‘A generic load/extract utility for data transfer between XML documents and relational databases’, 2nd International Workshop on Advanced Issues of EC and Web-based Information Systems (WECWIS), San Jose, California.
4. Bray, T., Paoli, J. and Sperberg-McQueen, C.M. (1998) Extensible markup language (xml), Technical Report PR-xml-971208, W3 Consortium, 8 December, 1997, http://www.w3.org/TR/PR-xml-971208.
5. Campbell, C.E., Eisenberg, A. and Melton, J. (2003) ‘XML schema’, SIGMOD Record, Vol. 32, No. 2, pp.96–101.
6. Ceri, S., Fraternali, P. and Paraboschi, S. (2000) ‘XML: current developments and future challenges for the database community’, Proceedings of the 7th International Conference on Extending Database Technology (EDBT), Springer, LNCS, Vol. 1777, pp.3–17.
7. Chen, P. (1976) ‘The entity relationship model – towards a unified view of data’, ACM Trans. Database Systems, Vol. 1, No. 1, pp.9–36.
8. Chen, P., Thalheim, B. and Wong, L.Y. (1999) ‘Future directions of conceptual modeling’, LNCS, Vol. 1565, p.287.
9. Deutsch, A., Fernandez, M. and Suciu, D. (1999) ‘Storing semistructured data in relations’, Workshop on Query Processing for Semistructured Data and Non-Standard Data Formats, Jerusalem.
10. Elmasri, R., Hevner, A. and Weeldreyer, J. (1985) ‘The category concept: an extension to the entity-relationship model’, Data and Knowledge Engineering, Vol. 1, pp.75–116.
11. Elmasri, R. and Navathe, S.B. (2007) Fundamentals of Database Systems, 5th ed., Pearson Education, Boston, MA.
12. Engels, G., Gogolla, M., Hohenstein, U., Hulsmann, K., Lohr-Richter, P., Saake, G. and Ehrich, H. (1992-1993) ‘Conceptual modelling of database applications using an extended ER model’, Data and Knowledge Engineering, Vol. 9, pp.157–204.
13. Fernandez, M., Tan, W-C. and Suciu, D. (2000) ‘SilkRoute: trading between relations and XML’, 9th International World Wide Web Conference, Amsterdam.
14. Hughes, C. (2003) The Web Wizard’s Guide To XML, Pearson Education, Boston, MA, USA.
15. Kappel, G., Kapsammer, E., Rausch-Schott, S. and Retschitzegger, W. (2000) ‘X-ray – towards integrating XML and relational database systems’, Proceedings of the 19th International Conference on Conceptual Modeling (ER), Salt Lake City, USA, LNCS, Vol. 1920, pp.339–353.
16. Kappel, G., Kapsammer, E. and Retschitzegger, W. (2001a) ‘Architectural issues for integrating XML and relational database systems – the X-ray approach’, Proceedings of the Workshop on XML Technologies and Software Engineering, Toronto.
17. Kappel, G., Kapsammer, E. and Retschitzegger, W. (2001b) ‘XML and relational database systems – a comparison of concepts’, Proceedings of the 2nd International Conference on Internet Computing (IC), CSREA Press, Las Vegas, USA.
18. Kappel, G., Kapsammer, E. and Retschitzegger, W. (2004) ‘Integrating XML and relational database systems’, World Wide Web: Internet and Web Information Systems, Vol. 7, pp.343–384.
19. Kapsammer, E. (2006) ‘XML-based EIS – a meta schema for mapping XML Schema to relational DBS’, Proceedings of the IFIP International Conference on Research and Practical Issues of Enterprise Information Systems (CONFENIS 2006), 24-26 April, Vienna, Austria.
20. Lewis, P.M., Bernstein, A. and Kifer, M. (2002) Databases and Transaction Processing, Addison Wesley, Boston, MA.
21. Navathe S.B. and Cheng, A. (1983) ‘A methodology for database schema mapping from extended entity relationship models into the hierarchical model’, in Davis, G.C., Sushil, J., Peter, A.Ng. and Raymond, T.Y. (Eds): Entity-Relationship Approach to Software Engineering, Elsevier North-Holland, New York.
22. SenGupta, A. and Mohan, S. (2003) Formal and Conceptual Models for XML Structures – The Past, Present and Future, Technical Report No. 137-1, Information Series Department Working Paper Series, Indiana University, Bloomington, Indiana.
23. Shanmugasundaram, J., Shekita, E., Barr, R., Carey, M., Lindsay, B., Pirahesh, H. and Reinwald, B. (2001) ‘Efficiently publishing relational data as XML documents’, VLDB Journal, Vol. 10, Nos. 2-3, pp.133–154.
24. Varlamis, I. and Vazirgiannis, M. (2001) ‘Bridging XML-Schema and relational databases. A system for generating and manipulating relational databases using valid XML documents’, DocEng, November, Atlanta, GA, pp.105–114.
25. Widom, J. (1999) ‘Data management for XML – research directions’, IEEE Data Engineering Bulletin, Special Issue on XML, Vol. 22, No. 3, pp.44–52.