- Relational Database & Non-relational database
- Relational - horizontal view
- Non-relational - vertical view
- Primary Key in relational database
- Segment Key in non-relational database
- RAID - Redundant Array of Independent Disks
- External, Internal, Conceptual View
- Different types of OS like Windows, Mac, i
- OS, and Android are the external views.
- Conceptual View integrates it two one Internal database, so only one database is required only.
- External View - Application level
- Conceptual View - Query
- Internal View -
- Implicit - Not self-defining
- Explicit - Self-defining
- Data - Meaningful fact & figures, self-defining
- Relational uses ACID - Atomicity, Consistency, Isolation, Durability
- Non-relational - Scattered data, in order to connect them, Segment Key is used.
- There are two types of entities
- Entity and Weak Entity
- Weak Entity is dependent on Entity, so if Entity is destroyed, Weak Entity is also destroyed.
Recent Pastes