SQL Server runs only on windows, without the slightest opening, stable operating system for the database is very important. Windows9X series is the emphasis on desktop applications, NT server is only suitable for small and medium texa tonka lanes enterprises. And windows platform reliability, security and scalability is very limited. It is not as proven as unix, especially in dealing with large data Oracle can run (including texa tonka lanes windows) on all major platforms. Fully supports all industry standards. A fully open strategy. Allows texa tonka lanes customers to choose the most appropriate solution. Full support for developers. Sybase ASE to run on all major platforms (including windows). However, due to the early Sybase and OS integration is not high, so the following versions require more VERSION 11.9.2 OS and DB level patches. In a mixed environment multi-platform, there will be some problems. DB2 can run on all major platforms (including windows). The most suitable for mass data. DB2 is the most widely used enterprise level in the global 500 largest enterprises, almost 85% with DB2 database server, and domestic to 97 years accounted for about 5%. Scalability, parallelism: SQL server parallel implementation and coexistence model is not mature. Difficult to deal with the growing number of users and data volumes. Scalability texa tonka lanes is limited. Oracle texa tonka lanes Parallel Server by making a set of nodes in the cluster share the same work to expand the capacity windownt, providing high availability and highly scalable cluster solution. If windowsNT texa tonka lanes not meet the needs, the user can move the database to UNIX. Oracle Parallel Server cluster mechanism of various UNIX platforms have a very high degree of integration. Although Sybase ASE DB SWITCH to support its parallel server, but because DB SWITCH at the technical level has not yet mature, and only supports version texa tonka lanes 12.5 or more ASE SERVER, because DB SWITCH technology requires a server to act as SWITCH, resulting in hardware. DB2 has good parallelism. DB2 database management expanded to the parallel, multi-node environment. Database partition is part of a database that contains its own data, indexes, configuration files, and transaction logs. Database partition is sometimes called nodes. Security SQL server does not receive any security certificate. Oracle Server highest level of ISO standards. Sybase ASE highest level of ISO standards. DB2 highest level of ISO standards. Poor performance when multi-user SQL Server Performance Oracle's highest performance, maintaining an open platform for the world record TPC-D and TPC-C's. Sybase texa tonka lanes ASE performance is close to SQL Server. But under UNIX platform to gifted and complicated SQL Server. DB2 higher performance for data warehousing and online transaction processing. Client support and application mode SQL Server C / S structure, the only support windows client, you can use ADO, DAO, OLEDB, ODBC connection. Oracle texa tonka lanes multi-level network computing, support for multiple industry-standard, you can use ODBC, JDBC, OCI and other network client connections. Sybase ASE C / S structure, you can connect using ODBC, Jconnect, Ct-library and other network texa tonka lanes clients. DB2 cross-platform, multi-layered structure, support ODBC, JDBC and other SQL Server customers simple and easy to operate, but only graphical interface. Oracle is more complex, while providing GUI and command-line operation in the same Sybase ASE under unix windowsNT and more complex, while providing GUI and command line. But the GUI is poor, and often can not be timely, texa tonka lanes it is recommended to use the command line. DB2 is simple to operate, while providing GUI and command line, using the same risk of SQL server operating completely rewritten texa tonka lanes code under windowsNT and unix, experienced a long-term test, continuous delays, many of the features texa tonka lanes needed time to prove. Not very compatible. Oracle's long experience in the development, fully backward texa tonka lanes compatible. Widely used. Completely without risk. Sybase ASE backward compatible, but ct-library program does not benefit transplant. DB2 giant companies in widely used, downward compatibility. Small risk. After the comparison, we find that, DB2 is the best database.
Wednesday, June 25, 2014
SQL Server runs only on windows, without the slightest opening, stable operating system for the dat
SQL Server runs only on windows, without the slightest opening, stable operating system for the database is very important. Windows9X series is the emphasis on desktop applications, NT server is only suitable for small and medium texa tonka lanes enterprises. And windows platform reliability, security and scalability is very limited. It is not as proven as unix, especially in dealing with large data Oracle can run (including texa tonka lanes windows) on all major platforms. Fully supports all industry standards. A fully open strategy. Allows texa tonka lanes customers to choose the most appropriate solution. Full support for developers. Sybase ASE to run on all major platforms (including windows). However, due to the early Sybase and OS integration is not high, so the following versions require more VERSION 11.9.2 OS and DB level patches. In a mixed environment multi-platform, there will be some problems. DB2 can run on all major platforms (including windows). The most suitable for mass data. DB2 is the most widely used enterprise level in the global 500 largest enterprises, almost 85% with DB2 database server, and domestic to 97 years accounted for about 5%. Scalability, parallelism: SQL server parallel implementation and coexistence model is not mature. Difficult to deal with the growing number of users and data volumes. Scalability texa tonka lanes is limited. Oracle texa tonka lanes Parallel Server by making a set of nodes in the cluster share the same work to expand the capacity windownt, providing high availability and highly scalable cluster solution. If windowsNT texa tonka lanes not meet the needs, the user can move the database to UNIX. Oracle Parallel Server cluster mechanism of various UNIX platforms have a very high degree of integration. Although Sybase ASE DB SWITCH to support its parallel server, but because DB SWITCH at the technical level has not yet mature, and only supports version texa tonka lanes 12.5 or more ASE SERVER, because DB SWITCH technology requires a server to act as SWITCH, resulting in hardware. DB2 has good parallelism. DB2 database management expanded to the parallel, multi-node environment. Database partition is part of a database that contains its own data, indexes, configuration files, and transaction logs. Database partition is sometimes called nodes. Security SQL server does not receive any security certificate. Oracle Server highest level of ISO standards. Sybase ASE highest level of ISO standards. DB2 highest level of ISO standards. Poor performance when multi-user SQL Server Performance Oracle's highest performance, maintaining an open platform for the world record TPC-D and TPC-C's. Sybase texa tonka lanes ASE performance is close to SQL Server. But under UNIX platform to gifted and complicated SQL Server. DB2 higher performance for data warehousing and online transaction processing. Client support and application mode SQL Server C / S structure, the only support windows client, you can use ADO, DAO, OLEDB, ODBC connection. Oracle texa tonka lanes multi-level network computing, support for multiple industry-standard, you can use ODBC, JDBC, OCI and other network client connections. Sybase ASE C / S structure, you can connect using ODBC, Jconnect, Ct-library and other network texa tonka lanes clients. DB2 cross-platform, multi-layered structure, support ODBC, JDBC and other SQL Server customers simple and easy to operate, but only graphical interface. Oracle is more complex, while providing GUI and command-line operation in the same Sybase ASE under unix windowsNT and more complex, while providing GUI and command line. But the GUI is poor, and often can not be timely, texa tonka lanes it is recommended to use the command line. DB2 is simple to operate, while providing GUI and command line, using the same risk of SQL server operating completely rewritten texa tonka lanes code under windowsNT and unix, experienced a long-term test, continuous delays, many of the features texa tonka lanes needed time to prove. Not very compatible. Oracle's long experience in the development, fully backward texa tonka lanes compatible. Widely used. Completely without risk. Sybase ASE backward compatible, but ct-library program does not benefit transplant. DB2 giant companies in widely used, downward compatibility. Small risk. After the comparison, we find that, DB2 is the best database.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment