Content deleted Content added
→Fundamental features: ref c/e |
Filled in 4 bare reference(s) with reFill 2 | Cleaned up using AutoEd |
||
Line 182:
| 2021-10-21
| {{free|[[BSD license|BSD]]}}
| {{Yes}}<ref>
|-
! [[H2 (DBMS)|H2]]
Line 1,638:
| {{yes}}<ref>{{Cite web|url=https://help.sap.com/viewer/e38b2f6217f24bdb90a3ff8ae57b1dd5/17.0/en-US/3bf0656e6c5f1014bb32fe2f7ce00302.html|title=SAP Help Portal|website=help.sap.com}}</ref>
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[HTTP|HTTP(S)]] (REST & SOAP)<ref>
| {{Yes}}
|-
Line 2,458:
! [[Materialized view]]
|}
* <cite id="tb_1">[[#tb 1 back|Note (1):]]</cite> Server provides tempdb, which can be used for public and private (for the session) temp tables.<ref>{{Citation
| url = http://sybooks.sybase.com/onlinebooks/group-as/asg1250e/sag/@Generic__BookTextView/3225;
Line 3,244 ⟶ 3,243:
! Duplicate index prevention
|}
* <cite id="idx_1">[[#idx 1 back|Note (1):]]</cite> The users need to use a function from freeAdhocUDF library or similar.<ref>{{Citation
| url = http://www.udf.adhoc-data.de/index_eng.html
Line 3,986 ⟶ 3,984:
|}
* <cite id="capa_1">[[#capa 1 back|Note (1):]]</cite> Recursive CTEs introduced in 11gR2 supersedes similar construct called CONNECT BY.
Line 4,848 ⟶ 4,845:
! External routine <sup>[[#other 1|1]]</sup>
|}
* <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.
* <cite id="other_2">[[#other 2 back|Note (2):]]</cite> In Derby, H2, LucidDB, and CUBRID, users code '''functions''' and '''procedures''' in Java.
Line 5,628 ⟶ 5,624:
! [[Attribute-based access control|Attribute-Based Access Control (ABAC)]]
|}
* <cite id="ac_1">[[Comparison of relational database management systems#ac 1|Note (1):]]</cite> Network traffic could be transmitted in a secure way (not clear-text, in general SSL encryption). Precise if option is default, included option or an extra modules to buy.
* <cite id="ac_2">[[Comparison of relational database management systems#ac 2|Note (2):]]</cite> Options are present to set a minimum size for password, respect complexity like presence of numbers or special characters.
| |||