What is a Database?

Spreadsheets are stand-alone files built to handle small amounts of data. A database is a central source, or hub, that users, applications, websites, and dashboards can access at once. Databases also enforce rules—validating data, controlling who can see or change it, and maintaining accuracy across millions of records. Spreadsheets are great for personal or small-team tasks, but most applications outgrow them quickly.

A database is a system that stores information in an organized way so it can be retrieved, updated, and managed efficiently. Instead of keeping information in separate files or spreadsheets, a database centralizes data so applications can access it quickly and reliably.

The five most common data models are relational (structured tables with rows and columns), document (flexible JSON-like records), key-value (fast lookups that return a single value), vector (meaning-based search using numerical codes), and graph (designed to analyze relationships between data points). Most modern applications use more than one type depending on the workload.

SQL-based, relational databases store data in structured tables with fixed schemas and use SQL for queries. They excel at maintaining strict data integrity and handling complex joins across tables. NoSQL-based databases offer flexible schemas and horizontal scaling and are often better suited for unstructured or rapidly changing data. The right choice depends on the application's data structure and performance requirements.

A DBMS (database management system) is the software that controls how a database stores, organizes, secures, and retrieves information. It handles indexing, permissions, transactions, and optimization so applications can access data safely and efficiently. A database management system enforces these access rules automatically.