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,...
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...
Data System Architecture
SQL - Statement (Type)

in SQL. Session Control Statements (Alter session, Set Role) System Control Statement (Alter System) Embedded Control Statements (Any DML, DDL or TCL that is integrated into a...



Share this page:
Follow us:
Task Runner