From XML view updates to relational view updates

Braganholo, Vanessa; Davidson, Susan B.; Heuser, Carlos A.

doi:10.1016/b978-012088469-8.50027-9

Cited by 27 publications

(36 citation statements)

References 7 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…The strategy used in Pataxo' ( [6], [7]) is to map XML views into relational views. Then, the XML update view problem is reduced to the relational view update problem, which is well studied and there are many existing solutions.…”

Section: Related Workmentioning

confidence: 99%

“…This is necessary because, even after normalization, the resulting query input will still remain the view input, which can be the entire database. While other systems use one-shot SQL derivations from view forests [13] or query trees [7], our approach is purely transformational. It starts from a query that works on the full content of relational tables (R[ [ T ] ] in our notation), promotes relevant SQL predicates into SQL queries, and fuses SQL queries in pairs using transformation rules.…”

Section: Query Optimizationmentioning

confidence: 99%

See 1 more Smart Citation

Propagating updates through XML views using lineage tracing

Fegaras

2010

2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)

View full text Add to dashboard Cite

Abstract-We address the problem of updating XML views over relational data by translating view updates expressed in the XQuery update facility to embedded SQL updates. Although our XML views may be defined using the full extent of the XQuery syntax, they can only connect relational tables through restricted one-to-many relationships that do not cause view side effects for a wide range of XQuery updates. Our approach is to use lineage tracing to propagate the necessary information about the origins of updatable data pieces through the query and the view code, to be used when these pieces are to be updated. Our system performs a compile-time analysis, based on polymorphic type inference and type usage, to detect the exclusive data sources, which are the table columns from the database that can be updated without causing side-effects to the view. The rest of the updates are associated with an update context in the form of a chain of tuples, which reflects the navigation path that was used to reach the update destination. At commit time, our system collectively considers all the compatible chains of all updates in the transaction and tries to relink them to new chains from the existing database whose tuples contain the updated data, so that the updates are reflected correctly without causing side effects to the other components of the view.

show abstract

Section: Related Workmentioning

confidence: 99%

Section: Query Optimizationmentioning

confidence: 99%

Propagating updates through XML views using lineage tracing

Fegaras

2010

2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)

View full text Add to dashboard Cite

show abstract

“…Thus, paths can be used to select data from sources and locate data in copy-paste updates to the target database. We believe these are reasonable requirements since XML publishing and view update for legacy RDBMSs are widely recognized as important research problems and have already received attention [2]. Moreover, many commercial relational databases already provide some capability for publishing their data as XML.…”

Section: How Can We Address and Update Heterogeneous Data?mentioning

confidence: 99%

A Provenance Model for Manually Curated Data

Buneman

Chapman

Cheney

et al. 2006

Provenance and Annotation of Data

View full text Add to dashboard Cite

Abstract. Many curated databases are constructed by scientists integrating various existing data sources "by hand", that is, by manually entering or copying data from other sources. Capturing provenance in such an environment is a challenging problem, requiring a good model of the process of curation. Existing models of provenance focus on queries/views in databases or computations on the Grid, not updates of databases or Web sites. In this paper we motivate and present a simple model of provenance for manually curated databases and discuss ongoing and future work.

show abstract

“…One line of work focused on determining under what circumstances view updates can be translated unambiguously, more recently for XML views [8]. Unfortunately, there are few such cases; besides, usually every update needs to have a well-defined translation, i.e., rejecting a valid update is unacceptable.…”

Section: Related Workmentioning

confidence: 99%

Compiling mappings to bridge applications and databases

Melnik

Adya

Bernstein

2008

ACM Trans. Database Syst.

View full text Add to dashboard Cite

Translating data and data access operations between applications and databases is a longstanding data management problem. We present a novel approach to this problem, in which the relationship between the application data and the persistent storage is specified using a declarative mapping, which is compiled into bidirectional views that drive the data transformation engine. Expressing the application model as a view on the database is used to answer queries, while viewing the database in terms of the application model allows us to leverage view maintenance algorithms for update translation. This approach has been implemented in a commercial product. It enables developers to interact with a relational database via a conceptual schema and an object-oriented programming surface. We outline the implemented system and focus on the challenges of mapping compilation, which include rewriting queries under constraints and supporting non-relational constructs.

show abstract

From XML view updates to relational view updates

Cited by 27 publications

References 7 publications

Propagating updates through XML views using lineage tracing

Propagating updates through XML views using lineage tracing

A Provenance Model for Manually Curated Data

Compiling mappings to bridge applications and databases

Contact Info

Product

Resources

About