March 11, 2013 at 2:14 am
Hi,
We are creating a Data Warehouse for our Client
We need to store a list of locations that our company.
My Colleague says we will store the list of all the cities in the world in a table (this table contains 8 MIllion records roughly) but i am suggestion that we will use only the required data in that table (Not more than 1000).
Which will be better option.
Kindly Tell me the correct way to go.
Note: This is a data warehouse and not a OLTP database.
March 11, 2013 at 2:22 am
ard5karthick (3/11/2013)
Hi,We are creating a Data Warehouse for our Client
We need to store a list of locations that our company.
My Colleague says we will store the list of all the cities in the world in a table (this table contains 8 MIllion records roughly) but i am suggestion that we will use only the required data in that table (Not more than 1000).
Which will be better option.
Kindly Tell me the correct way to go.
Note: This is a data warehouse and not a OLTP database.
" This is a data warehouse and not a OLTP database."
I am not sure how will this make a difference .
Storing 1000 data rather than 8 million data is better ; but, the point is it's not about design at all .. it's about usage of that data . Will you be needing 8 million cities records , or the 1000 is enough for the company techincal framwork ??
Store the data that is of any use in present or in future .. there is no point in saving unnecessary data , it would just cause query overhead and maintenance overhead ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
March 12, 2013 at 8:11 am
What is the other person's justifications for wanting to store 8M entries, 7.99999M of which will never be referenced?
Completely horrible suggestion from a performance standpoint for numerous reasons.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply