Catalog

1、Oracle Its own characteristics

1.1、 Complete data management function

1.2、 Products with complete relationships  

1.3、 Distributed processing function

Two 、Oracle Its own advantages ：

3、 ... and 、MySQL Its own characteristics

Four 、 Use the maximum difference

---

1、Oracle Its own characteristics

1.1、 Complete data management function

        1）、 The amount of data ;

        2）、 The persistence of data storage ;

        3）、 Data sharing ;

        4）、 Data reliability ;

1.2、 Products with complete relationships  

        1）、 Information rules --- Relational type DBMS All the information should be logically in one way , That is, the values in the table explicitly represent ;

        2）、 Criteria for ensuring access ;

        3）、 View update criteria --- As long as the data in the table forming the view changes , The data in the corresponding view changes at the same time ;

        4）、 Data physical and logical independence criteria ;

1.3、 Distributed processing function

         ORACLE The database is from the 5 Distributed processing capability has been provided since version , To the first 7 Version has a relatively perfect distributed database function , One ORACLE Distributed database consists of oraclerdbms、sql*Net、SQL*CONNECT And other non ORACLE The composition of relational products .

Two 、Oracle Its own advantages ：

        1）、 High availability ;

        2）、 High scalability ;

        3）、 Strong database security ;

        4）、 Strong stability ;

3、 ... and 、MySQL Its own characteristics

       1）、 Use C and C++ To write , And used a variety of compilers for testing , Ensure the portability of the source code .

    2)、 Support AIX、FreeBSD、HP-UX、Linux、Mac OS、NovellNetware、OpenBSD、OS/2 Wrap、Solaris、Windows And many other operating systems .

    3）、 Provides... For multiple programming languages API. These programming languages include C、C++、Python、Java、Perl、PHP、Eiffel、Ruby and Tcl etc. .

    4)、 Multithreading support , make the best of CPU resources .

    5)、 Optimization of the SQL Query algorithm , Effectively improve query speed .

    6)、 It can be used as a separate application in the client server network environment , It can also be embedded in other software as a library .

    7)、 Provide multilingual support , Common codes like Chinese GB 2312、BIG5, In Japanese Shift_JIS Etc. can be used as data table name and data column name .

    8）、 Provide TCP/IP、ODBC and JDBC And so on .

    9)、 To provide for the management of 、 Check 、 Management tools for optimizing database operation .

  10)、Oracle Large data = library , and MySQL It's a small and medium database . however MySQL It's open source. , however Oracle Is the charge , And it's more expensive .

11)、Oracle It's a huge amount of memory , and mysql A very small

Four 、 Use the maximum difference

1、MySQL Support primary key self growth , Specify that the primary key is auto increment, It grows automatically when it's inserted .Oracle Primary keys generally use sequences .

2、MySQL Strings can be wrapped in double quotes , and Oracle Only single quotation marks are allowed

3、MySQL Pagination limit keyword , and Oracle Use rownum The field indicates the location , And you can only use less than , Can't use greater than .

4、Oracle When dealing with long strings , The length is less than or equal to 4000 Bytes , If you want to insert a longer string , Consider using CLOB type , Before inserting a modification record, you need to modify and The judgment of length , If it is empty , If the length exceeds the return operation processing .（CLOB Types are built-in types , It's usually a column in a row , Some databases also have aliases ）

5、MySQL in 0、1 Judge true or false ,Oracle in true false

7、MySQL The default command is commit, however Oracle Manual submission is required

8、MySQL stay windows The environment is case insensitive stay unix,linux The environment is case sensitive ,Oracle Indistinguishes