Skip to main content
Mobius
Beginner

What is a database

Also known as: DB, data base

Definition

A database is an organised collection of information, usually tables of rows and columns, that software can search, update and link, like customers to orders.

Why it matters

Your CRM, your invoicing tool and your online shop all sit on databases, even if you only ever see their screens and exports.

Common mistakes

Having no tested backup, so one failure or one wrong delete erases the order history.

Related terms

Worked exampleIllustration

A small shop's two linked tables

Customers

  • NoaC-1
  • EliC-2
  • MayaC-3

Orders

  • Order 1001C-1
  • Order 1002C-3
  • Order 1003C-1

What the link shows

Eli, customer C-2, appears in no order, so he gets a reminder.

Steps

  1. The Customers table has one row per customer, with a customer number, a name and a phone.

  2. The Orders table has one row per order, with an order number, the customer number and a date.

  3. The customer number in Orders points to exactly one row in Customers, and that is the link.

  4. The question "which customers have not ordered in 90 days?" is answered by joining the two tables on that number.

  5. In a spreadsheet the same answer means copying between tabs by hand, where one typo breaks the match.

A database pays off when your questions cross tables.

Illustration

Tap a customer, follow the link

Customers

NameCustomer no.
NoaC-1
EliC-2
MayaC-3

Orders

OrderCustomer no.
Order 1001C-1
Order 1002C-3
Order 1003C-1

Noa is customer C-1. Orders with that number: Order 1001, Order 1003.

The customer number is the linking column: in Orders it points to exactly one row in Customers.

Follow one tap on Pay

  1. 1PhoneThe customer taps Pay. The page sends the cart and the details.
  2. 2InternetThe request travels over the internet to the shop's server.
  3. 3ServerThe back-end checks the prices again, never trusting the price the phone sent.
  4. 4DatabaseThe database returns the real prices and the stock.
  5. 5Payment providerThe back-end asks the payment provider to charge the card and waits for approval.
  6. 6DatabaseThe database saves the order and reduces the stock.
  7. 7ServerThe back-end sends the answer back to the phone.
  8. 8PhoneThe page shows the thank you message.

Two stops are the database: it answers what is true and keeps what happened.

The database is where the trip stops for facts: the real price, the stock and the saved order.

Definition

A database is a structured collection of data stored electronically so that software can find, add, change and link records quickly. In the common relational kind, the data sits in tables: each row is one record, such as one customer, and each column is one field, such as the phone number. A key links the tables, so the customer number in the Orders table points to one row in the Customers table. The database is the data, and the database management system (DBMS) is the software that runs it, such as MySQL, PostgreSQL, SQL Server or Oracle. SQL is the language used to ask it questions. The relational model comes from a 1970 paper by E. F. Codd at IBM. NoSQL databases store data in more flexible shapes, such as documents, and suit data that does not fit neat tables.

Why it matters

That is where your customer list, order history and stock live, so the database decides which questions you can answer and how fast the application responds. Losing it means losing the business's memory, which is why tested backups are a basic safeguard. Security is set up, not built in: who can read the data, who can change it, and whether passwords are stored as hashes rather than as plain text.

Directly related: Back-end, Server, API.

Improvement tips

  • Keep automated backups away from the database's own server, and test a restore at least once.
  • Give each person and each app only the access it needs, and remove access the day someone leaves.
  • Check that your CRM, shop and invoicing tool can export all your data, and export it regularly.
  • Add indexes on the fields you search most, such as the phone number or the order date, so searches stay fast as the data grows.

Common mistakes

  • Storing passwords as plain text instead of as hashes, one way values that cannot be turned back into the password.
  • Keeping the same customer in several places, so the phone number is updated in one and wrong in the others.
  • Running a growing business on a spreadsheet long after its questions started to cross tables.

Related terms

TechnologyIntermediate

Back-end

Back-end is the part of a website or app that users never see: it saves orders, checks stock, charges cards and keeps accounts, running on a server.

TechnologyBeginner

Server

A server is a computer, or a program on one, that receives requests from other programs, such as a visitor's browser, processes them and sends back an answer.

TechnologyIntermediate

API

An API (application programming interface) is the agreed way one program asks another for data or an action and gets an answer, so your tools can work together.

TechnologyIntermediate

Authentication

Authentication is the check that a user is who they claim to be, using something they know, something they have or something they are.

TechnologyBeginner

Cloud

The cloud, or cloud computing, is renting a provider's servers, storage and software over the internet instead of running your own, paid monthly or by use.

Quick check

Your shop keeps customers and orders in two tables. What lets you see all the orders of one customer?

Choose an answer

Frequently asked questions

Do I need to understand databases before I start my business?
Only the idea: a database is where your records live, in tables of customers, orders and products. It helps you plan which data you collect and ask whether you can get it out again.
When does a database first become relevant for a new business?
The moment you store structured information such as customers, bookings, orders or stock. You probably already use one inside your CRM, shop or invoicing tool, through their screens.
What is the cheapest way to store my startup's data?
Use the database built into the tools you already pay for, such as your shop platform or CRM, or a managed database from a cloud provider, many of which have a free tier for small projects. That way nobody has to install and maintain a database server for you.
Should I use a relational database or a NoSQL database?
For orders, customers, bookings and payments, a relational database with tables is the usual and safer choice. NoSQL suits data that changes shape often or arrives in huge volumes, such as event logs. Your developer should explain the choice in business terms.
Why does database speed matter for a business already running?
As records grow, searches and reports that were instant start to lag, and the whole application feels slow. Indexes, archiving old data and a larger database plan are the usual fixes.
What goes wrong when a business neglects database backups?
A server failure, an attack or one wrong delete can erase years of orders and customer history. Automated backups, stored away from the database and restored in a test now and then, are a basic safeguard.
How do I speed up my database without stopping day to day work?
A developer can add indexes on the fields you search most and cache common requests, usually while the system stays live. Larger changes to the structure are tested on a copy first and released at a quiet hour.
How do I know if my database is insecure?
Warning signs are default admin passwords, access open to the whole internet, former staff who still have logins, and passwords stored as plain text. Ask a developer for a short review of who can reach the database and how.
What does database actually mean in plain words?
Linked spreadsheets with rules. Each table holds one kind of thing, each row is one item, and the rules stop the duplicates and broken links a spreadsheet would allow.
Is editing a database directly risky?
Yes. One wrong command can change or delete thousands of rows at once. Make everyday changes through the application's screens or an admin tool, and let a developer make structural changes after a backup.
Can I use a spreadsheet instead of a database?
For a short list, yes. A spreadsheet's limits appear as you grow: nothing enforces the structure, tabs do not link to each other, permissions per row are weak and very large sheets get slow. When your questions cross several tabs, it is time for a database.
Why does Israeli privacy law use a different Hebrew word?
Developers say מסד נתונים, while the Privacy Protection Law speaks of a מאגר מידע. Knowing both words helps you follow a developer and a lawyer in the same meeting. This page explains the technology and states no legal duties.

Sources: E. F. Codd, A Relational Model of Data for Large Shared Data Banks, Communications of the ACM 13(6), June 1970, pages 377 to 387, DOI 10.1145/362384.362685

Last reviewed: 2026-09-23

I have worked with

What Clients Say

From different fields, at different stages of business

Dan Manto

Eclipse Capital

Real Estate Investment and Finance, USA

Arty McLabin

GameReady

Game Development Education and Outsourcing, International

Anna, Beautician

Anna

Beautician

After I finished a cosmetology course at a leading company, I was confused. I didn't know how to open a business, what to sell from home, or how to bring in clients. Since I reached out to Mobius, everything has changed. We built an organized plan with clear steps and no unnecessary risks. Today I see results, and I'm growing and developing every month.

Mark, Massage therapist, Gan Yavne

Mark

Massage therapist, Gan Yavne

When I finished a massage course, I imagined a different world. I found out it's a hard field, and financial stability isn't easy to find. When I came to Mobius, something changed. We started an organized process and built a business plan. Without Mobius? I probably would have given up. Today I believe in myself and in my own path.

Tech decisions bigger than your team?

Alex helps Israeli businesses choose technology that fits the business, not the hype. The first call is free.

+972 055-248-6151. Better on WhatsApp: I am in meetings most of the day and answer as soon as I am free.