| 关系数据库设计中的数据依赖确定与语义分析 |
| |
| 引用本文： | 程录庆,张智光.关系数据库设计中的数据依赖确定与语义分析[J].计算机与现代化,2008(12):164-168. |
| |
| 作者姓名： | 程录庆 张智光 |
| |
| 作者单位： | 1. 南京林业大学经济管理学院,江苏,南京210042;南京人口管理学院信息科学系,江苏,南京,210042
2. 南京林业大学经济管理学院,江苏,南京210042 |
| |
| 摘 要： | 在关系数据库的设计中,数据依赖的确定是至关重要的,为保证数据的完整性,需要在数据库的设计、录入及维护全过程中保持数据依赖的一致性。数据依赖是关系数据间现实语义约束的一个反映,是属于语义范畴的,它的确定也是基于数据所蕴含的语义。本文结合实例,通过分析数据蕴含的语义,讨论确定关系数据的函数依赖和多值依赖的一般思路和方法,并分析了语义的强制与保持问题,对实际的关系数据库设计有理论参考价值。
|
| 关 键 词： | 关系数据库 数据依赖 语义约束 语义的强制与保持 |
Finding Correct Data Dependency in Relational Database Design and Semantic Analysis |
| |
| CHENG Lu-qing,ZHANG Zhi-guang.Finding Correct Data Dependency in Relational Database Design and Semantic Analysis[J].Computer and Modernization,2008(12):164-168. |
| |
| Authors: | CHENG Lu-qing ZHANG Zhi-guang |
| |
| Affiliation: | CHENG Lu-qing, ZHANG Zhi-guang ( 1. Institute of Economical Management, Nanjing Forest University, Nanjing 210042, China; 2. Nanjing College for Population Programme Management, Nanjing 210042, China) |
| |
| Abstract: | In the relational database design,finding the correct data dependency is very important,for the guarantee data integrity,it is necessary that hold the consistency of data dependency in the entire process of the database design,data input and database maintains.The data dependence reflects the realistic semantic constraints between relational data,belongs to the semantic areas,and finding the correct data dependency is also based on the semantics contained in data.This article discusses the general ideas and methods of finding the correct function dependency and multiple-value dependency among the relational data by some instances,and analyzes semantic forcing and semantic holding questions.It has the theory reference value for the actual relational database design. |
| |
| Keywords: | relational database data dependency semantic constraint semantic forcing and holding |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
