179 | | * http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/ |
180 | | * Normalization: |
181 | | * http://msdn.microsoft.com/en-us/library/ms191178%28SQL.100%29.aspx |
182 | | * http://www.tomjewett.com/dbdesign/dbdesign.php?page=normalize.php |
183 | | * http://www.sqlteam.com/article/database-design-and-modeling-fundamentals |
184 | | * http://msdn.microsoft.com/en-us/library/dd129510%28VS.85%29.aspx |
| 181 | * http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/ |
| 182 | * Normalization: |
| 183 | * http://msdn.microsoft.com/en-us/library/ms191178%28SQL.100%29.aspx |
| 184 | * http://www.tomjewett.com/dbdesign/dbdesign.php?page=normalize.php |
| 185 | * http://www.sqlteam.com/article/database-design-and-modeling-fundamentals |
| 186 | * http://msdn.microsoft.com/en-us/library/dd129510%28VS.85%29.aspx |
186 | | * http://www.intermedia.net/support/sql/sqltut.asp |
187 | | * http://sqlcourse.com/intro.html |
188 | | * http://www.w3schools.com/sql/default.asp |
189 | | * http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html |
| 188 | * http://www.intermedia.net/support/sql/sqltut.asp |
| 189 | * http://sqlcourse.com/intro.html |
| 190 | * http://www.w3schools.com/sql/default.asp |
| 191 | * http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html |
191 | | * http://www.tomjewett.com/dbdesign/dbdesign.php?page=intro.html |
192 | | * http://www.w3schools.com/Sql/sql_join.asp |
193 | | * http://en.wikipedia.org/wiki/Join_(SQL |
194 | | * http://www.plus2net.com/sql_tutorial/sql_linking_table.php |
195 | | * http://en.wikipedia.org/wiki/Entity-attribute-value_model |
196 | | * http://pypi.python.org/pypi/eav-django |
197 | | * Object-Relational Mapping: http://www.objectmatter.com/vbsf/docs/maptool/ormapping.html |
198 | | * Modified preorder Tree Traversal (for large Hierarchical trees): http://www.sitepoint.com/print/hierarchical-data-database/ |
199 | | * GAE Many<>Many: http://arbingersys.blogspot.com/2008/04/google-app-engine-better-many-to-many_30.html |
200 | | * Django ORM & JOINs: http://slott-softwarearchitect.blogspot.com/2009/07/object-models-and-relational-joins.html |
201 | | * Especially useful for USB (minimise disk access): http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html |
202 | | |
| 193 | * http://www.tomjewett.com/dbdesign/dbdesign.php?page=intro.html |
| 194 | * http://www.w3schools.com/Sql/sql_join.asp |
| 195 | * http://en.wikipedia.org/wiki/Join_(SQL |
| 196 | * http://www.plus2net.com/sql_tutorial/sql_linking_table.php |
| 197 | * http://en.wikipedia.org/wiki/Entity-attribute-value_model |
| 198 | * http://pypi.python.org/pypi/eav-django |
| 199 | * Object-Relational Mapping: http://www.objectmatter.com/vbsf/docs/maptool/ormapping.html |
| 200 | * Modified preorder Tree Traversal (for large Hierarchical trees): http://www.sitepoint.com/print/hierarchical-data-database/ |
| 201 | * GAE Many<>Many: http://arbingersys.blogspot.com/2008/04/google-app-engine-better-many-to-many_30.html |
| 202 | * Django ORM & JOINs: http://slott-softwarearchitect.blogspot.com/2009/07/object-models-and-relational-joins.html |
| 203 | * Especially useful for USB (minimise disk access): http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html |