📄 数据库设计中的14个技巧 - sirfei的专栏 - csdnblog.htm
字号:
<P>用“打补丁方法”设计数据库的理论依据。</P>
<P> 14. 提高数据库运行效率的办法<BR> 在给定的系统硬件和系统软件条件下，提高数据库系统的运行效率的办法是：<BR> (1)
在数据库物理设计时，降低范式，增加冗余, 少用触发器, 多用存储过程。<BR> (2)
当计算非常复杂、而且记录条数非常巨大时(例如一千万条)，复杂计算要先在数据库外面，以</P>
<P>文件系统方式用C++语言计算处理完成之后，最后才入库追加到表中去。这是电信计费系统设计的经验。<BR> (3)
发现某个表的记录太多，例如超过一千万条，则要对该表进行水平分割。水平分割的做法是，</P>
<P>以该表主键PK的某个值为界线，将该表的记录水平分割为两个表。若发现某个表的字段太多，例如超过</P>
<P>八十个，则垂直分割该表，将原来的一个表分解为两个表。<BR> (4)
对数据库管理系统DBMS进行系统优化，即优化各种系统参数，如缓冲区个数。<BR> (5)
在使用面向数据的SQL语言进行程序设计时，尽量采取优化算法。<BR> 总之，要提高数据库的运行效率，必须从数据库系统级优化、数据库设计级优化、程序实现级优化</P>
<P>，这三个层次上同时下功夫。</P>
<P> 上述十四个技巧，是许多人在大量的数据库分析与设计实践中，逐步总结出来的。对于这些经验的</P>
<P>运用，读者不能生帮硬套，死记硬背，而要消化理解，实事求是，灵活掌握。并逐步做到：在应用中发</P>
<P>展，在发展中应用。<BR></P><BR><BR>
<P id=TBPingURL>Trackback:
http://tb.blog.csdn.net/TrackBack.aspx?PostId=434994</P><BR></DIV>
<DIV class=postFoot>
<SCRIPT src=""></SCRIPT>
[<A title=功能强大的网络收藏夹，一秒钟操作就可以轻松实现保存带来的价值、分享带来的快乐
href="javascript:d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(saveit=window.open('http://wz.csdn.net/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=590,height=300,left=75,top=20,status=no,resizable=yes'));saveit.focus();">收藏到我的网摘</A>]
[<A
href="http://tb.blog.csdn.net/TrackBack.aspx?PostId=434994">发送Trackback]</A> sirfei发表于
2005年07月26日 09:18:00 </DIV></DIV><LINK
href="http://blog.csdn.net/sirfei/Services/Pingback.aspx" rel=pingback><!--<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"xmlns:dc="http://purl.org/dc/elements/1.1/"xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"><rdf:Descriptionrdf:about="http://blog.csdn.net/sirfei/archive/2005/07/26/434994.aspx"dc:identifier="http://blog.csdn.net/sirfei/archive/2005/07/26/434994.aspx"dc:title="数据库设计中的14个技巧"trackback:ping="http://tb.blog.csdn.net/TrackBack.aspx?PostId=434994" /></rdf:RDF>-->
<SCRIPT>function hide(){showComment();}</SCRIPT>
<BR><BR><BR>
<DIV class=post id=csdn_zhaig_ad_yahoo></DIV>
<SCRIPT type=text/javascript>document.write("<img src=http://counter.csdn.net/pv.aspx?id=24 border=0 width=0 height=0>");</SCRIPT>
<SPAN class=PreAndNext id=viewpost.ascx_PreviousAndNextEntriesDown>
<DIV align=center><A
href="http://blog.csdn.net/sirfei/archive/2005/08/19/458779.aspx">上一篇: document.execComand()参数说明</A> | <A
href="http://blog.csdn.net/sirfei/archive/2005/06/27/404345.aspx">下一篇: MSXML.
xmlhttp 的应用参考</A></DIV></SPAN><SPAN id=Anthem_Comments.ascx_ltlComments__><SPAN
id=Comments.ascx_ltlComments><BR>
<DIV id=comments>
<H3>评论</H3>
<DIV class=post>
<DIV class=postTitle><A title="permalink: 回复:数据库设计中的14个技巧"
href="http://blog.csdn.net/sirfei/archive/2005/07/26/434994.aspx#738674">#</A> <A
name=738674> </A><IMG class=UserStatus id=imgCommentsIsOnline_cpine_738674
alt=""
src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/blank.gif"> cpine 发表于2007-11-05
18:35:31 IP: 218.76.218.*</DIV>
<DIV class=postText>
<TABLE style="TABLE-LAYOUT: fixed">
<TBODY>
<TR>
<TD
style="WORD-WRAP: break-word">对数据库的表的论述非常好啊，也搞懂了很多的东西，谢谢了</TD></TR></TBODY></TABLE></DIV></DIV><BR>
<DIV class=post>
<DIV class=postTitle><A title="permalink: 回复:数据库设计中的14个技巧"
href="http://blog.csdn.net/sirfei/archive/2005/07/26/434994.aspx#738813">#</A> <A
name=738813> </A><IMG class=UserStatus
id=imgCommentsIsOnline_jinhaitao_738813 alt=""
src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/blank.gif"> jinhaitao 发表于2007-11-06
10:56:11 IP: 58.247.209.*</DIV>
<DIV class=postText>
<TABLE style="TABLE-LAYOUT: fixed">
<TBODY>
<TR>
<TD
style="WORD-WRAP: break-word">菜鸟受教了，写得很通俗易懂。谢谢指教！</TD></TR></TBODY></TABLE></DIV></DIV><BR></DIV></SPAN></SPAN>
<SCRIPT language=javascript>
ad_width=468;
ad_height=60;
adcss=2;
unionuser=19;
ad_type='j';
count=5;
</SCRIPT>
<SCRIPT language=javascript
src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/showads.js"
type=text/javascript></SCRIPT>
<SCRIPT language=javascript
src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/showgm.js"
type=text/javascript></SCRIPT>
<DIV id=commentform>
<DIV id=Anthem_PostComment.ascx_CommentUpdatePanel__>
<DIV id=PostComment.ascx_CommentUpdatePanel>
<TABLE cellSpacing=1 cellPadding=1 border=0>
<TBODY>
<TR>
<TD width=75>大名</TD>
<TD><INPUT id=PostComment.ascx_tbName style="WIDTH: 300px" disabled
maxLength=32 size=40 name=PostComment.ascx:tbName></TD>
<TD><SPAN id=PostComment.ascx_RequiredFieldValidator2
style="VISIBILITY: hidden; COLOR: red" initialvalue=""
evaluationfunction="RequiredFieldValidatorEvaluateIsValid"
errormessage="请输入名字"
controltovalidate="PostComment.ascx_tbName">请输入名字</SPAN></TD></TR>
<TR>
<TD>网址</TD>
<TD><INPUT id=PostComment.ascx_tbUrl style="WIDTH: 300px" disabled
maxLength=256 size=40 name=PostComment.ascx:tbUrl></TD>
<TD></TD></TR>
<DIV id=PostComment.ascx_AntiBotImageRegion></DIV>
<TR>
<TD>校验码：</TD>
<TD colSpan=2><INPUT id=PostComment.ascx_tbAntiBotImage
style="WIDTH: 75px" name=PostComment.ascx:tbAntiBotImage> <SPAN
id=PostComment.ascx_valAntiBotImage style="DISPLAY: none; COLOR: red"
evaluationfunction="CustomValidatorEvaluateIsValid"
display="Dynamic">检验码无效!</SPAN> <SPAN
id=Anthem_PostComment.ascx_imgAntiBotImage__><IMG
id=PostComment.ascx_imgAntiBotImage alt=""
src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/AntiBotImage.htm"
align=absMiddle border=0></SPAN> <SPAN
id=Anthem_PostComment.ascx_lbCreateAntiBotImage__><A
id=PostComment.ascx_lbCreateAntiBotImage
onclick="javascript:Anthem_FireCallBackEvent(this,event,'PostComment.ascx:lbCreateAntiBotImage','',false,'','','',true,null,null,null,true,true);return false;"
href="javascript:__doPostBack('PostComment.ascx$lbCreateAntiBotImage','')">看不清,换一张</A></SPAN>
</TD></TR>
<DIV></DIV>
<TR>
<TD colSpan=3>评论 <SPAN id=PostComment.ascx_RequiredFieldValidator3
style="VISIBILITY: hidden; COLOR: red" initialvalue=""
evaluationfunction="RequiredFieldValidatorEvaluateIsValid"
errormessage="请输入评论"
controltovalidate="PostComment.ascx_tbComment">请输入评论</SPAN><BR><TEXTAREA id=PostComment.ascx_tbComment style="WIDTH: 400px; HEIGHT: 193px" disabled name=PostComment.ascx:tbComment rows=10 cols=50></TEXTAREA></TD></TR>
<TR>
<TD><SPAN id=Anthem_PostComment.ascx_btnSubmit__></SPAN></TD>
<TD colSpan=2><SPAN id=PostComment.ascx_Message
style="COLOR: red">当前用户设置只有注册用户才能发表评论。如果你没有登录，请点击<A
href="http://passport.csdn.net/member/UserLogin.aspx?from=http://blog.csdn.net/sirfei/archive/2005/07/26/434994.aspx">登录</A></SPAN></TD></TR></TBODY></TABLE></DIV></DIV></DIV></DIV>
<P id=footer>Powered by: <BR><A id=Footer1_Hyperlink2
href="http://scottwater.com/blog" name=Hyperlink1><IMG
src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/100x30_Logo.gif" border=0></A> <A
id=Footer1_Hyperlink3 href="http://asp.net/" name=Hyperlink1><IMG
src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/PoweredByAsp.Net.gif"
border=0></A> <BR>Copyright © sirfei </P>
<SCRIPT src="数据库设计中的14个技巧 - sirfei的专栏 - CSDNBlog.files/counter.js"></SCRIPT>
<SCRIPT type=text/javascript>
<!--
var Page_Validators = new Array(document.getElementById("PostComment.ascx_RequiredFieldValidator2"), document.getElementById("PostComment.ascx_valAntiBotImage"), document.getElementById("PostComment.ascx_RequiredFieldValidator3"));
// -->
</SCRIPT>
<SCRIPT type=text/javascript>
<!--
var Page_ValidationActive = false;
if (typeof(ValidatorOnLoad) == "function") {
ValidatorOnLoad();
}
function ValidatorOnSubmit() {
if (Page_ValidationActive) {
return ValidatorCommonOnSubmit();
}
else {
return true;
}
}
// -->
</SCRIPT>
</FORM>
<SCRIPT language=javascript type=text/javascript>
<!--
try
{
hide();
}
catch(e){}
//-->
</SCRIPT>
</BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -