SQL Server and Oracle database, the difference between

2010-03-15  来源:本站原创  分类:Database  人气:178 

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 rapid development of information technology, data processing requirements not only increasing in number and in quality also become increasingly demanding.

The stability of the operating system the database is very critical, operational platform in the database, Oracle can run on all major platforms, Oracle database, an open strategic objectives, it allows customers to choose the most suitable for their specific needs solution. Customers can use many types of third-party applications, tools. Of the developers is a great support. The SQL Server can only run in Windows, and it becomes rather monotonous, but the SQL Sever in Window platform performance, and the Windows operating system, the overall degree of integration, ease of use, and the Microsoft development platform integration are much stronger than Oracle. However, the stability and reliability of the Windows operating system for everyone to see, say Microsoft's strategy is to target customers are locked to the Windows platform, the environment, improve the performance only with the Windows, SQL Server can be further improved. From this point on the Oracle platform is totally better than SQL Server, the.

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

Purchase a product, the first consideration of course, product performance, and when considering the performance of the same course, for how much money to spend on this product is a very key issue. To create and run a database system. Not only includes the initial purchase of software and hardware costs, but also includes training and subsequent maintenance costs. Orcale database SQL Server database, the price is far higher, than why the Oracle database to SQL Server database, the price so much higher, while Oracle's initial cost is relatively high, especially when considering the tools, Oracle lot tools need to purchase, and Microsoft provides free software tools compared to SQL Server, Oracle is more costly price. However, SQL Server can only run in Windows because, generally considered the reliability of SQL Server database is relatively poor. Oracle's performance advantage is reflected in his multi-user, while SQL Server's performance advantage on the multi-user becomes insufficient.

Operation on the SQL Server is significantly larger than Orcale simple, if you used Java and DOTNET development platform, the basic difference between Oracle and SQL Server is different, Oracle's Java-based interface, basically, most of the tool is Dos interface, even SQLPlus is, SQL Server is the same with VB, full graphical interface, rarely seen DOS window. SQL Server in Enterprise Manager to provide a full graphical user interface, integrated management console to centrally manage multiple servers. Oracle also has its own business manager, and its performance in some ways even more than the SQL Server's Enterprise Manager, but it is more difficult to install.

Orcale database and the SQL Server database that quickly? Is actually a very difficult question to answer because there are many uncertainties, including handling the type of data distribution and hardware infrastructure.

SQL Server is a fully Web-enabled database product, providing core support for Extensible Markup Language and the Internet, and the ability to query outside the firewall, with the scalability, flexibility, scalability is good, but cheap price, features, and Oracle will have a reliable security, speed hundreds of times faster than SQL Server, but its price in the implementation of the SQL Server is higher than a few hundred times.

In fact, consider the options the industry that the database is a database of characteristics and according to their business needs and infrastructure taken into account to decide.

相关文章
  • 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

  • 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 2000 change database name. change the logical file name! 2010-09-24

    sql server 2000 change database name, change the logical file name 2010-09-24 11:00:00. One. Change the database physical file name in Enterprise Manager can not directly change to run in Query Analyzer (database name): the original name of the datab

  • sql server 2000 change database name. to change the logical file name! 2010-09-24

    sql server 2000 change database name, change the logical file name 2010-09-24 11:00:00. 1. To change the database physical file name in the Enterprise Manager can not directly change to run in Query Analyzer (database name): alter database name of th

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

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

  • 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

  • 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 stored procedure database application developed 2010-07-27

    SQL SERVER database application developed by the stored procedure definition: Stored procedure is acceptable to save up and return the user supplied parameters of Transact-SQL statement collection. Can create a process for permanent use, or for tempo

  • [Transfer] SQL Server 2000 master database in the system tables mapped to their corresponding SQL Server 2008 system view or function 2010-12-16

    [Switched from MSDN: http://msdn.microsoft.com/zh-cn/library/ms187997.aspx ] This topic describes the system functions and system tables and views and the mapping between functions. The following table in SQL Server 2000 system tables within the mast

  • [Transfer] SQL Server 2000 master database in the system table is mapped to their corresponding SQL Server 2008 system views or functions 2010-12-16

    [Transfer from MSDN: http://msdn.microsoft.com/zh-cn/library/ms187997.aspx ] This topic describes the system functions and system tables and views and the mapping between functions. The following table in SQL Server 2000 system tables within the mast

  • SQL Server 2008 relational database engine, new features 2011-04-20

    Reprinted from: http://database.51cto.com/art/200803/66568.htm In SQL Server 2008, the relational database engine, a relatively large number of new features, this article will be focused on application developers and database administrators more conc

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

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

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

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

  • 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,mysql,oracle三者的区别 2014-06-12

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

  • oracle database, the difference between any and all 2010-08-04

    oracle database, any and all of the differences: All: All, such as> all you need is greater than all, <all Zexu less than all Any: Any if> any more than any one of them is required, <any is less than any of them.