Please enable JavaScript.

Coggle requires JavaScript to display documents.

DATA ENGINEER - Coggle Diagram

- - - - computer
    - - computer
    - - computer
  - - - Interface: PysSpark
- - - - Aggregate queries
      - OLAP: Online Analytical Processing
      - Column-oriented
        
        Queries about subset of columns
        
        Parallelization
    - - Transactions
      - OLTP
      - Row - oriented
        
        Stored per record
        
        adding customer is fast
    - - Amazon Redshift
      - Azure SQL Data Warehouse
      - Google BigQuery
- - - - Get data from data sources
        
        clear-> clean
        
        join, aggregate data
        
        Analytical Database
- - - - Relation
      - Schema
      - Table
      - Structure
    - - Non-Relation
      - Structure, non-structure
      - Key-Value
      - Redis, mongo