Purpose of partitioning data - microsoft solution framework

Explain the purpose of partitioning data

Data 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.
How do you optimize transactions for good system performance? - MSF
The performance increases on optimizing transactions because: 1. An optimized query targets the exact field data are needed..........
Impact of indexing on data access - microsoft solution framework
Databases indexes are used to improve the speed of operations on database tables. Indexes are created using one or more fields of a table........
Difference between horizontal and vertical partitioning of data - microsoft solution framework
Horizontal partitioning of data refers to storing different rows into different tables. E.g.: Students with their first name starting from A-M are stored in table A........
Post your comment