【作者】 杨春梅；

【导师】 张文东；

【作者基本信息】 中国石油大学 ， 计算机技术， 2007， 硕士

【摘要】 《基于VBA的地质图件系统设计与实现》主要应用了VBA技术,面向对象技术和克里金地质绘图技术,Visual Basic for Application(VBA)是一种使用对象模型模拟现实世界的一种完整的编程语言,它可以与那些与之集成的宿主应用程序一起使用。在具体的VBA开发中,我们通过面向对象的分析(OOA)建立概念模型,根据类之间的服务关系建立了数据库系统的E-R模型,经过面向对象的映射我们将E-R模型转化为相应的面向对象的数据模型,为实现数据的高效访问我们启用了ODBC访问模式,利用ADO数据访问接口实现了不同格式数据的编辑和修改。本次设计的核心模块由作图数据模块和绘图模块构成,结合相应复杂断块油藏细分层系研究,作图数据模块实现了复杂断块油藏细分层系研究中综合指数法、最优分割法,单参数定量化、经济参数等研究过程中的数据处理问题,从而优化了组合开发层系。绘图模板实现了细分层系研究中所涉及的沉积微相、孔隙度、渗透率等图件的自动绘制。更多还原

【Abstract】 The author applied VBA(Visual Basic for Application) technology, object-oriented technology, Cokriging geological drafting technique to the“Design and Implementation of Geological Map System Based on VBA”. ,VBA(Visual Basic for Application)is a macro programming language, which uses the object model to simulate the real world. It can be run with a host application integrated with VBA. In the course of exploring VBA, we construct conceptual model through OOA (Object-Oriented Analyse), establish Database System’s E-R model according to the serving connection between the different classes. E-R Model can be converted to relevant Object-Oriented Data Model through the Object-Oriented mapping, in order to implement efficient data access, we start ODBC (Open DataBase Connectivity) accessing pattern, achieving the compilation and modification of different Data format by ADO (Active Data Objects) accessing pattern port. The key modules in the design are Construct-Data Module and Plot Module. In the Construct-Data Module, comprehensive index, best segmentation, single parameter quantitative, economy parameter and so on, which were used in data processing, optimizing series of development in the the research of strata subdividing in the complicated fault-block oil reservoir. In the Plot Module, automatism charting was implemented about sedimentary facies, porosity, permeability in the the research of strata subdividing.更多还原