CN110579998A - Data acquisition method - Google Patents

Data acquisition method Download PDF

Info

Publication number
CN110579998A
CN110579998A CN201911014465.1A CN201911014465A CN110579998A CN 110579998 A CN110579998 A CN 110579998A CN 201911014465 A CN201911014465 A CN 201911014465A CN 110579998 A CN110579998 A CN 110579998A
Authority
CN
China
Prior art keywords
data
acquisition
module
calculation
real
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.)
Pending
Application number
CN201911014465.1A
Other languages
Chinese (zh)
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.)
Suzhou Liangjiang Intelligent Technology Co Ltd
Original Assignee
Suzhou Liangjiang Intelligent Technology 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 Suzhou Liangjiang Intelligent Technology Co Ltd filed Critical Suzhou Liangjiang Intelligent Technology Co Ltd
Priority to CN201911014465.1A priority Critical patent/CN110579998A/en
Publication of CN110579998A publication Critical patent/CN110579998A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B19/00Programme-control systems
    • G05B19/02Programme-control systems electric
    • G05B19/04Programme control other than numerical control, i.e. in sequence controllers or logic controllers
    • G05B19/05Programmable logic controllers, e.g. simulating logic interconnections of signals according to ladder diagrams or function charts
    • G05B19/058Safety, monitoring
    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B2219/00Program-control systems
    • G05B2219/10Plc systems
    • G05B2219/16Plc to applications
    • G05B2219/163Domotique, domestic, home control, automation, smart, intelligent house

Landscapes

  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Automation & Control Theory (AREA)
  • Arrangements For Transmission Of Measured Signals (AREA)

Abstract

The invention provides a data acquisition method, which comprises the following steps: 1) uploading acquisition drive to a data real-time display and cache module according to an object to be acquired; 2) instantiating the acquisition drive and configuring corresponding acquisition parameters; 3) importing an acquisition list into the data acquisition example, and starting a data acquisition module; 4) the data enters a data calculation module, the data enters a data real-time display and cache module after being calculated in the data calculation module, and the data real-time display and cache module performs summation and cache on the data; 5) and uploading the data to a database. The invention can effectively solve the technical problems that the data acquisition of systems such as instruments, PLC and the like is relatively dispersed, centralized and unified management cannot be realized, and remote 4G low-power-consumption data acquisition and control are supported.

Description

Data acquisition method
Technical Field
the invention relates to the field of data real-time display and cache modules in the fields of instruments, industrial PLC and the like, in particular to a data acquisition method;
the method belongs to the fields of data acquisition of the Internet of things, industrial data acquisition and the like, and is applied to the fields of electric power, instruments and meters, oil wells, ships, equipment and parts, electric machinery, automobiles and parts, building material metallurgy, electronic information, new energy, fine chemical engineering, textile chemical fibers, biological medicines, food and beverage, clothes, shoes and hats and the like.
Background
In the fields of electric power, instruments and meters, oil wells, ships, equipment and parts, electrical machinery, automobiles and parts, building material metallurgy, electronic information, new energy, fine chemical engineering, textile chemical fibers, biological medicines, food and beverage, clothes, shoes and hats and the like at present, particularly in the occasions of oil wells, ships, factories and the like, other systems such as instruments, PLC and the like used are various, so that the realization of an integrated data access component is difficult.
At present, data acquisition software for instruments, PLC and the like used in occasions such as oil wells, ships, factories and the like mainly aims at specific instruments, PLC and the like, and the main reason is that each instrument or other subsystems develop corresponding interface programs, namely, one system has various instruments and other subsystems, each instrument and PLC have own protocols, various programs need to be developed, and the problems of non-uniform interfaces of the software, difficulty in later maintenance and the like are caused.
Disclosure of Invention
in view of this, the invention provides a data acquisition method, which can effectively solve the technical problems that system data acquisition of instruments, PLCs and the like is relatively dispersed, centralized management cannot be realized, and remote 4G low-power-consumption data acquisition and control are realized.
therefore, the invention provides a data acquisition method, which comprises the following steps:
1) uploading acquisition drive to a data real-time display and cache module according to an object to be acquired;
2) Configuring corresponding acquisition parameters for the acquisition drive;
3) importing a collection list into the data real-time display and cache module, and starting the data collection module;
4) The data enters a data calculation module, the data enters a data real-time display and cache module after being calculated in the data calculation module, and the data real-time display and cache module performs summation and cache on the data;
5) And uploading the data to a database.
Furthermore, the data real-time display and cache module reads the acquired data of the object through 433/315 wireless, 232/485 serial ports or TCP/UDP transmission media.
further, the collected object is a meter.
Further, the collected object is an industrial PLC.
further, the data real-time display and cache module writes the data into the database through 4G, TCP/UDP, OPCUA or MQTT protocols.
Further, the databases are a relational database, a time sequence database and an MES database.
Further, the data are calculated in a data calculation module in a formula calculation mode, a lua embedded script calculation mode or a custom function calculation mode.
furthermore, in the formula calculation mode, reference variables are substituted into the calculation, and common arithmetic and logical operators are supported.
further, in the above lua embedded script calculation method, the first line of the calculation formula is function calc (), the last line must be end, the first return value is the calculated value, and the second return value is the calculated state.
furthermore, the data acquisition module deletes or modifies the data in the real-time data display and cache module.
the data acquisition method provided by the invention uses a flexible driving technology, can run on a data acquisition and control system on hardware such as x86, x64, arm and the like, provides external forward data such as gPCs, OPCUA, modbus, MQTT and the like, can acquire oil well instrument data, control an oil well valve switch, acquire the motor and sewage flow of a ship environment-friendly device, acquire data of industrial PLC (programmable logic controller), support protocol acquisition data such as OPCUA, modbus and the like, and support various calculation modes, formula calculation, lua embedded script calculation, custom function calculation and the like through simple configuration.
therefore, the data acquisition method provided by the invention can effectively solve the technical problems that the data acquisition of systems such as instruments and PLCs (programmable logic controllers) is dispersed and cannot be intensively and uniformly managed, and the data acquisition and control of remote 4G low power consumption are realized.
Drawings
various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
Fig. 1 is a schematic flow chart of a data acquisition method according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
As shown in fig. 1, the data acquisition method provided in this embodiment mainly includes the following steps:
S1: uploading a collection drive to a data real-time display and cache module according to an instrument or a PLC required to be collected;
S2: configuring corresponding acquisition parameters for the acquisition drive;
S3: importing a collection list into the data real-time display and cache module, and starting the data collection module;
S4: the data enters a data calculation module, the data enters a data real-time display and cache module after being calculated in the data calculation module, and the data real-time display and cache module performs summation and cache on the data;
S5: and uploading the data to a database.
the following introduces the acquisition management function involved in the method, and the function module is mainly used for adding a corresponding acquisition module and reading acquisition data:
firstly, adding and collecting: adding a new acquisition module; clicking the next step to configure acquisition parameters; operation: operating an acquisition module and editing: modifying acquisition configuration and deleting: deleting the collection module and collecting the name: clicking the name to enter the acquisition detail configuration;
secondly, collecting details: clicking a button corresponding to the collection name to enter a collection list configuration page; and (3) inquiring: filtering the displayed content according to the condition; an introduction point table: importing a list required to be collected; exporting a point table: exporting an acquisition list; and (3) adding a measuring point: newly building a measuring point; and (4) deleting a measuring point: deleting a measuring point; emptying a measuring point: deleting all the measuring points; and (4) restarting collection: restarting the acquisition module; running a log: checking current operation information; history log: and checking historical operation information.
the uploading management function related to the method is introduced below, and the function module is mainly used for adding a corresponding uploading driver and uploading acquired data to other equipment or systems.
wherein, the configuration is completed and a prompt is given: operation: operating an acquisition module; editing: modifying the acquisition configuration; and (3) deleting: deleting the acquisition module; collecting a name: and clicking the name to enter the acquisition detail configuration.
the upload management function further includes the following sub-functions: and (3) inquiring: filtering the displayed content according to the condition; an introduction point table: importing a list needing to be uploaded; exporting a point table: exporting an uploading list; and (3) adding a measuring point: newly building an uploading measuring point; and (4) deleting a measuring point: deleting an uploading measuring point; emptying a measuring point: deleting all the uploading measuring points; and (4) restarting collection: restarting the upload set module; running a log: checking current operation information; history log: and checking historical operation information.
the edge calculation function involved in the method is described below, and is mainly used for realizing various calculation requirements:
firstly, calculating an expression: formulas can be written, reference variables are substituted into the calculation, and common arithmetic and logical operators are supported; and (3) inquiring: filtering the display content according to the condition; an introduction point table: importing a calculated list; exporting a point table: deriving a computed manifest; and (3) adding a measuring point: newly building a calculation measuring point; and (3) modifying the measuring points: modifying the calculation information; and (4) deleting a measuring point: deleting the calculation measuring point; emptying a measuring point: and emptying the measuring point information.
Secondly, script calculation: a calculation script can be written in to support the lua script; and (3) inquiring: filtering the display content according to the condition; an introduction point table: importing a calculated list; exporting a point table: deriving a computed manifest; and (3) adding a measuring point: newly building a calculation measuring point;
Wherein, the first line of the calculation formula must be function calc (), the last line must be end, the first of the return value is the calculated value, the second is the calculated state;
And (3) modifying the measuring points: modifying the calculation information;
And (4) deleting a measuring point: deleting the calculation measuring point;
Emptying a measuring point: and emptying the measuring point information.
thirdly, calculating a function: calling a calculation method to realize calculation; including the following subfunctions: and (3) inquiring: filtering the display content according to the condition; an introduction point table: importing a calculated list; exporting a point table: deriving a computed manifest; and (3) adding a measuring point: newly building a calculation measuring point; parameter configuration: the first is the parameter of the self-defining function other than the self-defining function quoted; and (3) modifying the measuring points: modifying the calculation information; and (4) deleting a measuring point: deleting the calculation measuring point; emptying a measuring point: and emptying the measuring point information.
The customized function functions involved in the method are described below:
Function list-set of defined functions:
the addition function: adding a calculation method;
Description of the function: the role of this method is described;
and (3) source code: implementation code of the method;
Wherein, using system built-in functions:
The format requires that the function start end must be completed and the first line must be the function start;
Get real-time data point;
Parameters are as follows: measuring point names in real time;
and returning a value: table, field content Value, Status, Time;
Example (c):
the functions are as follows: reading the value of a real time point multiplied by 10 times
function test(mypoint)
local point=Get(mypoint)
local val=point.Value*10
return val,0
end
deletion function: deleting a calculation method;
and (3) helping: displaying help information;
The data management functions involved in the method are described below: the real-time data function: displaying the collected real-time data information; cache setting: caching related settings; historical data storage days: the number of days the history data is saved is set.
the drive management functions involved in the method are described below: enter this module by 'drive management'; the functions comprise uploading a driver, clicking an uploading driver and uploading drive information; and in the driving uploading process, displaying a progress bar, and prompting the successful uploading prompt after the uploading is finished.
The functions of the test tools involved in the method are described below: access to this module through a 'test tool'; the main function introduction comprises providing a common test program; network testing: providing a common port whether to open or not and a network ping test; and (3) serial port testing: data sending and receiving of the test serial port; modbus serial port test: testing the communication condition of the modbus serial port; modbus TCP test: and testing the communication condition of the Modbus TCP.
The data acquisition method provided by the embodiment uses a flexible driving technology, can run on data acquisition and control systems on hardware such as x86, x64 and arm, provides external forwarding data such as gPCs, OPCUA, modbus and MQTT, can acquire oil well instrument data through simple configuration, controls an oil well valve switch, acquires the motor and sewage flow of a ship environment-friendly device, acquires data of industrial PLC, supports protocols such as OPCUA and modbus to acquire data, and supports multiple calculation modes, formula calculation, lua embedded script calculation, custom function calculation and the like.
therefore, the data acquisition method provided by the embodiment can effectively solve the technical problems that system data acquisition of instruments, PLCs and the like is dispersed and cannot be managed in a centralized and unified manner, and remote 4G low-power-consumption data acquisition and control are realized.
in addition, the data acquisition method provided by the embodiment further has the following advantages:
1. the product is modularized, and the required drive can be flexibly customized according to the requirements of customers;
2. The instrument and the corresponding drive of the PLC can be flexibly selected according to the requirements, and users can acquire data and integrate the data into systems such as a database and the like without understanding software development;
3. The acquisition software can be accessed by various modes such as a mobile phone, a computer and the like;
4. supports integration into platforms gPCs, OPCUA, modbus and MQTT in various modes;
5. Supporting various calculation modes, formula calculation, script calculation and function calculation;
6. integrating various debugging tools such as ping, Connect, UDP/TCP network test, mosbus serial port, internet access test and OPCUA client test software;
7. the interface style is uniform, and the maintenance is easy.
it will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.

Claims (10)

1. a data acquisition method is characterized by comprising the following steps:
1) Uploading acquisition drive to a data real-time display and cache module according to an object to be acquired;
2) configuring corresponding acquisition parameters for the acquisition driving acquisition driver;
3) importing a collection list into the data real-time display and cache module, and starting the data collection module;
4) The data enters a data calculation module, the data enters the data real-time display and cache module after being calculated in the data calculation module, and the data real-time display and cache module performs collection and cache on the data;
5) And uploading the data to a database.
2. The data acquisition method as claimed in claim 1, wherein the data real-time display and buffer module reads the acquired data of the object through 433/315 wireless, 232/485 serial port or TCP/UDP transmission medium.
3. a data acquisition method according to claim 1 or 2, wherein the object being acquired is a meter.
4. A data acquisition method according to claim 1 or 2, wherein the object being acquired is an industrial PLC.
5. the data collection method of claim 1, wherein the real-time data presentation and caching module writes data into the database via 4G, TCP/UDP, opuca, or MQTT protocols.
6. A data collection method according to claim 1 or 5, wherein the database is a relational database, a time series database, or an MES database.
7. the data acquisition method according to claim 1, wherein the data is calculated in the data calculation module by a formula calculation mode, a lua embedded script calculation mode or a custom function calculation mode.
8. The data collection method of claim 7, wherein the formula calculation is based on substitution of reference variables to support common arithmetic and logical operators.
9. The data collection method of claim 7, wherein in the lua embedded script calculation mode, the first line of the calculation formula is function calc (), the last line must be end, the first return value is the calculated value, and the second return value is the calculated state.
10. The data acquisition method as claimed in claim 1, wherein the data acquisition module is deleted or modified in the data real-time presentation and caching module.
CN201911014465.1A 2019-10-24 2019-10-24 Data acquisition method Pending CN110579998A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911014465.1A CN110579998A (en) 2019-10-24 2019-10-24 Data acquisition method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911014465.1A CN110579998A (en) 2019-10-24 2019-10-24 Data acquisition method

Publications (1)

Publication Number Publication Date
CN110579998A true CN110579998A (en) 2019-12-17

Family

ID=68815364

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911014465.1A Pending CN110579998A (en) 2019-10-24 2019-10-24 Data acquisition method

Country Status (1)

Country Link
CN (1) CN110579998A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111681405A (en) * 2020-06-16 2020-09-18 江苏联丰温室工程有限公司 Internet of things temperature and humidity data acquisition method for greenhouse
CN112307102A (en) * 2020-10-30 2021-02-02 中国船舶重工集团公司第七0四研究所 Ship edge intelligent data acquisition module based on time sequence database
CN115599770A (en) * 2022-10-25 2023-01-13 北京力控元通科技有限公司(Cn) Data calculation script system

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101833498A (en) * 2009-07-31 2010-09-15 北京伟晨豪嘉科技有限责任公司 Automatic detection system of embedded type system based on testing script technique
CN106599197A (en) * 2016-12-14 2017-04-26 深圳天源迪科信息技术股份有限公司 Data acquisition and exchange engine
US20180059630A1 (en) * 2016-09-01 2018-03-01 Posco ICT Co., Ltd. Smart Factory Platform For Processing Data Obtained In Continuous Process
CN108667725A (en) * 2018-04-25 2018-10-16 哈尔滨电气股份有限公司 A kind of industrial AnyRouter and implementation method based on a variety of accesses and edge calculations
CN108762738A (en) * 2018-04-23 2018-11-06 北京兰光创新科技有限公司 The data collecting system of hardware and software platform

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101833498A (en) * 2009-07-31 2010-09-15 北京伟晨豪嘉科技有限责任公司 Automatic detection system of embedded type system based on testing script technique
US20180059630A1 (en) * 2016-09-01 2018-03-01 Posco ICT Co., Ltd. Smart Factory Platform For Processing Data Obtained In Continuous Process
CN106599197A (en) * 2016-12-14 2017-04-26 深圳天源迪科信息技术股份有限公司 Data acquisition and exchange engine
CN108762738A (en) * 2018-04-23 2018-11-06 北京兰光创新科技有限公司 The data collecting system of hardware and software platform
CN108667725A (en) * 2018-04-25 2018-10-16 哈尔滨电气股份有限公司 A kind of industrial AnyRouter and implementation method based on a variety of accesses and edge calculations

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111681405A (en) * 2020-06-16 2020-09-18 江苏联丰温室工程有限公司 Internet of things temperature and humidity data acquisition method for greenhouse
CN112307102A (en) * 2020-10-30 2021-02-02 中国船舶重工集团公司第七0四研究所 Ship edge intelligent data acquisition module based on time sequence database
CN115599770A (en) * 2022-10-25 2023-01-13 北京力控元通科技有限公司(Cn) Data calculation script system

Similar Documents

Publication Publication Date Title
CN110579998A (en) Data acquisition method
US7272458B2 (en) Control system setting device
US8612545B2 (en) Use of a really simple syndication communication format in a process control system
CN107548475A (en) Adaptive striding equipment control and steerable system and its corresponding method
US5574637A (en) Control apparatus for an automated production system workcell
CN103988477A (en) Device for operating at least one automation technology field device
CN110320875B (en) PAC cloud operation and maintenance system based on MQTT protocol
CN107042513B (en) Machining robot system
CN101393442A (en) CEMS monitoring method based on OPC communication technology
CN102944426A (en) Measurement and control system and method for test bed of X-type aero-engine
CN103312794A (en) Field equipment integration device based on mobile terminal
CN110867956A (en) Topology automatic identification system and method based on intelligent platform area
CN114070726A (en) Data acquisition method, system, device and storage medium
CN113419484A (en) Cloud programmable controller and operation method
CN115657564A (en) Programming-free field control device and method
CN115687494A (en) Digital twin monitoring system of manufacturing system
CN112799664A (en) Configuration method and system supporting heterogeneous environment
CN110650188B (en) Remote control method and system of HMI equipment and computer equipment
CN111212093A (en) Data processing system and control device
CN111025916B (en) Household appliance detection control method and system
CN114466259B (en) Data processing method, device and equipment of Internet of things gateway and Internet of things gateway
CN202974663U (en) X type aeroengine test bench measuring and controlling system
CN112986725B (en) Intelligent control terminal, testing method and electronic equipment for testing electric power secondary equipment
CN210724868U (en) Data processing system and control device
CN114662910A (en) CNC equipment real-time monitoring non-sensing work reporting system and method

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20191217