DB Overview

Database Application

• Form
• Query
• Report

DBMS

• Create
• Process
• Administer

DBMS 기능

• 정의
• 조작(Manipulation) : Retrieval, insertion, deletion, update
• 제어 : recovery, concurrency control(동시성 제어, LOCK), security, integrity(무결성, correctness)

DB

• integrated, self-describing, metadata
• A database is a self-describing collection of integrated tables.
• The tables are called integrated because they store data about the relationships between the rows of data.

DB Contents

• Tables of user data
• Metadata
• Indexes : 색인, 반드시 필요하다, Overhead data(속도가 빨라지는 대신 차지하는 공간이 많아 지니깐)
  • Sequential, B+tree
• Stored procedures : 3-tier, 2-tier 상황을 그냥 DB에 넣는다 (SQL문을 내장시킨다, MyBatis가 떠오른다..) call만 앱단에서 발생시킨다.
  • 트래픽 감소, 성능 증가
• Triggers : 자동주문, trigger를 짠다. 왜 트리거를 쓰는지에 대한 이해!
• Security data : 권한, 보안
• Backup/recovery data : "log" 해킹 대비, 회복

Personal Database Systems : Microsoft Access

• user friendly
• individual users, small workgroups, beginners
• DBMS engine called Jet, Microsofy SQL Server DBMS

Enterprise-Class Database Systems

• Client/Server Network
• E-Commerce
• Web Portal with Reporting Applications
• XML

이러한 것들이 SQL <-> DBMS <-> DB