The Opsis project: materialized views for data warehouses and the web

Authors:
Nick Roussopoulos;Yannis Kotidis;Alexandros Labrinidis;Yannis Sismanis
Affiliations:
Department of Computer Science, University of Maryland, Maryland, College Park, MD;Department of Computer Science, University of Pittsburgh, Pittsburgh, PA;Department of Computer Science, University of Pittsburgh, Pittsburgh, PA;Department of Computer Science, University of Maryland, Maryland, College Park, MD
Venue:
PCI'01 Proceedings of the 8th Panhellenic conference on Informatics
Year:
2001

Citing 36
Cited 0

Principles and Techniques in the Design of ADMS±

Computer
Efficiently updating materialized views

SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Join indices

ACM Transactions on Database Systems (TODS)
Intelligent caching and indexing techniques for relational database systems

Information Systems
Maintaining materialized views without accessing base data

Information Systems
An incremental access method for ViewCache: concept, algorithms, and cost analysis

ACM Transactions on Database Systems (TODS)
Implementing data cubes efficiently

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Efficient refreshment of data warehouse views

Efficient refreshment of data warehouse views
Cubetree: organization of and bulk incremental updates on the data cube

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Maintenance of data cubes and summary tables in a warehouse

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Internet Web servers: workload characterization and performance implications

IEEE/ACM Transactions on Networking (TON)
Materialized views and data warehouses

ACM SIGMOD Record
Dynamic assembly of views in data cubes

PODS '98 Proceedings of the seventeenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
An alternative storage organization for ROLAP aggregate views based on cubetrees

SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
On the complexity of the view-selection problem

PODS '99 Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
DynaMat: a dynamic view management system for data warehouses

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
The Asilomar report on database research

ACM SIGMOD Record
Direct spatial search on pictorial databases using packed R-trees

SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
View indexing in relational databases

ACM Transactions on Database Systems (TODS)
System R: relational approach to database management

ACM Transactions on Database Systems (TODS)
WebView materialization

SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Implementation of integrity constraints and views by query modification

SIGMOD '75 Proceedings of the 1975 ACM SIGMOD international conference on Management of data
A case for dynamic view management

ACM Transactions on Database Systems (TODS)
View selection for designing the global data warehouse

Data & Knowledge Engineering - Data warehousing
R-trees: a dynamic index structure for spatial searching

SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
Index Selection for OLAP

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Maintaining Materialized Views in Distributed Databases

Proceedings of the Fifth International Conference on Data Engineering
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total

ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Selection of Views to Materialize in a Data Warehouse

ICDT '97 Proceedings of the 6th International Conference on Database Theory
Fast Computation of Sparse Datacubes

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Materialized Views Selection in a Multidimensional Database

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Materialized View Selection for Multidimensional Datasets

VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Preliminary Design of ADMS±: A Workstation-Mainframe Integrated Architecture for Database Management Systems

VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
Caching Strategies for Data-Intensive Web Sites

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
On the Computation of Multidimensional Aggregates

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
The Logical Access Path Schema of a Database

IEEE Transactions on Software Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

The real world we live in is mostly perceived through an incredibly large collection of views generated by humans, machines, and other systems. This is the view reality. The Opsis project concentrates its efforts on dealing with the multifaceted form and complexity of data views including data projection views, aggregate views, summary views (synopses) and finally web views. In particular, Opsis deals with the generation, the storage organization (Cubetrees), the efficient run-time management (Dynamat) of materialized views for Data Warehouse systems and for web servers with dynamic content (WebViews).