City and Airport Terminal tables in dimensional modelling

View previous topic View next topic Go down

City and Airport Terminal tables in dimensional modelling

Post  amargaddam on Tue May 11, 2010 9:46 am

Hi,

We have City and Terminal as 2 separate reference tables around Order fact in Star Schema. Products like Hotels, restaurants are reported at city level and granularity for products like Flight is at terminal level.

Both City and Terminal tables have few common attributes like City_Name, Country_Code, Country_Name, Continent_Code etc. Is there any way to have relationship between these tables to avoid data duplication? or have only one table?

I have thought of common table between City and Terminal which can hold common attributes and keying back to respective tables but that is more like normalized way rather than dimensional/star schema approach.

Can you please suggest/advise any other way? Thx in advance.

Thx,
Amar

amargaddam

Posts : 2
Join date : 2010-05-11

View user profile

Back to top Go down

Re: City and Airport Terminal tables in dimensional modelling

Post  ngalemmo on Tue May 11, 2010 12:04 pm

Why not just call it 'Location' and put everything in one dimension? Add a type code so you know what a row represents and populate attributes appropriate for the type. There isn't that much difference in the data and, even if you have every town and airport terminal in the world, its not going to be that much data. When you can get a GPS system that covers North America (with landmarks, hotels, gas stations, ATM machines, etc...) that you can hold in the palm of your hand, how much data could there possibly be? Sure, a GPS only stores a name once, but for a database, repeating a name 1,000 times is no big deal.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: City and Airport Terminal tables in dimensional modelling

Post  amargaddam on Fri May 21, 2010 6:22 am

Thx for inputs. Location entity makes sense. Let me design in that way.

amargaddam

Posts : 2
Join date : 2010-05-11

View user profile

Back to top Go down

Re: City and Airport Terminal tables in dimensional modelling

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum