A Comparison of Oracle and MySQL for Searchers of Ideal DBMS
COMPARISON OF ORACLE AND MYSQL
FOR SEARCHERS OF IDEAL DBMS
Abstract
Nowadays Database Management System (DBMS) is the important part of many important industries. Databases hold everything from sales, inventory, payroll, accounting, personnel and more. A properly maintained and designed database can give managers insights into trends and information that might Have been otherwise missed. Presently with the large amount of DBMS versions, it is a problem to choose exact and proper database for your requirement. The main reason for my presentation is to help us understand some of the differences between databases and realize that there are some fundamental differences between database implementations. With this paper I want to introduce about differences between two well-known database systems such a MySQL and Oracle. With this paper reader can differentiate two database above with three aspects: security, data type and data storage concepts. Section 2.1, for understand security advantages of two database systems. Section 2.2, with listed data type of two database systems we can differentiate data types. The section 2.3 provide a description of the conceptual differences and similarities in data storage for MySQL and Oracle databases.
Key words: MySQL, Oracle, Database Comparison, Ideal DBMS
1. INTRODUCTION
This paper contains a comparison of Oracle and MySQL databases in the context of selection of a DBMS. First of all I determined what features of DBMS are important from the point of view of a customer which searches for ideal DBMS. From a papers which I read about comparison, I think the following features are important:
Database Security: This section includes information about security issues with MySQL databases and Oracle databases.
Data types: This section lists the difference between MySQL and Oracle data types.
Data storage concepts: This section provide a description of the conceptual differences and similarities in data storage for MySQL
FOR SEARCHERS OF IDEAL DBMS
Abstract
Nowadays Database Management System (DBMS) is the important part of many important industries. Databases hold everything from sales, inventory, payroll, accounting, personnel and more. A properly maintained and designed database can give managers insights into trends and information that might Have been otherwise missed. Presently with the large amount of DBMS versions, it is a problem to choose exact and proper database for your requirement. The main reason for my presentation is to help us understand some of the differences between databases and realize that there are some fundamental differences between database implementations. With this paper I want to introduce about differences between two well-known database systems such a MySQL and Oracle. With this paper reader can differentiate two database above with three aspects: security, data type and data storage concepts. Section 2.1, for understand security advantages of two database systems. Section 2.2, with listed data type of two database systems we can differentiate data types. The section 2.3 provide a description of the conceptual differences and similarities in data storage for MySQL and Oracle databases.
Key words: MySQL, Oracle, Database Comparison, Ideal DBMS
1. INTRODUCTION
This paper contains a comparison of Oracle and MySQL databases in the context of selection of a DBMS. First of all I determined what features of DBMS are important from the point of view of a customer which searches for ideal DBMS. From a papers which I read about comparison, I think the following features are important:
Database Security: This section includes information about security issues with MySQL databases and Oracle databases.
Data types: This section lists the difference between MySQL and Oracle data types.
Data storage concepts: This section provide a description of the conceptual differences and similarities in data storage for MySQL