Comparison of relational database management systems: Difference between revisions

Revision as of 08:17, 23 October 2024

Revision as of 22:33, 23 October 2024

Line 4,502:

|-

! style="width:16em" |

! [[Data Domain___domain]]

! [[Cursor (databases)|Cursor]]

! [[Database trigger|Trigger]]

! [[Function (computer programming)|Function]]&nbsp;<sup id="other_1_back">[[#other 1|1]]</sup>

! [[Subroutine|Procedure]]&nbsp;^{[[#other 1|1]]}

! External routine&nbsp;^{[[#other 1|1]]}

|-

! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]

Line 4,553:

| {{yes}}

| {{yes}}

| {{yes}}&nbsp;<sup id="other_2_back">[[#other 2|2]]</sup>

| {{yes}}&nbsp;^{[[#other 2|2]]}

| {{yes}}&nbsp;^{[[#other 2|2]]}

|-

! style="text-align:left" | [[Clustrix]]DB

Line 4,570:

| {{yes}}

| {{yes}}

| {{yes}}&nbsp;^{[[#other 2|2]]}

| {{yes}}

|-

Line 4,616:

| {{yes}}

| {{no}}

| {{yes}}&nbsp;^{[[#other 2|2]]}

| {{yes}}&nbsp;^{[[#other 2|2]]}

| {{yes}}&nbsp;^{[[#other 2|2]]}

| {{yes}}

|-

Line 4,657:

| {{yes}}

| {{no}}

| {{yes}}&nbsp;^{[[#other 2|2]]}

| {{yes}}&nbsp;^{[[#other 2|2]]}

| {{yes}}&nbsp;^{[[#other 2|2]]}

|-

! style="text-align:left" | [[MariaDB]]

| {{yes}}<ref name="constraint_in_mariadb">{{Cite web |url=https://mariadb.com/kb/en/library/constraint/#check-constraints |title=CONSTRAINTConstraint |website=mariadb.com}}</ref>

| {{yes}}

| {{yes}}

Line 4,838:

|-

! |

! [[Data Domain___domain]]

! [[Cursor (databases)|Cursor]]

! [[Database trigger|Trigger]]

! [[Function (computer programming)|Function]]&nbsp;<sup id="other_1_back">[[#other 1|1]]</sup>

! [[Subroutine|Procedure]]&nbsp;^{[[#other 1|1]]}

! External routine&nbsp;^{[[#other 1|1]]}

|}

* <cite id="other_1">[[#other 1 back|Note (1):]]</cite> Both '''function''' and '''procedure''' refer to internal routines written in SQL and/or procedural language like [[PL/SQL]]. '''External routine''' refers to the one written in the host languages, such as C, Java, Cobol, etc. "[[Stored procedure]]" is a commonly used term for these routine types. However, its definition varies between different database vendors.