Method for realizing historical data report by breaking away industrial configuration software database interface

Abstract

The invention discloses a method for realizing a historical data report by breaking away an industrial configuration software database interface, comprising the following sequence: confirming the type of industrial configuration software according to the selection of a user; selecting an OPC / DDE interface function; acquiring data through an OPC / DDE interface in real time; storing the data which are acquired in real time into a data buffer and waiting for picking-up a request; setting the type of a data report to be generated according to the selection of the user; setting the data range of the data report to be generated according to the selection of the user; using an invoking function to invoke data from the data stored in the buffer; and generating the data report. After the configuration software is operated by the method, the configuration software with any format can achieve a data generating function, and types and amounts of data variables can be stored in real time and modified, deleted or increased on the basis of storage, thereby the method has the advantages of simpleness, high speed, arbitrariness and practicality.

Description

technical field [0001] The invention relates to a method for extracting data from database software, in particular to a method for extracting industrial data from any industrial general configuration software to form a report form. Background technique [0002] The current status of data reports of domestic and foreign industrial general configuration software is as follows: [0003] (1) Most of the imported software does not integrate data report software, some of which can choose to purchase additional components to realize the function of data report according to the needs of customers, but this will undoubtedly increase the cost of use for customers; [0004] (2) Some of the imported software contains data report software, but these software have poor pertinence, and the format produced does not meet or cannot fully meet the requirements of domestic users; [0005] (3) The domestic industrial general report software contains this part of the function, which realizes the...

AI Technical Summary

Problems solved by technology

[0003] (1) Most of the imported software does not integrate data report software, and some software can choose to purchase additional components to realize the function of data report according to the needs of customers, but this will undoubtedly increase the cost of use for customers;

[0004] (2) Some of the imported software contains data report software, but these software have poor pertinence, and the format produced does not meet or cannot fully meet the requirements of domestic users;

[0005] (3) The domestic industrial general report software contains this part of the function, which realizes the simple data browsing function, but does not have the complex format and data statistics function;

[0006] (4) The most important thing is that commonly used configuration software requires users or development engineers to perform complex programming work, and requires users or engineers to have a certain programming language skills, which is not easy to popularize. For companies with practical software Raising the threshold requirements will invisibly increase labor costs;

[0007] (5) The development cycle of a single data report is relatively long, and there are many restrictions when querying or printing;

[0009] The technical problem that this method solves is that the imported and domestic general industrial configuration software software such as iFix, Wincc, configuration king etc. that are used in China at present realizes industrial data reports from the software ontology database, uses unified third-party software, adopts A unified method to realize data reports in any format. At present, there is no such tool software and its realization method at home and abroad.

Images