[go: nahoru, domu]

Jump to content

User:Intlcashcow100k/Books/BIRDs Database Dictionary

From Wikipedia, the free encyclopedia


BIRDs Database Dictionary[edit]

by Doug.L.Smith@dhl.com[edit]

Introduction
Business intelligence
Decision support system
Database
Database design
Data warehouse
Data mart
Data mining
Data governance
Enterprise architecture
Applications & Language
Functional dependency
Relational model
Microsoft SQL Server
SQL Server Integration Services
Business Intelligence Development Studio
Microsoft SQL Server Master Data Services
Microsoft Analysis Services
SQL
XML
Metadata
Data definition language
Report Definition Language
Dimensional modeling
Online analytical processing
Workflow application
Types of Keys
Star schema
Foreign key
Unique key
Relational database
Surrogate key
Candidate key
Compound key
Optimization
Database normalization
Aggregate (data warehouse)
Database index
Partition (database)
Scalability
Staging (data)
Key Terms
Fact table
Dimension table
View (database)
Dimension (data warehouse)
Extract, transform, load
Slowly changing dimension
Degenerate dimension
Snowflake schema
Tuple
Tuple-versioning
Temporal database
Modular programming
Parallel computing
Referential integrity
Propagation constraint
Entity integrity
Domain/key normal form
Cardinality
Algorithm
Data model
OLAP cube
Transaction log
MultiDimensional eXpressions
Database schema
Entity–relationship model
Relational database management system