(完整版)数据库重要术语(中英文)

单词汇总(数据库专业一点的词汇其实主要就是每章后面review items的内容，在这里简单列一下，如果你实在没时间看书，至少这些单词要认识。

)：1. 数据库系统：database system(DS),database ma nageme nt system(DBMS)2. 数据库系统(DS)，数据库管理系统(DBMS)3. 关系和关系数据库table= relation，column = attribute 属性，domain, atomic domain, row= tuple ，relati onal database, relati on schema, relati on in sta nee, database schema, database in sta nee;4. 表=关系，列=属性属性，域，原子域，排=元组，关系型数据库，关系模式，关系实例，数据库模式，数据库实例；1. key 们：super key, can didate key, primary key, foreig n key, referencing relati on, referen ced relati on;2. 超码，候选码，主码，外码，参照关系，被参照关系5. 关系代数(relational algebra): selection, project, natural join, Cartesian product, set operations, union, intersect, set differe nee ( except\m in us), Ren ame, assig nment, outer join, group ing, tuple relati on calculus6. (关系代数)：选择，项目，自然连接，笛卡尔积，集合运算，集，交集，集合差(除负)，重命名，分配，外连接，分组，元组关系演算7. sql组成：DDL :数据库模式定义语言，关键字：createDML :数据操纵语言，关键字：Insert、delete、updateDCL :数据库控制语言，关键字：grant、removeDQL :数据库查询语言，关键字：select8.3. SQL 语言：DDL，DML，DCL，QL，sql query structure, aggregate functions, nested subqueries,exists(as an operator), uni que(as an operator), scalar subquery, asserti on, in dex(i ndices), catalogs, authorization, all privileges, granting, revoking , grant option, trigger, stored procedure, stored fun cti on 4. SQL语言：DDL，DML，DCL，QL，SQL查询结构，聚合函数，嵌套子查询，存在(如运营商)，独特的(如运营商)，标量子查询，断言指数(指数) ，目录，授权，所有权限，授予，撤销，GRANT OPTION，触发器，存储过程，存储函数8. 表结构相关：Integrity constraints, domain constraints, referential integrity constraints9. 完整性约束，域名约束，参照完整性约束5. 数据库设计(ER 模型)：Entity-Relationship data model, ER diagram, composite attribute, sin gle-valuedand multivalued attribute, derived attribute, binary relati on ship set, degree of relati on ship set, mapp ing card in ality, 1-1, 1-m, m-n relati on ship set (one to one, one to many, many to many), participati on, partial or total participati on, weak en tity sets, discrim in ator attributes, specialization andgeneralization6. 实体关系数据模型，ER图，复合属性，单值和多值属性，派生属性，二元关系集，关系集，映射基数的程度，1-1，1-米，MN关系集合(一对一，一对多，多对多) ，参与部分或全部参与，弱实体集，分辨符属性，特化和概化10. 函数依赖理论：functional dependence, normalization, lossless join (or lossless) decomposition,First Normal Form (1NF), the third normal form (3NF), Boyce-codd normal form (BCNF), R satisfies F, Fholds on R, Dependency preservation 保持依赖,Trivial, closure of a set of functional dependencies 函数依赖集的闭包,closure of a set of attributes 属性集闭包,Armstrong 's axioms Armstrong 公理, reflexivity rule 自反律, augmentation rule ，增广率, transitivity 传递律, restriction of F to R i ，F在Ri上的限定，canonical cover 正则覆盖, extraneous attributes 无关属性, decomposition algorithm 分解算法.7. 函数依赖，规范化，无损连接（或无损）分解，第一范式（1NF ），第三范式（3NF ）BC 范式（BCNF ）, R满足F, F持有R，依赖保存，平凡，一组函数依赖封闭，一组属性，8. 事务：transition, ACID properties ACID 特性,并发控制系统concurrency control system, 故障恢复系统recovery system, 事务状态transition state, 活动的active, 部分提交的partiallycommitted, 失败的failed, 中止的aborted , 提交的committed, 已结束的terminated , 调度schedule，操作冲突con flict of operatio ns, 冲突等价con flict equivale nee，冲突可串行化conflict serializablity，可串行化顺序serializablity order,联级回滚cascading rollback,圭寸锁协议lockingprotocol ,共享（S）锁shared-mode lock （S-lock）,排他（X）锁exclusive -mode lock （X-lock）, 相容性compatibility, 两阶段封锁协议2-phase locking protocol, 意向锁intention lock, 时间戳timestamp,恢复机制recovery scheme日志log,基于日志的恢复log-based recovery,延迟的修改deferred modification, 立即的修改immediate modification, 检查点checkpoint.数据库系统DBS Database System数据库系统应用Database -ystem applicati ons文件处理系统file-processing system 数据不一致性data inconsistency 一致性约束consistency constraint 数据抽象Data Abstraction实例instance模式schema物理模式physical schema逻辑模式logical schema物理数据独立性physical data independence数据模型data model实体-联系模型entity-relationship model （E-R）关系数据模型relational data model 基于对象的数据模型object-based data model 半结构化数据模型semistructured data model数据库语言database language数据定义语言data-definition language 数据操纵语言data-manipulation language 查询语言query language元数据metadata应用程序application program规范化normalization数据字典data dictionary存储管理器storage manager 查询管理器query processor 事务transaction原子性atomicity故障恢复failure recovery并发控制concurrency-control 两层和三层数据库体系结构two-tier/three-tier 数据挖掘data mining 数据库管理员DBA database administrator表table关系relation 元组tuple 空值null value 数据库模式database schema 数据库实例database instance 关系模式relation schema 关系实例relation instance 码keys超码super key候选码candidate key主码primary key外码foreign key参照关系referencing relation被参照关系referenced relation 属性attribute 域domain 原子域atomic domain 参照完整性约束referential integrity constraint 模式图schema diagram 查询语言query language 过程化语言procedural language 非过程化语言nonprocedural language 关系运算operations on relations选择元组selection of tuples选择属性selection of attributes自然连接natural join笛卡尔积Cartesian product集合运算set operations 关系代数relational algebraSQL 查询语言SQL query structureSelect 字句select clauseFrom 字句from clauseWhere 字句where clause 自然连接运算natural join operationAs 字句as clauseOrder by 字句order by clause相关名称(相关变量，元组变量) correlation name ( correlation variable ，tuple variable ) 集合运算set operationsUnionInterest Except 空值null values真值“ unknown ” truth “ unknown ” 聚集函数aggregate functions avg，min ，max，sum，count group by having 嵌套子查询nested subqueries 集合比较set comparisons{ 《，《=，》，》=}{some ，all}existsunique lateral 字句lateral clause with 字句with clause 标量子查询scalar subquery 数据库修改database modification删除deletion 插入insertion 更新updating参照完整性referential integrity参照完整性约束referential -ntegrity constraint 或子集依赖subset dependency可延迟的deferrable 断言assertion连接类型join types内连接和外连接inner and outer join 左外连接、右外连接和全外连接left 、right and full outer join Natural 连接条件、using 连接条件和on 连接条件natural using and so on 视图定义view definition 物化视图materialized views 视图更新view update 事务transactions提交commit work 回滚roll back work 原子事务atomic transaction 完整性约束integrity constraints域约束domain constraints 唯一性约束unique constraint Check 字句check clause 参照完整性referential integrity 级联删除cascading delete 级联更新cascading updates 断言assertions 日期和时间类型date and time types 默认值default values 索引index 大对象large object 用户定义类型user-defined types 域domains 目录catalogs 模式schemas 授权authorization 权限privileges选择select插入insert 更新update 所有权限all privileges 授予权限granting of privileges 收回权限revoking of privileges 授予权限的权限privileges to privileges Grant option 角色roles 视图授权authorization on views 执行授权execute authorization 调用者权限invoker privileges 行级授权row-level authorizationJDBCODBC 预备语句prepared statements 访问元数据accessing metadata SQL 注入SQL injection 嵌入式SQL embedded SQL 游标cursors 可更新的游标updatable cursors 动态SQL dynamic SQL SQL 函数SQL functions 存储过程stored procedures 过程化结构procedural constructs 外部语言例程external language routines 触发器triggerBefore 和after 触发器before and after triggers 过渡变量和过渡表transition variables and tables 递归查询recursive queries 单调查询monotonic queries 排名函数ranking functionsRank Dense rankPartition by 分窗windowing 联机分析处理（OLAP ）online analytical processing 多维数据multidimensional data度量属性measure attributes 维属性dimension attributes 转轴pivoting 数据立方体data cube 切片和切块slicing and dicing 上卷和下钻rollup and drill down 交叉表cross-tabulation第七章实体- 联系数据模型Entity-relationship data model 实体和实体集entity and entity set 属性attribute 域domain 简单和复合属性simple and composite attributes 单值和多值属性single-valued and multivalued attributes 空值null value 派生属性derived attribute超码、候选码以及主码super key ,candidate key, and primary key 联系和联系集relationship and relationship set二元联系集binary relationship set 联系集的度degree of relationship set 描述性属性descriptiveattributes 超码、候选码以及主码super key ,candidate key, and primary key 角色role自环联系集recursive relationship setE-R 图E-R diagram 映射基数mapping cardinality 一对一联系one-to-one relationship 一对多联系one-to-many relationship 多对一联系many-to-one relationship 多对多联系many-to-many relationship参与participation全部参与total participation部分参与partial participation弱实体集和强实体集weak entity sets and strong entity sets分辨符属性discriminator attributes标识联系identifying relationship特化和概化specialization and generalization超类和子类superclass and subclass属性继承attribute inheritance单和多继承single and multiple inheritance条件定义的和用户定义的成员资格condition-defined and userdefined membership 不相交概化和重叠概化disjoint and overlapping generalization 全部概化和部分概化total and partial generalization聚集aggregationUMLUML 类图UML class diagram第八章E-R 模型和规范化E-R model and normalization分解decomposition函数依赖functional dependencies无损分解lossless decomposition原子域atomic domains第一范式( 1NF) first normal form(1NF)合法关系legal relations超码super keyR 满足F R satisfies FF在R上成立F holds on RBoyce-Codd 范式BCNF Boyce-Codd normal form(BCNF)保持依赖dependency preservation第三范式( 3NF ) third normal form(3NF)平凡的函数依赖thivial functional dependencies函数依赖集的闭包closure of a set of functional dependenciesArmstrong 公理Armstrong ‘s axioms属性集闭包closure of attribute setsF 在Ri 上的限定restriction of F to Ri正则覆盖canonical cover无关属性extraneous attributesBCNF 分解算法BCNF decomposition algorithm3NF 分解算法3NF decomposition algorithm多值依赖multivalued dependencies第四范式( 4NF )fourth normal form(4NF)多值依赖的限定restriction of a multivalued independency投影-连接范式( PJNF ) project-join normal form(PJNF)域-码范式( DKNF ) domain-key normal form(DKNF)泛关系universal relation 唯一角色假设unique-role assumption 去规范化denormalization。