Exploration Database Integration And G&G Software Application Based On OpenSpirit

With the influence of informatization on the oil industry,the oil company has established various kinds of professional database,project database,center database and real-time information system.A large number of G&G professional software is used in the oil industry,the independent data source lots and lots of data format.Between the local database and professional software,professional software data exchange has become the core needs of users.Application of data assets and how to better,fast preparing the data for the various professional software.OpenSpirit emerge as the times require in this context,it is of a variety of professional software database is integrated,is a very good solution to the problem of the data exchange.Because most of the domestic oil company's data stored in relational database based on the design and development of professional database,each of the oil company's local database difference is very big,the data structure is not the same,and not with the OpenSpirit integration,professional software to use these data becomes more difficult.Exploration and development of professional software design based on public data format,the public database with OpenSpirit interface,and the migration tool public database design based on OpenSpirit Copy Manager Extend,is the use of OpenSpirit API two development.It is the role of the source database with the OpenSpirit model data migration to OpenSpirit public database,the advantage of OpenSpirit data exchange bridge platform,professional application and convenient data database,thereby strengthening the data application,improve user productivity.Issue in accordance with the software engineering ideas and project management process,the specific work includes:analysis of requirements analysis and business situation,design and development technical data exploration model,professional software based data format analysis,analysis of OpenSpirit data model and SDK API,system structure design,technology selection,database design and construction of the public around the technical data of G&G professional software needs of the content,the public database design based on data migration tools,data visualization provides data query and data display function,meet the basic data query,preparation,migration of seamless docking.Topic established exploration and development database on the basis of professional software to model and database,and based on the SDK interface provided by OpenSpirit,developed a data migration tools,solve the seamless integration of oilfield database and professional software.Provides the design of database model diagram,data dictionary,procedure flow chart,data flow chart,the system function structure,the executable program,operation manual and other specific results.