What is a database?

06 February 2023 By papmall®

A database is a structured collection of data that exists as a file in a data management system and can be accessed through computer applications. Databases can also be stored on memory cards, hard disks, and CDs. Its main feature is to retrieve information and data using various methods. 

By purpose, databases are classified into 4 popular types:

  • File database : This is data stored in the form of files. The most commonly used database file format is *.mdb Foxpro, some other file formats are text, ASCII, and *.dbf.
  • Relational database : This is a different type of data (entities) stored in data tables. Famous relational database support management systems include MS SQL server, Oracle, and MySQL...
  • Object-oriented database : It also represents data in the form of tables. The difference is that the tables provide additional functionalities to replicate or modify existing objects. Management systems that support object-oriented databases are MS SQL server, Oracle, and Postgresql.
  • Semi-structured database : It stores information in XML format. Thanks to the storage of different data types, semi-structured databases provide a new direction in database research and application.

Additionally, there are two classifications of databases according to the operating system as mentioned below:

  • Database using Linux system: MySQL, MariaDB.
  • Database using Windows system: SQL Server – MSSQL.
Do you have any other question? Do you have any other question?

Do you have any other
question?

Contact Us Here

Loading...