Unit 8.8: Database System Architectures | IT 231 BBA Slides

--:-- --
↓ Scroll for more

Unit 8.8

Database System Architectures

IT 231: IT and Applications (BBA)

1-Tier Architecture 💻

The database and the application exist on the same physical machine.

  • Direct user interaction with the DB.
  • Pros: Fast, simple.
  • Cons: No network access, poor scalability.

2-Tier Architecture 🖥️ ↔️ 🗄️

A client-server model where the application on the user's machine talks directly to a central database server.

  • Pros: Centralized data, fast development.
  • Cons: Security risks (direct access), limited scalability for concurrent users.

3-Tier Architecture 📱 ↔️ ⚙️ ↔️ 🗄️

Introduces an "Application Server" middle layer between the user and the database.

  1. Presentation: User Interface (Web Browser)
  2. Application: Business Logic (Web Server)
  3. Database: Data Storage (DBMS)

Why 3-Tier is the Standard 🏆

  • Security: The user never directly accesses the database.
  • Scalability: You can add more application servers without touching the database.
  • Maintainability: Code is separated logically.

Thank You & Q&A