FWDD DBMS

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

1. QUERY PROCESSING

1.1. SQL – Structured Query Language -commands that use to access data within databases. - DDL - DCL - DML

2. Data Control Language

3. DATA MODELS

3.1. STRUCTURED

3.1.1. organized and formatted in a way so it's easily searchable in relational databases. Examples of structured data - names, dates, addresses, credit card numbers, - geolocation etc.

3.1.1.1. Relational DB(RDBMS) - MySQL - Microsoft SQL Server -Oracle Database

3.2. UNSTRUCTURED

3.2.1. no pre-defined format or organization, making it much more difficult to collect, process, and analyse. Examples of unstructured data -text, video, audio, mobile activity, social media activity, satellite imagery, surveillance imagery etc.

3.2.1.1. Non-relational DB (NoSQL databases) - MongoDB - Cassandra -HBase

3.3. SEMI-STRUCTURED

3.3.1. form of structured data that does not conform with the formal structure of data models associated with relational databases or other forms of data tables. It is called self-describing structure. Examples of semi-structured data - JSON and XML.

3.4. METADATA

3.4.1. data about data. It provides additional information about a specific set of data. Example of metadata - for a photograph, metadata could describe when(date) and where(location) the photos were taken.

4. RELATIONAL MODEL

4.1. - All data is stored in various tables. - Tables may be joined together

5. DDL COMMANDS

5.1. Data Defination Language

5.2. CREATE

5.3. ALTER

5.4. RENAME

5.5. ADD

5.6. MODIFY

5.7. DROP

6. DML COMMANDS

6.1. Data Manipulation Language

6.2. INSERT INTO

6.3. DELETE

6.4. SELECT

6.4.1. FROM

6.4.1.1. WHERE

6.5. UPDATE

7. CONSTRAINTS

7.1. PRIMARY KEY

7.2. FORIEGN KEY

7.3. UNIQUE KEY

7.4. NOT NULL

8. DATABASE SYSTEM INTERNALS

9. DATA MANAGEMENT

9.1. Permenant

9.2. Temporary

10. DCL COMMANDS

10.1. GRANT

10.2. REVOKE