使用PowerDesigner迁移Schema

《使用PowerDesigner迁移Schema》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、SYBASEIQIQ：适合分析型的应用，不适合OLTP等实时更新的事务系统。最多的操作是：复杂即席查询+大量数据装载针对查询，最关键的是索引。索引的设计依据：数据类型，基数和字段上的主要查询类型。2-1SYBASEIQ的架构(3+3)2-2IQ的资源管理层次（3层）CatalogIQTemporaryStoresIQStoreStoreStoreIQ_SYSTEM_MAINUSER_DBSPACESYSTEMIQ_SYSTEM_TEMPdbspacesdbfiles2-3SybaseIQIndex类型2-4推荐索引类型T

2、ypeofQueryUsageRecommendedIndexTypeInaSELECTprojectionlistFPIncalculationexpressionssuchasA+BFPAsAVG/SUMargumentHNG,LF,HG,FPAsMIN/MAXargumentLF,HG,HNGAsCOUNTargumentLF,HGAsCOUNTDISTINCT,SELECTLF,HG,FPDISTINCTorGROUPBYargumentAsanalyticalfunctionargumentLF,FPIffieldd

3、oesnotallowduplicatesLF,HGContinued…2-5推荐索引类型TypeofQueryUsageRecommendedIndexTypeColumnsusedinadhocjoinFP,HG,LFColumnsusedinjoinindexHG,LFAsLIKEargumentinaWHEREclauseFPAsINargumentHG,LFInequalityorinequality(=,!=)HG,LF;alsoCMPInrangepredicateWHEREclause(>,<.>=,<=,LF

4、,HGorHNG;alsoCMP,DATE,BETWEEN)TIME,DTTMInDATEPARTequality,rangeandINlistDATE,TIME,DTTMpredicates2-6数据类型支持的索引类型DataTypeSupportedIndexesUnsupportedIndexestinyintCMP,HG,HNG,LFWD,DATE,TIME,DTTMsmallintCMP,HG,HNG,LFWD,DATE,TIME,DTTMintCMP,HG,HNG,LFWD,DATE,TIME,DTTMunsign

5、edintCMP,HG,HNG,LFWD,DATE,TIME,DTTMbigintCMP,HG,HNG,LFWD,DATE,TIME,DTTMunsignedbigintCMP,HG,HNG,LFWD,DATE,TIME,DTTMnumeric,decimalCMP,HG,HNG,LFWD,DATE,TIME,DTTMdoubleLF(HGpermittedbutnotCMP,HNG,WD,DATE,TIME,DTTMrecommended)2-7数据类型支持的索引类型DataTypeSupportedIndexesUnsup

6、portedIndexesfloatLF(HGpermittedbutnotCMP,HNG,WD,DATE,TIME,DTTMrecommended)realLF(HGpermittedbutnotCMP,HNG,WD,DATE,TIME,DTTMrecommended)bitFPonlyCMP,HG,HNG,LF,WD,DATE,TIME,DTTMdateCMP,HG,HNG,LF,DATEWD,TIME,DTTMtimeCMP,HG,HNG,LF,TIMEWD,DATE,DTTMdatetime,CMP,HG,HNG,LF

7、,DTTMWD,DATE,TIMEtimestamp2-8数据类型支持的索引类型DataTypeSupportedIndexesUnsupportedIndexeschar<=255bytes,CMP,HG,HNG,LF,WDDATE,TIME,DTTMcharacterchar>255bytesCMP,WDHG,HNG,LF,DATE,TIME,DTTMvarchar<=255bytesCMP,HG,HNG,LF,WDDATE,TIME,DTTMvarchar>255bytesCMP,WDHG,HNG,LF,DATE,TIM

8、E,DTTMbinaryCMP,HG,LFHNG,WD,DATE,TIME,DTTMvarbinary<=255bytesCMP,HG,LFHNG,WD,DATE,TIME,DTTMvarbinary>255bytesCMPHG,HNG,LF,WD,DATE,TIME,DTT