Please enable JavaScript.

Coggle requires JavaScript to display documents.

System Design - Coggle Diagram

- - - - Separate the rows of a table by ranges and put each range in a separate table.
      - You must create balanced ranges of data to avoid unbalanced tables.
      - Partitioning Criteria
        
        Key or Hash-based partitioning
        
        We apply a hash function to the entity to be persisted in order to get the partition number.
        
        List Partitioning
        
        There is a predefined list indicating which partition corresponds to each entity.
        
        Round-Robin Partitioning
        
        Given an i entity and having n partitions, the corresponding partition is computed as i % n
        
        Composite Partitionig
        
        Combination of two or more partitioning schemes.
    - - Store tables related to specific features in dedicated database servers (contacts, photos, user info).
      - In huge data scenarios you may need to partition features databases.
    - - Loosely coupled approach to work which handles internally required partitioning and provides a uniform interfaces to manage data.
  - - - Joins are hard to perform if data is spread across servers, you could denormalize data to try to address this.
    - - Enforcing data integrity constrains such as foreign keys can be extremely difficult in partitioned databases.
    - - Redistribute data in unbalanced scenarios can be hard without incurring in downtimes.
- - - - Write data in cache and then propagate it to the permanent storage.
    - - Data is updated in permanent storage and removed from cache
    - - Data is updated in both cache and database at the same time
- - - - Accessible by any internet user
        
        Anonymous
        
        Forwards request but hides client original information like IP
        
        Transparent
        
        Doesn't hide request original data, useful for website cashing
    - - Ask for resources like if it was the client and then send them to the client.
- - - - Sharing information between redundant elements so information is consistent.