OLTP vs OLAP in finance

5 pts.
Tags:
Database
Finance
olap
OLTP
Storage
In the past years our company moved from collecting excel files to OLTP database storage. Focusing on data quality, processes integration and reporting tools now the path has been created. Traditional optimization methods applied to OLTP databases (indexing, partitioning etc.) are going to be insufficient in terms of improving reporting time as the amount of data will increase. Furthermore non-IT users have difficult to extract data from OLTP systems, and also extracting data through data visualization tools is possible only if they have a good command of OLTP relations/tables/rules. In the other hand de-normalization of data can create incongruences in terms of reporting and collection of data. Develop OLAP systems requires also a big amount of time in creating schemas, rules, systems with the only gain to have better reporting systems and more users involved. Is there any best-practice to handle this change? How I can decide the best direction for my company? Do you have any suggestion on books, cases, discussions that can help my on manage this change?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: