INTRODUCTION TO DATABASE SYSTEM

 A Database System is an organized collection of data and the system used to manage, store,
and retrieve that data.
 Designed to store vast amounts of data in a structured way, making it easier to manage, query,
and retrieve information efficiently.
 Essential tools for businesses, governments, and individuals by providing a reliable way to
manage data, ensure its integrity, and enable its use in various applications.

Types of Databases
1. Relational Databases
 Relational Databases (RDBMS) store data in tables (called relations) that are organized into
rows and columns.
 Relational databases use Structured Query Language (SQL) to query and manage data.
Example:
 A customer table in an RDBMS might look like this:

 Advantages: Highly structured data, Supports complex queries and joins between
tables. Ensures data consistency and integrity.
 Popular Relational Databases: MySQL, PostgreSQL, Oracle, and Microsoft SQL Server
2. NoSQL Databases
 NoSQL Databases store data in a non-relational format, allowing for flexible schemas and
supporting unstructured or semi-structured data. NoSQL databases are designed to scale
horizontally and are often used in applications that require handling large amounts of
distributed data.
Types of NoSQL Databases:
 Document Stores: Store data as documents (e.g., MongoDB).
 Key-Value Stores: Store data as key-value pairs (e.g., Redis).
 Column Stores: Store data in columns rather than rows (e.g., Cassandra).
 Graph Databases: Store data in graph structures with nodes and edges (e.g., Neo4j).
Example (Document Store):
 A customer record in a NoSQL document store like MongoDB might look like this:
3. In-Memory Databases
 In-Memory Databases store data in the main memory (RAM) rather than on disk, allowing for
faster data access. These databases are often used in applications that require high - speed
transactions or real-time data processing.
Example:
 Redis is a popular in-memory database used for caching, real-time analytics, and
message brokering.
Advantages:
 Extremely fast data access.
 Ideal for real-time applications and caching.
4. Cloud Databases
 Cloud Databases are hosted on cloud platforms such as Amazon Web Services (AWS),
Microsoft Azure, and Google Cloud. Cloud databases provide scalable storage, on - demand
resources, and managed services, allowing organizations to avoid the overhead of maintaining
their own data infrastructure.
Advantages:
 Scalability and flexibility.
 Reduced infrastructure and maintenance costs.
 Managed services with automated backups and scaling.

Key Components of a Database System

1. Tables (For Relational Databases)
 Tables represent the core structure of a relational database, where data is stored in rows and
columns. Each table contains records (rows) and attributes (columns).
Example: A customer table stores customer information, such as name, email, and address.
2. Indexes
 Indexes are used to speed up data retrieval by creating pointers to the rows in a table. They
are especially useful for improving query performance in large datasets.
Example: An index on the "Email" column of the customer table allows for faster searches based on
email addresses.
3. Queries
 Queries allow users to retrieve and manipulate data stored in a database. In relational
databases, SQL queries are used to select, insert, update, or delete data.
Example: Retrieving all customers with a specific email domain:
4. Transactions
 A transaction is a sequence of operations performed as a single, logical unit of work. ACID
properties (Atomicity, Consistency, Isolation, Durability) ensure that transactions are processed
reliably in database systems.
Example: Transferring funds between two bank accounts is a transaction that ensures both the debit
and credit operations occur together or not at all.
5. Schemas
 A schema defines the structure of a database, including the tables, fields, relationships, and
data types. It acts as a blueprint for organizing the data in a relational database.

Importance of Database Systems

 Data Management: Database systems provide a centralized way to manage large amounts of
data efficiently, allowing users to store, update, retrieve, and analyze data with ease.
 Data Security: Databases enforce strict security measures to protect sensitive information,
ensuring that only authorized users have access to the data.
 Scalability: Modern database systems are designed to scale as data grows, ensuring that
organizations can handle large datasets without performance degradation.
 Data Integrity: Database systems maintain data integrity through constraints, rules, and
relationships, ensuring that data remains accurate, consistent, and reliable.
 Support for Complex Queries: Database systems allow users to run complex queries and
analytics, helping organizations make informed decisions based on data insights.

Common Use Cases of Database Systems

 E-Commerce: Databases store product catalogs, customer information, and transaction
records for online retailers, enabling smooth order processing and inventory management.
 Banking: Financial institutions rely on databases to manage account balances, transactions,
and customer data securely, while supporting millions of daily operations.
 Healthcare: Healthcare providers use databases to store patient records, appointments,
treatments, and billing information, ensuring quick access to critical data while complying with
privacy regulations.
 Social media: Social media platforms use databases to store user profiles, posts, comments,
and interactions, enabling real-time engagement at a massive scale.
 Education: Educational institutions use databases to manage student records, course
information, enrollment, and grades.
Challenges in Database Systems
 Data Security: Protecting sensitive data from unauthorized access, breaches, and
cyberattacks is a top priority for organizations, especially in industries like finance and
healthcare.
 Scalability: As data grows, database performance can suffer if the system isn't optimized to
handle large-scale queries, transactions, and operations.
 Data Integrity: Ensuring that data remains accurate and consistent across multiple systems or
users requires careful management, especially in distributed environments.
 Database Maintenance: Regular backups, indexing, and performance tuning are necessary to
keep the database running efficiently.

Database System vs. File Processing System

What is a File Processing System?
 A File Processing System (FPS) is a method of storing and managing data using individual
files. Each file is independent and typically contains data related to a specific task or
department. File systems rely on programs to process the data stored in each file, often using
flat files (like text files) to store data.
Key Characteristics:
 Independent Files: Data is stored in separate files without any links or relationships between
them.
 Data Redundancy: Since files are independent, the same data may be duplicated across
multiple files.
 Manual Management: Data processing often requires manual intervention or custom
programs to
 access and manipulate the data.
 Low Scalability: File systems become harder to manage as the volume of data grows.
Example:
 A company's employee data might be stored in several independent files:
o Employee Personal Details (Name, Address, Phone)
o Employee Payroll Data (Salary, Benefits)
o Employee Work History (Projects, Positions)

Database System?
 more advanced and structured system
 organizes data into tables (or other structures like documents in NoSQL databases)
 provides tools to efficiently store, retrieve, manipulate, and manage large amounts of data
while ensuring data integrity, security, and consistency.
Key Characteristics:
 Structured Data: Data is organized into tables with predefined relationships between them.
 Centralized Management: Data is stored and managed in a centralized system, allowing for
coordinated access and manipulation.
 Data Integrity: Ensures that data remains accurate and consistent.
 High Scalability: Databases are designed to handle large volumes of data and can scale as
data need grow.
 ACID Properties: Database transactions follow Atomicity, Consistency, Isolation, and
Durability principles for reliable data operations.

Types of Database Users

Naive Users (End Users)
 Unsophisticated users who have zero knowledge of database system
 End user interacts to database via sophisticated software or tools
 e.g. Clerk in bank
Application Programmers
 Programmers who write software using tools such as Java, .Net, PHP etc...
 e.g. Software developers
Sophisticated Users
 Interact with database system without using an application program
 Use query tools like SQL
 e.g. Analyst
Specialized Users (DBA)
 User write specialized database applications program
 Use administration tools e.g. Database Administrator
 e.g. Database Administrator

Role of DBA (Database Administrator)

Schema Definition
 DBA defines the logical schema of the database.
Storage Structure and Access Method Definition
 DBA decides how the data is to be represented in the database & how to access it.
Defining Security and Integrity Constraints
 DBA decides on various security and integrity constraints.
Granting of Authorization for Data Access
  DBA determines which user needs access to which part of the database.
Liaison with Users
 DBA provide necessary data to the user.
Assisting Application Programmer
 DBA provides assistance to application programmers to develop application programs.
Monitoring Performance
 DBA ensures that better performance is maintained by making a change in the physical or
logical schema if required.
Backup and Recovery
 DBA backing up the database on some storage devices such as DVD, CD or magnetic tape or
remote servers and recover the system in case of failures, such as flood or virus attack from
this backup.