s Computer English Chapter 11 Database Management
Computer English Chapter 11 Database Management
Chapter 11 Database Management Key points日 useful terms and definitions of Database Management Difficult points Classification of the logical structuring techniques of DBMS 《什第机专出美语 712
Chapter 11 Database Management 计算机专业英语 11-2 Key points: useful terms and definitions of Database Management Difficult points: Classification of the logical structuring techniques of DBMS
Chapter 11 Database Management Requirements: 1. Principle of easiest penetration 2. The kinds of computer security breaches 3. What is firewall 4.了解英文摘要的写作技巧 《什第机专出美语 713
Chapter 11 Database Management 计算机专业英语 11-3 Requirements: 1. Principle of easiest penetration 2. The kinds of computer security breaches 3. What is firewall 4. 了解英文摘要的写作技巧
Chapter 11 Database Management 11.1 Overview New Words Expressions facilitate使容易,促进 etrieval n检索 field n.字段, record记录 alphabetically按字母顺序地 chronologically按年代顺序排 break down v.分解 build up建造,装配,组成 encyclopedia n 百科全书 reference n.涉及,参考,引用 bibliography书目,参考书目 periodical n期刊,杂志 literature n.文献,著作 professional n专业人员,专家 Abbreviations: 计算机专业英语 114
Chapter 11 Database Management 计算机专业英语 11-4 New Words & Expressions: facilitate 使容易,促进 retrieval n. 检索 field n. 字段, record 记录, alphabetically 按字母顺序地 chronologically按年代顺序排 break down v. 分解 build up 建造,装配,组成 encyclopedia n. 百科全书 reference n. 涉及,参考,引用 bibliography 书目,参考书目 periodical n. 期刊,杂志 literature n. 文献,著作 professional n. 专业人员,专家 11.1 Overview Abbreviations:
Chapter 11 Database Management 11.1 Overview a data base consists of a file or a set of files The informationin these files may be broken down into records, each of which consists of one or more fields. Fields are the basic units of data storage, and each field typically contains information pertaining to one aspect or attribute of the entity described by the database. Using keywords and various sorting commands, users can rapidly search, rearrange, group, and select the fields in many records to retrieve or create reports on particular aggregates of data. 一个数据库由一个文件或文件集合组成。这些文件中的信息可分解成一个 个记录,每个记录有一个或多个域。域是数据存储的基本单位,每个域 般含有由数据库描述的属于实体的一个方面或一个特性的信息。用户使用 键盘和各种排序命令,能够快速查找、重排、分组并在查找的许多记录中 选择相应的域,建立特定集上的报表。 《什第机专出美语 15
Chapter 11 Database Management 计算机专业英语 11-5 A database consists of a file or a set of files. The information in these files may be broken down into records, each of which consists of one or more fields. Fields are the basic units of data storage, and each field typically contains information pertaining to one aspect or attribute of the entity described by the database. Using keywords and various sorting commands, users can rapidly search, rearrange, group, and select the fields in many records to retrieve or create reports on particular aggregates of data. 一个数据库由一个文件或文件集合组成。这些文件中的信息可分解成一个 个记录,每个记录有一个或多个域。域是数据存储的基本单位,每个域一 般含有由数据库描述的属于实体的一个方面或一个特性的信息。用户使用 键盘和各种排序命令,能够快速查找、重排、分组并在查找的许多记录中 选择相应的域,建立特定集上的报表。 11.1 Overview
Chapter 11 Database Management 11.I Overview Database records and files must be organized to allow retrieval of the information. Early systems were arranged sequentially (i. e, alphabetically, numerically, or chronologically); the development of direct-access storage devices made possible random access to data via indexes. Queries are the main way users retrieve data base information. Typically, the user provides a string of characters, and the computer searches the data base for a corresponding sequence and provides the source materials in which those characters appear. a user can request, for example, all records in which the content of the field for a persons last name is the word Smith 数据库记录和文件的组织必须确保能对信息进行检索。早期的系统是顺序 组织的(如:字母顺序、数字顺序或时间顺序);直接访问存储设备的研 制成功使得通过索引随机访问数据成为可能。用户检索数据库信息的主要 方法是 query(查询)。通常情况下,用户提供一个字符串,计算机在数据 库中寻找相应的字符序列,并且给出字符串在何处出现。比如,用户能够 在所有记录中寻找所有 Tlast name域为 Smith的记录 计算机专些英语 11-6
Chapter 11 Database Management 计算机专业英语 11-6 11.1 Overview Database records and files must be organized to allow retrieval of the information. Early systems were arranged sequentially (i.e., alphabetically, numerically, or chronologically); the development of direct-access storage devices made possible random access to data via indexes. Queries are the main way users retrieve database information. Typically, the user provides a string of characters, and the computer searches the database for a corresponding sequence and provides the source materials in which those characters appear. A user can request, for example, all records in which the content of the field for a person’slast name is the word Smith. 数据库记录和文件的组织必须确保能对信息进行检索。早期的系统是顺序 组织的(如:字母顺序、数字顺序或时间顺序);直接访问存储设备的研 制成功使得通过索引随机访问数据成为可能。用户检索数据库信息的主要 方法是query(查询)。通常情况下,用户提供一个字符串,计算机在数据 库中寻找相应的字符序列,并且给出字符串在何处出现。比如,用户能够 在所有记录中寻找所有last name域为Smith的记录
Chapter 11 Database Management 11.1 Overview In flat databases 21, records are organized according to a simple list of entities; many simple data bases for personal computers are flat in structure. The records in hierarchical data bases are organized in a treelike structure, with each level of records branching off into a set of smaller categories. Unlike hierarchical databases, which provide single links between sets of records at dififerent levels network databases create multiple linkages between sets by placing links, or pointers, to one set of records in another; the speed and versatility of network data bases have led to their wide use in business 在非结构化的数据库中,按照实体的一个简单列表组织记录;很多个人 计算机的简易数据库是非结构的。层次型数据库按树型组织记录,每 层的记录分解成更小的属性集。层次型数据库在不同层的记录集之间提 供一个单一链接,与此不同,网络型数据库在不同记录集之间提供多个 链接,这是通过设置指向其它记录集的链或指针来实现的。网络型数据 库的速度及多样性使其在企业中得到广泛应用。 雾语1
Chapter 11 Database Management 计算机专业英语 11-7 In flat databases [2] , records are organized according to a simple list of entities; many simple databases for personal computers are flat in structure. The records in hierarchical databases are organized in a treelike structure, with each level of records branching off into a set of smaller categories. Unlike hierarchical databases, which provide single links between sets of records at different levels, network databases create multiple linkages between sets by placing links, or pointers, to one set of records in another; the speed and versatility of network databases have led to their wide use in business. 在非结构化的数据库中,按照实体的一个简单列表组织记录;很多个人 计算机的简易数据库是非结构的。层次型数据库按树型组织记录,每一 层的记录分解成更小的属性集。层次型数据库在不同层的记录集之间提 供一个单一链接,与此不同,网络型数据库在不同记录集之间提供多个 链接,这是通过设置指向其它记录集的链或指针来实现的。网络型数据 库的速度及多样性使其在企业中得到广泛应用。 11.1 Overview
Chapter 11 Database Management 11.1 Overview Relational data bases are used where associations among files or records cannot be expressed by links; a simple flat list becomes one table, or "relation", and multiple relations can be mathematically associated to yield desired information. Object-oriented databases store and manipulate more complex data structures, called objects", which are organized into hierarchical classes that may inherit properties from classes higher in the chain; this data base structure is the most flexible and adaptable 当文件或记录间的关系不能用链表达时,使用关系型数据库。 个表或一个“关系”,就是一个简单的非结构列表。多个关系可 通过数学关系提供所需信息。面向对象的数据库存储并处理更复 杂的称为对象的数据结构,可组织成有层次的类,其中的每个类 可以继承层次链中更高一级类的特性,这种数据库结构最灵活 最具适应性。 《什第机专出美语 18
Chapter 11 Database Management 计算机专业英语 11-8 Relational databases are used where associations among files or records cannot be expressed by links; a simple flat list becomes one table, or “relation”, and multiple relations can be mathematically associated to yield desired information. Object-oriented databases store and manipulate more complex data structures, called “objects”, which are organized into hierarchical classes that may inherit properties from classes higher in the chain; this database structure is the most flexible and adaptable. 当文件或记录间的关系不能用链表达时,使用关系型数据库。一 个表或一个“关系” ,就是一个简单的非结构列表。多个关系可 通过数学关系提供所需信息。面向对象的数据库存储并处理更复 杂的称为对象的数据结构,可组织成有层次的类,其中的每个类 可以继承层次链中更高一级类的特性,这种数据库结构最灵活, 最具适应性。 11.1 Overview
Chapter 11 Database Management 11.2 DBMS STRUCTURING TECHNIQUES New Words expressions: sequential顺序的,连续的 integrate综合,使成整体 access v.访问 retrieve v.找回,检索 employ v.使用 list structure n链表结构 Invoice I.发票 pointer n指针 hierarchical structure树结构 subordinate adi.从属的 network structure网状结构 relational structure关系结构 physical structure物理结构 Abbreviations DBMs( Data base Management System)数据库管理信息系统 《什第机专出美语 11-9
Chapter 11 Database Management 计算机专业英语 11-9 New Words & Expressions: sequential 顺序的,连续的 integrate 综合,使成整体 access v. 访问 retrieve v.找回,检索 employ v.使用 liststructure n.链表结构 invoice n. 发票 pointer n.指针 hierarchicalstructure 树结构 subordinate adj. 从属的 network structure 网状结构 relationalstructure 关系结构 physicalstructure 物理结构 11.2 DBMS STRUCTURING TECHNIQUES Abbreviations : DBMS(DatabaseManagement System) 数据库管理信息系统
Chapter 11 Database Management 11.2 DBMS STRUCTURING TECHNIQUES DBMS iS able to access and retrieve data from nonkey record fields. That is the dbms is able to structure and tie together the logically related data from several large files DBMS可综合几个文件的数据项以回答用户对信息的查询,这就意味着 DBMS能够访问和检索非关键记录字段的数据,即DBMS能够将几个大文件 中逻辑相关的数据组织并连接在一起 Logical Structures. Identifying these logical relationships is a job of the data administrator. a data definition language is used for this purpose. The DbMs may then employ one of the following logical structuring techniques during storage access, and retrievaloperations Ill 逻辑结构。确定这些逻辑关系是数据管理者的任务,由数据定乂语 言完成。DBMS在存储、访问和检索操作过程中可选用以下逻辑构造技术 《什第机专出美语 1-10
Chapter 11 Database Management 计算机专业英语 11-10 11.2 DBMS STRUCTURING TECHNIQUES DBMS is able to access and retrieve data from nonkey record fields. That is, the DBMS is able to structure and tie together the logically related data from several large files. DBMS可综合几个文件的数据项以回答用户对信息的查询,这就意味着 DBMS能够访问和检索非关键记录字段的数据,即DBMS能够将几个大文件 中逻辑相关的数据组织并连接在一起。 Logical Structures. Identifying these logical relationships is a job of the data administrator. A data definition language is used for this purpose. The DBMS may then employ one of the following logical structuring techniques during storage access, and retrieval operations[1] : 逻辑结构。确定这些逻辑关系是数据管理者的任务,由数据定义语 言完成。DBMS在存储、访问和检索操作过程中可选用以下逻辑构造技术: