国家级油气资源数据库管理与应用系统架构
摘要
“国家级油气资源数据库建设”是数字国土工程(项目编号:1211010750107)的子课题。本论文是对国家级油气资源数据库管理与应用系统架构进行的设计。
本系统架构采用MVC模式进行视图、控制、模型的分离,有利于组件优化和未来的系统维护,使用UML面向对象技术来描述本系统进行软件系统架构需求分析设计,把软件体系结构的概念贯穿于需求分析、设计和实现三个阶段。
本系统完成了集局域网子系统、广域网子系统和录入子系统于一体的油气资源数据库管理与应用系统平台,是国内首个全面反映我国及国际油气资源情况且具备综合性空间信息处理能力的系统。
考虑到客户操作的方便性、友好性,为避免因提取大量空间数据而无法忍受长时间的等待,所有B/S模式功能均采用AJAX技术实现。
本系统实现了Excel数据智能导入系统,满足将国家级油气数据库10个专题以Excel格式保存的近百张属性表数据导入到数据库的要求。
本系统具备将Access数据库导入Oracle的功能,拥有处理大批量数据的能力。
本系统完成了数据报表输出系统,方便用户将按照特定查询要求得到的结果,填入动态绘制生成的报表中进行打印保存。
本系统完成了数据成图系统,可以将给定的数据绘制成柱状图、饼状图等图形,还支持3D图形显示、3D旋转、打印输出等功能。
“The National Petroleum Resources Database Construction”is the sub-topic of the digital national territory project (the project number: 1211010750107). The present paper aims at the designing of the National Petroleum Resources Database Using And Management System construction.
This system construction development uses the MVC pattern. MVC is Model– View–Controller .The model processes the backstage data and business logic .The view is used to demonstrate that the backstage the attribute data and spatial data's contact surface (may be C/S UI, may also be the B/S browser), may also transmit the request which the user must process .The controller is the intermediary between the view and the model, it is responsible to the requesting of the view for the concrete model, causing the view to make the corresponding demonstration change. And the Model layer may also be subdivided into the handling of the business layer and the data manipulation layer. The handling of business layer undertakes by the Web service module, through the server module to visit the Web, had guaranteed C/S Win Form and B/S Web Form and the JSP page execute the identical request obtains the same result . Therefore uses the MVC pattern to separate the view, the control and the model. The separation makes the system's structure more clear and which will be advantageous in the module and future system maintenance.
Using the object-oriented analysis design technique in demand stage of this system .The system takes the UML (Unified Modeling Language) as the model language of the system architecture, Using the circulation life cycle method of exploitation, has been helpful to the SA concept penetration entire software life cycle, thus had guaranteed the software development process's concept integrity, expressed the large-scale complicated system's architecture effectively. Using this method is helpful between the guarantee demand analysis and the system design traceability and the uniformity, in the overall system performance history, the user, the analysis designers, the programmer, the system integration personnel, the administrative personnel understand the system from different view of the combination model and exchange the thought. Using the UML object-oriented technologies to design this software system construction, the software architecture’s concept penetration in the three stages are demand analysis, designs and realizes.
This system has completed the National Petroleum Resources Database Using And Management platform which contains the local area network subsystem, the WAN subsystem and the inputting subsystem. This system first reflects our country and the international oil gas resources situation comprehensively in domestic. This system also has the ability of handling comprehensive spatial information.
The C/S construction's application has the characteristics of speed of responding, operation contact surface personalization and complex flow adaptation quick and so on. This system uses the C/S construction to realize including various special petroleum resources data inquiry, compiles service functions, spatial operation, spatial inquiry, space and attribute interoperability. The system completes the onstage customer to submit and to transform Web the service the request. This system mainly visits to various special basic information, amount of resources and so on attribute data maintenances. The multiform compiles the analysis and can connect to the database of the spatial data, loading the data, revising the data, and so on concrete service. Let system's user visit to the local area network to get a more complex processing data which is deployment on the database server. The user cannot directly through Internet to visit The National Petroleum Resources Database. The user derive the data which are conform to the foreign announcement condition to a special foreign announcement country Petroleum Resources data server, thus making the data separate the connection from the net, therefore the data that the users will visit has been processed .Thus the data of the system is safe.
In order to enable this system issue the petroleum resources information promptly. This system provides the petroleum resources basic data through net to issue, the attribute data basic inquiry, the attribute data unification inquiry and so on spatial data basic management. This system's outside net part uses the B/S construction, enables the public through the WWW browser convenient to inquiry some basic information. Considering the security and the secrecy of the data, the National Petroleum Resources data that are issued to the public must undergo the strict appraisal to be able to issue to the public. Moreover the database are issued to the public is subset to the local area’s database. These two database in physics must isolate completely. This system usually through the Intranet link to connect to the Petroleum Resources database, and according to assigned from already uploaded various special data which through the appraisal data takeoff rule withdrew to the petroleum resources database which wants to issue, then cutting of the intranet's connection. Needs to consume server's massive resources by the B/S pattern's spatial data operation, moreover needs to wait for a long time. Considering to make the customer operation conveniences and friendliness, to avoid the customer because of withdrawing the massive spatial data to be unable to endure the long time waiting. So the all B/S pattern function uses the newest AJAX technology to realize. AJAX uses the asynchronous communication mechanism movement. Therefore the customer operates this system equally with the C/S pattern, the users does not need to wait other duties after sending out the request. The result which is very quickly calculated by the system returns to browser's page, the attribute data will present by the paging attractive tabular form. The result that is the spatial data of inquiring and anglicizing will returns as many kinds of picture.
This system realized the Excel data intelligence inputting system, this system is to satisfy the national petroleum resources database 10 topics saved by the Excel preservation nearly hundred attribute list data to transmit into the Access database. It must choose one from many EXCEL sheets which preserve National Petroleum Resources information, then choose one to preserve the concrete topic in some table. The users must carry on the strict data check and finally preserved the database in the goal table.
This system has completed the data form outputting system. This system can use the form style which the user provides. To produce form dynamically according to the user inquiry's result, simultaneously providing functions such as printing preview and printing setup. The users can print the data and preserve the data more convenience.
This system completed the charting system, this charting system's function including drawing up the statistical result into the graph (for example line and so on)that the user chose, adjusting stick plot column size, demonstrating the graph value, setting background picture, setting the abscissa axis ordinate axis title and the total title, preserving picture and the printing picture function.
In brief, the design of the National Petroleum Resources Database Using And Management System construction has provided the very good theory to realize the system.
本系统架构采用MVC模式进行视图、控制、模型的分离,有利于组件优化和未来的系统维护,使用UML面向对象技术来描述本系统进行软件系统架构需求分析设计,把软件体系结构的概念贯穿于需求分析、设计和实现三个阶段。
本系统完成了集局域网子系统、广域网子系统和录入子系统于一体的油气资源数据库管理与应用系统平台,是国内首个全面反映我国及国际油气资源情况且具备综合性空间信息处理能力的系统。
考虑到客户操作的方便性、友好性,为避免因提取大量空间数据而无法忍受长时间的等待,所有B/S模式功能均采用AJAX技术实现。
本系统实现了Excel数据智能导入系统,满足将国家级油气数据库10个专题以Excel格式保存的近百张属性表数据导入到数据库的要求。
本系统具备将Access数据库导入Oracle的功能,拥有处理大批量数据的能力。
本系统完成了数据报表输出系统,方便用户将按照特定查询要求得到的结果,填入动态绘制生成的报表中进行打印保存。
本系统完成了数据成图系统,可以将给定的数据绘制成柱状图、饼状图等图形,还支持3D图形显示、3D旋转、打印输出等功能。
“The National Petroleum Resources Database Construction”is the sub-topic of the digital national territory project (the project number: 1211010750107). The present paper aims at the designing of the National Petroleum Resources Database Using And Management System construction.
This system construction development uses the MVC pattern. MVC is Model– View–Controller .The model processes the backstage data and business logic .The view is used to demonstrate that the backstage the attribute data and spatial data's contact surface (may be C/S UI, may also be the B/S browser), may also transmit the request which the user must process .The controller is the intermediary between the view and the model, it is responsible to the requesting of the view for the concrete model, causing the view to make the corresponding demonstration change. And the Model layer may also be subdivided into the handling of the business layer and the data manipulation layer. The handling of business layer undertakes by the Web service module, through the server module to visit the Web, had guaranteed C/S Win Form and B/S Web Form and the JSP page execute the identical request obtains the same result . Therefore uses the MVC pattern to separate the view, the control and the model. The separation makes the system's structure more clear and which will be advantageous in the module and future system maintenance.
Using the object-oriented analysis design technique in demand stage of this system .The system takes the UML (Unified Modeling Language) as the model language of the system architecture, Using the circulation life cycle method of exploitation, has been helpful to the SA concept penetration entire software life cycle, thus had guaranteed the software development process's concept integrity, expressed the large-scale complicated system's architecture effectively. Using this method is helpful between the guarantee demand analysis and the system design traceability and the uniformity, in the overall system performance history, the user, the analysis designers, the programmer, the system integration personnel, the administrative personnel understand the system from different view of the combination model and exchange the thought. Using the UML object-oriented technologies to design this software system construction, the software architecture’s concept penetration in the three stages are demand analysis, designs and realizes.
This system has completed the National Petroleum Resources Database Using And Management platform which contains the local area network subsystem, the WAN subsystem and the inputting subsystem. This system first reflects our country and the international oil gas resources situation comprehensively in domestic. This system also has the ability of handling comprehensive spatial information.
The C/S construction's application has the characteristics of speed of responding, operation contact surface personalization and complex flow adaptation quick and so on. This system uses the C/S construction to realize including various special petroleum resources data inquiry, compiles service functions, spatial operation, spatial inquiry, space and attribute interoperability. The system completes the onstage customer to submit and to transform Web the service the request. This system mainly visits to various special basic information, amount of resources and so on attribute data maintenances. The multiform compiles the analysis and can connect to the database of the spatial data, loading the data, revising the data, and so on concrete service. Let system's user visit to the local area network to get a more complex processing data which is deployment on the database server. The user cannot directly through Internet to visit The National Petroleum Resources Database. The user derive the data which are conform to the foreign announcement condition to a special foreign announcement country Petroleum Resources data server, thus making the data separate the connection from the net, therefore the data that the users will visit has been processed .Thus the data of the system is safe.
In order to enable this system issue the petroleum resources information promptly. This system provides the petroleum resources basic data through net to issue, the attribute data basic inquiry, the attribute data unification inquiry and so on spatial data basic management. This system's outside net part uses the B/S construction, enables the public through the WWW browser convenient to inquiry some basic information. Considering the security and the secrecy of the data, the National Petroleum Resources data that are issued to the public must undergo the strict appraisal to be able to issue to the public. Moreover the database are issued to the public is subset to the local area’s database. These two database in physics must isolate completely. This system usually through the Intranet link to connect to the Petroleum Resources database, and according to assigned from already uploaded various special data which through the appraisal data takeoff rule withdrew to the petroleum resources database which wants to issue, then cutting of the intranet's connection. Needs to consume server's massive resources by the B/S pattern's spatial data operation, moreover needs to wait for a long time. Considering to make the customer operation conveniences and friendliness, to avoid the customer because of withdrawing the massive spatial data to be unable to endure the long time waiting. So the all B/S pattern function uses the newest AJAX technology to realize. AJAX uses the asynchronous communication mechanism movement. Therefore the customer operates this system equally with the C/S pattern, the users does not need to wait other duties after sending out the request. The result which is very quickly calculated by the system returns to browser's page, the attribute data will present by the paging attractive tabular form. The result that is the spatial data of inquiring and anglicizing will returns as many kinds of picture.
This system realized the Excel data intelligence inputting system, this system is to satisfy the national petroleum resources database 10 topics saved by the Excel preservation nearly hundred attribute list data to transmit into the Access database. It must choose one from many EXCEL sheets which preserve National Petroleum Resources information, then choose one to preserve the concrete topic in some table. The users must carry on the strict data check and finally preserved the database in the goal table.
This system has completed the data form outputting system. This system can use the form style which the user provides. To produce form dynamically according to the user inquiry's result, simultaneously providing functions such as printing preview and printing setup. The users can print the data and preserve the data more convenience.
This system completed the charting system, this charting system's function including drawing up the statistical result into the graph (for example line and so on)that the user chose, adjusting stick plot column size, demonstrating the graph value, setting background picture, setting the abscissa axis ordinate axis title and the total title, preserving picture and the printing picture function.
In brief, the design of the National Petroleum Resources Database Using And Management System construction has provided the very good theory to realize the system.
引文
[1] Jason Couchman and Sudheer Marisetti.OCP Oracle9i Database: Fundamentals I Exam Guide[M].McGraw-Hill Osborne Media,2002.
[2] Wilpen L Gorr and Kristen S Kurland.GIS Tutorial Updated for ArcGIS 9.2: Work book for Arc View 9[M]. Esri Press,2007.
[3] Maribeth H. Price.Mastering ArcGIS with Video Clips[M].McGraw-Hill Science/Engineering/Math 2007.
[4] Michele Campagna.GIS for Sustainable Development: CRC 2005.
[5] Lannes Morris-Murphy.Oracle9i: SQL, with an Introduction to PL/SQL Course[M]. Technology 2003.
[6] Jay Hilyard and Stephen Teilhet .C# Cookbook, 2nd Edition[M]. O‘Reilly Media, Inc,Jan 2006.
[7] Tim Ormsby, Eileen Napoleon and Robert Burke . Getting to Know ArcGIS Desktop: The Basics of ArcView, ArcEditor, and ArcInfo Updated for ArcGIS 9[M]. Esri Press 2007.
[8] Jesse Liberty,Programming . C#:Building.NET Applications with C# [M].O‘Reilly Media,Inc,2005.
[9] Keyton Weissinger,ASP in a Nutshell[M]. O‘Reilly Media, Inc Dec 31, 1999.
[10] Marco Bellinaso.ASP.NET 2.0 Website Programming:Problem-Design-Solution [M].Wrox,2006.
[11]吴秀芹.ArcGIS 9地理信息系统应用与实践[M].清华大学出版社,2003年.
[12]王石.精通C#2005:数据库系统开发、Web开发[M].人民邮电出版社,2007.
[13]冯克忠.ArcObjects开发指南[M].电子工业出版社,2007年01月.
[14]王晟.Visual C#.NET数据库开发经典案例解析[M].清华大学出版社,2005年.
[15]盖国强.循序渐进Oracle数据库管理、优化与备份恢复[M].人民邮电出版社,2007 .
[16]王成春,萧雅云.实战Access 2003 VBA程序设计[M].中国铁道出版社,2005.
[17]边馥苓,GIS地理信息系统原理和方法[M].北京测绘出版社,1996.
[18]沈百玲,ArcGIS Server简介[R] ,北京:ESRI中国(北京)有限公司,2004.
[19]尹建忠,何政伟等.基于ArcGIS的土地资源信息系统(LRIS)开发研究[J].新疆石油学院学报,2003.4.
[20]王家耀.空间信息系统原理[M].北京科学出版社,2001
[2] Wilpen L Gorr and Kristen S Kurland.GIS Tutorial Updated for ArcGIS 9.2: Work book for Arc View 9[M]. Esri Press,2007.
[3] Maribeth H. Price.Mastering ArcGIS with Video Clips[M].McGraw-Hill Science/Engineering/Math 2007.
[4] Michele Campagna.GIS for Sustainable Development: CRC 2005.
[5] Lannes Morris-Murphy.Oracle9i: SQL, with an Introduction to PL/SQL Course[M]. Technology 2003.
[6] Jay Hilyard and Stephen Teilhet .C# Cookbook, 2nd Edition[M]. O‘Reilly Media, Inc,Jan 2006.
[7] Tim Ormsby, Eileen Napoleon and Robert Burke . Getting to Know ArcGIS Desktop: The Basics of ArcView, ArcEditor, and ArcInfo Updated for ArcGIS 9[M]. Esri Press 2007.
[8] Jesse Liberty,Programming . C#:Building.NET Applications with C# [M].O‘Reilly Media,Inc,2005.
[9] Keyton Weissinger,ASP in a Nutshell[M]. O‘Reilly Media, Inc Dec 31, 1999.
[10] Marco Bellinaso.ASP.NET 2.0 Website Programming:Problem-Design-Solution [M].Wrox,2006.
[11]吴秀芹.ArcGIS 9地理信息系统应用与实践[M].清华大学出版社,2003年.
[12]王石.精通C#2005:数据库系统开发、Web开发[M].人民邮电出版社,2007.
[13]冯克忠.ArcObjects开发指南[M].电子工业出版社,2007年01月.
[14]王晟.Visual C#.NET数据库开发经典案例解析[M].清华大学出版社,2005年.
[15]盖国强.循序渐进Oracle数据库管理、优化与备份恢复[M].人民邮电出版社,2007 .
[16]王成春,萧雅云.实战Access 2003 VBA程序设计[M].中国铁道出版社,2005.
[17]边馥苓,GIS地理信息系统原理和方法[M].北京测绘出版社,1996.
[18]沈百玲,ArcGIS Server简介[R] ,北京:ESRI中国(北京)有限公司,2004.
[19]尹建忠,何政伟等.基于ArcGIS的土地资源信息系统(LRIS)开发研究[J].新疆石油学院学报,2003.4.
[20]王家耀.空间信息系统原理[M].北京科学出版社,2001