Qlikview, why is a revolution?

[joe69008]

hi everybody,

Please, someone can explain me in what Qlikview is a revolution? because it attack directly an OLTP base without need a datawarehouse? but a lot of tools like Webfocus, reportone or BO do that. Moreover, in what the fact to attack directly an prodcution base by franking of datawarehouse oonstruction is a revolution.
And about the quality of data? about the aberant data? about historical data?
Avoid the construction of a DWH is less costly that is sure but there is a real interest.

Thanks for sharing your experience with me.

Best regards.

 

[johnherman]

One of the major reasons for building a data warehouse is to relieve the OLTP system of the burden of processing queries. OLTP systems are optimized for selecting, updating, and inserting one or two rows at a time, aka RAAT (Record At A Time) processing. Data Warehouses are optimized for retrieving data in sets, and utilize off-hours CPU cycles to load and update. If the server which runs the OLTP can handle the burden of the OLAP and report work, there is no reason for a data warehouse based on performance matters.

There are, however, other major reasons to build a data warehouse other than for performance gains.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[joe69008]

Others reasons like about quality data, historical data for example? that's right?
Other reasons for example but i don't sure is right :
Do some reports or Dashboards will be more complex on OLTP base than a Datawarehouse (or a datamart), isn't it?

thanks
best regards

 

[johnherman]

Alot depends on the structure of the OLTP and the structure of the dashboard. Certainly, the OLTP is not designed or optimized to present the dashboard data elements.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[joe69008]

thanks for your answer.