Talk:Comparison of relational database management systems: Difference between revisions
Content deleted Content added
m Signing comment by 193.127.207.152 - "I had to remove Native Replication API as no one stepped up to provide a single reference." |
syntaxhighlight & fix lint |
||
| (42 intermediate revisions by 31 users not shown) | |||
Line 1:
{{WikiProject
{{WikiProject Computing|importance=|software=yes|software-importance=}} {{
}}
{{ 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?
== How can MySQL possibly be ACID compliant? Surely it should be marked as "No" under ACID ==
Line 20 ⟶ 26:
:Anyway, InnoDB is not ACID compliant, the problem is *some* engines listed for MySQL are said to be ACID compliant (like they said InnoDB is ...) and I have no information to confirm that. Sure thing is, the word should be spread that InnoDB is not 'C' compliant, including on this page . // This brings the question of how this list was compiled and how many others aren't actually ACID compliant.[[User:Yourbane|Yourbane]] ([[User talk:Yourbane|talk]]) 10:23, 23 August 2011 (UTC)
:: How many are or are not strictly ACID compliant is an excellent question, but also a lot of work to figure out. The bold course would seem to change them all to "unknown" then change them to something that can be backed up with a reference, and keep out the changes that aren't checkable. ACID is a hot buzzword (and subject to ill-informed fanboiism in certain quarters) but all the same important enough to get it correct. Also, I support the notion that this is not a place for loose interpretations. ACID is much less useful if you only get it if you contort yourself. The only approach that makes having it useful is to make it strictly the default then optionally allow for carefully loosening the requirements for speed; the SQL standard supports this. Doing it the other way just doesn't make sense, unless you believe in the awesome power of "your mileage may vary". <span style="font-size: smaller;" class="autosigned">— Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/84.86.176.163|84.86.176.163]] ([[User talk:84.86.176.163|talk]]) 12:50, 9 February 2012 (UTC)</span><!-- Template:Unsigned IP --> <!--Autosigned by SineBot-->
== Someone needs to add information about FileMaker Pro. ==
Line 34 ⟶ 42:
This page definitely needs an overview of which transaction types the databases support. For many applications, it is important that you can start a transaction, make 100 select queries over a period of 10 minutes, and know that the first and last query will deliver the same result if they're identical, even if the database is being used and written to by other users in the same time period. It's needed because that's the only way you can make correct multi-query reports from production databases. For instance, Microsoft SQL Server 2000 doesn't support this. Also, it would be interesting to know what the default transaction type is - because that's typically the one that people use.[[Special:Contributions/87.63.152.70|87.63.152.70]] ([[User talk:87.63.152.70|talk]]) 06:48, 1 May 2008 (UTC)
: I don't see the point you're trying to make, but this sounds like ACID 'C' and there is a whole column for that, even if it's filled with random values apparently (...)[[User:Yourbane|Yourbane]] ([[User talk:Yourbane|talk]]) 10:24, 23 August 2011 (UTC)
: A agree that a section with a detailed ACID break-down is necessary. Pessimistic vs. optimistic concurrency, distributed transaction support, isolation level support, level of durability. This is one of the most difficult aspects of DBMS implementation and is one of the most important when comparing. --[[Special:Contributions/66.43.16.227|66.43.16.227]] ([[User talk:66.43.16.227|talk]]) 19:09, 15 November 2012 (UTC)
== Tables and views ==
Line 136 ⟶ 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">
CREATE TABLE BLEAH (
A1 CHAR(2000 BYTE),
Line 145 ⟶ 154:
A6 CHAR(2000 BYTE),
A7 CHAR(2000 BYTE));
</syntaxhighlight>
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 176 ⟶ 185:
==Tidying up the Comparison==
To adhere to Wikipedia policy, this comparison needs to include entries that have an article, and not include lists of external links. See for example [[Wikipedia:WTAF]] and [[Wikipedia:External links]]. [[User:Greenman|Greenman]] ([[User talk:Greenman|talk]]) 12:34, 4 February 2010 (UTC)
FEATURE TABLE USE OF NON-STD FOOTNOTES
The Features table uses a confusing combination of standard (Wikipedia) footnotes and non-standard notes. I was going to add a web reference to the SQLite API, but edit PREVIEW the Wikipedia assigned footnote number was NOT the "NOTE" number at the bottom of the table.
BTW, the reference to the SQLite API is: http://sqlite.org/cintro.html
It wasn't strictly necessary for understanding to footnote the SQLite API (except to prevent it from being deleted), however the footnote glitch prevented me from listing GUI's that are specifically designed to work with SQLite, but that are only available at URLs other than sqlite.org.
GUIs for SQLite links:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
[[User:Jim.Callahan,Orlando|Jim.Callahan,Orlando]] ([[User talk:Jim.Callahan,Orlando|talk]]) 15:59, 19 September 2013 (UTC)
Can someone show what 'Shadow' partitioning is? It is a heading in the '''Partitioning''' table, but only [[Firebird]] and [[InterBase]] support it. Since these have a common origin, this would seem to be a platform-specific term. 'Shadow partitioning' is not mentioned in the [[Partition_(database)|Partitioning]] article, and I have not come across it in any RDBMS platform I have used. I suggest deleting this column. [[Special:Contributions/80.194.100.111|80.194.100.111]] ([[User talk:80.194.100.111|talk]]) 16:17, 21 September 2010 (UTC)
Line 187 ⟶ 204:
:Could you add a reference? It seems like [[Drizzle (database server)|Drizzle]] supports [[Referential integrity]] and there is a table comparison for it.
=== Referential Integrity isn't '''the''' key ===
Some RDBMS, e.g. MySQL/MariaDB, have DB engines which maintain referential integrity, and some which don't. Claiming that they offer 'partial' support is misleading. They give you the choice of ACID conformance, when you need it, as well as offering options that don't incur the overhead. Open source is all about choice... <span style="font-size: smaller;" class="autosigned">— Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/75.73.1.89|75.73.1.89]] ([[User talk:75.73.1.89|talk]]) 15:32, 4 October 2014 (UTC)</span><!-- Template:Unsigned IP --> <!--Autosigned by SineBot-->
== "Free" licensed versions of proprietary products not handled well ==
Line 256 ⟶ 277:
Would someone help me filling what databases have proper fine grained locking? <span style="font-size: smaller;" class="autosigned">— Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/193.127.207.152|193.127.207.152]] ([[User talk:193.127.207.152|talk]]) 10:12, 5 October 2011 (UTC)</span><!-- Template:Unsigned IP --> <!--Autosigned by SineBot-->
: A lot of databases are not ''locking'' but ''versioning''. They has no 'fine-grained' locking because their only locks are (rarely) used for concurrent updates of one row by two+ transactions. These are Interbase-family (Informix, Firebird, Yaffi), PostgreSQL etc. Even MsSQL has an option for snapshots. So this 'fine' locking is not a self-sufficient feature but an option for locking databases only. [[User:\chAlx|\chAlx]] ([[User talk:\chAlx|talk]]) 11:04, 10 April 2015 (UTC)
== Forks ==
Line 262 ⟶ 285:
Should we keep forks in the comparison that have the same features? <span style="font-size: smaller;" class="autosigned">— Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/193.127.207.152|193.127.207.152]] ([[User talk:193.127.207.152|talk]]) 10:35, 5 October 2011 (UTC)</span><!-- Template:Unsigned IP --> <!--Autosigned by SineBot-->
== Please categorize by serverless/client-server/etc. ==
I think that it this article would be a lot more useful if it would also categorize database management systems by whether they use a client/server model or are serverless, or any other kinds of IPC (Inter-Process Communication) that they use. For example this makes a big difference between MySQL and SQLite. I added the stub category "Category:Database management systems by process model". I also [[Wikipedia:Requested_articles/Applied_arts_and_sciences/Computer_science,_computing,_and_Internet#Databases|requested an article]] for "List of serverless database management systems". It would be helpful to programmers and readers to have a list of serverless database management systems here in the comparison groupings and/or in a separate article, and the DBMS's should be categorized as such.
== [[Multiversion concurrency control]] ==
Some databases like [[Apache Derby]] do not support [[Multiversion concurrency control]]<ref>[https://issues.apache.org/jira/browse/DERBY-4823 #DERBY-4823 multi-version concurrency control support - ASF JIRA]</ref>
Should we add this feature to the comparison? Where should it be added? <span style="font-size: smaller;" class="autosigned">— Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/85.53.50.115|85.53.50.115]] ([[User talk:85.53.50.115|talk]]) 12:28, 25 May 2012 (UTC)</span><!-- Template:Unsigned IP --> <!--Autosigned by SineBot-->
== LibreOffice and OpenOffice Base ==
Is Base considered a relational database?, if so it could be added to comparision [[User:Jonpatterns|Jonpatterns]] ([[User talk:Jonpatterns|talk]]) 10:43, 12 May 2013 (UTC)
:I can now answer my own question, the default database backend for LibreOffice is [[HSQLDB]], with is compared here. [[User:Jonpatterns|Jonpatterns]] ([[User talk:Jonpatterns|talk]]) 14:09, 17 May 2013 (UTC)
== Percona Server ==
As a currently-popular choice, I wish that this article covered the MySQL fork "Percona Server".
[[User:Doctorgage|Doctorgage]] ([[User talk:Doctorgage|talk]]) 00:07, 19 September 2013 (UTC)
== Delete old (SaaS) databases? ==
If unmaintained but not [[SaaS]], I guess not (disagree?). However for Saas as [[Xeround Cloud Database]] that planned to shut down by now even for paying customers I guess (if really gone). [[User:Comp.arch|comp.arch]] ([[User talk:Comp.arch|talk]]) 15:13, 26 February 2014 (UTC)
== Review section ==
"Postgres lacks off-the-shelf cross-database functionality that MySQL has". Now that PostgreSQL has foreign-data-wrappers, I'm not sure this is true, but I'm not familiar with all the issues there. [[User:Comp.arch|comp.arch]] ([[User talk:Comp.arch|talk]]) 13:52, 14 April 2014 (UTC)
== Edit 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)
:Thank you for being transparent about your conflict of interest! What is the name of [[NuoDB]]'s product? In general, a person, product or organization added to a list should have a pre-existing article before being added to most lists. For example, all of the entries in [[Comparison of relational database management systems]] link to pre-existing product articles, not company articles. If you think that NuoDB's product qualifies for a separate, stand-alone article according to Wikipedia's [[WP:Notability|notability]] guideline, I suggest you write a [[Help:Userspace draft|userspace draft]]. You can then ask someone to review it through [[Wikipedia:Feedback]], the [[WP:IRC|live help channel]], or [[WP:AFC|Articles for creation]]. Note that the creation of article drafts by, or on behalf of, article subjects is regarded by some Wikipedians as controversial and unethical. The draft should aim for neutrality, but there's no guarantee it will be used. Nor should it be incorporated into Wikipedia without sufficient review from a variety of editors in proportion to its scope and contentiousness. Any draft may be rigorously edited to conform with our policies. --[[User:Dodi 8238|Dodi 8238]] ([[User talk:Dodi 8238|talk]]) 14:59, 28 May 2015 (UTC)
::Thanks, I've put the information for the requested edit into my sandbox https://en.wikipedia.org/wiki/User:Bcooper87/sandbox [[User:Bcooper87|Bcooper87]] ([[User talk:Bcooper87|talk]]) 16:00, 10 June 2015 (UTC)
{{help me-helped}}
Hi! I am wondering if someone can help me with this request. Thank you![[User:Bcooper87|Bcooper87]] ([[User talk:Bcooper87|talk]]) 16:10, 23 July 2015 (UTC)
:I don't see that we have an article on the product, as opposed to the company. I don't see any [[WP:RS|reliable sources]] for the information you want to add, much less [[WP:Independent sources|inndependent]] ones. [[User:Huon|Huon]] ([[User talk:Huon|talk]]) 17:33, 23 July 2015 (UTC)
== Why Oracle is marked as ACID compliant?==
It doesn't provide ANSI SERIALIZABLE isolation level (allows non-serializable executions). So, it lacks full transaction isolation. Or, if ACID actually means nothing these days, why not just remove its line?
This is the citation from this wiki (https://en.wikipedia.org/wiki/Snapshot_isolation): "Snapshot isolation is called "serializable" mode in Oracle..."
[[Special:Contributions/176.194.72.92|176.194.72.92]] ([[User talk:176.194.72.92|talk]]) 01:26, 18 October 2015 (UTC) anonymous
== External links modified ==
Hello fellow Wikipedians,
I have just added archive links to {{plural:1|one external link|1 external links}} on [[Comparison of relational database management systems]]. Please take a moment to review [https://en.wikipedia.org/w/index.php?diff=prev&oldid=707472656 my edit]. If necessary, add {{tlx|cbignore}} after the link to keep me from modifying it. Alternatively, you can add {{tlx|nobots|deny{{=}}InternetArchiveBot}} to keep me off the page altogether. I made the following changes:
*Added archive {newarchive} to http://atc.altibase.com/sub09/611b/html/GeneralReference/ch01s01s01.html
When you have finished reviewing my changes, please set the ''checked'' parameter below to '''true''' or '''failed''' to let others know (documentation at {{tlx|Sourcecheck}}).
{{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==
In the table referential integrity for MySQL is yes and for MariaDB is partial. However, they both have the same limited note: "For other [than InnoDB] storage engines, MySQL Server parses and ignores the FOREIGN KEY and REFERENCES syntax in CREATE TABLE statements. The CHECK clause is parsed but ignored by all storage engines." Perhaps this is a mistake and they are both partial? [[User:Jonpatterns|Jonpatterns]] ([[User talk:Jonpatterns|talk]]) 13:16, 16 April 2016 (UTC)
==Max Row size on Limits table==
Max Row size on Limits table would be better is values are listed in kb as the lowest unit - to make comparison easier. [[User:Jonpatterns|Jonpatterns]] ([[User talk:Jonpatterns|talk]]) 13:16, 16 April 2016 (UTC)
{{reflist-talk}}
== Improve SAP HANA related technical details ==
SAP HANA information is completely missing. I added some information. Does anyone know more details about HANA? Feel free to add more details if you have any information. <small><span class="autosigned">— Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[User:Stvw80|Stvw80]] ([[User talk:Stvw80|talk]] • [[Special:Contributions/Stvw80|contribs]]) 05:11, 17 June 2016 (UTC)</span></small><!-- Template:Unsigned --> <!--Autosigned by SineBot-->
== Missing Databases ==
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 ==
Hello fellow Wikipedians,
I have just modified one external link on [[Comparison of relational database management systems]]. Please take a moment to review [https://en.wikipedia.org/w/index.php?diff=prev&oldid=795049624 my edit]. If you have any questions, or need the bot to ignore the links, or the page altogether, please visit [[User:Cyberpower678/FaQs#InternetArchiveBot|this simple FaQ]] for additional information. I made the following changes:
*Added {{tlx|dead link}} tag to http://sybooks.sybase.com/onlinebooks/group-as/asg1250e/sag/%40Generic__BookTextView/3225%3B
*Added archive https://web.archive.org/web/20060423094210/http://pure.rednoize.com/archives/13/ to http://pure.rednoize.com/archives/13/
When you have finished reviewing my changes, you may follow the instructions on the template below to fix any issues with the URLs.
{{sourcecheck|checked=false|needhelp=}}
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">— 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)
| |||