| Both sides previous revision Previous revision | |
| public:99_annexes:annex-b-terms-and-definitions:s:sql [2026/09/12 17:42] – ↷ Page moved from private:99_annexes:annex-b-terms-and-definitions:s:sql to public:99_annexes:annex-b-terms-and-definitions:s:sql nick_dido | public:99_annexes:annex-b-terms-and-definitions:s:sql [2026/09/12 17:43] (current) – ↷ Links adapted because of a move operation nick_dido |
|---|
| ====== Structured Query Language (SQL) ====== | ====== Structured Query Language (SQL) ====== |
| |
| [[private:99_annexes:annex-b-terms-and-definitions:start|Go up to Terms and Definitions]] | [[public:99_annexes:annex-b-terms-and-definitions:start|Go up to Terms and Definitions]] |
| |
| ===== Discussion ===== | ===== Discussion ===== |
| Structured Query Language (SQL) provides a standard language for defining, querying, manipulating, and controlling data in relational database systems. | Structured Query Language (SQL) provides a standard language for defining, querying, manipulating, and controlling data in relational database systems. |
| |
| SQL supports database schemas, tables, columns, [[private:99_annexes:annex-b-terms-and-definitions:d:datatype| datatypes]], constraints, queries, views, transactions, access control, and stored logic. In architecture work, SQL artifacts express semantic content when table names, column names, constraints, relationships, views, and queries preserve [[private:99_annexes:annex-b-terms-and-definitions:t:traceability|traceability]] to defined domain meaning. | SQL supports database schemas, tables, columns, [[public:99_annexes:annex-b-terms-and-definitions:d:datatype| datatypes]], constraints, queries, views, transactions, access control, and stored logic. In architecture work, SQL artifacts express semantic content when table names, column names, constraints, relationships, views, and queries preserve [[public:99_annexes:annex-b-terms-and-definitions:t:traceability|traceability]] to defined domain meaning. |
| |
| SQL differs from [[private:99_annexes:annex-b-terms-and-definitions:s:schema|schema]]. A schema defines information elements, permitted values, relationships, and constraints within a defined representation context. SQL provides one language for defining and using database schemas in relational database environments. | SQL differs from [[public:99_annexes:annex-b-terms-and-definitions:s:schema|schema]]. A schema defines information elements, permitted values, relationships, and constraints within a defined representation context. SQL provides one language for defining and using database schemas in relational database environments. |
| |
| SQL also differs from [[private:99_annexes:annex-b-terms-and-definitions:s:semantic]]. SQL syntax and database structure do not establish domain meaning on their own. SQL expresses selected semantic content when SQL artifacts trace to a [[private:99_annexes:annex-b-terms-and-definitions:c:conceptual_model|conceptual model]], vocabulary, [[private:99_annexes:annex-b-terms-and-definitions:t:type_system|type system]], rule set, report model, or other authoritative semantic source. | SQL also differs from [[public:99_annexes:annex-b-terms-and-definitions:s:semantic]]. SQL syntax and database structure do not establish domain meaning on their own. SQL expresses selected semantic content when SQL artifacts trace to a [[public:99_annexes:annex-b-terms-and-definitions:c:conceptual_model|conceptual model]], vocabulary, [[public:99_annexes:annex-b-terms-and-definitions:t:type_system|type system]], rule set, report model, or other authoritative semantic source. |
| |
| SQL semantic content includes: | SQL semantic content includes: |