[Oracle] Oracle DBMS


Contents




๊ด€๊ณ„ํ˜• DB; Relational Database; RDB

์—ด๊ณผ ํ–‰์œผ๋กœ ์ด๋ฃจ์–ด์ง„ ํ…Œ์ด๋ธ” ํ˜•ํƒœ๋กœ ๊ณผ๋‹ํ•˜๋ฉฐ, ํ…Œ์ด๋ธ” ๊ฐ„์— ๊ด€๊ณ„(relation)๋ผ๋Š” ๊ฐœ๋…์„ ํ†ตํ•ด ์—ฐ๊ฒฐํ•œ๋‹ค.

ํ…Œ์ด๋ธ”์€ ๋ ˆ์ฝ”๋“œ(๋กœ์šฐ, ํ–‰)๋“ค์˜ ์ง‘ํ•ฉ์œผ๋กœ ๊ตฌ์„ฑ๋˜๋ฉฐ, ๋ ˆ์ฝ”๋“œ๋Š” ํ•„๋“œ(์ปฌ๋Ÿผ)์œผ๋กœ ๊ตฌ์„ฑ๋œ๋‹ค.

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์™€ DBMS, SQL์€ ๋ชจ๋‘ ์„œ๋กœ ๋‹ค๋ฅด๋‹ค.

  • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ DBMS๊ฐ€ ๊ด€๋ฆฌํ•˜๊ณ  DBMS๋ฅผ SQL๋กœ ๊ด€๋ฆฌํ•œ๋‹ค.

์ฃผ์š” ์šฉ์–ด

  • table(relation)
  • column(Fields, Attribute, ์—ด)
  • Rows(record, tuple, ํ–‰)
  • Field







ยฉ 2022. by Yejin Ha

Powered by JihyunRyu