Research On Publishing XML Documents From Enterprise Database

With the exponential growth of Internet, XML(eXtensible Markup Language) isbecoming a de-facto standard for data publishing and data exchange. Due to its highexpressiveness and nested structure, self-describing characteristic, XML can play amore important role than Relational Database does in connecting Database withInternet. While at the present time most business data are still stored in traditionalrelational database systems, how to transform data from existing relational databaseinto XML representation has become the pivotal problem to be resolved.Some discussions have been done about the technology of publishing XMLdocuments from RDB at the viewpoint of both schema and instance, guided by thepopular MDA principle. We analyze the necessity and feasibility of publishing XMLfrom RDB according to the features of XML and RDB in the first part of this thesis.The following is one of the main contributions in this thesis: Two strategies areproposed to design XML views schema structure by analyzing the semanticconstraints characteristics of both XML Schema and relational schema andsummarizing the general transformation rules from relational schema to XMLdocument schema.In the third part we compare several techniques of XML publishing provided bythe mainstream manufacturers of database. And we choose Oracle as the test-bed byanalyzing the characteristics of XML publishing functions provided by Oracledatabase.At last, a publishing model of enterprise database is brought forward.Correspondingly a tool named XViews-Generator which can automatically generateXML views schema is implemented. At the same time a case about the publishing ofweather database is introduced to illustrate the techniques mentioned above: Utilizingthe realization principle of XViews-Generator to get the candidate XML viewsschema according to the main information of weather database and on the basis ofthis dynamic query techniques are used to implement the XML publishing from weather database.The publishing technique is studied in which the RDB is taken as the bottomstoring medium and the upper XML views are set up in this thesis. To implement theXML publishing from RDB, the thesis establish two strategies of designing XMLviews schema structure combining the static mapping rules with the dynamic queries.