Journal of the ACM (JACM)
Updating databases with incomplete information
Updating databases with incomplete information
Update and retrieval in a relational database through a universal schema interface
ACM Transactions on Database Systems (TODS)
Comment on Bancilhon and Spyratos' “Update semantics and relational views”
ACM Transactions on Database Systems (TODS)
On the foundations of the universal relation model
ACM Transactions on Database Systems (TODS)
Update semantics of relational views
ACM Transactions on Database Systems (TODS)
A characterization of globally consistent databases and their correct access paths
ACM Transactions on Database Systems (TODS)
Updating a relational database through a universal schema interface
PODS '85 Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systems
PODS '85 Proceedings of the fourth ACM SIGACT-SIGMOD symposium on Principles of database systems
Can we use the universal instance assumption without using nulls?
SIGMOD '81 Proceedings of the 1981 ACM SIGMOD international conference on Management of data
Canonical view update support through boolean algebras of components
PODS '84 Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems
PODS '82 Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems
The Theory of Data Dependencies - An Overview
Proceedings of the 11th Colloquium on Automata, Languages and Programming
Updating relational databases through views (complements, mappings, select, project, join)
Updating relational databases through views (complements, mappings, select, project, join)
Theory of Relational Databases
Theory of Relational Databases
Analysis of a Virtual Memory Model for Maintaining Database Views
IEEE Transactions on Software Engineering
Updating relational databases through weak instance interfaces
ACM Transactions on Database Systems (TODS)
Abductive Knowledge Base Updates for Contextual Reasoning
Journal of Intelligent Information Systems
Using Constraint Satisfaction for View Update
Journal of Intelligent Information Systems
View updates in a semantic data modelling paradigm
ADC '01 Proceedings of the 12th Australasian database conference
Updating knowledge bases while maintaining their consistency
The VLDB Journal — The International Journal on Very Large Data Bases
An Extended Authorization Model for Relational Databases
IEEE Transactions on Knowledge and Data Engineering
A Knowledge Representation Model for Multiuser Knowledge-Based Systems
IEEE Transactions on Knowledge and Data Engineering
Automatic Migration and Wrapping of Database Applications - A Schema Transformation Approach
ER '99 Proceedings of the 18th International Conference on Conceptual Modeling
View Updatability Based on the Models of a Formal Specification
FME '01 Proceedings of the International Symposium of Formal Methods Europe on Formal Methods for Increasing Software Productivity
The intrinsic problems of structural heterogeneity and an approach to their solution
The VLDB Journal — The International Journal on Very Large Data Bases
An intensional approach to the specification of test cases for database applications
Proceedings of the 28th international conference on Software engineering
Triggers over nested views of relational data
ACM Transactions on Database Systems (TODS)
Controlled Query Evaluation and Inference-Free View Updates
Proceedings of the 23rd Annual IFIP WG 11.3 Working Conference on Data and Applications Security XXIII
Updating relational data via SPARQL/update
Proceedings of the 2010 EDBT/ICDT Workshops
Update support for database views via cooperation
ADBIS'07 Proceedings of the 11th East European conference on Advances in databases and information systems
Information-optimal reflections of view updates on relational database schemata
FoIKS'08 Proceedings of the 5th international conference on Foundations of information and knowledge systems
Requirements and protocols for inference-proof interactions in information systems
ESORICS'09 Proceedings of the 14th European conference on Research in computer security
Independent update reflections on interdependent database views
Conceptual Modelling and Its Theoretical Foundations
Information-based distance measures and the canonical reflection of view updates
Annals of Mathematics and Artificial Intelligence
Hi-index | 0.00 |
A view on a database is a mapping that provides a user or application with a suitable way of looking at the data. Updates specified on a view have to be translated into updates on the underlying database. We study the view update translation problem for a relational data model in which the base relations may contain (indexed) nulls.The representative instance is considered to be the correct representation of all data in the database; the class of views that is studied consists of total projections of the representative instance. Only independent database schemes are considered, that is, schemes for which global consistency is implied by local consistency. A view update can be an insertion, a deletion, or a modification of a single view tuple.It is proven that the constant complement method of Bancilhon and Spyratos is too restrictive to be useful in this context. Structural properties of extension joins are derived that are important for understanding views. On the basis of these properties, minimal algorithms for translating a single view-tuple update are given.