Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MySQL vs. SQL Server vs. Oracle [closed]

Tags:

sql-server

mysql

oracle

I have always only used MySQL and no other database system.

A question came up at a company meeting today and I was embarrassed I did not know: To a developer, what earth-shaking functionality do MS or Oracle offer that MySQL lacks and which allows MS and Oracle to charge for their systems?

like image 422
KJ Saxena Avatar asked Dec 16 '09 09:12

KJ Saxena

People also ask

Is Oracle killing MySQL?

Oracle is killing MySQL. On purpose. This has been going on for a while, and they're not doing it because they're stupid, it's in their best interests. Thankfully Maria is such a nice clean replacement.

Which is best SQL or MySQL or Oracle?

In terms of software, Oracle is the more powerful one because of its extra features over the basic MySQL. It also supports parallel and distributed Databases and offers better indexing because of which can have a competitive advantage over MySQL.

What is difference between Oracle SQL and MySQL?

MySQL supports full-text and hash indexing only. Oracle uses more indexes than just these, including Bitmap, function-based, Partitioned, and so forth. Oracle is better for enterprise deployments, while MySQL is suited for small to medium scale. MySQL is free, while Oracle requires a licensing fee.

What is the difference between SQL and MySQL or SQL Server?

SQL is a query programming language that manages RDBMS. MySQL is a relational database management system that uses SQL. SQL is primarily used to query and operate database systems. MySQL allows you to handle, store, modify and delete data and store data in an organized way.

1 Answers

I think other commentators are quite right to highlight all of the extra non-core RDBMS abilities that are bundled with the commercial solutions.

Here is a matrix of Oracle editions and features that would be worth browsing just for an understanding of the "extra" features, particularly in the context of what it would cost to develop and support your own version of them (if that is even possible) on a product like MySQL: https://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm#DBLIC116

For example, if you had a requirement that said: "Users shall be able to recover any previous versions of data that they have deleted/updated up to one week after the changes has been committed" then that implies a certain development overhead that I think would be much higher on a system that did not have a built-in feature like oracle's Flashback Query.

like image 98
David Aldridge Avatar answered Sep 20 '22 04:09

David Aldridge
Sign in to Comment

Related questions

How can I fix MySQL error #1064?
RuntimeError with mysql2 and rails3 (bundler)
MySQL ORDER BY IN()
How to select the first row for each group in MySQL?
MySQL SELECT LIKE or REGEXP to match multiple words in one record
Incorrect string value: '\xF0\x9F\x8E\xB6\xF0\x9F...' MySQL
Most efficient way to store IP Address in MySQL [duplicate]
A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1
How to auto-load MySQL on startup on OS X Yosemite / El Capitan
How to convert result table to JSON array in MySQL
How to use MySQL dump from a remote machine
How can I slow down a MySQL dump as to not affect current load on the server?
Last index of a given substring in MySQL
Print the actual query MySQLdb runs?
How to convert MySQL time to UNIX timestamp using PHP?
MySQL select all rows from last month until (now() - 1 month), for comparative purposes
How to select rows where column value IS NOT NULL using CodeIgniter's ActiveRecord?
How can I enable the MySQLi extension in PHP 7?
Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'
#1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!