The Art of SQL

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