What is a database?
What is a database?
A database is an organized collection of information stored electronically so that it can be viewed, updated and managed easily. Instead of leaving data scattered across loose papers, computer files or messy spreadsheets, a database keeps it all in one place, with a defined structure and clear rules for storing and retrieving each piece of data. When someone opens the contact list on their phone, browses the catalogue of an online store or watches a cashier check the price of a product, they are using a database, even if they do not realize it.
This article explains, with simple examples and no unnecessary jargon, what a database is, how it is organized, what the main types are, what a database is for in a business, what a database management system is, and why the concept matters so much for inventory control.
A simple definition of a database
In formal terms, a database is a collection of information that is organized and stored electronically so that a program can find and change it quickly. The word base refers to the foundation that something rests on, while data are the pieces of information: names, prices, dates, quantities and addresses. Putting both ideas together gives the key to the concept: ordered information that a business or an application can rely on in order to work properly.
What makes a database different is not the amount of information but the order. A drawer full of receipts can hold the same information as a database, but finding anything in it takes hours, and avoiding mistakes is almost impossible. A database works like a well-organized library: every book has its place, every card shows where to find it, and any authorized person can take it and return it without disturbing the rest. That order is what makes it possible to answer questions such as how many units of a product were sold last month or which customers have pending payments.
Examples of databases in everyday life
Databases are much closer to daily life than it seems. Some examples that almost everyone uses every day are:
- The contact list on a phone, which stores names, numbers and e-mail addresses and lets you find them in seconds.
- The catalogue of an online store, which shows products, prices, photos and availability to thousands of visitors at the same time.
- The customer records of a business, where the data, purchases and payment history of each client are kept.
- The system of a bank, which manages the accounts, transactions and balances of millions of people.
All these systems work on the same principle: the information is stored once, in an organized way, and any search finds the answer without going through papers or loose files.
Basic concepts: tables, records and fields
To understand how a database is organized, it helps to know three terms that appear in every manual and in every conversation with a software developer:
| Concept | What it is | Example |
|---|---|---|
| Table | A set of information of the same type, organized in rows and columns | The Products table, which brings together every item the business sells |
| Record (row) | One complete piece of information; each line of the table | A specific product with its name, its price and its quantity in stock |
| Field (column) | A specific attribute that is repeated in every record | The Price column, where each product has its own value |
A table can store, for example, the information of customers: each row or record is a customer, and each column or field holds one piece of data about that customer, such as his or her name, phone number or city. When people talk about saving, searching or updating a piece of data, they are always talking about working with records and fields inside tables.
Types of databases: relational and non-relational
Although there are many ways to classify databases, the best-known division separates two large families: relational and non-relational. Relational databases, also called SQL after the language used to query them, organize information in tables that are related to one another. The database of a store can have a customers table, a products table and a sales table, and each sale is connected to the customer and the product involved. That connection between tables is what keeps the information consistent and free of duplicates.
Non-relational databases, known as NoSQL, store information in a more flexible way, for example as documents, and are useful when data changes format often or when enormous volumes must be handled, as happens on social networks or in data analytics applications. For most businesses, relational databases are the most common choice because they offer order, security and support.
| Aspect | Relational (SQL) | Non-relational (NoSQL) |
|---|---|---|
| Structure | Data in tables with defined rows and columns | Flexible data: documents, keys or graphs |
| Relationships | Tables connected to each other through keys | Each record stands on its own |
| Design time | The structure is defined before storing the data | The structure can grow and change easily |
| Example systems | MySQL, PostgreSQL, SQL Server, Oracle | MongoDB, Redis, Cassandra |
| When they fit | Sales, customers, inventory and accounting | Applications with changing data and huge volumes |
Choosing between one family and the other depends on the type of information and the use it will receive. For a business that must keep track of sales, customers and inventory, a relational database is, in most cases, the wisest decision.
What a database is for in a business
A database acts as the organized memory of a business: it stores the information that is consulted every day and that is used to make decisions. The most common uses are:
- Storing products: name, reference, price, cost and available quantity of every item.
- Recording sales: every sale is written down with its date, its products, its quantities and its total value.
- Managing customers: contact details, purchase history, invoices and account status of each customer.
- Tracking suppliers: who sells each input, at what price and under what payment terms.
With that information in order, a business can answer in seconds questions that would otherwise take days: which is the best-selling product of the month, which customers owe money, how much it costs to keep the current inventory or how much was sold last year in the same season. That querying power turns data into a real management tool.
What is a database management system (DBMS)
The database is the ordered information, but someone has to create it, protect it and answer the queries. That job is done by a database management system, known by its initials DBMS. It is a program that makes it possible to create databases, store information in them, query it, modify it and delete it, and it also controls who is allowed to perform each of those tasks.
Among the best-known relational database management systems are MySQL, PostgreSQL, SQL Server and Oracle. These are mature programs used by millions of companies around the world, offering features such as permissions per user, automatic backups and the ability for several people to work on the same information at the same time without damaging the data.
It is worth telling the two concepts apart: the database is the information itself, like the content of a file, while the management system is the program that administers it, like the software that lets you open, edit and save that file.
Differences between a database and a spreadsheet
Many small businesses start by keeping their records in spreadsheets such as Excel or Google Sheets, and for certain tasks that tool is enough. Confusing the two is normal, because a spreadsheet also organizes data in rows and columns. The difference appears when the information grows and several people must work with it.
| Aspect | Spreadsheet | Database |
|---|---|---|
| Purpose | Analysis and calculations over personal or small-team data | Managing the information of an entire business |
| Capacity | Comfortable up to a few thousand rows | Built for millions of records without losing speed |
| Users | One or a few people at a time, with the risk of overwriting each other's changes | Many simultaneous users, with permissions per person |
| Security | Hard to control who changes what | Permissions, backups and a record of changes |
| Relationships | Connecting several sheets without errors is difficult | Connected tables that avoid repeated data |
In a spreadsheet, anyone can delete a formula or change a value with no trace left behind. In a database, each user has permissions, changes are controlled, and information about sales, customers and inventory can be linked without duplicating it. When a business grows and needs several people to consult and update the same information reliably, the time has come to move from the spreadsheet to a database.
Why a database is essential for inventory
Inventory is one of the places where the difference between working with organized information and working with paper is most noticeable. A warehouse or a store is in constant motion: goods come in from suppliers, products go out through sales, and returns, adjustments and losses happen all the time. Each of those movements must be recorded so that it is possible to know, at any moment, what there is and how much.
The orderly record of those inflows and outflows is what is known as a stock card or kardex: a record that follows the life of every product and shows its entries, its exits and its balance. Keeping the kardex by hand or on loose spreadsheets is slow and error-prone, because one wrong entry repeats itself in every calculation that follows. With a database, products and their movements are stored once, the balance updates itself, and any question about the state of the inventory is answered instantly.
That is the principle behind modern inventory management tools. A kardex program built on a database can show the exact cost of what is in the warehouse, detect shortages or surpluses in time, value the inventory and prevent losses caused by disorganization. For a business that sells products, the question is not whether it needs a database, but when it should start using one. Tools such as Kardex Tauro handle that work by keeping inventory and stock cards on secure databases, so that the owner of the business can focus on selling.