SQL Server毕业论文外文翻译.doc

英文原文Sql Server SQLSQL is Structured Query Language English acronym, which means for the Structured Query Language SQL language is the main function of establishing ties with the various databases, for communication In accordance with ANSI (American National Standards Institute) requirements, SQL as a relational database management system standard language SQL statements can be used to implement a wide range of operations, such as updating the data in the database, extract data from the database and so on At present， the vast majority of the popular relational database management systems such as Oracle， Sybase， Microsoft SQL Server， Access， adopted the standard SQL language Although many databases on the SQL statement for the redevelopment and expansion， but including the Select， Insert， Update， Delete， Create， and Drop， including the standard SQL commands can be used to complete almost all the database operations SQL Server SQL Server is a relational database management system It was originally proposed by Microsoft Sybase and Ashton-Tate three companies jointly developed in 1988 with the introduction of the first OS / 2 version After the introduction of Windows NT in, Microsoft and Sybase in the development of SQL Server on the split, Microsoft will migrate to SQL Server on Windows NT system, focusing on promoting the development of SQL Server version of Windows NT Sybase is more focused on SQL Server in the UNIX operating system applications SQL Server 2005 is Microsoft Launches the SQL Server database management system, the inherited version of SQL Server 70 version of the merits, at the same time it increases than many of the more advanced features Good scalability with ease of use and related high degree of software integration, across from the running Microsoft Windows 98 laptop running Microsoft Windows 2000 large-scale multi-processor servers such as the use of multiple platforms SQL Server 2005? SQL Server 2005 is a comprehensive database platform, the use of integrated business intelligence (BI) tools to provide enterprise-class data management SQL Server 2005 relational database engine for data and structured data to provide a more secure and reliable storage function that allows you to build and manage high availability for business and high-performance data applications SQL Server 2005 data engine is the enterprise data management solutions for the core The SQL Server 2005 combines the analysis, reporting, integration and notifications This makes your business can build and deploy cost-effective BI solutions that help your team through the Scorecard, Dashboard, Web services and data applications to mobile devices to all areas of business With Microsoft Visual Studio, Microsoft Office System and the new development kit (including the Business Intelligence Development Studio) to enable the close integration of SQL Server 2005 unique Whether you're a developer, database administrator, information worker or decision-makers, SQL Server 2005 that can provide you with innovative solutions to help you benefit from more data Edit this paragraph Microsoft SQL Server 2005 SQL Server 2005 is a major product version, it introduced many new features and key improvements made to date it has become the strongest and most comprehensive version of SQL Server The article described in detail in Microsoft SQL Server 2005's new features, advantages and features Microsoft's data platform to meet these data explosion and the next generation of data-driven applications that demand and support the data platform vision： mission-critical enterprise data platform, dynamic development, relational data and business intelligence Microsoft data platform vision SQL Server's vision Many factors have led to an explosion of information storage A new type of information, such as pictures and digital video, and RFID tags obtained from the sensor information, the company's digital information in the rapid growth of the number Compliance with the norms and requirements of the development of globalization, the security of information storage and are available at any time At the same time, the cost of disk storage significantly reduced so that every dollar invested can store more data Users to move quickly in a large amount of data to find relevant information In addition, on any device they want to use this information, and plan to use every day, such as the Microsoft Office system applications The explosion of data and user expectations for an increase in the management of the company has created many challenges Microsoft ? data platform vision to provide a solution to meet these needs, this solution is companies can store and manage the use of many data types, including XML, e-mail, time / calendar, files, documents, geographic, etc, at the same time provide a rich set of services to interact with the data： search, query, data analysis, reporting, data integration, synchronization and powerful Users can access from the creation to archive to any device, from desktop to mobile devices SQL Server 2005 new features The platform has the following characteristics： Trusted - allows the company can be a very high security, reliability and scalability to run their most mission-critical applications Efficient - allows the company to reduce development and management of their data infrastructure of the time and cost Intelligence - provides a comprehensive platform for users in your time of need to send him to observe and information A trusted (A) the protection of your information In the past the basis of SQL Server 2005 on, SQL Server 2005 made the following enhancements to expand its security： * Simple data encryption SQL Server 2005 can be the entire database, data files and log files for encryption, without requiring changes to applications Encrypt enable companies to meet compliance with the norms and their concern about data privacy requirements Simple and the benefits of data encryption, including the use of any scope or ambiguous search query data encryption to enhance data security to prevent unauthorized user access, as well as data encryption These can change the applications have been conducted * Foreign key management SQL Server 2005 for the encryption and key management provides a comprehensive solution In order to meet evolving data center for more information on the needs of security, to the supplier's investment company to manage the security key SQL Server 2005 by supporting third-party key management and hardware security module (HSM) products to provide for the needs of a very good support * Enhanced the review SQL Server 2005 allows you to review the operation of your data, resulting in improved compliance and security Review of more than modification of data, including all of the information, but also on the data when reading the information SQL Server 2005 as server with enhanced configuration and management review of such a function, which allows the company to meet the needs of a variety of norms SQL Server 2005 can also define a database review of each specification， so the review can be configured for each separate database for the development For a specific configuration object for the review so that review of the implementation of better performance, higher flexibility in configuration (Ii) to ensure business sustainability * Improved database mirroring SQL Server 2005 on SQL Server 2005, and provides a more reliable database mirroring to enhance the platform The new features include： Automatic page repair SQL Server 2005 through a request for cooperation from the mirror to be the wrong machine to copy pages to the main computer and the image can be transparent to repair the data page 823 and 824 errors To improve performance SQL Server 2005 reduced the output of the log stream in order to enable database mirroring the network bandwidth required to achieve the minimum Edit this paragraph SQL Server Analysis Server Install SQL Server 2005 the previous version, for example, there is generally no more than 70 version, only the Standard Edition with the desktop version, users who do not know what version of the equipment, the installation can be a prerequisite for the installation instructions to install, usually in WIN2000 Server Edition's Wear Standard Edition, and other systems installed on the desktop version of the can; and SQL Server 2005 installed on the larger issues, when the common issues are as follows： (1) interruption of server configuration (2) when the interruption of registered ActiveX (3) show that 100% of the time to interrupt (4) prompt： command line option syntax error, type command /? For help, continue with the installation, the last time in there to configure the server： can not find the specified dynamic-link SQLUNIRLDLL path (5) before the procedure to create a pending file operations, before running Setup, you must restart the (1) (2) (3) solution： Reminder： In order to avoid misoperation the first database backup into the registry and can not SQL Server 2005, can be backup Program Files Microsoft SQL Server MSSQL Data folder of the document 1, first uninstall SQL Server (uninstall does not matter can not continue to operate below) 2, the Microsoft SQL Server to delete the entire folder 3, run the registry, delete the following items： HKEY_CURRENT_USER Software Microsoft Microsoft SQL Server HKEY_LOCAL_MACHINE SOFTWARE Microsoft Microsoft SQL Server HKEY_LOCAL_MACHINE SOFTWARE Microsoft MSSQLServer 4, if necessary, restart the system on 5, re-install Can also try to run the installation of single-step method of SQL Server 2005： 1： Add SQL Server 2005 CD-ROM 2： In the "Start" - "Run" type "F： x86 setupexe k = dbg" (F is the CD-ROM) Note： First, different operating systems support SQL Server 2005 version and hardware requirements Windows 2000 Server can be installed any SQL Server 2005 version Windows 2000 Professional can only install SQL Server 2005 Personal Edition, Developer Edition, Evaluation, MCDE Two, SQL Server 2005 versions and hardware requirements (4) solution Because the path of installation files (full path), there are Chinese For example， c： SQLSERVER Chinese Enterprise Edition Changed to c： SQLSERVER (5) solution a, restart the machine and then install， if there is the error， follow these steps b, at the beginning -> Run, type regedit c, to HKEY_LOCAL_MACHINE SYSTEM CurrentControlSet Control Session Manager position d, select the file -> Pour out the preservation e, in the right window right-click PendingFileRenameOperations, select Delete, and then confirmed f, restart the installation, problem-solving If the problem remains, try to repair the operating system Under the command prompt： Sfc / scannow Finally, the method： for Windows 2000 installation disk and installation disk SQL Server2000 Sometimes the cause of the problem is very strange that someone has to replace a power supply to solve the problem 1 to uninstall your SQL Server 2005, the time necessary to delete Program Files Microsoft SQL Server folder 2 Open the registry In the "Start" - "Run", type "regedit" 3 clicks to open in the following order + HKEY_LOCAL_MACHINE + SOFTWART + Microsoft + Windows + CurrentVersion + Setup + ExceptionComponents 4 ExceptionComponents the following to delete all folders! Such as (60BFF50D-FB2C-4498-A577-C9548C390BB9) (60BFF50D-FB2C-4498-A577-C9548C390BB9) (60BFF50D-FB2C-4498-A577-C9548C390BB9) (60BFF50D-FB2C-4498-A577-C9548C390BB9) 5to restart： 6 re-install SQL Server 2005中文译文SQL Server SQL是英文Structured Query Language的缩写,意思为结构化查询语言。SQL语言的主要功能就是同各种数据库建立联系，进行沟通。按照ANSI(美国国家标准协会)的规定，SQL被作为关系型数据库管理系统的标准语言。SQL语句可以用来执行各种各样的操作，例如更新数据库中的数据，从数据库中提取数据等。目前，绝大多数流行的关系型数据库管理系统，如Oracle， Sybase， Microsoft SQL Server， Access等都采用了SQL语言标准。虽然很多数据库都对SQL语句进行了再开发和扩展，但是包括Select， Insert， Update， Delete， Create，以及Drop在内的标准的SQL命令仍然可以被用来完成几乎所有的数据库操作。 SQL Server SQL Server 是一个关系数据库管理系统。它最初是由Microsoft Sybase 和Ashton-Tate三家公司共同开发的，于1988 年推出了第一个OS/2 版本。在Windows NT 推出后，Microsoft与Sybase 在SQL Server 的开发上就分道扬镳了，Microsoft 将SQL Server 移植到Windows NT系统上，专注于开发推广SQL Server 的Windows NT 版本。Sybase 则较专注于SQL Server在UNIX 操作系统上的应用。 SQL Server 2005 是Microsoft 公司推出的SQL Server 数据库管理系统，该版本继承了SQL Server 70 版本的优点，同时又比它增加了许多更先进的功能。具有使用方便可伸缩性好与相关软件集成程度高等优点，可跨越从运行Microsoft Windows 98 的膝上型电脑到运行Microsoft Windows 2000 的大型多处理器的服务器等多种平台使用。 SQL Server 2005？ SQL Server 2005 是一个全面的数据库平台，使用集成的商业智能 (BI) 工具提供了企业级的数据管理。SQL Server 2005 数据库引擎为关系型数据和结构化数据提供了更安全可靠的存储功能，使您可以构建和管理用于业务的高可用和高性能的数据应用程序。 SQL Server 2005 数据引擎是本企业数据管理解决方案的核心。此外 SQL Server 2005 结合了分析、报表、集成和通知功能。这使您的企业可以构建和部署经济有效的 BI 解决方案，帮助您的团队通过记分卡、Dashboard、Web services 和移动设备将数据应用推向业务的各个领域。 与 Microsoft Visual Studio、Microsoft Office System 以及新的开发工具包（包括 Business Intelligence Development Studio）的紧密集成使 SQL Server 2005 与众不同。无论您是开发人员、数据库管理员、信息工作者还是决策者，SQL Server 2005 都可以为您提供创新的解决方案，帮助您从数据中更多地获益。 微软SQL Server 2005 SQL Server 2005是一个重大的产品版本，它推出了许多新的特性和关键的改进，使得它成为至今为止的最强大和最全面的SQL Server版本。这篇文章详细介绍了Microsoft SQL Server 2005中的新的特性、优点和功能 微软的这个数据平台满足这些数据爆炸和下一代数据驱动应用程序的需求，支持数据平台愿景：关键任务企业数据平台、动态开发、关系数据和商业智能。 Microsoft数据平台愿景 SQL Server的愿景 许多因素致使产生了信息存储爆炸。有了新的信息类型，例如图片和视频的数字化，和从RFID标签获得的传感器信息，公司的数字信息的数量在急剧增长。遵守规范和全球化的发展要求信息存储的安全性和在任何时候都可用。同时，磁盘存储的成本显著地降低了，使得公司投资的每一美元可以存储更多的数据。用户必须快速的在大量的数据中找到相关的信息。此外，他们想在任何设备上使用这个信息，并且计划每天使用，例如Microsoft Office系统应用程序。对数据爆炸和用户期望值的增加的管理为公司制造了许多挑战。 Microsoft? 数据平台愿景提供了一个解决方案来满足这些需求，这个解决方案就是公司可以使用存储和管理许多数据类型，包括XML、e-mail、时间/日历、文件、文档、地理等等，同时提供一个丰富的服务集合来与数据交互作用：搜索、查询、数据分析、报表、数据整合，和强大的同步功能。用户可以访问从创建到存档于任何设备的信息，从桌面到移动设备的信息 SQL Server 2005新功能 这个平台有以下特点： 可信任的使得公司可以以很高的安全性、可靠性和可扩展性来运行他们最关键任务的应用程序。 高效的使得公司可以降低开发和管理他们的数据基础设施的时间和成本。 智能的提供了一个全面的平台，可以在你的用户需要的时候给他发送观察和信息。 一、可信任的 1保护你的信息 在过去的SQL Server 2005的基础之上，SQL Server 2005做了以下方面的增强来扩展它的安全性： * 简单的数据加密 SQL Server 2005可以对整个数据库、数据文件和日志文件进行加密，而不需要改动应用程序。进行加密使公司可以满足遵守规范和及其关注数据隐私的要求。简单的数据加密的好处包括使用任何范围或模糊查询搜索加密的数据、加强数据安全性以防止未授权的用户访问、还有数据加密。这些可以在不改变已有的应用程序的情况下进行。 * 外键管理 SQL Server 2005为加密和密钥管理提供了一个全面的解决方案。为了满足不断发展的对数据中心的信息的更强安全性的需求，公司投资给供应商来管理公司内的安全密钥。 SQL Server 2005通过支持第三方密钥管理和硬件安全模块(HSM)产品为这个需求提供了很好的支持。 * 增强了审查 SQL Server 2005使你可以审查你的数据的操作，从而提高了遵从性和安全性。审查不只包括对数据修改的所有信息，还包括关于什么时候对数据进行读取的信息。SQL Server 2005具有像服务器中加强的审查的配置和管理这样的功能，这使得公司可以满足各种规范需求。SQL Server 2005还可以定义每一个数据库的审查规范，所以审查配置可以为每一个数据库作单独的制定。为指定对象作审查配置使审查的执行性能更好，配置的灵活性也更高。 2确保业务可持续性 * 改进了数据库镜像 SQL Server 2005基于SQL Server 2005，并提供了更可靠的加强了数据库镜像的平台。新的特性包括： 页面自动修复。SQL Server 2005通过请求获得一个从镜像合作机器上得到的出错页面的重新拷贝，使主要的和镜像的计算机可以透明的修复数据页面上的823和824错误。 提高了性能。SQL Server 2005压缩了输出的日志流，以便使数据库镜像所要求的网络带宽达到最小。 SQL Server 服务