?
Solved

using an OR mapper for a data warehouse

Posted on 2011-03-25
1
Medium Priority
?
335 Views
Last Modified: 2012-05-11
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
Comment
Question by:andieje
1 Comment
 
LVL 22

Accepted Solution

by:
dportas earned 2000 total points
ID: 35226731
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question