An architecture for object management in OIS
ACM Transactions on Information Systems (TOIS)
A snapshot differential refresh algorithm
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Efficiently updating materialized views
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Semantics and implementation of schema evolution in object-oriented databases
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
A performance analysis of view materialization strategies
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
File structures: an analytic approach
File structures: an analytic approach
Extension of relational views to derived relations with exceptions
Information Systems
Version management of composite objects in CAD databases
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Join processing in relational databases
ACM Computing Surveys (CSUR)
Introduction to object-oriented databases
Introduction to object-oriented databases
Performance analysis of “what-if” databases using independently updated views
Journal of Management Information Systems
Differential files: their application to the maintenance of large databases
ACM Transactions on Database Systems (TODS)
Calculating constraints on relational expression
ACM Transactions on Database Systems (TODS)
Approximating block accesses in database organizations
Communications of the ACM
Implementation of integrity constraints and views by query modification
SIGMOD '75 Proceedings of the 1975 ACM SIGMOD international conference on Management of data
Embedding expert knowledge and hypothetical data bases into a data base system
SIGMOD '80 Proceedings of the 1980 ACM SIGMOD international conference on Management of data
Hypothetical data bases as views
SIGMOD '81 Proceedings of the 1981 ACM SIGMOD international conference on Management of data
Updating Distributed Materialized Views
IEEE Transactions on Knowledge and Data Engineering
Architecture of the ORION Next-Generation Database System
IEEE Transactions on Knowledge and Data Engineering
An Incremental Mechanism for Schema Evolution in Engineering Domains
Proceedings of the Fourth International Conference on Data Engineering
Generalized Version Control in an Object-Oriented Database
Proceedings of the Fourth International Conference on Data Engineering
Proceedings of the Eighth International Conference on Data Engineering
An Implementation of Hypothetical Relations
VLDB '83 Proceedings of the 9th International Conference on Very Large Data Bases
Versions of Schema for Object-Oriented Databases
VLDB '88 Proceedings of the 14th 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
Mapping a Version Model to a Complex-Object Data Model
Proceedings of the Eighth International Conference on Data Engineering
An Event Driven Software Architecture for Enterprise-Wide Data Source Integration
ITCC '00 Proceedings of the The International Conference on Information Technology: Coding and Computing (ITCC'00)
Hi-index | 0.00 |
Independently updated views (IUVs) are updated versions of a relational view. Unlike traditional views, updating an IUV changes only that IUV and not the underlying database. Updates to an IUV are stored in a differential table (DT) and incorporated when the IUV is accessed. There is no restriction on the type of query used to define the IUV. Applications of IUVs include alternative scenarios for decision support, local updating of distributed snapshots, and CAD versioning. IUVs allow versions to be defined on dynamic databases. This may cause inconsistencies because both the IUV and the base tables on which the IUV is defined can be updated independently of one another. We introduce "overlapping updates" that cause such inconsistencies and present algorithms for their detection and resolution using timestamps. These algorithms do not impose additional overhead on the database and require only the modification of the DT. A performance analysis indicates that the cost of querying IUVs is reasonable for a wide range of queries, views, and access strategies. We also consider a materialized implementation of IUVs. Materialized IUVs do not require a DT, relying instead on additional system columns for operation codes and timestamps. Results suggest a mix of implementation strategies for different types of IUV applications, depending on the frequency and nature of queries on the IUVs, the IUV sizes, and how actively the base tables are updated.