Problem Statement


A typical data mart houses huge amount of data which grows exponentially over time. The key challenges when dealing with such data include :

  1. Manageability of data
  2. Scaleability of data
  3. Query Performance/retrieval of data

Solution : Database Partitioning



What is Database Partitioning ?

Database partitioning is a feature that supports distribution of data across database partitions by using a key-hashing algorithm.

Operation


This tutorial demonstrates the data partitioning technique and highlights the best practices to do the same. The need for creating data partitions and their advantages are analysed. A graph of the query execution time against the tables with data partitioning enabled is generated and the steps to create an explain snapshot displaying partition elimination during query processing are indicated.

Benefits of Database Partitioning


  1. Significantly reduced times for data management operations such as data loads, backup and recovery, index creation and building
  2. Increased scaleability as the data is spread across multiple database partitions
  3. Highly improved query performance as the query executes in parallel on each partition
  4. Significantly reduced impact of downtime for maintainence operations