计算机英语(第三版)7-7.2作者刘兆毓、郑家农(普通高等教育“十一五”国家级规划教材).pptVIP

计算机文化基础 * PART Ⅲ APPLICATIONS CHAPTER 7 DATABASE 7.2 SQL AND SQL SERVER chapter 7-7.2 *Main point Main point: ● Development of SQL ● Client/Server architecture 7.2 SQL AND SQL SERVER IBM invented a computer language back in the 1970s designed specifically for database queries called SEQUEL; those letters stand for Structured English Query Language. Over time, the language has been added to so that it is not just a language for queries, but can also build databases and manage the database engine’s security. IBM released SEQUEL into the public domain, where it became known as SQL. Because of this heritage you can pronounce it “sequel” or spell it out “S-Q-L.” There are various versions of SQL used in today’s database engines. 结果状语从句 定语从句 *?1 Microsoft SQL Server uses a version called Transact-SQL, or T-SQL, which stands for Transaction SQL. 1. What Is SQL Server? SQL Server is a client/server relational database management system (RDBMS) that uses Transact-SQL to send requests between a client and SQL Server. 2. Client/Server Architecture The terms client, server, and client/server can be used to refer to very general concepts or to specific items of hardware or software. *?1 ● How does SEQUEL become the SQL ? *?2 At the most general level, a client is any component of a system that requests services or resources from other components of a system. A server is any component of a system that provides services or resources to other components of a system. For example, when you print a document from your workstation on a network, the workstation is the client and the machine that does the print spooling is the server.［1］ *?2 ● What is client and what is server ? 定语从句 定语从句 定语从句 Any client/server data-based system consists of the following components: ● The server—A collection of data items and supporting objects organized and presented to faci