XML-based Database Query Architecture Design And Application

With the development of computer network and database technology, the application of database become more and more widely, especially in the process of the enterprise information. Many applications use databases to manage and store data, and almost all the large-scale business application are associated with database. Normally, the database server effectively manages the system resources and handles the requests of the customer. However, the direct interaction with database application has strong dependence to data structure, especially the query operation, frequent visits and high concentration of the data access causes database performance bottleneck and the waste of resources, even makes database burden and collapse. So, let all the application procedures conveniently interactive respectively is becoming more and more important, and because of the different data formats and versions between different databases, it's difficult to realize fast and convenient data interaction.We need to find a medium as the intermediate to solve the problem. The teconology of XML with its flexible and simple data format becomes our choice for the intermediate. Then we can construct XML document to simulate a relational database, which turns the database query into XML queries. In other words, by tranferring the database recordset into XML documents, the queries do not directly access the database, but turn to relevant data-oriented XML document, thus makes the data query faster and more efficient.Based on this idea, this paper first discusses the features of the XML and database, analysis under what conditions the transformation is the most suitable, discusses the mutual transformation steps between XML and database records. Secondly, the paper discusses three technology including DOM, SAX and XPath to realize the XML query, provides the detail method of code realizes, then compares the applicable range of these three kinds of technology. By comparing these three different strengths of each technology, the paper combines DOM and XPath together, proposes a simple and flexible XML query solution, and a XML query application model. Finally, provides the model analysis and the application realizes. The research shows that, this model can realize the XML query more simplely, and has good practical value.