Introduction to Database Systems

These flashcards cover key terminology and concepts related to database systems, aiding in understanding databases and their management.

Data

Facts that are recorded and can be accessed.

Information

Data that is accessed by a user for some particular purpose.

Metadata

Data that describes the structure and properties of the data.

Database

A structured collection of related data stored on a computer medium.

Database Management System (DBMS)

Software used for creation, manipulation, and maintenance of databases.

Database System

Computer-based system aimed at enabling efficient interaction between users and information.

Front-end Applications

Provide a mechanism for easy interaction between users and the DBMS.

Direct Interaction

End-user communicating with the database directly through the DBMS.

Indirect Interaction

End-user communicating with the database through front-end applications.

Database Modeling

Creation of the database model that is implementable by DBMS software.

SQL (Structured Query Language)

A language used by most relational database management systems (RDBMS).

Database Deployment

Releasing the database system for use by end-users.

Database Use

Insertion, modification, deletion, and retrieval of data in the database system.

Database Administration and Maintenance

Activities that support the database end-user and deal with technical issues.

Operational Database

Collects and presents operational information for daily procedures.

Analytical Database

Collects and presents analytical information for analytical tasks.

Database Analysts

Involved in requirements collection, definition, and visualization stage.

Database Designers

Involved in the database modeling stage to create the database schema.

Database Developers

In charge of implementing the database model as a functioning database.

Database Administrators (DBAs)

Perform tasks related to the maintenance and administration of a database system.