SQL Server and Oracle.DB2 three database comparison

2011-02-21  来源:本站原创  分类:Database  人气:98 

Development of database applications, choosing a good database is very important. This paper compares some aspects of SQL Server and Oracle, DB2 three database, you select the database to provide some reference.

Development of database applications, choosing a good database is very important. This paper compares some aspects of SQL Server and Oracle, DB2 three database, you select the database to provide some reference.

Open SQL Server
Can only run on Windows, not the slightest open, the operating system, the stability of the database is very important. Windows9X series is the emphasis on desktop applications, NT server is only suitable for small and medium enterprises. And the Windows platform reliability, security and scalability is very limited. It is not like Unix, as proven, especially when dealing with large amount of critical business data.

Oracle
In all major platforms (including Windows). Fully supports all industry standards. A fully open strategy. Allows customers to choose the most suitable solution. Full support for developers.

DBz
In all major platforms (including Windows). Most suitable for mass data. DB2 in the enterprise's most widely used in the world's 500 largest companies, almost 85% of the DB2 database server, and domestic to 97 years accounted for about 5%.

Scalability, parallelism SQL Server
Parallel implementation and co-existence model is not mature. Difficult to deal with the growing number of users and data volumes. Scalability is limited. Oracle Parallel Server by making a set of cluster nodes share the same work in Window NT to extend the ability to provide high availability and highly scalable cluster solution. If you can not meet the needs of WindowsNT, the user can move the database to UNIX.

DB2
DB2 has a very good parallelism. DB2 database management expanded to the parallel, multi-node environment. Database partition is part of the database contains its own data, indexes, configuration files, and transaction logs. Database partition is sometimes called a node or database node.

SQL server security
Did not get any security certificates.

Oracle Server
The highest level of ISO certification standards.

DB2
The highest level of ISO certification standards.

Performance
SQL Server
Oracle poor performance when multiple users
Highest performance, maintaining WindowsNT under the TPC-D and TPC-C world record.

DB2
For data warehousing and online transaction processing, high performance. Client support and application mode.

SQL Server
C / S structure, only supports Windows clients, you can use ADO, DAO, OLEDB, ODBC connection.

Oracle
Multi-level network computing to support a variety of industry standard, you can use ODBC, JDBC, OCI-peer network client connections.

DB2
Cross-platform, multi-layer structure, support ODBC, JDBC and other customers.

Easy SQL Server
Simple operation, but only graphical interface.

Oracle
More complex, while providing GUI and command line in Windows NT and Unix operating the same.

DB2
Simple operation, while providing GUI and command line in Windows NT and Unix operating the same.

The risk of using SQL Server
Complete rewrite of the code, after a long test, and constantly delayed, many of the features will take time to prove. Not very compatible with earlier products. Use need to take some risks.

Oracle
Long period of development experience, is fully backward compatible. Widely used. Entirely without risk.

DB2
In the mega-corporations is widely used, backward compatibility is good. Little risk

相关文章
  • SQL Server and Oracle.DB2 three database comparison 2011-02-21

    Development of database applications, choosing a good database is very important. This paper compares some aspects of SQL Server and Oracle, DB2 three database, you select the database to provide some reference. Development of database applications,

  • 比较SQL Server与Oracle.DB2数据库的一些知识 2015-05-01

    本文比较大型数据库SQL Server与Oracle.DB2的一些不同应用之处.对于以后开发选择什么样的数据库. 开放性 SQL Server 只能在Windows 上运行,没有丝毫的开放性,操作系统的系统的稳定对数据库是十分重要的.Windows9X系列产品是偏重于桌面应用,NT server只适合中小型企业.而且Windows平台的可靠性,安全性和伸缩性是非常有限的.它不象Unix那样久经考验,尤其是在处理大数据量的关键业务时. Oracle 能在所有主流平台上运行(包括 Windows).

  • SQL Server与Oracle.DB2三种数据库的比较 2014-11-01

    开放性 SQL Server 只能在Windows 上运行,没有丝毫的开放性,操作系统的系统的稳定对数据库是十分重要的.Windows9X系列产品是偏重于桌面应用,NT server只适合中小型企业.而且Windows平台的可靠性,安全性和伸缩性是非常有限的.它不象Unix那样久经考验,尤其是在处理大数据量的关键业务时. Oracle 能在所有主流平台上运行(包括 Windows).完全支持所有的工业标准.采用完全开放策略.可以使客户选择最适合的解决方案.对开发商全力支持. DB2 能在所有主流

  • SQL Server and Oracle database, the difference between 2010-03-15

    Can be seen from the data, Oracle's highest certification level security certification of ISO standard certification, and what SQL Server does not receive security certification. This proves Oracle's security is higher than the SQL Server. With the r

  • JAVA connection ACCESS, SQL Server, MySQL, Oracle Database 2011-05-04

    import java.sql .*; / * * JAVA connection ACCESS, SQL Server, MySQL, Oracle Database * * * / public class JDBC { public static void main (String [] args) throws Exception { Connection conn = null; //==== Connection ACCESS database ==== / / Connection

  • SQL Server and Oracle database on the differences in query optimization 2011-03-18

    [IT News Writer In general, Oracle database data in a large environment, its operating performance than the higher efficiency of the SQL Server database. From the query optimization in terms of a single, relatively large differences between the two t

  • Comparison of SQL server and Oracle Developer 2010-06-21

    Conceptual distinction between 1.Oracle is an object-relational database management system (ORDBMS), and the Sql server is a relational database management Management System (RDBMS). 2.Oracle use Internet file system, Java-based application that allo

  • Oracle.MYSQL.sql server and the DB2 query formulation page 2010-11-16

    DB2: DB2 Query page SELECT * FROM (Select Field 1, Field 2, Field 3, rownumber () over (ORDER BY column name sort by ASC) AS rn from the table name) AS a1 WHERE a1.rn BETWEEN 10 AND 20 That extract more than the record of the first 10 to 20 select *

  • SQL server.MySQL.Oracle page queries the SQL statement 2011-07-14

    SQL Server SQL statement to query on the data page of solutions: Asked to choose tbllendlist the first 3000 records, 100 records each page. ------------------------- ---------- Method 1: ---------- select top 100 * from tbllendlist where fldserialNo

  • Random read N records (MySQL.SQL Server.Access.Oracle.postgreSQL) | access 2011-03-30

    From the database using a SQL statement to obtain N random Table table records, the database SQL statement is slightly different, as follows: 1, MySql Select * From TABLE Order By Rand () Limit N The code efficiency is not high, their 1000 data table

  • 在SQL Server和Oracle中创建job 2014-03-10

    有的时候,我们可能需要在数据库中设定一些自动执行的任务(job),以此来自动完成一些包括统计.备份方面的需求,下面就简单说明一下有关ms server和oracle两种数据库中如何新建自动任务. 首先说下ms server,因为我也是新手,所以首先选择了使用企业管理器进行任务设定,然后再导出设计完毕的任务脚本,这样就可以在其他数据库中直接通过执行脚本的形式来新建任务了(需要适当修改其中的一些任务名称和数据库名称等值),下面说下具体的操作步骤以及获得的任务脚本: 1. 保证启动ms server的

  • sql server,mysql,oracle三者的区别 2014-06-12

    oracle就是ORACLE公司的数据库产品,以高性能著称,系统是可以随意下载的,但应用与商业用途需要LECENCE; MS SQL是微软的数据库产品特点是易学易用,交互性好,具有良好的用户界面,,定位是中型企业 MYSQL是著名的开源数据库系统,应用的也十分广泛,尤其是论坛和小型企业网站 三个数据库都是基于SQL语言实现,但每个数据库在基本SQL语言基础上增加了自己的语法和优化策略. MYSQL先是被SUN公司收购,后来SUN又被ORACLE公司收购,因此关系有些微妙. 1. ORACLE o

  • Sql Server 创建数据库脚本Create DATABASE 2015-04-29

    这篇文章主要介绍了Sql Server 创建数据库脚本语句Create DATABASE的使用,需要的朋友可以参考下 Create DATABASE HappyRelaxDB on( NAME='HappyRelaxDB',FILENAME='D:\Sunny_Project\HappyRelaxPro\HappyRelaxDB.mdf') LOG ON(NAME='HappyRelaxDB_log',FILENAME='D:\Sunny_Project\HappyRelaxPro\HappyR

  • SQL Server与Oracle数据库在安全性上的异同 2014-02-18

    在业界,普遍认为Oracle数据库的安全性要比SQL Server数据库高.下面笔者就来谈谈这两种数据库在安全性设计上面的异同.掌握好这些内容,对于我们进行数据库安全方面的设计与管理,有着举足轻重的作用. 一.角色到用户的授权. 现在很多应用软件,包括数据库系统,都采用了角色到用户的授权体系.也就是说,先给一个角色进行授权,然后再把用户加入到这个角色中,让其拥有这个角色的权限. 如我们在数据库设计的时候,一般至少需要两种角色,一种是系统管理员角色,这种角色具有对数据库系统进行管理,如表的建立与删

  • SQL Server vs Oracle 简单语法比较 2014-01-25

    1.SQL SERVER变量必须以@开头. 2.SQL SERVER语句后不需要写分号结束符. 3.oracle变量类型number 可以修改为sql server的decimal 4.oracle变量类型varchar2 可以修改为sql server的varchar 5.SQL SERVER定义变量及传递参数,最好加上参数大小数值,例如:varchar(50) 6.SQL SERVER 不能用ROWID, ROWNUM (但可以用TOP代替) 7.oracle里的nvl函数,在SQL SER

  • SQL server 2005 to create a database failure prompted "Collation <server default> is not valid" solution 2010-12-02

    Error Description: Create a database occurs, the new database error "Collation '<Server Default>' is not valid. (Microsoft.SqlServer.Express.Smo)" Solution: In the [option], the collation for the default values ​​given, we collation select

  • SQL Server and Oracle compared commonly used functions 2011-09-21

    http://database.51cto.com/art/200611/35178.htm

  • oracle and sql server feature comparison 2011-01-05

    Oracle Database 10g compared the competitive advantage of SQL Server 2005 Microsoft officially released on 2005.11.7 SQL Server 2005. By comparing Oracle Database 10g and SQL Server 2005 features and performance, we give the competitive advantage of

  • With SQL Server skills to learn DB2 UDB V8 2010-05-12

    With SQL Server skills to learn DB2 UDB V8 Introduction In today's information technology field, new information continues to impact us - the new software product, new versions and new features. So you can keep up with these constant changes of the h

  • Oracle and SQL Server in the interconnection 2010-07-21

    Oracle and SQL Server interconnection: Interconnection of different database platforms, heterogeneous database services, generally referred to now can be achieved between the major databases such heterogeneous interconnect, but the manufacturers are