Fundamentals of Database Systems

Vocabulary flashcards covering key terms and concepts from the lecture on database systems.

Database

A collection of related data.

DBMS (Database Management System)

A software package/system to facilitate the creation and maintenance of a computerized database.

Data

Known facts that can be recorded and have an implicit meaning.

Mini-world

Some part of the real world about which data is stored in a database.

Multi-user transaction processing

Allowing a set of concurrent users to retrieve from and update the database.

Data Abstraction

A data model used to hide storage details and present users with a conceptual view of the database.

Actors on the Scene

Users who actually use and control the database content, and those who design, develop, and maintain database applications.

Actors Behind the Scene

Those who design and develop the DBMS software and related tools, and the computer systems operators.

OLTP (Online Transaction Processing)

A major part of database applications that allows hundreds of concurrent transactions to execute per second.

NOSQL

Not Only SQL, a type of database designed for rapid search and retrieval from documents and processing of huge graphs occurring on social networks.

Data Warehouse

An organized collection of data for analysis and reporting, often used in big data applications.

Integrity Constraints

Rules that ensure the accuracy and consistency of data within a database.

Big Data

Large volumes of data that require special processing techniques to handle their complexity.

Cloud Storage

Data storage on remote servers accessed via the internet, providing scalable and flexible storage solutions.

Conceptual Data Model

A model that describes the structure of the database in terms of the entities involved and their relationships.

Canned Transaction

A predefined and well-defined function that can be executed by end-users without programming knowledge.

Meta-data

Data that provides information about other data within the database.

Program-Data Independence

The ability to change data structures without changing the DBMS access programs.

Social Media

Platforms that capture and store a large amount of information about people and their interactions.

Historical Development of Database Technology

The evolution of database systems from early hierarchical and network models to contemporary relational and NOSQL databases.

Data Mining

The process of discovering patterns and knowledge from large amounts of data.