In order to facilitate everyone's learning, I will release database information in this post, and I hope to get relevant knowledge from it.
In addition, please don't bill it, thank you for your cooperation!
database
Developing database applications, choose a good database is very important. SQL Server and Oracle, DB2 are compared from some aspects, and some references are available for you to select the database.
Openness
SQL Server
It can only be run on Windows, without the openness of openness, the stability of the operating system's system is important to the database. The Windows9x series products are biased on desktop applications, and NT Server is only suitable for small and medium-sized businesses. And the reliability, security and scalability of the Windows platform are very limited. It is not like UNIX, especially when dealing with key services in processing large data.
Oracle
Can run on all mainstream platforms (including Windows). Fully support all industrial standards. Using a fully open policy. You can make customers choose the most suitable solution. Find support for developers.
DBZ
Can run on all mainstream platforms (including Windows). Ultimate to massive data. DB2 is the most extensive application in enterprise-class applications, almost 85% of the world's largest enterprises, with DB2 database servers, while domestic to 97 years accounts for 5%.
Scalability, parallelism
SQL Server
Parallel implementation and coexistence models are not mature. It is difficult to handle increasing number of users and data volumes. Smalllability is limited. Oracle
The parallel server delivers high availability and high scalability clusters by sharing a set of nodes to share WINDOW NT capabilities. If WindowsNT does not meet the needs, the user can move the database into UNIX.
DB2
DB2 has good parallelism. DB2 expands database management to parallel, multi-node environments. The database partition is part of the database, including your own data, index, profile, and transaction logs. Database partitions are sometimes referred to as nodes or database nodes.
safety
SQL Server
No security certificate is obtained.
Oracle Server
Get the highest certification level ISO standard certification.
DB2
Get the highest certification level ISO standard certification.
performance
SQL Server
Multi-user performance is poor
Oracle
The highest performance, keeps TPC-D and TPC-C under Windows.
DB2
Suitable for data warehouses and online processing, high performance. Client support and application mode.
SQL Server
C / S structure, only support Windows customers, you can connect with ADO, DAO, OLEDB, ODBC.
Oracle
Multi-level network computing, supporting a variety of industrial standards, can be connected with network clients such as ODBC, JDBC, OCI.
DB2
Cross-platform, multi-layer structure, support ODBC, JDBC and other customers.
Easy to operate
SQL Server
Simple operation, but only the graphical interface.
Oracle
More complicated, also providing the GUI and command lines, the same operations in Windows NT and UNIX.
DB2
Simple operation, but also provide the GUI and command line, the same operation is available under Windows NT and UNIX.
Risk
SQL Server
The code completely rewritten has experienced long-term testing, continuous delays, and many functions take time to prove. It is not very compatible with early products. Use needs to take a risk.
Oracle
Long-term development experience is fully compatible. Get a wide range of applications. There is no risk at all.
DB2
Giant businesses have been widely used, which is compatible downward. low risk.
