Database Introduction

What is a Database?

A database is a collection of data organized to support user operations efficiently. It provides a structured way to store, retrieve, and manage information.

Structure of a Database System

Structure of a Database System

• Frontend: The client side, typically accessed through a browser.

• Backend: Comprises the database and application server.

• Database: The component where data is stored.

• Application Server: The component that processes business logic and handles client requests.

Types of Databases

Relational Databases (SQL Databases)

Relational Databases

• Use Structured Query Language (SQL) to interact with the relational model.

  • Tables: Sets of named relations or tables.

    • Each table has a unique name.

    • Contains attributes (columns) with constraints to ensure data integrity.

  • Record: A line of relation or a row in the table.

    • Contains values for each column.

    • Each column has a specific data type.

Relational Databases

NoSQL Databases

Designed for specific data models and have flexible schemas.

NoSQL Databases

Time Series Databases

Optimized for storing and querying data that varies over time.

Time Series Databases