Hot Girls And Accounting

Database Modeling Building Blocks

Call hot blocking: the result is the same---gridlock! Reverse keys make the index values not sequential in terms of where they are physically written to disk. The result is no locking, no hot blocking, no grid lick, and, thus, much better performance.
Other than table, keys, and indexes, there are other types of objects. These other object types are more easily defined as data management objects and only loosely definable objects. Management of data is the administration process occurring on a production system, long after completion of the data modeling process.

Introducing views and other specialized objects
So far in this chapter, topics covered have included tables, relationships between tables, and relationships between tables are determined by primary keys in parent tables linked to foreign keys in child tables. Foreign keys are copies of primary key field values from parent tables. Indexing is important to understand not directly from a modeling perspective, but that indexes are used to superimpose a different order on top of the order created by the very structure of the relationships between tables, imposed primary and foreign keys.