CN110187939B - Implementation method and system for calling Vensim model by applying WebService - Google Patents

Implementation method and system for calling Vensim model by applying WebService Download PDF

Info

Publication number
CN110187939B
CN110187939B CN201910464458.5A CN201910464458A CN110187939B CN 110187939 B CN110187939 B CN 110187939B CN 201910464458 A CN201910464458 A CN 201910464458A CN 110187939 B CN110187939 B CN 110187939B
Authority
CN
China
Prior art keywords
vensim
model
calling
webservice
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201910464458.5A
Other languages
Chinese (zh)
Other versions
CN110187939A (en
Inventor
郑俊健
梁耀林
潘志达
王慧芬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangdong Power Grid Co Ltd
Dongguan Power Supply Bureau of Guangdong Power Grid Co Ltd
Original Assignee
Guangdong Power Grid Co Ltd
Dongguan Power Supply Bureau of Guangdong Power Grid Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Guangdong Power Grid Co Ltd, Dongguan Power Supply Bureau of Guangdong Power Grid Co Ltd filed Critical Guangdong Power Grid Co Ltd
Priority to CN201910464458.5A priority Critical patent/CN110187939B/en
Publication of CN110187939A publication Critical patent/CN110187939A/en
Application granted granted Critical
Publication of CN110187939B publication Critical patent/CN110187939B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/20Design optimisation, verification or simulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/448Execution paradigms, e.g. implementations of programming paradigms
    • G06F9/4482Procedural
    • G06F9/4484Executing subprograms
    • G06F9/4486Formation of subprogram jump address
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/455Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
    • G06F9/45533Hypervisors; Virtual machine monitors
    • G06F9/45558Hypervisor-specific management and integration aspects
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/455Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
    • G06F9/45533Hypervisors; Virtual machine monitors
    • G06F9/45558Hypervisor-specific management and integration aspects
    • G06F2009/45579I/O management, e.g. providing access to device drivers or storage

Abstract

The invention discloses a realization method and a system for calling a Vensim model by applying WebService, wherein the method comprises the steps of connecting an Oracle database through JDBC and carrying out data transmission on a simulation operation decision system; and remotely calling a Vensim model in the virtual machine by using WebService, performing data simulation calculation, and outputting a calculation result. The invention provides a realization method and a system for calling a Vensim model by using WebService, which realize the function of introducing a Vensim tool to carry out simulation measurement in a software system with a B/S structure by establishing a calling interface between an enterprise management information system and Vensim software by using WebService technology, solve the problem that the existing Vensim tool can only be called manually, realize the functions of instant calling, instant response and real-time data input and output transmission of the Vensim tool, and provide an effective solution for realizing a dynamic decision function of the enterprise management information system.

Description

Implementation method and system for calling Vensim model by applying WebService
Technical Field
The embodiment of the invention relates to the technical field of Vensim model calling, in particular to a realization method and a system for calling a Vensim model by using WebService.
Background
In the process of simulation modeling by using a system dynamics tool (VENSIM), because the function module of the VENSIM software is limited, the data input and the result output of simulation measurement and calculation need to be manually converted into an electronic form or a database to be used by other software systems (such as an enterprise management information system), and the convenience of simulation measurement and calculation by using the VENSIM tool is limited to a certain extent. By consulting the relevant literature and consulting the VENSIM developer, no effective method for solving the problems exists at present.
Disclosure of Invention
The invention provides a realization method and a system for calling a Vensim model by applying WebService, which aim to overcome the defects of the prior art.
In order to achieve the above purpose, the present invention provides the following technical solutions:
in a first aspect, an embodiment of the present invention provides an implementation method for invoking a Vensim model by using WebService, including:
connecting an Oracle database through JDBC to transmit data to the analog operation decision system;
and remotely calling a Vensim model in the virtual machine by using WebService, performing data simulation calculation, and outputting a calculation result.
Further, in the implementation method for invoking the Vensim model by using WebService, the step of remotely invoking the Vensim model in the virtual machine by using WebService to perform data simulation calculation and output the calculation result includes:
the enterprise management information system calls an interface of an auxiliary system in a virtual machine where the Vensim model is located to operate the Vensim model through WebService;
transferring the data to an auxiliary system, assigning the data by calling an API (application program interface) of Vensim software by the auxiliary system, calling a Vensim model for simulation operation, and storing a calculation result in Excel after the operation is finished;
the auxiliary system analyzes Excel, and transmits the calculation result to the simulation operation decision system through WebService, so as to realize the operation by using a Vensim model in the enterprise management information system.
In a second aspect, an embodiment of the present invention provides an implementation system for invoking a Vensim model using WebService, including;
the data transmission module is used for connecting an Oracle database through JDBC and transmitting data to the simulation operation decision system;
and the model calling module is used for remotely calling the Vensim model in the virtual machine by using WebService, carrying out data simulation calculation and outputting a calculation result.
Further, in the implementation system for invoking the Vensim model by using WebService, the model invoking module is specifically configured to:
calling an interface of an auxiliary system in a virtual machine where a Vensim model is located to run the Vensim model through WebService;
transferring the data to an auxiliary system, assigning the data by calling an API (application program interface) of Vensim software by the auxiliary system, calling a Vensim model for simulation operation, and storing a calculation result in Excel after the operation is finished;
the auxiliary system analyzes Excel, and transmits the calculation result to the simulation operation decision system through WebService, so as to realize the operation by using a Vensim model in the enterprise management information system.
The implementation method and the system for calling the Vensim model by using the WebService provided by the embodiment of the invention realize the function of introducing the Vensim tool to carry out simulation measurement in the software system with the B/S structure by establishing the calling interface of the enterprise management information system and the Vensim software by using the WebService technology, solve the problem that the existing Vensim tool can only be called manually, realize the functions of instant calling, instant response and real-time data input and output transmission of the Vensim tool, and provide an effective solution for realizing the dynamic decision function of the enterprise management information system.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without inventive exercise.
Fig. 1 is a schematic flowchart of an implementation method for invoking a Vensim model by using WebService according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of an enterprise management information system according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an implementation system using WebService to invoke the Vensim model according to the second embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Referring to fig. 1, a flow diagram of an implementation method for invoking a Vensim model by using WebService according to an embodiment of the present invention is shown, where the method is executed by an implementation system for invoking the Vensim model by using WebService. The method specifically comprises the following steps:
s101, connecting an Oracle database (decision database) through JDBC (Java Data Base Connectivity, Java database connection), and performing Data transmission on the simulation operation decision system;
s102, remotely calling a Vensim model in the virtual machine by using WebService (an application program which exposes an API (application program interface) which can be called through Web to the outside), carrying out data simulation calculation, and outputting a calculation result.
The API refers to an Application Programming Interface (API).
Specifically, the step S02 further includes:
(1) the enterprise management information system calls an interface of an auxiliary system in a virtual machine where the Vensim model is located to operate the Vensim model through WebService;
(2) transferring the data to an auxiliary system, assigning the data by calling an API (application program interface) of Vensim software by the auxiliary system, calling a Vensim model for simulation operation, and storing a calculation result in Excel after the operation is finished;
(3) the auxiliary system analyzes Excel, and transmits the calculation result to the simulation operation decision system through WebService, so as to realize the operation by using a Vensim model in the enterprise management information system.
It should be noted that POI (open source code library of Apache software foundation, POI provides API to Java program for reading and writing Microsoft Office format archive) parses Vensim model calculation result Excel, and organizes data.
The core code for operating the WebService to call the Vensim model in the embodiment is as follows:
Figure BDA0002079030110000041
Figure BDA0002079030110000051
Figure BDA0002079030110000061
Figure BDA0002079030110000071
Figure BDA0002079030110000081
Figure BDA0002079030110000091
Figure BDA0002079030110000101
Figure BDA0002079030110000111
Figure BDA0002079030110000121
Figure BDA0002079030110000131
firstly, translating a large number of original English help documents, and mainly analyzing interface application and integration specifications to form a test case; through the realization process of a large number of test cases familiar with the system, the transmission protocol/calling method/input and output parameters/basic data organization and other cautions in interface calling; mainly finding a measuring and calculating model with relatively complete basic data, and completing single-interface case test by maintaining the basic data, controlling input parameters and comparing output parameter results; the method comprises the steps of intensively deploying a plurality of interface calling programs, synchronously carrying out integrated tests, and carrying out calling/responding tests to finish the interface calling programs of a test version; and finishing basic data additional entry, production environment deployment and joint debugging by arranging real data, comparing the measuring and calculating results with the measuring and calculating results of the VENSIM tool, ensuring the practicability and putting into production.
The implementation method for calling the Vensim model by using the WebService provided by the embodiment of the invention realizes the function of introducing the Vensim tool to carry out simulation measurement in the software system with the B/S structure by establishing the calling interface of the enterprise management information system and the Vensim software by using the WebService technology, solves the problem that the existing Vensim tool can only be called manually, realizes the functions of instant calling, instant response and real-time data input and output transmission of the Vensim tool, and provides an effective solution for realizing the dynamic decision function of the enterprise management information system.
Example two
As shown in fig. 3, a second embodiment of the present invention provides an implementation system for invoking a Vensim model by using WebService, which specifically includes the following modules;
the data transmission module 21 is used for connecting an Oracle database through JDBC and transmitting data to the simulation operation decision system;
and the model calling module 22 is used for remotely calling the Vensim model in the virtual machine by using WebService, performing data simulation calculation and outputting a calculation result.
Preferably, the model invoking module is specifically configured to:
calling an interface of an auxiliary system in a virtual machine where a Vensim model is located to run the Vensim model through WebService;
transferring the data to an auxiliary system, assigning the data by calling an API (application program interface) of Vensim software by the auxiliary system, calling a Vensim model for simulation operation, and storing a calculation result in Excel after the operation is finished;
the auxiliary system analyzes Excel, and transmits the calculation result to the simulation operation decision system through WebService, so as to realize the operation by using a Vensim model in the enterprise management information system.
The system can execute the method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
The implementation system for calling the Vensim model by using the WebService provided by the embodiment of the invention establishes the calling interface between the enterprise management information system and the Vensim software by using the WebService technology, realizes the function of introducing the Vensim tool to carry out simulation measurement in the software system with the B/S structure, solves the problem that the existing Vensim tool can only be called manually, realizes the functions of instant calling, instant response and real-time data input and output transmission of the Vensim tool, and provides an effective solution for realizing the dynamic decision function of the enterprise management information system.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims (2)

1. A realization method for calling a Vensim model by applying WebService is characterized by comprising the following steps:
connecting an Oracle database through JDBC to transmit data to the analog operation decision system;
remotely calling a Vensim model in a virtual machine by using WebService, carrying out data simulation calculation, and outputting a calculation result;
the steps of remotely calling a Vensim model in a virtual machine by using WebService, carrying out data simulation calculation and outputting a calculation result comprise:
the enterprise management information system calls an interface of an auxiliary system in a virtual machine where the Vensim model is located to operate the Vensim model through WebService;
transferring the data to an auxiliary system, assigning the data by calling an API (application program interface) of Vensim software by the auxiliary system, calling a Vensim model for simulation operation, and storing a calculation result in Excel after the operation is finished;
the auxiliary system analyzes Excel, and transmits the calculation result to the simulation operation decision system through WebService, so as to realize the operation by using a Vensim model in the enterprise management information system.
2. An implementation system for calling a Vensim model by applying WebService is characterized by comprising;
the data transmission module is used for connecting an Oracle database through JDBC and transmitting data to the simulation operation decision system;
the model calling module is used for remotely calling a Vensim model in the virtual machine by using WebService, carrying out data simulation calculation and outputting a calculation result;
the model calling module is specifically configured to:
calling an interface of an auxiliary system in a virtual machine where a Vensim model is located to run the Vensim model through WebService;
transferring the data to an auxiliary system, assigning the data by calling an API (application program interface) of Vensim software by the auxiliary system, calling a Vensim model for simulation operation, and storing a calculation result in Excel after the operation is finished;
the auxiliary system analyzes Excel, and transmits the calculation result to the simulation operation decision system through WebService, so as to realize the operation by using a Vensim model in the enterprise management information system.
CN201910464458.5A 2019-05-30 2019-05-30 Implementation method and system for calling Vensim model by applying WebService Active CN110187939B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910464458.5A CN110187939B (en) 2019-05-30 2019-05-30 Implementation method and system for calling Vensim model by applying WebService

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910464458.5A CN110187939B (en) 2019-05-30 2019-05-30 Implementation method and system for calling Vensim model by applying WebService

Publications (2)

Publication Number Publication Date
CN110187939A CN110187939A (en) 2019-08-30
CN110187939B true CN110187939B (en) 2021-03-02

Family

ID=67719056

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910464458.5A Active CN110187939B (en) 2019-05-30 2019-05-30 Implementation method and system for calling Vensim model by applying WebService

Country Status (1)

Country Link
CN (1) CN110187939B (en)

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102184320A (en) * 2011-04-20 2011-09-14 重庆市电力公司綦南供电局 Automatic calculation engine for IT (information technology) system application evaluation and extension platform
CN102567661A (en) * 2010-12-31 2012-07-11 北京奇虎科技有限公司 Program recognition method and device based on machine learning

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7818275B2 (en) * 1999-02-08 2010-10-19 Accenture Global Services Gmbh Runtime program regression analysis tool for a simulation engine
CN109447422A (en) * 2018-10-08 2019-03-08 北京百分点信息科技有限公司 A kind of policy simulation system and method based on system dynamics model

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102567661A (en) * 2010-12-31 2012-07-11 北京奇虎科技有限公司 Program recognition method and device based on machine learning
CN102184320A (en) * 2011-04-20 2011-09-14 重庆市电力公司綦南供电局 Automatic calculation engine for IT (information technology) system application evaluation and extension platform

Also Published As

Publication number Publication date
CN110187939A (en) 2019-08-30

Similar Documents

Publication Publication Date Title
CN101266570B (en) Software system test method and apparatus
CN110928529A (en) Method and system for assisting operator development
CN108845940B (en) Enterprise-level information system automatic function testing method and system
CN114841326B (en) Operator processing method, device, equipment and storage medium of deep learning framework
US20220066409A1 (en) Method and system for generating an artificial intelligence model
CN110221815B (en) Automatic generation method of control software model based on ontology
CN102694866A (en) Service request broker system in distributed network environment
US20230185702A1 (en) Method and Apparatus for Generating and Applying Deep Learning Model based on Deep Learning Framework
KR20210124934A (en) Method and apparatus of training model, development system, electronic device, computer readable storage medium, and computer program
CN115115048A (en) Model conversion method, device, computer equipment and storage medium
CN110187939B (en) Implementation method and system for calling Vensim model by applying WebService
CN106843822B (en) Execution code generation method and equipment
TW201321765A (en) Automatic test system of communication device
CN111459506A (en) Deployment method, device, medium and electronic equipment of deep learning platform cluster
Hendriks et al. A systematic approach for interfacing component-based software with an active automata learning tool
CN109739666A (en) Striding course call method, device, equipment and the storage medium of singleton method
CN115421940A (en) Multi-source heterogeneous model white box integration method based on shared memory technology
CN111966665B (en) Data migration testing method and device
CN114741294A (en) Page debugging method, device, equipment and storage medium
Dalibor et al. Tagging Model Properties for Flexible Communication.
CN113760462A (en) Method and device for constructing verification environment of dispatching automation system
Sheng et al. The micro-service architecture design research of financial trading system based on domain engineering
CN112685051A (en) Method, device, platform and storage medium for automatically executing shell script
CN103257911A (en) SOA (service-oriented architecture) based model testing tool integrating method
Zhang Research on software development and test environment automation based on android platform

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant