March 10

We have had numerous arguments with your DBA’s about normalization.

We had the following issues

  1. Normalizing 2 different tables used by entirely different services (Audit, Business) because they have the same field name
  2. Normalizing immutable audit table

The following links might help you in defending your architecture -

Title

Links

Pat Hellend’s Weblog – Normalization is for Sissies

http://blogs.msdn.com/pathelland/archive/2007/07/23/normalization-is-for-sissies.aspx

Maybe Normalizing isn’t Normal

http://www.magheap.com/article/17114/Maybe-Normalizing-Isnt-Normal.aspx

To Normalize or Not to Normalize

http://www.realsoftwaredevelopment.com/to-normalize-or-not-to-normalize/

Optimizing the database design by Denormalizing

http://technet.microsoft.com/en-us/library/cc505841.aspx

Does Normalization apply to services?

http://soaevolution.blogspot.com/2007/12/does-normalization-apply-to-services.html

Database War Stories – Flickr

http://radar.oreilly.com/archives/2006/04/database_war_stories_3_flickr.html

Should we carve service independence into database?

http://blogs.msdn.com/nickmalik/archive/2007/04/16/soa-question-should-we-carve-service-independence-into-the-database.aspx

Transactions between services, No! No! No!

http://www.ddj.com/blog/architectblog/archives/2007/04/transactions_be.html

SOA and Referential Integrity

http://bill-poole.blogspot.com/2008/04/soa-and-referential-integrity.html

Data Normalization – is it really good?

http://www.infoq.com/news/2007/08/denormalization

Denormalization Patterns

http://database-programmer.blogspot.com/2008/04/denormalization-patterns.html

Denormalization, Performance and Integrity

http://www.dmreview.com/issues/20020601/5251-1.html

Keeping Denormalized values correct

http://database-programmer.blogspot.com/2008/11/keeping-denormalized-values-correct.html

Web 2.0 and Databases – Part I

http://radar.oreilly.com/archives/2006/04/web_20_and_databases_part_1_se.html

Database War Stories – Memorandum

http://radar.oreilly.com/archives/2006/04/database_war_stories_2_bloglin.html

Database War Stories – NASA

http://radar.oreilly.com/archives/2006/04/database_war_stories_4_nasa_wo.html

Database War Stories – Craiglist

http://radar.oreilly.com/archives/2006/04/database_war_stories_5_craigsl.html

SQA & EDA – Using events to bridge decoupled service boundaries

http://searchsoa.techtarget.com/tip/0,289483,sid26_gci1246430,00.html?track=NL-547&ad=581976&asrc=EM_NNL_1092473&uid=1

State management in “Statless” SOA

http://www.oreillynet.com/xml/blog/2007/09/state_management_in_stateless.html

Enterprise SOA

http://books.google.com/books?id=R7oGhITYUuUC&pg=PA117&lpg=PA117&dq=referential+integrity+soa&source=bl&ots=UA5wk8I_GG&sig=T7w3t5GKzVSVH_5OP6A2o6A4WzQ&hl=en&sa=X&oi=book_result&resnum=9&ct=result#PPA117,M1