Translating WFS Query to SQL/XML Query
نویسندگان
چکیده
The purpose of the WFS specification, proposed by the the OpenGIS Consortium (OGC), is to describe the manipulation operations over geospatial data using GML. Web servers providing WFS service are called WFS Servers. WFS servers publish GML views of geographic features stored in data sources such that the user can query and update data sources through a user defined feature type schema. In this work, we study the problem of answering WFS queries through a feature type schema, when the data is stored in a relational database. A feature type is specified by the feature type schema and a set of correspondence assertions. The feature type's correspondence assertions formally specify relationships between the feature type schema and the relational database schema. We define the semantic for WFS query answering and present an algorithm that translate a WFS query defined over a feature type schema into a SQL/XML query defined over the relational database schema.
منابع مشابه
Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملEfficient XML - to - SQL Query Translation : Where to Add the Intelligence ? ( Extended
Exporting XML views of relational data gives rise to the problem of translating XML queries into SQL. To date, the focus of most of the work in the published literature [9, 14, 20] has been on mechanisms for correctly translating complex XML queries into SQL queries, with less emphasis on evaluating the quality of the resulting SQL queries. The efficiency of the SQL queries generated by the tra...
متن کاملTranslating SPARQL and SQL to XQuery
In our community there are three main models for representing and processing data: Relations, XML and RDF. Each of these models has its "sweet spot" for applications and its own query language; very few implementations cater for more than one of these. We describe a uniform platform which provides interfaces for different query languages to retrieve andmodify the same information or combine it ...
متن کامل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 X...
متن کامل