๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
Data Engineering

NoSQL

by ํ–‰๋ฑ 2024. 6. 13.

๋ถ„์‚ฐ KVS

 

 

Amazon DynamoDB

 

 

์™€์ด๋“œ ์ปฌ๋Ÿผ ์Šคํ† ์–ด

https://www.linkedin.com/pulse/apache-cassandra-nosql-database-adam-getz-pmp-csm-aws-cmmi/

 

row key์™€ column์˜ ์กฐํ•ฉ์„ ์ €์žฅํ•˜๋Š” ๋ฐฉ์‹์œผ๋กœ dynamic columns๋ฅผ ์ €์žฅํ•˜๋Š” NoSQL ๋ฐ์ดํ„ฐ ์ €์žฅ์†Œ

dynamic columns๋Š” ๊ฐ™์€ ํ…Œ์ด๋ธ”์ด๋ผ๋„ row ๋ณ„๋กœ column ์ด๋ฆ„๊ณผ ํฌ๋งท์ด ๋‹ค๋ฅผ ์ˆ˜ ์žˆ์Œ์„ ์˜๋ฏธํ•จ

column์„ ๊ทธ๋ฃนํ•‘ํ•œ column family ๊ฐœ๋…์„ ์ œ๊ณตํ•˜๊ธฐ๋„ ํ•˜๋Š”๋ฐ, ํ•จ๊ป˜ ์ €์žฅ๋˜๋ฏ€๋กœ ํ•จ๊ป˜ ๋งŽ์ด ์‚ฌ์šฉ๋˜๋Š” column์„ ๊ทธ๋ฃนํ•‘ํ•ด์•ผ ํ•จ

 

Apache Cassandra

๋ถ„์‚ฐํ˜• ์™€์ด๋“œ ์ปฌ๋Ÿผ ์Šคํ† ์–ด (์˜คํ”ˆ์†Œ์Šค)

TBD

 

๋„ํ๋จผํŠธ ์Šคํ† ์–ด

https://www.linkedin.com/posts/raul-junco_i-couldnt-understand-a-document-store-until-activity-7181622299488325633-y39d/

 

JSON ๊ฐ™์€ ๋ณต์žกํ•œ ์Šคํ‚ค๋งˆ๋ฆฌ์Šค ๋ฐ์ดํ„ฐ๋ฅผ ๊ทธ๋Œ€๋กœ ์ €์žฅํ•˜๊ณ  ์ฟผ๋ฆฌํ•  ์ˆ˜ ์žˆ๋Š” NoSQL ๋ฐ์ดํ„ฐ ์ €์žฅ์†Œ

RDBMS์ฒ˜๋Ÿผ ๋น ๋ฅธ ๊ฒ€์ƒ‰์„ ์œ„ํ•œ ์ธ๋ฑ์Šค๋„ ์žˆ์œผ๋ฉฐ,

๋น„์Šทํ•œ ๋„ํ๋จผํŠธ๋ฅผ ํ•จ๊ป˜ ์ €์žฅํ•˜๊ฑฐ๋‚˜ (Embedding) ๋ ˆํผ๋Ÿฐ์Šค ํ•ด๋‘์–ด (Linking) Join์„ ์ค„์ผ ์ˆ˜ ์žˆ์Œ

(+) ๋ฐ์ดํ„ฐ ์ฒ˜๋ฆฌ์˜ ์œ ์—ฐ์„ฑ

 

MongoDB

 

 

๋ถ„์‚ฐํ˜• ๋„ํ๋จผํŠธ ์Šคํ† ์–ด (์˜คํ”ˆ์†Œ์Šค)

BSON (Binary JSON) ํ˜•์‹์œผ๋กœ JSON ๊ฐ™์€ ์Šคํ‚ค๋งˆ๋ฆฌ์Šค ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•จ

# JSON
{
  "name": "John",
  "age": 30,
  "city": "New York"
}

# BSON
\x16\x00\x00\x00                   // BSON ๋ฌธ์„œ์˜ ์ „์ฒด ๊ธธ์ด
\x02                               // ๋ฌธ์ž์—ด ๋ฐ์ดํ„ฐ ํƒ€์ž…
name\x00                           // ํ•„๋“œ ์ด๋ฆ„ ("name")
\x05\x00\x00\x00John\x00          // ๋ฌธ์ž์—ด ๊ฐ’ ("John")
\x10\x00\x00\x00                   // 32-bit ์ •์ˆ˜ ๋ฐ์ดํ„ฐ ํƒ€์ž…
age\x00                            // ํ•„๋“œ ์ด๋ฆ„ ("age")
\x1e\x00\x00\x00                   // ์ •์ˆ˜ ๊ฐ’ (30)
\x02                               // ๋ฌธ์ž์—ด ๋ฐ์ดํ„ฐ ํƒ€์ž…
city\x00                           // ํ•„๋“œ ์ด๋ฆ„ ("city")
\x08\x00\x00\x00New York\x00      // ๋ฌธ์ž์—ด ๊ฐ’ ("New York")
\x00                               // BSON ๋ฌธ์„œ์˜ ์ข…๋ฃŒ๋ฅผ ๋‚˜ํƒ€๋‚ด๋Š” ๋งˆ์ง€๋ง‰ ๋ฐ”์ดํŠธ

 

 

https://www.linkedin.com/posts/isharanimicrosoftleader_%3F%3F%3F%3F%3F%3F%3F-%3F%3F%3F%3F%3F%3F%3F%3F%3F%3F-netflix-activity-7116026121078407168-INIs/?trk=public_profile_like_view

 

๋Œ“๊ธ€