Types of database system | nibusinessinfo.co.uk (2023)

A database management system is a software package for creating and managing databases. Many different types of database systems exist based on how they manage the database structure.

Two types of database structure

Databases typically have one of two basic forms:

(Video) System databases - What is Master,Model,Msdb,Tempdb and Resource in SQL server

  • single-file or flat file database
  • multi-file relational or structured database

A flat file databasestores data in a plain text file, with each line of text typically holding one record. Delimiters such as commas or tabs separate fields. A flat file database uses a simple structure and, unlike a relational database, cannot contain multiple tables and relations.

A relational databasecontains multiple tables of data with rows and columns that relate to each other through special key fields. These databases are more flexible than flat file structures, and provide functionality for reading, creating, updating, and deleting data. Relational databases use Structured Query Language (SQL) - a standard user application that provides an easy programming interface for database interaction.

(Video) Learn What is Database | Types of Database | DBMS

Types of relationships in a database

Four types of relationships exist in relational database design:

  • one to one - where one table record relates to another record in another table
  • one to many - where one table record relates to multiple records in another table
  • many to one - where more than one table record relates to another table record
  • many to many - where multiple records relate to more than one record in another table

These relations form functional dependencies within the database. Some common examples of relational databases include MySQL, Microsoft SQL Server, Oracle, etc.

(Video) What are the different types of databases in DBMS?

Four types of database management systems

A relational database management system is one of four common types of systems you can use to manage your business data. The other three include:

  • hierarchical database systems
  • network database systems
  • object-oriented database systems

Ahierarchical database modelresembles a tree structure, similar to a folder architecture in your computer system. The relationships between records are pre-defined in a one to one manner, between 'parent and child' nodes. They require the user to pass a hierarchy in order to access needed data. Due to limitations, such databases may be confined to specific uses.

(Video) How To Choose The Right Database?

Network database models also have a hierarchical structure. However, instead of using a single-parent tree hierarchy, this model supports many to many relationships, as child tables can have more than one parent.

Finally, in object-oriented databases, the information is represented as objects, with different types of relationships possible between two or more objects. Such databases use an object-oriented programming language for development.

(Video) Type of Databases in DBMS (Database Management System) Tutorial | Lec -04 Hindi

NoSQL or non-relational databases

A popular alternative to relational databases, NoSQL databases take a variety of forms and allow you to store and manipulate large amounts of unstructured and semi-structured data. Examples include key-value stores, document stores and graph databases.

Which database is right for you?

Businesses with simple database requirements often use standard office tools, such as spreadsheets. However, if you use large amounts of data or have complex business needs, you may need to consider more capable database systems that offer better functionality. Find tips to help you decide which is the best database for your business.

(Video) Database Tutorial for Beginners

See also 5 reasons why your business needs a good database.


1. Database Tutorial for Beginners
(Lucid Software)
2. Types Of Database | Explained | Learn It In Tamil | தமிழ்
(Learn It In Tamil)
(Sundeep Saradhi Kanthety)
4. Database Users
(Neso Academy)
5. Types of Databases | Criteria to choose the best database in the System Design Interview
(Think Software)
6. Spatial database systems and their types
(Introduction to Geographic Information Systems)
Top Articles
Latest Posts
Article information

Author: Rev. Leonie Wyman

Last Updated: 18/05/2023

Views: 6551

Rating: 4.9 / 5 (79 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Rev. Leonie Wyman

Birthday: 1993-07-01

Address: Suite 763 6272 Lang Bypass, New Xochitlport, VT 72704-3308

Phone: +22014484519944

Job: Banking Officer

Hobby: Sailing, Gaming, Basketball, Calligraphy, Mycology, Astronomy, Juggling

Introduction: My name is Rev. Leonie Wyman, I am a colorful, tasty, splendid, fair, witty, gorgeous, splendid person who loves writing and wants to share my knowledge and understanding with you.