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…show more content… And the final piece is the database that contains the data and makes it available to the use for queries and processing. (Prohorenko and Prokhorenko, June 2005)
The use of XML in relational databases is effective but in no way should it be considered simple. When designing a web application a multi-tiered approach is used that separates each process into three distinct components or layers. The web page is the component of the web page where the user enters the data into the form thought of as the presentation layer since this is where the entry form is presented to the user. The code, this is the heart of the web page where the processing takes place and defines how the data is presented and captured and is written in Java or a similar Object Oriented language. The final piece is the actual database, data layer, where the data is stored and made available for queries and other processing. This type of division of structure provides an easy way to upgrade or change one process without affecting the other. When using a traditional relational database there are complications that can arise, data that is captured on a web page has a different structure that the data structure of a relational database since there is a unique structure of the database that is based on the relations of the data in the datasets. Data in a relational database is maintained by rows and columns in
