QlikView

From Wikipedia, the free encyclopedia

QlikView uses various different graphics and colour-coding to illustrate the data in intuitive and comprehensive ways.
Enlarge
QlikView uses various different graphics and colour-coding to illustrate the data in intuitive and comprehensive ways.

QlikView is a Business Intelligence tool developed by QlikTech. It is claimed that it has strong advantages over its competitors is its ease of use and its short implementation time. It is differentiated from other BI tools by the fact that it loads all data live into system memory (RAM) and by the ability of end users to develop their own applications. The primary downside to this approach is that the amount of data that can be loaded is limited by the available system memory. This limitation has recently been eased by the widespread introduction of innexpensive standard 64-bit Xeon and Itanium hardware.

QlikView uses a patented technology, In Memory Associative Technology, to build a non-relational associative database residing in memory, rather than on disk. This is space efficient as there is not a need to pre-calculate measures and due to the lack of null values being recorded. The lack of pre-calculated measures also means that the application can be more flexible that traditional OLAP solutions.

QlikView also provides a GUI which allows end users to interact with the data by clicking on graphs, charts and listboxes. Listboxes are a QlikView specific term referring to the display of fields in the underlying data model as a list in which a each element in the underlying field is displayed uniquely.

The QlikView product has been rated as a Visionary by the Gartner Group's BI Tools Magic Quadrant. Gartner states that QlikTech, as an organization has grown considerably and the application QlikView has demonstrated strong vision in the areas of memory-based calculation and visual development. To be described as a Leader would require that QlikView is deployed as the enterprise standard at more large organizations.