Please enable JavaScript.

Coggle requires JavaScript to display documents.

Dynamo TE and DB Summary (dynamo demo (Basic (Index pt ? (global secondary…

- - - - MySQL
      - Oracle
      - PostgreSQL
      - SQL Server
  - - - RDBMS
        
        schema is fixed. Need to design table, column and row
      - Engine Type
        
        PostGreg
        
        2.MySQL
        
        3.MariaDB
        
        Aurora
        
        2ttype
        
        MySQL (5x) - can handle more throughput (R/W)
        
        Postgresql (3x)
        
        with scaling from GB to TB, perfromance is 137X better for Mysql
        
        Aurora Serverless
        
        Oracle
        
        Microsoft SQL
      - Multi-AZ
        
        If master fail,
        
        rebuild from S3 & not recover
- - - - Database software
      - hardware
    - - Limit
        
        Max thoughput is no limit
        
        Minimium limit is
      - Synchronous replicate data across 3 Az in a region
      - Dynamo Query.feature
        
        query can use sort key
        
        using optinal sort key name and value
        
        query items with timestamp of last 7 days
        
        Result are always are sorted by sort key
        
        Numeric order
        
        By default :ascending order 1,2,3,4
        
        Can set to reverse order
        
        by defualt is eventually consistent
        
        return all atrribute of the item by dfault
        
        1.partition key pt
        
        2
        
        Example: select an item base on userID 212, will select all atribute based on the item. Ex:first name, surname & email Id
        
        but can limit certain attribute
        
        Ex:only want to see email rather than first
        
        Query using primary key and a unique value
        
        can based on 2 type of key
        
        1.Base on 2nd index
        
        base on primary key
      - Dynamo Scan
        
        Examine every item.
        
        default also return all attribute
        
        Can refine the scan using filter to only return the attribute you want:(same as query)
        
        scan dump the whole table, no efficient
      - provison throughout point
        
        Measure in capacity unit
        
        1 x write capacity unit= 1KB write per seconds
        
        Specify when create table
        
        1 read capacity unit = 1 x strong consistency read of 4 KB
        
        1 x strong consistency read of 4KB per seconds
        
        2 x eventaully consistency of 4KB per second
        
        DT: strong and eventually consistency
        
        limit
        
        is per table and per account
        
        can create case to increase the limit
    - - Access via API. App on OS such as Linux, Windows, iOS, Android, Solaris, AIX, and HP-UX) can use DynamoDB. .
      - recommended using AWS SDK
  - - - Table no need fixed schema, no need colum and row
      - 1 data can be many attribute
    - - cn be Json, XML, html
    - - 2 type of primary key
        
        partion key and sort key (Composite key)
        
        consist of 2 attribute
        
        the output of internal hash determine the partion of Dynamo dB
        
        partition is physical storage in which items are stored
        
        All items of same partition key are store together
        
        Possible 2 items have sama partition key
        
        so must have diff soft key
        
        soft key is to determine the sorted order
        
        partition key
        
        simple primary key
        
        compose of 1 attribute
        
        Outpui is hash function of partition key
        
        No 2 items can have same partition key value
        
        fn
      - function
        
        To identify each item in the table
    - - purpose :Enable fast queries on local seoncary index and global secondary iindex
      - 2 type
        
        local secondary index
        
        Must be create when create table,
        
        Same partition key as your table
        
        diff sort key
      - global secondary index
        
        can be create after create table
        
        definition: diff partition key and sort key as your table
        
        diff sort key
        
        Can be simple key or with sort key
- - - - Analysis in social media
        
        Analysis in social media
        
        Can see relationship of facebook user and their hobbies and relatives