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 PDFInfo
- 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
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 24
- 238000012360 testing method Methods 0.000 title claims abstract description 23
- 238000000034 method Methods 0.000 title claims abstract description 13
- 238000001914 filtration Methods 0.000 claims abstract description 63
- 238000003860 storage Methods 0.000 claims abstract description 29
- 238000004891 communication Methods 0.000 claims abstract description 19
- 238000012546 transfer Methods 0.000 claims abstract description 8
- 230000004069 differentiation Effects 0.000 claims 2
- 230000032683 aging Effects 0.000 description 3
- 238000005457 optimization Methods 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 238000007418 data mining Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
Landscapes
- Mobile Radio Communication Systems (AREA)
Abstract
Description
技术领域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)
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)
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 |
-
2018
- 2018-05-28 CN CN201810520837.7A patent/CN108804589A/en active Pending
Patent Citations (3)
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 |