Matching XML DTD to relational Database Views
Massimo Pagotto, Augusto Celentano · 2000
In this paper we approach the problem of matching a set of XML Document Type Definitions against a view schema drawn form a relational database, aiming at evaluating the similarity between the view schema and the DTDs for (semi)automatic translation of relational tables (i.e., views, queries) data into XML documents. The paper discusses a matching algorithm and evaluates the similarity criteria defined. The approach is intended to be used in an interactive system supporting a user in populating documents belonging to a set of predefined schemas with data extracted from a database. The application we foresee are mostly related to the areas of prototyping and reuse, and are based on a scenario in which several libraries of DTDs describe common documents or data structures defined by standards related to specific application domains, and databases defined for various purposes (e.g., legacy repositories, application programs, etc.) store data that need to be processed according to the schemas defined. In such a scenario a system for evaluating the degree of correspondence between database data and document schemas can help to develop prototypes at low cost with great flexibility.