Talk:Comparison of relational database management systems: Difference between revisions

Revision as of 17:42, 11 August 2017

Latest revision as of 14:11, 14 January 2025

(12 intermediate revisions by 11 users not shown)

Line 1:

{{WikiProject Computingbanner shell|class=List|
{{WikiProject Computing|importance=|software=yes|software-importance=}}

{{WPDATABASE|classWikiProject = ListDatabases|importance = High}}

}}

{{ archive box |

* [[/Archive 2005]]

Line 6 ⟶ 8:

}}

{{User:WildBot/m04|sect={{User:WildBot/m03|1|Comparison of relational database management systems#fn 2|2|#fn 2}}, {{User:WildBot/m03|1|Comparison of relational database management systems#idx 10 back|Note (10):|#idx 10 back}}, {{User:WildBot/m03|1|Comparison of relational database management systems#idx 11 back|Note (11):|#idx 11 back}}|m04}}

== Programming languages of the implementations? ==

What about adding a mention of the programming language(s) that each DBMS implementation uses?

Line 140 ⟶ 145:

----

The assertion that the maximum row size in Oracle is 8KB is also incorrect. While it does not appear in a document, at least as of version 10.2 of Oracle, the row size can easily exceed 8KB. For example, this is perfectly valid:

<syntaxhighlight lang="sql">

<code>

CREATE TABLE BLEAH (

A1 CHAR(2000 BYTE),

Line 149 ⟶ 154:

A6 CHAR(2000 BYTE),

A7 CHAR(2000 BYTE));

</syntaxhighlight>

</code>

This example can be extended to the full 1000 column limit to create a table with a physical row length of 2000000 bytes. So, while the row length limit is not apparently documented, it is definitely not 8K.

Line 312 ⟶ 317:

== Edit Request ==

{{request edit COI|answered=yes}}

Hello, I have a conflict of interest for this article because I am being paid by [[NuoDB]] to help them add information. We would like to add NuoDB’s data to the following sections: Operating system support, Fundamental features, Limits, Tables and view, Indices, Database capabilities, Data types, Other objects, Partitioning, and Access control. I understand that I am not supposed to edit articles where I have a COI, so I’m asking for someone to do it for me. I have all the data and can provide it to any editor willing to add it for me. [[User:Bcooper87|Bcooper87]] ([[User talk:Bcooper87|talk]]) 13:56, 28 May 2015 (UTC)

Line 339 ⟶ 344:

{{sourcecheck|checked=failed}}

Cheers.—[[User:Cyberbot II|<sup style="color:green;font-family:Courier">cyberbot II</sup>]]<small><sub style="margin-left:-14.9ex;color:green;font-family:Comic Sans MS">[[User talk:Cyberbot II|<span style="color:green">Talk to my owner</span>]]:Online</sub></small> 02:02, 29 February 2016 (UTC)

==Referential integrity MySQL and MariaDB==

Line 356 ⟶ 361:

I can't locate MongoDB in here - but it's quite popular.--[[Special:Contributions/185.67.228.2|185.67.228.2]] ([[User talk:185.67.228.2|talk]]) 15:03, 12 April 2017 (UTC)

:: I would also like Sybase and Vertica added...maybe popular enough? :) [[User:Rogerdpack|Rogerdpack]] ([[User talk:Rogerdpack|talk]]) 17:00, 5 May 2021 (UTC)

== External links modified ==

Line 370 ⟶ 376:

Cheers.—[[User:InternetArchiveBot|'''<span style="color:darkgrey;font-family:monospace">InternetArchiveBot</span>''']] <span style="color:green;font-family:Rockwell">([[User talk:InternetArchiveBot|Report bug]])</span> 17:42, 11 August 2017 (UTC)

== No "Fundamental Features" for Filemaker ==

Why is Filemaker listed under all the tables except for fundamental features? I checked going back to 2011 and it has apparently never been listed. I don't know it myself (it's why I came to the article), but someone ought to fill it in. [[User:KarlM|KarlM]] ([[User talk:KarlM|talk]]) 07:26, 7 March 2018 (UTC)

== Puropse of "Database capabilities" table? ==

This table makes me a bit confused as it seems to combine pure SQL syntax/functionality and optimization techniques. Or am I completely wrong here? AFAIK the MERGE JOIN is nothing but a dbms optimization trick to perform better, or does it have its own SQL syntax and a different result (different than regular JOIN)?

And doesn't parallel queries fall into the same category?

I'd prefer two separate tables, one for pure SQL functionality (INNER/OUTER JOIN, UNION, INTERSECT etc.), and another table for underlaying dbms performance functionality. <!-- Template:Unsigned IP --><small class="autosigned">—&nbsp;Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/94.234.39.197|94.234.39.197]] ([[User talk:94.234.39.197#top|talk]]) 09:41, 31 July 2020 (UTC)</small> <!--Autosigned by SineBot-->

:That makes a lot of sense. [[User:Dorset100|Dorset100]] ([[User talk:Dorset100|talk]]) 10:15, 31 July 2020 (UTC)

== Color for license column? ==

Can someone eXplain the choice of background color in the license column? I find it quite irritating to see proprietary licenses, GPL, and public ___domain use the same shade of purple. What does it mean? --[[Special:Contributions/2A02:8109:9AC0:1E40:AC4B:F238:F73:D435|2A02:8109:9AC0:1E40:AC4B:F238:F73:D435]] ([[User talk:2A02:8109:9AC0:1E40:AC4B:F238:F73:D435|talk]]) 12:09, 1 April 2021 (UTC)

== How do you find the template that gives "cite web" script warning? ==

"Script warning: One or more { {cite web} } templates have errors;"

But there is a bunch of cite web-templates, and I did not find any with an obvious error. [[User:Emilsteen|Emilsteen]] ([[User talk:Emilsteen|talk]]) 19:28, 12 December 2024 (UTC)