Lesson 01 ~25 min read

What is a Database?

Before writing a single line of SQL, you need to understand why databases exist. The answer starts with a problem — and the story of how data management evolved to solve it.

The Problem Databases Solve

Imagine a school that tracks 2,000 students, their courses, grades, and teachers — all in paper files or a stack of spreadsheets. Finding a student's record means searching through hundreds of pages. Updating an address means finding every place that address appears. Adding a new course means editing dozens of files.

This is the problem databases were created to solve. A database is an organised collection of structured information stored and managed so it can be efficiently accessed, updated, and retrieved — by one person or by thousands simultaneously.

// Definition

A database is a structured set of data held in a computer so that it can be accessed in various ways. The term comes from "data" + "base" — a foundation or repository for storing information.

Data vs Information vs Knowledge

These three terms are often confused. Understanding the distinction helps clarify what databases actually store and why organisation matters.

Data

Raw, unprocessed facts with no context. Example: 21, Kondwani, 2025-03-01. Alone, these are meaningless.

Information

Data that has been processed and given context. Example: "Kondwani enrolled on 2025-03-01 and is 21 years old." Now the numbers mean something.

Knowledge

Information applied to decision-making. Example: "Students who enrol before March typically complete the course — let's prioritise March intake."

Databases store data. Applications turn that data into information. Humans use that information to build knowledge.

Before Databases — File-Based Systems

Before databases existed, applications stored data in flat files — text files or binary files on a hard drive. Each application managed its own files. This caused serious problems that led directly to the invention of the modern database.

Data Redundancy

The same data stored in multiple places. A student's name might appear in a registration file, a grades file, and a fees file — three copies that could become inconsistent.

Data Inconsistency

When redundant copies aren't updated together, you get inconsistent records. One file says the student lives on Main Street; another still says Oak Avenue.

Data Isolation

Data scattered across many files in different formats. Writing a program to combine information from two files was complex and brittle.

No Concurrent Access

If two people tried to update the same file simultaneously, one would overwrite the other's changes — no protection against conflicting edits.

Security Problems

Files had limited access control — either someone could read the whole file or none of it. No way to say "this user can see names but not salaries."

What a Database Provides

A database system addresses every problem listed above by centralising data management and providing a controlled interface between the data and the applications that use it.

database benefits

FILE-BASED SYSTEM          DATABASE SYSTEM
────────────────────────   ──────────────────────────
Data scattered in files  → Data centralised, one place
Redundant copies         → Single source of truth
Manual consistency       → Enforced by constraints
One user at a time       → Thousands of concurrent users
All-or-nothing security  → Fine-grained permissions
No backup system         → Built-in recovery tools
Custom query code        → Standard query language (SQL)

Databases in the Real World

Every digital system you use daily relies on databases. They are the silent infrastructure of the modern world.

Banking

Your account balance, every transaction, every transfer — stored and protected in databases that must never lose or corrupt a single record.

Healthcare

Patient records, medical history, prescriptions, lab results — databases that can mean the difference between life and death if corrupted.

E-commerce

Products, inventory, orders, customers, reviews — Amazon processes millions of database queries per second to serve its customers.

Social Media

User profiles, posts, likes, follows, messages — Facebook stores over 100 petabytes of data distributed across thousands of servers.

Education

Student records, enrolment, grades, course materials — the system you're using right now stores lesson progress in a database.

// Knowledge Check

A school stores student records in separate files for each department. The IT department updates a student's address but the fees office still has the old address. What database problem does this illustrate?