Database Development Vocabulary

Flashcards covering key vocabulary and concepts discussed in the Database Development lecture, including database lifecycle phases, business intelligence, data administration, and SQL practices.

Database Development Lifecycle (DDLC)

Framework for database development to ensure structured approach.

Phase 1: Database Initial Study

Analysing the organization, defining problems and constraints, defining objectives, and defining scope and boundaries.

Phase 2: Database Design (Part 1)

Data requirement analysis, ER modelling and normalisation, and ER Model verification.

Phase 2: Database Design (Part 2)

Select resources for Implementation, Logical Design, and Physical Design.

Phase 3: Implementation and Loading

Creating DB, assigning permission to a Database Administrator (DBA), creating tables within DB, and assigning permission to users.

Phase 4: Testing and Evaluation

Testing performance, security constraints, integrity and concurrent access.

Phase 5: Operation

Completed database going into production, users start to interact with data, DBA fine-tunes, allocates storage, controls access, and performs backups.

Phase 6: Maintenance and Evaluation

Preventive, corrective, and adaptive maintenance; access control, statistics, auditing, and periodic system-usage summaries.

Business Intelligence (BI)

Comprehensive, cohesive, integrated set of tools and processes that captures, collects, integrates, stores, and analyzes data, generating information to support business decision making.

Artificial Intelligence (AI)

A technique which enables machines to replicate human’s intelligent behaviours.

Machine Learning

Subset of AI technique to enable machines to learn from data with statistical methods.

Deep Learning

Subset of ML with multi-layer neural network.

Data visualization

Enhances data understanding through advanced visual techniques (e.g., charts, graphs).

Online Analytical Processing (OLAP) tools

Enables multidimensional data analysis (e.g., drill-down, roll-up) since data is organized in cubes with dimensions like time, geography, product, etc..

Portals

Provides a unified, web-based entry point to integrate and distribute data from multiple sources into a single webpage.

Data analysis and reporting tools

Queries diverse data sources to generate integrated reports.

Data-mining tools

Applies advanced statistical analysis to uncover hidden patterns or opportunities in business data.

Data warehouses (DW)

Serves as the foundation of BI infrastructure, integrating production system data in near real-time into BI tools.

DATA ADMINISTRATOR (DA)

Focuses on strategic planning, control, and supervision, setting long-term goals and policies.

DATABASE ADMINISTRATOR (DBA)

Focuses on executing plans, enforcing policies, and daily operations.

foreign key

A key that uniquely identifies a row in another table.

Nosql Database Characteristic

It can handle large volumes of unstructured data.

INNER JOIN

Returns only rows that have matching values in the common column of both tables.

3NF (Third Normal Form)

Removes transitive dependencies.

Primary role of a Data Warehouse (DW) in Business Intelligence (BI)

To serve as the foundational infrastructure and enable BI tools.