topic Re: what is aql? in QlikView

what is aql?

Wed, 18 Jun 2014 17:28:15 GMT

what is aql?

Re: what is aql?

venkatg6759 — Wed, 18 Jun 2014 17:30:12 GMT

Hi Raja,

AQL is a query language based on a data base management system which uses Codd's relational model of data. It has been designed mainly to be used by the nonspecialist in data processing for interactive problem solving, application building, and simulation. Ease of use is achieved by providing an interface which allows the use of default options, synonyms, and definitions of attributes, inference, and the possibility of interactive completion of the query (i.e., menu). AQL combines the capabilities of the relational model of data with the powerful computational facilities and control structure of the host programming language (i.e., APL). A prototype version of AQL, which has been implemented, is reviewed.

Re: what is aql?

its_anandrjs — Wed, 18 Jun 2014 17:32:27 GMT

You can best read this thread which is about the AQL. AQL is stands for the Associated Query Language which is based on the association rules.

Definition:-

Associate Query Logic QlikView is based upon patented technology called Associative Query Logic (AQL). AQL enables QlikView to work with millions of cells and still respond to queries in less than a second. High-speed associations occur as the user clicks in the various sheet objects, and the display is updated immediately.

By replacing resource intensive relational joins with AQL, QlikView removes the need to pre-aggregate data for most applications. In Online Analytical Processing (OLAP) applications, QlikView removes the need to define complex dimensional hierarchies and generate cubes. QlikView performs calculations on the fly, allowing any user to become a sophisticated knowledge worker.

What is AQL? How It behavior in QlikView?