Menu
Download Free Trial

Best practices on on implementing pivot tables on top of Oracle DB with large datasets

Resolved

Hi,

my team is currently looking at how to best implement slice & dice pivot tables for a .NET app that is built on top of an Oracle DB (12c). We are dealing with 3+ million transaction records but don’t yet have any data-warehouse and/or OLAP cube in place. Will the simple “optimized CSV” approach of Flexmonster scale with a dataset this large? In general, what are the best practices you guys would recommend for such a setup?
 
Thanks in advance,
Chris

1 answer

Public
Dmytro Zvazhii Flexmonster July 24, 2017

Hello Christian,
Thank you for your questions. We have collected all our experience and shared it in the following article – http://www.flexmonster.com/blog/blog-perform-faster/. It is a little bit outdated but the key ideas are still relevant. Speaking about your case, you need to choose between two options.

Please let us know if you have additional questions here.
Best regards,
Dmytro.

Please login or Register to Submit Answer