A database keeps application information organized
An application may use a database for customer records, requests, inventory, appointments, or other information that needs to remain available over time.
A database is a managed digital system for storing, organizing, securing, and retrieving collections of data used by people or software.
Structure gives records meaning
A database does more than place information in one location. Its structure defines what each record represents and how records relate. A service request, for example, may connect to one customer, one assigned worker, and several updates.
Relational databases organize this information in tables with rows and columns. Other database types use different structures. The useful choice depends on the data and how the application needs to work with it.
Access needs rules
The database management system controls how people and applications create, read, update, and remove information. The application should add permission and validation rules that match the business.
Plan corrections and unusual cases early. Duplicate customers, canceled requests, and changed assignments can expose weak data definitions long before the database runs out of storage.
Database terms
- Record
- A stored set of related facts about one item, event, or person.
- Database management system
- Software that organizes stored data and controls how people and applications work with it.
- Relational database
- A database that organizes related information in tables made of rows and columns.
Questions your data model should answer
What is one record
Define the difference between a customer, request, invoice, task, or other business item.
How records relate
Decide which items belong together and whether one can connect to several others.
Who may change it
Set access rules for reading, creating, correcting, and removing information.
Questions about databases
A spreadsheet stores information in cells and can resemble a table. A database is a centrally managed system built to organize data, control access, and support more advanced ways of working with records.
It is a database that stores related data in tables made of rows and columns. Connections between tables can represent relationships such as a customer having several orders.
An application needs a database when information must be saved, found, changed, and shared consistently. The database gives that information a managed home after a screen closes or a session ends.
Related glossary guides
Give your business information a home
Caffeine apps run on the Internet Computer, a public network built for this.