What is Data partitioning?

0 votes
Hi!!

I am new to the database, can someone tell me what exactly data partitioning is and how does it benefit us?
Aug 22, 2018 in Database by CodingByHeart77
• 3,680 points
103 views

1 answer to this question.

0 votes

This is the process of partitioning tables, indexes into smaller pieces in order to manage and access the data at a finer level.

This reduces the cost of storing a large amount of data as well as enhances the performance and manageability.

Database partitioning also gives us the following advantages:

  1. Improves query performance and manageability.
  2. Simplifies common administration tasks.
  3. Acts as a key tool for building systems with extremely high availability requirements.
  4. Allows accessing a large part of a single partition.
answered Aug 22, 2018 by DataKing99
• 8,100 points

Related Questions In Database

0 votes
1 answer

What is Data Redundancy?

Duplication of data in the database is ...READ MORE

answered Aug 16, 2018 in Database by darklord
• 6,140 points
91 views
0 votes
1 answer

What is the best way to fetch data from table?

Hey Shraddha, I understand your doubts about fetching ...READ MORE

answered May 24 in Database by Sampriti
• 860 points
16 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,360 points
68 views
0 votes
1 answer

What is Proactive/Retroactive/Simultaneous Update

Proactive Update: The updates that are applied ...READ MORE

answered Aug 17, 2018 in Database by CodingByHeart77
• 3,680 points
126 views
0 votes
1 answer

What is schema?

The description of a database is called ...READ MORE

answered Aug 17, 2018 in Database by CodingByHeart77
• 3,680 points
36 views
0 votes
3 answers

What is Phantom deadlock?

To understand phantom deadlock, you need an ...READ MORE

answered Feb 13 in Database by Ravi kumar
1,200 views
0 votes
1 answer

What is checkpoint in Database?

Checkpoint declares a point before which all ...READ MORE

answered Sep 4, 2018 in Database by darklord
• 6,140 points
96 views
0 votes
1 answer

What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,140 points
55 views
0 votes
1 answer

What is Functional dependency?

A relation is said to be in ...READ MORE

answered Aug 10, 2018 in Database by DataKing99
• 8,100 points
33 views
0 votes
1 answer

What is Normalization of database?

Normalization is the process of organizing data ...READ MORE

answered Oct 8, 2018 in Database by DataKing99
• 8,100 points
81 views