ѧ
JOURNAL OF SOFTWARE
1999 10 8 Vol.10 No.8 1999



ϵͶݿϵͳIS-Globalʵ
ʤӻΡޡݺ
ժҪҪIS-Global˼͹ؼʵּ.IS-GlobalһϵͶݿϵͳ,ĿΪCIMS(computer integrated manufacture system)ҵӦṩһɵġ硢ϵͳݿϵͳ칹ԵȫϢϵͳ.IS-GlobalҪصǣ(1) һϵϵͳ,ͳһȫģʽ,ԲͬĹϵݿϵͳ,Oracle,SybaseSQL(structured query language) Serverȿɽ͸.(2) IS-Globalͻ/ṹ,ֲ֧ƺͰȫԻ,һûϵͳ.(3)ͬʱṩͼλ湤ߡODBC(open database connectivity)ӿںSQLԽʽʽӿ.(4)ͬʱֶ֧Զֲݿݵϲѯ.
ؼʡ칹ݿϵͳ,ݿϵͳ,ɻݿϵͳ.
ͼšTP311,TP132
Design and Implementation of Relational Multi-database System IS-Global
WU Sheng-li ZHONG Hua HUANG Tao SUN Hong-yan YU Hai-jiang
(Object Technology Center Institute of Software The Chinese Academy of Sciences Beijing 100080)
(Laboratory of Computer Science Institute of Software The Chinese Academy of Sciences Beijing 100080)
Abstract In this paper, the authors discuss IS-Global's pivotal technique in design and implementation. IS-Global is a relational multi-database system, which provides an integrated global information system platform for enterprises applying CIMS (computer integrated manufacture system), and hides the detail of the heterogeneity of network, local operating systems and database systems. The major characteristics of IS-Global are as follows: (1) It is a tightly integrated system with unique global schema. (2) Being a multi-user system, IS-Global possesses two-lever client/server architecture and supports concurrent and security control mechanisms. (3) IS-Global provides graph-based tools, ODBC function call and interactive SQL interface. (4) IS-Global supports multi-location queries.
Key wordsHeterogeneous multi-database systems, federated database systems, interoperable database systems.
Դ80,칹ݿϵͳҲΪݿϵͳɻݿϵͳһֱݿһҪо.90,ڼ缼,رINTERNETѸͷչ,ݿµҪ.ݿеϢҪINTERNETϷ,ҴӦҪͬʱʶݿе.,칹ݿϵͳݿϵͳһγΪݿһоȵ.ĿǰΪֹ,Ƴʮԭϵͳ1,2,ݿƷҲٵ֧һЩݿĹ,нͻIBM˾DB2UniSQL˾UniSQL.DB2DataJoiner3ݺUniSQLеUniSQL/MṩǿĶݿѯ.
ڶݿϵͳ෽,ģʽͼɡģת칹ѯŻģ͡ƺͰȫԵвٵо,Ŀǰڴ.һʵϵͳۺϿЩ,ƺʵһɫġʺϹҵӦõĶݿϵͳҲһѶȵĹ.
,ǳе˹ҡ863CIMScomputer integrated manufacture systemشƼĿCIMSӦϵͳƽ̨е岿֡ȫϢϵͳ.ĿǰҵжԼӦһ,绷ϵͳӦ칹,ҵΧϢͨ빲һ.ΪȫΧڽһƹCIMS,Ϊ͹ṩԺõӦϵͳƽ̨,ĿĿ궨λڼӦ,м̽һЩʵõʵּ͹.ȿCIMSӦϵͳƽ̨ϵͳԭ,ͨһЩúͲϸĽ,γʵõĲƷ.۸ԭϵͳƷеĹؼ,ṹȫģͺģʽɡơѯŻȫԻƺȫֵȼ.
1 IS-Globalṹȫģʽ
IS-Globalͻ/ṹ,ͻ˰ͼλߡODBC(open database connectivity)ӿںͽʽԽӿڵǰ˲,ͨײͨϵͳIS-Globalķϵ,ûӦóݿ,ٽشͻ.IS-GlobalҪλIS-Global.IS-GlobalΪÿһûӦ߳.յӦóеݿʱ,Ӧ̷ֱ߳ôȡơơ﷨Ͳѯϵͳ.ݿϵͳֲͼ1ʾ.

ͼ1ݿϵͳֲ
IS-Globalڽиֲʱ,Ҫõȫֵ.ȫֵһϵб,ݿϵͳʵҪƵʹ,ǱĳЩҲû.ݿϵͳṩʽͼλʽûйصĲ.ĺ滹ҪԴ˽иϸ.
ݿϵͳͨ׼ODBCӿڣ4ݺ͸ֲݿϵͳ.Ŀǰӵļֲݿϵͳÿͻ/ʽ.ֻҪODBCӿڱ׼,ݿϵͳ,ݿҲΪϵͳеľֲݿʹ.Ŀǰʵ΢Windows NTϵͳƽ̨ϵIS-Global,ͻʵ΢Windows NTWindows 95ǰеĽӿ,SGIվUNIXϵͳʵһODBCýӿ.
ȫģͺģʽ.ڹ,ĿǰʵֻʵֵĶݿԭϵͳģ,˵,ģڹܽǿ,ʺΪȫģ.ʵԷ濼,Ŀǰҵ󶼲øֹϵݿƷ,ݿƷ߽,ԤڶڲԸı.,IS-GlobalùϵģΪȫģ.ݿΪֲݿ,μף5.
ף6, һ㽫ݿϵͳģʽΪ5,¶,ǷֱǸֲݿıģʽֲģʽģʽݿϵͳȫģʽģʽ.ڱϵͳ,ڸֲݿģʽΪϵģʽ,ٽת,,ɽֲݿıģʽ;ֲģʽϲΪһ.
ʵȫģʽǱϵͳҪ.ϵͳĿԺʵֵЧʡѶȵȶҪӰ7.ۺϿ,ϵͳƳһ͵Ķݿϵͳ,༴ϵͳΨһȫģʽ.ҲṩԽģʽɹ.ͨǰ߿ɴǿϵͳĿ,ʵƺ߿ɽϵͳʵѶ,ϵͳʵЧ.һҲɽͶûҪ,ʹϵͳʹúά.ڹϵĲȱͨԽӿڵȰ취ֲ.
ļɷ,ɽֲݿеͼеһЩԣؼ֣Ϊͼ.Ҳ˵,ԱΪλ,ùӳʱ뱣֤һеԪֲӦͼһضԪһһӦ.,ڽݿʱᷢ.ûȫֱĻ϶ȫͼ,δṩ칹ķ.
2 ȡ
ȡǶûϵͳеҪ.
Ŀǰ,ڶݿϵͳĲкۣܶ8,˲µģ,ǴǶԴͳĳ̶ֳȵķſ,ָ֧ӦҪĳǶ,ʵӦû.
ݿϵͳĲƻƲͬһݿϵͳ.һ,ֲݿϵͳӦĲƺ,ݿϵͳеɾݴ˽.һ,ֲݿϵͳеĲƺǲ.ϵͳ֧ȫĸ,һȫɶֲ,׶ύЭʵȫ.һҪǵ漰ȫֵ.ʵвSQL ServerݿϵͳЩԪ,ԶԪݵķҲ֯ķʽ,Ӷϵͳʵ.
ȫǼϵͳ(ϵͳ)еҪ.ĿǰڶݿϵͳеİȫһЩо.нʿZrichѧͰĴǵĻʼīѧԺ.CHASSISDOKλֱƳĶݿԭϵͳ.ǰϸ̽˶ݿϵͳ԰ȫϵͳҪƣ9,ʵһɿͻĶݿϵͳİȫϵͳ,۰ȫϵͳʵּ10.
ݿϵͳ,ʵְȫķҪǿƣmandatory access controlԾ(discretionary access control).Ʒݿϵͳ󶼲Ծʽ,һЩǿƵĸ.ָ֧ӦõҪ,ֻ֧ڽɫ򡢹顢͹İȫҲۣ11.IS-Globalֻ֧ûԾȡƻ,ɢdecentralizeȨ.༴еĴȡȨڶݿϵͳԱ,ɰѲȨתڸû,תڹ̿ɼ.һûͬʱμӶû,ûĳԱһЩûû,༴ûΪǶ׽ṹ,γѭ.Ȩ(positive)Ȩͷ.༴һûķ,δʽȨ,Խֹ.
һûͬʱμӶûʱ,ʱᵼ·ͻ,ڱϵͳ,ͻ,е1ȼڵ2.
(1) ʽȨʽֹ
(2) ԵûȨڶûȨ
ʵ,ôȡƾķʽ.ûûͬȶԴ,Ȩ.ھֲݿݿϵͳ,Ҫһ,ôǸþֲĹԱ,ҲǾĳЩȨ޵һû.ݿϵͳԱҪôЭȫģʽйظþֲݿ⹲Ϣ.ݿϵͳжԸþֲݿķʾԸôݽе.ɱ֤ȫֺ;ֲ㰲ȫԶ.
3 ѯŻ
ݿϵͳĲѯŻȵݿϵͳĲѯŻǵҪࡢ,ĿǰһЩԵо12.漰ѯʵЧʵУϴ䡢ֲݿĲѯڸֲݿϵͳ칹,ݿϵͳص,һµĽֲۣ.ڱϵͳ,ص㿼ǾֲݿĲѯֲ,ں潫һ.
IS-GlobalķΪÿһû˵ӦӦ߳̽з.Щ,ѯIS-GlobalݿϵͳеȫֹṹϢ,ϵͳеûûϢ,ֱӲѯֵйϢͿ,һݵķʡӡɾ޸,ҪиĴ.,ȵ﷨ϵͳ,SQL﷨,Ȼٵôȡϵͳ,˳ͨϵͳ,òϵͳ,ѡһʵʱòѯϵͳӦĴ.ѯϵͳҪ﷨ϵͳ,ҪSQLмһЩű.SQLм֯ɵʽ,ÿڵΪĴʷλ.űкҪıڵеλõϢ.
ѯϵͳΪȫֱӦֲеı,жеĴֻ漰һֲݿ⻹漰ֲݿ.ֻ漰һֲݿ,SQLмӦֲݿķ(ɾӺ޸)Ӧķ,õشͻ.
Ϊѯ,漰ֲݿϢ.,һ׼ѡһݿ,ѯҪڴ˽.Ȼ,ȷڵľֲݿ,ȽѡͶӰȥ,ٽҪݿݿ.,ݿнвѯ.ΪʵֵĶݿϵͳûݴĹ(ֵһЩܳ),һݴҪĳֲݿ.ѡݿ.
(1) þֲݿ漰(ֽ),ȣ
(2) þֲݿĲѯ,ǿ.
е1ռ70,2ռ30.һݿ漰ͨһļó,ݿĲѯͨһЩضĲѯʵ,ٽбȽ,õһԵıֵ,洢ȫֵ.
ͨIS-GlobalĽӿڴһЩ֮.ҪΪûͨSQLָںδû.ϵͳĽ취ûͨͼλ߽ӿָȱʡλ.ɾشĳֲݿɾñ,ɾȫֵей.Ͷȫģʽй෴ĹǶϿ,ʹñȫֹ,ñӾֲݿɾ.
4 ȫֵ
ȫֵݿϵͳȫԴ,Ҫи.
(1) ֲݿĻ
еݰֲݿĲƷơ汾šַ֧ODBCļԼѯϢ.
(2) ȫģʽֲģʽӳ
ݰÿһȫֱֲеĻͼĶӦ.
(3) ݿϵͳĻ
MDBSơ汾š֧ODBCļ֧SQLԵ.
(4) MDBSĴȡϢ
ûûơÿûĿÿûĳԱʹȡƾ.
ȫֵȫһSQL Serverݿ,ҺIS-Globalķλͬһ̨.һЩԪݵķ,IS-GlobalֻҪʱݿ⼴ɣһݵĲ,IS-GlobalҲҪе.ݿԪݵŵ,ݿṩ,󷽱ϵͳʵ,ϵͳĿɿ.
5 ǰ˽ӿ
IS-Globalǰ˽ӿṩͼλ湤ߡODBCӿںSQLԽʽ3ֹ.
ͼλ湤ΪݿϵͳṩģʽɡȨ޹ϵͳάȹ.ڶݿ⽨֮,ڶиֲݿϵͳĹϢ,ģʽ,γɶݿϵͳ.,ڶݿϵͳɲͶ֮,ֲݿûԾֲݿϵͳ޸ҲҪͨģʽɹȫϵͳзӳ,Աʹȫûʹ.
IS-GlobalϵͳԱȨͨͼλ湤߽Ȩ޹,ҲԷֵе.ûͨù߲鿴ԼķȨ޺Ͷݿϵͳй,ҲܽһЩɵȨһȨϵͳеû,ֱ޸ֵе.
ODBCMicrosoft˾ƶһʵݿʵĽӿ,ѳΪһʵϵı׼,ӦӦóͿ,ͨIS-Globalǰṩ׼ODBCӿ,ʹЩӦó͹߲޸ľIS-Globalݿϵͳ,ǿIS-GlobalĹܺͿ.
IS-Global ODBCҪIS-Global ODBCݱ/ģ͵ײͨŷģ.ӦóĺODBCIS-Global ODBC,Ҫɷĺ,ݱ/ģĴ,ɵײͨŷLCS(local communication system)͸.෴,ĽϢLCS,IS-Global ODBC дӦóָڴ滺.
SQLԽʽʽӿIS-Globalϵͳṩһʵù,ͨԷزѯݿϵͳԴ,ʵѭSQL92׼13.ʱ,ӵIS-GlobalԴ,ѯ䲢ִк,ѯ״̬Ϣֱʾڽ.
6 
Ľһݿϵͳʵ.Ŀǰ,ڶݿоѾȡһЩɹ,һʱԽȥ.νЩɹЧءۺϵӦʵõϵͳһֺ̽ʵ,ĿⷽЧ.ͨĿʵ,ʹȡһЩľ,ΪԺĹõĻ.
Ŀǰ,IS-Globalѻʵ,һЩӦóӲ.,ǽIS-Globalй(1) ͨڹʹ,ϵط,ԸĽ,ϵͳĿɿԣ(2) ̽ʵּ,ϵͳЧ.Ǽƻؼ,ڿͻṩƵݻ,Լһ̽漰ֲݿݲѯŻ.
лĵоõ863CIMSشƼĿ,ĿΪ863-511-9704-002-02,õȻѧ,ĿΪ69703006.
עоõȻѧ𡢹863߿ƼĿͲʿл.
ͨѶϵ:ӻ,100080,йѧԺо
߼飺ʤ,1963,ʿ,оԱ,ҪоΪݿ,,.
ӻ,1971,ʿ,ҪоΪֲʽݿ,.
,1965,ʿ,оԱ,ҪоΪ,,ֲ,Լ.
,Ů,1973,,ҪоΪ칹ݿϵͳ.
ݺ,1974,,ҪоΪ칹ݿϵͳ.
ߵλӻйѧԺоġ100080
ʤΡޡݺйѧԺооʵҡ100080
ο
1Bukhres, Elmagarmid Ahmed K eds. Object-oriented Multi-database Systems, Omran A. Englewood Cliffs, NJ: Prentice Hall, 1996
2Proceedings of Research Issues in Federated Database Systems'97 Workship. http://www.iti.cs.uni-magdeburg.de/cornad/EFDBS97/
3IBM Inc. DataJoiner: A Multidatabase Server. http://www.software.ibm.com/data/pubs/papers/#djlwp
4Microsoft Inc. ODBC 3.0 SDK. http://www.microsoft.com
5ʤ,.CIMSȫϢϵͳṹ.廪ѧѧ,1998,38(3):108111
(Wu Sheng-li, Huang Tao. Structure design of global information system in CIMS. Journal of Tsinghua University, 1998,38(3):108111)
6Sheth A, Larson J. Federated database systems for managing distributed. Heterogeneous and Autonomous Databases ACM Computing Surveys, 1990,22(3):183236
7ʤ,ܱ.칹ֲʽݿϵͳ岻һһֽ취.ѧ,1996,19(5):363368
(Wu Shang-li, Wang Neng-bin. A method to support semantic discrepant data in heterogeneous distributed database systems. Chinses Journal of Computers, 1996,19(5):363368)
8Zhang A, Nodine M, Bhargava B et al. Ensuring relaxed atomicity for flexible transactions in multi-database systems. In: Richard T S, Marianne W eds. Proceedings of ACM SIGMOD Conference, Minnesota: ACM Press, 1994.6778
9Jonscher Dirk, Dittrich Klaus R. Argosa configurable access control system for interoperable environments. In: David L S, Steven A D, John E D eds. Database Security IX: Status and Prospects, London: Chapman & Hall, 1996. 4360
10Tari Z, Fernandez G. Security Enforcement in the DOK Federated Database System. Database Security X, Status and Prospects, North Holland(Elsevier): Chapman & Hall, 1997
11Thomas R K, Sandhu R S. Task-based authorization controls(TBAC): a family of models for active and enterprise-oriented authorization management. In: Proceedings of IFIP WG 11.3 Workshop on Database Security. California: Lake Tahoe, 1997
12Evrendilek C, Dogac A, Nural S et al. Multi-database query optimization. Journal of Distributed and Parallel Databases, 1997,5(4):77114
13International Standand ISO/IEC 9075, Information TechnologyDatabase LanguagesSQL. 1992
1998-04-03յԭ,1998-09-01յ޸ĸ
