COMP3005 - Introduction to Database Management Systems (DBMS)

Vocabulary flashcards covering introductory concepts of Database Management Systems (DBMS), file processing limitations, and data models based on COMP3005 lecture notes.

Database Management System (DBMS)

A software system managing a single repository that maintains data defined once and accessed by various users and programs.

Computer (Lecture Definition)

A system conceptualized in the lecture as Microprocessor + RAM.

Three-step Program Data Processing

The basic data flow execution of a program consisting of: 1- Read the Data, 2- Process the Data, and 3- Write the Data.

Traditional file processing

An approach where each user defines and implements the files needed for a specific software application.

Data inconsistency

A problem in traditional file processing resulting from having different copies of the same data and a lack of synchronization across files.

Data security

Measures including access control and encryption to protect data from unauthorized access.

Data sharing

The management of permissions determining who can access what data across multiple users and applications.

Data independence

A system property where changes to the data structure do not require modifying all associated software applications.

Concurrent access control

A mechanism that prevents conflicts when multiple users attempt to access or modify the same data simultaneously.

Database approach

A data management system where a single repository maintains data that is defined once and accessed by various users and software applications.

Data Model

A conceptual representation of how data is organized, structured, and related within a database system.

Relational Data Model

A data model that organizes data into tabular relations, supported by DBMS software such as PostgreSQL.

Document-based Data Model

A data model that organizes and stores data as semi-structured documents such as JSON, supported by DBMS software like MongoDB.

Graph-based Data Model

A data model that represents data as nodes, edges, and relationships, supported by DBMS systems like Neo4J and Jena.

SQL

The query language used by software applications to interact with relational DBMS systems.