Télécharger cours oracle gratuit: Oracle vs sqlserver

A-Databases Take On Increasingly Critical Roles

Exhibit 1 shows the perceived level of criticality for a sample of databases utilizing Microsoft SQL Server 6.5 and Oracle8 (Workgroup).
Exhibit 2 reinforces this perception of criticality by showing the profiles of perceived business impact of database downtime for databases utilizing Microsoft SQL Server 6.5 and Oracle8 (Workgroup) respectively Databases using these products are no longer implemented largely for the convenience of an individual group of users. Should a database fail then there is approximately a 50:50 chance that the entire company will be inconvenienced or even forced to stop working. As a result the cost of downtime to businesses nowadays is considerable.In such circumstances, the performance, reliability and recovery facilities of database products are critical to the organization.

Application Usage by Database Server
The profiles of application usage are broadly similar across database server. However Oracle8 (Workgroup) tends to be more extensively used for more intensive applications such as data warehousing and OLTP than is Microsoft SQL Server 6.5. Conversely there is greater emphasis on use of Microsoft SQL Server 6.5 for customer relationship management and accounting applications.

Usage Statistics by Database Server
Amongst those organizations surveyed, applications utilizing Microsoft SQL Server 6.5 have a higher average number of named users than applications utilizing Oracle8 (Workgroup). However, the Oracle8 (Workgroup) database servers achieve higher intensity of usage by supporting a higher ratio of concurrent users to named users. In addition,the average size of database supported is almost three times higher for Oracle8 (Workgroup). This suggests that a greater workload, overall and per named user, is typically being placed on those databases utilizing Oracle8 (Workgroup).

B-Oracle 8 (Workgroup) is More Suited to Data Warehousing Environments

In these circumstances, it is important that database software selected is suitable to support mission critical applications and has the scalability required to facilitate these high levels of planned growth. In particular, database software requires:
· A high level of reliability
· Recovery facilities to minimize downtime in mission critical environments
· Performance in increasingly demanding environments.
Exhibit 5 compares satisfaction with Microsoft SQL Server 6.5 and Oracle8 (Workgroup) in terms of a range of these characteristics across the complete application mix shown earlier.

…..