分布式数据库数据查询的优化处理方法

284Vol128No14200512JournalofChangchunUniversityofScienceandTechnologyDec.2005:2005-07-20:,(1977-),,,(,130022):,,,,,:;;;:TP3111132:A:1672-9870(2005)04-0085-03OptimizedMethodforDataQueryInDistributedDatabaseLIHuaZHAOJianping(SchoolofComputerScienceandTechnologyofChangchunUniversityofScienceandTechnology)Abstract:ThispaperdiscussesandanalyzesthemodelofdatadistributionindistributeddatabaseonLAN.Theresultindicatestherelationshipsbetweenoptimizedinquireofdataandapplicationenvironment&nodeprocessingabilityinthedistributeddatabasewhichcanaffecttheefficiencyofquery,thenbringsforwardanoptimizedalgorithmmodelbasedonjointwayfortheoveralloptimization.Itcanadvancetheefficiencyeffectivelyofdataqueryunderdistributedenvironment.Keywords:distributeddatabase;query;optimize;model,,,,(DDBS)C/S(/),,,11:(1)SQL,(2),(3),,,(4),,DBMS2©1994-2006ChinaAcademicJournalElectronicPublishingHouse.Allrightsreserved.(FSCODE),,,,,,::S(S#,SNAME,SEX,AGE)104A:C(C#,CNAME)103B:SC(S#,C#,SCORE)105A,100bit;104bit/s;015s;Multimedia,DDBMS,SQL:SELECTS#,SNAMEFROMS,SC,CWHERES1S#=SC1S#ANDSC1C#=C1C#ANDSEX=MANDCNAME=Multimedia:T=C0+(X3C1)=(31)+(/104),:1:CA,:T1(1033100/104)0.16;2:BMultimedia,10,C#AS1SC,Multimedia,:T2(01231031)=2;3:BMultimedia,10,A,A,:T31+(103100)/1041;4:SSCB,B,:T4(2+104+103)3100/1041.7,,R:R,;R,R,,,,,,,,,:68©1994-2006ChinaAcademicJournalElectronicPublishingHouse.Allrightsreserved.:RiRjAFisFjt=st,RiRjA,:(1)RiRjA,RiRjAB(2)RiRjA,BA,A,RiRjB(3)RiRjA,RjRkB,RiARjBRk=(FisAFjsBFks),,sRiRjRk,,,,,,,:(1)1Site0Site1Site2R1R11R12R12R2R21R22(70)78©1994-2006ChinaAcademicJournalElectronicPublishingHouse.Allrightsreserved.[1],.[J].,2000,37(5):97-102.[2],.[J].,2002,46(16):105-110.[3],.Wigner[J].,1997,(11):68-72.[4],.[J].,1996,(9):112-118.[5]KennethRCastleman,,,,.[J].:,1998.[6]ChengFH,HsuWH.ThreestrokeextractionmethodsforrecognitionofhandwrittenChinesecharacters[J].Int.Comput.Symp.,Taiwan,1986,191-195.[7]TsengLY,ChenRC.SegmentationhandwrittenChinesecharactersbasedonheuristicmergingofstrokeboundingboxesanddynamicprogramming[J].PatternRecognitionLetters,1998,19:963-973.[8]ChenHong.SegmentationandrecognitionofcontinuoushandwritingChineseText[J].InternationalJournalofPatternRecognitionandArtificialIntelligence,1998,12(2):223-233.(87),:R11R12R12Site1Site2,,Site0Site2:,Ri,,Ri,Sj,,St(Ri),RijSjSt,St;St,Sj,St0,St0Sj,Ri,,,35,,,,,[1],.[J].,2002,25(3):50-53.[2],,.[J].,2000,23(2):5-8.[4].[M].:,1998.[5].[M].:,1992.[6],.DBMS[J].,1999,(4):31-33.07©1994-2006ChinaAcademicJournalElectronicPublishingHouse.Allrightsreserved.