Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

using an OR mapper for a data warehouse

Hello

Are there any problems with using OR mappers for creating code to insert/update data in a data warehouse?

The data warehouse I am considering has a reverse star schema whereby the dimension tables have foreign keys to the main table.

thanks
0
andieje
Asked:
andieje
1 Solution
 
dportasCommented:
I suspect scalability might be an issue. OR mappers sometimes struggle to cope with large, complex data sets whereas loading a DW typically involves joins to retrieve surrogate keys, determine whether an update or insert is needed, etc. OR/Ms are generally optimised for lots of small updates whereas DW tends to require fewer, larger data loads.

O/R mappers probably won't provide the kind of out-of-the-box logging and process orchestration that you would usually expect from a more conventional ETL tool.

Also most people working in the DW/BI space are probably more familiar with the standard ETL tools and perhaps less likely to be programmers in the languages supported by the OR mapper.

Is there some reason why you are considering an OR mapper for this rather than a data integration / ETL tool? I can't think of many advantages for a DW application, although I expect it could work in some circumstances.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now