to Database Systems Topic #1 Intro to DB Systems – Review Database-management system (DBMS) • Database-system applications • File-processing systems • Data inconsistency • Consistency constraints • Data abstraction • Instance • Schema • Physical schema ◦ Logical schema ◦ Physical data independence • Data models • Entity-relationship model ◦ Relational data model ◦ Object-based data model ◦ Semi-structured data ◦ Database languages • Data-definition language ◦ Data-manipulation language ◦ Query language ◦ Metadata • Application program • Normalization • Data dictionary • Storage manager • Query processor • Transactions • Atomicity ◦ Failure recovery ◦ Concurrency control ◦ Two-and three-tier database architectures • Data mining • Database administrator (DBA) •
to Database Systems Topic #1 – Intro to DB Systems Review • Database-management system (DBMS) • Database-system applications • File-processing systems • Data inconsistency • Consistency constraints • Data abstraction • Instance • Schema ◦ Physical schema ◦ Logical schema • Physical data independence • Data models ◦ Entity-relationship model ◦ Relational data model ◦ Object-based data model ◦ Semi-structured data • Database languages ◦ Data-definition language ◦ Data-manipulation language ◦ Query language • Metadata • Application program • Normalization • Data dictionary • Storage manager • Query processor • Transactions ◦ Atomicity ◦ Failure recovery ◦ Concurrency control • Two-and three-tier database architectures • Data mining • Database administrator (DBA)
Coverage%20Terms%20and%20Summary-1.docx