Incomplete Information in Relational Databases
Journal of the ACM (JACM)
Journal of the ACM (JACM)
Equivalence and optimization of relational transactions
Journal of the ACM (JACM)
Properties and update semantics of consistent views
ACM Transactions on Database Systems (TODS)
View updates in relational databases with an independent scheme
ACM Transactions on Database Systems (TODS)
Database updates through abduction
Proceedings of the sixteenth international conference on Very large databases
Updating logical databases
A linear constraint satisfaction approach to cost-based abduction
Artificial Intelligence
The role of abduction in database view updating
Journal of Intelligent Information Systems
View update in entity-relationship approach
Data & Knowledge Engineering
Update semantics of relational views
ACM Transactions on Database Systems (TODS)
On the correct translation of update operations on relational views
ACM Transactions on Database Systems (TODS)
PODS '85 Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systems
Problem of Incomplete Information in Relational Databases
Problem of Incomplete Information in Relational Databases
On the semantics of updates in databases
PODS '83 Proceedings of the 2nd ACM SIGACT-SIGMOD symposium on Principles of database systems
TAILOR, A Tool for Updating Views
EDBT '88 Proceedings of the International Conference on Extending Database Technology: Advances in Database Technology
A Relational Database View Update Translation Mechanism
VLDB '84 Proceedings of the 10th International Conference on Very Large Data Bases
Choosing a View Update Translator by Dialog at View Definition Time
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
View Updates Translations in Relational Databases
DEXA '98 Proceedings of the 9th International Conference on Database and Expert Systems Applications
The impact of the constant complement approach towards view updating
Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
An intensional approach to the specification of test cases for database applications
Proceedings of the 28th international conference on Software engineering
Artemis: a system for analyzing missing answers
Proceedings of the VLDB Endowment
Explaining missing answers to SPJUA queries
Proceedings of the VLDB Endowment
| Hi-index | 0.00 |
View update is the problem of translating update requests against a view into update requests against the base data. In this article, we present a novel approach to generating alternative translations of view updates in relational databases. Using conditional tables to represent relational views, we transform a view update problem into constraint satisfaction problems (CSPs). Solutions to the CSPs correspond to possible translations of the view update. Semantic information to resolve ambiguity can be incrementally added as constraints in the CSPs. The connection between view update and constraint satisfaction makes it possible to apply the rich results of the CSP research to analyze and solve the important problem of view management.