΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000 Vol.19 No.2 P.45-47




ͼӦвΣϵDBMSʵͼά
Ԫ䡡ܲ
ժ Ҫ ˻ڲΣϵģ͵ͼƣOEMģΪһά㷨
ؼʣ GIS ʵͼ 󽻻ģ Σϵģ ά
ϢϵͳGISĺǵݿ⣬ҪͼʵݺռԵĿռݡռܴҾжλԵԣѡʵģϵͳܵĹؼǲòΣϵĻģͣͼ1ʾͼĻϢϲϵڵͼеĸ²ϵ̻Ƚ˲ģ͵ĿռóĹϵݿ⼼ߵϢϵͳܡ
ͼviewͨѯ䶨Ĵ1ԴеıڷֲʽͼӦУͼݵ󣬻Ҫ򳣹ϢĲѯӲѯռԼĻʾӦʵͼƣڿͻ˱һԭʼݵĸԼ紫ɣߵͼӦõܡͳĹϵģݿϵĲѯķֵʵǽṹġСݿ⡣ΣϵģǸģͣͬʱεָṹݺͳϵıṹݡǿ䶨ʵͼSQL䣬֤ʵͼԭʼݵĽṹһԡʵͼضģ͡ǽö󽻻ģͣOEMΪмģͣ۲Σϵݿϵʵͼƺά㷨
1 DM2еĶ󽻻ģ
󽻻ģOEMģͣѹ㷺칹ݿ⼯ɵмģ͡DM2OEMΪʵʵͼĸģͣԼ򻯻ģϵĸӲÿһobject1Ԫ飼OIDlabeltypevalueʾOIDȫΨһıʶlabelǶԶtypeintegerstringԭͣҲǼͣset͵ֵһЩOIDļϡOEMģͿֻ1ڵͼʾӸڵԱͼһڵ㡣
DM2жڹϵģͣǿørootʾϵÿӾǹϵеÿԪ飬Ϊtupleιϵͼ2еĸӹϵΣϵģ;תΪOEMģ͡
1OEMģͼ2еĲΣϵݿ⣨Ϊ˱ʾȥԪеͺֵ2򣩡

ͼ1-ϵģ

ͼ2-ϵݿ

ͼ3OEMģͼ2Ĳһϵݿ
ROOT1͵Ķ2ӣֱͼ2ͼN1L1ԭ͡labeloʾıעvalueoʾoֵlabelM11tuplevalueM11N1L1ΪͼƵ¶塣
1һ·pathעlabel͵ŽеУpl1l2lnriverR2һ·
2NpʾܴӶN·pﵽĶļϡN2N1pN1N2ȣancestorN2N11descendentpеĵһעN1ĶӣһעN2ıעͬN2N1p1N3N2p2N3N1p1p2ͼ3УڵM12ǽڵROOTĺԴROOTڵ㾭·rivertupleM12 ROOTrivertuple
3͵ĶɽмϲunionS1S2ʾ1ֵΪvalueS1valueS2ĶS1S2Ǽ͵Ķ󡣶intS1S2ʾֵΪvalueS1valueS2Ķ
2 ͼʵͼ
ķʽĲѯͼ
SELECT OBJSelpathexp X
FROM DB
WHERE condXcondpathexp
ϵͳѯ·OBJSelpathexpܵõĶ󣬵condXcondpathexpʱANSanswersetvalueANSͼ
DM2аѽԭĲOBJSelpathexpܹ1ΣϵṹĽݿ⡣òѯʵֵͼΪ
define view MapView as 
SELECT ROOTriver* X 
FROM MAP 
WHERE Xlength250 
ͼ1VviewsetvalueVʾ
ʵ廯ͼʵֵͼͨϴ洢ͼ̶ݣٲѯʱ䡣ݲֿ͵ݻصĸӲѯкܴơ
¶ͼжOID·ķʽͼṹԭݿṹһԣʹʵͼȻ1Σϵݿ⡣1¶XͼVʱXOIDΪVX 
2ʵͼ¡ 
define mview MMAPVIEW as 
SELECT ROOTrivertuple X 
FROM MAP 
WHERE Xlength250
õͼʾ
ͼ4ʾ

ͼ4ʵͼ

ͼ5ʵͼ
Ȼͼֻ1Ҷڵ㣬ҶڵOIDѳֱԭݿĲνṹ
3 ʵͼά
ʵͼϵͳάۣϵͳʵͼ֮Դı仯ͨˢʵͼݻάķʵͼԴһԡһ£άĴСˢʵͼĴۡ
3ֻ£
1insertN1N2N2OID뵽valueN1N1ǼͣɺN2ΪN1Ķӡ
2deleteN1N1N2OIDvalueN1ɾǰN2N1Ķӡ
3modifyNoldvnewvԭ͵ĶoldvΪnewv
1ݿִиinserM1M13ʱM13ֻǸն󣬶ʵͼûӰ졣ִиinsertM13L13L13ʾL13lengthinterger350ʱʵͼܵӰ죬ͼ5ʾĻ²һִеĲ¡ͬɾ1ĳʱcondXcondpathexpôԵĳȶҪɾ㷨1ǸOEMԣⱻ¶ʵͼжӦȣȻȽи¡
㷨ͼMVά


ע⵽1ڵ㵽1ڵֻ1·pathN1N2ʾN1N2·N1N2ȣpathN1N2 Ϊ㷨1¶壺1ancestorNpʾNXpathXNpĶancestorNp 2evalNpcondNpcondNpжļϡûжʱ 3VinsertVN1VN2ʾVN2뵽valueVN1СVN2ѾvalueVN1Уòԡ4VdeleteVN1VN2ʾVN2valueVN1ɾvalueVN1вVN2òԡ 
2ݿִinsertM1M13ʱͼø£ִinsertM13L13ʱͼά̽㷨1ִ²裺
1⵽ͼ²insertM13L132ΪpathROOTM13rivertupleselpathrivertuplecondpathlengthselpathcondpathpathROOTM13labelL13pʱp գ
3SevalL13գcondL13L13SУΪvalueL13350250˶L13Ĳ뽫ʹL13ĳҪͼ4YancestorL13lengthM13ִVinsertMMAPVIEWMMAPVIEWM13ʱMMAPVIEWM13ΪͼMMAPVIEWĶӡ 
˵ͼӦвΣϵģϵʵͼʵ֣˻OEMʵͼά㷨ݿʵͼӦñԴĲΣϵṹ󽻻ģOEMձ칹ݼɵмģͣͬʱܹΪģ͵ݿϵмģʹͼʵָͳһȻʹͬһͼܴӲͬṹԴʵͼ˵ͼӦϵͳӦԣȱҪģת
Ԫ䣨ѧݿý弼о430074
ܲѧݿý弼о430074
ոڣ19990821
