[go: up one dir, main page]

CN108804589A - A kind of manufacturing equipment tests recording method and its system of big data - Google Patents

A kind of manufacturing equipment tests recording method and its system of big data Download PDF

Info

Publication number
CN108804589A
CN108804589A CN201810520837.7A CN201810520837A CN108804589A CN 108804589 A CN108804589 A CN 108804589A CN 201810520837 A CN201810520837 A CN 201810520837A CN 108804589 A CN108804589 A CN 108804589A
Authority
CN
China
Prior art keywords
data
industrial equipment
database
filtered
filtering
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
CN201810520837.7A
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.)
Foshan University
Original Assignee
Foshan University
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 Foshan University filed Critical Foshan University
Priority to CN201810520837.7A priority Critical patent/CN108804589A/en
Publication of CN108804589A publication Critical patent/CN108804589A/en
Pending legal-status Critical Current

Links

Landscapes

  • Mobile Radio Communication Systems (AREA)

Abstract

The invention discloses recording method and its systems that a kind of manufacturing equipment tests big data, including:It initializes manufacturing equipment test big data and records system, wireless communication module connects the data acquisition node of industry wireless network;Data acquisition node acquires industrial equipment data and the industrial equipment data is passed to noise filtering module by wireless communication module;Noise filtering module downloads filtering rule from filtering rule database, and is filtered to industrial equipment data according to the filtering rule, and gives filtered industrial equipment data transfer to storage database;Storage database stores the filtered industrial equipment data;Wherein, the manufacturing equipment test big data record system includes:Wireless communication module, noise filtering module, filtering rule database store database.The invention can reduce noise data, avoid data too fat to move, analyze and excavate convenient for later data.It can be used for technical field of industrial automatic control.

Description

一种制造装备测试大数据的记录方法及其系统A method and system for recording big data of manufacturing equipment testing

技术领域technical field

本发明涉及工业自动化控制技术领域,特别涉及一种制造装备测试大数据的记录方法及其系统。The invention relates to the technical field of industrial automation control, in particular to a method and system for recording big data of manufacturing equipment testing.

背景技术Background technique

在工业4.0的技术背景下,工业实现自动化与智能化需要对生产情景进行大量的监测工作。其中测量的信号种类多样且形式各异,同时检测到的数据量也非常巨大。Under the technical background of Industry 4.0, the realization of industrial automation and intelligence requires a lot of monitoring work on production scenarios. The measured signals are of various types and in different forms, and the amount of detected data is also huge.

特别在制造装备测试老化过程中,会产生大量的数据,现有的大数据记录系统一般是对从传感器网络中传递过来的信号直接记录在数据库中。由于数据量庞大,因此,现有的大数据记录系统容易出现记录的数据冗长,臃肿,噪声数据很多等,不利于后期的数据分析和挖掘。Especially in the aging process of manufacturing equipment testing, a large amount of data will be generated. The existing big data recording system generally records the signals transmitted from the sensor network directly in the database. Due to the huge amount of data, the existing big data recording system is prone to long, bloated, noisy data, etc., which is not conducive to later data analysis and mining.

发明内容Contents of the invention

本发明为了解决现有技术的不足,提供一种制造装备测试大数据的记录方法及其系统。In order to solve the deficiencies of the prior art, the present invention provides a method and system for recording big data of manufacturing equipment testing.

本发明解决其技术问题的解决方案是:一种制造装备测试大数据的记录方法,包括:The solution of the present invention to solve its technical problem is: a method for recording big data of manufacturing equipment testing, including:

步骤1、初始化制造装备测试大数据记录系统,无线通讯模块连接工业无线网络的数据采集节点;Step 1. Initialize the manufacturing equipment test big data recording system, and connect the wireless communication module to the data acquisition node of the industrial wireless network;

步骤2、数据采集节点采集工业设备数据并将所述工业设备数据通过无线通讯模块传递给噪声过滤模块;Step 2, the data acquisition node collects industrial equipment data and transmits the industrial equipment data to the noise filtering module through the wireless communication module;

步骤3、噪声过滤模块从过滤规则数据库中下载过滤规则,并根据所述过滤规则对工业设备数据进行过滤,并将过滤后的工业设备数据传递给储存数据库;Step 3, the noise filtering module downloads the filtering rules from the filtering rule database, and filters the industrial equipment data according to the filtering rules, and transfers the filtered industrial equipment data to the storage database;

步骤4、储存数据库对所述过滤后的工业设备数据进行存储;Step 4, storing the database to store the filtered industrial equipment data;

其中,所述制造装备测试大数据记录系统包括:无线通讯模块,噪声过滤模块,过滤规则数据库,储存数据库。Wherein, the manufacturing equipment test big data recording system includes: a wireless communication module, a noise filtering module, a filtering rule database, and a storage database.

进一步,所述过滤后的工业设备数据至少包括用于标识工业设备的代码,所述储存数据库包括若干个子库,所述子库具有唯一的标志,其中,所述标志以工业设备的代码作为区分。Further, the filtered industrial equipment data includes at least codes for identifying industrial equipment, and the storage database includes several sub-libraries, and the sub-libraries have unique signs, wherein the signs are distinguished by codes of industrial equipment .

进一步,在步骤4中,储存数据库对所述过滤后的工业设备数据进行存储的方法包括:Further, in step 4, the method for storing the filtered industrial equipment data in the storage database includes:

步骤4.1、从所述过滤后的工业设备数据中提取工业设备的代码;Step 4.1, extracting the code of the industrial equipment from the filtered industrial equipment data;

步骤4.2、根据所述工业设备的代码从储存数据库中找到与所述代码对应的子库;Step 4.2, find the sub-library corresponding to the code from the storage database according to the code of the industrial equipment;

步骤4.3、将步骤4.1中的所述过滤后的工业设备数据存储在所述子库中。Step 4.3, storing the filtered industrial equipment data in step 4.1 in the sub-library.

一种制造装备测试大数据的记录系统,包括:无线通讯模块,噪声过滤模块,过滤规则数据库,储存数据库;A recording system for manufacturing equipment testing big data, including: a wireless communication module, a noise filtering module, a filtering rule database, and a storage database;

所述无线通讯模块用于连接工业无线网络的数据采集节点,并将所述数据采集节点采集得到的数据传递给噪声过滤模块;The wireless communication module is used to connect the data acquisition nodes of the industrial wireless network, and transfer the data collected by the data acquisition nodes to the noise filtering module;

所述噪声过滤模块用于从过滤规则数据库中下载过滤规则,并根据所述过滤规则对工业设备数据进行过滤,并将过滤后的工业设备数据传递给储存数据库;The noise filtering module is used to download filtering rules from the filtering rule database, filter the industrial equipment data according to the filtering rules, and transfer the filtered industrial equipment data to the storage database;

所述过滤规则数据库用于存储过滤规则;The filtering rule database is used to store filtering rules;

所述储存数据库用于对所述过滤后的工业设备数据进行存储。The storage database is used to store the filtered industrial equipment data.

进一步,所述过滤后的工业设备数据至少包括用于标识工业设备的代码,所述储存数据库包括若干个子库,所述子库具有唯一的标志,其中,所述标志以工业设备的代码作为区分。Further, the filtered industrial equipment data includes at least codes for identifying industrial equipment, and the storage database includes several sub-libraries, and the sub-libraries have unique signs, wherein the signs are distinguished by codes of industrial equipment .

本发明的有益效果是:本发明创造的方法及其系统通过噪声过滤模块从过滤规则数据库下载过滤规则,并根据所述过滤规则对无线通讯模块传递过来的工业设备数据进行过滤,从而减少噪声数据,避免数据臃肿,便于后期数据分析和挖掘。The beneficial effects of the present invention are: the method and the system created by the present invention download the filtering rules from the filtering rule database through the noise filtering module, and filter the industrial equipment data transmitted by the wireless communication module according to the filtering rules, thereby reducing the noise data , avoid data bloat, and facilitate later data analysis and mining.

附图说明Description of drawings

为了更清楚地说明本发明实施例中的技术方案,下面将对实施例描述中所需要使用的附图作简单说明。显然,所描述的附图只是本发明的一部分实施例,而不是全部实施例,本领域的技术人员在不付出创造性劳动的前提下,还可以根据这些附图获得其他设计方案和附图。In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly describe the drawings that need to be used in the description of the embodiments. Apparently, the described drawings are only some embodiments of the present invention, not all embodiments, and those skilled in the art can obtain other designs and drawings based on these drawings without creative work.

图1是本发明方法的步骤流程图;Fig. 1 is a flow chart of the steps of the inventive method;

图2是优化后的步骤S4的步骤流程图;Fig. 2 is the step flowchart of step S4 after optimization;

图3是本发明创造系统的系统连接示意图。Fig. 3 is a schematic diagram of the system connection of the inventive system of the present invention.

具体实施方式Detailed ways

以下将结合实施例和附图对本发明的构思、具体结构及产生的技术效果进行清楚、完整地描述,以充分地理解本发明的目的、特征和效果。显然,所描述的实施例只是本发明的一部分实施例,而不是全部实施例,基于本发明的实施例,本领域的技术人员在不付出创造性劳动的前提下所获得的其他实施例,均属于本发明保护的范围。另外,文中所提到的所有联接/连接关系,并非单指构件直接相接,而是指可根据具体实施情况,通过添加或减少联接辅件,来组成更优的联接结构。本发明创造中的各个技术特征,在不互相矛盾冲突的前提下可以交互组合。The idea, specific structure and technical effects of the present invention will be clearly and completely described below in conjunction with the embodiments and accompanying drawings, so as to fully understand the purpose, features and effects of the present invention. Apparently, the described embodiments are only some of the embodiments of the present invention, rather than all of them. Based on the embodiments of the present invention, other embodiments obtained by those skilled in the art without creative efforts belong to The protection scope of the present invention. In addition, all the connection/connection relationships mentioned in this article do not refer to the direct connection of components, but mean that a better connection structure can be formed by adding or reducing connection accessories according to specific implementation conditions. The various technical features in the invention can be combined interactively on the premise of not conflicting with each other.

实施例1,参考图1,一种制造装备测试大数据的记录方法,包括步骤:Embodiment 1, referring to Fig. 1, a method for recording big data of manufacturing equipment testing, including steps:

S1、初始化制造装备测试大数据记录系统,无线通讯模块连接工业无线网络的数据采集节点;S1. Initialize the manufacturing equipment test big data recording system, and connect the wireless communication module to the data acquisition node of the industrial wireless network;

S2、数据采集节点采集工业设备数据并将所述工业设备数据通过无线通讯模块传递给噪声过滤模块;S2. The data collection node collects industrial equipment data and transmits the industrial equipment data to the noise filtering module through the wireless communication module;

S3、噪声过滤模块从过滤规则数据库中下载过滤规则,并根据所述过滤规则对工业设备数据进行过滤,并将过滤后的工业设备数据传递给储存数据库;S3. The noise filtering module downloads filtering rules from the filtering rule database, and filters the industrial equipment data according to the filtering rules, and transfers the filtered industrial equipment data to the storage database;

S4、储存数据库对所述过滤后的工业设备数据进行存储;S4. The storage database stores the filtered industrial equipment data;

其中,制造装备测试大数据记录系统包括:无线通讯模块,噪声过滤模块,过滤规则数据库,储存数据库。Among them, the manufacturing equipment test big data recording system includes: a wireless communication module, a noise filtering module, a filtering rule database, and a storage database.

作为优化,所述过滤后的工业设备数据至少包括用于标识工业设备的代码,所述储存数据库包括若干个子库,所述子库具有唯一的标志,其中,所述标志以工业设备的代码作为区分。As an optimization, the filtered industrial equipment data at least includes codes for identifying industrial equipment, and the storage database includes several sub-libraries, and the sub-libraries have unique signs, wherein the signs use industrial equipment codes as distinguish.

参考图2,作为优化,在步骤S4中,储存数据库对所述过滤后的工业设备数据进行存储的方法包括步骤:Referring to Fig. 2, as an optimization, in step S4, the method for storing the filtered industrial equipment data in the storage database includes steps:

S4.1、从所述过滤后的工业设备数据中提取工业设备的代码;S4.1. Extract the code of the industrial equipment from the filtered industrial equipment data;

S4.2、根据所述工业设备的代码从储存数据库中找到与所述代码对应的子库;S4.2. Find the sub-library corresponding to the code from the storage database according to the code of the industrial equipment;

S4.3、将步骤S4.1中的所述过滤后的工业设备数据存储在所述子库中。S4.3. Store the filtered industrial equipment data in step S4.1 in the sub-library.

参考图3,下面以一种制造装备测试大数据的记录系统的角度对本发明创造进一步描述,所述系统包括:无线通讯模块,噪声过滤模块,过滤规则数据库,储存数据库。Referring to FIG. 3 , the present invention will be further described from the perspective of a recording system for manufacturing equipment testing big data. The system includes: a wireless communication module, a noise filtering module, a filtering rule database, and a storage database.

当本系统工作时,所述无线通讯模块连接工业无线网络的数据采集节点,并将所述数据采集节点采集得到的数据传递给噪声过滤模块;所述噪声过滤模块从过滤规则数据库中下载过滤规则,并根据所述过滤规则对工业设备数据进行过滤,其中,过滤规则数据库中的过滤规则为用户根据制造装备的实际情况而预先设定的。比如说,对于发动机的老化测试过程中,则需要采集和记录发动机老化过程中的发动机罩振动信号,此时,为了过滤掉一些无用的数据,则过滤规则为:去掉振动频率<20Hz或>460Hz的信号,噪声过滤模块可根据所述过滤规则,去掉振动频率<20Hz或>460Hz的信号数据,从而降低噪声。过滤后的工业设备数据可传递到储存数据库中。When the system is working, the wireless communication module is connected to the data acquisition node of the industrial wireless network, and the data collected by the data acquisition node is passed to the noise filtering module; the noise filtering module downloads the filtering rules from the filtering rule database , and filter the industrial equipment data according to the filtering rules, wherein the filtering rules in the filtering rule database are preset by the user according to the actual situation of the manufacturing equipment. For example, during the engine aging test process, it is necessary to collect and record the engine hood vibration signal during the engine aging process. At this time, in order to filter out some useless data, the filtering rule is: remove the vibration frequency <20Hz or >460Hz signal, the noise filtering module can remove signal data with a vibration frequency <20Hz or >460Hz according to the filtering rules, thereby reducing noise. Filtered industrial equipment data can be transferred to a storage database.

为了方便数据存储,所述过滤后的工业设备数据至少包括用于标识工业设备的代码,所述储存数据库包括若干个子库,所述子库具有唯一的标志,其中,所述标志以工业设备的代码作为区分。当储存数据库对过滤后的工业设备数据进行存储时,首先提取所述过滤后的工业设备数据的代码,并根据所述代码查询与所述代码相对应的子库,并将所述过滤后的工业设备数据存储在所述子库中,方便外部设备直接通过所述代码调取相应的工业设备数据。In order to facilitate data storage, the filtered industrial equipment data at least includes codes for identifying industrial equipment, and the storage database includes several sub-libraries, and the sub-libraries have unique signs, wherein the signs are represented by industrial equipment code as a distinction. When storing the filtered industrial equipment data in the storage database, first extract the code of the filtered industrial equipment data, and query the sub-library corresponding to the code according to the code, and store the filtered industrial equipment data The industrial equipment data is stored in the sub-library, which is convenient for the external equipment to directly call the corresponding industrial equipment data through the code.

以上对本发明的较佳实施方式进行了具体说明,但本发明创造并不限于所述实施例,熟悉本领域的技术人员在不违背本发明精神的前提下还可做出种种的等同变型或替换,这些等同的变型或替换均包含在本申请权利要求所限定的范围内。The preferred embodiments of the present invention have been described in detail above, but the invention is not limited to the described embodiments, and those skilled in the art can also make various equivalent modifications or replacements without violating the spirit of the present invention. , these equivalent modifications or replacements are all included within the scope defined by the claims of the present application.

Claims (5)

1. a kind of recording method of manufacturing equipment test big data, which is characterized in that including:
Step 1, initialization manufacturing equipment test big data record system, and wireless communication module connects the data of industry wireless network Acquisition node;
Step 2, data acquisition node acquisition industrial equipment data are simultaneously passed the industrial equipment data by wireless communication module Pass noise filtering module;
Step 3, noise filtering module download filtering rule from filtering rule database, and according to the filtering rule to industry Device data is filtered, and gives filtered industrial equipment data transfer to storage database;
Step 4, storage database store the filtered industrial equipment data;
Wherein, the manufacturing equipment test big data record system includes:Wireless communication module, noise filtering module, filtering rule Then database stores database.
2. a kind of recording method of manufacturing equipment test big data according to claim 1, which is characterized in that the filtering Industrial equipment data afterwards include at least the code for identifying industrial equipment, and the storage database includes several word banks, The word bank has unique mark, wherein the mark is using the code of industrial equipment as differentiation.
3. a kind of recording method of manufacturing equipment test big data according to claim 2, which is characterized in that in step 4 In, the method that storage database stores the filtered industrial equipment data includes:
Step 4.1, from the code of the filtered industrial equipment extracting data industrial equipment;
Step 4.2 finds word bank corresponding with the code according to the code of the industrial equipment from storage database;
The filtered industrial equipment data in step 4.1 are stored in the word bank by step 4.3.
4. a kind of record system of manufacturing equipment test big data, which is characterized in that including:Wireless communication module, noise filtering Module, filtering rule database store database;
The wireless communication module is used to connect the data acquisition node of industry wireless network, and the data acquisition node is adopted Collect obtained data transfer and gives noise filtering module;
The noise filtering module is used to download filtering rule from filtering rule database, and according to the filtering rule to work Industry device data is filtered, and gives filtered industrial equipment data transfer to storage database;
The filtering rule database is for stored filter rule;
The storage database is for storing the filtered industrial equipment data.
5. a kind of record system of manufacturing equipment test big data according to claim 4, which is characterized in that the filtering Industrial equipment data afterwards include at least the code for identifying industrial equipment, and the storage database includes several word banks, The word bank has unique mark, wherein the mark is using the code of industrial equipment as differentiation.
CN201810520837.7A 2018-05-28 2018-05-28 A kind of manufacturing equipment tests recording method and its system of big data Pending CN108804589A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810520837.7A CN108804589A (en) 2018-05-28 2018-05-28 A kind of manufacturing equipment tests recording method and its system of big data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810520837.7A CN108804589A (en) 2018-05-28 2018-05-28 A kind of manufacturing equipment tests recording method and its system of big data

Publications (1)

Publication Number Publication Date
CN108804589A true CN108804589A (en) 2018-11-13

Family

ID=64090526

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810520837.7A Pending CN108804589A (en) 2018-05-28 2018-05-28 A kind of manufacturing equipment tests recording method and its system of big data

Country Status (1)

Country Link
CN (1) CN108804589A (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104954242A (en) * 2014-03-26 2015-09-30 洛克威尔自动控制技术股份有限公司 Unified data ingestion adapter for migration of industrial data to a cloud platform
CN105929781A (en) * 2016-07-04 2016-09-07 安徽天达网络科技有限公司 On-line monitoring system for industrial equipment
CN106774209A (en) * 2016-12-26 2017-05-31 北京梵天智能工业科技有限公司 A kind of industrial equipment collecting method and device

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104954242A (en) * 2014-03-26 2015-09-30 洛克威尔自动控制技术股份有限公司 Unified data ingestion adapter for migration of industrial data to a cloud platform
CN105929781A (en) * 2016-07-04 2016-09-07 安徽天达网络科技有限公司 On-line monitoring system for industrial equipment
CN106774209A (en) * 2016-12-26 2017-05-31 北京梵天智能工业科技有限公司 A kind of industrial equipment collecting method and device

Similar Documents

Publication Publication Date Title
CN104123221A (en) Response time test method and device
CN111224807B (en) Distributed log processing method, device, equipment and computer storage medium
CN104065521A (en) A system and method for collecting, analyzing and publishing power network equipment logs and configuration files
CN103760394A (en) Automatic processing method and device for measured data of oscilloscope
CN103944761A (en) Android log information filter method and system
CN108427623A (en) A kind of computer fault alarm system and method
CN109388671A (en) Data processing method, device, equipment and storage medium
CN113239007B (en) Multi-level heterogeneous log transaction analysis method, system, equipment and storage medium
CN111694824A (en) Method for mapping and cleaning oil data chain
CN108804589A (en) A kind of manufacturing equipment tests recording method and its system of big data
CN115049493A (en) Block chain data tracking method and device and electronic equipment
CN101373506B (en) A Vulnerability Model Based Software Vulnerability Model Detection Method
CN108871781A (en) A kind of Fault Diagnosis of Engine and its system
CN114414255A (en) Automatic driving test method and system based on CAN message period monitoring
CN111191086B (en) Test data identification method
CN110489627B (en) Internet crawler routing method
CN116719750B (en) Software testing method and device, server equipment and storage medium
CN112464591A (en) Multi-port nested model connection analysis method and medium
CN106787180A (en) The analysis method and device of a kind of power transmission and transformation Condition Monitoring Data
CN114338441B (en) An analysis method for intelligently identifying business links based on business traffic
CN115209394B (en) Log grabbing method, device, equipment and storage medium
CN111753138B (en) Real-time logging data acquisition method
CN116414102A (en) Fault diagnosis method of vehicle-mounted online service system
CN111123861B (en) Distributed data acquisition system and method for large-scale multi-field coupled test equipment
CN110191026B (en) Distributed service link monitoring method and device

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

Application publication date: 20181113

RJ01 Rejection of invention patent application after publication