Data Analysis - Reporting Query

Data System Architecture


Reporting queries are query:

  • executed periodically
  • to create well-known, pre-defined metrics
  • that will answer questions about the financial and operational health of a system (business).

Although reporting queries tend to be static, minor changes are common. From one use of a given reporting query to the next, a user might choose to shift focus by varying a date range, geographic location or a brand name.


The central difference between reporting queries and ad hoc queries is that there is a high degree of foreknowledge that is available in order to tune the database.

Because this query are very well known in advance, the DBA can optimize the system specifically for these queries to execute them very rapidly by using:

  • data placement methods (e.g. partitioning and clustering)
  • and/or auxiliary data structures (e.g. materialized views and indexes).

See SQL - Query Performance

Discover More
Data System Architecture
Cube - Multi-dimensional query (OLAP query)

An multi-dimensional query is a query that runs against a multi-dimensional structure (ie cube). It is also known as: an OLAP query. a business query multi-dimensional query are analytics query...
Data System Architecture
Data Analysis - ad-hoc queries (exploratory)

An ad-hoc query is a query created on the fly by an analyst in order to answer specific business questions. It's also known as: speed-of-thought analysis Impromptu query This queries are: constructed...
Data System Architecture
SQL - Query (SELECT)

A query is a SQL statement that begins with the SELECT word. A stored query is called a view. The result of a query is stored in a result table, called the result-set. A query is itself a Relations...
Basket Analysis Joke
Web Analytics - Page views (PV)

id The unique ID of the page or screen call itself received_at When the page or screen call was received sent_at When the page or screen call was triggered by the user a collaborative recommandation...

Share this page:
Follow us:
Task Runner