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

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Add topic

Revision as of 11:05, 10 April 2015 edit \chAlx (talk \| contribs) 10 edits →Proper fine grained locking ← Previous edit		Latest revision as of 14:11, 14 January 2025 edit undo WOSlinker (talk \| contribs) Administrators 861,416 edits syntaxhighlight & fix lint
(27 intermediate revisions by 22 users not shown)
Line 1: {{WikiProject ~~Computing~~banner shell\|class=List\| {{WikiProject Computing\|importance=\|software=yes\|software-importance=}} {{~~WPDATABASE\|class~~WikiProject ~~= List~~Databases\|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? == How can MySQL possibly be ACID compliant? Surely it should be marked as "No" under ACID == Line 139 ⟶ 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 148 ⟶ 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 308 ⟶ 314: "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)