M

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]

many-to-many relationship resolving between two tables
master/detail relationships
matching, finding the best match
materialized path model (SQL trees) 2nd
     aggregating values stored in leaf nodes
         computing head counts at every level
     bottom-up tree walk
     path explosion
     substituting for connect by or recursive with
     top-down walk
materialized views
     pre-joining vs.
measurement values, storage of
memory
     addresses for data storage
     corrupting by mishandling pointers
merge statement, Oracle 9i
merge table (MySQL)
meta-design
mini-dimensions
modeling
     head counts
         computing at every level
modularity, database programming and
monitoring performance
     defining good performance
         checking against standards
         defining performance goals
         knowing what you get
         knowing what you spend
     execution plans
         forcing the right plan
         identifying the fastest
         using properly
     server load
     slow database
     statements currently being executed
     thinking in business tasks
     what really matters in improving queries
"more-flexible-than-thou" construct
movie database
     designing database and main search query
     redesigning main search query for tight fit
     wrapping SQL in PHP
MySQL
     last_insert_id( )
     merge table
     PHP, using with