… tool must generate to answer those queries. Performance challenges with larger databases, and some ways to help performance using aggregation. Using materialized views to automate that aggregation process… might be necessary to keep the tables in sync. Part five of my series will introduce materialized views which attempt to address these challenges…
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
… tool must generate to answer those queries. Performance challenges with larger databases, and some ways to help performance using aggregation. Using materialized views to automate that aggregation process…, bitmap indexes, table partitioning, parallel query execution, clustered tables and materialized views. These features make working with a star schema much easier…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… is a materialized view(MV)? It explained that an MV can pre-compute joins and may aggregate and summarize data. Using the aggregated… be used to: Monitor a database table, or tables for changes. Improve ETL performance by identifying the data which has changed. Maintain materialized views… script automates the process of adding a table to the list of tables to changelog. It does this by adding an entry to the…
