浅谈ORACLE与SQLSERVER的差异.doc

摘要 ORACLE 和 SQL SERVER 是众多数据库的一分子。在不同的关系型数据库管理系统(RDBMS)之间，存在很多差异，ORACLE和SQL SERVER都符合SQL-92标准的属性扩展。从应用程序的开发人员的角度来看,ORACLE和SQL SERVER对数据进行管理方式没有太大的区别。ORACLE和SQL SERVER之间的内部差异却是十分明显。计算机系统和终端设备的功能、性能和使用方式千差成别，用户希望在现有设备的基础上，充分利用不同系统的各种资源，尽可能简单地完成一项工作，满足用户的要求，设计一个统一的系统接口，并通过这一接口与局部系统转换，实现各种资源的共享。这种转换实际上是数据库语言转换，为了实现其转换，就必须进行数据库语言的比较。ORACLE公司的ORACLE和Microsoft公司推出的SQL ERVER是当今流行的大型关系数据库管理系统，它们是建立在成熟而强大的关系模型基础上，可以很好的支持客户/服务器模型，系统具有功能强大，使用灵活和形式多样的特点，可以用于构造从小型的单用户系统到支持数千个并发用户的大型应用项目上。 本文针对ORACLE和SQL SERVER两种语言进行比较。 关键字：数据库，ORACLE，SQL SERVER Abstract Oracle and Sql server?are member of?numerous?database.In the relational database management system (RDBMS) between different, there are number of differences,Properties of Oracle and Sql server are in line with the SQL-92 standard extension.From the application developers perspective, Oracle and Sql server is not much difference to carry on the management mode of data.Is?very obvious to The internal differences between Oracle and Sql server Computer systems and terminal equipment function, performance and the use way thousands of poor into other,Users hope that on the basis of the existing equipment, make full use of various resources in different systems, as simple as possible to complete a task, to meet user requirements, design a unified system interface, and through this interface with the local system transformation, realize the sharing of various resources.This conversion is actually the database language conversion, in order to realize the conversion, the comparison must carry out the database language.Oracle and Microsofts Sql server is a large scale relational database management system of popular.They are based on a mature and powerful relationship model based on server model, can be very good support customer / the system have the function strong, the use of flexible and diverse forms of characteristics, can be used for the large type application project is constructed from the single user system for small to suppor