Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Introduction
Logical Database Design Antipatterns
Jaywalking
Naive Trees
ID Required
Keyless Entry
Entity-Attribute-Value
Polymorphic Associations
Multicolumn Attributes
Metadata Tribbles
Physical Database Design Antipatterns
Rounding Errors
31 Flavors
Phantom Files
Index Shotgun
Query Antipatterns
Fear of the Unknown
Ambiguous Groups
Random Selection
Poor Man's Search Engine
Spaghetti Query
Implicit Columns
Application Development Antipatterns
Readable Passwords
SQL Injection
Pseudokey Neat-Freak
See No Evil
Diplomatic Immunity
Magic Beans
Appendixes
Rules of Normalization
Bibliography
[1]
[A]
[SPT]
[HPM]
Examples of entity-relationship diagrams
Diagram for example bug database
[1]
[2]
Intersection table entity-relationship diagram
[2]
Adjacency list entity-relationship diagram
Threaded comments illustration
Jaywalking
[3]
Nested Sets illustration
Closure Table illustration
Comparing hierarchical data designs
[JCTAHISFS]
[SDP]
[3]
Rules of Normalization
[4]
[JCSPS]
[5]
[4]
[5]
[6]
Entity-Attribute-Value
Polymorphic Associations
[7]
[6]
[7]
[ARMODFLSDB]
Object-oriented class diagram for bug types
EAV entity relationship
[POEAA]
Simple association
Concrete Table Inheritance
Polymorphic association
Multicolumn Attributes
Polymorphic Associations for addresses
[8]
Reversing a polymorphic association
Single Table Inheritance
Class Table Inheritance
Association of Comments to the Base Issues table
[8]
Jaywalking
[9]
Entity-Attribute-Value
Jaywalking
[9]
[10]
Multicolumn Attributes
[10]
[WECSSKAFA]
[11]
[11]
MySQL query execution plan
[12]
[13]
[12]
Poor Man's Search Engine
[13]
Legitimate Uses of the Antipattern
[14]
[14]
[15]
Choose Next Higher Key Value
[15]
[16]
[17]
[18]
[16]
[17]
[18]
Cartesian product between fixed and open bugs
[19]
[19]
Keyless Entry
[20]
[DSOSS]
[21]
[22]
SQL Injection
[20]
[21]
[22]
[23]
[24]
Exploits of a mom
[25]
[26]
[23]
[24]
[25]
[26]
[27]
[28]
[27]
Special Scope for Sequences
[28]
A fatal error in PHP results in a blank screen
[29]
[30]
[29]
[30]
[31]
[32]
[33]
[AWDWR]
[34]
Schema Evolution Tools
[31]
[32]
[33]
[34]
[35]
Model View Controller
[36]
[TLOLA]
[37]
[38]
Using Magic Beans leads to vinelike tangles.
[39]
[AUAPAITOAADAID]
[DDTCITHOS]
Untangling the vines by decoupling
[35]
[FAFOSE]
[36]
[TLOLA]
[37]
[POEAA]
[38]
[39]
[TPPFJTM]
Implicit Columns
Entity-Attribute-Value
Polymorphic Associations
Pseudokey Neat-Freak
Jaywalking
Index Shotgun
Progression of normal forms
Multicolumn Attributes
Jaywalking
Repeating groups vs. first normal form
Redundancy vs. second normal form
[40]
Redundancy vs. third normal form
Third normal form vs. Boyce-Codd normal form
Merged relationships vs. fourth normal form
Merged relationships vs. fifth normal form
[41]
[42]
[40]
[41]
[42]
← Prev
Back
Next →
← Prev
Back
Next →