Get Started. It's Free
or sign up with your email address
Rocket clouds
DBMS by Mind Map: DBMS

1. DATA MODELS

1.1. RELATIONAL MODEL

1.2. ENTITY-RELATIONAL MODEL

1.3. OBJECT-BASED DATA MODEL

1.4. SEMI STRUCTURED MODEL

1.5. NETWORK MODEL

1.6. HIERARCHICAL MODEL

2. RELATIONAL MODEL

2.1. All data is stored in various tables

3. DDL COMMANDS

3.1. data defination language

3.2. CREATE

3.3. ALTER

3.4. RENAME

3.5. ADD

3.6. MODIFY

3.7. DROP

3.8. TRUNCATE

4. DML COMMANDS

4.1. data manipulation language

4.2. INSERT

4.3. DELETE

4.4. SELECT

4.4.1. FROM

4.4.1.1. WHERE

4.5. UPDATE

5. MDX

5.1. Multidimensional eXpressions is a language for expressing analytical queries

6. CONSTRAINTS

6.1. PRIMARY KEY

6.2. FORIEGN KEY

6.3. UNIQUE KEY

6.4. NOT NULL

6.5. CHECK

7. DATABASE SYSTEM INTERNALS

7.1. QUERY PROCESSING

7.2. PARSING AND TRANSLATION

7.3. OPTIMIZATION

7.4. EVALUTION

8. DATABASE ARCHITECTURE

8.1. CENTRALIZED

8.2. CLIENT-SERVER

8.3. PARALLEL(MULTIPROCESS)

8.4. DISTRIBUTED

8.4.1. CLOSELY COUPLE

8.4.2. BASELY COUPLE

9. TRANSACTION MANAGEMENT

10. STORAGE MANAGEMENT

11. RELETIONAL ALGEBRA

11.1. JOINS