Introduction to Databases

Vocabulary flashcards covering key concepts in the study of databases and database management systems.

Database

A collection of self-describing and integrated data files.

DBMS

Database Management System, a software that interacts with databases.

Data Definition Language (DDL)

A syntax for defining data structures in a database.

Data Manipulation Language (DML)

A language used for managing data within a database.

Structured Query Language (SQL)

A standardized language for managing and manipulating databases.

File-based Systems

Systems where programs define and manage their own data.

Limitations of File-based Systems

Issues such as separation, duplication, dependence, fixed queries, and proliferation.

Relational Model

A type of database model introduced by E. R. Codd, where data is organized in tables.

Object-relational DBMS

A database management system that integrates object-oriented database principles.

Database Administrator

A person responsible for managing and overseeing database systems.

Advantages of DBMS

Benefits including control of redundancy, consistency, integrity, and security.

Limitations of DBMS

Challenges such as complexity, size, cost, performance, and vulnerability.

Meta Data

Data about data, providing information about the structure and management of data.