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

Reporting against OLTP - urgent

3 posters

Go down

Reporting against OLTP - urgent Empty Reporting against OLTP - urgent

Post  dwcurious Thu Jun 16, 2011 2:40 am

I have a set of reports that are going against OLTP systems since the requirement is for real time data reporting. There is a request to improve performance.
Could you suggest ways to do so, data warehouse is not an option. Is ODS better? what are the pros and cons?
Is it recommended to build cubes on top of OLTP?

dwcurious

Posts : 20
Join date : 2011-04-14

Back to top Go down

Reporting against OLTP - urgent Empty Re: Reporting against OLTP - urgent

Post  ngalemmo Thu Jun 16, 2011 7:56 am

DW is not an option, yet every option you propose involves moving the data out of the OLTP system. If you do that, going to the DW is just as valid as others you mention.

The issue is what does the business mean by 'real time'? What level of data latency is acceptable? What level of latency that you do experience will be more an issue of how you can detect change in your source system rather than the choice of target system (although loading a cube would probably be the worst choice in that respect).
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Reporting against OLTP - urgent Empty Re: Reporting against OLTP - urgent

Post  BoxesAndLines Thu Jun 16, 2011 8:58 am

If you have to use the OLTP system, then there are several performance tuning options available. Partitioning, denormalization, and derived tables and or columns, are several techniques. It really sounds like management needs to get a clue though. You can't have your cake and eat it too.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Reporting against OLTP - urgent Empty Re: Reporting against OLTP - urgent

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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