Hardware Required

Wed, 30 Apr 2014 08:27:26 GMT

Dear All,

I want to know how much RAM,CPU and Storage... [HARDWARE RESOURCE] required for establish an Qlikview environment

for 10TB data in Oracle.

Regards,

Rahul

Re: Hardware Required

MK_QSL — Wed, 30 Apr 2014 08:50:45 GMT

Check enclosed files...

Re: Hardware Required

its_anandrjs — Fri, 31 Oct 2014 17:17:53 GMT

Please find the attached document

Also you can refer this post

RAM

Re: Calculate how much RAM needed?

Regards

Anand

Re: Hardware Required

JonnyPoole — Fri, 31 Oct 2014 17:36:28 GMT

Hi - just a word of caution..

If you plug 10TB as a raw figure into a formula to calculate RAM needs you will most likely grossly over estimate your true RAM requirements for QLIK.

Its important to think about data requirements in terms of a limited data model not a raw database.

That doesn't come across in the documentation where we need to do a better job.

A bit more: a single QlikView app is supported by a single data model that will cover a series of dimensions and calculate a series of KPIs. It will answer a 'family' of questions about that data model. It will give a user access to any intersection or possible summary in that data and its very easy to overload a user with information .

If you are familiar with BO , Cognos or any other enterprise reporting platform a customer will likely have more than 1 data model per database to support different families of questions. Building a giant model (in any tool) off a large database becomes harder and harder to serve all needs and ultimately becomes an exercise in compromising everything from agility to performance. Its better and mandatory in qlikview to address a sizable chunk of data in pieces that users can manage.

In Qlik , for a 10TB database you will likely need more than one data model to 'package' all the information into a format that a user can actually consume. That means 'pieces' of the database for each qlikview app and sizing the pieces (probably just the first piece to begin with) and not something like 10TB disk = 4TB RAM

i'm not saying there aren't the odd use case that needs a very deep (many rows) data set. They exist. But they aren't the norm hence my comment.

topic Re: Hardware Required in QlikView

Hardware Required

Re: Hardware Required

Re: Hardware Required

Re: Hardware Required

Re: Hardware Required