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
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)
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.
NoSQL Databases
Designed for specific data models and have flexible schemas.
Time Series Databases
Optimized for storing and querying data that varies over time.
Last updated