AN APPLICATION TO INTEGRATE RELATIONAL AND XML DATA SOURCES

Ana Mª Fermoso García, Roberto Berjón Gallinas, Mª José Gil Larrea

Abstract

Nowadays, special with the Internet explosion, enterprises have to work with data from heterogeneous sources, such as data from conventional databases, or from new sources of Internet world like XML or HTML documents. Organizations have to work with these different data sources at the same time, so, it’s necessary to find some way to integrate this heterogeneous information.In this paper we are going to centre in two main types of data, conventional data from relational databases, and the new web data format XML. Traditional relational database continues being the main data store and XML has become the main format to exchange and representation data on the web. At the end our purpose would be that the necessary data in each moment were in the same and common format, in XML, because this is the most used format on the web.This paper proposes an efficient environment for accessing relational databases from a web perspective using XML. Our environment defines a query system based on XML for relational databases, called XBD. XBD has a full XML appearance, query language and query results are in XML format. For the end user it is similar to query a XML document. This system includes a model to adapt any relational database in order it could be queried in two new query languages, derived from XSL and XQuery languages, and a software tool to implement the functionality of the XBD environment.

References

  1. Fermoso, A., Berjón, R., 2004. Acceso a datos relacionales en entornos Web. Un caso práctico. Publicaciones Universidad Pontificia de Salamanca
  2. Fernández, M., Kadiyska, Y., Morishima, A., Suciu, D., Tan., W.C., 2002. SilkRoute: a framework for publishing relational data in XML. ACM Transactions on Database Systems (TODS), Vol. 27, Nª 4, December, pp. 438-493.
  3. Funderburk, J. E., Kiernan, G., Shanmugasundaram, J. , Shekita, E., Wei, C., 2002. XTABLES: Bridging relational technology and XML. IBM Systems Journal, Vol. 41 , Nª 4.
  4. IBM, 2002. IBM DB2 Universal Database. XML Extender Administration and Programming. Version 8. IBM Corporation.
  5. Microsoft, SQL Server 2000. XML and Internet Support. Microsoft Corp.
  6. Oracle, 2002. Oracle 9i Release 2. Database Concepts. Oracle Corp., March.
  7. Oracle, 2002. Oracle 9i Release 2. XML Database Developers's Guide-Oracle XML DB. Oracle Corp., October.
  8. World Wide Web Consortium (W3C), 2004. Extensible Markup Languaje (XML). http://www.w3c.org/xml.
  9. World Wide Web Consortium (W3C), 2004. XML Path Language (XPath). http://www.w3c.org/TR/xpath.
  10. World Wide Web Consortium (W3C), 2004. XML Schema. http://www.w3c.org/2001/XMLSchema.
  11. World Wide Web Consortium (W3C), 2004. Extensible Style Language (XSL). http://www.w3c.org/Style/XSL.
  12. World Wide Web Consortium (W3C), 2004. XQuery: A Query Language for XML. http://www.w3c.org/TR/xquery.
Download


Paper Citation


in Harvard Style

Mª Fermoso García A., Berjón Gallinas R. and José Gil Larrea M. (2005). AN APPLICATION TO INTEGRATE RELATIONAL AND XML DATA SOURCES . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 313-319. DOI: 10.5220/0002555403130319


in Bibtex Style

@conference{iceis05,
author={Ana Mª Fermoso García and Roberto Berjón Gallinas and Mª José Gil Larrea},
title={AN APPLICATION TO INTEGRATE RELATIONAL AND XML DATA SOURCES},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2005},
pages={313-319},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002555403130319},
isbn={972-8865-19-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - AN APPLICATION TO INTEGRATE RELATIONAL AND XML DATA SOURCES
SN - 972-8865-19-8
AU - Mª Fermoso García A.
AU - Berjón Gallinas R.
AU - José Gil Larrea M.
PY - 2005
SP - 313
EP - 319
DO - 10.5220/0002555403130319