[go: nahoru, domu]

Jump to content

User:Sdevang01/Books/Data Warehousing

From Wikipedia, the free encyclopedia


Data Warehousing[edit]

Datawarehouse
Data warehouse
Data mart
Data model
Snowflake schema
Star schema
Reverse star schema
Online analytical processing
OLAP cube
Operational data store
Online transaction processing
Facts and dimensions
Fact table
Dimension (data warehouse)
Attribute (computing)
Degenerate dimension
Slowly changing dimension
Master data management
ETL
Extract, transform, load
Change data capture
Staging (data)
Data mining
Data integrity
Data integration
Data cleansing
Business Intelligence
Business intelligence
Data visualization
Databases
Database
Relational database
Entity–relationship model
Table (database)
Referential integrity
Natural key
Unique key
Surrogate key
Foreign key
Candidate key
Normalization
Database normalization
First normal form
Second normal form
Third normal form
Fourth normal form
Fifth normal form
Sixth normal form
Boyce–Codd normal form
Domain/key normal form