Kimgostring

Data Dictionary

2024๋…„ 9์›” 29์ผ1 min read

DataBase

๐Ÿ“Œ DBMS์— ๊ด€๋ จ ์žˆ๋Š” ๋‹ค์–‘ํ•œ ๊ฐ์ฒด (= Metadata) ์— ๋Œ€ํ•œ ์ •๋ณด๋ฅผ ์ €์žฅํ•˜๋Š”, System DB
= System Catalog

  • Select๋งŒ ๊ฐ€๋Šฅ, ์ˆ˜์ • ๋ถˆ๊ฐ€

Metadata

๐Ÿ“Œ ๋ฐ์ดํ„ฐ์— ๋Œ€ํ•œ ๋ฐ์ดํ„ฐ

  1. Schema
  2. Integrity Constraint (๋ฌด๊ฒฐ์„ฑ ์ œ์•ฝ)
  3. Authorization (์ ‘๊ทผ ๊ถŒํ•œ)

๊ทธ๋ž˜ํ”„ ๋ทฐ

๋ฐฑ๋งํฌ