Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] fact dimension fact tables joining to dimensions querying querying star schema through federated systems fifth normal form (5NF) filtering conditions 2nd dynamically concatenated evaluation of large quantities of data meaning of proportions of retrieved data queries returning a few rows from direct, specific criteria financial structures, risk exposure calculations fine (granularity) first normal form (1NF) fixed, inflexible database model flexibility (excessive), dangers of foreign keys indexes and integrity constraint in master/detail relationship multiple indexing of the same columns referencing underlying tables in partitioned view free lists from clauses nested queries in uncorrelated subqueries rewritten as inline views uncorrelated subquery in full table scans 2nd indexes vs. on tables expected to grow functions added to DBMS products aggregate built-in, advantages over external functions indexes with 2nd implicit conversions and OLAP, operating on sliding windows user-defined 2nd |