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 |