计算机英语(第三版)7-7.2作者:刘兆毓、郑家农(普通高等教育“十一五”国家级规划教材).ppt
《计算机英语(第三版)7-7.2作者:刘兆毓、郑家农(普通高等教育“十一五”国家级规划教材).ppt》由会员分享,可在线阅读,更多相关《计算机英语(第三版)7-7.2作者:刘兆毓、郑家农(普通高等教育“十一五”国家级规划教材).ppt(19页珍藏版)》请在三一文库上搜索。
1、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
2、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 engines security. IBM released SEQUEL into the public domain, where it became known as SQL. Because of this heritage you ca
3、n pronounce it “sequel” or spell it out “S-Q-L.” There are various versions of SQL used in todays 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 dat
4、abase 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 th
5、e 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 y
6、our 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 serverA collection of data items and supportin
7、g objects organized and presented to facilitate services, such as searching, sorting, recombining, retrieving, updating, and analyzing data. The database consists of the physical storage of data and the database services. All data access occurs through the server; the physical data is never accessed
8、 directly by the client., The clientA software program that might be used interactively by a person or that could be an automated process. This includes all software that interacts with the server, either requesting data from or sending data to the database. Examples are management utilities (those
9、that are part of the SQL Server product as well as those bought separately), ad hoc query and reporting software, custom applications, off-the-shelf applications, and Web server- based applications.2,定语从句,*?3*?4, The communication between the client and the server The communication between the clien
10、t and the server depends largely on how the client and server are implemented. Both physical and logical layers of communication can be identified.3,*?4 On what factors does the communication between the client and server depend ?,*?3 What will do with the server and with the client ?,When you commu
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 计算机 英语 第三 7.2 作者 刘兆毓 郑家农 普通 高等教育 十一 国家级 规划 教材
链接地址:https://www.31doc.com/p-2075117.html