ITEC 610 Assingement 1
The relationship and interaction between XML and databases
ECET610 UMUC
Abstract
This paper will explore the relationship between XML and databases and the way that they can be leveraged to provide data exchange on the internet. As XML gains popularity as the format for exchanging information via the internet and has become the language of choice for use in database development for Internet use.Introduction
XML is a universal data standard and thereby does not need to be translated for use in different database systems. This is very important with large corporate data systems. In companies that have web presence this is a vital concern where some of the data base systems are handled by external companies that use an entirely different database system. Rather than creating a program to make the translation between that databases XML makes the data readable by both database systems by sharing a schema.
Is XML a Database
From the beginnings of the information age documents have always contained a wealth of useful information but it was hard to catalogue, this limited its usefulness. XML changed this by allowing the document to be catalogued with the data it contained and allowed targeted searches to be made against the documents.
An XML document is a collection of data so in the strictest sense it is a database since it contains data of a sort. It contains several things found in a traditional database management system such as schema, query capabilities and storage of data. So in this sense it is a data base and the XML document can be used to store data. When the need to store large amounts of data arises XML is also a valid choice if the application uses XML as a transport format. For example an e-commerce application that collects order information from a web site and uses XML as the transport format for data. This type of data will have a highly regular structure and can be used by non-XML applications on the back end that gather statistic s on
ECET610 UMUC
Abstract
This paper will explore the relationship between XML and databases and the way that they can be leveraged to provide data exchange on the internet. As XML gains popularity as the format for exchanging information via the internet and has become the language of choice for use in database development for Internet use.Introduction
XML is a universal data standard and thereby does not need to be translated for use in different database systems. This is very important with large corporate data systems. In companies that have web presence this is a vital concern where some of the data base systems are handled by external companies that use an entirely different database system. Rather than creating a program to make the translation between that databases XML makes the data readable by both database systems by sharing a schema.
Is XML a Database
From the beginnings of the information age documents have always contained a wealth of useful information but it was hard to catalogue, this limited its usefulness. XML changed this by allowing the document to be catalogued with the data it contained and allowed targeted searches to be made against the documents.
An XML document is a collection of data so in the strictest sense it is a database since it contains data of a sort. It contains several things found in a traditional database management system such as schema, query capabilities and storage of data. So in this sense it is a data base and the XML document can be used to store data. When the need to store large amounts of data arises XML is also a valid choice if the application uses XML as a transport format. For example an e-commerce application that collects order information from a web site and uses XML as the transport format for data. This type of data will have a highly regular structure and can be used by non-XML applications on the back end that gather statistic s on
References: Bourret, R (2005) XML and Databases. Retrieved form: http://www.rpbourret.com/xml/XMLAndDatabases.htm DeWitt, Naughton,Shanmugasundaram, Tufte, Zhang (1999) Relational Databases for Querying XML Documents: Limitations and Opportunities Dodds, L. (2001) XML and Databases? Follow Your Nose. Published on XML.com Retrieved from: http://www.xml.com/pub/a/2001/10/24/follow-yr-nose.html Obasanjo, D Pardede, E. (2009) Open and Novel Issues in XML Database Applications:Future Directions and Advanced Technologies. Published by IGI Global. Chapter 1 and 2. Prohorenko, Prokhorenko. (2005) XML as a Bridge between SQL and Web Applications. Published on BEA Dev2Dev. Retrieved from: http://www.oracle.com/technetwork/articles/entarch/xml-bridge-093515.html Trinidad, G Trippe, Waldt (2008). Using XML and Databases: W3C Standards in Practice. White Paper sponsored by EMC2 Retrieved from: http://xml.coverpages.org/Gilbane-EMC-WaldtTrippe-XML-andDatabases.pdf Figure Captions Figure 1. Aligning XML Data with XML Database (Costello 2012) [Figures – note that this page does not have the manuscript header and page number] Figure 1. Aligning XML Data with XML Database (Costello 2012)