![]() The database administrator creates one or more materialized views, which are the equivalent of a summary. Materialized views can perform a number of roles, such as improving query performance or providing replicated data. The summaries or aggregates that are referred to in this book and in literature on data warehousing are created in Oracle Database using a schema object called a materialized view. For example, you can create a summary table to contain the sums of sales by region and by product. Summaries are special types of aggregate views that improve query execution times by precalculating expensive joins and aggregation operations prior to execution and storing the results in a table in the database. One technique employed in data warehouses to improve performance is the creation of summaries. Usually, the vast majority of the data is stored in a few very large fact tables. ![]() Data warehouses commonly range in size from hundreds of gigabytes to a few terabytes. The data is normally processed in a staging file before being added to the data warehouse. Typically, data flows from one or more online transaction processing (OLTP) database into a data warehouse on a monthly, weekly, or daily basis. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |