《计算机专业英语实用教程 教学课件 ppt 作者 梁晓晖 计算机专业英语（数据库1）》由会员分享，可在线阅读，更多相关《计算机专业英语实用教程 教学课件 ppt 作者 梁晓晖 计算机专业英语（数据库1）（18页珍藏版）》请在金锄头文库上搜索。
1、计算机专业英语,公欲成其事，必先利其器。,制作：梁晓晖 联系方式：,Unit Three Database,Keywords： definition 定义 architecture 体系结构 database 数据库 database management system 数据库管理系统 conceptual 概念上的 relational database model 关系型数据库模型 DBMS 数据库管理系统,Passage One Database Overview,Unit Three Database,Keywords： security 安全 backup 备份 query 查询 e
2、ntry 条目 update 升级 fetch 读取 execute 执行,Passage One Database Overview,Unit Three Database,Keywords： interpret 解释 optimizer 优化程序，优化器 transaction 事务 table 表 index 索引 referential integrity constraint 引用完整性约束,Passage One Database Overview,Unit Three Database,Keywords： Data Definition Language 数据定义语言 Data
3、Control Language 数据控制语言 Data Manipulation Language 数据操作语言 retrieve 检索 commit 提交 rollback 回滚 recovery 恢复 data warehouse 数据仓库,Passage One Database Overview,Unit Three Database,Keywords： analytical 分析的 distributed 分布式的 hypermedia 超媒体 analogous 相似的 object-oriented data model 面向对象数据库模型,Passage One Databa
4、se Overview,Word-building ： 连字符构词法 两个词语通过连字符“-”连接在一起， 构成一个包含该两个词语含义的 合成词。 例如：object-enhanced post-relational pre-relational等等,Unit Three Database,Passage One Database Overview,Sentences ： Clearly separating the three levels was a major feature of the relational database model that dominates 21st cen
5、tury databases.,Unit Three Database,Passage One Database Overview,Sentences ： It provides a common view of the database that is uncomplicated by details of how the data is stored or managed, and that can unify the various external views into a coherent whole.,Unit Three Database,Passage One Database
6、 Overview,Sentences ： A database management system (DBMS) consists of software that operates databases, providing storage, access, security, backup and other facilities.,Unit Three Database,Passage One Database Overview,Sentences ： Database management systems can be categorized according to the data
7、base model that they support, such as relational or XML, the type(s) of computer they support, such as a server cluster or a mobile phone, the query language(s) that access the database, such as SQL or XQuery, performance trade-offs, such as maximum scale or maximum speed or others.,Unit Three Datab
8、ase,Passage One Database Overview,Sentences ： These drivers are code libraries that provide methods to prepare statements, execute statements, fetch results, etc. Examples include ODBC, JDBC, MySQL/PHP, FireBird/Python.,Unit Three Database,Passage One Database Overview,Sentences ： Object DBMS (ODBMS
9、) has transaction and storage components that are analogous to those in an RDBMS.,Unit Three Database,Passage One Database Overview,Sentences ：,Unit Three Database,Passage One Database Overview,Examples include customer databases that record contact, credit, and demographic information about a busin
10、ess customers, personnel databases that hold information such as salary, benefits, skills data about employees, manufacturing databases that record details about product components, parts inventory, and financial databases that keep track of the organizations money, accounting and financial dealings
11、.,Sentences ： Codds Information Principle, which requires that all information in the database must be cast explicitly in terms of values in relations and in no other way.,Unit Three Database,Passage One Database Overview,Sentences ： Some of these extensions to the relational model integrate concept
12、s from technologies that pre-date the relational model.,Unit Three Database,Passage One Database Overview,Sentences ： Paradoxically, this allows products that are historically pre-relational, such as PICK and MUMPS, to make a plausible claim to be post-relational.,Unit Three Database,Passage One Dat
13、abase Overview,Sentences ： Others have attacked the problem from the database end, by defining an object-oriented data model for the database, and defining a database programming language that allows full programming capabilities as well as traditional query facilities.,Unit Three Database,Passage One Database Overview,
