SettingsSQL
Advantage Database Server
Advantage Database Server is a relational database management system for small to medium sized businesses by Sybase iAnywhere.
Advantage Database Server is a relational database management system for small to medium sized businesses by Sybase iAnywhere.
Alpha (programming language)
The Alpha language was the original database language developed by Edgar F. Codd, the inventor of the relational database approach.
The Alpha language was the original database language developed by Edgar F. Codd, the inventor of the relational database approach.
Apatar
Apatar is an open source ETL (Extract-Transform-Load) and data integration software application.
Apatar is an open source ETL (Extract-Transform-Load) and data integration software application.
Call Level Interface
The Call Level Interface (CLI) is a software standard defined in ISO/IEC 9075-3:2003.
The Call Level Interface (CLI) is a software standard defined in ISO/IEC 9075-3:2003.
Cardinality (SQL statements)
In SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column (attribute) of a database table.
In SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column (attribute) of a database table.
Check Constraint
A check constraint (also known as table check constraint) is a condition that defines valid data when adding or updating an entry in a table of a relational database.
A check constraint (also known as table check constraint) is a condition that defines valid data when adding or updating an entry in a table of a relational database.
Commit (data management)
In the context of computer science and data management, commit refers to the idea of making a set of tentative changes permanent.
In the context of computer science and data management, commit refers to the idea of making a set of tentative changes permanent.
Common table expressions
A Common Table Expression, or CTE, is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement.
A Common Table Expression, or CTE, is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement.
Condition (SQL)
A relational database management system uses SQL conditions or expressions in WHERE clauses and in HAVING clauses to SELECT subsets of data.
A relational database management system uses SQL conditions or expressions in WHERE clauses and in HAVING clauses to SELECT subsets of data.
Correlated subquery
A correlated sub-queryCorrelated subquery is a term used for specific types of queries in SQL in computer databases.
A correlated sub-queryCorrelated subquery is a term used for specific types of queries in SQL in computer databases.
CUBRID
CUBRID is a comprehensive open source relational database management system (RDBMS) highly optimized for Web applications, especially when complex business services process large amount of data ...
CUBRID is a comprehensive open source relational database management system (RDBMS) highly optimized for Web applications, especially when complex business services process large amount of data ...
Cursor (databases)
Nd technology, a database cursor is a control structure that enables traversal over the records in a database.
Nd technology, a database cursor is a control structure that enables traversal over the records in a database.
Data Control Language
A Data Control Language (DCL) is a computer language and a subset of SQL, used to control access to data in a database.
A Data Control Language (DCL) is a computer language and a subset of SQL, used to control access to data in a database.
Data control language
A data control language is a syntax similar to a computer programming language used to control access to data stored in a database.
A data control language is a syntax similar to a computer programming language used to control access to data stored in a database.
Data Definition Language
A data definition language or data description language is a syntax similar to a computer programming language for defining data structures, especially database schemas.
A data definition language or data description language is a syntax similar to a computer programming language for defining data structures, especially database schemas.
Data Manipulation Language
A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database.
A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database.
Database Console Commands (Transact-SQL)
The Database Console Commands (DBCC) are a series of statements in Transact-SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database.
The Database Console Commands (DBCC) are a series of statements in Transact-SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database.
DbForge Data Compare for Oracle
dbForge Data Compare for Oracle is a software application created by Devart for comparing and synchronizing Oracle databases.
dbForge Data Compare for Oracle is a software application created by Devart for comparing and synchronizing Oracle databases.
DbForge Schema Compare for Oracle
dbForge Schema Compare for Oracle is a software application created by Devart for comparing and synchronizing schemes of Oracle databases.
dbForge Schema Compare for Oracle is a software application created by Devart for comparing and synchronizing schemes of Oracle databases.
DbForge SQL Complete
dbForge SQL Complete is an add-in for SQL Server Management Studio and Visual Studio created by Devart that offers autocompletion and formatting of T-SQL code.
dbForge SQL Complete is an add-in for SQL Server Management Studio and Visual Studio created by Devart that offers autocompletion and formatting of T-SQL code.
DbForge Studio for MySQL
dbForge Studio for MySQL is a software application created by Devart for developing and administrating the popular Relational Database Management System (RDBMS) MySQL.
dbForge Studio for MySQL is a software application created by Devart for developing and administrating the popular Relational Database Management System (RDBMS) MySQL.
Declarative Referential Integrity
Declarative Referential Integrity (DRI) is one of the techniques in the SQL database programming language to ensure data integrity.
Declarative Referential Integrity (DRI) is one of the techniques in the SQL database programming language to ensure data integrity.
Devgems Data Modeler
Devgems Data Modeler is a database design software targeting multiple database systems (MS SQL Server, Firebird, and others).
Devgems Data Modeler is a database design software targeting multiple database systems (MS SQL Server, Firebird, and others).
Embedded SQL
Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline w...
Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline w...
EnterpriseDB
EnterpriseDB is a privately held company that provides enterprise class support for PostgreSQL through its products Postgres Plus Solutions Pack, which is PostgreSQL with extra bundled modules.
EnterpriseDB is a privately held company that provides enterprise class support for PostgreSQL through its products Postgres Plus Solutions Pack, which is PostgreSQL with extra bundled modules.
Foreign key
In the context of relational databases, a foreign key is a referential constraint between two tables.
In the context of relational databases, a foreign key is a referential constraint between two tables.
Hint (SQL)
In various SQL implementations, a hint is an addition to the SQL standard that instructs the database engine on how to execute the query.
In various SQL implementations, a hint is an addition to the SQL standard that instructs the database engine on how to execute the query.
HSQLDB
HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java.
HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java.
Meta-SQL
Meta-SQL Use (with reference to PeopleSoft) Meta-SQL expands to platform-specific SQL substrings, causes another function to be called, or substitutes a value.
Meta-SQL Use (with reference to PeopleSoft) Meta-SQL expands to platform-specific SQL substrings, causes another function to be called, or substitutes a value.
Navicat
Navicat is a series of graphical database management and development software produced by PremiumSoft CyberTech Ltd. for MySQL, Oracle, SQLite and PostgreSQL. It has an Explorer-like graphical u...
Navicat is a series of graphical database management and development software produced by PremiumSoft CyberTech Ltd. for MySQL, Oracle, SQLite and PostgreSQL. It has an Explorer-like graphical u...
Nested SQL
A nested table is a table that is embedded within another table.
A nested table is a table that is embedded within another table.
NVL
In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.
In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.
Object-PL/SQL
Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of usage of the Oracle Corporation's procedural extension language for SQL an...
Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of usage of the Oracle Corporation's procedural extension language for SQL an...
PL/pgSQL
PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL language.
PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL language.
PL/SQL
PL/SQL is Oracle Corporation's procedural extension language for SQL and the Oracle relational database.
PL/SQL is Oracle Corporation's procedural extension language for SQL and the Oracle relational database.
Prepared statement
In database management systems, a prepared statement or parameterized statement is a feature used to execute the same or similar database statements repeatedly with high efficiency.
In database management systems, a prepared statement or parameterized statement is a feature used to execute the same or similar database statements repeatedly with high efficiency.
Pro*C
Pro*C (also known as Pro*C/C++) is an embedded SQL programming language used by Oracle Database database management systems.
Pro*C (also known as Pro*C/C++) is an embedded SQL programming language used by Oracle Database database management systems.
Query optimization
Query optimizatn is a function of many relational database management systems in which multiple query plans for satisfying a query are examined and a good query plan is identified.
Query optimizatn is a function of many relational database management systems in which multiple query plans for satisfying a query are examined and a good query plan is identified.
Query optimizer
The query optimizer is the component of a database management system that attempts to determine the most efficient way to execute a query.
The query optimizer is the component of a database management system that attempts to determine the most efficient way to execute a query.
Query plan
A query plan is an ordered set of steps used to access or modify information in a SQL relational database management system.
A query plan is an ordered set of steps used to access or modify information in a SQL relational database management system.
Rollback (data management)
In database technologies, a rollback is an operation which returns the database to some previous state.
In database technologies, a rollback is an operation which returns the database to some previous state.
Scriptella
Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java.
Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java.
SQL
SQL is a special-purpose programming language designed for managing data in relational database management systems.
SQL is a special-purpose programming language designed for managing data in relational database management systems.
SQL Access Group
The SQL Access Group (SAG) was a group of software companies that was formed in 1989 to define and promote standards for database portability and interoperability.
The SQL Access Group (SAG) was a group of software companies that was formed in 1989 to define and promote standards for database portability and interoperability.
SQL CLR
SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server.
SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server.
SQL PL
SQL PL stands for Structured Query Language Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the IBM DB2 (DB2 UDB Version 7) database system.
SQL PL stands for Structured Query Language Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the IBM DB2 (DB2 UDB Version 7) database system.
SQL Server Agent
The SQL Server Agent is a process which executes SQL jobs and handles other automated tasks.
The SQL Server Agent is a process which executes SQL jobs and handles other automated tasks.
SQL-92
SQL-92 was the third revision of the SQL database query language.
SQL-92 was the third revision of the SQL database query language.
SQL/CLI
The SQL/CLI, or Call-Level Interface, is an extension to the SQL standard is defined in SQL:1999 (based on CLI-95), but also available in later editions such as ISO/IEC 9075-3:2003.
The SQL/CLI, or Call-Level Interface, is an extension to the SQL standard is defined in SQL:1999 (based on CLI-95), but also available in later editions such as ISO/IEC 9075-3:2003.
SQL/JRT
The SQL/JRT, or SQL Routines and Types for the Java Programming Language, extension to the SQL standard is defined by ISO/IEC 9075-13:2003.
The SQL/JRT, or SQL Routines and Types for the Java Programming Language, extension to the SQL standard is defined by ISO/IEC 9075-13:2003.
SQL/MED
The SQL/MED, or Management of External Data, extension to the SQL standard is defined by ISO/IEC 9075-9:2003.
The SQL/MED, or Management of External Data, extension to the SQL standard is defined by ISO/IEC 9075-9:2003.
SQL/OLB
The SQL/OLB, or Object Language Bindings, extension to the SQL standard is defined by ISO/IEC 9075-10:2003.
The SQL/OLB, or Object Language Bindings, extension to the SQL standard is defined by ISO/IEC 9075-10:2003.
SQL/PSM
SQL/PSM stands for Structured Query Language/Persistent Stored Modules, and was developed by the American National Standards Institute (ANSI) as an extension to SQL. It was first adopted in 1996...
SQL/PSM stands for Structured Query Language/Persistent Stored Modules, and was developed by the American National Standards Institute (ANSI) as an extension to SQL. It was first adopted in 1996...
SQL/Schemata
The SQL/Schemata, or Information and Definition Schemas, part to the SQL standard is defined by ISO/IEC 9075-11:2008.
The SQL/Schemata, or Information and Definition Schemas, part to the SQL standard is defined by ISO/IEC 9075-11:2008.
SQL/XML
SQL/XML or XML-Related Specifications is an extension to the Structured Query Language specification, which defines the use of XML in conjunction with SQL. The XML data type is introduced,...
SQL/XML or XML-Related Specifications is an extension to the Structured Query Language specification, which defines the use of XML in conjunction with SQL. The XML data type is introduced,...
SQL:1999
SQL:1999 was the fourth revision of the SQL database query language.
SQL:1999 was the fourth revision of the SQL database query language.
SQL:2003
SQL:2003 is the fifth revision of the SQL database query language.
SQL:2003 is the fifth revision of the SQL database query language.
SQL:2008
SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language.
SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language.
SQL:2011
SQL:2011 or ISO/IEC 9075:2011 is the seventh revision of the ISO and ANSI standard for the SQL database query language.
SQL:2011 or ISO/IEC 9075:2011 is the seventh revision of the ISO and ANSI standard for the SQL database query language.
SQLPro SQL Client
SQLPro is a proprietary, visual database management and development tool for multiple databases.
SQLPro is a proprietary, visual database management and development tool for multiple databases.
Standard Interchange Language
The Standard Interchange Language (SIL) is a data interchange language standard developed by the Food Distribution Retails Systems Group (FDRSG) for the interchange of information between...
The Standard Interchange Language (SIL) is a data interchange language standard developed by the Food Distribution Retails Systems Group (FDRSG) for the interchange of information between...
Table (database)
In relational databases and flat file databases, a table is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizonta...
In relational databases and flat file databases, a table is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizonta...
Transact-SQL
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. SQL, often expanded to Structured Query Language, is a standardized computer language that was originally dev...
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. SQL, often expanded to Structured Query Language, is a standardized computer language that was originally dev...
Truviso
Truviso (pronounced true-VEE-so) is a continuous analytics, venture-backed, startup headquartered in Foster City, California developing and supporting its solution leveraging PostgreSQL, to ...
Truviso (pronounced true-VEE-so) is a continuous analytics, venture-backed, startup headquartered in Foster City, California developing and supporting its solution leveraging PostgreSQL, to ...
User-defined function
A User-Defined Function, or UDF, is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or env...
A User-Defined Function, or UDF, is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or env...
varchar
A varchar or Variable Character Field is a set of character data of indeterminate length.
A varchar or Variable Character Field is a set of character data of indeterminate length.
View (database)
In database theory, a view consists of a stored query accessible as a virtual table in a relational database or a set of documents in a document-oriented database composed of the result set of a...
In database theory, a view consists of a stored query accessible as a virtual table in a relational database or a set of documents in a document-oriented database composed of the result set of a...
Windows Internal Database
Windows Internal Database is a variant of SQL Server Express 2005 that is included with Windows Server 2008 and Windows Server 2008 R2, and is included with other free Microsoft products release...
Windows Internal Database is a variant of SQL Server Express 2005 that is included with Windows Server 2008 and Windows Server 2008 R2, and is included with other free Microsoft products release...
WQL
Windows Management Instrumentation Query Language (WQL) is Microsoft's implementation of the CIM Query Language (CQL), a query language for the Common Information Model standard from the Distrib...
Windows Management Instrumentation Query Language (WQL) is Microsoft's implementation of the CIM Query Language (CQL), a query language for the Common Information Model standard from the Distrib...
XLeratorDB
XLeratorDB is a suite of database function libraries that enable Microsoft SQL Server to perform a wide range of additional (non-native) business intelligence and ad hoc analytics.
XLeratorDB is a suite of database function libraries that enable Microsoft SQL Server to perform a wide range of additional (non-native) business intelligence and ad hoc analytics.
XSQL
XSQL combines the power of XML and SQL to provide a language and database independent means to store and retrieve SQL queries and their results.
XSQL combines the power of XML and SQL to provide a language and database independent means to store and retrieve SQL queries and their results.