Query Translation from XSLT to SQL
نویسندگان
چکیده
XML has been accepted as a universal format for data interchange and publication. It can be applied in the applications in which the data of a database needs to be viewed in XML format so that the data being viewed takes more semantics and is easily understood. In these applications, the user of the data to be viewed sees only XML data, not the database. He may use XML query languages such as XSLT to query data and the retrieved data is presented in XML format to them. We are interested in the connection between the data that the user sees and the data in the database. More specifically, we are interested in translating XSLT queries to SQL queries.
منابع مشابه
Towards practical meta-querying
We describe a meta-querying system for databases containing queries in addition to ordinary data. In the context of such databases, a meta-query is a query about queries. Representing stored queries in XML, and using the standard XML manipulation language XSLT as a sublanguage, we show that just a few features need to be added to SQL to turn it into a fully-fledged meta-query language. The good...
متن کاملXSLT and XPath Optimization
Recent releases of Saxon support XQuery 1.0 as well as XSLT 2.0. However, the XQuery processor is an in-memory processor, not a database query engine. Optimizing database queries is an entirely different art, because it relies so heavily on rearranging queries to exploit persistent indexes. An in-memory processor does not have this opportunity, because the only indexes available are those that ...
متن کاملA Framework for Using Materialized XPath Views in XML Query Processing
XML languages, such as XQuery, XSLT and SQL/XML, employ XPath as the search and extraction language. XPath expressions often define complicated navigation, resulting in expensive query processing, especially when executed over large collections of documents. In this paper, we propose a framework for exploiting materialized XPath views to expedite processing of XML queries. We explore a class of...
متن کاملXML and DB2
The eXtensible Markup Language (XML) is a key technology that facilitates both information exchange and e-business transactions. Starting with DB2 UDB Net.Data V1, an application can generate XML documents from SQL queries against DB2 or any ODBC compliant databases. Today DB2 UDB XML Extender not only serves as a repository for both XML documents and their Document Type Definitions (DTDs), but...
متن کاملCEN prEN 13606 compliant export of medical data from an Entity- Attribute-Value based patient record system
This work describes an implementation of a proof-of-concept layer to export medical data from a health information system in a CEN prEN 13606 compliant format. The resulting EHR extracts are deposited in a local repository. The export-layer is based on Oracle PL/SQL and the PL/SQL DOM API. EHR extracts are described by means of two XML Schemas and are transformed into Archetype compliant EHR ex...
متن کامل