F



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




The Art of SQL
The Art of SQL
ISBN: 0596008945
EAN: 2147483647
Year: N/A
Pages: 143

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net