Explain the purpose of partitioning dataData is often partitioned to achieve better maintainability and accessibility. For example, in case of a data warehouse, partitioning can help in efficient and effective access to different database segments at different locations based on need. This helps in developing BI solutions which guide the management to better drive their business and achieve customer satisfaction. One could have many facts and dimension tables and perform slicing and dicing of information to achieve predictability or extract business rules. Data warehouses can be huge in volume which makes it necessary to partition data to achieve more robustness and better performance. Partitioning also enhances data availability which is important for critical data needed by some BI users often.
|