[1]林英建.数据库逻辑设计性能优化关键技术研究[J].计算机技术与发展,2013,(12):74-77.
　LIN Ying-jian.Research on Key Technology of Performance Optimization for Database Logical Structure Design[J].,2013,(12):74-77.
点击复制

数据库逻辑设计性能优化关键技术研究()
分享到：

《计算机技术与发展》[ISSN:1006-6977/CN:61-1281/TN]

卷:
期数:
2013年12期
页码:
74-77
栏目:
智能、算法、系统工程
出版日期:
1900-01-01

文章信息/Info

Title:
Research on Key Technology of Performance Optimization for Database Logical Structure Design
文章编号:
1673-629X（2013）12-0074-04
作者:
林英建
渤海大学 大学计算机教研部
Author(s):
LIN Ying-jian
关键词:
数据库; 逻辑结构设计; 性能; 函数依赖; 第三范式
Keywords:
database; logical structure design; performance; function dependency; 3NF
文献标志码:
A
摘要:
数据库逻辑结构设计是把概念结构转化为具体DBMS所支持的逻辑模型，对初步设计的逻辑模型进行调整、修改和优化，是逻辑结构设计的重要工作。文中从三个方面研究逻辑设计性能优化关键技术。首先，通过四个定义研究消除依赖的方法，包括函数依赖、部分函数依赖、传递函数依赖、第三范式；其次，研究主关键字，包括聚簇索引的创建以及设计主关键字的通用规则；最后，研究关系的分解与合并，其中分解包括水平分解和垂直分解。文中研究的性能优化技术与通常的性能优化技术既有一致性也有冲突，实际运用要通过具体分析采用切实可行的策略
Abstract:
Database logic structure design transforms the conceptual structure into a logical model that supported by specific DBMS,and adjusts,modifies and optimizes the logical model of preliminary design,which is the important work of logical structure design. Study the key technologies of performance optimization for logic design from three aspects. First,through four definition research the method to e-liminate dependency,including function dependency,partial function dependency,transitive function dependency and 3NF. Second,study the primary key,including the creation of clustered index as well as the general rule of design primary key. Finally,study the decomposi-tion and merger of relationship,where the decomposition includes horizontal decomposition and vertical decomposition. This performance optimization techniques studied in this paper both has the consistency and conflict with the usual performance optimization techniques,and should have the practical strategies in practical application

相似文献/References:

[1]王明超 陈榕.基于脚本的客户端软件结构化存储技术研究[J].计算机技术与发展,2010,(02):25.
　WANG Ming-chao,CHEN Rong.Local Structural Storage on Software Based Description Technology[J].,2010,(12):25.
[2]郭秀娟 王春光.基于B／S模式的毕业设计管理系统开发与实现[J].计算机技术与发展,2010,(03):239.
　GUO Xiu-juan,WANG Chun-guang.Development and Implementatin of Graduation Project Management System Based on B/S Mode[J].,2010,(12):239.
[3]刘宏波 罗锐 王永斌.一种采用RBAC模型的权限体系设计[J].计算机技术与发展,2009,(09):154.
　LIU Hong-bo,LUO Rui,WANG Yong-bin.Competence System Based on RBAC Design and Implementation[J].,2009,(12):154.
[4]周爱武 李孙长 程博 夏松.XML数据库的研究与应用[J].计算机技术与发展,2009,(09):218.
　ZHOU Ai-wu,LI Sun-chang,CHENG Bo,et al.Research on XML Database and Its Application[J].,2009,(12):218.
[5]海涛.课程管理系统PowerBuilder实现[J].计算机技术与发展,2009,(02):196.
　HAI Tao.Realization of Courses Management System Based on PowerBuiider[J].,2009,(12):196.
[6]马程.空间聚类研究[J].计算机技术与发展,2009,(04):134.
　MA Cheng.A Survey of Spatial Clustering Research[J].,2009,(12):134.
[7]王福田 汤进 罗斌.带电设备红外辅助诊断系统的开发[J].计算机技术与发展,2009,(04):184.
　WANG Fu-tian,TANG Jin,LUO Bin.Development of Infrared Auxiliary Diagnosis System of Charged Equipments[J].,2009,(12):184.
[8]王君 祝永志 魏榕晖 李丙锋.基于Oracle分布式数据库的查询优化[J].计算机技术与发展,2008,(01):157.
　WANG Jun,ZHU Yong-zhi,WEI Rong-hui,et al.Optimizing of Query Based on Oracle Distributed Database[J].,2008,(12):157.
[9]张玲娟.智能公交实时测控系统中集成监管软件的研制[J].计算机技术与发展,2008,(01):199.
　ZHANG Ling-juan.Development of Integrated Manager Software in Intelligent Realtime- Surveillance System on Bus[J].,2008,(12):199.
[10]谷庆华 李成贵.基于Java语言实现数据库的访问[J].计算机技术与发展,2008,(02):13.
　GU Qing-hua,LI Cheng-gui.Realizing Database Accessing Based on Java[J].,2008,(12):13.

更新日期/Last Update: 1900-01-01