Data management Flashcards
1
Q
Database design - data model
A
Designer and user communication
Documentation
2
Q
Database implementation - SQL
A
Globl IT standard for creating, processing, and querying database and their tables
Example: MS Access
3
Q
Data Warehouse
A
Organization-wide, large-scale storage for comprehensive data analysis.
4
Q
Data Mart
A
Department-specific, smaller-scale storage for targeted data analysis.
5
Q
Online Transcational Processing (OLTP)
A
Primarily used for managing day-to-day transactional data, like order processing, payments, inventory management, etc.
6
Q
OLAP (Online Analytical Processing)
A
Designed for data analysis and decision-making, involving complex queries and large volumes of data
