Must-know Topics on Database

• Materials of this article include: G4G

Table of Contents

1. Basic Concepts
2. ER Model
3. Relational Model
4. Transactions and Concurrency Control
5. Indexing, B and B+ trees
6. File Organization
7. SQL and NoSQL
8. SQL Queries

1. Basic Concepts

DBMS helps in efficient organization of data in the database which has the following advantages over the typical file system. Minimized redundancy and data consistency, Simplified Data Access, Multiple data views, Data Security, Concurrent access to data, Backup and Recovery mechanism.

1. 1 DBMS Architecture: 1-Tier, 2-Tier & 3-Tier

Link1

• DBMS architecture helps in the design, development, implementation, and maintenance of a database
• The simplest of Database Architecture is 1 tier where the Client, Server, and Database all reside on the same machine
• A two-tier architecture is a database architecture where the presentation layer runs on a client and .data is stored on a Server
• The 3-tier architecture is consist of the Presentation layer (PC, Tablet, Mobile, etc.), the Application layer (server) and Database Server