SQL Abstract Syntax Trees Vocabulary

IRI:
http://ns.inria.fr/ast/sql#
Current version:
0.3
Authors:
Corentin Follenfant
Olivier Corby
Other visualisation:
Ontology source

Table of Content

  1. Classes
  2. Object Properties
  3. Data Properties
  4. Annotation Properties
  5. Namespace Declarations

Classes

Access Control Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#AccessControlStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL access control statement.
has super-classes
Statementc
has sub-classes
Grant Statementc, Revoke Statementc

Additionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Plus

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Arithmetic Operatorc

Aggregate Functionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#AggregateFunction

is defined by
http://ns.inria.fr/ast/sql#
A SQL aggregate function returns a single value given the values of multiple rows from a column.
has super-classes
Functionc
has sub-classes
Averagec, Countc, Maximumc, Minimumc, Standard Deviationc, Sumc, Variancec

Aggregation Expressionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#AggregationExpression

is defined by
http://ns.inria.fr/ast/sql#
A SQL aggregation expression consists in the use of an aggregate function.
has super-classes
Expressionc

Aliasc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Alias

is defined by
http://ns.inria.fr/ast/sql#
The SQL AS operator used to give an identifier to an expression.
has super-classes
Operatorc

Allc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#All

is defined by
http://ns.inria.fr/ast/sql#
The SQL '*' wildcard operator, substitutes to all the columns of the tables in the FROM clause.
has super-classes
Operatorc

Alter Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#AlterStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL ALTER statement.
has super-classes
Data Definition Statementc

Arithmetic Operatorc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ArithmeticOperator

is defined by
http://ns.inria.fr/ast/sql#
A SQL arithmetic operator used to perform arithmetic calculation.
has super-classes
Operatorc
has sub-classes
Additionc, Divisionc, Multiplicationc, Negationc, Subtractionc

Averagec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Avg

is defined by
http://ns.inria.fr/ast/sql#
The SQL aggregate function that returns the mean of the given expression.
has super-classes
Aggregate Functionc

Call Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#CallStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL CALL statement.
has super-classes
Procedural Statementc

Case Expressionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#CaseExpression

is defined by
http://ns.inria.fr/ast/sql#
A SQL case expression enables the use of the IF <condition> THEN <consequent> ELSE <alternative> logic within SQL statements.
has super-classes
Expressionc

Castc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Cast

is defined by
http://ns.inria.fr/ast/sql#
A SQL scalar function that converts an expression to a target data type
has super-classes
Data Type Conversion Functionc

Column Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ColumnIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog column.
has super-classes
Database Catalog Object Identifierc

Commit Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#CommitStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL COMMIT statement.
has super-classes
Transaction Management Statementc

Comparison Operatorc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ComparisonOperator

is defined by
http://ns.inria.fr/ast/sql#
A binary operator used to compare two values, and when evaluated returns one of the TRUE / FALSE / UNKNOWN truth values.
has super-classes
Operatorc
has sub-classes
Difference comparisonc, Equality comparisonc, Greater than comparisonc, Greater than or equal to comparisonc, Less than comparisonc, Less than or equal to comparisonc

Concatenationc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Concatenation

is defined by
http://ns.inria.fr/ast/sql#
A SQL concatenation operator that returns the combination of two strings, expressions or values.
has super-classes
String Operatorc

Connect Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ConnectStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL CONNECT statement.
has super-classes
Session Management Statementc

Countc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Count

is defined by
http://ns.inria.fr/ast/sql#
The SQL aggregate function that returns the number of rows or non NULL values from the result set.
has super-classes
Aggregate Functionc

Create Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#CreateStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL CREATE statement.
has super-classes
Data Definition Statementc

Cross Join Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#CrossJoin

is defined by
http://ns.inria.fr/ast/sql#
Join predicate used to perform the cross-product of two tables.
has super-classes
Join Predicatec

Data Definition Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#DataDefinitionStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL data definition statement.
has super-classes
Statementc
has sub-classes
Alter Statementc, Create Statementc, Drop Statementc

Data Manipulation Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#DataManipulationStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL data manipulation statement.
has super-classes
Statementc
has sub-classes
Delete Statementc, Insert Statementc, Select Statementc, Update Statementc

Data Type Conversion Functionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#DataTypeConversionFunction

is defined by
http://ns.inria.fr/ast/sql#
A SQL scalar function.
has super-classes
Scalar Functionc
has sub-classes
Castc

Database Catalog Objectc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#CatalogObject

is defined by
http://ns.inria.fr/ast/sql#
A database catalog object reference.
has super-classes
Generic AST Nodec
has sub-classes
Relational Columnc, Relational Indexc, Relational Procedurec, Relational Rolec, Relational Schemac, Relational Sequencec, Relational Tablec, Relational Userc, Relational Viewc

Database Catalog Object Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ObjectIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A database catalog object identifier, qualified or not.
has super-classes
Generic AST Nodec
has sub-classes
Column Identifierc, Identifierc, Index Identifierc, Procedure Identifierc, Role Identifierc, Schema Identifierc, Table Identifierc, User Identifierc, View Identifierc

Date Time Computation Functionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#DateTimeFunction

is defined by
http://ns.inria.fr/ast/sql#
A SQL date time function returns a date or time value or performs a specific date or time value computation.
has super-classes
Scalar Functionc
has sub-classes
Nowc

Delete Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#DeleteStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL DELETE statement.
has super-classes
Data Manipulation Statementc

Difference comparisonc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#NotEquals

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Comparison Operatorc

Divisionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Div

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Arithmetic Operatorc

Drop Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#DropStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL DROP statement.
has super-classes
Data Definition Statementc

Equality comparisonc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Equals

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Comparison Operatorc

Exclusionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Except

is defined by
http://ns.inria.fr/ast/sql#
A SQL exclusion operator used to return the result set produced by removing the result rows of the second query that appear in the result set of the first query.
has super-classes
Set Operatorc

Exists predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Exists

is defined by
http://ns.inria.fr/ast/sql#
Unary predicate that returns one of the TRUE or FALSE truth values depending on whether the evaluated subquery returns an empty result set.
has super-classes
Predicatec

Expressionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Expression

is defined by
http://ns.inria.fr/ast/sql#
A SQL expression denotes any clause that when evaluated returns values.
has super-classes
Generic AST Nodec
has sub-classes
Aggregation Expressionc, Case Expressionc, Function Expressionc

Full Outer Join Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#FullOuterJoin

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Outer Join Predicatec

Functionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Function

is defined by
http://ns.inria.fr/ast/sql#
A SQL built-in function that performs calculation and returns a value. May be vendor-specific.
has super-classes
Generic AST Nodec
has sub-classes
Aggregate Functionc, Scalar Functionc, Table Functionc

Function Expressionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#FunctionExpression

is defined by
http://ns.inria.fr/ast/sql#
A SQL function expressions consists in the use of any built-in SQL function.
has super-classes
Expressionc

Generic AST Nodec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ASTNode

is defined by
http://ns.inria.fr/ast/sql#
Abstract class subsumed by all AST node classes.
has sub-classes
Database Catalog Objectc, Database Catalog Object Identifierc, Expressionc, Functionc, Operatorc, Predicatec, Statementc
is in domain of
AST Node Argumentsop
is in range of
Clauseop

Grant Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Grant

is defined by
http://ns.inria.fr/ast/sql#
A SQL GRANT statement used to give a set of privileges or roles to specified users that are actionable on specified database objects.
has super-classes
Access Control Statementc

Greater than comparisonc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#GreaterThan

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Comparison Operatorc

Greater than or equal to comparisonc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#GreaterEquals

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Comparison Operatorc

Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#SequenceIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog sequence.
has super-classes
Database Catalog Object Identifierc

Import / Export Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#IOStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL import or export statement.
has super-classes
Statementc

In predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#In

is defined by
http://ns.inria.fr/ast/sql#
Variadic predicate used to assert whether the first provided expression's value is within the set of following provided expressions' values.
has super-classes
Predicatec

Index Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#IndexIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog index.
has super-classes
Database Catalog Object Identifierc

Inner Join Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#InnerJoin

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Join Predicatec

Insert Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#InsertStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL INSERT statement.
has super-classes
Data Manipulation Statementc
is in domain of
VALUES list Clauseop

Intersectionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Intersect

is defined by
http://ns.inria.fr/ast/sql#
A SQL intersection operator used to return the common result rows of the combination of the result sets of two or more queries.
has super-classes
Set Operatorc

Is Null predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#IsNull

is defined by
http://ns.inria.fr/ast/sql#
Unary predicate that compares the evaluated expression's value with NULL
has super-classes
Predicatec

Join Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#JoinPredicate

is defined by
http://ns.inria.fr/ast/sql#
Binary predicate used join two or more tables.
has super-classes
Predicatec
has sub-classes
Cross Join Predicatec, Inner Join Predicatec, Outer Join Predicatec

Left Outer Join Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#LeftOuterJoin

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Outer Join Predicatec

Less than comparisonc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#LessThan

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Comparison Operatorc

Less than or equal to comparisonc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#LessEquals

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Comparison Operatorc

Like predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Like

is defined by
http://ns.inria.fr/ast/sql#
Binary predicate that returns one of the TRUE or FALSE truth values depending on whether the string resulting in the evaluation of the first expression matches the lightweight regular expression described in the second expression.
has super-classes
Predicatec

Lock Table Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#LockTableStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL LOCK TABLE statement.
has super-classes
Transaction Management Statementc

Logical Conjunctionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#And

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Logical Operatorc

Logical Disjunctionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Or

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Logical Operatorc

Logical Negationc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Not

is defined by
http://ns.inria.fr/ast/sql#
A SQL logical negation that can be used to negate any condition.
has super-classes
Logical Operatorc

Logical Operatorc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#LogicalOperator

is defined by
http://ns.inria.fr/ast/sql#
A SQL logical connective used to perform logical calculation.
has super-classes
Operatorc
has sub-classes
Logical Conjunctionc, Logical Disjunctionc, Logical Negationc

Maximumc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Max

is defined by
http://ns.inria.fr/ast/sql#
The SQL aggregate function that returns the maximum value of the given expression.
has super-classes
Aggregate Functionc

Minimumc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Min

is defined by
http://ns.inria.fr/ast/sql#
The SQL aggregate function that returns the minimum value of the given expression.
has super-classes
Aggregate Functionc

Multiplicationc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Mult

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Arithmetic Operatorc

Negationc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Negate

is defined by
http://ns.inria.fr/ast/sql#
A unary arithmetic operator used to produce the negative of its operand.
has super-classes
Arithmetic Operatorc

Nowc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Now

is defined by
http://ns.inria.fr/ast/sql#
A SQL now function is a nullary function that returns the current timestamp.
has super-classes
Date Time Computation Functionc

Number Functionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#NumberFunction

is defined by
http://ns.inria.fr/ast/sql#
A SQL number function that returns a numeric value and reads numeric values or string with numeric characters.
has super-classes
Scalar Functionc

Operatorc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Operator

is defined by
http://ns.inria.fr/ast/sql#
A SQL operator used to perform arithmetic calculations, comparisons or value assignments.
has super-classes
Generic AST Nodec
has sub-classes
Aliasc, Allc, Arithmetic Operatorc, Comparison Operatorc, Logical Operatorc, Set Operatorc, String Operatorc

Outer Join Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#OuterJoin

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Join Predicatec
has sub-classes
Full Outer Join Predicatec, Left Outer Join Predicatec, Right Outer Join Predicatec

Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Predicate

is defined by
http://ns.inria.fr/ast/sql#
Represents a collection of one or more expressions or subqueries, that may be combined with logical operators, and when evaluated returns one of the TRUE / FALSE / UNKNOWN truth values.
has super-classes
Generic AST Nodec
has sub-classes
Exists predicatec, In predicatec, Is Null predicatec, Join Predicatec, Like predicatec, Range predicatec

Procedural Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ProceduralStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL procedural statement.
has super-classes
Statementc
has sub-classes
Call Statementc

Procedure Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ProcedureIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog procedure.
has super-classes
Database Catalog Object Identifierc

Range predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Between

is defined by
http://ns.inria.fr/ast/sql#
Ternary predicate used to assert whether a provided expression's value is within the range specified by two other expressions' values.
has super-classes
Predicatec

Relational Columnc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Column

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog column.
has super-classes
Database Catalog Objectc

Relational Indexc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Index

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog index.
has super-classes
Database Catalog Objectc

Relational Procedurec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Procedure

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog procedure.
has super-classes
Database Catalog Objectc

Relational Rolec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Role

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog role.
has super-classes
Database Catalog Objectc

Relational Schemac back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Schema

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog schema.
has super-classes
Database Catalog Objectc

Relational Sequencec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Sequence

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog sequence.
has super-classes
Database Catalog Objectc

Relational Tablec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Table

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog table.
has super-classes
Database Catalog Objectc
is in range of
INTO target table clauseop

Relational Userc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#User

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog user.
has super-classes
Database Catalog Objectc

Relational Viewc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#View

is defined by
http://ns.inria.fr/ast/sql#
A reference or declarative statement for a catalog view.
has super-classes
Database Catalog Objectc

Revoke Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Revoke

is defined by
http://ns.inria.fr/ast/sql#
A SQL REVOKE statement used to revoke a set of privileges or roles to specified users from specified database objects.
has super-classes
Access Control Statementc

Right Outer Join Predicatec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#RightOuterJoin

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Outer Join Predicatec

Role Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#RoleIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog role.
has super-classes
Database Catalog Object Identifierc

Rollback Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#RollbackStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL ROLLBACK statement.
has super-classes
Transaction Management Statementc

Scalar Functionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ScalarFunction

is defined by
http://ns.inria.fr/ast/sql#
A SQL scalar function returns a single value given the input values. The input value is of a SQL primitive data type.
has super-classes
Functionc
has sub-classes
Data Type Conversion Functionc, Date Time Computation Functionc, Number Functionc

Schema Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#SchemaIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog schema.
has super-classes
Database Catalog Object Identifierc

Select Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#SelectStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL SELECT statement.
has super-classes
Data Manipulation Statementc
is in domain of
GROUP BY clause, HAVING clause, LIMIT clausedp, ORDER BY clause, SELECT clause

Session Management Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#SessionManagementStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL session management statement.
has super-classes
Statementc
has sub-classes
Connect Statementc, Set Statementc

Set Operatorc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#SetOperator

is defined by
http://ns.inria.fr/ast/sql#
A SQL set operator used to perform set operation on the results of two or more queries.
has super-classes
Operatorc
has sub-classes
Exclusionc, Intersectionc, Unionc, Union Allc

Set Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#SetStatement

is defined by
http://ns.inria.fr/ast/sql#
Assigns a value to a session variable identifier.
has super-classes
Session Management Statementc

Standard Deviationc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#StdDev

is defined by
http://ns.inria.fr/ast/sql#
The SQL aggregate function that returns the standard deviation (square root of the variance) of the given expression.
has super-classes
Aggregate Functionc

Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Statement

is defined by
http://ns.inria.fr/ast/sql#
A SQL statement.
has super-classes
Generic AST Nodec
has sub-classes
Access Control Statementc, Data Definition Statementc, Data Manipulation Statementc, Import / Export Statementc, Procedural Statementc, Session Management Statementc, Transaction Management Statementc
is in domain of
Clauseop

String Operatorc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#StringOperator

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Operatorc
has sub-classes
Concatenationc

Subtractionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Minus

is defined by
http://ns.inria.fr/ast/sql#
has super-classes
Arithmetic Operatorc

Sumc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Sum

is defined by
http://ns.inria.fr/ast/sql#
The SQL aggregate function that returns the sum of the given expression.
has super-classes
Aggregate Functionc

Table Functionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#TableFunction

is defined by
http://ns.inria.fr/ast/sql#
A SQL function that returns a virtual table.
has super-classes
Functionc

Table Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#TableIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog table.
has super-classes
Database Catalog Object Identifierc

Transaction Management Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#TransactionManagementStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL transaction management statement.
has super-classes
Statementc
has sub-classes
Commit Statementc, Lock Table Statementc, Rollback Statementc

Unionc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Union

is defined by
http://ns.inria.fr/ast/sql#
A SQL union operator used to return the combination of the result sets of two or more queries.
has super-classes
Set Operatorc

Union Allc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#UnionAll

is defined by
http://ns.inria.fr/ast/sql#
A SQL union operator used to return the combination of the result sets of two or more queries, including duplicate result rows.
has super-classes
Set Operatorc

Update Statementc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#UpdateStatement

is defined by
http://ns.inria.fr/ast/sql#
A SQL UPDATE statement.
has super-classes
Data Manipulation Statementc

User Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#UserIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog user.
has super-classes
Database Catalog Object Identifierc

Variancec back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#Var

is defined by
http://ns.inria.fr/ast/sql#
The SQL aggregate function that returns the variance of the given expression.
has super-classes
Aggregate Functionc

View Identifierc back to ToC or Class ToC

IRI: http://ns.inria.fr/ast/sql#ViewIdentifier

is defined by
http://ns.inria.fr/ast/sql#
A valid identifier for a catalog view.
has super-classes
Database Catalog Object Identifierc

Object Properties

AST Node Argumentsop back to ToC or Object Property ToC

IRI: http://ns.inria.fr/ast/sql#args

The generic predicate used to attach an ordered list of children to any AST node.
has domain
Generic AST Nodec
has range
listc

Clauseop back to ToC or Object Property ToC

IRI: http://ns.inria.fr/ast/sql#clause

is defined by
http://ns.inria.fr/ast/sql#
A SQL clause is a part of a statement.

FROM clauseop back to ToC or Object Property ToC

IRI: http://ns.inria.fr/ast/sql#from

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies the target sources (tables, views, subqueries) of a SELECT statement.
has super-properties
Clauseop
has range
listc

INTO target table clauseop back to ToC or Object Property ToC

IRI: http://ns.inria.fr/ast/sql#into

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies into which table the following values or select statement's result set are to be inserted into.
has super-properties
Clauseop
has range
Relational Tablec

VALUES list Clauseop back to ToC or Object Property ToC

IRI: http://ns.inria.fr/ast/sql#values

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies a list of values or expressions evaluating to values.
has super-properties
Clauseop
has domain
Insert Statementc
has range
listc

Data Properties

LIMIT clausedp back to ToC or Data Property ToC

IRI: http://ns.inria.fr/ast/sql#limit

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that limits the number of records from the result set that should be returned.
has domain
Select Statementc
has range
integer
is also defined as
annotation property

Annotation Properties

GROUP BY clauseap back to ToC or Annotation Property ToC

IRI: http://ns.inria.fr/ast/sql#groupBy

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies the columns whose values will be considered to cluster the result set of selected rows.
has super-properties
Clause
has domain
Select Statementc

HAVING clauseap back to ToC or Annotation Property ToC

IRI: http://ns.inria.fr/ast/sql#having

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies the filtering predicates to apply on the clustered result set resulting of a GROUP BY clause.
has super-properties
Clause
has domain
Select Statementc

LIMIT clauseap back to ToC or Annotation Property ToC

IRI: http://ns.inria.fr/ast/sql#limit

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that limits the number of records from the result set that should be returned.
has super-properties
Clause
is also defined as
data property

ORDER BY clauseap back to ToC or Annotation Property ToC

IRI: http://ns.inria.fr/ast/sql#orderBy

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies how to order the result set's records according to given expressions.
has super-properties
Clause
has domain
Select Statementc

SELECT clauseap back to ToC or Annotation Property ToC

IRI: http://ns.inria.fr/ast/sql#select

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies the projected tables of a SELECT statement.
has super-properties
Clause
has domain
Select Statementc

WHERE clauseap back to ToC or Annotation Property ToC

IRI: http://ns.inria.fr/ast/sql#where

is defined by
http://ns.inria.fr/ast/sql#
The SQL clause that specifies the filtering predicates to apply on the inputs of the FROM clause.
has super-properties
Clause

Namespace Declarations back to ToC

default namespace
http://ns.inria.fr/ast/sql#
ns
http://www.w3.org/2003/06/sw-vocab-status/ns#
owl
http://www.w3.org/2002/07/owl#
rdf
http://www.w3.org/1999/02/22-rdf-syntax-ns#
rdfs
http://www.w3.org/2000/01/rdf-schema#
spinrdf-org
http://spinrdf.org/
sql
http://ns.inria.fr/ast/sql#
terms
http://purl.org/dc/terms/
vann
http://purl.org/vocab/vann/
xsd
http://www.w3.org/2001/XMLSchema#

This HTML document was obtained by processing the OWL ontology source code through LODE, Live OWL Documentation Environment, developed by Silvio Peroni.