1/24
Glossary-style vocabulary flashcards covering data warehouse concepts, PostgreSQL with Python basics, and NoSQL/MongoDB topics from the lecture notes.
Data warehouse
A subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision-making.
Subject-Oriented
A data warehouse can be used to analyse a particular subject area (e.g., marketing).
Integrated
A data warehouse integrates data from multiple data sources into a single, consistent view.
Time-Variant
Historical data is stored so you can retrieve data from previous time periods.
Non-volatile
Once data is in the data warehouse, it does not change; historical data remains unchanged.
Bottom-up approach
Starts with experiments and prototypes; useful in early stages to evaluate benefits before large commitments.
Top-down approach
Starts with overall design and planning; useful when technology is mature and business problems are well understood.
Hybrid approach
Combines the planning strength of top-down with the rapid, incremental implementation of bottom-up.
Grain
The fundamental, atomic level of data represented in the fact table (e.g., individual transactions).
Dimension
The attributes that apply to each fact table record (e.g., time, item, customer).
Measures
Numeric additive quantities that populate the fact table (e.g., quantity sold).
PostgreSQL
Free, open-source relational database management system.
psql (SQL Shell)
A terminal-based tool for writing and executing SQL commands.
psycopg2
PostgreSQL database adapter for Python; enables Python–PostgreSQL interaction.
psycopg2.connect()
API call that opens a connection to a PostgreSQL database.
cursor()
Creates a cursor object to execute SQL statements within a connection.
commit()
Commits the current transaction so changes become visible to other connections.
fetchone()
Fetches the next row of a query result as a single tuple (or None if no more data).
fetchall()
Fetches all remaining rows of a query result as a list.
NoSQL
Non-relational databases with flexible schemas, horizontal scaling and BASE-style consistency.
BASE model
Basic Availability, Soft State, and Eventual Consistency; a common NoSQL consistency model.
HOLAP
Hybrid OLAP: combines MOLAP and ROLAP storage so you can use pre-calculated cubes with relational data.
Graph database
Stores data as nodes and edges to model highly connected data (e.g., fraud detection, social networks).
Document database
Stores semi-structured data as JSON-like documents; no fixed schema; examples include MongoDB.
MongoDB
Popular NoSQL document-oriented database that stores data as BSON/JSON and supports indexing, sharding and replication.