A formal definition for translating XML documents to the entity relationship model

International Journal of Metadata, Semantics and Ontologies

Volumn 2, Issue 1, 2007, Pages 54-66

  Bagui, Sikha ^a  

^a UNIVERSITY OF WEST FLORIDA   (United States)

Author keywords

Conceptual model; Database design; Entity relationship diagrams; Relational database; XML

Indexed keywords

DATA PROCESSING; DATABASE SYSTEMS; FORMAL LANGUAGES; WORLD WIDE WEB;

ENTITY RELATIONSHIP MODEL; RELATIONAL DATABASE;

XML;

EID: 35549013651     PISSN: 17442621     EISSN: 1744263X     Source Type: Journal    
DOI: 10.1504/IJMSO.2007.015076     Document Type: Article

References (24)

1. Adler, S., Berglund, A., Clark, J., Cseri, I., Grosso, P., Marsh, J., Nicol, G., Paoli, J., Shach, D., Thompson, H.S. and Wilson, C. (1997) A Proposal for xsl, Technical Report NOTE.XSL.html, W3 Consortium.
2. Apparao, V., Champion, M., Le Hors, A., Pixley, T., Robie, J., Sharpe, P., Wilson, C. and Wood, L. (1999) Document Object Model Level 2 Specification Technical Report WD-DOM-level-19990304, W3 Consortium.
3. Bagui, S. and Earp, R. (2003) Database Design using Entity-Relationship Diagrams, Auerbach Publications, A CRC Press Company, New York.
4. Bosak, J., Bray, T., Connolly, D., Maler, E., Nicol, G., Sperberg-McQueen, C.M., Wood, L. and Clark, J. (1998) W3C XML Specification DTD, http://www.w3.org/XML/1998/06/ xmlspec-report-19980910.htm.
5. Bray, T., Frankston, C. and Malhotra, A. (1998a) Document Content Description for XML, http://www.w3.org/TR/NOTE-dcd.
6. Bray, T., Paoli, J. and Sperberg-McQueen, C.M. (1998b) Extensible Markup Language (xml), Technical Report PR-xml-971208, W3 Consortium, 8 December 1997, http://www.w3.org/TR/PR-xml-971208.
7. Buneman, P., Davidson, S., Hillebrand, G. and Suciu, D. (1996) 'A query language and optimisation techniques unstructured data', Proceedings of the ACM SIGMOD Conference, Montreal, Canada.
8. Chen, P. (1976) 'The entity relationship model - towards a unified view of data', ACM Trans. Database Systems, Vol. 1, No. 1. pp.9-36.
9. Chen, P., Thalheim, B. and Wong, L.Y. (1999) 'Future directions of conceptual modelling', LNCS, Vol. 1565, p.287.
10. Codd, E. (1970) 'A relational model for large shared data banks,' CACM, Vol. 13, No. 6, pp.377-387.
11. Cover, R. (2005) The SGML/XML Web Page, http://www.oasis-open.org/cover/xml.html.
12. Elmasri, R. and Navathe, S.B. (2007) Fundamentals of Database Systems, 5th ed., Pearson Education, Boston, MA.
13. Fong, J., Pang, F. and Bloor, C. (2001) 'Converting relational database into XML document', 12th International Workshop on Database and Expert Systems Applications, p.61.
14. Fernandez, M., Malhotra, A., Marsh, J., Nagy, M. and Walsh, N. (2003) XQuery 1.0 and XPath Data Model, W3C Working Draft at http://www.w3.org/tr/query-datamodel.
15. Hughes, C. (2003) The Web Wizard's Guide To XML, Pearson Education, Boston, MA, USA.
16. Layman, A., Jung, E., Maler, E., Mikula, N.H., Paoli, J., Tigue, J., Thompson, H.S. and DeRose, S. (1997) XML-Data, Technical Report, W3 Consortium.
17. Light, R. (1987) Presenting XML, SAMS Publishing, Boston, USA.
18. McHugh, J., Abitehoul, S., Goldman, R., Quass, D. and Widom, J. (1997) 'Lore: a database management system for semistructured data', SIGMOD Record, Vol. 26, No. 3, pp.54-66.
19. Papotti, P. and Torlone, R. (2004) 'An approach to heterogeneous data translation based on XML conversion', CAiSE 2004 Workshop, 16th Conference on Advanced Information Systems Engineering, Riga, Latvia.
20. Psaila, G., (2000) 'ERX: a conceptual model for XML documents', SAC, Vol. 2, pp.898-903.
21. Sengupta, A. and Mohan, S. (2003) Formal and Conceptual Models for XML Structures - The Past, Present and Future, Technical Report No. 137-1, Information Systems Department Working Paper Series, Indiana University, Bloomington, Indiana.
22. Sengupta, A. Mohan, S. and Doshi, R. (2003) 'XER-Extensible entity relationship modelling,' Proceedings of XML 2003, Philadelphia, Pennsylvania.
23. Shanmugasundaram, J., Tufte, K., He, G., Zhang, C., DeWitt, D. and Naughton, J. (1999) 'Relational databases for querying XML documents: limitations and opportunities', Proceedings of the 25th VLDB Conference, Edinburgh, Scotland.
24. Xu, S., Li, Y. and Lu, S. (2003) 'ERDraw: an XML-based ER-diagram drawing and translation tool', Proceedings of ISCA 18th International Conference on Computers and their Applications, Honululu, Hawaii.