Shulou(Shulou.com)06/01 Report--

This article introduces the relevant knowledge of "what are the different points between MySQL and Oracle". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

Overview:

MySQL is a relational database management system, it is one of the most popular relational database management systems.

Relational databases in MySQL keep data in separate tables rather than putting all the data in one big warehouse, which increases speed and flexibility. MySQL uses SQL, the most commonly standardized language for accessing databases. It uses a dual licensing policy, it is divided into community and commercial versions, it is small, fast, low total cost of ownership, and open source. Loved by many developers.

MySQL database

Oracle Database, also known as Oracle RDBMS, referred to as Oracle. Oracle Database System is a group of software products provided by Oracle Corporation (Oracle) in the United States with distributed database as the core. It is one of the most popular client/server or B/S architecture databases at present. SilverStream is a middleware based on database. Oracle database is the most widely used database management system in the world at present. As a general database system, it has complete data management functions; as a relational database, it is a product of complete relations; as a distributed database, it realizes distributed processing functions, but all its knowledge can be used on various types of machines as long as it learns Oracle knowledge on one type of machine.

Difference between MySQL and Oracle

Memory size: MySQL occupies much less memory after installation than Oracle, and in the database files created later, MySQL file memory is also smaller than Oracle.

Open source or not: MySQL is open source, while Oracle is paid and expensive.

Flexibility: MySQL is far more flexible than Oracle, sql statements can be easily extended, insert can insert multiple rows of data at a time, and Oracle does not support this operation.

Security: MySQL is much less secure than Oracle and is more vulnerable to attack.

Partitioned tables and partitioned indexes: MySQL partitioned tables are not mature and stable;Oracle partitioned tables and partitioned indexes are mature and can improve the user experience of accessing db.

Data saving: MySQL submits sql statements by default, and data loss may occur if problems occur during the update process. Oracle guarantees that all committed transactions can be recovered.

Submission methods vary. MySQL commits automatically by default, while Oracle requires manual commit.

Performance diagnostics. MySQL has few diagnostic tuning methods, while Oracle can implement many diagnostic tuning methods, such as addm, sqltrace, awr, etc.

"What are the differences between MySQL and Oracle?" is introduced here. Thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.