๋ชฉ๋กSQL (1)

๐ŸŒฑ → ๐ŸŒณ

[DataBase] DBMS(DataBase Management System)

๐Ÿ“Œ DBMS : ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ๊ด€๋ฆฌํ•˜๊ณ  ์šด์˜ํ•˜๋Š” SW ๋‹ค์–‘ํ•œ ํ˜•ํƒœ, ์„œ๋น„์Šค๊ฐ€ ์กด์žฌ โœ… SQL (Structured Query Language) ๊ตฌ์กฐ๊ฐ€ ์žˆ๋Š” ์งˆ๋ฌธ์šฉ ์–ธ์–ด SELECT, INSERT, UPDATE, DELETE ๊ฐ™์€ ์–ธ์–ด๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๋‹ค๋ฃจ๋Š” ์–ธ์–ด ๋‹ค์ˆ˜์˜ DBMS๊ฐ€ SQL ๋ฐฉ์‹์„ ๋”ฐ๋ฅด๊ธฐ ๋•Œ๋ฌธ์— SQL ์„ ๋ฐฐ์šฐ๋ฉด, ๋งŽ์€ DBMS๋ฅผ ๋น„๊ต์  ๋น ๋ฅด๊ฒŒ ์Šต๋“์ด ๊ฐ€๋Šฅ MySQL, SQLite, ORACLE ๋“ฑ์ด SQL ๊ตฌ๋ฌธ์„ ์‚ฌ์šฉ ๐Ÿ“Œ DB์˜ ์ข…๋ฅ˜ ๊ด€๊ณ„ํ˜•(SQL) vs ๋น„๊ด€๊ณ„ํ˜•(NoSQL) โœ… ๊ด€๊ณ„ํ˜•, Relational DBMS(RDBMS) : SQL์„ ์‚ฌ์šฉํ•˜๋Š” DB ํ‚ค์™€ ๊ฐ’์˜ ๊ด€๊ณ„๋ฅผ ํ…Œ์ด๋ธ”ํ™” ์‹œํ‚จ ์›์น™์„ ํ† ๋Œ€๋กœ DB๋ฅผ ๊ตฌ์„ฑ ์ฆ‰, ํ…Œ์ด๋ธ”๋กœ ๊ตฌ์„ฑ๋จ ๋จผ์ € ํ…Œ์ด๋ธ”์ด ๊ตฌ์„ฑ๋˜๊ณ  ํ…Œ์ด๋ธ”์˜ ๊ตฌ์กฐ์— ..

Computer Science 2022. 9. 24. 11:00