Database management system (DBMS)

Data System Architecture


A DBMS 1) is an application that controls:

  • the organization,
  • storage,
  • management,
  • and retrieval of data.

A database is a collection of permanently stored data used by an application or enterprise. A database contains logically related data, which means that the database was created to represent the real-world.

All databases are not built on the relational model, see Database - Model

When people use the word database, fundamentally what they are saying is that the data should be self-describing and it should have a schema. That's really all the word database means.

The databases were born to insert into.

A collection of information organized to afford efficient retrieval

They are also known as storage engine.




Mutable vs Immutable

After writing data:

Key Features

Why would I want a database? What problem do they solve?

  1. Sharing. Support concurrent access by multiple readers and writers
  2. Data Model Enforcement. Make sure all applications see clean, organized data
  3. Scale. Some work with datasets too large to fit in memory
  4. Flexibility. Use the data in new, unanticipated ways. Abstraction … Layer between physical and logical.

Documentation / Reference

  • Bill Howe, PhD (Director of Research, Scalable Data Analytics) University of Washington - eScience Institute

Discover More
Data System Architecture
(Data|State|Operand) Management and Processing

This section is and state management as opposed to code. System that manages data are called database. In a computer, there is two kinds of byte instruction byte and data byte. This section is...
Card Puncher Data Processing
Data Storage - (Repository|Data Store)

Repository commonly refers to a location for storage, often for safety or preservation. Two main forms of repository implementation exist: through a database or via a file system with files (xml,...
Card Puncher Data Processing

This section regroups all databases that manages data including SQL engine. If you are interested in a ranking: Db Engine Ranking
Data System Architecture
Database - Document Database

A document database is a database that can store and retrieve a document (generally a json document) at once. The data unit is generally not the record as in a relational database but the document. ...
Essbase Data Source Record Fields
Essbase - Data Source

A data source is external data that is loaded into an database with the help of one this two process : Data sources contain the information that you want to load into the Essbase database. A data...
Undraw File Manager Re Ms29
File System Delete

delete is a file system operation that will delete a file. Because the unit of persistent on a file system is the file, you can't delete byte. If you want to delete byte of your files physically with...
Card Puncher Data Processing
IO - Block (Batch on device)

A block is a unit of storage representing a fix number of bytes called the block size. It's also known as the minimum unit of transfer. It implements the concept of batch where data is organized into...
Card Puncher Data Processing
ODBC - Open Database Connectivity

In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). The designers of ODBC aimed to make it independent of programming languages,...
Card Puncher Data Processing
Oracle Data Integrator (ODI formerly Sunopsis)

Oracle Data Integrator employs a powerful declarative design approach to ETL, which separates the declarative rules from the implementation details. Oracle Data Integrator is also based on a uniqueElRDBMOracle...

Share this page:
Follow us:
Task Runner