Breaking News: Grepper is joining You.com. Read the official announcement!

database partitioning

Innocent Iguana answered on February 22, 2023 Popularity 9/10 Helpfulness 4/10

answer database partitioning

database partitioning

Comment

- Data is managed across multiple partitions
- Split large tables into smaller tables
- Each partition holds a subset of data
- Common in very large volume of data ( data warehousing and BI analytics)
- Things/Topics that go hand-in-hand with database paritioning:
1. Table Spaces:
	- Structures that contain one or more database objects
    - Used for mapping between logical database objects and physical storage 
    	containers that house the database objects
2. Containers:
	- Physical storage medium used to store different table space
    - Fast SSD container for heavily used files
3. Storage Groups
	- Group of containers based on similar characteristics
    - Allows multi-temparature data management with ease for different table-spaces.
    	- Hot group : Very frequently used data
        - Warm group : Somewhat frequently used data
    	- Cold group : Least frequently used data
Table Space, containers, Storage Groups help to
	- Optimize performance
    - Backup and restore data more conveniently
    - Storage management allows extending ability for datafiles or containers

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: database-partitioning sql

Link to this answer
Share Copy Link

Contributed on Feb 22 2023

Innocent Iguana

0 Answers Avg Quality 2/10

database partitioning

Contents

More Related Answers

database partitioning

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.