MOVIE: an incremental maintenance system for materialized object views

Authors:
M. Akhtar Ali;Alvaro A. A. Fernandes;Norman W. Paton
Affiliations:
School of Informatics, University of Northumbria, Newcastle Upon Tyne NE1 8ST, UK;Department of Computer Science, University of Manchester, Oxford Road, Manchester M13 9PL, UK;Department of Computer Science, University of Manchester, Oxford Road, Manchester M13 9PL, UK
Venue:
Data & Knowledge Engineering
Year:
2003

Citing 27
Cited 8

Efficiently updating materialized views

SIGMOD '86 Proceedings of the 1986 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
The 007 Benchmark

SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
Maintaining views incrementally

SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
Shoring up persistent applications

SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
Using partial information to update materialized views

Information Systems
View maintenance in a warehousing environment

SIGMOD '95 Proceedings of the 1995 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
Generating data integration mediators that use materialization

Journal of Intelligent Information Systems - Special issue on intelligent integration of information
Query unnesting in object-oriented databases

SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Incremental materialization of object-oriented views

Data & Knowledge Engineering
The object data standard: ODMG 3.0

The object data standard: ODMG 3.0
&lgr;-DB: an ODMG-based object-oriented DBMS

SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Maintaining views in object-relational databases

Proceedings of the ninth international conference on Information and knowledge management
Polar: an architecture for a parallel ODMG compliant object database

Proceedings of the ninth international conference on Information and knowledge management
Query processing in DOQL: a deductive database language for the ODMG model

Data & Knowledge Engineering
Materialized view selection and maintenance using multi-query optimization

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Optimizing object queries using an effective calculus

ACM Transactions on Database Systems (TODS)
Efficient incremental view maintenance in data warehouses

Proceedings of the tenth international conference on Information and knowledge management
Object-Relational DBMSs: Tracking the Next Great Wave

Object-Relational DBMSs: Tracking the Next Great Wave
Active Rules in Database Systems

Active Rules in Database Systems
Incremental Maintenance of Materialized Object-Oriented Views in MultiView: Strategies and Performance Evaluation

IEEE Transactions on Knowledge and Data Engineering
Trigger Condition Testing and View Maintenance Using Optimized Discrimination Networks

IEEE Transactions on Knowledge and Data Engineering
Join Index, Materialized View, and Hybrid-Hash Join: A Performance Analysis

Proceedings of the Sixth International Conference on Data Engineering
Deriving Production Rules for Incremental View Maintenance

VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Incremental Updates for Materialized OQL Views

DOOD '97 Proceedings of the 5th International Conference on Deductive and Object-Oriented Databases
Selection and maintenance of views in a data warehouse

Selection and maintenance of views in a data warehouse

Incrementalization across object abstraction

OOPSLA '05 Proceedings of the 20th annual ACM SIGPLAN conference on Object-oriented programming, systems, languages, and applications
The MurMur project: modeling and querying multi-representation spatio-temporal databases

Information Systems
Generating incremental implementations of object-set queries

GPCE '08 Proceedings of the 7th international conference on Generative programming and component engineering
Updates and views dependencies in semi-structured databases

IDEAS '08 Proceedings of the 2008 international symposium on Database engineering & applications
Forecasting box office revenue of movies with BP neural network

Expert Systems with Applications: An International Journal
Query Optimization through Cached Queries for Object-Oriented Query Language SBQL

SOFSEM '10 Proceedings of the 36th Conference on Current Trends in Theory and Practice of Computer Science
Ajax-based report pages as incrementally rendered views

Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Towards automatic generation of rules for incremental maintenance of XML views of relational data

WISE'05 Proceedings of the 6th international conference on Web Information Systems Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

View materialization is an important technique for high performance query processing, data integration and replication. Solutions to the problem of incrementally maintaining materialized views are very relevant. So far, most work on this problem has been confined to relational settings and solutions have not been comprehensively evaluated. This paper describes MOVIE, a complete, implemented and evaluated solution to the problem of incrementally maintaining materialized OQL views in ODMG-compliant object databases. The evaluation throws light into how the effectiveness of incremental maintenance is affected by issues such as database size, and the complexity and selectivity of views.