Data Warehouse, PostgreSQL with Python, NoSQL & MongoDB

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/24

flashcard set

Earn XP

Description and Tags

Glossary-style vocabulary flashcards covering data warehouse concepts, PostgreSQL with Python basics, and NoSQL/MongoDB topics from the lecture notes.

25 Terms

1
New cards

Data warehouse

A subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision-making.

2
New cards

Subject-Oriented

A data warehouse can be used to analyse a particular subject area (e.g., marketing).

3
New cards

Integrated

A data warehouse integrates data from multiple data sources into a single, consistent view.

4
New cards

Time-Variant

Historical data is stored so you can retrieve data from previous time periods.

5
New cards

Non-volatile

Once data is in the data warehouse, it does not change; historical data remains unchanged.

6
New cards

Bottom-up approach

Starts with experiments and prototypes; useful in early stages to evaluate benefits before large commitments.

7
New cards

Top-down approach

Starts with overall design and planning; useful when technology is mature and business problems are well understood.

8
New cards

Hybrid approach

Combines the planning strength of top-down with the rapid, incremental implementation of bottom-up.

9
New cards

Grain

The fundamental, atomic level of data represented in the fact table (e.g., individual transactions).

10
New cards

Dimension

The attributes that apply to each fact table record (e.g., time, item, customer).

11
New cards

Measures

Numeric additive quantities that populate the fact table (e.g., quantity sold).

12
New cards

PostgreSQL

Free, open-source relational database management system.

13
New cards

psql (SQL Shell)

A terminal-based tool for writing and executing SQL commands.

14
New cards

psycopg2

PostgreSQL database adapter for Python; enables Python–PostgreSQL interaction.

15
New cards

psycopg2.connect()

API call that opens a connection to a PostgreSQL database.

16
New cards

cursor()

Creates a cursor object to execute SQL statements within a connection.

17
New cards

commit()

Commits the current transaction so changes become visible to other connections.

18
New cards

fetchone()

Fetches the next row of a query result as a single tuple (or None if no more data).

19
New cards

fetchall()

Fetches all remaining rows of a query result as a list.

20
New cards

NoSQL

Non-relational databases with flexible schemas, horizontal scaling and BASE-style consistency.

21
New cards

BASE model

Basic Availability, Soft State, and Eventual Consistency; a common NoSQL consistency model.

22
New cards

HOLAP

Hybrid OLAP: combines MOLAP and ROLAP storage so you can use pre-calculated cubes with relational data.

23
New cards

Graph database

Stores data as nodes and edges to model highly connected data (e.g., fraud detection, social networks).

24
New cards

Document database

Stores semi-structured data as JSON-like documents; no fixed schema; examples include MongoDB.

25
New cards

MongoDB

Popular NoSQL document-oriented database that stores data as BSON/JSON and supports indexing, sharding and replication.