Sciweavers

259 search results - page 4 / 52
» Using Relational Database Constraints to Design Materialized...
Sort
View
CIS
2004
Springer
13 years 9 months ago
Utilizing Staging Tables in Data Integration to Load Data into Materialized Views
rces. A data warehouse can be abstractly seen as a set of materialized views. Selecting views for materialization in a data warehouse is one of the most important decisions making ...
Ahmed Ejaz, Kenneth Revett
SIGMOD
1999
ACM
108views Database» more  SIGMOD 1999»
13 years 9 months ago
DynaMat: A Dynamic View Management System for Data Warehouses
Pre-computation and materialization of views with aggregate functions is a common technique in Data Warehouses. Due to the complex structure of the warehouse and the different pro...
Yannis Kotidis, Nick Roussopoulos
SIGMOD
1997
ACM
159views Database» more  SIGMOD 1997»
13 years 9 months ago
On-Line Warehouse View Maintenance
Data warehouses store materialized views over base data from external sources. Clients typically perform complex read-only queries on the views. The views are refreshed periodical...
Dallan Quass, Jennifer Widom
SPE
2008
140views more  SPE 2008»
13 years 5 months ago
A relational-XML data warehouse for data aggregation with SQL and XQuery
: Integration of multiple data sources is becoming increasingly important for enterprises that cooperate closely with their partners for e-commerce. OLAP enables analysts and decis...
Joseph Fong, Herbert Shiu, Davy Cheung
PVLDB
2010
115views more  PVLDB 2010»
13 years 3 months ago
CORADD: Correlation Aware Database Designer for Materialized Views and Indexes
We describe an automatic database design tool that exploits correlations between attributes when recommending materialized views (MVs) and indexes. Although there is a substantial...
Hideaki Kimura, George Huo, Alexander Rasin, Samue...