오라클9i와 sql의 비교분석 자료

본문내용

Introduction
This white paper is intended for database administrators and developers of Oracle9i Database (Release 1) applications who want to understand how its feature sets compare to Microsoft? SQL Server 2000. The tools, processes, and techniques that show the feature comparison are described here.
Target Audience
The target audience can be new to Microsoft? SQL Server and its operation, but should have a solid foundation in the Oracle? RDBMS and general relational database concepts. The target audience should have:
• A strong background in Oracle RDBMS fundamentals.
• General database management knowledge.
• Familiarity with the Oracle SQL and PL/SQL languages.
• Membership in the sysadmin fixed server role on an Oracle test database.
• Membership in the administrator role on a Microsoft SQL Server 2000 test database.
For clarity and ease of presentation, the reference development and application platform is assumed to be the Microsoft Windows? 2000 operating system, and the use of Microsoft SQL Server 2000, and Oracle?9i™ Database Server Release 1.
Overview
Understanding the features of the Microsoft? SQL Server and Oracle9i Database can be a daunting task. This white paper discusses the features of Microsoft SQL Server 2000 and Oracle9i Database and makes comparison by abilities. Even though both products have similar functionality, their features can be grouped by the abilities demanded by users needing the use of a Relational Database Management System product.
For the purpose of this white paper, the groups covered will be: Availability, Scalability, Security, Interoperability, Manageability, Programmability, Ease of Use, Data Warehousing, Data Mining, and Mobility.
This white paper will also highlight the strengths and weaknesses of both products to see how they relate to each other and to understand how the same functionality is obtained from both.
Not every single feature is discussed here. For additional information, you may consult the product documentation. For Microsoft SQL Server 2000, this is a compressed html file; for Oracle9i Database, this is series of approximately 100 Adobe Acrobat files. Information can also be obtained from the Web sites of the each respective product.
Availability
This section provides comparative information between Microsoft? SQL Server and Oracle?9i™ Database by comparing the tools to maximize uptime and availability, looking at how both products are supported in a clustered environment, and highlighting the architecture, deployment and failover support. The introduction of Oracle Application Clusters will also be discussed, moving on to replication and supporting backup and recovery capabilities. We will also touch on how both database products handle database recovery and repair procedures.
Before proceeding, the reader must be aware that high availability for any system (regardless of vendor) is influenced by three key components: technology, people and process. A failure or weakness in any one of these will likely have significant consequences on the overall availability of the system.

키워드

오라클,   sql,   비교,   분석,   자료,   mssql,   mysql,   서버