D

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]

data containers, contention when trying to access
data corruption
data definition language (DDL)
data duplication
     detection of duplicate primary keys
     minimizing with normalization
data entry errors
data flow
data manipulation language (DML)
     commit statements
data manipulation operations, ranking in terms of overall cost
data modeling 2nd
     historical data
data pages
     accessed by database engine, keeping as low as possible
     number visited by DBMS during a query
     number you are hitting
data purges
data redundancy
data volumes (large), coping with
     data warehousing
     increasing volumes
         partitioning as solution
         sensitivity of operations to
     sudden increase in volume
Data Warehouse Toolkit, The
data warehousing
     cautions about
     data extraction
     integrity constraints and indexes
     loading data
     querying dimensions and facts
     star transformation
         emulating
     transformation
data-driven partitioning 2nd
     concurrency problems and
     true partitioning
database access libraries
database accesses
     maximizing usefulness of
     minimizing
     multiplying
database connections, managing use of
database links
     performance and
databases
     conflicting goals in optimizing physical layout of data
     locking entire database
     reorganizations of
     SQL and
     structural types
date arithmetic
date type
dates and times
     comparing dates
     partitioning
     partitioning historical data tables by date
     simple or range searching on dates
datetime type
DB2
     call to get new sequence value
     clustering index
     range-clustering
     recursive with statement 2nd
DBA (database administrator), solutions to contention 2nd
DBMS
     closeness to kernel
     partition, different meanings of
dbms_application_info package (Oracle)
DDL (data definition language)
decision support systems (DSS)
     interaction with production databases
     query tools
declarative language
declarative processing, procedural vs.
decode( ) function
delete operations
     against a database
     ranking in terms of overall cost
denormalization
     caused by ready-made solutions
dependencies, analyzing
     Boolean columns
     checking attribute independence
     checking dependence on whole key
     data replications and
depth, hierarchical data 2nd 3rd
design
     performance and
developmental solutions to contention
dimension tables
     joining dimensions to fact tables
     querying
dimensional modeling
     caution with
     facts and dimensions
     querying dimensions and facts
     SQL implications
directives to the optimizer 2nd 3rd
disk addresses, indexes referring to
distinct
     avoiding at the top level
     implicit
     regular join with
distributed systems
DML (data manipulation language)
     commit statements
double conversion 2nd
duplicate data
     detection of duplicate primary keys
     minimizing with normalization
dynamic queries 2nd
dynamic search criteria
     defining movie database and main query
     mistakes common in queries with
     redesigning main query to fit criteria tightly
     wrapping SQL in PHP