# 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.**


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://www.ankitavirani.com/experience/database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.