Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Data Stores on Separate Databases within DW.

2 posters

Go down

Data Stores on Separate Databases within DW. Empty Data Stores on Separate Databases within DW.

Post  MarkW Fri Dec 04, 2015 2:30 pm

Is there an argument to have separate databases within a data warehouse for the following data stores:


  • Staging
  • Normalised Data Store
  • Operational Data Store
  • Dimensional Data Store


Conversely, is there an argument to mix your operational data store with your dimensional data store for example? So, you would end up with a database with a mix of tables you would normally expect to find in a ODS with fact and dimension tables, which you would expect to find in a DDS?

Our DW is hosted by a supplier, and they are ooh-ing and ahh-ing over allowing us to create databases on the SQL server instance. Why, justification, etc. I would expect them to be on a separate database, not least for it to be more organised, and therefore, easier to support and maintain for example.

MarkW

Posts : 14
Join date : 2015-11-25

Back to top Go down

Data Stores on Separate Databases within DW. Empty Re: Data Stores on Separate Databases within DW.

Post  ngalemmo Fri Dec 04, 2015 3:05 pm

Are you talking about multiple databases on the same server or multiple servers?

Same server is just a logical subdivision that should not impact interoperability between the databases. If you are considering different servers, it is a matter of how much interaction occurs between the disparate systems. Generally speaking, you want staging to occur on the same server as the targeted data store. You would want to avoid joining tables across servers at all costs.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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