Triggers over nested views of relational data

Authors:
Feng Shao;Antal Novak;Jayavel Shanmugasundaram
Affiliations:
Cornell University, Ithaca, NY;Stanford University, Stanford, CA;Cornell University, Ithaca, NY
Venue:
ACM Transactions on Database Systems (TODS)
Year:
2006

Citing 45
Cited 2

Extended algebra and calculus for nested relational databases

ACM Transactions on Database Systems (TODS)
View updates in relational databases with an independent scheme

ACM Transactions on Database Systems (TODS)
Deriving production rules for constraint maintenance

Proceedings of the sixteenth international conference on Very large databases
On rules, procedure, caching and views in data base systems

SIGMOD '90 Proceedings of the 1990 ACM SIGMOD international conference on Management of data
Extensible/rule based query rewrite optimization in Starburst

SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Incremental maintenance of views with duplicates

SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
On the correct translation of update operations on relational views

ACM Transactions on Database Systems (TODS)
Algorithms for translating view updates to database updates for views involving selections, projections, and joins

PODS '85 Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systems
NiagaraCQ: a scalable continuous query system for Internet databases

SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
SilkRoute: trading between relations and XML

Proceedings of the 9th international World Wide Web conference on Computer networks : the international journal of computer and telecommunications netowrking
A relational model of data for large shared data banks

Communications of the ACM - Special 25th Anniversary Issue
Monitoring XML data on the Web

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
A normal form for XML documents

Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Rainbow: mapping-driven XQuery processing system

Proceedings of the 2002 ACM SIGMOD international conference on Management of data
The database language GEM

SIGMOD '83 Proceedings of the 1983 ACM SIGMOD international conference on Management of data
An algebraic approach for incremental maintenance of materialized XQuery views

Proceedings of the 4th international workshop on Web information and data management
Remarks on the algebra of non first normal form relations

PODS '82 Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems
Incremental Maintenance of Materialized Object-Oriented Views in MultiView: Strategies and Performance Evaluation

IEEE Transactions on Knowledge and Data Engineering
Complex Query Decorrelation

ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Object Exchange Across Heterogeneous Information Sources

ICDE '95 Proceedings of the Eleventh International Conference on Data Engineering
Incremental Maintenance for Materialized Views over Semistructured Data

VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Efficiently Publishing Relational Data as XML Documents

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Efficient Filtering of XML Documents for Selective Dissemination of Information

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Deriving Production Rules for Incremental View Maintenance

VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Querying XML Views of Relational Data

Proceedings of the 27th International Conference on Very Large Data Bases
Integrating Triggers and Declarative Constraints in SQL Database Sytems

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Intra-Transaction Parallelism in the Mapping of an Object Model to a Relational Multi-Processor System

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Representing and Querying Semistructured Web Data Using Nested Tables with Structural Variants

ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
Implementing Incremental View Maintenance in Nested Data Models

DBLP-6 Proceedings of the 6th International Workshop on Database Programming Languages
Incremental Updates for Materialized OQL Views

DOOD '97 Proceedings of the 5th International Conference on Deductive and Object-Oriented Databases
Efficient filtering of XML documents with XPath expressions

The VLDB Journal — The International Journal on Very Large Data Bases
Optimal implementation of conjunctive queries in relational data bases

STOC '77 Proceedings of the ninth annual ACM symposium on Theory of computing
Scalable Trigger Processing

ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Oracle8i"The XML Enabled Data Management System

ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Stream processing of XPath queries with predicates

Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Active XQuery

ICDE '02 Proceedings of the 18th International Conference on Data Engineering
YFilter: Efficient and Scalable Filtering of XML Documents

ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Implementing a scalable XML publish/subscribe system using relational database systems

SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Incremental evaluation of schema-directed XML publishing

SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Triggers over XML Views of Relational Data

ICDE '05 Proceedings of the 21st International Conference on Data Engineering
DB2/XML: designing for evolution

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
XML and relational database management systems: inside Microsoft® SQL Server™ 2005

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Quark: an efficient XQuery full-text implementation

Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Incremental maintenance for non-distributive aggregate functions

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
From XML view updates to relational view updates: old solutions to a new problem

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30

Records retention in relational database systems

Proceedings of the 17th ACM conference on Information and knowledge management
An XQuery-based trigger service to bring consistency management to data integration systems

Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services

Quantified Score

Hi-index	0.00

Visualization

Abstract

Current systems that publish relational data as nested (XML) views are passive in the sense that they can only respond to user-initiated queries over the nested views. In this article, we propose an active system whereby users can place triggers on (unmaterialized) nested views of relational data. In this architecture, we present scalable and efficient techniques for processing triggers over nested views by leveraging existing support for SQL triggers over flat relations in commercial relational databases. We have implemented our proposed techniques in the context of the Quark XML middleware system. Our performance results indicate that our proposed techniques are a feasible approach to supporting triggers over nested views of relational data.