Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

using an OR mapper for a data warehouse

Posted on 2011-03-25
1
Medium Priority
?
334 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

927 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