CN114418355A - Method and device for determining service cycle of crusher constructed based on data view - Google Patents

Method and device for determining service cycle of crusher constructed based on data view Download PDF

Info

Publication number
CN114418355A
CN114418355A CN202111667327.0A CN202111667327A CN114418355A CN 114418355 A CN114418355 A CN 114418355A CN 202111667327 A CN202111667327 A CN 202111667327A CN 114418355 A CN114418355 A CN 114418355A
Authority
CN
China
Prior art keywords
crusher
data
attribute information
actual
data view
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
CN202111667327.0A
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.)
China Coal Industry Group Information Technology Co ltd
Original Assignee
China Coal Industry Group Information 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 China Coal Industry Group Information Technology Co ltd filed Critical China Coal Industry Group Information Technology Co ltd
Priority to CN202111667327.0A priority Critical patent/CN114418355A/en
Publication of CN114418355A publication Critical patent/CN114418355A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063—Operations research, analysis or management
    • G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • 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/242—Query formulation
    • G06F16/2433—Query languages
    • 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/25—Integrating or interfacing systems involving database management systems

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Strategic Management (AREA)
  • Development Economics (AREA)
  • Educational Administration (AREA)
  • Quality & Reliability (AREA)
  • General Business, Economics & Management (AREA)
  • Game Theory and Decision Science (AREA)
  • Tourism & Hospitality (AREA)
  • Operations Research (AREA)
  • Marketing (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The application provides a crusher use period determining method and device based on data view construction. The method comprises the following steps: performing attribute carding on the core point of the crusher to obtain first attribute information of the core point of the crusher; performing attribute carding on the production environment of the crusher to obtain second attribute information of the production environment of the crusher; constructing a service cycle data view of the crusher based on the first attribute information and the second attribute information; inserting the usage period data view into a database based on a database language, and acquiring data based on the usage period data view in the database to obtain actual acquisition data based on the usage period data view; the actual life cycle of the crusher is calculated based on the actual collected data. The application provides a coal preparation plant breaker actual service cycle's definite mode, guarantees the degree of accuracy that actual service cycle calculated, provides the basis for the service cycle analysis of coal preparation plant breaker.

Description

Method and device for determining service cycle of crusher constructed based on data view
Technical Field
The application relates to the field of algorithm calculation of crushing production equipment and environmental physical quantities of a coal preparation plant, in particular to production business relation and algorithm calculation, and particularly relates to a crusher use period determining method and device based on data view construction.
Background
With the coming of the gold period of new coal production, the coal production capacity is greatly increased. Coal is used as an essential raw material for chemical industry, production and life, and plays a key role in stable operation of the whole society. As a production link for crushing and washing raw coal, the normal operation and the service cycle analysis of washing equipment become an important work for ensuring the coal washing production. Therefore, the analysis of the service cycle of the crusher in the coal preparation plant becomes an urgent need for washing service.
Disclosure of Invention
The present application is directed to solving, at least to some extent, one of the technical problems in the related art.
Therefore, a first objective of the present application is to provide a method for determining a service life of a crusher constructed based on a data view, which can provide a determination manner for an actual service life of a crusher in a coal preparation plant, ensure accuracy of calculation of the actual service life, and provide a basis for service life analysis of the crusher in the coal preparation plant.
A second object of the present application is to propose a crusher life determining device constructed on the basis of data views.
A third object of the present application is to propose a computer device.
A fourth object of the present application is to propose a computer readable storage medium.
To achieve the above object, an embodiment of a first aspect of the present application provides a method for determining a usage period of a crusher constructed based on data views, including:
performing attribute carding on a core point of a crusher to obtain first attribute information of the core point of the crusher;
performing attribute carding on the production environment of the crusher to obtain second attribute information of the production environment of the crusher;
constructing a usage period data view of the crusher based on the first attribute information and the second attribute information;
inserting the service cycle data view into a database based on a database language, and acquiring data based on the service cycle data view in the database to obtain actual acquired data based on the service cycle data view;
calculating an actual life cycle of the crusher based on the actual collected data.
To achieve the above object, a second aspect of the present application provides a crusher usage period determining apparatus constructed based on data views, including:
the first acquisition module is used for performing attribute carding on the core point of the crusher to acquire first attribute information of the core point of the crusher;
the second acquisition module is used for performing attribute carding on the production environment of the crusher to obtain second attribute information of the production environment of the crusher;
a construction module for constructing a usage period data view of the crusher based on the first attribute information and the second attribute information;
the data processing module is used for inserting the service cycle data view into a database based on a database language, acquiring data based on the service cycle data view in the database and acquiring actual acquisition data based on the service cycle data view;
and the calculation module is used for calculating the actual service cycle of the crusher based on the actual acquisition data.
To achieve the above object, an embodiment of a third aspect of the present application provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the method according to the foregoing embodiment of the first aspect.
In order to achieve the above object, a fourth aspect of the present application provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method according to the foregoing first aspect.
According to the technical scheme, the method and the device for determining the actual service cycle of the crusher in the coal preparation plant can be provided, the accuracy of calculation of the actual service cycle is guaranteed, and a basis is provided for analysis of the service cycle of the crusher in the coal preparation plant.
Additional aspects and advantages of the present application will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the present application.
Drawings
The foregoing and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
fig. 1 is a schematic flow chart of a method for determining a usage period of a crusher based on data view construction according to an embodiment of the present application;
FIG. 2 is a diagram illustrating an example of usage cycle data in accordance with an embodiment of the present application;
FIG. 3 is a schematic flow chart of another method for determining the usage period of a crusher based on data view construction according to an embodiment of the present application;
FIG. 4 is a schematic structural diagram of a crusher use period determining device constructed based on data views according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of another crusher use period determining device constructed based on data views according to an embodiment of the present application.
Fig. 6 is a block diagram of a computer device according to an embodiment of the present disclosure.
Detailed Description
Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary and intended to be used for explaining the present application and should not be construed as limiting the present application.
The crusher use period determination method and apparatus constructed based on data views according to the embodiments of the present application are described below with reference to the accompanying drawings.
Fig. 1 is a schematic flow chart of a method for determining a usage period of a crusher, which is constructed based on a data view according to an embodiment of the present application. As shown in fig. 1, the crusher usage period determining method constructed based on the data view may include the following steps.
101, performing attribute carding on the core point of the crusher to obtain first attribute information of the core point of the crusher.
Optionally, the core point location is captured by analyzing the core point location of the crusher, and the attribute carding is performed on the core point location of the crusher to obtain first attribute information of the core point location of the crusher.
For example, the physical quantities of the production core points of the crusher are selected, such as: and performing attribute carding on the physical quantities of the core point positions to obtain first attribute information of the core point positions of the crusher. For example, the crusher core point physical properties are shown in table 1 below:
TABLE 1 core point physical Property Table of crusher
Figure BDA0003452090550000051
And 102, performing attribute carding on the production environment of the crusher to obtain second attribute information of the production environment of the crusher.
Optionally, the environmental physical quantities acquired by the environmental sensors in the production environment of the crusher are collected, and the environmental physical quantities acquired by the environmental sensors are subjected to attribute carding to obtain second attribute information of the production environment of the crusher. For example, physical quantities of various environment sensors of the production environment of the crusher, such as humidity, temperature and the like, are selected, and attribute carding is performed on the physical quantities of the environment sensors to obtain second attribute information of the production environment of the crusher. For example, the crusher production environment has the following physical properties of the environmental sensors as shown in table 2:
TABLE 2 crusher production Environment sensor physical Property Table
Figure BDA0003452090550000052
Figure BDA0003452090550000061
And 103, constructing a service cycle data view of the crusher based on the first attribute information and the second attribute information.
Optionally, taking the production work orders with the same crushing amount as a service main key, checking the first attribute information and the second attribute information, and constructing a service cycle data view of the crusher. That is, the actual production work order can be used as the main key object for associating the core point attribute of the crusher with the production environment attribute, and the two types of attributes are checked together to form the service cycle data view of the crusher in the coal preparation plant.
For example, the 'crushing work order code' is used as a main key, and attribute checking is carried out on the physical quantity of the crusher point and the physical quantity of the sensor to obtain a service cycle data view of the crusher of the coal preparation plant. The service cycle data view of the crusher of the coal preparation plant can be shown in the following table 3:
Figure BDA0003452090550000062
Figure BDA0003452090550000071
in an embodiment of the present application, the usage period data view may include the name, type, length, unit, and the like of the core physical quantity.
And 104, inserting the usage period data view into the database based on the database language, and acquiring data based on the usage period data view in the database to obtain actual acquired data based on the usage period data view.
Optionally, the usage period data view of the coal preparation plant crusher is compiled through a database language and inserted into the database. For example, taking the database as a Mysql database as an example, the above table 3 physical quantities may be subjected to language assembly through SQL language to generate an SQL file, and the generated SQL file is imported into the Mysql database to form a usage period data view of the crusher, where an example of the usage period data view after the Mysql database is imported may be as shown in fig. 2.
In the embodiment of the application, after the usage period data view is inserted into the database, the crusher core point physical quantity and the sensor physical quantity data can be acquired into the usage period view of the crusher through the Kafka technology or a structured database in the related technology, so that data collection under the view is realized, and the actual acquired data based on the usage period data view is obtained.
Step 105, calculating the actual service life of the crusher based on the actual collected data.
Optionally, after obtaining the actual acquisition data based on the usage period data view, the actual usage period of the crusher may be calculated based on the actual acquisition data.
In the embodiment of the present application, the calculation formula of the actual usage period is expressed as follows:
Figure BDA0003452090550000072
wherein x isiActually collecting data for the ith; the actually acquired data are physical quantity data which are actually acquired except for the codes of the crusher equipment, the work orders of the crusher equipment, the codes of the sensors and the used period.
For example, the algorithm is calculated by taking 100 ten thousand tons of crushing weight on a name plate of the crusher and 5 months of service life as standard values. The method comprises the steps of acquiring physical quantities except a crushing equipment code, a crushing equipment work order, a sensor code and a used period from actually acquired data recorded in a using period data view in a database, and calculating by using an actual using period calculation formula. For example, it is assumed that the physical quantities of the actually acquired data recorded in the usage period data view, except for the crushing equipment code, the crushing equipment work order, the sensor code and the used period, are respectively: the actual service life of the crusher can be obtained by substituting the numerical values of the physical quantities into the calculation formula, wherein the crushing weight is 120 tons, the feed particles are 210mm, the motor temperature is 42 ℃, the working angle is 32.1 ℃, the ground flatness is 3.3 degrees, the sulfur dioxide concentration is 12.5 percent, the humidity is 62 percent, the decibel is 23db, the temperature is 25 ℃ and the oxygen concentration is 92 percent: [ (120+210+42+32.1+3.3+12.5+62+23+25+92) × 2-1000]/60 ═ 4.06 (month).
The above formula for calculating the actual usage period is determined by a great deal of experiments and by practical experience. That is, the inventor found out through a large number of experiments and practical experience that the service life of the crusher can be represented by a value obtained by adding values of physical quantities other than the crushing equipment code, the crushing equipment work order, the sensor code and the used period, dividing the sum by 2, subtracting 1000 and dividing by 60, and thus, a calculation formula defining the actual service life is as shown in the above formula 1.
According to the method for determining the service cycle of the crusher constructed based on the data view, a determination mode of the actual service cycle of the crusher in the coal preparation plant can be provided, the calculation accuracy of the actual service cycle is guaranteed, and a basis is provided for the service cycle analysis of the crusher in the coal preparation plant.
In some embodiments of the present application, as shown in fig. 3, based on the embodiment shown in fig. 1, the method for determining the usage period of the crusher constructed based on the data view may further include:
step 301, determining standard cycle data of a crusher; wherein the standard period data is the service period of the crusher on the nameplate.
Alternatively, the period of use on the name plate of the crusher can be used as standard period data of the crusher. For example, the standard cycle data of the crusher may be stored in a database in advance, from which the standard cycle data of the crusher may be obtained.
Step 302, comparing the standard period data with the actual use period to obtain a comparison result.
Optionally, the standard period data is compared with the actual usage period obtained by calculation to obtain the comparison result. The comparison result may be that the actual usage period is less than the standard period data, or that the actual usage period is greater than or equal to the standard period data.
And 303, analyzing the use condition of the crusher based on the actual collected data and the comparison result to determine the reason of the comparison result.
Optionally, the usage of the crusher may be analyzed based on the actual collected data and the comparison results recorded in the usage period data view to determine the cause of the comparison results. For example, assuming that the actual usage period is 4.06 (months), the standard period data is 5 months, and the comparison result is that the actual usage period is smaller than the standard period data, the actually collected data may be 120 tons of crushing weight, 210mm of feeding particles, 42 ℃ of motor temperature, 32.1 ℃ of working angle, 3.3 ° of ground flatness, 12.5% of sulfur dioxide concentration, 62% of humidity, 23db of decibel, 25 ℃ of temperature, and 92% of oxygen concentration, and the analysis may determine that the reason for the comparison result that the actual usage period is smaller than the standard period data is the overweight of crushing weight of the crusher.
According to the method for determining the service cycle of the crusher constructed based on the data view, after the comparison result of the actual collected data and the standard cycle data is obtained, the service condition of the crusher is analyzed based on the actual collected data and the comparison result to determine the reason causing the comparison result, so that the length of the service cycle of the crusher and the reason causing the result can be judged, and the service personnel of a coal preparation plant can be helped to analyze the service cycle of the crusher.
In order to realize the embodiment, the application also provides a crusher use period determining device constructed based on the data view.
Fig. 4 is a schematic structural diagram of a crusher use period determining device constructed based on data views according to an embodiment of the present application. As shown in fig. 4, the crusher usage period determining apparatus 400 constructed based on the data view may include: a first acquisition module 401, a second acquisition module 402, a construction module 403, a data processing module 404 and a calculation module 405.
The first obtaining module 401 is configured to perform attribute combing on the core point of the crusher to obtain first attribute information of the core point of the crusher.
The second obtaining module 402 is configured to perform attribute combing on the production environment of the crusher to obtain second attribute information of the production environment of the crusher. Optionally, the second obtaining module 402 collects environmental physical quantities collected by various environmental sensors in the production environment of the crusher; and (4) performing attribute carding on the environmental physical quantities acquired by the environmental sensors to obtain second attribute information of the production environment of the crusher.
The construction module 403 is configured to construct a usage period data view of the crusher based on the first attribute information and the second attribute information. Optionally, the building module 403 uses the production work orders with the same crushing amount as the service key, checks the first attribute information and the second attribute information, and builds the service cycle data view of the crusher.
The data processing module 404 is configured to insert the usage period data view into the database based on the database language, and perform data acquisition based on the usage period data view in the database, so as to obtain actual acquisition data based on the usage period data view.
In the embodiment of the present application, the calculation formula of the actual usage period is expressed as follows:
Figure BDA0003452090550000101
wherein x isiActually collecting data for the ith; wherein the actually acquired data are codes of the crusher equipment, work orders of the crusher equipment, codes of the sensor and the used periodEach of the actually collected physical quantity data.
The calculation module 405 is used to calculate the actual life cycle of the crusher based on the actual collected data.
In some embodiments of the present application, as shown in fig. 5, the crusher usage period determining apparatus constructed based on the data view may further include: a determination module 506, an alignment module 507 and a cause analysis module 508. Wherein the determining module 506 is configured to determine standard period data of the crusher; wherein the standard period data is the service period of the crusher nameplate; the comparison module 507 is configured to compare the standard cycle data with the actual usage cycle to obtain a comparison result; the reason analyzing module 508 is used for analyzing the usage of the crusher based on the actually collected data and the comparison result to determine the reason for the comparison result. Wherein 501-505 in fig. 5 and 401-405 in fig. 4 have the same functions and structures.
It should be noted that the foregoing explanation on the embodiment of the method for determining the usage period of the crusher constructed based on the data view is also applicable to the device for determining the usage period of the crusher constructed based on the data view in this embodiment, and is not repeated here.
According to the device for determining the service cycle of the crusher constructed based on the data view, a determination mode of the actual service cycle of the crusher in the coal preparation plant can be provided, the calculation accuracy of the actual service cycle is guaranteed, and a basis is provided for the service cycle analysis of the crusher in the coal preparation plant.
In order to implement the above embodiments, the present application also provides a computer device. As shown in fig. 6, the computer device 600 may include a memory 601, a processor 602, and a computer program 603 stored on the memory 601 and executable on the processor 602, and when the processor 602 executes the computer program 603, the crusher usage period determination method constructed based on data view as described in any of the above embodiments is implemented.
In order to achieve the above embodiments, the present application also proposes a computer-readable storage medium, on which a computer program is stored, which when executed by a processor implements the method for determining a usage period of a crusher constructed based on data views as described in any of the above embodiments.
In the description herein, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present application, "plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing steps of a custom logic function or process, and alternate implementations are included within the scope of the preferred embodiment of the present application in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present application.
The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. If implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present application may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc. Although embodiments of the present application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present application, and that variations, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present application.

Claims (10)

1. A method for determining the service life of a crusher constructed based on a data view is characterized by comprising the following steps:
performing attribute carding on a core point of a crusher to obtain first attribute information of the core point of the crusher;
performing attribute carding on the production environment of the crusher to obtain second attribute information of the production environment of the crusher;
constructing a usage period data view of the crusher based on the first attribute information and the second attribute information;
inserting the service cycle data view into a database based on a database language, and acquiring data based on the service cycle data view in the database to obtain actual acquired data based on the service cycle data view;
calculating an actual life cycle of the crusher based on the actual collected data.
2. The method according to claim 1, wherein the attribute carding of the production environment of the crusher to obtain second attribute information of the production environment of the crusher comprises:
collecting environmental physical quantities acquired by various environmental sensors in the production environment of the crusher;
and performing attribute carding on the environmental physical quantities acquired by the environmental sensors to obtain second attribute information of the production environment of the crusher.
3. The method of claim 1, wherein constructing the usage period data view of the crusher based on the first attribute information and the second attribute information comprises:
and taking the production work orders with the same crushing amount as a service main key, checking the first attribute information and the second attribute information, and constructing a service cycle data view of the crusher.
4. The method according to claim 1, wherein the calculation formula of the actual usage period is expressed as follows:
Figure FDA0003452090540000021
wherein x isiActually collecting data for the ith; the actually acquired data are actually acquired physical quantity data except for the codes of the crusher equipment, the work orders of the crusher equipment, the codes of the sensors and the used period.
5. The method of claim 1, further comprising:
determining standard period data of the crusher; wherein the standard period data is a service period on the crusher nameplate;
comparing the standard period data with the actual use period to obtain a comparison result;
analyzing the use condition of the crusher based on the actual collected data and the comparison result to determine the reason of the comparison result.
6. A crusher usage period determining apparatus constructed based on a data view, comprising:
the first acquisition module is used for performing attribute carding on the core point of the crusher to acquire first attribute information of the core point of the crusher;
the second acquisition module is used for performing attribute carding on the production environment of the crusher to obtain second attribute information of the production environment of the crusher;
a construction module for constructing a usage period data view of the crusher based on the first attribute information and the second attribute information;
the data processing module is used for inserting the service cycle data view into a database based on a database language, acquiring data based on the service cycle data view in the database and acquiring actual acquisition data based on the service cycle data view;
and the calculation module is used for calculating the actual service cycle of the crusher based on the actual acquisition data.
7. The apparatus of claim 6, wherein the second obtaining module is specifically configured to:
collecting environmental physical quantities acquired by various environmental sensors in the production environment of the crusher;
and performing attribute carding on the environmental physical quantities acquired by the environmental sensors to obtain second attribute information of the production environment of the crusher.
8. The apparatus of claim 6, further comprising:
a determination module for determining standard cycle data of the crusher; wherein the standard period data is a service period on the crusher nameplate;
the comparison module is used for comparing the standard period data with the actual use period to obtain a comparison result;
and the reason analysis module is used for analyzing the use condition of the crusher based on the actual collected data and the comparison result so as to determine the reason causing the comparison result.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor, when executing the program, implements the method according to any of claims 1-5.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-5.
CN202111667327.0A 2021-12-31 2021-12-31 Method and device for determining service cycle of crusher constructed based on data view Pending CN114418355A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111667327.0A CN114418355A (en) 2021-12-31 2021-12-31 Method and device for determining service cycle of crusher constructed based on data view

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111667327.0A CN114418355A (en) 2021-12-31 2021-12-31 Method and device for determining service cycle of crusher constructed based on data view

Publications (1)

Publication Number Publication Date
CN114418355A true CN114418355A (en) 2022-04-29

Family

ID=81270490

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111667327.0A Pending CN114418355A (en) 2021-12-31 2021-12-31 Method and device for determining service cycle of crusher constructed based on data view

Country Status (1)

Country Link
CN (1) CN114418355A (en)

Similar Documents

Publication Publication Date Title
CN109034244B (en) Line loss abnormity diagnosis method and device based on electric quantity curve characteristic model
CN111563606A (en) Equipment predictive maintenance method and device
CN107908533B (en) A kind of monitoring method, device, computer readable storage medium and the equipment of database performance index
CN114328075A (en) Intelligent power distribution room sensor multidimensional data fusion abnormal event detection method and system and computer readable storage medium
CN118051863B (en) Health data acquisition system and method based on digital metering technology
CN117556366B (en) Data abnormality detection system and method based on data screening
CN118067204B (en) Safety production data acquisition system based on digital metering technology
CN116879831A (en) Intelligent ammeter monitoring method and system based on Internet of things
CN110399903B (en) Abnormal data detection method and device and computer readable storage medium
US7171314B2 (en) Methods and systems for analyzing structural test data
CN117994955A (en) Method and device for building and alarming temperature alarm model of hydroelectric generating set
CN114418355A (en) Method and device for determining service cycle of crusher constructed based on data view
CN115663812B (en) Direct current transmission system reliability assessment method and system
CN116817983A (en) Data analysis method, data analysis recorder and storage medium
CN116380228A (en) Method, system, terminal and storage medium for monitoring operation of weighing apparatus
CN116912061A (en) Soil ecological environment monitoring and management method and system based on big data
CN115496143A (en) Method and device for detecting abnormity of blast furnace thermocouple temperature measurement data and storage medium
CN114975184A (en) Semiconductor yield monitoring method and device, electronic equipment and storage medium
CN114548673A (en) Emission reduction index monitoring method and device
CN113761103A (en) Batch data processing method and device and electronic equipment
CN110991940A (en) Ocean observation data product quality online inspection method and device and server
CN116448062B (en) Bridge settlement deformation detection method, device, computer and storage medium
CN116303356B (en) Construction method of production man-hour database, and determination method and device of production man-hour
CN116295741B (en) Weight monitoring method and system based on air cushion
CN111626586B (en) Data quality detection method, device, computer equipment and storage medium

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