Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Qlikview, why is a revolution?

Status
Not open for further replies.

joe69008

Programmer
Jun 29, 2005
42
FR
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.
 
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top