B

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