On conjunctive queries containing inequalities
Journal of the ACM (JACM)
Implementing (nondeterministic) parallel assignments
Information Processing Letters
A Discipline of Programming
Queries Independent of Updates
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Combinatorial algorithms for feedback problems in directed graphs
Information Processing Letters
Exploiting functional dependence in query optimization
Exploiting functional dependence in query optimization
Building the 4 Processor SB-PRAM Prototype
HICSS '97 Proceedings of the 30th Hawaii International Conference on System Sciences: Advanced Technology Track - Volume 5
Checking query containment with the CQC method
Data & Knowledge Engineering
Date on Database: Writings 2000-2006
Date on Database: Writings 2000-2006
Databases, Types and the Relational Model (3rd Edition)
Databases, Types and the Relational Model (3rd Edition)
Efficient exploitation of similar subexpressions for query processing
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Conjunctive query containment and answering under description logic constraints
ACM Transactions on Computational Logic (TOCL)
Optimizing complex queries with multiple relation instances
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
| Hi-index | 0.00 |
We investigate the problems involved in efficient implementation of the multiple assignment construct in Date and Darwen's Third Manifesto [5] and we explain the connection between assignment and insert, delete and update. Updating multiple tables using SQL places responsibility on the user to order the update statements correctly. Integrity constraints must either be preserved in the unnecessary intermediate states or else deferred. Multiple assignment accepts updates across the entire database simultaneously and makes the system responsible for scheduling them correctly. We outline implementation techniques that potentially permit multiple assignment to outperform SQL deferred constraint checking by employing parallelism and multi-query optimization.