[go: up one dir, main page]
Scribd
Upload
20 views7 pages

Databases and Data Management

Databases are essential for storing, managing, and retrieving both structured and unstructured data, with two main types being SQL (relational) and NoSQL (non-relational). Database Management Systems (DBMS) facilitate efficient data management and integrity, with examples including MySQL and MongoDB. The choice between SQL and NoSQL databases depends on the specific project requirements and data structure, with SQL being suited for structured data and NoSQL offering flexibility and scalability.

Uploaded by

Motuma Lalisa
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
20 views7 pages

Databases and Data Management

Databases are essential for storing, managing, and retrieving both structured and unstructured data, with two main types being SQL (relational) and NoSQL (non-relational). Database Management Systems (DBMS) facilitate efficient data management and integrity, with examples including MySQL and MongoDB. The choice between SQL and NoSQL databases depends on the specific project requirements and data structure, with SQL being suited for structured data and NoSQL offering flexibility and scalability.

Uploaded by

Motuma Lalisa
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 7

5.

Databases and Data


Management
Understanding Database Systems and
Their Types
Introduction to Databases
• - **Databases store, manage, and retrieve
structured and unstructured data.**
• - Used in applications like web development,
banking, and e-commerce.
• - **Two main types:**
• - **SQL Databases (Relational databases).**
• - **NoSQL Databases (Non-relational, flexible
structure).**
5.1 Database Management
Systems (DBMS)
• - **DBMS is software that allows users to
store, manage, and query data efficiently.**
• - **Functions of a DBMS:**
• - Ensures data integrity and security.
• - Supports query languages like SQL.
• - Manages data access and concurrency.
• - **Examples:** MySQL, PostgreSQL,
MongoDB, Firebase.
5.1.1 SQL Databases (Relational
Databases)
• - **SQL databases use structured tables with
predefined schemas.**
• - Data is stored in rows and columns, with
relationships between tables.
• - **Examples:**
• - **MySQL**: Open-source, widely used in
web applications.
• - **PostgreSQL**: Advanced features,
supports complex queries.
• - **SQLite**: Lightweight, used in mobile
5.1.2 NoSQL Databases (Non-
Relational)
• - **NoSQL databases store data in flexible
formats like JSON, key-value, or graph.**
• - Ideal for handling large-scale, unstructured,
and real-time data.
• - **Examples:**
• - **MongoDB**: Document-oriented, stores
data in JSON format.
• - **Firebase**: Cloud-based, real-time
database for mobile apps.
• - **Example NoSQL Query (MongoDB):**
SQL vs. NoSQL: Key Differences
• - **Data Structure:**
• - SQL: Structured tables (rows, columns,
relationships).
• - NoSQL: Flexible, schema-less storage (JSON,
key-value, graph).
• - **Scalability:**
• - SQL: Scales vertically (adding power to a
single server).
• - NoSQL: Scales horizontally (adding multiple
servers).
Conclusion
• - **SQL Databases** are best for structured
data and transactional applications.
• - **NoSQL Databases** provide flexibility and
scalability for modern applications.
• - **Choosing the right database** depends on
project requirements and data structure.

You might also like