Please enable JavaScript.

Coggle requires JavaScript to display documents.

Introduction - Coggle Diagram

- - - - How users view and access data
      - Includes tables, relationships, and schemas
      - SQL is used to manipulate the data
    - - How data is stored and organized at the lowest level
      - Includes file structures, storage, and access
- - - - Based on tables (rows and columns)
      - Use primary and foreign keys
      - Uses SQL
    - - Tree structure with parent-child relationships
    - - Graph structure; an entity can have multiple parents
    - - Data represented as objects with properties and methods
    - - Handling unstructured or semi-structured data (JSON, XML)
- - - - Standard for relational databases
      - Includes sublanguages:
        DDL (structure definition)
        DML (data manipulation)
        DCL (permission control)
    - - Adapted for non-relational databases (e.g., BSON, Mango Query)