Ad-hoc Queries meaning analysis

Source: Internet
Author: User

Meaning of Ad hoc

No pre-planned or low-planned or unpredictable events

Or indicate that the described thing is a stopgap, a deliberate plan, or an impromptu event .

Ad hoc queries (adhoc query)

Ad hoc query is based on the user's own needs, flexible choice of query conditions, the system can be based on the user's choice to generate the corresponding statistical reports . The biggest difference between ad hoc query and ordinary application query is that the Common application query is custom developed, and the Ad hoc query is custom-defined by the user.

In the field of data warehousing there is a concept called ad hoc queries, Chinese is generally translated as "ad hoc query."

Ad hoc queries are those that users define when they use the system, based on their own needs at that time. Ad hoc queries are generated in many ways, the most common being the use of ad hoc query tools. The General Data Presentation tool provides ad hoc query functionality. The usual way is to map the dimension tables and fact tables in the data warehouse to the semantic layer, which allows the user to select tables through the semantic layer, establish associations between tables, and ultimately generate SQL statements. There is no essential difference between an ad hoc query and a typical query from an SQL statement. The difference between them is that the usual queries are known during system design and implementation, and all of us can optimize these queries by indexing, partitioning, and so on when the system is implemented, making these queries highly efficient. While ad hoc queries are produced temporarily by users while they are in use, the system cannot pre-optimize these queries, so ad hoc queries are also an important indicator for evaluating data warehouses.

the location of an ad-hoc query is typically in a relational data warehouse, in EDW or ROLAP . Multidimensional databases have their own methods of storage, and there is no difference between ad hoc queries and common queries. In a data warehouse system, the more the Ad hoc query is used, the higher the requirement for the data warehouse, the higher the symmetry of the data model. The symmetric data model is the same for all queries, which is an advantage of dimensional modeling .

Ad hoc Network

As a term, ad hoc networks (temporary networks) usually refer to temporary networks that are not pre-scheduled or organized by some network devices on a very low schedule.

Ad hoc assumptions (also as "special case assumptions" or "ad hoc assumptions")

In the field of science and philosophy, ad hoc means to prevent this theory from becoming a wrong theory by proposing peripheral assumptions about a theory.

Ad-hoc Queries meaning analysis

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.