Team members
• Ratnesh 23z251
• Sanjeev-23z258
• Narayanan-23z239
• Yashwant -24z437
• pranav - 23z246
Understanding Web
Databases
The Backbone of Dynamic Web Applications
Presented by: Team 9
Introduction to Web
Databases
What is a Web Common Uses
Database? • E-commerce platforms
A database that is • Content Management
accessible over the web Systems (CMS)
through a web application.
• Social media networks
It enables dynamic content
management and real-time
data interaction.
Purpose
To store, retrieve, and manage data dynamically to support
user interactions and content updates seamlessly on the web.
How Web Databases Work
Client Request Server Processing Database Response Content Delivery
A user's web browser The server runs a script The database engine The server formats the
sends a request to (such as PHP or [Link]) (e.g. MySQL) returns the data into HTML or JSON
access data or perform that processes the requested data to the and sends it back to the
an action on a website. client's request and server. client browser to update
queries the database for the webpage
the needed data. dynamically.
Components of Web Database
Systems
Front-End
User interface built with HTML, CSS, and JavaScript that interacts with users.
Back-End
Server-side logic using languages such as PHP, Python, or [Link] to
handle user requests and business logic.
Database
Storage system like MySQL or MongoDB where the actual data is
organized and managed.
API Layer
A secure interface that connects the front-end with the database,
ensuring controlled data access and communication.
Types of Web Databases
Relational Databases NoSQL Databases Cloud Databases
Structured systems with tables and Flexible schema models such as Hosted on cloud platforms for
predefined schemas. Examples document or key-value stores. scalability and accessibility, like
include MySQL and PostgreSQL, Examples: MongoDB, Firebase. AWS RDS and Google Cloud
ideal for transactional data. Great for handling unstructured or Firestore. Offers flexibility and
rapidly changing data. reduced maintenance.
Relational vs NoSQL
Databases
Relational
Uses tables with rows and columns, enforced schema,
and SQL for complex queries. Ideal for structured data
and relationships.
NoSQL
Stores data as documents, key-value pairs, or graphs.
Designed for scalability and flexibility with a dynamic
schema.
Choosing Use Cases
• Relational: Banking, ERP, inventory systems
• NoSQL: Real-time analytics, content delivery, IoT
Popular Web Database Technologies
MySQL / MariaDB PostgreSQL MongoDB Firebase
Open-source and widely Advanced relational Popular NoSQL document Backend-as-a-service
used relational databases, database with strong database, designed for solution by Google with
favored for reliability and support for complex ease of development and real-time database and
extensive community queries and extensibility. horizontal scaling. cloud features for
support. mobile/web apps.
SQLite
Lightweight embedded
relational database ideal
for local storage in mobile
and desktop applications.
Applications of Web Databases
E-commerce Social Media Sites Content Booking Systems
Platforms Management
Manages user profiles, Handles reservations,
Systems
Stores product data, posts, interactions, Enables creation, editing, availability checking,
manages inventory, multimedia content, and publication, and user data, and
handles customer orders, real-time feeds at large organization of website transaction processing
and processes payments scale. content in an efficient for airlines, hotels, and
dynamically. and user-friendly way. events.
Security and Best Practices
Prevent SQL Injection
Use parameterized queries and prepared statements to secure
database interactions from injection attacks.
Secure Connections
Implement HTTPS with SSL/TLS to encrypt data transmissions and
protect user privacy.
Data Backup & Access Control
Regularly back up data and enforce strict access permissions to
prevent unauthorized data exposure.
Data Validation & Encryption
Validate user input thoroughly and encrypt sensitive data both in
transit and at rest.
Conclusion and Next Steps
Understand Requirements
Carefully analyze the application’s data needs, access
patterns, and scalability goals to choose the right database
type.
Prioritize Security
Implement best practices from the start to protect data and
ensure compliance with privacy standards.
Focus on Performance and Scalability
Design database structures and queries with efficient
indexing, caching, and scaling strategies for growing
applications.
By embracing these principles, developers and students can build
robust and dynamic web applications powered by effective web
databases.