首页>国外GIS软件>ESRI ArcGIS应用与开发>[原创]ArcSDE的Featrue Class存储空间分析
回复
« 返回列表
abo123
abo123
外卖仔
外卖仔
  • 注册日期2004-09-16
  • 发帖数67
  • QQ37443636
  • 铜币352枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
阅读：2593回复：9

[原创]ArcSDE的Featrue Class存储空间分析

楼主#
更多 发布于：2006-10-27 15:03
<P ><FONT face="Times New Roman">1 </FONT>问题引出</P>
<P >对于提高<FONT face="Times New Roman">ArcSDE</FONT>的性能，其中的一项内容为（<FONT face="Times New Roman">Oracle</FONT>一直推荐的、<FONT face="Times New Roman">ESRI</FONT>强力建议的）把<FONT face="Times New Roman">index</FONT>和<FONT face="Times New Roman">table</FONT>分开来存储，分不同的磁盘存放。对于<FONT face="Times New Roman">SDE</FONT>来说，在<FONT face="Times New Roman">SDE.DBTUNE</FONT>表中设置<FONT face="Times New Roman">config_string</FONT>来设置。（本节不详细展开，以后会开新贴讨论<FONT face="Times New Roman">ArcSDE</FONT>的调优问题）</P>
<P >这样一来，就产生了一个问题，对于一个一个<FONT face="Times New Roman">featrue class</FONT>来讲，导入数据库后，产生的表和索引是怎样存储的呢，分别占用多大的空间呢？</P>
喜欢0 评分0
举报 回复
abo123
abo123
外卖仔
外卖仔
  • 注册日期2004-09-16
  • 发帖数67
  • QQ37443636
  • 铜币352枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
1楼#
发布于：2006-10-27 15:04
<P 0cm 0cm 0pt"><FONT face="Times New Roman">2 </FONT>测试环境</P>
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Windows 2000 advanced server</FONT>；<FONT face="Times New Roman"> oracle 9i </FONT>；<FONT face="Times New Roman">ArcSDE 9.0</FONT></P>
<P 0cm 0cm 0pt">图层<FONT face="Times New Roman"> BUILDING</FONT>：（<FONT face="Times New Roman">polygon</FONT>）大小，<FONT face="Times New Roman">24.6MB</FONT>。</P>
举报 回复(0) 喜欢(0)     评分
abo123
abo123
外卖仔
外卖仔
  • 注册日期2004-09-16
  • 发帖数67
  • QQ37443636
  • 铜币352枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
2楼#
发布于：2006-10-27 15:08
<P 0cm 0cm 0pt; tab-stops: center 207.65pt"><FONT face="Times New Roman">3 </FONT>分析过程<FONT face="Times New Roman">                                                    </FONT></P>
<P 0cm 0cm 0pt"><FONT face="Times New Roman">A</FONT>：<FONT face="Times New Roman"> ArcCatalog </FONT>导入一建筑物图层。分别查询关于这个图层所有表的磁盘空间占用情况。</P>
<P 0cm 0cm 0pt">默认参数（不指定<FONT face="Times New Roman">GRID SIZE</FONT>）</P>
<P 0cm 0cm 0pt"><FONT face="Times New Roman">B</FONT>：查看表大小：</P>
<P 0cm 0cm 0pt"><FONT face="Times New Roman">select owner ,table_name, NUM_ROWS, BLOCKS*AAA/1024/1024 "Size M", EMPTY_BLOCKS, LAST_ANALYZED from dba_tables where table_name= XXX ; </FONT></P>
<P 0cm 0cm 0pt">　　<FONT face="Times New Roman">Here: AAA is the value of db_block_size ; oracle </FONT>默认为<FONT face="Times New Roman">2048 </FONT>。本次测试为<FONT face="Times New Roman">8096</FONT></P>
<P 0cm 0cm 0pt">　　<FONT face="Times New Roman">XXX is the table name you want to check</FONT></P>
<P 0cm 0cm 0pt"><FONT face="Times New Roman">C</FONT>：查看<FONT face="Times New Roman">index</FONT>大小：</P>
<P 0cm 0cm 0pt"><B>select</B> <B>sum</B>(blocks)*AAA/1024/1024 <B>from</B> dba_extents t <B>where</B>  t.owner=OEWNER' <B>and</B> t.segment_name=XXX<p></p></P>
<P 0cm 0cm 0pt">　<FONT face="Times New Roman">Here: AAA is the value of db_block_size ; oracle </FONT>默认为<FONT face="Times New Roman">2048 </FONT>。本次测试为<FONT face="Times New Roman">8096</FONT></P>
<P 0cm 0cm 0pt; TEXT-INDENT: 21pt"><FONT face="Times New Roman">XXX is the index name you want to check</FONT></P>
<P 0cm 0cm 0pt; TEXT-INDENT: 21pt">实际上这种查询也应该可以对表大小进行查询，只要<FONT face="Times New Roman">t.segment_name</FONT>指定表名称即可。只不过这样查询出的结果比上一种方法查询出的结果稍大。不知道为什么<FONT face="Times New Roman"> :)<p></p></FONT></P>
<P 0cm 0cm 0pt; TEXT-INDENT: 21pt"><p><FONT face="Times New Roman"> </FONT></p></P>
<P 0cm 0cm 0pt; TEXT-INDENT: 21pt"><B normal">注意：如果查询结果为空的话，需要事情对表进行分析（</B><B normal"><FONT face="Times New Roman">analyze</FONT></B><B normal">）</B>。<p></p></P>
<P 0cm 0cm 0pt; TEXT-INDENT: 21pt">方法：<FONT face="Times New Roman">sqlplus user/pass<p></p></FONT></P>
<P 0cm 0cm 0pt; TEXT-INDENT: 21pt"><FONT face="Times New Roman">Analyze table table_name compute statistics;<p></p></FONT></P>
<P 0cm 0cm 0pt; TEXT-INDENT: 21pt"><FONT face="Times New Roman">Analyze index index_name compute statistics;<p></p></FONT></P>
举报 回复(0) 喜欢(0)     评分
abo123
abo123
外卖仔
外卖仔
  • 注册日期2004-09-16
  • 发帖数67
  • QQ37443636
  • 铜币352枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
3楼#
发布于：2006-10-27 15:09
<P 0cm 0cm 0pt"><FONT face="Times New Roman">4 </FONT>结果</P>
<P 0cm 0cm 0pt">对于<FONT face="Times New Roman">ArcSDE</FONT>的一个<FONT face="Times New Roman">featrue class </FONT>而言，导入数据库后生成了三张<FONT face="Times New Roman">table</FONT>，<FONT face="Times New Roman">7</FONT>个<FONT face="Times New Roman">index</FONT>。</P>
<P 0cm 0cm 0pt">分别为：<FONT face="Times New Roman">(</FONT>假设在<FONT face="Times New Roman">sde.layers</FONT>中序号为<FONT face="Times New Roman">100)</FONT></P>
<TABLE medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 100%; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext" cellSpacing=0 cellPadding=0 width="100%" border=1>

<TR 0; mso-yfti-firstrow: yes">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt">名称</P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt">类别</P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt">索引列</P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt">存储空间大小</P></TD></TR>
<TR 1">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">BUILDING</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Table</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><p><FONT face="Times New Roman"> </FONT></p></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="m"><FONT face="Times New Roman">2 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 2">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">-> A100_IX1</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Index</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Shape</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue=".8" UnitName="m"><FONT face="Times New Roman">0.8 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 3">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">->index 162_SDE_ROWID_UK</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Index</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">OBJECTID</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue=".8" UnitName="m"><FONT face="Times New Roman">0.8 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 4">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt; tab-stops: 39.0pt"><FONT face="Times New Roman">F100</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Table</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><p><FONT face="Times New Roman"> </FONT></p></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">9</FONT></P></TD></TR>
<TR 5">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">->F100_AREA_IX2</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Index</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">AREA</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="m"><FONT face="Times New Roman">2 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 6">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">->F100_LEN_IX3</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Index</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">LEN</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="m"><FONT face="Times New Roman">2 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 7">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">->F100_UK1</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Index</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">FID</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue=".8" UnitName="m"><FONT face="Times New Roman">0.8 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 8">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">S100</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Table</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><p><FONT face="Times New Roman"> </FONT></p></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="6" UnitName="m"><FONT face="Times New Roman">6 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 9">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">->S100_IX1</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Index</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">GX,GY,EMAXX,EMAXY,</FONT></P>
<P 0cm 0cm 0pt"><FONT face="Times New Roman">EMINX,EMINY,SP_FID</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="8" UnitName="m"><FONT face="Times New Roman">8 M</FONT></st1:chmetcnv></P></TD></TR>
<TR 10; mso-yfti-lastrow: yes">
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 1pt solid; WIDTH: 42.1%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="42%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">->S100_IX2</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 14.86%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="14%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">Index</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 18.6%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="18%">
<P 0cm 0cm 0pt"><FONT face="Times New Roman">SP_FID</FONT></P></TD>
<TD windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 24.44%; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width="24%">
<P 0cm 0cm 0pt"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="3" UnitName="m"><FONT face="Times New Roman">3 M</FONT></st1:chmetcnv></P></TD></TR></TABLE>
<P 0cm 0cm 0pt"><p><FONT face="Times New Roman"> </FONT></p></P>
举报 回复(0) 喜欢(0)     评分
abo123
abo123
外卖仔
外卖仔
  • 注册日期2004-09-16
  • 发帖数67
  • QQ37443636
  • 铜币352枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
4楼#
发布于：2006-10-27 15:09
<P 0cm 0cm 0pt"><FONT face="Times New Roman">5 </FONT>结论</P>
<P 0cm 0cm 0pt">对于一个<FONT face="Times New Roman"><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="24" UnitName="m">24M</st1:chmetcnv> </FONT>的图层，导入数据库后，总计的存储空间大约为<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="34.4" UnitName="m"><FONT face="Times New Roman">34.4M</FONT></st1:chmetcnv>。</P>
<P 0cm 0cm 0pt">注意，默认情况下，使用的空间索引的<FONT face="Times New Roman">GRID </FONT>为一级。如果这个参数变化<FONT face="Times New Roman"> </FONT>会对<FONT face="Times New Roman">S100</FONT>和<FONT face="Times New Roman">S100</FONT>索引的大小产生非常巨大的影响。（在<FONT face="Times New Roman">SDE</FONT>调优里面讲到）</P>
<P 0cm 0cm 0pt"><p><FONT face="Times New Roman"> </FONT></p></P>
<P 0cm 0cm 0pt">对于整体来说，数据的存储空间增加了<FONT face="Times New Roman">40</FONT>％，表和索引所占的比例大致为<FONT face="Times New Roman">50:50</FONT>。</P>
<P 0cm 0cm 0pt"><p><FONT face="Times New Roman"> </FONT></p></P>
<P 0cm 0cm 0pt">在创建<FONT face="Times New Roman">ArcSDE</FONT>时，首先创建两个存储在不同的磁盘（不是逻辑磁盘，最好是物理分离的磁盘）表，作为<FONT face="Times New Roman">ArcSDE</FONT>表和索引的默认表空间。</P>
<P 0cm 0cm 0pt"><p><FONT face="Times New Roman"> </FONT></p></P>
<P 0cm 0cm 0pt">由于测试图层的不同，数据库参数的设置不同，<FONT face="Times New Roman">ArcSDE</FONT>存储空间会有所不同。现在的数据库磁盘空间已经不再是一个瓶颈（随便哪个数据库都会有<FONT face="Times New Roman">100GB</FONT>），对于一般的应用来说，已经足够了。</P>
举报 回复(0) 喜欢(0)     评分
abo123
abo123
外卖仔
外卖仔
  • 注册日期2004-09-16
  • 发帖数67
  • QQ37443636
  • 铜币352枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
5楼#
发布于：2006-10-27 15:10
欢迎大家 批评指正！
举报 回复(0) 喜欢(0)     评分
cafecat
cafecat
路人甲
路人甲
  • 注册日期2003-07-29
  • 发帖数375
  • QQ
  • 铜币894枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
6楼#
发布于：2006-11-03 10:19
这么好的东西竟然没有人顶，能否介绍一下如何在安装arcsde的过程中安装完后实现将index和table分磁盘存储的呢，最好弄点图片告知如何处理这个问题，谢谢！
http://3s2go.blogspot.com/
举报 回复(0) 喜欢(0)     评分
Joe_ding
Joe_ding
路人甲
路人甲
  • 注册日期2004-04-07
  • 发帖数32
  • QQ
  • 铜币226枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
7楼#
发布于：2006-11-03 15:58
haohao
举报 回复(0) 喜欢(0)     评分
whmwxhanshan123
whmwxhanshan123
路人甲
路人甲
  • 注册日期2006-06-17
  • 发帖数3108
  • QQ
  • 铜币6445枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
8楼#
发布于：2006-11-04 18:22
<img src="images/post/smile/dvbbs/em02.gif" /><img src="images/post/smile/dvbbs/em02.gif" />
举报 回复(0) 喜欢(0)     评分
wjckaxi
wjckaxi
路人甲
路人甲
  • 注册日期2004-04-13
  • 发帖数144
  • QQ
  • 铜币149枚
  • 威望0点
  • 贡献值0点
  • 银元0个
写私信
9楼#
发布于：2006-11-06 12:37
<P>好东西，还没有全部学到，先留个记号！</P>
菜虫 欢迎光临Blog http://blog.sina.com.cn/wjckaxi
举报 回复(0) 喜欢(0)     评分
游客

关于GIS帝国论坛

©2003-2015 phpwind.com 赣ICP备15002320号-1

返回顶部