Please enable JavaScript.

Coggle requires JavaScript to display documents.

Database Internal - Coggle Diagram

- - - - How distributed system are different from single node system?
        
        Constrains
        
        Problems
        
        Complexities
      - How to pick the correct database system for my applications?
        
        Simulating your work on different databases, and measure their performances KPI. Get results from the conclusions.
        
        Real-world production setup as closely as possible.
        
        :red_flag: The questions to answer:
        
        “Does the database support the required queries?
        
        Is this database able to handle the amount of data we’re planning to store?
        
        How many read and write operations can a single node handle?
        
        How many nodes should the system have?
        
        How do we expand the cluster given the expected growth rate?
        
        What is the maintenance process?”
        
        Understanding the use cases of DBMS
        
        “To compare databases, it’s helpful to understand the use case in great detail and define the current and anticipated variables, such as:
        
        Schema and record sizes
        
        Number of clients
        
        Types of queries and access patterns
        
        Rates of the read and write queries
        
        Expected changes in any of these variables”
        
        Excerpt From: Alex Petrov. “Database Internals.” Apple Books.
      - How each database works?