# Some Popular Database Systems

There are some big, expensive, **enterprise** database systems like Oracle, IBM DB2 Universal Database, Sybase etc.

They have lots of features, work on multiple platforms and can scale to multiple machines.

There are other database systems like MySQL Server that have lots of features and decent performance, but are relatively cheaper. However, MySQL Server only runs on Windows platform.

On the other hand, there are systems like MS Access that are cheap, easy to use but have limited functionality.

The following are some **open-source** database systems:

* **MySQL**
  * Limited SQL, not good for OLAP
  * Limited transaction support but fast lookups
  * Extremely widely used, e.g., web servers (Linux Apache MySQL PHP - LAMP)
* **PostgreSQL**
  * Rich SQL features, decent query optimizer
  * Not as widely used but popular in academia
* **SQLite**
  * SQL transactional DB
  * server-less
  * self-contained
  * zero-configuration
* **Berkeley DB**
  * No SQL support
  * Embedded database, a few hundred KB size
  * Basically a library of disk-based data structures with support for transactions
* **MapReduce, BigTable, PNuts, Dynamo, and others**
  * No SQL support
  * Used for data and text analysis (search engines etc) or to keep live data


---

# 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://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/some-popular-database-systems.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.
