Based on user requirements, select a partitioning strategy:
Partition applications from the top down.
Use top-down partitioning to split a database onto multiple processors, servers, or computers, which can improve the scalability, reliability, and performance of databases. To achieve the best results with top-down partitioning, create a separate application for each partitioned database.
Partition applications from the bottom up.
Use bottom-up partitioning to manage data flow between multiple related databases, which can improve the quality and accessibility of the data in databases.
Partition databases according to attribute values associated with base dimensions (a standard dimension associated with one or more attribute dimensions).
Use this strategy to extract data based on the characteristics of a dimension, such as flavor or size.
Note: | You cannot partition attribute dimensions. See Attributes in Partitions. |