REVIEW 1: Introduction

:material-circle-edit-outline: 约 83 个字

schema and instance

就数据库系统里的两个专业术语，在OO里叫class/object，C++里叫type/variable

• Database Languages
  • DDL: Data Definition Language
    • CREATE TABLE
  • DML: Data Manipulation Language
    • UPDATE
  • API: Application program interface
    • ODBC/JDBC
  • SQL Query Language
    • SELECT

Database Administrator（DBA）

• DBA’s duties include
  • Schema definition
  • Granting user authority
  • Routine maintenance
    • back up
    • performance tuning
    • ensure enough free disk space

下面是一个数据库schema