Database Partitioning

What is a database table partitioning? Partitioning is the process of dividing large database table into smaller parts. Partitioning helping in making queries fast, as after dividing large table, queries have to access smaller data. What are different ways of partitioning? Two ways: Horizontal partitioning Vertical partitioning What is Vertical Partitioning? Vertical table partitioning is…

Columnar Database

What is columnar database? It is a type of NoSQL database, also called wide-column store or extensible record stores.  It uses tables, rows, and columns, but names and format of the columns can vary from row to row in the same table.  While a relational database is optimized for storing rows of data, typically for…

BitMap Indexing in Database

What is bitmap indexing? Bitmap Indexing is a type of database indexing that uses bitmaps. Bitmap indexes provide greatest advantage when applied on columns having low cardinality, that is, columns in which the number of distinct values is small compared to the number of rows in the table. What is Cardinality? Cardinality means uniqueness of…