异构工程数据库互操作的研究
摘要
发动机CAD系统是一个庞大而复杂的系统，它包括10多个子系统，各子系统间相互独立，但是其部件间又相互作用和影响。在发动机CAD工程设计中，总体CAD设计和不同子系统CAD设计是在分布式网络环境中不同结点的工作站上进行的。为了实现信息共享以及用户对它们的透明访问，作者采用JDBC，解决了发动机异构工程数据库间的互操作问题。异构数据库互操作的关键技术是屏蔽异构数据库之间以及它们所处环境的差异。
本文提出并实现了一个基于JDBC的发动机异构工程数据库互操作系统。通过可视化界面，用户可以直观地对多个异构数据库进行透明访问，并可实现对数据库中数据的查询、增加、删除和修改等操作，同时还支持事务管理功能；具有可移植性，支持不同的客户平台，如Windows系列、OS／2等。
Engine CAD System is large and complicated.It includes 20 subsystems those are independent and reciprocal each other.In process of engine CAD system design,global CAD system and every subsystem CAD are designed in different workstations in distributed network environment.Interoperation between heterogeneous engineering databases is soveld by means of JDBC.The key technology of interoperation database is masking the heterogenieity of heterogeneous databases and their environments.
Architecture of engine heterogeneous database interoperated system based on JDBC is adoptcd.Users could transparently access heterogeneous databases and query,add,delete and modify data of connected databases through visiual interface.The system could run on different platforms such as Windows series,OS/2 .It has quality of portability and extensibility.
本文提出并实现了一个基于JDBC的发动机异构工程数据库互操作系统。通过可视化界面，用户可以直观地对多个异构数据库进行透明访问，并可实现对数据库中数据的查询、增加、删除和修改等操作，同时还支持事务管理功能；具有可移植性，支持不同的客户平台，如Windows系列、OS／2等。
Engine CAD System is large and complicated.It includes 20 subsystems those are independent and reciprocal each other.In process of engine CAD system design,global CAD system and every subsystem CAD are designed in different workstations in distributed network environment.Interoperation between heterogeneous engineering databases is soveld by means of JDBC.The key technology of interoperation database is masking the heterogenieity of heterogeneous databases and their environments.
Architecture of engine heterogeneous database interoperated system based on JDBC is adoptcd.Users could transparently access heterogeneous databases and query,add,delete and modify data of connected databases through visiual interface.The system could run on different platforms such as Windows series,OS/2 .It has quality of portability and extensibility.
引文
[1] CeriS, Pelagatri G. Distributed database:principles and systems. New York: McGraw-HillInc, 1984.
[2] 张水平，万映辉，卢潇等．异构数据库的集成与互操作．计算机应用研究，1999(1)：81～83．
[3] 唐雪飞，熊平，刘锦得．异构数据库互操作性的概念及其面临的问题．计算机科学，1994(6)：14～16．
[4] Thomas G, Hartman B. Heterogeneous distributed database systems for production use. ACM Computing Surveys, 1990, 22(3):237-266.
[5] 车敦仁，王令赤，王小京译．SYSBASE开发者指南．北京：清华大学出版社，1995．
[6] 周后盘．工程数据库与CIMS信息集成中的关键技术及其应用研究[博士学位论文]．浙江大学研究生院，浙江，1997．
[7] 李正宪．面向对象的工程数据库管理系统[硕士学位论文]．清华大学研究生院，北京，1992．
[8] Templeton M, Ward P. Pragmatics of access control in Mermaid. IEEE Comput Soc Tech Commitee Data Eng, 1987b, 10(3):33-38.
[9] Breitbart Y J, Tieman L R. ADDS Heterogeneous distributed database system:Distributed Data Sharing Systems, Netherlands:North Holland Publishing Co, 1985:7-24.
[10] Chung C W. DATAPLEX:A heterogeneous distributed database management system. Reseach Publication GMR-5973, General Motors Research Laboratories, 1987.
[11] Chung C W. DATAPLEX:An access to heterogeneous distributed databases. CommunACM, 1990,33(1):70-80.
[12] Ingres. Ingres Relational Technology. Inc Alameda, Calif, 94501
[13] Barkmeyer E, Mitchell M, Su S. An architecture for an integrated manufacturing data administration system. NBSIR 863312, National Bureau of Standards, 1986.
[14] Lee W F, Olson P L, Thomas G F.A remote user interface for the ADDS multidatabase system. Proceeding of the 2nd Oklahoma workshop on
Applied Computing. Tulsa:The Univ of Tulsa, 1988:194-204.
[15] Landers T, Prosenberg R. An overview of MULTIBASE. Netherlands: North ttolland Publishing Company:152-184.
[16] Landers T, Fox S. DAPLEX User's Manual:Tech Rep CCA-84-01: Computer Corporation of America, 1984.
[17] Shipman D. Tile functional data model and the data language DAPLEX. ACM Trans Database Syst, 1981, 6(1) :140-173.
[18] Dayal U, Landers T, Yedwab L. Global optimization techniques in MULTIBASE:Tech Rep CCA-82-05, Computer Corporation of America, 1982.
[19] ayal U, Landers T, Goodman N, Landers T, Yedwab L. Local query. optimization in MULTIBASE:A system for heterogeous distributed database:Tech Rep CCA-81-11, Computer Corporation of America, 1981.
[20] Katz R, Goodman N, Landers T, Smith J, Yedwab L. Database integration ans incomatible data handling in MULTIBASE:A system for heterogenonse distributed database:Tech Rep CCA-81-06, Computer Corporation of America, 1981.
[21] 马应章．浅谈我国数据库软件业的发展．PCWORLD CHINA，1997，3：39-41．
[22] 贾凤军．异构型数据库的联合使用：[硕士学位论文]．北京：北京理工大学，1993．
[23] 王韬．Client／Server结构分布式工程数据库管理系统的研究与实现[博士学位论文]．中国科学院计算技术研究所，北京，1996．
[24] 李炽明，徐明，周兴铭．基于Java技术的Web环境下的分布式数据库互操作性的实现，小型微型计算机系统，Vol．20，No．1，1999．
[25] JDK1.2 beta 3 Document. http://www.javasoft.com.
[26] Ashton Hobbs著，丁一青，吴静等译．自学JDBC数据库编程．北京：清华大学出版社，1998．
[27] JBuilder 6.0 IDE Help Document.
[28] Michael Meloan. Duke's Bakery-A JDBCTM Order Entry Prototype-Part Ⅰ. http://www.sun.com.
[29] John Pagegeorge. Getting Started With JDBC. http://www.sun.com.
[30] 唐巍，周俊林，李晓．异构数据库集成方法初探，计算机应用研究，1999年第8期．
[31] R. Krishnan, XiaoLingLi, Davis Steier et al. On Heteogeneous Database
Retrival:A Congnitiviely Guided Approach. Carnegie Melon Wording Paper Series. 1997.
[32] Java White Papers. Sunsoft Inc, http://java.sun.com/docs/white/index.html.
[33] JDBC API. http://java.sun.com/producs/jdk/1.2/docs/guide/jdbc/.
[34] JDBC Drivers. http://java.sun.com/products/jdbc/jdbc.drivers.html.
[35] 朱其亮，郑斌．CORBA原理及应用．北京：北京邮电大学出版社，2001．
[36] Nirva Morisseau-Leroy, Martin K. Solomon, Gerald P. Momplaisir著：田蕴哲等译．Oracle 9i SQLJ程序设计．北京：机械工业出版社，2002．
[37] 唐飞龙，姚君遗．Web数据库访技术的分析与研究[J]．计算机工程，2001，27 (7)：90．
[38] Andreas Vogel. Building Enterprise Applieations for the Net with EJB, CORBA, and XML. http://www.Inprise.com.
[39] OMG CORBA/IIOP 2.2 Specifieation. http:www.omg.org/corba/corbiiop.com.
[40] A White Paper of technical introduction to CORBA. http://www.segue.com
[2] 张水平，万映辉，卢潇等．异构数据库的集成与互操作．计算机应用研究，1999(1)：81～83．
[3] 唐雪飞，熊平，刘锦得．异构数据库互操作性的概念及其面临的问题．计算机科学，1994(6)：14～16．
[4] Thomas G, Hartman B. Heterogeneous distributed database systems for production use. ACM Computing Surveys, 1990, 22(3):237-266.
[5] 车敦仁，王令赤，王小京译．SYSBASE开发者指南．北京：清华大学出版社，1995．
[6] 周后盘．工程数据库与CIMS信息集成中的关键技术及其应用研究[博士学位论文]．浙江大学研究生院，浙江，1997．
[7] 李正宪．面向对象的工程数据库管理系统[硕士学位论文]．清华大学研究生院，北京，1992．
[8] Templeton M, Ward P. Pragmatics of access control in Mermaid. IEEE Comput Soc Tech Commitee Data Eng, 1987b, 10(3):33-38.
[9] Breitbart Y J, Tieman L R. ADDS Heterogeneous distributed database system:Distributed Data Sharing Systems, Netherlands:North Holland Publishing Co, 1985:7-24.
[10] Chung C W. DATAPLEX:A heterogeneous distributed database management system. Reseach Publication GMR-5973, General Motors Research Laboratories, 1987.
[11] Chung C W. DATAPLEX:An access to heterogeneous distributed databases. CommunACM, 1990,33(1):70-80.
[12] Ingres. Ingres Relational Technology. Inc Alameda, Calif, 94501
[13] Barkmeyer E, Mitchell M, Su S. An architecture for an integrated manufacturing data administration system. NBSIR 863312, National Bureau of Standards, 1986.
[14] Lee W F, Olson P L, Thomas G F.A remote user interface for the ADDS multidatabase system. Proceeding of the 2nd Oklahoma workshop on
Applied Computing. Tulsa:The Univ of Tulsa, 1988:194-204.
[15] Landers T, Prosenberg R. An overview of MULTIBASE. Netherlands: North ttolland Publishing Company:152-184.
[16] Landers T, Fox S. DAPLEX User's Manual:Tech Rep CCA-84-01: Computer Corporation of America, 1984.
[17] Shipman D. Tile functional data model and the data language DAPLEX. ACM Trans Database Syst, 1981, 6(1) :140-173.
[18] Dayal U, Landers T, Yedwab L. Global optimization techniques in MULTIBASE:Tech Rep CCA-82-05, Computer Corporation of America, 1982.
[19] ayal U, Landers T, Goodman N, Landers T, Yedwab L. Local query. optimization in MULTIBASE:A system for heterogeous distributed database:Tech Rep CCA-81-11, Computer Corporation of America, 1981.
[20] Katz R, Goodman N, Landers T, Smith J, Yedwab L. Database integration ans incomatible data handling in MULTIBASE:A system for heterogenonse distributed database:Tech Rep CCA-81-06, Computer Corporation of America, 1981.
[21] 马应章．浅谈我国数据库软件业的发展．PCWORLD CHINA，1997，3：39-41．
[22] 贾凤军．异构型数据库的联合使用：[硕士学位论文]．北京：北京理工大学，1993．
[23] 王韬．Client／Server结构分布式工程数据库管理系统的研究与实现[博士学位论文]．中国科学院计算技术研究所，北京，1996．
[24] 李炽明，徐明，周兴铭．基于Java技术的Web环境下的分布式数据库互操作性的实现，小型微型计算机系统，Vol．20，No．1，1999．
[25] JDK1.2 beta 3 Document. http://www.javasoft.com.
[26] Ashton Hobbs著，丁一青，吴静等译．自学JDBC数据库编程．北京：清华大学出版社，1998．
[27] JBuilder 6.0 IDE Help Document.
[28] Michael Meloan. Duke's Bakery-A JDBCTM Order Entry Prototype-Part Ⅰ. http://www.sun.com.
[29] John Pagegeorge. Getting Started With JDBC. http://www.sun.com.
[30] 唐巍，周俊林，李晓．异构数据库集成方法初探，计算机应用研究，1999年第8期．
[31] R. Krishnan, XiaoLingLi, Davis Steier et al. On Heteogeneous Database
Retrival:A Congnitiviely Guided Approach. Carnegie Melon Wording Paper Series. 1997.
[32] Java White Papers. Sunsoft Inc, http://java.sun.com/docs/white/index.html.
[33] JDBC API. http://java.sun.com/producs/jdk/1.2/docs/guide/jdbc/.
[34] JDBC Drivers. http://java.sun.com/products/jdbc/jdbc.drivers.html.
[35] 朱其亮，郑斌．CORBA原理及应用．北京：北京邮电大学出版社，2001．
[36] Nirva Morisseau-Leroy, Martin K. Solomon, Gerald P. Momplaisir著：田蕴哲等译．Oracle 9i SQLJ程序设计．北京：机械工业出版社，2002．
[37] 唐飞龙，姚君遗．Web数据库访技术的分析与研究[J]．计算机工程，2001，27 (7)：90．
[38] Andreas Vogel. Building Enterprise Applieations for the Net with EJB, CORBA, and XML. http://www.Inprise.com.
[39] OMG CORBA/IIOP 2.2 Specifieation. http:www.omg.org/corba/corbiiop.com.
[40] A White Paper of technical introduction to CORBA. http://www.segue.com