Windows-Unix SQL-Oracle (from: White fruit tree)

Windows -- Unix

Microsoft uses the Windows NT technology and releases an upgraded version of Windows NT, Windows 2000. However, the defects in the management of memory and CPU resources in Windows operating systems have not been greatly improved. For example, every socket connection added to the Windows NT System will occupy about 13 K of processes in the memory area. The development of online securities businesses will certainly face access from a large number of customers. Windows systems can easily crash or crash when a large number of users access the system due to resource depletion. At the same time, the famous blue screen and illegal operations of Windows operating systems are also one of the reasons for the lack of stability of the system. According to Microsoft documentation, Windows NT only guarantees stability for 6 months.

However, compared with small-scale applications and low concurrency traffic, Windows is undoubtedly an operating system with the minimum management and investment costs.

When UNIX serves multiple tasks, it can protect any task from interfering with other resources and never paralyze the entire system due to a task failure (this is especially true for Windows ). This feature is very important to database applications. Because other operating systems do not have this feature, it is difficult to avoid frequent crashes. UNIX can operate on multiple files at the same time, and can open a large number of files without significantly reducing the performance, which is impossible for any other operating system. UNIX provides a synchronous method for mutual notification when multiple tasks that work collaboratively access shared resources. This mechanism ensures that multiple users operate on the same database without deadlock or conflict. A Unix process can contain multiple threads and be used with multiple threads in the database system. UNIX can call the remote processor transparently over the network, without the application being noticed. UNIX can schedule tasks based on the priority of tasks to ensure that emergency tasks are handled urgently. UNIX can dynamically add devices during running without re-configuring the system. UNIX systems can run for years without restarting, reducing service interruptions.

A single UNIX system requires a high level of enterprise investment and technical skills of professional management personnel.

According to the above analysis, it can be seen that the Windows operating system is suitable for running in a work environment where the concurrent data volume is small and data operations are not very frequent. In this environment, the Windows operating system has a high performance-price ratio.

UNIX operating systems have great advantages in system stability, resource allocation, multithreading, and other important performances, the Development Trend of today's key platforms in the telecom, finance, insurance, and other industries will be towards a more stable UNIX direction.

UNIX also has the biggest advantage. Although unxi's critical vulnerabilities do not require fewer windows, the number of UNIX attackers is far smaller than that of Windows attackers (because the Internet is full of Windows hacking tools, however, there are few hacker tools that attack Unix. Therefore, a very large number of low-level attackers are much fewer than Unix. For a Unix expert, Windows is just a piece of cake ).

SQL---ORALCE

Microsoft SQL Server database is a customer/Server database system and is a Microsoft product mainly for small and medium-sized enterprises. Its features are good combination with Microsoft's series of operating systems, and the operation and installation are relatively simple. When loading a small amount of data, it can play a better performance. When a large amount of data is accessed concurrently, it consumes a lot of system resources and reduces the speed. This greatly affected the customer's viewing prices and the response time of the transaction.

However, it is easy to operate, the flexibility and convenience of customized backup, and the low technical requirements of management personnel.

Oracle is currently the best-performing database system that supports huge data throughput, faster data processing speed, and better stability. This product also has good stability, especially for UNIX operating systems, Oracle in terms of database stability, reliability, ease of maintenance, requirements for system resources, especially for Internet/Intranet applications, etc, its overall performance is better than other database systems.

It is undeniable that Oracle is much more complex than SQL, and the price is at least 3-5 times more expensive. It is suitable for enterprises and companies with a large number of concurrent businesses and a large amount of money.

For an image configuration case, a securities company's:

For example, if you use the single business department mode and the number of concurrent users is small, we recommend that you use the Intel architecture SERVER + Windows 2000 operating system, and SQL server for the database. The number of concurrent users is up to 3000, and the transaction request of 1000 users can be responded simultaneously.

When connecting to multiple business departments, we recommend that you use the intel-Based Server + SCO Unix Ware operating system and Sybase for the database. The number of concurrent users can reach about 6000, and can respond to transaction requests of 2000 users at the same time.

If the number of concurrent users exceeds 8000, we recommend that you use the sun dedicated server + Solaris operating system, and Oracle for the database. It can meet the requirements of 6000-13000 users for concurrent access and respond to transaction requests from 3000-6000 users at the same time.

(Original address: http://www.cnblogs.com/charyl/archive/2005/04/18/139759.html)