Please enable JavaScript.

Coggle requires JavaScript to display documents.

Fundamentals - Coggle Diagram

- - - - Indexing for fallback
  - - - indexing
      - hardware e.g. SSD
      - RAM
      - denorm
      - materialise views (precompute)
- - - - data replication
        
        primary-replica
        
        multi-leader (group project, shared google doc)
        
        p-to-p (IoT device, rumour!)
      - consensus (whats true?)
      - conflict resolution
        
        CRDTs
        
        automatic ('last write wins')
        
        manual (git merge)
        
        custom/app specific (sales say update contact details with latest, all else dont e.g.)
  - - - ACID
      - clear, structured relationships
      - transactions
      - joins
      - indexes
    - - joins? nesting?
      - key-value: hot lookups
      - flexible schema, adapting data model
      - ElasticSearch (text)
    - - pre-signed URLs
      - combine with metadata
- - - - SYN
      - SYN-ACK
      - ACK
    - - FIN-ACK-FIN-ACK
    - - cert
      - key exchange
  - - - keep-alive :check:
      - Multiplexing :red_cross:
    - - keep-alive :check:
      - multi-plexing :check:
    - - persistent connection :check:
      - multiplexing :check:
      - QUIC instead of TCP
        
        TCP (reliability) + TLS (secure) + UDP (speed)
- - - - uniqueness, 1-1 mapping
  - - - API Gateway
        
        Auth
        
        Rate limting
        
        Routing
        
        SSL termination
        
        Front door/receptionist
- - - - represent differently - change alphabet
      - Base64
        
        AZaz09+/
      - 2-way
    - - Fingerprint
      - one-way
    - - Hide information
      - 2-way
      - pub/pri keys
        
        TODO :warning:
    - - local counter or salt
      - attempt insert, check
      - DB id