Database, DBMS ์ •์˜

์•„์ฃผ๋Œ€ํ•™๊ต ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค ์ˆ˜์—…

Posted by Bangjinhyuk on March 15, 2021 · 1 min read

Database

DBMS = Database Management System
  1. DBMS ์ข…๋ฅ˜: ์ƒ์šฉ๋ฒ„์ „(์˜ค๋ผํด,MS) , ์˜คํ”ˆ์†Œ์Šค (MySQL, PostgreSQL,SQLite)

  2. DBMS๋ฅผ ํ†ตํ•ด์„œ ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค์— ์ €์žฅํ•˜๊ณ  ์ ‘์†(read/write)ํ• ์ˆ˜ ์žˆ๊ฒŒ ํ•ด์ค€๋‹ค.

  3. DataBase ํŠน์ง•
    • Massive (ํฐ์‚ฌ์ด์ฆˆ์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๋‹ค๋ฃฌ๋‹ค)
    • Persistent (ํ•œ๋ฒˆ ์ €์žฅ๋˜๋ฉด ์ง€์šฐ๊ธฐ ์ „๊นŒ์ง€ ์ €์žฅ)
    • Safe (์•ˆ์ „ํ•˜๋‹ค)
    • Multi-user(๋™์‹œ ๊ณต์œ =>concurrent sharing)
    • Convenient (๋ณต์žกํ•˜์ง€ ์•Š๋‹ค. high-level query language, physical data independence=>table ๊ฐœ๋… )
    • Efficient (์ฒ˜๋ฆฌ์†๋„๊ฐ€ ๋†’๋‹ค)
    • Reliable (์•ˆ์ •์ )
  4. Database ์–ดํ”Œ๋ฆฌ์ผ€์ด์…˜์€ framework๋ฅผ ํ†ตํ•ด ํ”„๋กœ๊ทธ๋ž˜๋ฐ ๋œ๋‹ค.

  5. ๋ฐ์ดํ„ฐ ์ค‘์‹ฌ ์–ดํ”Œ๋ฆฌ์ผ€์ด์…˜(Data-intensive applications)๋Š” DBMS๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š๋Š”๋‹ค.

  6. Key concepts
    • Data model (๋ฐ์ดํ„ฐ๋ฅผ ์–ด๋–ป๊ฒŒ ๊ตฌ์„ฑํ•˜๋Š”์ง€ ์ •ํ•œ ๋ชจ๋ธ, ๊ตฌ์„ฑ ์š”์†Œ ์ •์˜ ex) table , set of records, XML, graph)
    • Schema versus data
      • schema = ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค ์•ˆ์— ๊ตฌ์„ฑ์š”์†Œ๋“ค์˜ ๊ตฌ์กฐ =>type
      • ํ•ด๋‹น ์œ„์˜ ์‚ฌ์ง„์—์„œ ๋‚ด๋ถ€ ์Šคํ‚ค๋งˆ ๋ถ€๋ถ„
      • data => variables ์‹ค์ œ ๋ฐ์ดํ„ฐ๋“ค
    • Data definition language(DDL) => ์Šคํ‚ค๋งˆ ์ •์˜ ๋ถ€๋ถ„ ex) create
    • Data manipulation or query language (DML) => ๋ฐ์ดํ„ฐ read(quering)/write(modifying) ์ฟผ๋ฆฌ๋ฌธ๋“ค
  7. Key people
    • DBMS implementer (DBMS๋ฅผ ๋งŒ๋“œ๋Š” ์‚ฌ๋žŒ๋“ค)
    • Database designer (์Šคํ‚ค๋งˆ ๋””์ž์ด๋„ˆ)
    • Database application developer(์–ดํ”Œ๋ฆฌ์ผ€์ด์…˜์„ ๊ฐœ๋ฐœํ•˜๋Š” ์‚ฌ๋žŒ=> ํ”ํžˆ ๋งํ•˜๋Š” ์„œ๋ฒ„ ๊ฐœ๋ฐœ์ž)
    • Database administer (๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค ๊ด€๋ฆฌ์ž)

๋งจ์œ„๋กœ๐Ÿ‘†