跳到主要內容

DynamoDB 名詞概念

DynamoDB

Table

  • 類似於 RDBMS 的 Table.
  • DynamoDB Table 是一個儲存集合單位。
  • 相當於 MongoDB 的 Collection

Items

  • 每個 Table 可以有多個 Items,相當於 RDBMS 的 Rows。
  • 每個 Items 可包含多個 Attributes
  • 相當於 MongoDB 的 Document

Attributes:

  • 每個 Items 由一個或多個 Attributes 組成
  • Attributes 支援最深 32 個層級

Example

  • People Table
{
    "PersonID":"101",
    "LastName":"Simtih",
    "FirstName":"Fred",
    "Phone":"123-456",
},
{
    "PersonID":"102",
    "LastName":"Jones",
    "FirstName":"Anytown",
    "Address":{
        "Street":"123 Main",
        "City":"Anytown",
        "Zip":123
    }
}

Primary Key

Partitiion Key

  • 相當於 RDS 的 Unique Key, 有一組不會重複的 hash value

Partition Key + Sort Key (複合鍵)

  • 先找到 unique key 再依照 sort key 做索引, hash + range
  • Hash : select * from xxx where id = hash
  • Hash + range : select * from xxx where id between (123, 456)

Secondary Indexes (二級索引)

  • 二級索引的會有一張 base table 跟 關聯的 table
  • Global secondary index:
    1. Key = Hash Key or (Hash and Rang Key), 前面的 Hash Key 是 base Table 的 hash Key, 後面的 Hash and Range Key 是 join 的 Table
  • Local secondary index:
    1. Key = Hash Key and Range Key
  • 要注意的是,DynamoDB 不管是 Primary Key or Secondary Indexes,在 Table 建立之後就無法修改。

這個網誌中的熱門文章

Spring boot Https 設定

1. 產生 SSL certificate keytool -genkey -alias tomcat -storetype PKCS12 -keyalg RSA -keysize 2048 -keystore keystore.p12 -validity 3650 Enter keystore password: Re-enter new password: What is your first and last name? [Unknown]: jerry What is the name of your organizational unit? [Unknown]: td What is the name of your organization? [Unknown]: com What is the name of your City or Locality? [Unknown]: taipei What is the name of your State or Province? [Unknown]: taiwan What is the two-letter country code for this unit? [Unknown]: tw Is CN=jarvis, OU=td, O=urad, L=taipei, ST=taiwan, C=tw correct? [no]: yes 這個 certificate 是 self-signed certificate 沒有經過第三方認證, 所以沒有公信力, 正式上線會在瀏覽器看到 連線不被信任 要有公信力的 certificate 最簡單的是 Lets Encrypt , 其他就是花一些錢找簽發 certificate 的組織 2. Enable HTTPS in Spring Boot Spring Boot 內建的 tomcat 預設 http 是 8080, Spring Boot 可以設定 http 跟 https, 但沒辦法同時存在這兩個設定, 如果要同時存在兩種 connection, 建議依照 文件 建議設定 https, 再透過 programmatically 去設定 http 會比較容易。 相關範例可以參考 : https://...

Google Compute Engine‎ - AccessDeniedExceptions 403

原因 打算從 instance 打包 logs 到 google cloud storage 發生了 AccessDeniedException: 403 Insufficient OAuth2 scope to perform this operation. , 看起來是 instance 沒有 storage 權限 解決 Reference: https://cloud.google.com/compute/docs/access/create-enable-service-accounts-for-instances#changeserviceaccountandscopes 重新設定 service account 權限 instance 上內建有 gcloud , 就直接用現有的工具查詢一下 instance 的 account. $ gsutil info 或者在本機直接 gcloud compute instances describe INSTANCE_NAMES Account: [alpha-number-compute@developer.gserviceaccount.com] Project: [our-project-name] 會看到 instance 的一些狀態, 接下來就簡單多了, 按照下列的說明, 要先 stop instance, 更改 storage scope 再重新 start 。 To change an instance's service account and access scopes, the instance must be temporarily stopped. To stop your instance, read the documentation for Stopping an instance. After changing the service account or access scopes, remember to restart the instance. # Stop Instance gcloud compute instances stop INSTANCE_NAMES # 設定 storage scope 為 full (Read, Write) gcloud co...

Java Process And Thread 筆記

英文很差,所以附上原文。 關係大概是這樣吧 Processes And Threads Processes (進程) 每個 Process 都可視為一個獨立運作的環境,有自己完整、私有的 Run-Time 資源,特別是每個 process 都有自己的記憶體空間。 Processes 聽起來很像 programs 或 application 的另一種說法,然而事實上一個 application 有可能是許多 processes 合作組成的。為了讓 processes 彼此互相合作,一些作業系統支援了 Inter Process Communication (IPC) resources,例如 pipes 與 sockets。IPC 不只讓不同的 processes 互相通訊,同時也支援不同系統的 pocesses 互相通訊。 大部分 JVM 實現的都是 single process。Java Application 可以創建額外的 process 透過 ProcessBuilder Object。 A process has a self-contained execution environment. A process generally has a complete, private set of basic run-time resources; in particular, each process has its own memory space. Processes are often seen as synonymous with programs or applications. However, what the user sees as a single application may in fact be a set of cooperating processes. To facilitate communication between processes, most operating systems support Inter Process Communication (IPC) resources, such as pipes and sockets. IPC is used not just for communication b...