CN104239560A - Opencast blasting data analysis and management system and method - Google Patents
Opencast blasting data analysis and management system and method Download PDFInfo
- Publication number
- CN104239560A CN104239560A CN201410503119.0A CN201410503119A CN104239560A CN 104239560 A CN104239560 A CN 104239560A CN 201410503119 A CN201410503119 A CN 201410503119A CN 104239560 A CN104239560 A CN 104239560A
- Authority
- CN
- China
- Prior art keywords
- data
- blasting
- analysis
- module
- explosion
- 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.)
- Granted
Links
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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Drilling And Exploitation, And Mining Machines And Methods (AREA)
Abstract
The invention discloses an opencast blasting data analysis and management system. The system comprises a data acquisition module, a data storage module, a data analysis and comparison module and a report display module, wherein the data acquisition module is used for acquiring opencast blasting data of users and acquiring blasting information of blasting operations in all opencast blasting projects; the data storage module is used for storing and managing blasting data information of the data acquisition module and storing blasting historical data information; the data analysis and comparison module is used for analyzing and comparing the blasting data information, acquired by the data acquisition module, and the blasting historical data information and calculating optimal opencast blasting data, so as to carry out on-site blasting work; the report display module is used for displaying the optimal opencast blasting data, obtained after comparing and analyzing, the blasting historical data information and the blasting information of the data acquisition module.
Description
Technical field
The present invention relates to a kind of surface blasting application system, particularly relate to a kind of surface blasting data analysis management system and method.
Background technology
For larger Min Bao enterprise, subordinate's blasting operation project management department is more, and setting is distributed in all parts of the country widely; And along with the develop rapidly of blasting technique, equipment, blasting scale is also increasing, such as adopt the outdoor medium-length hole blasting of bulk mixing truck powder charge, onepull explosive load tens tons, ton up to a hundred are very common.And each blasting operation point differs from one another, as different in lithology, the explosive type difference of employing, Hole pattern parameters are different etc.The explosion data that numerous blasting operation point is formed are for the intellectual property Min Bao enterprise being a kind of preciousness.By explosion data preparation, the statistics to each blasting operation point, analyze, compare, can determine that blasting technique is comparatively advanced, blasting parameter comparatively reasonably blasting operation point, reference information can be provided for the aspect such as explosion design, construction in the rational not setting of blasting operation and new project portion.But, because huge explosion data make Blasting Enterprise managerial personnel and person skilled cannot obtain constituent parts explosion situation rapidly, to such an extent as to each work unit can not be resolved in time at technology, economic aspect Problems existing, badly influence demolition effect and the economic benefit of blast working.
At present, the data message of each side such as the production of Min Bao enterprise, explosion, cost, profit is enumerated in Min Bao enterprise available data analytic system.Min Bao enterprise wishes that the data obtaining explosion relevant from available data analytic system carry out blasting technique analysis.But the available data analytic system of economically setting out is extracted from data or is all lacked professional and specific aim data analysis, available data analytic system is just added up explosion data, the data item that can extract can not meet the needs instructing blasting operation completely, and the aspect such as explosion design, construction provides reference information.
Summary of the invention
The present invention is intended at least solve the technical matters existed in prior art, especially innovatively proposes a kind of surface blasting data analysis management system and method.
In order to realize above-mentioned purpose of the present invention, the invention provides a kind of surface blasting data analysis management system, its key is, comprising: data acquisition module, data memory module, data analysis contrast module and report display module; Data acquisition module connection data memory module, data memory module connection data analysis contrast module, data analysis contrast model calling report display module;
Data acquisition module, for the surface blasting data of user being gathered, gathers the blasting information of each surface blasting project borehole blasting operation;
Data memory module, for carrying out store and management to the explosion data message of data acquisition module, and stores explosion historical data information;
Data analysis contrast module, carries out for the explosion data message that gathers data acquisition module and explosion historical data information analysiss and contrasts, calculate optimum surface blasting data, carry out on-the-spot blasting work;
Report display module, the optimum surface blasting data after analyzing for display comparison, and the blasting information of explosion historical data information and data acquisition module.
The beneficial effect of technique scheme is: by data acquisition module, data memory module, and data analysis contrast module and report display module cooperatively interact and realize surface blasting data analysis management, manage efficient and convenient.
Described surface blasting data analysis management system, preferably, described data acquisition module comprises:
Project management department's explosion data module, for carrying out collection in worksite to surface blasting data, the data gathered are the explosion date, explosion type, by the lithology of quick-fried rock mass, explosive type, bench height, bore diameter, drilling depth, boring number, pitch-row, reject, stemming length, design unit consumption, drill footage, explosive load, detonator consumption, explosion side amount and operation recruitment, above-mentioned gathered data are transferred to data memory module;
Described project management department explosion data module also comprises, explosion type block, for being bench blasting, secondary blasting and the presplitting blasting of light face by the state demarcation of explosion, the explosion data of bench blasting, secondary blasting and the presplitting blasting of light face are stored into data memory module; Lithologic analysis module, for the rock mass lithology after explosion being analyzed, determines the explosion rock mass lithology of coal petrography, mud stone, shale, sandstone, ls, grouan; Explosive type module, for determining that according to rock mass lithology use loads in mixture ammonium nitrate fuel oil mixture, the mixed loading emulsion explosive, loads in mixture titania-mica and finished explosive products.
The beneficial effect of technique scheme is: carry out collection analysis by data acquisition module to surface blasting data, and the data of analysis are used for surface blasting and use.
Described surface blasting data analysis management system, preferably, described data memory module comprises:
History data store module, for history surface blasting data being stored, being convenient to subsequent data analysis contrast module and carrying out calling work;
Data management module, for carrying out store and management to the explosion data message of data acquisition module, utilizes MS SQL server to set up the database storing explosion relevant information; Data importing first by data upload to server, by data preview, and data are screened, are imported in database, then the file uploaded is deleted from server, Free up Memory, guarantee the stability of system database;
Data classifying module, set up for the relation of database root according to technology form, preserve different entity classes, and have corresponding incidence relation table, by database manipulation language, data are retrieved, retouching operation, a surface blasting historical data is often analyzed by data analysis contrast module, draw analysis result, be stored in result table, record this analysis operation simultaneously, database comprises user profile, unit information and explosion data, user profile is used for user and logs in and user operation rights management, user carries out corresponding operating according to authority different pairs according to storehouse, unit information is used for user identity identification, data management module, the data starting when importing data to import with regard to reply carry out unit information association, and then carry out according to unit in data statistics with when analyzing, unit information is divided into project management department and the operation unit two large divisions belonging to it, the managerial demand administrator right of unit information operates, different pairs according to user has different operating rights according to library facility module.
The beneficial effect of technique scheme is: stored history data store by data memory module, by data management and data classifying module, the data of historical data and Real-time Collection is carried out corresponding analysis.
Described surface blasting data analysis management system, preferably, described data analysis contrast module comprises:
Data for extracting related data in data memory module, are carried out adding up, Classification Management by data statistics module;
Described data statistics module comprises: bench blasting statistical module, secondary blasting statistical module, light face presplitting blasting statistical module
Bench blasting statistical module, for collecting bench blasting side's amount, boring amount, explosive charge, detonator amount and work consumption in advance, bench blasting side's amount, explosive charge and detonator amount carry out statistical study according to comprehensive, lithology, bore diameter respectively, and boring amount and work consumption carry out statistical study according to lithology and bore diameter respectively; Secondary blasting statistical module, for collecting secondary blasting rock drilling amount, explosive charge, detonator amount and work consumption in advance, secondary blasting rock drilling amount, explosive charge, detonator amount and work consumption carry out statistical study according to lithology respectively; Light face presplitting blasting statistical module, for receiving light-collecting surface presplitting explosive charge, primacord fuse amount and work consumption in advance, light face presplitting explosive charge, primacord fuse amount and work consumption carry out statistical study according to lithology respectively;
Data analysis module, utilize surface blasting algorithm, described surface blasting algorithm comprises the computing method of explosive specific charge, blasting output per meter hole, explosive load, detonator amount, pencil ratio, work loss-rate, rock drilling amount, borehole spacing counter bored holes diameter multiple, for analyzing the data result of data statistics module, comprise bench blasting analysis module, secondary blasting analysis module and light face presplitting blasting analysis module;
Described bench blasting analysis module is divided into explosive specific charge analysis indexes, blasting output per meter hole analysis indexes, explosive consumption analysis indexes, detonator dosage analysis index, pencil than analysis indexes and work consumption analysis index; Explosive specific charge analysis indexes refer to the rock of explosion unit volume consume the quality of explosive, carry out classification analysis by lithology; Blasting output per meter hole index refer to every meter hole quick-fried fall rock mass side amount, carry out classification analysis according to lithology and bore diameter; Explosive consumption analysis indexes adopts every explosive consumption incomparably to represent, every explosive consumption incomparably refers to the explosive load that explosion 10,000 side rock mass consumes, and carries out classification analysis according to lithology and bore diameter; Detonator dosage analysis index adopts every detonator consumption incomparably to represent, every detonator consumption incomparably refers to carry out classification analysis according to lithology and bore diameter by the detonator consumption that explosion 10,000 side rock mass consumes; Pencil refers to the ratio of the total consumption of each rendrock and the total consumption of detonator than analysis indexes, carries out classification analysis according to lithology and bore diameter; Work consumption analysis index power dissipation ratio represents, i.e. the operation recruitment person-time set out of every explosion 10,000 side rock mass, carries out classification analysis according to lithology and bore diameter; Secondary blasting analysis module is divided into rock drilling component analysis index, explosive consumption analysis indexes, detonator dosage analysis index and work consumption analysis index; Wherein explosive consumption analysis indexes, detonator dosage analysis index, work consumption analysis index meaning are identical with bench blasting; The every rock drilling amount incomparably of rock drilling component analysis index represents, the big gun pore volume bored when rock drilling amount refers to secondary drilling, and every rock drilling amount incomparably refers to the secondary drilling volume required for every explosion 10,000 side rock mass; The presplitting blasting of light face is analyzed modulus and is comprised every light face presplitting blasting areal analysis index and borehole spacing counter bored holes diameter multiple analysis indexes incomparably; Every all places light face presplitting blasting areal analysis index refers to the ratio in every explosion 10,000 side rock mass shared by light face presplitting blasting area, and presplitting area in light face refers to the product of borehole spacing on the pre-broken face in light face and drill footage; Borehole spacing counter bored holes diameter multiple analysis indexes refers to the ratio of borehole spacing on presplitting blasting face and blasthole diameter;
Data analysis contrast submodule, for being analyzed the result of data statistics subsystem and data analytics subsystem;
Described data analysis contrast submodule comprises longitudinal comparative analysis module and across comparison analysis module, longitudinal comparative analysis module, for the comparative analysis of the relevant explosion statistical study index to project management department's different time sections; Across comparison analysis module, for the comparative analysis of the relevant explosion statistical study index between disparity items portion in same time section.
The beneficial effect of technique scheme is: by the work of data analysis contrast module, to surface blasting data analysis.
Described surface blasting data analysis management system, preferably, described report display module comprises: by data statistics, analysis and comparing result, statistic of classification, conclusion are carried out to statistics, analysis and comparing result, and printed, export, preserve, adopt form, in 3-D histogram, two-dimensional histogram, pie chart, curve map or broken line graph, at least one presents patterned mode and carries out output display.
The beneficial effect of technique scheme is: shown the data after analysis by report display module.
The present invention also discloses a kind of surface blasting data analysis management method, and its key is, comprises the steps:
Step 1, is gathered by the surface blasting data of data acquisition module by user, gathers the blasting information of each surface blasting project borehole blasting operation;
Step 2, carries out store and management by the explosion data message of data memory module to data acquisition module, and stores explosion historical data information;
Step 3, the explosion data message gathered data acquisition module by data analysis contrast module and explosion historical data information are carried out analysiss and are contrasted, and calculate optimum surface blasting data, carry out on-the-spot blasting work;
Step 4, the optimum surface blasting data after being analyzed by report display module display comparison, and the blasting information of explosion historical data information and data acquisition module.
In sum, owing to have employed technique scheme, the invention has the beneficial effects as follows:
By data acquisition module, data memory module, data analysis contrast module and report display module cooperatively interact and realize surface blasting data analysis management, manage efficient and convenient.
Carry out collection analysis by data acquisition module to surface blasting data, the data of analysis are used for surface blasting and use.
By data memory module, history data store is stored, by data management and data classifying module, the data of historical data and Real-time Collection are carried out corresponding analysis.
By the work of data analysis contrast module, to surface blasting data analysis.
By report display module, the data after analysis are shown.
Additional aspect of the present invention and advantage will part provide in the following description, and part will become obvious from the following description, or be recognized by practice of the present invention.
Accompanying drawing explanation
Above-mentioned and/or additional aspect of the present invention and advantage will become obvious and easy understand from accompanying drawing below combining to the description of embodiment, wherein:
Fig. 1 is the general frame schematic diagram of surface blasting data analysis management system of the present invention;
Fig. 2 is the data analysis configuration diagram of surface blasting data analysis management system of the present invention;
Fig. 3 is the data analysis management configuration diagram of surface blasting data analysis management system of the present invention;
Fig. 4 is the date comprision configuration diagram of surface blasting data analysis management system of the present invention;
Fig. 5 is the technical report schematic diagram of surface blasting data analysis management system of the present invention;
Fig. 6 is the workflow diagram of surface blasting data analysis management method of the present invention.
Embodiment
Be described below in detail embodiments of the invention, the example of described embodiment is shown in the drawings, and wherein same or similar label represents same or similar element or has element that is identical or similar functions from start to finish.Being exemplary below by the embodiment be described with reference to the drawings, only for explaining the present invention, and can not limitation of the present invention being interpreted as.
In describing the invention, it will be appreciated that, term " longitudinal direction ", " transverse direction ", " on ", D score, "front", "rear", "left", "right", " vertically ", " level ", " top ", " end " " interior ", the orientation of the instruction such as " outward " or position relationship be based on orientation shown in the drawings or position relationship, only the present invention for convenience of description and simplified characterization, instead of indicate or imply that the device of indication or element must have specific orientation, with specific azimuth configuration and operation, therefore can not be interpreted as limitation of the present invention.
In describing the invention, unless otherwise prescribed and limit, it should be noted that, term " installation ", " being connected ", " connection " should be interpreted broadly, such as, can be mechanical connection or electrical connection, also can be the connection of two element internals, can be directly be connected, also indirectly can be connected by intermediary, for the ordinary skill in the art, the concrete meaning of above-mentioned term can be understood as the case may be.
As shown in Figure 1, technical matters to be solved by this invention is to provide a kind of surface blasting data analysis management system and method, each project management department's blasting information collected is carried out add up, treatment and analysis, realize the robotization of blasting operation, intelligentized technical Analysis and management.
To this, the invention provides a kind of surface blasting statistical analysis system, comprising: data acquisition module, data memory module, data analysis contrast module and report display module.
Described data acquisition subsystem, for gathering the blasting information of projects portion blasting operation, comprising: project management department's title, the explosion date, explosion type, by the lithology of quick-fried rock mass, explosive type, bench height, bore diameter, drilling depth, boring number, pitch-row, reject, stemming length, design unit consumption, drill footage, explosive load, detonator consumption, explosion side's amount and operation recruitment etc.Wherein, explosion type is divided into bench blasting, secondary blasting and the presplitting blasting of light face; Lithology be divided into coal petrography, mud stone, shale, sandstone, ls, grouan and other; Explosive type is divided into and loads in mixture ammonium nitrate fuel oil mixture, the mixed loading emulsion explosive, loads in mixture titania-mica and finished explosive products; Detonator is divided into common electric detonator, common on-electric detonator, high strength on-electric detonator and other detonators etc.; Bore diameter is divided into the boring of slim hole (<100mm), intermediate diameters (100-200mm) and large diameter borehole (>200mm).For the ease of the convenience of data acquisition, data acquisition is divided into Excel data acquisition form to make a report on making a report on online data, or adopts the direct remote collection mode of corresponding data message sensor.
Described data-storage system, for carrying out store and management to the blasting information of data acquisition subsystem.MS SQL server is utilized to set up the database storing explosion relevant information.The process of data importing first by data upload to server, by data preview, and data are screened, are imported in database, then the file uploaded is deleted from server, Free up Memory, guarantee the stability of system database.Database root is set up according to the relation of technology form, preserves different entity classes, and has corresponding incidence relation table.By database manipulation language, data are retrieved, the operation such as amendment.Often analyze onepull raw data, draw certain result, be stored in result table, record this analysis operation simultaneously.Database comprises user profile, unit information and explosion data.User profile is used for user and logs in and user operation rights management, and user carries out corresponding operating according to authority different pairs according to storehouse.Unit information is used for user identity identification, explosion data management module, and the data starting when importing data to import with regard to reply carry out unit information association, and then processes according to unit in data statistics with when analyzing.Unit information is divided into project management department and the operation unit two large divisions belonging to it, and the managerial demand administrator right of unit information operates.In order to improve the security of system, the different pairs according to user has different operating rights according to library facility module, avoids the destruction risk of other staff to critical data.Allow domestic consumer to carry out statistics and analysis to data, export technique is reported.All operation notes all will be deposited in database, so that when system goes wrong, are originated and solution by operation note quick positioning question.
As shown in Figure 2, data for extracting related data in data storage subsystem, are carried out adding up, Classification Management by described data statistics subsystem, comprise bench blasting statistical module, secondary blasting statistical module and light face presplitting blasting statistical module.Wherein, bench blasting statistical module is divided into explosion side's amount, boring amount, explosive charge, detonator amount and work consumption.Explosion side's amount, explosive charge and detonator amount are added up according to comprehensive, lithology, bore diameter respectively, and boring amount and work consumption are added up according to lithology and bore diameter respectively; Secondary blasting statistical module is divided into rock drilling amount, explosive charge, detonator amount and work consumption, and rock drilling amount, explosive charge, detonator amount and work consumption are added up according to lithology respectively; Presplitting blasting statistical module in light face is divided into explosive charge, primacord fuse amount and work consumption, and explosive charge, primacord fuse amount and work consumption are added up according to lithology respectively.
As shown in Figure 3, described data analytics subsystem, utilizing relevant explosion algorithm, for analyzing the data result of data statistics subsystem, comprising bench blasting analysis module, secondary blasting analysis module and light face presplitting blasting analysis module.Wherein bench blasting analysis module is divided into explosive specific charge analysis indexes, blasting output per meter hole analysis indexes, explosive consumption analysis indexes, detonator dosage analysis index, pencil than analysis indexes and work consumption analysis index.Explosive specific charge analysis indexes refer to the rock of explosion unit volume consume the quality of explosive, carry out classification analysis by lithology; Blasting output per meter hole index refer to every meter hole quick-fried fall rock mass side amount, carry out classification analysis according to lithology and bore diameter; Explosive consumption analysis indexes adopts every explosive consumption incomparably to represent, every explosive consumption incomparably refers to the explosive load that explosion 10,000 side rock mass consumes, and carries out classification analysis according to lithology and bore diameter; Detonator dosage analysis index adopts every detonator consumption incomparably to represent, every detonator consumption incomparably refers to carry out classification analysis according to lithology and bore diameter by the detonator consumption that explosion 10,000 side rock mass consumes; Pencil refers to the ratio of the total consumption of each rendrock and the total consumption of detonator than analysis indexes, carries out classification analysis according to lithology and bore diameter; Work consumption analysis index power dissipation ratio represents, i.e. the operation recruitment person-time set out of every explosion 10,000 side rock mass, carries out classification analysis according to lithology and bore diameter.Secondary blasting analysis module is divided into rock drilling component analysis index, explosive consumption analysis indexes, detonator dosage analysis index and work consumption analysis index.Wherein explosive consumption analysis indexes, detonator dosage analysis index, work consumption analysis index meaning are identical with bench blasting; The every rock drilling amount incomparably of rock drilling component analysis index represents, the big gun pore volume bored when rock drilling amount refers to secondary drilling, and every rock drilling amount incomparably refers to the secondary drilling volume required for every explosion 10,000 side rock mass.The presplitting blasting of light face is analyzed modulus and is comprised every light face presplitting blasting areal analysis index and borehole spacing counter bored holes diameter multiple analysis indexes incomparably.Every all places light face presplitting blasting areal analysis index refers to the ratio in every explosion 10,000 side rock mass shared by light face presplitting blasting area, and presplitting area in light face refers to the product of borehole spacing on the pre-broken face in light face and drill footage; Borehole spacing counter bored holes diameter multiple analysis indexes refers to the ratio of borehole spacing on presplitting blasting face and blasthole diameter.
As shown in Figure 4, described date comprision subsystem, for being analyzed the result of data statistics subsystem and data analytics subsystem, comprises longitudinal comparative analysis module and across comparison analysis module.Longitudinal comparative analysis module refers to the comparative analysis of the relevant explosion statistical study index of project management department's different time sections; Across comparison analysis module refers to the comparative analysis of the relevant explosion statistical study index between disparity items portion in same time section.For the ease of intuitively showing comparative analysis result, except employing forms mode display result, also adopting at least one in 3-D histogram, two-dimensional histogram, pie chart, curve map or broken line graph to present patterned mode and carrying out output display.
As shown in Figure 5, described technical report subsystem, according to the result of described data statistics subsystem, data analytics subsystem and date comprision subsystem, the blasting operation information in all items portion is exported with the form of technical report, comprises blasting operation general status module, the key technical indexes comparative analysis module and problem and countermeasure module.Wherein, blasting operation general status module is divided into bench blasting side to measure situation, bench blasting drill footage situation, bench blasting explosive consumption situation, bench blasting detonator consumption situation, light face presplitting blasting quantities situation, the blasting operation frequency and scale situation; The key technical indexes comparative analysis module comprises unit consumption of bench blasting explosive comparative analysis, blasting output per meter hole comparative analysis, pencil than comparative analysis, recruitment consumption comparative analysis, the comparative analysis of secondary blasting amount, the comparative analysis of light face presplitting blasting amount; Problem and countermeasure module is technician according to the result of blasting operation general status module and the key technical indexes comparative analysis module, finds the deficiency that blasting operation situation in projects portion exists, proposes reasonably to advise.Take time as node, technical report is divided into monthly, season, semi-annual and Annual Technical report.
As shown in Figure 6, native system also provides a kind of explosion data processing method adopting above-mentioned surface blasting statistical analysis system, comprises the steps: that data collection steps, data storing steps, data statistics step, data analysis step, date comprision step and technical report export step.
Described data collection steps, projects portion monthly will report to system manager place by blasting operation information unification, and according to project management department's actual conditions, data acquisition is divided into Excel data acquisition form to make a report on making a report on two kinds of modes with online data.Comprise following sub-step: as adopted Excel data acquisition form to make a report on mode, explosion data in projects portion make a report on sub-step, a data sheet sub-step is monthly submitted in projects portion to; As adopted online data to make a report on mode, data sub-step is made a report in projects portion on the net online, a big gun submission onepull data sub-step is often put in projects portion.
Described data storing steps, by explosion data importing database, then manages data.Comprise following sub-step: from collection form or online online reading explosion data sub-step; Explosion data are carried out to Classification Management, stored sub-step.
Described data statistics step, for extracting related data in data storage subsystem, data are carried out add up, Classification Management, for follow-up analytic function provides convenience, comprise following sub-step: from database of blasting data, read projects portion explosion data sub-step; Explosion data in projects portion are added up, Classification Management export sub-step.
Described data analysis step, for analyzing the data result of data statistics subsystem, comprises following sub-step: from data statistics subsystem, read explosion data statistics to bear fruit step; Statistics is calculated, analyzes and export sub-step.
Described date comprision step, for being analyzed the result of data statistics subsystem and data analytics subsystem, comprises following sub-step: from data statistics subsystem and data analytics subsystem, read explosion data statistic analysis to bear fruit step; Longitudinal contrast, across comparison are carried out to statistic analysis result, and result tabular and graphical result are exported sub-step.
Described technical report exports step, the blasting operation information of all project management departments is exported with the form of technical report, comprises following sub-step: read the statistics of data statistics subsystem, data analytics subsystem and date comprision subsystem, analysis and comparing result sub-step; To statistics, to analyze and comparing result carries out statistic of classification, conclusion, and printed, export, preserve sub-step.
In the description of this instructions, specific features, structure, material or feature that the description of reference term " embodiment ", " some embodiments ", " example ", " concrete example " or " some examples " etc. means to describe in conjunction with this embodiment or example are contained at least one embodiment of the present invention or example.In this manual, identical embodiment or example are not necessarily referred to the schematic representation of above-mentioned term.And the specific features of description, structure, material or feature can combine in an appropriate manner in any one or more embodiment or example.
Although illustrate and describe embodiments of the invention, those having ordinary skill in the art will appreciate that: can carry out multiple change, amendment, replacement and modification to these embodiments when not departing from principle of the present invention and aim, scope of the present invention is by claim and equivalents thereof.
Claims (6)
1. a surface blasting data analysis management system, is characterized in that, comprising: data acquisition module, data memory module, data analysis contrast module and report display module; Data acquisition module connection data memory module, data memory module connection data analysis contrast module, data analysis contrast model calling report display module;
Data acquisition module, for the surface blasting data of user being gathered, gathers the blasting information of each surface blasting project borehole blasting operation;
Data memory module, for carrying out store and management to the explosion data message of data acquisition module, and stores explosion historical data information;
Data analysis contrast module, carries out for the explosion data message that gathers data acquisition module and explosion historical data information analysiss and contrasts, calculate optimum surface blasting data, carry out on-the-spot blasting work;
Report display module, the optimum surface blasting data after analyzing for display comparison, and the blasting information of explosion historical data information and data acquisition module.
2. surface blasting data analysis management system according to claim 1, it is characterized in that, described data acquisition module comprises:
Project management department's explosion data module, for carrying out collection in worksite to surface blasting data, the data gathered are the explosion date, explosion type, by the lithology of quick-fried rock mass, explosive type, bench height, bore diameter, drilling depth, boring number, pitch-row, reject, stemming length, design unit consumption, drill footage, explosive load, detonator consumption, explosion side amount and operation recruitment, above-mentioned gathered data are transferred to data memory module;
Described project management department explosion data module also comprises, explosion type block, for being bench blasting, secondary blasting and the presplitting blasting of light face by the state demarcation of explosion, the explosion data of bench blasting, secondary blasting and the presplitting blasting of light face are stored into data memory module; Lithologic analysis module, for the rock mass lithology after explosion being analyzed, determines the explosion rock mass lithology of coal petrography, mud stone, shale, sandstone, ls, grouan; Explosive type module, for determining that according to rock mass lithology use loads in mixture ammonium nitrate fuel oil mixture, the mixed loading emulsion explosive, loads in mixture titania-mica and finished explosive products.
3. surface blasting data analysis management system according to claim 1, it is characterized in that, described data memory module comprises:
History data store module, for history surface blasting data being stored, being convenient to subsequent data analysis contrast module and carrying out calling work;
Data management module, for carrying out store and management to the explosion data message of data acquisition module, utilizes MS SQL server to set up the database storing explosion relevant information; Data importing first by data upload to server, by data preview, and data are screened, are imported in database, then the file uploaded is deleted from server, Free up Memory, guarantee the stability of system database;
Data classifying module, set up for the relation of database root according to technology form, preserve different entity classes, and have corresponding incidence relation table, by database manipulation language, data are retrieved, retouching operation, a surface blasting historical data is often analyzed by data analysis contrast module, draw analysis result, be stored in result table, record this analysis operation simultaneously, database comprises user profile, unit information and explosion data, user profile is used for user and logs in and user operation rights management, user carries out corresponding operating according to authority different pairs according to storehouse, unit information is used for user identity identification, data management module, the data starting when importing data to import with regard to reply carry out unit information association, and then carry out according to unit in data statistics with when analyzing, unit information is divided into project management department and the operation unit two large divisions belonging to it, the managerial demand administrator right of unit information operates, different pairs according to user has different operating rights according to library facility module.
4. surface blasting data analysis management system according to claim 1, is characterized in that, described data analysis contrast module comprises:
Data for extracting related data in data memory module, are carried out adding up, Classification Management by data statistics module;
Described data statistics module comprises: bench blasting statistical module, secondary blasting statistical module, light face presplitting blasting statistical module
Bench blasting statistical module, for collecting bench blasting side's amount, boring amount, explosive charge, detonator amount and work consumption in advance, bench blasting side's amount, explosive charge and detonator amount carry out statistical study according to comprehensive, lithology, bore diameter respectively, and boring amount and work consumption carry out statistical study according to lithology and bore diameter respectively; Secondary blasting statistical module, for collecting secondary blasting rock drilling amount, explosive charge, detonator amount and work consumption in advance, secondary blasting rock drilling amount, explosive charge, detonator amount and work consumption carry out statistical study according to lithology respectively; Light face presplitting blasting statistical module, for receiving light-collecting surface presplitting explosive charge, primacord fuse amount and work consumption in advance, light face presplitting explosive charge, primacord fuse amount and work consumption carry out statistical study according to lithology respectively;
Data analysis module, utilize surface blasting algorithm, described surface blasting algorithm comprises the computing method of explosive specific charge, blasting output per meter hole, explosive load, detonator amount, pencil ratio, work loss-rate, rock drilling amount, borehole spacing counter bored holes diameter multiple, for analyzing the data result of data statistics module, comprise bench blasting analysis module, secondary blasting analysis module and light face presplitting blasting analysis module;
Described bench blasting analysis module is divided into explosive specific charge analysis indexes, blasting output per meter hole analysis indexes, explosive consumption analysis indexes, detonator dosage analysis index, pencil than analysis indexes and work consumption analysis index; Explosive specific charge analysis indexes refer to the rock of explosion unit volume consume the quality of explosive, carry out classification analysis by lithology; Blasting output per meter hole index refer to every meter hole quick-fried fall rock mass side amount, carry out classification analysis according to lithology and bore diameter; Explosive consumption analysis indexes adopts every explosive consumption incomparably to represent, every explosive consumption incomparably refers to the explosive load that explosion 10,000 side rock mass consumes, and carries out classification analysis according to lithology and bore diameter; Detonator dosage analysis index adopts every detonator consumption incomparably to represent, every detonator consumption incomparably refers to carry out classification analysis according to lithology and bore diameter by the detonator consumption that explosion 10,000 side rock mass consumes; Pencil refers to the ratio of the total consumption of each rendrock and the total consumption of detonator than analysis indexes, carries out classification analysis according to lithology and bore diameter; Work consumption analysis index power dissipation ratio represents, i.e. the operation recruitment person-time set out of every explosion 10,000 side rock mass, carries out classification analysis according to lithology and bore diameter; Secondary blasting analysis module is divided into rock drilling component analysis index, explosive consumption analysis indexes, detonator dosage analysis index and work consumption analysis index; Wherein explosive consumption analysis indexes, detonator dosage analysis index, work consumption analysis index meaning are identical with bench blasting; The every rock drilling amount incomparably of rock drilling component analysis index represents, the big gun pore volume bored when rock drilling amount refers to secondary drilling, and every rock drilling amount incomparably refers to the secondary drilling volume required for every explosion 10,000 side rock mass; The presplitting blasting of light face is analyzed modulus and is comprised every light face presplitting blasting areal analysis index and borehole spacing counter bored holes diameter multiple analysis indexes incomparably; Every all places light face presplitting blasting areal analysis index refers to the ratio in every explosion 10,000 side rock mass shared by light face presplitting blasting area, and presplitting area in light face refers to the product of borehole spacing on the pre-broken face in light face and drill footage; Borehole spacing counter bored holes diameter multiple analysis indexes refers to the ratio of borehole spacing on presplitting blasting face and blasthole diameter;
Data analysis contrast submodule, for being analyzed the result of data statistics subsystem and data analytics subsystem;
Described data analysis contrast submodule comprises longitudinal comparative analysis module and across comparison analysis module, longitudinal comparative analysis module, for the comparative analysis of the relevant explosion statistical study index to project management department's different time sections; Across comparison analysis module, for the comparative analysis of the relevant explosion statistical study index between disparity items portion in same time section.
5. surface blasting data analysis management system according to claim 1, it is characterized in that, described report display module comprises: by data statistics, analysis and comparing result, statistic of classification, conclusion are carried out to statistics, analysis and comparing result, and printed, export, preserve, adopt form, in 3-D histogram, two-dimensional histogram, pie chart, curve map or broken line graph, at least one presents patterned mode and carries out output display.
6. a surface blasting data analysis management method, is characterized in that, comprises the steps:
Step 1, is gathered by the surface blasting data of data acquisition module by user, gathers the blasting information of each surface blasting project borehole blasting operation;
Step 2, carries out store and management by the explosion data message of data memory module to data acquisition module, and stores explosion historical data information;
Step 3, the explosion data message gathered data acquisition module by data analysis contrast module and explosion historical data information are carried out analysiss and are contrasted, and calculate optimum surface blasting data, carry out on-the-spot blasting work;
Step 4, the optimum surface blasting data after being analyzed by report display module display comparison, and the blasting information of explosion historical data information and data acquisition module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410503119.0A CN104239560B (en) | 2014-09-26 | 2014-09-26 | Surface blasting data analysis management system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410503119.0A CN104239560B (en) | 2014-09-26 | 2014-09-26 | Surface blasting data analysis management system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104239560A true CN104239560A (en) | 2014-12-24 |
| CN104239560B CN104239560B (en) | 2017-07-14 |
Family
ID=52227619
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410503119.0A Active CN104239560B (en) | 2014-09-26 | 2014-09-26 | Surface blasting data analysis management system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104239560B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105719077A (en) * | 2016-01-20 | 2016-06-29 | 中国矿业大学(北京) | Laneway explosion construction quality management method and laneway explosion construction quality management system |
| CN106525610A (en) * | 2016-08-25 | 2017-03-22 | 中国黄金集团内蒙古矿业有限公司 | Implementation method for distribution rule of blast muckpiles in surface mine |
| CN107893660A (en) * | 2017-10-27 | 2018-04-10 | 成都大学 | A kind of tunnel branch leads cave blasting design method and intelligence system |
| CN107905797A (en) * | 2017-10-27 | 2018-04-13 | 成都大学 | A kind of positive cave blasting design method in tunnel and intelligence system |
| CN108319782A (en) * | 2018-02-02 | 2018-07-24 | 福建省新华都工程有限责任公司 | A kind of surface blasting side's amount computational methods |
| CN112325717A (en) * | 2020-11-05 | 2021-02-05 | 中国葛洲坝集团易普力股份有限公司 | Blasting construction filling system and method |
| CN112347172A (en) * | 2020-11-05 | 2021-02-09 | 中国葛洲坝集团易普力股份有限公司 | Industrial electronic detonator full life cycle supervision method and system |
| CN114140968A (en) * | 2021-12-07 | 2022-03-04 | 四川智能建造科技股份有限公司 | Blasting product usage amount early warning system and method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021404A (en) * | 2007-03-08 | 2007-08-22 | 济南东之林电器有限公司 | Mine intelligent explosion management system |
| CN101645180A (en) * | 2009-05-31 | 2010-02-10 | 北京龙德时代科技发展有限公司 | Intelligent data acquisition unit |
| CN102663183A (en) * | 2012-03-31 | 2012-09-12 | 浙江大学 | Blasting simulation method in digital mine |
| CN103336510A (en) * | 2013-06-27 | 2013-10-02 | 山东华戎信息产业有限公司 | Comprehensive operation and maintenance management system for internet of things |
-
2014
- 2014-09-26 CN CN201410503119.0A patent/CN104239560B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021404A (en) * | 2007-03-08 | 2007-08-22 | 济南东之林电器有限公司 | Mine intelligent explosion management system |
| CN101645180A (en) * | 2009-05-31 | 2010-02-10 | 北京龙德时代科技发展有限公司 | Intelligent data acquisition unit |
| CN102663183A (en) * | 2012-03-31 | 2012-09-12 | 浙江大学 | Blasting simulation method in digital mine |
| CN103336510A (en) * | 2013-06-27 | 2013-10-02 | 山东华戎信息产业有限公司 | Comprehensive operation and maintenance management system for internet of things |
Non-Patent Citations (2)
| Title |
|---|
| CUI XIAO-RONG等: "Reliability analysis of larger-scale priming circuit used in blasting demolition", 《BLASTING》 * |
| 蔡建德: "露天煤矿高温区爆破案例作业技术研究", 《工程爆破》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105719077A (en) * | 2016-01-20 | 2016-06-29 | 中国矿业大学(北京) | Laneway explosion construction quality management method and laneway explosion construction quality management system |
| CN106525610A (en) * | 2016-08-25 | 2017-03-22 | 中国黄金集团内蒙古矿业有限公司 | Implementation method for distribution rule of blast muckpiles in surface mine |
| CN107893660A (en) * | 2017-10-27 | 2018-04-10 | 成都大学 | A kind of tunnel branch leads cave blasting design method and intelligence system |
| CN107905797A (en) * | 2017-10-27 | 2018-04-13 | 成都大学 | A kind of positive cave blasting design method in tunnel and intelligence system |
| CN108319782A (en) * | 2018-02-02 | 2018-07-24 | 福建省新华都工程有限责任公司 | A kind of surface blasting side's amount computational methods |
| CN108319782B (en) * | 2018-02-02 | 2021-05-28 | 福建省新华都工程有限责任公司 | Open blasting volume calculation method |
| CN112325717A (en) * | 2020-11-05 | 2021-02-05 | 中国葛洲坝集团易普力股份有限公司 | Blasting construction filling system and method |
| CN112347172A (en) * | 2020-11-05 | 2021-02-09 | 中国葛洲坝集团易普力股份有限公司 | Industrial electronic detonator full life cycle supervision method and system |
| CN114140968A (en) * | 2021-12-07 | 2022-03-04 | 四川智能建造科技股份有限公司 | Blasting product usage amount early warning system and method |
| CN114140968B (en) * | 2021-12-07 | 2023-06-06 | 四川智能建造科技股份有限公司 | Blasting product consumption early warning system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104239560B (en) | 2017-07-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104239560A (en) | Opencast blasting data analysis and management system and method | |
| CN106897839B (en) | Well site data integration collaborative work platform | |
| WO2019042483A2 (en) | Tbm boring rock state real-time sensing system and method | |
| CN1894652B (en) | Automatic monitoring and statistical analysis of dynamic process metrics to expose meaningful changes | |
| CN104834518A (en) | Oilfield exploitation and development working platform system | |
| CN104732359A (en) | Oil field geographic information and exploration development collaboration work platform system | |
| CN105405069B (en) | Electricity purchase operation decision analysis and data processing method | |
| CN103605651A (en) | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis | |
| Jaripatke et al. | Review of Permian completion designs and results | |
| CN111311190A (en) | Experimental data management method convenient for data collection | |
| CN109882163A (en) | A kind of PRODUCTION FORECASTING METHODS for compact oil reservoir pressure break horizontal well | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN105069542A (en) | Responsibility cost budgeting method and system | |
| CN105204081B (en) | A kind of method predicting shale gas Clay Mineral and constituent content thereof | |
| CN105528400A (en) | Web-based multidimensional analysis system and method | |
| Leung et al. | Sample truncation strategies for outlier removal in geochemical data: the MCD robust distance approach versus t-SNE ensemble clustering | |
| CN108573340A (en) | A kind of stone pit manufacturing monitoring system and method | |
| CN117829754B (en) | Intelligent engineering construction whole process number management method and platform based on BIM and GIS | |
| CN109685323A (en) | A kind of green building assessment system | |
| CN116578612A (en) | Lithium battery finished product detection data asset construction method | |
| McGaughey et al. | Automated, real-time geohazard assessment in deep underground mines | |
| CN107060744A (en) | A kind of Logging Geology system | |
| Ma et al. | Design and development of intelligent well logging interpretation system | |
| Gering et al. | Drill & blast implementation case study at multiple Freeport-McMoRan sites. | |
| CN108182550A (en) | Oil gas field post project evaluation system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |