User:Intlcashcow100k/Books/BIRDs Database Dictionary

by Doug.L.Smith@dhl.com

 * 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