CN111538762A - Information management analysis method based on data mining technology - Google Patents
Information management analysis method based on data mining technology Download PDFInfo
- Publication number
- CN111538762A CN111538762A CN202010322403.3A CN202010322403A CN111538762A CN 111538762 A CN111538762 A CN 111538762A CN 202010322403 A CN202010322403 A CN 202010322403A CN 111538762 A CN111538762 A CN 111538762A
- Authority
- CN
- China
- Prior art keywords
- data
- method based
- equipment
- information management
- analysis method
- 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
- 238000007418 data mining Methods 0.000 title claims abstract description 16
- 238000005516 engineering process Methods 0.000 title claims abstract description 16
- 238000004458 analytical method Methods 0.000 title claims abstract description 15
- 238000007726 management method Methods 0.000 title claims abstract description 13
- 238000012423 maintenance Methods 0.000 claims abstract description 8
- 238000012545 processing Methods 0.000 claims abstract description 8
- 238000007405 data analysis Methods 0.000 claims abstract description 4
- 238000013480 data collection Methods 0.000 claims abstract description 4
- 238000000034 method Methods 0.000 claims description 8
- 238000005065 mining Methods 0.000 claims description 4
- 238000013475 authorization Methods 0.000 claims description 3
- 238000007670 refining Methods 0.000 claims description 3
- 238000007619 statistical method Methods 0.000 claims description 3
- 230000000007 visual effect Effects 0.000 claims description 3
- 238000007689 inspection Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 238000010223 real-time analysis Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2468—Fuzzy queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/20—Administration of product repair or maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Automation & Control Theory (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to an information management and analysis method based on a data mining technology, which comprises the steps of data collection, data processing, data analysis, data statistics, data display and equipment maintenance.
Description
Technical Field
The invention relates to an information management analysis method based on a data mining technology.
Background
The conventional method for evaluating the operation of the equipment is generally realized by means of regular manual inspection, routine inspection of equipment outage and the like, but the method has several problems: 1. periodic testing consumes labor and resources, but is inefficient. 2. Some unnecessary devices are also detected, and the waste of resources is caused. 3. The safety belts that would give the nuclear industry are disabled from immeasurable risks.
Disclosure of Invention
The technical problem to be solved by the invention is as follows: in order to overcome the defects of the prior art, an information management analysis method based on a data mining technology is provided.
The technical scheme adopted by the invention for solving the technical problems is as follows: an information management analysis method based on data mining technology comprises the following steps:
1) data collection: collecting all entrance guard events;
2) data processing: classifying the data collected in the step 1) to distinguish useful events;
3) and (3) data analysis: analyzing the data processed in the step 2), and refining each type of event into an independent unit;
4) and (3) data statistics: processing the information by applying a statistical method and a fuzzy set method to obtain a statistical result;
5) and (3) data display: presenting the statistical result obtained by mining the statistical data in the step 4) to a user in a visual mode;
6) equipment maintenance: the event is analyzed by step 5) to determine if maintenance of the device is required.
Preferably, in step 1), the access control event includes card swiping, password, exit button, duress code, manual door opening, and input and output.
Preferably, in step 2), the access converter service interfaces the access subsystem through the SDK, then writes the person, device and card authorization information into the subsystem through the interface, formats and classifies the events received by the access converter service, and then saves the events of the structure into the database through the interface, wherein the ID definitions of the type and subtype in the project are defined by the subsystem.
Preferably, in step 3), the data in the database are sorted by type, and an index is created, so that the data are pre-sorted inside the database.
Preferably, in step 4), a storage process script is created for the data analyzed in step 3), event types in the script are grouped, fuzzy query conditions are added, information of each equipment group is summarized into a memory table, then the life value of each equipment is compared with the memory table in an associated manner, and finally whether the service life of the equipment is reached or not can be judged.
The information management analysis method based on the data mining technology has the advantages that the event output by the equipment can be subjected to self-adaptive clustering analysis, the data model of the equipment is established, the prediction is carried out according to the model and the event record of the equipment operation, and the condition that the production safety cannot be guaranteed due to further expansion of faults is avoided.
Detailed Description
Example (b):
an information management analysis method based on data mining technology comprises the following steps:
1) data collection: collecting all entrance guard events;
2) data processing: classifying the data collected in the step 1) to distinguish useful events;
3) and (3) data analysis: analyzing the data processed in the step 2), and refining each type of event into an independent unit;
4) and (3) data statistics: processing the information by applying a statistical method and a fuzzy set method to obtain a statistical result;
5) and (3) data display: presenting the statistical result obtained by mining the statistical data in the step 4) to a user in a visual mode;
here, the various access records in the card swiping event can be embodied as the door opening times of the relay; the button clicking times can be seen through the statistical result of the going-out button; the number of times of using the keys of the card reader with the keyboard; and equipment early warning conditions and the like
6) Equipment maintenance: the event is analyzed by step 5) to determine if maintenance of the device is required.
The data mining technology can effectively solve some knowledge bottlenecks in equipment fault diagnosis and service life, is applied to equipment operation, effectively solves some difficulties in fault or service life, and judges appropriate time points in advance to replace relevant equipment.
Preferably, in step 1), the access control event includes card swiping, password, exit button, duress code, manual door opening, and input and output.
Preferably, in step 2), the access converter service interfaces the access subsystem through the SDK, then writes the person, device and card authorization information into the subsystem through the interface, formats and classifies the events received by the access converter service, and then saves the events of the structure into the database through the interface, wherein the ID definitions of the type and subtype in the project are defined by the subsystem.
For example, card swiping: the structure body comprises card swiping occurrence time, card number, name, type, subtype, card reader equipment and door equipment; when the card is normally swiped, the IDs of the type and the subtype are respectively 18-1, and the structure body is filled with other received item values; the card swiping cannot pass through (without permission) the type and subtype values 34-1, except that the name is empty, other corresponding values are filled into the structure body together with the received other item values; the password and the duress code are used for inquiring the setting of the password and the duress code according to the input content and then finding out corresponding values, and the IDs of the type and the subtype when the password and the duress code normally open the door are respectively as follows: 19-1 and 19-6; for the input content, if the corresponding setting value is not found, the password is wrong, and the IDs of the type and the subtype are respectively: 35-1, similarly, filling item values of different events into the structure, and finally saving the events of the structure through the interface, wherein the events are not received directly for system operation events and abnormal events which are not related to equipment.
Preferably, in step 3), the data in the database are sorted by type, and an index is created, so that the data are pre-sorted inside the database.
Preferably, in step 4), a storage process script is created for the data analyzed in step 3), event types in the script are grouped, fuzzy query conditions are added, information of each equipment group is summarized into a memory table, then the life value of each equipment is compared with the memory table in an associated manner, and finally whether the service life of the equipment is reached or not can be judged.
The data mining technology mainly refers to discovering and mining some implicit valuable and useful information and knowledge from a large amount of data, the extracted knowledge is generally expressed as modes, laws, rules and concepts, all objects of the data mining are defined into a data set of a database, and then corresponding data are extracted from the data set.
The analysis method is mainly carried out by adopting a database method, monitoring equipment in operation by utilizing a card swiping event and a computer technology, analyzing and processing different types of events and predicting equipment operation information. And information feedback of the alarm event is provided when necessary, so that the equipment damage event is avoided, and real-time analysis data is provided for equipment maintenance.
In light of the foregoing description of the preferred embodiment of the present invention, many modifications and variations will be apparent to those skilled in the art without departing from the spirit and scope of the invention. The technical scope of the present invention is not limited to the content of the specification, and must be determined according to the scope of the claims.
Claims (5)
1. An information management analysis method based on a data mining technology is characterized by comprising the following steps:
1) data collection: collecting all entrance guard events;
2) data processing: classifying the data collected in the step 1) to distinguish useful events;
3) and (3) data analysis: analyzing the data processed in the step 2), and refining each type of event into an independent unit;
4) and (3) data statistics: processing the information by applying a statistical method and a fuzzy set method to obtain a statistical result;
5) and (3) data display: presenting the statistical result obtained by mining the statistical data in the step 4) to a user in a visual mode;
6) equipment maintenance: the event is analyzed by step 5) to determine if maintenance of the device is required.
2. The information management analysis method based on the data mining technology as claimed in claim 1, wherein in the step 1), the access control event comprises card swiping, password, exit button, duress code, manual door opening, input and output.
3. The information management and analysis method based on data mining technology as claimed in claim 1, wherein in step 2), the access converter service interfaces the access subsystem through the SDK, then writes the personnel, equipment and card authorization information into the subsystem through the interface, the events received by the access converter service are formatted into a structure and classified, and then the events of the structure are saved into the database through the interface, wherein the ID definitions of the type and subtype in the project are all defined by the subsystem.
4. The information management and analysis method based on data mining technology as claimed in claim 1, wherein in step 3), the data in the database is sorted by type, and an index is created, so that the data is pre-sorted inside the database.
5. The information management and analysis method based on the data mining technology as claimed in claim 1, wherein in step 4), a storage process script is created for the data analyzed in step 3), event types in the script are grouped, fuzzy query conditions are added, information of each equipment group is gathered into a memory table, then the life value of each equipment is associated with the memory table for comparison, and finally whether the service life of the equipment is reached or not can be judged.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010322403.3A CN111538762A (en) | 2020-04-22 | 2020-04-22 | Information management analysis method based on data mining technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010322403.3A CN111538762A (en) | 2020-04-22 | 2020-04-22 | Information management analysis method based on data mining technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111538762A true CN111538762A (en) | 2020-08-14 |
Family
ID=71973040
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010322403.3A Pending CN111538762A (en) | 2020-04-22 | 2020-04-22 | Information management analysis method based on data mining technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111538762A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101741146A (en) * | 2010-02-11 | 2010-06-16 | 江苏方天电力技术有限公司 | Intelligent auxiliary monitoring terminal of transformer substation |
| CN101789630A (en) * | 2010-02-11 | 2010-07-28 | 江苏方天电力技术有限公司 | Monitoring system uniform platform of on-line monitoring and auxiliary equipment of transformer substation |
| CN107015517A (en) * | 2017-06-07 | 2017-08-04 | 浙江群力电气有限公司 | A kind of power equipment monitoring system |
| CN107025274A (en) * | 2017-03-21 | 2017-08-08 | 华中科技大学 | Equipment health status intelligent perception system and method based on Hadoop |
| CN107393264A (en) * | 2017-08-18 | 2017-11-24 | 江苏省烟草公司无锡市公司 | A kind of safety monitoring equipment centralized management method, apparatus and system |
| CN108564254A (en) * | 2018-03-15 | 2018-09-21 | 国网四川省电力公司绵阳供电公司 | Controller switching equipment status visualization platform based on big data |
| CN108810848A (en) * | 2018-06-06 | 2018-11-13 | 中国铁路总公司 | The real-time monitoring of CIR equipment and state analysis system and method |
-
2020
- 2020-04-22 CN CN202010322403.3A patent/CN111538762A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101741146A (en) * | 2010-02-11 | 2010-06-16 | 江苏方天电力技术有限公司 | Intelligent auxiliary monitoring terminal of transformer substation |
| CN101789630A (en) * | 2010-02-11 | 2010-07-28 | 江苏方天电力技术有限公司 | Monitoring system uniform platform of on-line monitoring and auxiliary equipment of transformer substation |
| CN107025274A (en) * | 2017-03-21 | 2017-08-08 | 华中科技大学 | Equipment health status intelligent perception system and method based on Hadoop |
| CN107015517A (en) * | 2017-06-07 | 2017-08-04 | 浙江群力电气有限公司 | A kind of power equipment monitoring system |
| CN107393264A (en) * | 2017-08-18 | 2017-11-24 | 江苏省烟草公司无锡市公司 | A kind of safety monitoring equipment centralized management method, apparatus and system |
| CN108564254A (en) * | 2018-03-15 | 2018-09-21 | 国网四川省电力公司绵阳供电公司 | Controller switching equipment status visualization platform based on big data |
| CN108810848A (en) * | 2018-06-06 | 2018-11-13 | 中国铁路总公司 | The real-time monitoring of CIR equipment and state analysis system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP1254402B1 (en) | Method and system for analyzing continuous parameter data for diagnostics and repairs | |
| AU660661B2 (en) | Knowledge based machine initiated maintenance system | |
| KR100976443B1 (en) | Home-network error prediction system and home-network fault estimation method | |
| CN111209131A (en) | Method and system for determining fault of heterogeneous system based on machine learning | |
| CN112561736A (en) | Fault diagnosis system and method for relay protection device of intelligent substation | |
| CN114267178B (en) | Intelligent operation maintenance method and device for station | |
| CN111186741B (en) | Elevator door system health maintenance method and device | |
| CN112462734B (en) | Industrial production equipment fault prediction analysis method and model | |
| CN116382217A (en) | Intelligent operation and maintenance monitoring system for production line | |
| CN111159272A (en) | Data quality monitoring and early warning method and system based on data warehouse and ETL | |
| CN115358155A (en) | Power big data abnormity early warning method, device, equipment and readable storage medium | |
| CN113468022B (en) | Automatic operation and maintenance method for centralized monitoring of products | |
| CN117170303B (en) | PLC fault intelligent diagnosis maintenance system based on multivariate time sequence prediction | |
| CN108700872A (en) | Machine sort device | |
| CN111538762A (en) | Information management analysis method based on data mining technology | |
| CN117113135A (en) | Carbon emission anomaly monitoring and analyzing system capable of sorting and classifying anomaly data | |
| CN116468423A (en) | Operation and maintenance emergency coordination method, system and terminal equipment | |
| Takano et al. | Psychological biases affecting human cognitive performance in dynamic operational environments | |
| CN113643154B (en) | Relay protection constant value intelligent auditing system | |
| CN110674193A (en) | Intelligent substation relay protection fault information modeling method | |
| CN113656666B (en) | Relay protection fixed value data interaction method | |
| CN117473241B (en) | Clinical trial progress statistics and analysis tool based on big data | |
| KR20230172091A (en) | Elevator Failure Diagnosis System Using Recurrent Neural Network Model | |
| CN117827608A (en) | Intelligent early warning and disposal method based on historical monitoring data | |
| CN114281635A (en) | Server violation operation recognition 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: 20200814 |
|
| RJ01 | Rejection of invention patent application after publication |