Column-family data model

 

Column-Oriented Databases

Meaning

Column-oriented databases store data column-wise instead of row-wise.

They are designed for:

• Large datasets

• High write throughput

• Distributed systems

---

Examples

• Apache HBase

• Apache Cassandra

---

2. Column-Family Data Model

Meaning

In the column-family model, data is stored as:

• Row Key

• Column Families

• Columns

• Values

It is inspired by Google BigTable.

---

3. Structure of Column-Family Model

1. Row Key

• Unique identifier for each row

• Used to locate data quickly

---

2. Column Family

• A group of related columns

• Defined at schema level

---

3. Columns

• Can be added dynamically

• Not all rows need same columns

---

4. Cell

• Intersection of row key and column

• Stores value and timestamp

---

4. Features of Column-Family Databases

• Schema-flexible

• High scalability

• Distributed storage

• Fast write operations

• Handles sparse data efficiently

---

5. Comparison with RDBMS

Aspect	RDBMS	Column-Family DB
Storage	Row-based	Column-based
Schema	Fixed	Flexible
Scalability	Vertical	Horizontal

---

6. Use Cases

• Event logging

• Time-series data

• Analytics

• Messaging systems

---

7. Advantages

• Efficient storage

• High performance

• Suitable for big data