Docstoc

Data Warehouse Architectures

Document Sample
Data Warehouse Architectures Powered By Docstoc
					Data Warehouse Architectures




                                    Basic




                               With Staging Area
                      with a Staging Area and Data Marts

                                     Data Warehouse Schema




                                           Start Schema

DATA WAREHOUSE IO Configurations
     Configure I/O for banchwidth not capacity :
     Stripe Far and Wide
     Use Redundancy (冗余)
     Test I/O system before building the Database
     Plan to Growth
Partitioning Methods
     Range Partitioning :maps data to partitions based on ranges of partition key values

				
DOCUMENT INFO