Search

NoSQL Databases

NoSQL (Not Only SQL) are non-relational databases that store data in a non-tabular format. They are designed to handle large amounts of data and to be highly scalable.

Non-relational

โ€ข
NoSQL databases never follow the relational model
โ€ข
Never provide tables with flat fixed-column records
โ€ข
No complex features like query languages, query planners, referential integrity joins, ACID
โ€ข
Offers easy to use interfaces for storage and querying data provided\
These are several types of SQL databases, and its examples:

Reference

[DB] NoSQL์ด๋ž€?, NoSQL ํŠน์ง•, NoSQL ์ข…๋ฅ˜, NoSQL ์žฅ์ 
NoSQL์ด๋ž€? NoSQL์€ ๋น„๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์ง€์นญํ•œ๋‹ค. ์ฆ‰, ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ ๋ชจ๋ธ์„ ์ง€์–‘ ํ•˜๋ฉฐ ๋Œ€๋Ÿ‰์˜ ๋ถ„์‚ฐ๋œ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๊ณ  ์กฐํšŒํ•˜๋Š” ๋ฐ ํŠนํ™”๋˜์—ˆ์œผ๋ฉฐ ์Šคํ‚ค๋งˆ ์—†์ด ์‚ฌ์šฉ ๊ฐ€๋Šฅํ•˜๊ฑฐ๋‚˜ ๋А์Šจํ•œ ์Šคํ‚ค๋งˆ๋ฅผ ์ œ๊ณตํ•˜๋Š” ์ €์žฅ์†Œ๋ฅผ ๋งํ•œ๋‹ค. NoSQL์€ ๊ธฐ์กด RDBMS ํ˜•ํƒœ์˜ ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๊ฐ€ ์•„๋‹Œ ๋‹ค๋ฅธ ํ˜•ํƒœ์˜ ๋ฐ์ดํ„ฐ ์ €์žฅ ๊ธฐ์ˆ ์„ ์˜๋ฏธํ•˜๋ฉฐ, ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ํ•œ๊ณ„๋ฅผ ๊ทน๋ณตํ•˜๊ธฐ ์œ„ํ•œ ๋ฐ์ดํ„ฐ ์ €์žฅ์†Œ์˜ ์ƒˆ๋กœ์šด ํ˜•ํƒœ์ด๋‹ค. NoSQL์˜ ํŠน์ง• RDBMS์™€ ๋‹ฌ๋ฆฌ ๋ฐ์ดํ„ฐ ๊ฐ„์˜ ๊ด€๊ณ„๋ฅผ ์ •์˜ํ•˜์ง€ ์•Š๋Š”๋‹ค. RDBMS๋Š” ๋ฐ์ดํ„ฐ ๊ด€๊ณ„๋ฅผ ์™ธ๋ž˜ํ‚ค ๋“ฑ์œผ๋กœ ์ •์˜ํ•˜๊ณ  JOIN ์—ฐ์‚ฐ์„ ์ˆ˜ํ–‰ํ•  ์ˆ˜ ์žˆ์ง€๋งŒ, NoSQL์€ JOIN ์—ฐ์‚ฐ์ด ๋ถˆ๊ฐ€๋Šฅํ•˜๋‹ค. RDBMS์— ๋น„ํ•ด ๋Œ€์šฉ๋Ÿ‰์˜ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•  ์ˆ˜ ์žˆ๋‹ค. ํŽ˜ํƒ€๋ฐ”์ดํŠธ ๊ธ‰์˜ ๋Œ€์šฉ๋Ÿ‰ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•  ์ˆ˜ ์žˆ๋‹ค..