International SOA World Conference & Expo

SOA in the Cloud Expo

Subscribe to SOA in the Cloud Expo: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get SOA in the Cloud Expo: 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 -



Pat Hellend’s Weblog – Normalization is for Sissies

Maybe Normalizing isn’t Normal

To Normalize or Not to Normalize

Optimizing the database design by Denormalizing

Does Normalization apply to services?

Database War Stories – Flickr

Should we carve service independence into database?

Transactions between services, No! No! No!

SOA and Referential Integrity

Data Normalization – is it really good?

Denormalization Patterns

Denormalization, Performance and Integrity

Keeping Denormalized values correct

Web 2.0 and Databases – Part I

Database War Stories – Memorandum

Database War Stories – NASA

Database War Stories – Craiglist

SQA & EDA – Using events to bridge decoupled service boundaries,289483,sid26_gci1246430,00.html?track=NL-547&ad=581976&asrc=EM_NNL_1092473&uid=1

State management in “Statless” SOA

Enterprise SOA,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.