What is Database?

In general, the definition of a database is a collection of information or data that is systematically organized in a computer device and can be managed using a Database Management System (DBMS) application program.

DBMS functions to process data and connect the existing databases with their users, allowing various activities such as creating, updating, transferring, and other administrative tasks.

2. Centralized Database

A Centralized Database is the opposite of a distributed database. This type of database is centralized in one location, as opposed to being spread across multiple locations like a distributed database. Users from different locations can access it over the internet, even from a remote distance.

3. Operational (Real-Time) Database

An operational database is also known as On-Line Transaction Processing (OLTP). Its function is to manage and update dynamic data in real-time. An example of this type of database is JavaScript Object Notation (JSON), often used for real-time data exchange between web servers and web browsers.

4. Data Warehouse

Data Warehouse collects current data from various different sources into a centralized and integrated location to generate analytical reports. An example of a data warehouse is Microsoft SQL Server.

5. In Memory Database

An In Memory Database is typically found in hardware devices. It operates primarily from main memory, which means its procedures are quite different when compared to disk-based storage management.

6. Analytical Database

The next type is the Analytical Database, which is used to store and process external big data, such as business information, customer data, and market data for business intelligence analysis. Analytical databases are typically crucial for management in organizations or companies, as well as other users.

7. Navigational Database

A Navigational Database helps users find specific information using related keywords. Typically, the data and information in this type come in the form of objects from various sources or references.

8. External Database

An external database provides access or channels to external parties. This is like when a commercial service requires a specific payment for someone to obtain or access its products or services. These databases are ultimately very useful for end-users and can also be called Commercial Databases, such as Oracle.

9. Hypermedia Database

A Hypermedia Database is a collection of interconnected multimedia pages within a website. Hyperlinks are used to access this type of database. Each webpage is connected via a home page using URL addresses from other sources. The media includes images, music, videos, text, graphics, and more.

10. Relational Database

A Relational Database is one of the most popular and widely used types of databases. In a relational type, each piece of data is linked and organized in tables consisting of rows and columns, with each one representing a data value. Relational databases typically use Structured Query Language (SQL) as the programming language in Relational Database Management Systems (RDBMS). An example of this type of database is MySQL, which is used by various major websites like Facebook, YouTube, and Google.

11. Document Oriented Database

A Document Oriented Database is a computer program designed for document implementation. Unlike relational databases with tabular formats, this type records information in specific document formats.

12. End-User Database

An End-User Database is a type of database managed by the end user using their own workstation. Therefore, data files are independently managed by the user through their preferred methods. End-user databases typically apply to offline documents stored on personal devices. Examples of end-user databases include spreadsheets and downloaded files."