Normalization of existing database

• $QLdb@

  Old Hand

  Points: 388

  More actions

  March 18, 2011 at 10:08 pm

  #389084

  Hi all,

  I have a database of 6o GB which is not in normalized form

  what should be my steps to make it in normalized form

  database consist of 244 tables and 1 crore 40 lac records

• LutzM

  SSC Guru

  Points: 107049

  More actions

  March 19, 2011 at 10:57 am

  #1300929

  Step 1: Understand normalization. You could google for "database design normalization" to get several links to cover the basics.

  Step 2: Understand the meaning and purpose of the data you're dealing with and the relationship.

  Step 3: Start from scratch and design a normalized data structure ("design" in the meaning of creating an ERM, not another physical database).

  Step 4: Compare the normalized design with what you have so far and identify the differences.

  Step 5: Evaluate the effort needed to normalize each denormalized table.

  Step 6: If compromises seem to be required, compare the long-term consequences and the short-term benefit.

  Step 7: Start a project to normalize the current DB (including all tasks a professional project requires)

  Some of the steps may involve external help, e.g. froma consultant or even a Software company.

  Disclaimer: the list above hold just a few basic milestones...

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  March 20, 2011 at 8:41 am

  #1301032

  $QLdb@ (3/18/2011)

  ---

  I have a database of 6o GB which is not in normalized form

  what should be my steps to make it in normalized form

  database consist of 244 tables and 1 crore 40 lac records

  Too little information, may I ask a couple of questions?

  1- Why you say "database is not in normalized form"?

  2- What's the utilization of this particular database, is this an OLTP system or is it a DSS/datawarehouse system?

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.