TLE SUMMATIVE

Database Systems

Structures for storing and managing data, enabling efficient access and manipulation.

Data vs. Information

Data are raw facts, while information is the processed form of data that reveals meaning.

Metadata

Data about data, providing descriptions of data characteristics and relationships.

DBMS (Database Management System)

A collection of programs that manage the structure and controls access to data.

GIGO

Garbage In, Garbage Out; refers to the idea that poor quality input will lead to poor quality output.

Data Management

The process of generating, storing, and retrieving data for effective utilization.

Data Warehouse

A system that stores data for strategic decision-making, containing both structured and unstructured data.

Data Redundancy

Unnecessary duplication of data in different locations, leading to potential inconsistencies.

Data Anomalies

Errors or irregularities that arise when changes in redundant data are not consistently applied.

File System

An organized collection of files forming a structure for storing data, typically older than databases.

Timely Information

Information that is delivered at the right moment when it is needed.

Reliable Information

Information that can be trusted by users, depending on the validity of data-collection methods.

Data Integrity

The accuracy and consistency of data over its lifecycle, essential for quality decision-making.

Single-user Database

A database that supports only one user at a time, often found in personal computing.

Multi-user Database

A database that supports multiple users simultaneously, enhancing collaborative access.

Centralized Database

A database where data is stored at a single location.

Distributed Database

A database that distributes data across multiple locations or sites.

Database Design

The process of defining the structure and organization of a database to ensure it meets user needs.

Decision Support

Systems designed to support better decision-making in an organization through data analysis.

Verifiable Information

Information that can be checked for accuracy by referencing multiple trusted sources.

Flexible Information

Information that can be utilized for various purposes and contexts within an organization.

Secure Data

Data that is protected against unauthorized access and breaches.

Data Access

The manner in which users interact with and retrieve data from a database.

Organization Survival

The need for effective decision-making based on accurate information for continued success.

End-User Data

Data that is of primary interest to the end users accessing the database.

Procedures in Database Systems

Guidelines and rules governing the design, access, and use of databases.

Peopleware

All individuals who interact with the database system, including admins and end users.

DBMS Software

Software specifically designed to manage database interactions and functionalities.

SQL (Structured Query Language)

A standard programming language used for managing and manipulating relational databases.