• 欢迎访问速搜资源吧,如果在网站上找不到你需要的资源,可以在留言板上留言,管理员会尽量满足你!

【速搜问答】SQL服务器是什么

问答 admin 2周前 (04-19) 24次浏览 已收录 0个评论

汉英对照:
Chinese-English Translation:

SQL服务器是由Microsoft所开发出来的数据库服务器,一般说来SQL Server可以配合Visual Basic、Visual FoxPro、Access、Clipper等程序语言来开发使用者前端接口,结合这些接口建立一个主从式数据库架构。

SQL server is a database server developed by Microsoft. Generally speaking, SQL server can cooperate with visual basic, Visual FoxPro, access, clipper and other programming languages to develop user’s front-end interface, and establish a master-slave database architecture with these interfaces.

SQL 服务器是由 Microsoft 所开发出来的数据库服务器(server),它可以让一个企业利用 Interned/Intranet 来整合所需的数据库,一般说来,SQL Server 可以配合 Visual Basic、Visual FoxPro、Access、Clipper 等程序语言来开发使用者前端接口,结合这些接口建立一个主从式数据库架构。

SQL server is a database server developed by Microsoft. It can make an enterprise use interned / Intranet to integrate the required database. Generally speaking, SQL server can cooperate with visual basic, Visual FoxPro, access, clipper and other programming languages to develop user’s front-end interface, and establish a master-slave database architecture with these interfaces.

简述

sketch

最初是 Sybase 提供的,但 Microsoft 公司把它发展成为了自己的产品。这种产品的目的是提供一种高性能的关系型数据库管理系统服务。关系型数据库管理系统是最流行的商业数据库之一。它们的基础是一系列含有不同类型信息的表格,这种表格有很多行和列,各列中存有不同类型的信息。关系型数据库管理系统的关键就在于它能把这些表格连起来成为一个整体的信息系统。

It was originally provided by Sybase, but Microsoft developed it into its own product. The purpose of this product is to provide a high performance RDBMS service. Relational database management system is one of the most popular commercial databases. They are based on a series of tables with different types of information, which have many rows and columns, and each column contains different types of information. The key of RDBMS is that it can connect these tables to form a whole information system.

发展

development

1970 年 6 月,E.EDodd 博士发表“A Relational Model ofData for Large Shared Data Banks”论文,提出关系模型。1979 年 6 月 12 日,Oracle 公司(当时还叫 Relational Software)发布了第一个商用 SQL 关系数据库。1987 年 Microsoft、Sybase 和 Ashton-Tate 三家公司共同开发了 Sybase SQL Server。1988 年,Microsoft、Sybase 和 Aston—Tate 三家公司把该产品移植到 OS/2 上。后来 Aston.Tate 公司退出了该产品的开发,而 Microsoft 公司、Sybase 公司则签署了一项共同开发协议,这两家公司的共同开发结果是发布了用于 Windows NT 操作系统的 SQL Server,1993 年,将 SQL Server 移植到了 Windows NT 3.1 平台上,即微软 SQL Server 4.2 版本发布。在 SQL Server 4 版本发行以后,Microsoft 公司和 Sybase 公司在 SQL Server 的开发方面分道扬镳,取消了合同,各自开发自己的 SOL Server。Microsoft 公司专注于 WindowsNT 平台上的 SQL Server 开发,而 Sybase 公司则致力于 UNIX 平台上的 SQL Server 开发。SQLServer 6.0 版是第一个完全由 Microsoft 公司开发的版本。1996 年,Microsoft 公司推出了 SOLServer 6.5 版本,接着在 1998 年又推出了具有巨大变化的 SQL Server 7.0 版,这一版本在数据存储和数据库引擎方面发生了根本性的变化。又经过两年的努力开发,Microsoft 公司于 2000 年 9 月发布了 SQL Server 2000,其中包括企业版、标准版、开发版、个人版 4 个版本。从 SQL Server 7.0 到 SQL Server 2000 的变化是渐进的,没有从 6.5 到 7.0 变化那么大,只是在 SQL Server 7.0 的基础上进行了增强。2005 年微软又发布了 SQL Server 2005 产品,该产品包括企业版、标准版、工作组版、精简版 4 个版本。

In June 1970, Dr. E. edodd published the paper “a relational model of data for large shared data banks” and proposed the relational model. On June 12, 1979, Oracle company (also known as relational software at that time) released the first commercial SQL relational database. In 1987, Microsoft, Sybase and Ashton Tate jointly developed Sybase SQL server. In 1988, Microsoft, Sybase and Aston Tate transplanted the product to OS / 2. Later, aston.tate company withdrew from the development of the product, while Microsoft company and Sybase company signed a joint development agreement. The result of the joint development of the two companies was the release of SQL server for Windows NT operating system. In 1993, SQL Server was transplanted to Windows NT 3.1 platform, that is, the release of Microsoft SQL Server 4.2. After the release of SQL Server 4, Microsoft company and Sybase company parted ways in the development of SQL server, cancelled the contract and developed their own sol server. Microsoft focuses on the development of SQL Server on Windows NT platform, while Sybase focuses on the development of SQL Server on UNIX platform. SQL Server Version 6.0 is the first version completely developed by Microsoft. In 1996, Microsoft launched solserver version 6.5, and then SQL server version 7.0 with great changes in 1998. This version has undergone fundamental changes in data storage and database engine. After two years of hard work, Microsoft released SQL Server 2000 in September 2000, including enterprise edition, standard edition, development edition and personal edition. The change from SQL Server 7.0 to SQL Server 2000 is gradual, which is not as big as that from 6.5 to 7.0, but is enhanced on the basis of SQL Server 7.0. In 2005, Microsoft released SQL Server 2005 products, which include enterprise version, Standard Version, working group version and compact version.

开发语言

development language

SQL 服务器上的基本交互语言,像其他大部分商业关系型数据库管理系统一样(例如 IBM DB2、Oracle、[nformix)是结构化的查询语言(SQL)。这种语言由于制造商的不同有一些小小的差别,但是语言的绝大部分都遵循了 ANSI 标准。这使得应用程序有很好的可移植性,并且可以和多种流行的数据管理系统交谈。为加强这种功能还支持与开放型数据库连接的驱动。这使得人们可以用更广泛的工具访问 SQL 服务器,如用 Visual Basic,VisualC++和其他。

The basic interactive language on SQL server, like most other business relational database management systems (such as IBM DB2, Oracle, [Informix]) is structured query language (SQL). This language has some small differences due to different manufacturers, but most of the languages follow the ANSI standard. This makes the application very portable, and can talk with a variety of popular data management systems. In order to enhance this function, the driver of connecting with open database is also supported. This enables people to use a wider range of tools to access SQL server, such as visual basic, Visual C + + and others.

特点

characteristic

除了 SQL Server 自己的功能集之外,它还允许使用几种其他的强大的 Microsoft 产品和技术:

In addition to SQL Server’s own feature set, it also allows the use of several other powerful Microsoft products and technologies:

●带有分布式事务处理协调器 Distributed Transaction Coordinator(DTC)的分布式事务处理(可跨越两个不同的数据库)。

Distributed transaction with Distributed Transaction Coordinator (DTC) (can span two different databases).

●数据库复制。

Database replication.

●Web 服务器连接。

● web server connection.

●Windows 2000 事件日志。

Windows 2000 event log.

●多种网络协议。

Various network protocols.

●支持 ODBC

Support ODBC

●使用 Microsoft Transaction Server(MTS)的异类事务处理(不同的数据库系统)。

Heterogeneous transaction processing (different database systems) using Microsoft Transaction Server (MTS).

安全漏洞

Security vulnerabilities

服务器是一个平台,它为网站的架设提供了一个环境。SQL 是安装在服务器上的一个服务,它提供了一个数据库管理平台。通常,一台服务器中安装的组件越多,被入侵的可能性就越大。比方说,需要 SQL Server 支持的论坛程序,就可以从服务器、论坛漏洞、SQL Server 三方面来尝试入侵。

The server is a platform, which provides an environment for the erection of the website. SQL is a service installed on the server, which provides a database management platform. Generally, the more components installed in a server, the more likely it is to be invaded. For example, a forum program that needs SQL Server support can try to invade from three aspects: server, forum vulnerability and SQL server.

SQL Server 也存在很多的漏洞,最高级别的漏洞可以让黑客轻松拿下服务器的系统管理员权限。SQL Server 攻击是 Web 攻击类型中的一种,这种攻击没有什么特殊的要求,只需要对方提供正常的 HTTP 服务即可。

SQL server also has a lot of vulnerabilities, the highest level of vulnerability allows hackers to easily take down the server administrator privileges. SQL Server attack is one of the types of Web attacks. There is no special requirement for this kind of attack. It only needs the other party to provide normal HTTP service.


速搜资源网 , 版权所有丨如未注明 , 均为原创丨转载请注明原文链接:【速搜问答】SQL服务器是什么
喜欢 (0)
[361009623@qq.com]
分享 (0)
发表我的评论
取消评论
表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址