CN103645973A - Data acquisition and application snapshot method of filling station - Google Patents
Data acquisition and application snapshot method of filling station Download PDFInfo
- Publication number
- CN103645973A CN103645973A CN201310721690.5A CN201310721690A CN103645973A CN 103645973 A CN103645973 A CN 103645973A CN 201310721690 A CN201310721690 A CN 201310721690A CN 103645973 A CN103645973 A CN 103645973A
- Authority
- CN
- China
- Prior art keywords
- oil
- information
- tank
- transaction
- snapshot
- 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
Images
Landscapes
- Loading And Unloading Of Fuel Tanks Or Ships (AREA)
Abstract
The invention relates to the field of information technologies and automation and discloses a data acquisition and application snapshot method of a filling station. The method comprises the following steps of performing second-level sampling on oil tank information and storing into an oil tank information base and a real-time information base, performing second-level real-time oil outlet information on an oil gun, and storing into an oil gun information base and the real-time information base, acquiring oil gun transaction information and storing into a transaction information base, a transaction snapshot information base and the real-time information base, acquiring oil gun and oil tank information at regular time and storing in a history snapshot information base, judging whether an alarm condition is met, judging whether oil tank stock reaches an oil discharge standard, calculating whether a variation of oil reserve of the oil tank meets a condition, and extracting data from the oil tank information base, the transaction information base and the transaction snapshot information base for loss calculation. The method can simplify business operation, improves working efficiency, monitors and eliminates potential safety hazards in real time, provides a high-efficiency oil discharge mechanism, automatically applies delivery, performs oil discharge statistics, and greatly reduces the data size of transmission and storage.
Description
Technical field
The present invention relates to infotech and automatic field, particularly a kind of effectively snapshot acquisition method of application of refuelling station's data that promotes.
Background technology
After success is joined WTO, China's refined oil market is open to foreign oil company gradually.How by KXG, grasp comprehensively, accurately and timely refuelling station's product oil and enter, sell, deposit information, realize information acquisition robotization, reduce hand labour, cut operating costs, improve the efficiency of management and become gradually domestic petroleum company and tackle the problem that external competition must be faced.Loss of Oil Products at Gas Station retail trade is the most important thing of oil company's information system management, to the collection of refuelling station's storage tank oil product information and oil gun real-time information be grasp that product oil enters, pin, stored important means.
Tradition refuelling station's watch-dog used or information management system real-time is poor, precision is low, cost is high and manual degree of participation is higher, can not adapt to the demand of market competition well.After entry to WTO, oil market foreign company enters, and has brought immense pressure to domestic oiling market.Meanwhile, modern's rhythm of life is accelerated day by day, and the work efficiency of refuelling station is had higher requirement.This moment, urgent need proposition is a kind of can provide the systems approach of complete, real-time basic data collection automatically for refuelling station's business.
Classical snapshot is mainly used in field of storage, and its effect is to carry out online data backup and recovery.Refuelling station's snapping technique in the present invention is mainly used in fuel station information and gathers field, refer to the complete usable copy of certain time point to refuelling station's oil tank and oil gun data, Main Function is to realize Loss of Oil Products at Gas Station " to enter, sell, deposit " statistics automation, promote accuracy, the information that snapshot comprises has: in all oil tank oil stocks, oil tank, in liquid level, oil tank, water accumulating volume, the real-time pump code of all oil guns, the every transaction transaction value of oil gun, snapshot gather time point etc.The triggering mode of snapshot collection is divided into two kinds: Event triggered and clocked flip.Event triggered also can be described as " transaction trigger ", refers in refuelling station for any one moment that oil gun is completed to transaction to gather refuelling station's snapshot; Clocked flip refers to that the time interval can change as required flexibly according to cycle in the time interval or the disposable collection refuelling station snapshot set.
From the angle of refuelling station's statistics, for the more abundant statistics that is more conducive to of data sample of adding up.A kind of effectively mode is to carry out a second utmost point sampling, gathers once p.s., too huge but shortcoming is data volume, and the data storage of data center is brought to sizable pressure with inquiry.The strategy that the Event triggered that the present invention adopts and clocked flip combine, when meeting refuelling station's statistical demand, has reduced data volume greatly.
Summary of the invention
The object of the invention is to in traditional refuelling station operation flow, manual degree of participation is high, efficiency is low, cost is high, the drawback that accuracy can not be guaranteed, provides a kind of effectively snapshot acquisition method of application of refuelling station's data that promotes.
Method of the present invention can gather refuelling station's oil machine and oil tank transaction level SNAPSHOT INFO in real time, automatically, for the business such as refuelling station's loss statistics, service alarm, emptying detection, oil products delivery provide complete data collection.Comprise the steps:
Tank information is carried out to second grade samples and is saved in tank information storehouse and real-time information storehouse.
The real-time fuel-displaced information of oil gun is carried out to second grade samples and is saved in oil gun information bank and real-time information storehouse.
Gather oil gun Transaction Information and be saved in Transaction Information storehouse and transaction SNAPSHOT INFO storehouse and real-time information storehouse.
Timing acquiring oil gun, oil tank up-to-date information are also saved in historical snapshot information bank.
According to the alarm threshold parameter of setting in configuration information storehouse, in conjunction with oil gun, oil tank up-to-date information, judge whether to meet alarm conditions.If meet, carry out corresponding warning.
According to the oil tank threshold parameter of setting in configuration information storehouse, in conjunction with oil tank up-to-date information, judge whether oil tank stock reaches to unload oil standard.If reach, to logistics distribution system, send oil products delivery request.
According to the emptying testing conditions of setting in configuration information storehouse, in conjunction with oil tank historical snapshot information bank, whether the variable quantity that calculates tank capacity satisfies condition, and sends corresponding prompting, and emptying information is saved in emptying information bank if meet.Information in emptying information bank comprises: emptying initial time, the emptying tank capacity zero hour, emptying end time, the emptying tank capacity finish time etc.
According to the time parameter of setting in configuration information storehouse, from tank information storehouse and Transaction Information storehouse and transaction SNAPSHOT INFO storehouse, extract data and carry out loss calculating.
Described tank information storehouse is: tank information library storage second refuelling station's tank information of level sampling, comprises refuelling station's numbering, oil tank numbering, oil product, profit cumulative volume, liquid level, acquisition time stamp etc.
Described real-time information storehouse is: in real-time information storehouse, storing respectively the latest data of all oil tanks and oil gun in refuelling station, oil tank packet oil scraper tank numbering, oil product, profit cumulative volume, liquid level, water are high; Oil gun packet oil scraper rifle numbering, pump code value, current volume read-out, the amount of money etc. that refuels.
Described historical snapshot information bank is: the SNAPSHOT INFO of storing all oil guns and oil tank in the refuelling station of timing acquiring in historical snapshot information bank: comprise the every transaction volume read-out of pump code, oil gun, the oil reserve of oil tank, the water accumulating volume of oil tank, transactional cards card number of oil gun etc.
Described oil gun information bank is: the fuel-displaced information of oil gun when oil gun information bank is being stored the oiling of real time second level sampling, comprising: refuelling station's numbering, oil gun number, oil price, pump code value, timestamp etc.
Described Transaction Information storehouse is: Transaction Information library storage refuelling station's oil gun transaction record of Real-time Collection, comprising: the terminal transaction sequence number that refuelling station numbering, oil gun number, current volume read-out, PSAM card produce, timestamp etc.
Described transaction SNAPSHOT INFO storehouse is: transaction SNAPSHOT INFO library storage in refuelling station the SNAPSHOT INFO that certain rifle completes all oil tanks, oil gun in this station of the moment of fueling transaction, comprising: the terminal transaction sequence number that refuelling station's numbering, oil gun number, PSAM card produce, the stock of all oil tanks, the pump code of all oil guns, timestamp.
Described configuration information storehouse is: in configuration information storehouse, depositing the parameter information that each related service of refuelling station sets: comprise the time parameter of computed losses, minimum quantity of stores of the threshold parameter of alert service and application oil products delivery etc.The threshold parameter of alert service comprises: the highest level value of oil tank, oil tank lowest water level value etc.
Described alarm threshold parameter refers to: alarm threshold parameter mainly comprises high liquid level threshold value, low liquid level threshold value, high water stage threshold value etc.High liquid level threshold value refers to the maximal value of oil product tank farm stock in oil tank; Low liquid level threshold value refers to the minimum value of oil product tank farm stock in oil tank; High water stage threshold value refers to the maximal value of water accumulating volume in oil tank.
The described alarm conditions that meet refer to: during the information of timing acquiring oil tank, the oil tank level of current collection or water level value are greater than or less than the threshold value that in alert service configuration information storehouse, relevant parameter is set.
Described oil tank threshold parameter refers to: when oil product tank farm stock is lower than certain storage in oil tank, just can not sell oil again, must apply for oil products delivery, oil tank threshold parameter just refers to the oil tank stock in the time of need to applying for oil products delivery.
Described reaching unloaded oil standard and referred to: the oil reserve of timing acquiring oil tank, minimum oil product memory margin in oil tank when the tank capacity of current collection is less than or equal to the oil tank of setting in configuration information storehouse and needs emptying.
The time parameter of setting in described configuration information storehouse refers to: can, according to refuelling station's business demand, be set flexibly the time interval that " enter, sell, deposit " statistics refuelling station.
Described collection oil gun Transaction Information and be saved in transaction SNAPSHOT INFO warehouse mainly comprise the steps:
By collecting device, gather oil gun data;
According to oil machine and host computer communication protocol, cutting data is searched the frontier point of packet from data stream;
Judgement type of data packet, if real time data is saved in oil gun information warehouse; If transaction data extracts the up-to-date information of all oil guns in this refuelling station and all oil tanks from real-time information storehouse, and be saved in transaction SNAPSHOT INFO warehouse.
Described timing acquiring oil gun, oil tank up-to-date information are also saved in historical snapshot information warehouse and mainly comprise the steps:
Set the time interval regularly, and be saved in configuration information storehouse;
Administrative center reads information in repository, is issued to corresponding refuelling station;
Refuelling station sets local timer according to configuration information;
When timer is triggered, from real-time information storehouse, extracts the corresponding information of all oil tanks and oil gun in refuelling station and send to administrative center;
Administrative center carries out corresponding operating according to information data type: if oil tank data judge whether to meet alarm conditions, satisfied alarm also produces alarm record, information is saved in to historical snapshot information bank simultaneously; Do not meet and the information of receiving is directly saved in to historical snapshot information bank.If oil gun data, are saved in historical snapshot information bank by the every transaction trading volume of oil gun and accumulative total pump code value;
Before tank capacity information is saved in historical snapshot information bank, judge whether oil tank oil storage variable quantity meets emptying testing conditions, if meet, record emptying information; If only do not meet and current oil reserve need be saved in to historical snapshot information bank.
Described loss is calculated and is mainly comprised the steps:
Obtain the time parameter of setting in configuration information storehouse;
Regularly add up interior oil tank oil pump capacity of period in tank information storehouse;
Regularly adding up corresponding oil tank in emptying information bank unloads oil mass in the period;
Regularly in statistics transaction SNAPSHOT INFO storehouse, in the oil gun period, pump code is walked number of words;
Regularly add up interior transaction of oil gun period oil mass total value in transaction SNAPSHOT INFO storehouse;
According to calculating gained tank unloading amount, oil gun pump code, walk number of words and oil gun transaction oil mass total value calculation interval internal loss.
The beneficial effect that the present invention compared with prior art has:
1. simplify business operation, increase work efficiency
At present, refuelling station's tank information and oil gun pump code acquisition of information are all manually to be read and record by employee, and then the mode of typing managing and control system or zero guard system realizes, and work loaded down with trivial details and error rate is high.Usually because of human factor, cause oil company's loss serious, occur many " bleed " phenomenons.
And this method can greatly reduce employee's workload, increase work efficiency.Employee only needs simple operations, just can complete easily, exactly acquisition of information.
2. Real-Time Monitoring, eliminates safe hidden trouble
It is nearly all manual completing that " run, drip, leak " phenomenon detects in tradition refuelling station, complex disposal process, and information delay is serious, causes above-mentioned phenomenon to happen occasionally, and contaminated environment not only, but also bury potential safety hazard to refuelling station.On the other hand, the phenomenon that refuelling station adds wrong oil also happens occasionally, and affects comparatively severe.
And this method can be utilized the SNAPSHOT INFO of all oil tanks in refuelling station and oil gun, calculate in real time, compare, pinpoint the problems in time and alarm occurs, eliminate safe hidden trouble.
3. efficient emptying mechanism is provided, and application is provided and delivered and adds up and unload oil mass automatically
Described refuelling station do not stop refueling class's knot computing method for the graduation business of refuelling station class provide a set of efficiently, computing mechanism accurately, can in real time, automatically detect oil tank stock, and to second logistic system, send emptying application in time, avoid the generation of slack tank phenomenon.In addition, can accurately detect RTC unloading, and statistics is unloaded oil mass automatically, has optimized operation flow, has improved efficiency.
4. event-driven and timing drive the snapshot mode combining, and have significantly reduced the data volume of transmission and storage
For in the situation that meeting refuelling station's business demand, reduce the data volume of Internet Transmission and data center as far as possible, adopt strategy system performance in the environment of a small amount of refuelling station of management of level sampling second to accept, but while facing large-scale application scene, can system performance be caused and be had a strong impact on.Based on this, this method proposition time drives with regularly driving the mode combining, event-driven and mainly does the sampling of oil gun transaction level, regularly drives and can root army business demand adjust flexibly, compare with level sampling second, can tens data volumes that even hundred times reduces transmission and stores.
Accompanying drawing explanation
Tu1Wei refuelling station data are effectively applied Snapshot Method hardware platform logic module figure;
Fig. 2 is that data snapshot application system structure forms schematic diagram;
Tu3Wei refuelling station data snapshot method flow schematic diagram;
Fig. 4 is that data snapshot method adds wrong oily early warning explanation;
Fig. 5 is data snapshot method emptying management schematic flow sheet;
Fig. 6 is that in data snapshot method, historical snapshot is obtained schematic diagram.
Embodiment
Below in conjunction with embodiment and accompanying drawing, technical scheme of the present invention is done more specifically bright.
As shown in Figure 1, it is as follows that a kind of refuelling station data are effectively applied the hardware development plate logic module figure of collecting device of Snapshot Method design:
1) real-time clock RTC: assurance system is the in the situation that of power-off, and internal clock circuit can normally be worked, guarantees real-time, the accuracy of system time;
3) Ethernet interface RJ45: by network, Acquisition Instrument is carried out to telemanagement and configuration, and mutual by network and central management system;
4) many serial ports RS232: gather fuel charger, tank gage data channel, can carry out 8 circuit-switched data collections at most simultaneously;
5) USB: after serial ports image data is arranged, analyzed, carry out local storage backup, so that inquiry at any time and recovery;
6) LED light: comprise data transmit-receive pilot lamp, power light and malfunction indicator lamp;
7) SD CARD interface: after serial ports image data is arranged, analyzed, carry out local storage backup, so that inquiry at any time and recovery;
8) CONSOLE mouth: the use of debugging, test.
Fig. 2 is that data snapshot application system structure forms schematic diagram, and it comprises oil tank, tank gage, oil gun, oil machine, data acquisition module, central management system, data warehouse, configuration information storehouse, loss statistics, service alarm, oil products delivery, emptying detection, loss statistical form, alarm record sheet and dispensing application form.Wherein, data acquisition module comprises: tank information collection, oil gun information acquisition, Transaction Information collection and SNAPSHOT INFO collection; Data warehouse comprises: tank information storehouse, oil gun information bank, real-time information storehouse, Transaction Information storehouse, transaction SNAPSHOT INFO storehouse, historical snapshot information bank and emptying information bank.
Mutual relationship in schematic diagram between each module can be summarized as follows:
The system parameters that central management system is set user is saved in configuration information storehouse, and by and refuelling station between communication interface configuration information is issued to refuelling station.
Tank information acquisition module sends querying command Real-time Obtaining tank information to tank gage, via tank information acquisition module, process to resolve and store into afterwards in tank information storehouse and real-time information storehouse simultaneously, keeping track of history record in tank information storehouse, only preserves state-of-the-art record in real-time information storehouse;
The real-time fuel-displaced information of oil gun uploads to oil gun information acquisition module through oil machine, processes to resolve store oil gun information bank and real-time information storehouse into afterwards via oil gun information acquisition module, and keeping track of history record in oil gun information bank, only preserves state-of-the-art record in real-time information storehouse;
The every transaction information of oil gun uploads to Transaction Information acquisition module by oil machine, processes to resolve store Transaction Information storehouse and transaction SNAPSHOT INFO storehouse afterwards into via Transaction Information acquisition module;
SNAPSHOT INFO acquisition module regularly extracts the information snap of all oil tanks in refuelling station and oil gun from real-time information storehouse, and on deliver in the historical snapshot information bank of center;
Loss statistical module is according to the timing statistics granularity of setting in configuration information storehouse, and regularly information extraction from tank information storehouse, emptying information bank and transaction SNAPSHOT INFO storehouse, adds up refuelling station's oil tank, the fuel-displaced loss of oil gun, and automatically generate loss statistical form.
Service alarm module, oil products delivery module and emptying detection module are all to obtain up-to-date oil tank, oil gun SNAPSHOT INFO from SNAPSHOT INFO acquisition module.Whether service alarm module meets alert if by calculating comparison information data, if satisfy condition, produces corresponding alarm and records corresponding warning information; Oil products delivery module is directly obtained oil product tank farm stock in oil tank, if lower than unloading oil mass threshold value, and Auto-writing dispensing application form send dispensing request to oil products delivery system; Emptying detection module is by the up-to-date memory space of oil product and the relation of historical oil reserve in comparison oil tank, and judgement emptying starts and the finish time, and the emptying information bank that upgrades in time.
As shown in Figure 3, the flow process that a kind of refuelling station data are effectively applied Snapshot Method is (in figure, dotted line is asynchronous control or flow process):
(1) systematic parameter configuration, the user of administrative center, according to business demand, sets dependent thresholds parameter, and is saved in configuration information storehouse;
(2) central management system is issued to refuelling station by the relevant configuration information in configuration information storehouse;
(3) according to the dependent thresholds parameter in repository, carry out basic data acquisition, the basic data of collection comprises refuelling station's tank information, the real-time fuel-displaced information of oil gun, oil gun Transaction Information and subscriber card information;
(4) correctness of the basic data that checking collects;
(5) type of judgement packet, if packet is transaction record, jumps to step (6); Otherwise jump to step (9);
(6) according to subscriber card information, judge whether to meet and add wrong oily Rule of judgment, satisfied send early warning;
(7) extract the SNAPSHOT INFO of all oil tanks and oil gun in this refuelling station and be saved in transaction SNAPSHOT INFO storehouse;
(8) data in timing extraction transaction SNAPSHOT INFO storehouse, tank information storehouse and Transaction Information storehouse, carry out refuelling station and sell oily loss statistics, generate loss statistical form;
(9) according to the system time parameter threshold value setting timer of configuration;
(10), when timer triggers, from real-time information storehouse, extract refuelling station's SNAPSHOT INFO;
(11) refuelling station's SNAPSHOT INFO sent to central management system and be saved in historical snapshot information bank;
(12) extract SNAPSHOT INFO and carry out corresponding calculating, comparison, if meet alarm conditions, send corresponding warning information;
(13), if oil tank oil stock is lower than unloading oil standard, to logistics system, send oil products delivery request;
(14) comparison oil tank stock's up-to-date information and historical snapshot information, if meet, emptying starts or termination condition, upgrades emptying information bank, jumps to step (9).
Tu4Shi refuelling station data snapshot method adds wrong oily warning module workflow, and oil gun information exchange Machine for adding oil on material is transferred to card insertion information acquisition module and oil gun is carried rifle information acquisition module.When grease card inserts fuel charger, card inserts information acquisition module and uploads and information, extract grease card application number and be saved in card oiling information bank from oil machine.Oil supplier mention oil gun while prepare refueling oil gun carry and in the information that rifle information acquisition module send from oil machine, extract oil gun and put forward rifle information and be saved in oil gun and carry in rifle information bank.The rifle information of carrying oil gun triggers and adds wrong oily detection module, add wrong oily detection module and extract grease card information from card log-on message storehouse, from petrol station essential information storehouse, extract refuelling station's essential information, judge whether current oiling has and add wrong alopecia areata danger, if risky, Ze Huigei refuelling station sends early warning information.
Fig. 5 is data snapshot method emptying management schematic flow sheet, has only described one-time detection process in figure, can be divided into following several step:
(1) from real-time information storehouse, obtain refuelling station's oil tank latest snapshot information;
(2) that from configuration information storehouse, extracts this oil tank unloads oil mass threshold value;
(3) whether more current oil tank oil tank farm stock meets emptying condition, if meet, jumps to step (8), otherwise, jump to step (4);
(4) mean value of the oil tank historical snapshot information in the nearest certain hour in more current oil tank oil tank farm stock and historical snapshot information bank, starts condition if meet emptying, jumps to step (5), otherwise jumps to step (8);
(5) in emptying information table, generate the beginning emptying record of a current oil tank;
(6) mean value of the oil tank historical snapshot information in the nearest certain hour in more current oil tank oil tank farm stock and historical snapshot information bank, if meet emptying termination condition, jumps to step (7), otherwise jumps to step (8);
(7) in renewal emptying information table, the corresponding emptying of current oil tank starts record, generates a complete emptying record;
(8) this oil product stock detects and finishes.
Fig. 6 is that in data snapshot method, historical snapshot is obtained schematic diagram, and this module is mainly divided into agentd and server two parts.Wherein, agentd is mainly responsible for extracting from real-time information storehouse the latest snapshot information of refuelling station's oil tank and oil gun, and server is mainly responsible for configuration information and issues and SNAPSHOT INFO is saved in to historical snapshot information bank.As shown in Figure 6, whole service process can be divided into following two subprocess:
(1) obtain the list of snapshot detection information parameter
Each parameter corresponding a kind of metrical information value of refuelling station's oil tank or oil gun, as oil tank oil stock, oil tank water accumulating volume, oil gun pump code value etc.Agentd obtains detected parameters list by timing from Server, and object is to guarantee the parameter list that upgrades in time.Obtaining of parameter list comprises the following steps:
Agentd obtains timing cycle from configuration information storehouse, the get parms time LT of list of the cycle that simultaneously arranges;
Agentd initiatively initiates connection request to Server, connects;
After Server receives the request of Agentd, be its Resources allocation, and return to request-reply;
Agentd sends to Server the list request that gets parms;
Server query configuration information bank, returns to corresponding detected parameters list;
Agentd resolves the parameter list receiving, if list information is preserved in request for the first time; Otherwise, upgrade previous list information;
After operating successfully, Agentd initiatively closes connection, and Server also does corresponding rehabilitation, releasing resource;
The overtime triggering of Agentd waiting timer LT, jumps to step 1).
(2) on, send fuel station information snapshot
On to send the process of data be that periodically each detected parameters at least comprises key and two parameters of delay, wherein key is the key word that needs the parameter of detection, delay is the cycle detection time.General steps is as follows:
Agentd is according to the delay value of detected parameters, and setting cycle SNAPSHOT INFO detects timer MT;
The overtime triggering of Agentd waiting timer MT;
Agentd gathers the corresponding SNAPSHOT INFO in refuelling station buffer memory according to the key of detected parameters;
Agentd initiatively initiates connection request to Server, connects;
After Server receives the request of Agentd, be its Resources allocation, and return to request-reply;
Agentd is to the SNAPSHOT INFO that send buffer memory on Server;
Server is saved in the information of sending on Agentd in historical snapshot information bank, and result is returned.Meanwhile, Server calls correlation module and makes calculation process, comprises service alarm, emptying detection etc.;
Agentd initiatively closes connection, and Server also does corresponding rehabilitation, and releasing resource jumps to step 1).
This method can greatly reduce employee's workload, increases work efficiency.Employee only needs simple operations, just can complete easily, exactly acquisition of information; The SNAPSHOT INFO that utilizes all oil tanks in refuelling station and oil gun, calculates in real time, compares, and pinpoints the problems in time and alarm occurs, and eliminates safe hidden trouble.For the graduation business of refuelling station class provide a set of efficiently, computing mechanism accurately, can in real time, automatically detect oil tank stock, and to second logistic system, send emptying application in time, avoid the generation of slack tank phenomenon.In addition, can accurately detect RTC unloading, and statistics is unloaded oil mass automatically, has optimized operation flow, has improved efficiency.The time that this method proposes drives and regularly drives the mode combining, event-driven is mainly done the sampling of oil gun transaction level, timing drives and can root army business demand adjust flexibly, compares with level sampling second, can tens data volumes that even hundred times reduces transmission and stores.
Above the Snapshot Method of a kind of refuelling station data acquisition provided by the present invention and application is described in detail, for one of ordinary skill in the art, thought according to the embodiment of the present invention, all will change in specific embodiments and applications, this description should not be construed as limitation of the present invention.
Claims (10)
- The Snapshot Method of the data acquisition of 1.Yi Zhong refuelling station and application, is characterized in that, comprises the steps:Tank information is carried out to second grade samples and is saved in tank information storehouse and real-time information storehouse;The real-time fuel-displaced information of oil gun is carried out to second grade samples and is saved in oil gun information bank and real-time information storehouse;Gather oil gun Transaction Information and be saved in Transaction Information storehouse and transaction SNAPSHOT INFO storehouse and real-time information storehouse;Timing acquiring oil gun, oil tank up-to-date information are also saved in historical snapshot information bank;According to the alarm threshold parameter of setting in configuration information storehouse, in conjunction with oil gun, oil tank up-to-date information, judge whether to meet alarm conditions, if meet, carry out corresponding warning;According to the oil tank threshold parameter of setting in configuration information storehouse, in conjunction with oil tank up-to-date information, judge whether oil tank stock reaches to unload oil standard, if reach, to logistics distribution system, send oil products delivery request;According to the emptying testing conditions of setting in configuration information storehouse, in conjunction with oil tank historical snapshot information bank, whether the variable quantity that calculates tank capacity satisfies condition, and sends corresponding prompting, and emptying information is saved in emptying information bank if meet;According to the time parameter of setting in configuration information storehouse, from tank information storehouse and Transaction Information storehouse and transaction SNAPSHOT INFO storehouse, extract data and carry out loss calculating.
- 2. the Snapshot Method of refuelling station according to claim 1 data acquisition and application, is characterized in that, described collection oil gun Transaction Information and be saved in transaction SNAPSHOT INFO warehouse mainly comprise the steps:By collecting device, gather oil gun data;According to oil machine and host computer communication protocol, cutting data is searched the frontier point of packet from data stream;Judgement type of data packet, if real time data is saved in oil gun information warehouse; If transaction data extracts the up-to-date information of all oil guns in this refuelling station and all oil tanks from real-time information storehouse, and be saved in transaction SNAPSHOT INFO warehouse.
- 3. the Snapshot Method of refuelling station according to claim 1 data acquisition and application, is characterized in that, described timing acquiring oil gun, oil tank up-to-date information are also saved in historical snapshot information warehouse and mainly comprise the steps:Set the time interval regularly, and be saved in configuration information storehouse;Administrative center reads information in repository, is issued to corresponding refuelling station;Refuelling station sets local timer according to configuration information;When timer is triggered, from real-time information storehouse, extracts the corresponding information of all oil tanks and oil gun in refuelling station and send to administrative center.
- 4. the Snapshot Method of refuelling station according to claim 3 data acquisition and application, it is characterized in that, administrative center carries out corresponding operating according to information data type: if oil tank data, judge whether to meet alarm conditions, satisfied alarm also produces alarm record, information is saved in to historical snapshot information bank simultaneously; Do not meet and the information of receiving is directly saved in to historical snapshot information bank.If oil gun data, are saved in historical snapshot information bank by the every transaction trading volume of oil gun and accumulative total pump code value.
- 5. the Snapshot Method of refuelling station according to claim 3 data acquisition and application, it is characterized in that, before tank capacity information is saved in historical snapshot information bank, judge whether oil tank oil storage variable quantity meets emptying testing conditions, if meet, record emptying information; If only do not meet and current oil reserve need be saved in to historical snapshot information bank.
- 6. the Snapshot Method of refuelling station according to claim 1 data acquisition and application, is characterized in that, described loss is calculated and mainly comprised the steps:Obtain the time parameter of setting in configuration information storehouse;Regularly add up interior oil tank oil pump capacity of period in tank information storehouse;Regularly adding up corresponding oil tank in emptying information bank unloads oil mass in the period;Regularly in statistics transaction SNAPSHOT INFO storehouse, in the oil gun period, pump code is walked number of words;Regularly add up interior transaction of oil gun period oil mass total value in transaction SNAPSHOT INFO storehouse;According to calculating gained tank unloading amount, oil gun pump code, walk number of words and oil gun transaction oil mass total value calculation interval internal loss.
- 7. according to the refuelling station's data acquisition described in claim 1 to 6 any one and the Snapshot Method of application, it is characterized in that, described tank information storehouse is: tank information library storage second refuelling station's tank information of level sampling, comprises refuelling station's numbering, oil tank numbering, oil product, profit cumulative volume, liquid level, acquisition time stamp;Described real-time information storehouse is: in real-time information storehouse, storing respectively the latest data of all oil tanks and oil gun in refuelling station, oil tank packet oil scraper tank numbering, oil product, profit cumulative volume, liquid level, water are high; Oil gun packet oil scraper rifle numbering, pump code value, current volume read-out, the amount of money that refuels;Described historical snapshot information bank is: in historical snapshot information bank, storing the SNAPSHOT INFO of all oil guns and oil tank in the refuelling station of timing acquiring, comprising the every transaction volume read-out of pump code, oil gun, the oil reserve of oil tank, the water accumulating volume of oil tank, the transactional cards card number of oil gun;Described oil gun information bank is: the fuel-displaced information of oil gun when oil gun information bank is being stored the oiling of real time second level sampling, comprising: refuelling station's numbering, oil gun number, oil price, pump code value, timestamp;Described Transaction Information storehouse is: Transaction Information library storage refuelling station's oil gun transaction record of Real-time Collection, comprising: terminal transaction sequence number, timestamp that refuelling station numbering, oil gun number, current volume read-out, PSAM card produce;Described transaction SNAPSHOT INFO storehouse is: transaction SNAPSHOT INFO library storage in refuelling station the SNAPSHOT INFO that certain rifle completes all oil tanks, oil gun in this station of the moment of fueling transaction, comprising: the terminal transaction sequence number that refuelling station's numbering, oil gun number, PSAM card produce, the stock of all oil tanks, the pump code of all oil guns, timestamp;Described configuration information storehouse is: in configuration information storehouse, depositing the parameter information that each related service of refuelling station sets, comprising the time parameter of computed losses, the minimum quantity of stores of the threshold parameter of alert service and application oil products delivery.
- 8. according to the refuelling station's data acquisition described in claim 1 to 6 any one and the Snapshot Method of application, it is characterized in that, described alarm threshold parameter refers to: alarm threshold parameter mainly comprises high liquid level threshold value, low liquid level threshold value, high water stage threshold value, and high liquid level threshold value refers to the maximal value of oil product tank farm stock in oil tank; Low liquid level threshold value refers to the minimum value of oil product tank farm stock in oil tank; High water stage threshold value refers to the maximal value of water accumulating volume in oil tank;The described alarm conditions that meet refer to: during the information of timing acquiring oil tank, the oil tank level of current collection or water level value are greater than or less than the threshold value that in alert service configuration information storehouse, relevant parameter is set.
- 9. according to the refuelling station's data acquisition described in claim 1 to 6 any one and the Snapshot Method of application, it is characterized in that, described oil tank threshold parameter refers to: when in oil tank, oil product tank farm stock is lower than certain storage, just can not sell again oil, must apply for oil products delivery, oil tank threshold parameter just refers to the oil tank stock in the time of need to applying for oil products delivery;Described reaching unloaded oil standard and referred to: the oil reserve of timing acquiring oil tank, minimum oil product memory margin in oil tank when the tank capacity of current collection is less than or equal to the oil tank of setting in configuration information storehouse and needs emptying.
- 10. according to the refuelling station's data acquisition described in claim 1 to 6 any one and the Snapshot Method of application, it is characterized in that, the time parameter of setting in described configuration information storehouse, can, according to refuelling station's business demand, arrange the time interval that " enter, sell, deposit " statistics refuelling station flexibly.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310721690.5A CN103645973B (en) | 2013-12-18 | 2013-12-18 | A kind of Snapshot Method of gas station's data acquisition and application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310721690.5A CN103645973B (en) | 2013-12-18 | 2013-12-18 | A kind of Snapshot Method of gas station's data acquisition and application |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103645973A true CN103645973A (en) | 2014-03-19 |
| CN103645973B CN103645973B (en) | 2017-08-11 |
Family
ID=50251194
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310721690.5A Expired - Fee Related CN103645973B (en) | 2013-12-18 | 2013-12-18 | A kind of Snapshot Method of gas station's data acquisition and application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103645973B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105160145A (en) * | 2015-07-02 | 2015-12-16 | 浙江工商大学 | Automatic oil discharge detection method and system for filling station |
| CN105588615A (en) * | 2015-12-14 | 2016-05-18 | 浙江工商大学 | Tank capacity table construction method and device based on real-time data acquisition |
| CN106021787A (en) * | 2016-05-31 | 2016-10-12 | 浙江工商大学 | Oil tank volume modeling method |
| CN107462299A (en) * | 2017-08-16 | 2017-12-12 | 浙江工商大学 | A kind of data processing method that oil tank volume list demarcation is carried out with integration |
| CN109716407A (en) * | 2016-06-14 | 2019-05-03 | 韦恩加油系统有限公司 | Method and apparatus for fuel adder electronic communication |
| CN109801020A (en) * | 2019-02-01 | 2019-05-24 | 中国石化销售有限公司浙江衢州石油分公司 | A kind of oil depot data summarization is analysis shows that method |
| CN109993920A (en) * | 2017-12-29 | 2019-07-09 | 韶关市易通车联电子商务有限公司 | A kind of shared fuel loading system based on cloud |
| CN110203875A (en) * | 2019-06-10 | 2019-09-06 | 郑州永邦测控技术有限公司 | Gas station's integrated control system |
| CN110991328A (en) * | 2019-11-29 | 2020-04-10 | 重庆宏道拓土科技有限公司 | Excavator loading and engineering transport vehicle management system and method in construction process |
| CN111045971A (en) * | 2019-12-18 | 2020-04-21 | 大唐半导体科技有限公司 | Control circuit and method for cutting single serial port into multiple 232 serial ports of refueling tax control machine |
| CN112284486A (en) * | 2020-10-28 | 2021-01-29 | 中国石化销售股份有限公司贵州石油分公司 | Abnormal data monitoring method and device for liquid level meter, computer equipment and storage medium |
| CN113307215A (en) * | 2021-05-13 | 2021-08-27 | 青岛海尔空调器有限总公司 | Liquid filling method, device, apparatus, system, medium, and program product |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101452599A (en) * | 2007-12-04 | 2009-06-10 | 天津开发区贰加壹米兰环保科技有限公司 | Filling station management system |
| CN201724706U (en) * | 2010-07-23 | 2011-01-26 | 北京博瑞特自动计量系统股份有限公司 | Oil discharge safety monitor |
| CN201917382U (en) * | 2011-01-20 | 2011-08-03 | 福建榕泰达信息技术服务有限公司 | Real-time oil consumption management system |
-
2013
- 2013-12-18 CN CN201310721690.5A patent/CN103645973B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101452599A (en) * | 2007-12-04 | 2009-06-10 | 天津开发区贰加壹米兰环保科技有限公司 | Filling station management system |
| CN201724706U (en) * | 2010-07-23 | 2011-01-26 | 北京博瑞特自动计量系统股份有限公司 | Oil discharge safety monitor |
| CN201917382U (en) * | 2011-01-20 | 2011-08-03 | 福建榕泰达信息技术服务有限公司 | Real-time oil consumption management system |
Non-Patent Citations (2)
| Title |
|---|
| 焦海明: "中石化深圳石油分公司加油站管理信息系统建设方案", 《中国优秀硕士学位论文全文数据库，经济与管理科学辑》 * |
| 王淼: "加油站综合信息管理系统", 《中国优秀硕士学位论文全文数据库，信息科技辑》 * |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105160145A (en) * | 2015-07-02 | 2015-12-16 | 浙江工商大学 | Automatic oil discharge detection method and system for filling station |
| CN105160145B (en) * | 2015-07-02 | 2018-03-09 | 浙江工商大学 | A kind of method and system of gas station's automatic oil discharge detection |
| CN105588615A (en) * | 2015-12-14 | 2016-05-18 | 浙江工商大学 | Tank capacity table construction method and device based on real-time data acquisition |
| CN106021787A (en) * | 2016-05-31 | 2016-10-12 | 浙江工商大学 | Oil tank volume modeling method |
| CN106021787B (en) * | 2016-05-31 | 2019-04-02 | 浙江工商大学 | A kind of oil tank volume modeling method |
| CN109716407A (en) * | 2016-06-14 | 2019-05-03 | 韦恩加油系统有限公司 | Method and apparatus for fuel adder electronic communication |
| CN107462299A (en) * | 2017-08-16 | 2017-12-12 | 浙江工商大学 | A kind of data processing method that oil tank volume list demarcation is carried out with integration |
| CN109993920A (en) * | 2017-12-29 | 2019-07-09 | 韶关市易通车联电子商务有限公司 | A kind of shared fuel loading system based on cloud |
| CN109801020A (en) * | 2019-02-01 | 2019-05-24 | 中国石化销售有限公司浙江衢州石油分公司 | A kind of oil depot data summarization is analysis shows that method |
| CN110203875A (en) * | 2019-06-10 | 2019-09-06 | 郑州永邦测控技术有限公司 | Gas station's integrated control system |
| CN110991328A (en) * | 2019-11-29 | 2020-04-10 | 重庆宏道拓土科技有限公司 | Excavator loading and engineering transport vehicle management system and method in construction process |
| CN110991328B (en) * | 2019-11-29 | 2023-07-14 | 重庆宏道拓土科技有限公司 | System and method for managing loading of excavator and engineering transport vehicle in construction process |
| CN111045971A (en) * | 2019-12-18 | 2020-04-21 | 大唐半导体科技有限公司 | Control circuit and method for cutting single serial port into multiple 232 serial ports of refueling tax control machine |
| CN112284486A (en) * | 2020-10-28 | 2021-01-29 | 中国石化销售股份有限公司贵州石油分公司 | Abnormal data monitoring method and device for liquid level meter, computer equipment and storage medium |
| CN113307215A (en) * | 2021-05-13 | 2021-08-27 | 青岛海尔空调器有限总公司 | Liquid filling method, device, apparatus, system, medium, and program product |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103645973B (en) | 2017-08-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103645973A (en) | Data acquisition and application snapshot method of filling station | |
| CN102081622B (en) | Method and device for evaluating system health degree | |
| CN101989283B (en) | Monitoring method and device of performance of database | |
| CN104156296B (en) | The system and method for intelligent monitoring large-scale data center cluster calculate node | |
| CN107329877B (en) | Air ticket business monitoring and executing system and method | |
| CN104809030A (en) | Android-based exception handling system and method | |
| CN103810231A (en) | Maintenance system for aircraft fleet and method for planning maintenance | |
| CN101197621A (en) | Method and system for remote diagnosing and locating failure of network management system | |
| CN103118051A (en) | Method and device for monitoring information issuing process | |
| CN101808007A (en) | Method for acquiring real-time performance data by network manager | |
| CN109614412A (en) | Data publication service two-stage shared buffer memory analysis strategy on cloud based on power industry | |
| CN110442495A (en) | The method for automating cruising inspection system exception | |
| CN105373118A (en) | Intelligent equipment data acquisition method | |
| CN113949652B (en) | User abnormal behavior detection method and device based on artificial intelligence and related equipment | |
| CN103530328B (en) | A kind of data statistic analysis system and method | |
| CN101355443B (en) | Method for acquiring ARM terminal equipment status | |
| CN102761429B (en) | A kind of abnormal call bill processing method and system | |
| CN104504504B (en) | A kind of electric network data transition detection and analysis system based on holographic time scale measurement | |
| CN104516953B (en) | A kind of black box subsystem for power dispatching automation magnanimity message | |
| CN106443171A (en) | System and method for metering data of power bus during power failure of power utilization equipment | |
| CN105223514A (en) | The reliability determination methods of Large Copacity energy storage device | |
| CN116090789B (en) | Lean manufacturing production management system and method based on data analysis | |
| CN109377143B (en) | Operation trace acquisition system, acquisition method, management system and management method | |
| CN102800159B (en) | Automatic transaction device and method for predicating cash demanded quantity | |
| CN116645082A (en) | System inspection method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170811 Termination date: 20171218 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |