The Oracle tutorial you are looking at is: oracle8i and Microsoft SQL Server comparison.
Architecture
Microsoft operates according to the distribution of the customer/server architecture. This approach produces unnecessary cost and complexity. Oracle has found a better answer to the Internet. In a multi-tiered (multi-tiered) architecture of the Internet computing, centralizing (centralization) simplifies deployment and maintenance of applications, manages and backs up data, and delivers advanced performance, security, and reliability to customers- The result is a lower overall operating cost. Oracle has the ability to store all data and documents in a few high-performance databases that enable customers to centrally manage all their data, and information management and access is easier, more reliable, and cheaper.
Open (openness)
SQL Server runs only on Windows, and the goal of Microsoft's proprietary strategy is to lock customers into a Windows environment, limiting customers ' access to the benefits of innovation and price competition by choosing an open standards-based solution. In addition, it is also known that the Windows platform itself is limited in reliability, security, and scalability. Oracle can run on all major platforms, including Windows, and fully supports all industry standards, so customers can leverage a number of third-party applications, tools, gateways, and management utilities. Oracle employs an open policy that allows customers to choose a solution that best suits their specific needs. With Oracle8i, the operating system will essentially become irrelevant. The Oracle8i Internet File System (IFS) is a breakthrough that provides an Easy-to-use data management interface for all data types, reducing the customer's reliance on specialized operating systems such as Windows.
Scalability
Because the parallel implementation and coexistence model of SQLServer7.0 is immature, it makes people more concerned about the ability of the product to handle the increasing number of users and data volumes (volumes). Oracle offers an excellent scalability in the following two areas:
Cluster: Oracle Parallel servers extend the capabilities of Windows NT by enabling a set of nodes to share workloads in the same cluster, and Oracle delivers a cluster solution with high availability and scalability, while Microsoft offers only clusters that overcome errors. According to a Gartner Group report (10/97), Microsoft will not have a scalable cluster solution until 2001. Oracle has had this capability since 1997.
Scalable to other operating systems: Because Oracle is an open solution, customers can move from their systems to UNIX or another operating system when Windows NT does not meet their needs. The combination of SQL Server and a single platform means that when a customer reaches the limits of Windows NT, they have no choice but to abandon their systems and move to a new database on a new platform-a proposal that saves time and money.
Security
Global data access as a result of the advent of the Internet also increases the potential security risks. The security requirements for the database are never higher than before, and SQL Server7.0 has not obtained any type of security certificate. Oracle, by contrast, is the only database to obtain the highest certification level of ISO Standard certification. Oracle's advanced security features take into account enforcement of small permissions, advanced review, enhanced access control, security distribution is processing and replication, and the ability to use additional external issuance mechanisms. SQL Server7.0 does not have these attributes. With Oracle products, organizations can migrate the truly integrated security mechanism into business systems cheaply.
[NextPage]
Scalability
Today's internet is an exciting new world with vivid images, real-time video-on-demand, high-fidelity voice and sound, and complex information such as financial data trends and geo-coding. By centralizing the management of text, images, audio, video, and geographic information, Oracle8i's Intermedia enables customers to take advantage of the multimedia features of the Web. Microsoft SQL Server 7.0, by contrast, lacks built-in support for non-traditional data types. As an alternative strategy, Microsoft advocates storing non-traditional data in a flat (flat) file in a separate server, and then linking them with Ole-db. By using this strategy, integrating the various data types found on the web will result in complex, insecure, and maintainable packets (mess), which lack the integrity of the object.
Performance
Low performance can be fatal (fatal) because the employee's productivity is hampered and the customer is lost due to too much waiting time. Oracle provides more advanced performance than SQL Server7.0, based on standards and results reviewed by the Things Handling Committee (TPC). By November 1998, Oracle had been the world record-keeping provider of tpc-d and TPC-C standards in Windows NT. In fact, Oracle's NT TPC-C results are almost twice times faster than Microsoft's. Microsoft has never announced a tpc-d result, which means that although there is a hypothetical environment in SQL Server7.0, it is still not suitable for data warehousing applications. Oracle also maintains a world record of Sap,baan and PeopleSoft standards. By consistently demonstrating the performance relationship between formal standards and reality, Oracle has proven that it can handle the most pressing workload requirements for data warehousing and OLTP applications.
Simple operation
Making a database easy to install, use, and manage--grouped together as "simple to operate"--is a key factor in reducing costs. Although Microsoft products have a reputation for ease of use, SQL Server7.0 lacks the characteristics of database management, which is necessary for complex database systems. For example, for SQL Server6.5 and SQL Server7.0,microsoft, you need to use separate administrative tools. For ease of installation, Oracle uses a java-based utility that provides everything you need to install and run a pre-configured and preconfigured oracle8i database. The most important part of "easy operation" is manageability, and Oracle Enterprise Manager (Enterprise Manager) provides an integrated management console to centralize multiple servers. Customers can also purchase all three or any of the optional Management Packs, which provide advanced functionality to tune and diagnose databases and manage complex changes in the database environment.
Innovation
PC Week has said that "SQL Server7.0 does not provide customers with anything new that their competitors have not yet provided." "According to Information Week (9/14/98)," even in the economic market: the Windows NT environment, SQL Server7 is still not an OLTP database competitor. "In SQL Server7.0, the functionality required for many mission-critical database applications (high availability/scalability, security, performance, and so on) is still not in existence." Microsoft is now struggling to catch Oracle's yet another technology-leading tradition, and the newly released oracle8i is no exception. Through innovations such as IFS, Database Java, WEBDB, intermedia, and Webtogo, Oracle takes the lead in enabling companies to gain the benefits of Internet computing. Particularly in Windows NT, because Oracle is the first vendor to publish an NT database cluster solution, it first supports more than large memory (VLM), and for the first time brings high availability and scalability to NT with oacle parallel servers. So Oracle has become a clear leader in extending NT capabilities. 1 3
[NextPage]
Technical risk
SQL Server7.0 is a fully rewritten version of the product. The product has experienced a delay in connection and has a very long beta test cycle, which typically represents a development issue. A Gartner report (8/98) said, "The engine was redesigned very deeply ... We recommend that you do not deploy the product to a larger product application until the middle of 1999. "As stated in a Giga report (3/98)," SQL Server still has a lot to prove. Scalability, reliability, multi-user performance, cluster development, object characteristics support, etc. are problematic. "A particularly dangerous factor is the problem of re adding to the database." As the basic data structure changes, Microsoft will require all SQL Server6.0 and 6.5 sites to unload and reload the data, a process that takes several days. Microsoft has acknowledged a post compatibility issue between 6.5 and 7.0. With SQL Server7.0, many of the previously existing basic 6.5 code will have to be rewritten to take advantage of new features like row-level locking and distribution unions. Companies must be very cautious in putting their productivity and information at risk. There is no risk of using Oracle. Oracle8 has been posted for more than a year and is deployed on hundreds of user sites. Of the 500 consortium companies, nearly 90% of the companies use Oracle products and servers.
[1] [2] Next page
The Oracle tutorial you are looking at is: oracle8i and Microsoft SQL Server comparison. Such broad support is the result of the trust of Oracle, which is a safe and reasonable choice for Oracle. Customers will ask themselves how to take the risk of using new, Oracle8 SQL Server7.0 when there is already a reliable, advanced database of databases.
Vendor risk
Microsoft's core competency is the development of desktop and operating system software, which has little experience in enterprise-level data management. From a technical and business point of view, Microsoft has only recently entered the field of data management and has so far not been trusted. Microsoft's success is due to the continuous abandonment and upgrades of customer software, as well as to the spread of hardware and operating systems as much as possible. Enterprise-wide success requires efficient use of existing data resources and consolidation of server resources. On the other side, Oracle has over more than 20 years of experience with customer solutions. A company's data is their most valuable asset, and Microsoft cannot expect to flood into the market and gain trust overnight. Oracle has spent years of hard work winning the trust of its customer base and the honor it currently enjoys. The success of thousands of customers running their business on Oracle every day is the perfect proof of the Oracle technology and business model.
Summarize
The SQL Server7.0 has been released almost two years later than the original plan. During this time, the battle over which vendor has the best database solution on Windows NT has been launched and eventually Oracle wins. Oracle has been a market leader on Windows NT since 1996. Over the past four years, Oracle has enjoyed an alarming 2000% per cent increase in revenue for NT. During this period, Microsoft's revenue share in the NT market has actually decreased by 27.8%. The great success of Oracle's partners complements the success of Oracle's customers. A recent ARM study (1998) showed that in the 1997 EPT market, 52% per cent of database revenues entered Oracle, compared to 5% of Microsoft SQL Server. In fact, of the 3,200 NT installations of ASP, 70% is on Oracle. Only 20% is on the SQL Server. With their latest database upgrades, Microsoft reached the level that Oracle reached through Oracle6 ten years ago. SQL Server7.0 is still a few years behind the oracle8i, and there are serious problems with scalability, architecture, functionality, security, extensibility, which will hinder its use in mission-critical applications. Customers will have serious reservations about choosing SQL Server7.0, especially when oraclr8i, a highly reliable and advanced product, already exists. 1 2
Previous page
prev [1] [2]
