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

Revision as of 02:02, 29 February 2016

Revision as of 13:16, 16 April 2016

Line 7:

{{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}}

== 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

== How can MySQL possibly be ACID compliant? Surely it should be marked as "No" under ACID ==

Line 326 ⟶ 322:

: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 ==

Line 336 ⟶ 337:

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=falsefailed}}

Cheers.—[[User:Cyberbot II|<sup style="color:green;font-family:Courier">cyberbot II]]<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]]: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)