Julian Jewel's Weblog()

Julian Jewel

Subscribe to Julian Jewel: eMailAlertsEmail Alerts
Get Julian Jewel: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


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

Read the original blog entry...

More Stories By Julian Jewel

Julian is one of the country's foremost experts in software design, process, and construction. He regularly speaks at major technical conferences. Not only is Julian an expert architect and programmer, he excels at passing his knowledge on to others as both a consultant and educator.

Having worked as a CTO, Julian is also in a unique position to assess and improve both your software and your software-development process. If you're a nontechnical CEO, he can help you bootstrap your startup or analyze (and help you improve) your existing software organization. He regularly does one-on-one CEO and CTO-coaching sessions, and can train individual teams and entire departments on Object-Oriented design/UML, Agile process, and languages.