> For the complete documentation index, see [llms.txt](https://www.ankitavirani.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.ankitavirani.com/experience/database.md).

# Database

Databases are categorized based on their structure, data organization, and access methods. Here are some common types:

#### 1. Relational/SQL Databases

* **Relational Database Management System (RDBMS):** Organizes data in tables with rows and columns. Each row represents a record, and each column represents a field. Relationships between tables are defined using foreign keys.
  * **Examples:** MySQL,PostgreSQL,Oracle,SQL Server

* **Object-Relational Database Management System (ORDBMS):** Combines the features of relational databases with object-oriented programming concepts. It allows for the storage and retrieval of complex data objects.
  * **Examples:** Microsoft SQL Server,Oracle Database,PostgreSQL,DB2

#### 2. NoSQL Databases

* **Document Databases:** Store data in flexible, document-oriented structures, often using JSON or BSON.
  * **Examples:**MongoDB,CouchDB,Firebase
* **Key-Value Stores:** Store data as key-value pairs, where keys are unique identifiers and values can be any type of data.
  * **Examples:**Redis,Memcached,DynamoDB
* **Wide-Column Stores:** Store data in wide columns, where each column can have multiple values associated with a specific row.
  * **Examples:**Cassandra,HBase
* **Graph Databases:** Store data as nodes and relationships between them, forming a graph structure.
  * **Examples:**Neo4j,ArangoDB,OrientDB

#### 3. Other Types

* **Time Series Databases:** Specialized for handling time-stamped data, often used in IoT, finance, and scientific applications.
  * **Examples:**InfluxDB,TimescaleDB
* **Spatial Databases:** Designed to store and query spatial data, such as geographic locations and shapes.
  * **Examples:**PostGIS,MongoDB
* **Multi-Model Databases:** Support multiple data models, allowing you to choose the best approach for different types of data.
  * **Examples:**Couchbase,ArangoDB

### Types of Databases and Their Examples

**Here's a more detailed table with examples for each type:**

| Database Type                       | Data Format                    | Example                                                           |
| ----------------------------------- | ------------------------------ | ----------------------------------------------------------------- |
| Relational Database (RDBMS)         | Tables with rows and columns   | Customer database with tables for customers, orders, and products |
| Object-Relational Database (ORDBMS) | Tables with complex data types | E-commerce database storing products as objects                   |
| Document Database                   | JSON or BSON documents         | Blog database storing posts, comments, and authors as documents   |
| Key-Value Store                     | Key-value pairs                | Caching system storing frequently accessed data                   |
| Wide-Column Store                   | Wide columns                   | Sensor data database storing measurements                         |
| Graph Database                      | Nodes and relationships        | Social network database representing users and connections        |
| Time Series Database                | Time-stamped data              | Financial database storing stock prices                           |
| Spatial Database                    | Spatial data                   | Mapping application storing locations                             |
| Multi-Model Database                | Varies                         | Complex application using document, graph, and key-value models   |

**The choice of database and data format depends on the specific requirements of  application, such as the type of data, query patterns, and scalability needs.**