Database Adventures (i) | MySQL is so good, why is anyone using Oracle?

relational databases (relational database Management System), referred to as RDBMS. Speaking of relational databases, we can immediately see the Oracle, MySQL, SQL Server and other databases, these are our common relational database.

The most important feature of a relational database is the term "relational", which preserves the various relationships in the database. So how does this relationship understand? Let's take an example of the school. In the school, we have a teacher (Teacher), students (Student), curriculum (Course) These entities, and these entities have a certain relationship. For example: A teacher can teach multiple students, a student can also be taught by multiple teachers, so the relationship between teachers and students is N-S relationship. Similarly, students and courses are also N, a relationship.

The development course of relational database

In 1979, Larry Ellison developed the first commercial relational database Oracle using assembler and C-language dominance. Nearly 16 years later, the Oracle database ran all the way to become the world's most popular relational database.

In 1989, Microsoft also released a relational database SQL Server, but it is also a fee-based commercial database.

Until 1995, the Swedish company MySQL AB released the first version of the MySQL database, thus terminating the relational database only with Oracle, SQL Server, the myth of these fee-based software.

After the birth of MySQL, because of its open source, free features, so it has been a large number of small and medium-sized users of the support, its user volume growth rapidly. In the meantime, MySQL's owner also a few easy hands. In 2008, Sun acquired MySQL AB and managed the MySQL database. In 2010, Oracle acquired the management of the company by acquiring Sun. On the day Oracle acquired Sun, Michael Widenius, known as the father of MySQL, forked a branch of MySQL and launched the MariaDB project because of fears that the prospect of MySQL would be limited after Oracle's takeover.

Sure enough, shortly after the acquisition, MySQL introduced the relevant fee version. While the original free version is still available, Oracle's effort in MySQL may be limited in the foreseeable future. After all, Oracle is a business company and a breadwinner.

Now we can understand the current mainstream relational database of the birth and development of the general situation, the main can be divided into the following stages:

• 1979, Oracle Database was born
• 1989, SQL Server database was born
• 1995, MySQL database was born

So what's the difference between these relational databases?

What are their respective application scenarios?

The feud between MySQL and Oracle

Speaking of the above three databases, many people have the impression that Oracle is large but difficult to use. MySQL is easy to use and seems to be the best choice. SQL Server is a database with the least sense of presence and is basically in the underachievement state.

From the db-engines.com Web site relational database market share rankings, now the market share is the highest in the Oracle database, MySQL Second, followed by the SQL Server database.

Rankings seem to subvert our daily perceptions, because few people around us use Oracle, but why is the market share so high?

Nothing is impossible,Oracle can take on such a large share of the market because it has an advantage over the processing of massive amounts of data and can provide a complete set of data storage solutions. so in some very large enterprises, these enterprises have huge capital ability, so they will choose money to buy solutions, rather than their own employees use MySQL to maintain. In general, Oracle has the following advantages over MySQL:

• Numerous database features to meet the diverse needs of the enterprise
• The benefits of massive data processing
• A complete set of data solutions

But the drawbacks of Oracle are also obvious: it's expensive.

Because Oracle has these features, Oracle is better suited to those large multinational companies. Because these companies are well funded, they can afford Oracle's expensive costs. On the other hand, the data volumes of these enterprises are also very large, they pay more attention to the security of data and efficient storage, and the problem of concern can be resolved quickly, Oracle provides a series of services just meet their needs.

For some small to medium-sized businesses or individual users, Oracle software is cumbersome on the one hand, and Oracle licensing is expensive on the other, which is unsustainable for them. And their database is not particularly large, so for these users, the use of MySQL has been able to solve their needs. Then there is no need to pay for Oracle's database.

Summarize

If the database performance alone is compared, then Oracle database is undoubtedly number one, amputated MySQL, after all, Oracle is more than 10 years earlier than the birth of MySQL. But many times still have to combine specific use scenes to make the right choice, after all, kill chicken without sledgehammer, can not solve the money, why pay to solve it!

So when you have a large amount of data and you are not short of money yourself, then go straight to Oracle! If the money is limited and the amount of data is small, then use MySQL!

Database Adventures (i) | MySQL is so good, why is anyone using Oracle?