SQL - Query (SELECT)

Data System Architecture

About

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

Equal

Type

Ad-hoc

Ad-hoc queries are query used to explore a data set and are therefore never known in advance.

Reporting

Reporting query are well-known query used to build metrics. See Data Analysis - Reporting Query

To relational algebra

Documentation / Reference





Discover More
Relational Data Model
(Relation|Table) - Tabular data

A Relation is a logical data structure composed of tuple (row) attribute (column, field) The following data structure are a relation: a table, a materialized view (query) (store data) a query,...
GraphQL - Query

A query has the same function as a SQL query for a database but is written in a hierarchical format (ie GraphQL can nest queries, one by node). A GraphQL query is a string interpreted by a server that...
Tez Hive Query Diagnostic
Hive - Query (SELECT)

in Hive. The SQL language of Hive is called hiveql. ...
Data System Architecture
Language Integrated Query (LINQ)

Language-Integrated Query (LINQ) is the name for a set of technologies based on the integration of query capabilities directly into the C# language. LINQ is a functional interface for SQL query. ...
Data System Architecture
Relational Data Modeling

This section is data Modeling applied to a relational structure (mostly table). Relational databases normalize data, removing as much duplication as possible. A relational database’s approach to...
Data System Architecture
Relational Data Modeling - Aggregate Table (Summary Table)

An Aggregate table is a persistence unit of aggregate data. Aggregate tables are also known as summary table (from summary) materialized view A aggregate is a table that contains the result of a query...
Rewrite
SQL - Materialized View

A materialized view is an auxiliary data structure that persist the result of a query in a table format managed by the cache system of the database. The refresh of the data is defined in criteria: ...
Data System Architecture
SQL - Order by

order by is a query clause that will sort the records (row) according to a collation.
Data System Architecture
SQL - Query Performance

The query performance is the of a query. OLTP query are query that comes from an OLTP application. This kind of query retrieve few rows and their performance is generally improved with a index....
Data System Architecture
SQL - Select

SELECT is a keyword of the SQL Language (specifically dml) that permits to read data from the database. A SELECT Statement is called a query. The select statement has three capabilities: projection...



Share this page:
Follow us:
Task Runner