Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

One database or many?

One database or many?

One database or many?

I'm fairly new to data warehousing, though I've been a database developer for a long time.

At my new company, they have all data, including the staging data, in a single database.

This seems to break all kinds of conventions, and seems like it would cause issues with security, backup/restore, and other things.

Is this done in the data warehousing space? Are there substantial reasons for consolidating (or not consolidating) all warehousing activity into a single database?

RE: One database or many?

Well first off Data Warehousing will seem to go against all of your learned conventions depending on the methodology followed.  

As for Having the staging area with in your DW if done right the only area it may pose a problem with is backups.  You can implement a different schema to break the tables out into a more identifiable group, and apply a standard naming convention.  Your security can be handled through the schema as well.  As for performance it depends on how your files and files groups are structured as to the impact.  Seperate file groups on seperate drives will cause little to no overhead against the production DW tables.

Data Warehouse vs OLTP conventions can be so different that I have been able to train developers with little to no DB experience easier than I have someone with 10 years of OLTP development.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close