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]

backup databases

bad SQL queries

bands, aggregating by

batch programs

     queries returning large amounts of data

     queries satisfied by data from an index

BCNF (Boyce-Codd normal form)

Bill of Materials (BOM) problem

bind variables

bind_param( ) method

binding variables 2nd

     PHP

bitmap indexes

blanket views, performance impact on queries

blocks

     contention for access

     locking

     minimizing accesses to

     pre-joined tables and

BOM (Bill of Materials) problem

book indexes, table of contents vs.

Boolean columns, qualifying

bottom-up tree walk 2nd

     adjacency model

     materialized path model

     nested set model

     performance, comparing for various models

boundaries of ranges, defining well

Boyce-Codd normal form (BCNF)

bridge tables

Building the Data Warehouse

business logic, mirrored by SQL statements

business processes, physical design and

business requirements

     atomicity and

     database modeling and

business tasks, focusing on