CN109615297A - A kind of storehouse Data Audit method, apparatus, system and readable storage medium storing program for executing - Google Patents
A kind of storehouse Data Audit method, apparatus, system and readable storage medium storing program for executing Download PDFInfo
- Publication number
- CN109615297A CN109615297A CN201811527161.0A CN201811527161A CN109615297A CN 109615297 A CN109615297 A CN 109615297A CN 201811527161 A CN201811527161 A CN 201811527161A CN 109615297 A CN109615297 A CN 109615297A
- Authority
- CN
- China
- Prior art keywords
- data
- storage
- library
- audit
- server
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012550 audit Methods 0.000 title claims abstract description 178
- 238000000034 method Methods 0.000 title claims abstract description 54
- 238000007726 management method Methods 0.000 claims abstract description 22
- 238000001514 detection method Methods 0.000 claims description 19
- 230000005540 biological transmission Effects 0.000 claims description 11
- 230000002159 abnormal effect Effects 0.000 claims description 8
- 238000011156 evaluation Methods 0.000 claims description 7
- 238000012545 processing Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 5
- 230000005856 abnormality Effects 0.000 claims description 3
- 238000004364 calculation method Methods 0.000 claims 1
- 230000000694 effects Effects 0.000 abstract description 3
- 230000008569 process Effects 0.000 description 11
- 239000010410 layer Substances 0.000 description 8
- 238000005516 engineering process Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 230000007246 mechanism Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 238000007689 inspection Methods 0.000 description 5
- 238000010276 construction Methods 0.000 description 3
- 239000012792 core layer Substances 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 230000015572 biosynthetic process Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000003786 synthesis reaction Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V20/00—Scenes; Scene-specific elements
- G06V20/50—Context or environment of the image
- G06V20/52—Surveillance or monitoring of activities, e.g. for recognising suspicious objects
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V20/00—Scenes; Scene-specific elements
- G06V20/60—Type of objects
- G06V20/62—Text, e.g. of license plates, overlay texts or captions on TV images
- G06V20/625—License plates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V2201/00—Indexing scheme relating to image or video recognition or understanding
- G06V2201/08—Detecting or categorising vehicles
Abstract
The invention discloses a kind of storehouse Data Audit methods, this method comprises: receiving the library that library point audit server is sent points out storage data；Library point audit server from the core switch of library point, is obtained library and points out storage data by Port Mirroring；What reception center audit server was sent goes out storage business datum；Center audit server from the service convergence interchanger at store management center, is obtained out by Port Mirroring and is put in storage business datum；According to detected rule, judge that library points out whether storage data match with storage business datum out；If it is not, then exporting out the warning message of storage business datum exception.This method can judge the authenticity for the data that each library point uploads, and then ensured that the audit to storehouse data is true and effective audit in the case where not influencing the normal operation of original treasury management system.The invention also discloses a kind of storehouse Data Audit device, system and readable storage medium storing program for executing, have corresponding technical effect.
Description
Technical field
The present invention relates to storehouse regulation technique field, more particularly to a kind of storehouse Data Audit method, apparatus, system and
Readable storage medium storing program for executing.
Background technique
After country pushes forward the construction of intelligent grain depot comprehensively, however it remains intelligent grain depot system the case where not conforming to specification.
In general, the data to grain depot are supervised, supervised in a set of intelligent grain depot system being completed mostly.For example,
According to set rule, the data uploaded to each library point are detected.In this way, although the number for not being inconsistent specification can be detected
According to.But if unauthorized person distorts data itself when library point uploads data.At this point, intelligent grain depot system is in logarithm
When according to being detected, because that can not learn whether the data itself have been tampered, also the data for not being inconsistent specification can not just be carried out true
It is effectively detected in fact.That is, the audit function of storage data is even developed out in intelligent grain depot system, but by
In that can not ensure whether business datum is true and reliable, therefore, the audit function of intelligent grain depot itself performs practically no function, and can not accomplish
To the effect that storage data are audited out, it is unfavorable for building intelligent grain depot, especially " brings down stocks to manage " mechanism.
In conclusion how to storehouse data carry out it is objective, effectively audit the problems such as, be current those skilled in the art
Technical problem urgently to be solved.
Summary of the invention
The object of the present invention is to provide a kind of storehouse Data Audit method, apparatus, system and readable storage medium storing program for executing, to library
The data progress of storage out of room administrative center is objective, effectively audits.
In order to solve the above technical problems, the invention provides the following technical scheme:
A kind of storehouse Data Audit method, comprising:
It receives the library that library point audit server is sent and points out storage data；The library point audit server passes through Port Mirroring
From the core switch of library point, obtains the library and point out storage data；
What reception center audit server was sent goes out storage business datum；The center audit server passes through Port Mirroring
From the service convergence interchanger at store management center, the storage business datum out is obtained；
According to detected rule, judge that the library points out storage data and goes out to be put in storage whether business datum matches with described；
Go out to be put in storage the warning message of business datum exception if it is not, then output is described.
Preferably, further includes:
Receive the storage video out that the center audit server is sent；
Go out to be put in storage video progress structuring to described, acquisition is described to go out to be put in storage the structured message of vehicle in video；
According to vehicle detection rule, the structured message is detected, determines whether the structured message closes rule；
Go out to be put in storage the warning message of video violation if it is not, then output is described.
Preferably, further includes:
Receive the bank settlement data that bank audit server is sent；The bank audit server passes through Port Mirroring from institute
It states in bank's convergence switch at store management center, obtains the bank settlement data；
According to bank settlement detected rule, the bank settlement data are detected, determine whether the bank settlement data close
Rule；
If it is not, then exporting the warning message of the bank settlement data violation.
Preferably, judge that storage data and the storage business datum out are pointed out in the library according to detected rule described
After whether matching, further includes:
If it is, going out storage business datum described in determining for truthful data, and the true evaluation result of output data.
A kind of storehouse Data Audit device, comprising:
Storage data acquisition module is pointed out in library, and storage data are pointed out in the library for receiving the transmission of library point audit server；Institute
It states library point audit server and passes through Port Mirroring from the core switch of library point, obtain the library and point out storage data；
Storage business datum obtains module out, for receiving the storage business datum out of center audit server transmission；Institute
Center audit server is stated through Port Mirroring from the service convergence interchanger at store management center, acquisition is described to go out to be put in storage industry
Business data；
Data validity detection module, for judging that storage data and the discrepancy are pointed out in the library according to detected rule
Whether library business datum matches；
Alarm module, for if it is not, then the output warning message for being put in storage business datum exception out.
A kind of storehouse data accountability system, comprising:
Be connected library point audit server with the bypass of the core switch of each library point；It is each with store management central data
The convergence switch of the library point bypasses the center audit server that is connected；And respectively with the library point audit server and institute
The database server that the center audit server of stating is connected；
Wherein, the library point audit server, for obtaining library from the service convergence interchanger by Port Mirroring
Storage data are pointed out, and storage data are pointed out into the library and are sent to the database server；
The center audit server, for by Port Mirroring, from being obtained in the convergence switch on each library point
Report goes out storage business datum, and the business datum of storage out is sent to the data server；
The data server, for judging that storage data and the storage industry out are pointed out in the library according to detected rule
Whether business data match, if it is not, then described go out to be put in storage the warning message of business datum exception.
Preferably, further includes:
By bank's convergence switch at bank audit server, the bank audit server and the store management center
Road is connected；The bank audit server is sent for obtaining bank's bank settlement data, and by bank's bank settlement data
To the database server；
The database server judges whether bank's bank settlement data are normal according to bank settlement detected rule, if
It is abnormal, then export bank's bank settlement data exception warning information.
Preferably, further includes:
The center audit server, which is also used to obtain out, is put in storage video data, and the video data transmitting of storage out is sent
Video structural server is given, the video structural server goes out to be put in storage video data progress structuring processing, obtain to described
Vehicle structure information is obtained, and the vehicle structure information is sent to the database server；
The database server is with judging whether the vehicle structure information is normal, if not according to vehicle detection rule
Normally, then storage video data abnormality alarming information is exported out.
Preferably, the library point audit server is specifically used for obtaining from the core switch by Port Mirroring
Library point acquires the network data in network；The network data is parsed, original storage data out are obtained；To described original
Storage data are parsed out, and the data obtained to parsing are reconstructed, and obtain the library and point out storage data.
A kind of readable storage medium storing program for executing is stored with computer program, the computer program quilt on the readable storage medium storing program for executing
The step of processor realizes above-mentioned storehouse Data Audit method when executing.
Using method provided by the embodiment of the present invention, receives the library that library point audit server is sent and point out storage data；
Library point audit server from the core switch of library point, is obtained library and points out storage data by Port Mirroring；Reception center is examined
Count the storage business datum out that server is sent；Center audit server is converged by Port Mirroring from the business at store management center
In poly- interchanger, obtains out and be put in storage business datum；According to detected rule, judge that library points out storage data and goes out storage business datum
Whether match；If it is not, then exporting out the warning message of storage business datum exception.
Pass through Port Mirroring from the core switch of library point using library point audit server, obtains library and point out storage number
According to the record data that storage data are the data and outbound link that are put in storage link are pointed out in library.That is, obtained library point
Storage data are the true data of library point out.Simultaneously as it is to pass through end by library point audit server that storage data are pointed out in library
What port mirror image was acquired from the core switch of library point, therefore, it will not influence the business fortune of original Intelligent storehouse system
Row.Correspondingly, it is obtained from the service convergence interchanger at store management center using center audit server by Port Mirroring
Storage business datum will not equally influence the regular traffic operation of original treasury management system out.Storage business datum should be gone out
What as each library point was uploaded to store management center goes out storage data.Then, it can judge that library point enters and leaves according to detected rule
Whether library data match with storage business datum out, and if the determination result is YES, then showing this, storage business datum is true out, without
Distort, if judging result be it is no, show that this goes out to be put in storage data and be tampered, it is exportable at this time go out storage business datum it is abnormal
Warning message.
That is, method provided by the embodiment of the present invention, can not influence the normal of original treasury management system
In the case where operation, the authenticity for the data that each library point uploads is judged, and then ensured the audit to storehouse data
It is true and effective audit.When being applied in large storehouse management system, as national reserved grain intelligent grain depot system in, can
The authenticity of the business datum of the upload of each library point is screened, the audit accuracy of grain depot data can be promoted, further
Be conducive to implement " taking an inventory of warehouses " mechanism.
Correspondingly, the embodiment of the invention also provides storehouse Data Audits corresponding with above-mentioned storehouse Data Audit method
Device, system and readable storage medium storing program for executing, have above-mentioned technique effect, and details are not described herein.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 is a kind of implementation flow chart of storehouse Data Audit method in the embodiment of the present invention；
Fig. 2 is a kind of common treasury management system structural schematic diagram；
Fig. 3 is a kind of structural schematic diagram of storehouse data accountability system provided by the embodiment of the present invention；
Fig. 4 is a kind of structural schematic diagram of storehouse Data Audit device in the embodiment of the present invention.
Specific embodiment
Core of the invention is to provide a kind of storehouse Data Audit method, and this method can be to the library of large storehouse or more libraries point
It effectively supervised, audited in house system.Specifically, this method can be used for purchase and supply warehouse, wholesale depot, retail storehouse
Library, transfer house, processing warehouse, in bonded warehouse, carries out including authenticity at reserve storage to the data of the administrative center in warehouse
The audit of examination.Lead to not accurate enough situation of auditing to avoid because data are false, wrong, warehouse is carried out very to realize
Real effective supervision.
Another core of the invention be to provide storehouse Data Audit device corresponding with storehouse Data Audit method, system and
Readable storage medium storing program for executing, details are not described herein.
In order to enable those skilled in the art to better understand the solution of the present invention, with reference to the accompanying drawings and detailed description
The present invention is described in further detail.Obviously, described embodiments are only a part of the embodiments of the present invention, rather than
Whole embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise
Under every other embodiment obtained, shall fall within the protection scope of the present invention.
Embodiment one:
Referring to FIG. 1, Fig. 1 is a kind of flow chart of storehouse Data Audit method in the embodiment of the present invention, this method can be answered
For in database server, method includes the following steps:
Storage data are pointed out in S101, the library for receiving the transmission of library point audit server.
Library point audit server from the core switch of library point, is obtained library and points out storage data by Port Mirroring.
Firstly, corresponding server can be added on the basis of existing treasury management system.Specifically, can be in such as Fig. 2
Shown in library point audit server and center audit server and database server are added in treasury management system.Wherein,
When choosing library point audit server and center audit server, since library point audit server and center audit server will be deposited
The mirror image data of interchanger is stored up, therefore can be used that memory capacity is larger, the faster server of read or write speed.After the completion of addition is
As shown in figure 3, wherein Fig. 2 is a kind of common treasury management system structural schematic diagram, Fig. 3 is provided system by the embodiment of the present invention
A kind of storehouse data accountability system structural schematic diagram.
Library point audit server by Port Mirroring from the core switch of library point, get library point out storage data it
Afterwards, library can be pointed out to storage data and be sent to database server.That is, database server can be by receiving library point
The mode of storage data is pointed out in the library that audit server is sent, and is obtained the library and is pointed out storage data.Wherein, Port Mirroring
(portMirroring) the data image of interchanger one or more port (VLAN) to the method for one or more ports.
Port Mirroring is also known as port mapping, is a kind of mode of network communication protocol.Core switch is library point core layer (network master
Stem portion) interchanger.It is that storage occurs for library point or when outbound that storage data are pointed out in library, the data of true record.
It should be noted that being to audit to take by library point since database server obtains library to point out the mode of storage data
Business device is by way of Port Mirroring from the core switch of library point, and storage data are pointed out in the library of acquisition, due to Port Mirroring
Itself it is the mode for the network data for not influencing core switch or not needing library point, therefore, audits and take even with library point
Business device gets library from core switch and points out storage data, will not influence the business in the point of library.
Wherein, library point audit server obtain library point out storage data detailed process include:
Step 1: by Port Mirroring, from the network data obtained in core switch in library point acquisition network；
Step 2: parsing to network data, original storage data out are obtained；
Step 3: being parsed to the original data of storage out, and the data obtained to parsing are reconstructed, and obtain library and point out
It is put in storage data.
It is illustrated for ease of description, below combining above three step.
Library point audit server due to being connected with the core switch of library point,, can be from core by Port Mirroring
Interchanger obtains the network data in library point acquisition network.Network data is parsed using the network transmission protocol, is obtained
It is original to go out to be put in storage data.Then, the data for the original data of storage out being parsed, and being obtained to parsing carry out weight, and acquisition can
Point out storage data in the library for being sent to database server.
S102, the storage business datum out that center audit server is sent is received.
Center audit server from the service convergence interchanger at store management center, is put in storage out by Port Mirroring
Business datum.
Usually will be directly facing in network user connection or access network part be known as access layer, will be located at access layer and
The purpose of part between core layer is known as distribution layer or convergence layer, access layer is that terminal user is allowed to be connected to network.Converge
Layer switch is the convergent point of more access-layer switch, it allows for handling all traffics from access layer equipment,
And provide the uplink for arriving core layer.That is, center audit server can be by Port Mirroring from store management center
Service convergence interchanger in obtain that each library point uploads go out storage business datum.Then, center audit server will acquire
To go out storage business datum be sent to database server.I.e. database server is sent by reception center audit server
Go out be put in storage business datum mode, come obtain each library point be uploaded to store management center go out storage business datum.Similarly,
Due to using the method for Port Mirroring, therefore, will not influence original treasury management system or storehouse in acquisition process
The business of administrative center operates normally.
S103, according to detected rule, judge library point out storage data with go out to be put in storage whether business datum matches.
Pointing out storage data as library is library point truthful data documented by storage link and outbound link, and goes out to be put in storage
Business datum is as the business datum for being uploaded to store management center for library point.Therefore, it is pointed out if going out storage business datum with library
It is put in storage data to mismatch, then the storage business datum that goes out for showing that library point uploads is tampered.Specifically, can be detected according to presetting
Rule judges that library points out whether storage data match with storage business datum.
If it is not, then the operation of executable step S104.
If it is, can be without operation.Certainly, in order to enable store management personnel or other related personnel understand each storehouse
Truth, can also library point out storage data with go out be put in storage business datum match when, to the library, point is evaluated.It is preferred that
Ground, if it is, determining to be put in storage business datum as truthful data, and the true evaluation result of output data.Specifically, can needle
The each of each library point is gone out to be put in storage the record of data, is determined if really, and then provide the true evaluation result of data.
S104, the warning message for exporting out storage business datum exception.
If going out storage business datum, also storage data mismatch is pointed out in library, and show the upload of library point goes out storage business datum
It is not true, the warning message of storage business datum exception can be entered and left out, directly at this time so that administrative staff arrange the data
It looks into, to avoid economic loss is generated.
Using method provided by the embodiment of the present invention, receives the library that library point audit server is sent and point out storage data；
Library point audit server from the core switch of library point, is obtained library and points out storage data by Port Mirroring；Reception center is examined
Count the storage business datum out that server is sent；Center audit server is converged by Port Mirroring from the business at store management center
In poly- interchanger, obtains out and be put in storage business datum；According to detected rule, judge that library points out storage data and goes out storage business datum
Whether match；If it is not, then exporting out the warning message of storage business datum exception.
Pass through Port Mirroring from the core switch of library point using library point audit server, obtains library and point out storage number
According to the record data that storage data are the data and outbound link that are put in storage link are pointed out in library.That is, obtained library point
Storage data are the true data of library point out.Simultaneously as it is to pass through end by library point audit server that storage data are pointed out in library
What port mirror image was acquired from the core switch of library point, therefore, it will not influence the business fortune of original Intelligent storehouse system
Row.Correspondingly, it is obtained from the service convergence interchanger at store management center using center audit server by Port Mirroring
Storage business datum will not equally influence the regular traffic operation of original treasury management system out.Storage business datum should be gone out
What as each library point was uploaded to store management center goes out storage data.Then, it can judge that library point enters and leaves according to detected rule
Whether library data match with storage business datum out, and if the determination result is YES, then showing this, storage business datum is true out, without
Distort, if judging result be it is no, show that this goes out to be put in storage data and be tampered, it is exportable at this time go out storage business datum it is abnormal
Warning message.
That is, method provided by the embodiment of the present invention, can not influence the normal of original treasury management system
In the case where operation, the authenticity for the data that each library point uploads is judged, and then ensured the audit to storehouse data
It is true and effective audit.When being applied in large storehouse management system, as national reserved grain intelligent grain depot system in, can
The authenticity of the business datum of the upload of each library point is screened, the audit accuracy of grain depot data can be promoted, further
Be conducive to implement " taking an inventory of warehouses " mechanism.
It should be noted that based on the above embodiment, the embodiment of the invention also provides be correspondingly improved scheme.Excellent
It can mutually be referred between step or corresponding steps same with the above-mentioned embodiment involved in choosing/improvement embodiment, it is corresponding beneficial
Effect can also be cross-referenced, no longer repeats one by one in preferred/improvement embodiment of this paper.
Preferably, if storage or outbound have for go out storage vehicle imaged, can also based on should go out storage video into
Row supervision.Specifically, process of supervision includes:
Step 1: receiving the storage video out that center audit server is sent；
Step 2: carrying out structuring to storage video is gone out, the structured message of vehicle in storage video is obtained out；
Step 3: being detected to structured message according to vehicle detection rule, determining whether structured message closes rule；
Step 4: if it is not, then exporting out the warning message of storage video violation.
It is illustrated for ease of description, below combining aforementioned four step.
Specifically, center audit server can get what each library point uploaded by Port Mirroring from convergence switch
It is put in storage video out.Specifically, the mode that center audit server obtains out storage video can refer to above-mentioned storage business number out
According to process, details are not described herein.After when center, audit server gets out storage video, this can be gone out be put in storage video
It is sent to database server.Database server receives this and goes out to be put in storage after video, can carry out structure to storage video is gone out
Change, obtains this and go out to be put in storage the result information of vehicle in video.Then, according to vehicle detection rule, to the result information into
Row monitoring, determines whether the structured message closes rule.It is exportable to go out to be put in storage the warning message of video violation if irregularity,
So that administrative staff are handled in time, if qualified, this can be gone out to be put in storage video give to close evaluation of rule or to add upper data true
Label.
Preferably, in order to supervise to storehouse data, bank settlement data can also be obtained, with determine store management personnel or
Whether storehouse operator closes rule.Detailed process is as follows:
Step 1: receiving the bank settlement data that bank audit server is sent；Bank audit server passes through Port Mirroring
From bank's convergence switch at store management center, bank settlement data are obtained；
Step 2: detecting according to bank settlement detected rule to bank settlement data, determine whether bank settlement data close rule；
Step 3: if it is not, then the warning message of output bank settlement data violation.
For ease of description, above three step is combined below and is illustrated.
Bank audit server, user's auditing service are connected in bank's convergence switch bypass at store management center
Device can obtain bank settlement data from bank's convergence switch at store management center by Port Mirroring, then by the receipt and payment
Amount of money evidence is sent to database server.Wherein, the specific implementation process that bank audit server obtains bank settlement data can join
The acquisition process of storage data is pointed out according to library above, this is no longer going to repeat them.
After database server receives bank settlement data, can according to transmitting-receiving detected rule, to bank settlement element according into
Row detection, to determine whether the bank settlement data close rule.If irregularity, the alarm signal of exportable bank settlement data violation
Bank settlement data can be determined as authentic data if closing rule by breath.
Embodiment two:
Technical solution provided by the embodiment of the present invention is better understood for the ease of those skilled in the art, below with application
To for the intelligent grain depot system in " intelligent grain depot " construction, it is provided for the embodiments of the invention technical solution and is described in detail.
Before implementing method described in the embodiment of the present invention, disposed as follows in intelligent grain depot system first:
1, an independent equipment is connected in the core switch bypass of each grain depot, i.e., library point as described above is examined
Server is counted, the data in equipment independent acquisition institute there is any discrepancy library reconstruct the data of storage key business, upload province's platform,
Any influence is not generated to original operation system.
2, an independent equipment is connected in the convergence switch bypass that Grain Administration of Shanxi Province acquires each library point data, i.e., above
Described center audit server, the data that all library points of the equipment independent acquisition report reconstruct storage key business
Data, to platform is saved, storage operation system does not generate any influence out.
3, an independent equipment is connected in the convergence switch bypass that Grain Administration of Shanxi Province acquires each bank paying data, i.e.,
Bank audit server as described above, the payment data which reports reconstruct storage and close
The clearing payment data of key business, to platform is saved, storage operation system does not generate any influence out.
4, the system for establishing a set of storage business video structural out in province's platform goes out storage business what each library point reported
Video carries out structuring, and system automatic identification judges that vehicle goes out whether storage link practises fraud in crucial.
After each equipment is built completion, can in the computer room of each grain depot, using audit server, acquisition, reconstruct, on
Spread out of the data of storage.
Specifically, library point audit server acquires all data in network by the mirror port of core switch；Then,
The data are parsed using the network transmission protocol, library is obtained and points out storage data, is i.e. the storage link of database port (is stepped on
Note, inspection, scale gross weight, value storehouse, scale tare weight, is settled accounts, is gone out sample) and outbound link (registration, scale tare weight, value storehouse, scale gross weight,
Settle accounts, go out) information；Then, according to the SQL syntax feature of disparate databases, parse the information of storage link, and by its
The data for being put in storage each link are reconstructed into out, are saved in audit database table, the data for being put in storage each link and alarm number are uploaded out
Go out to be put in storage audit database table according to province's platform.For example, audit database table can be sent to the center auditing service of province's platform
Device, or audit database table is sent to a data server dedicated for handling data.
In the computer room for saving platform, using audit server, the synthesis for acquiring, reconstructing each library point goes out to be put in storage data, acquires, again
The banker's payment data of each library point of structure.
Specifically, center audit server acquires all numbers in network by saving the mirror port of the core switch of platform
According to；Then, what each library point that only database port is arrived in processing uploaded goes out storage business datum, i.e., comprehensive storage information out；Root
According to the SQL syntax feature of disparate databases, the comprehensive storage information out of parsing, and the data of comprehensive storage out are reconstructed into, it protects
It is stored in province's platform audit database table.Furthermore it is also possible to which the mirror port by each bank's access switch acquires in network
All data；Then, the information to the payment of database port is only handled；According to the SQL syntax feature of disparate databases, parsing
The information of payment, and the data of payment are reconstructed into, it is saved in province's platform audit database table；
In the computer room for saving platform, using video structural server, institute's there is any discrepancy library video progress structuring, specifically
, that reads each library point goes out storage video composition information (being put in storage link+camera out)；Read out storage video (per car one
It is a), and storage video composition information is pointed out according to library and decomposites storage video to storage link out；It will go out to be put in storage the video of link
Give video structural server process, obtain the link video vehicle structure information (link+license plate number+license plate color+
Vehicle brand+body color).
After completing above-mentioned data collection task, intelligent early-warning analysis can be carried out.
Specifically, checking rule, inspection according to the process between the Content inspection rule gone out in storage link and link of definition
That looks into grain depot acquisition goes out storage data, alarms the data of irregularity；According to the content inspection of definition gone out in storage link
The process looked between rule and link checks rule, checks that the synthesis for saving platform acquisition goes out to be put in storage data, to the data of irregularity into
Row alarm；Rule is checked according to the payment of definition, checks the payment data for saving platform acquisition, the data of irregularity are reported
It is alert；According to vehicle inspection rule between the link of definition, the data of storage video structural are checked, the data of irregularity are carried out
Alarm；Comprehensive Comparison, discovery are carried out to storage data, the comprehensive data of storage out, payment data, video structural data are gone out
Problem is alerted；The centralized processing of all alarms, manually checks up on the facts, result of handling it.
Wherein, can refer to Tables 1 and 2 about the detection for going out storage business datum, specific table 1 is content detection regulation,
Table 2 is process detection regulation (wherein, [] indicates inessential link).
Table 1
Table 2
After completing above-mentioned detection, " quantity is true " evaluation can be carried out.
Specifically, can include:
Train number quantity is true: the train number does not alert in storage or each link of outbound, or occurs alerting through people
Work checks up on the facts, and there is no problem.
Quantity is true between storehouse for grain, etc.: all train number quantity being put in storage between storehouse for grain, etc. are true, all train number quantity of outbound are true, then between storehouse for grain, etc.
Quantity is true；
Reservoir area quantity is true: quantity is true between each storehouse for grain, etc. of reservoir area, then reservoir area quantity is true.
Using technical solution provided by the embodiment of the present invention, that is, independent auditing by third party technology is used, audit enters and leaves
Library " quantity is true " property can spend several hundred million funds to carry out " taking an inventory of warehouses " for annual country and provide a new feasible way
Diameter.In addition, integrated application multiple technologies: network bypass obtains data, according to model reconstruction data technique；It is put in storage video frequency vehicle out
Message structure technology；The technologies such as regular definition, application, warning technology can escort for the independent auditing by third party of realization,
To complete intelligent silo construction, especially " bring down stocks to manage " mechanism.
Embodiment three:
Corresponding to above method embodiment, the embodiment of the invention also provides a kind of storehouse data accountability systems, hereafter
The storehouse data accountability system of description can correspond to each other reference with above-described storehouse Data Audit method.
Shown in Figure 3, which includes:
Be connected library point audit server 201 with the bypass of the core switch 200 of each library point；With store management center
The convergence switches bypass 300 of the 400 each library points of acquisition is connected center audit server 301；And it audits respectively with library point
The database server 401 that server is connected with center audit server；
Wherein, library point audit server, for obtaining library from business convergence switch and pointing out storage by Port Mirroring
Data, and storage data are pointed out into library and are sent to database server；
Center audit server, for obtaining the discrepancy that each library point reports from convergence switch by Port Mirroring
Library business datum, and storage business datum will be gone out and be sent to data server；
Data server, for according to detected rule, judge library point out storage data and go out storage business datum whether
Match, if it is not, then going out to be put in storage the warning message of business datum exception.
Wherein, library point audit server, is specifically used for through Port Mirroring, and library point is obtained from core switch and acquires net
Network data in network；Network data is parsed, original storage data out are obtained；The original data of storage out are solved
Analysis, and the data obtained to parsing are reconstructed, and obtain library and point out storage data.
Preferably, rule whether are closed for the ease of supervision bank settlement, the system further include:
Bank audit server, bank audit server are connected with the bypass of bank's convergence switch at store management center
It connects；Bank audit server is sent to database service for obtaining bank's bank settlement data, and by bank's bank settlement data
Device；
Database server judges whether bank's bank settlement data are normal, if abnormal, then according to bank settlement detected rule
Export bank's bank settlement data exception warning information.
Preferably, it is put in storage video data in order to supervise out, the system further include:
Center audit server, which is also used to obtain out, is put in storage video data, and will go out storage video data transmitting and give video knot
Structure server, video structural server carry out structuring processing to storage video data is gone out, obtain vehicle structure information,
And vehicle structure information is sent to database server；
Database server is then defeated if abnormal, with judging whether vehicle structure information is normal according to vehicle detection rule
Go out storage video data abnormality alarming information.
Using system provided by the embodiment of the present invention, receives the library that library point audit server is sent and point out storage data；
Library point audit server from the core switch of library point, is obtained library and points out storage data by Port Mirroring；Reception center is examined
Count the storage business datum out that server is sent；Center audit server is converged by Port Mirroring from the business at store management center
In poly- interchanger, obtains out and be put in storage business datum；According to detected rule, judge that library points out storage data and goes out storage business datum
Whether match；If it is not, then exporting out the warning message of storage business datum exception.
Pass through Port Mirroring from the core switch of library point using library point audit server, obtains library and point out storage number
According to the record data that storage data are the data and outbound link that are put in storage link are pointed out in library.That is, obtained library point
Storage data are the true data of library point out.Simultaneously as it is to pass through end by library point audit server that storage data are pointed out in library
What port mirror image was acquired from the core switch of library point, therefore, it will not influence the business fortune of original Intelligent storehouse system
Row.Correspondingly, it is obtained from the service convergence interchanger at store management center using center audit server by Port Mirroring
Storage business datum will not equally influence the regular traffic operation of original treasury management system out.Storage business datum should be gone out
What as each library point was uploaded to store management center goes out storage data.Then, it can judge that library point enters and leaves according to detected rule
Whether library data match with storage business datum out, and if the determination result is YES, then showing this, storage business datum is true out, without
Distort, if judging result be it is no, show that this goes out to be put in storage data and be tampered, it is exportable at this time go out storage business datum it is abnormal
Warning message.
That is, system provided by the embodiment of the present invention, can not influence the normal of original treasury management system
In the case where operation, the authenticity for the data that each library point uploads is judged, and then ensured the audit to storehouse data
It is true and effective audit.When being applied in large storehouse management system, as national reserved grain intelligent grain depot system in, can
The authenticity of the business datum of the upload of each library point is screened, the audit accuracy of grain depot data can be promoted, further
Be conducive to implement " taking an inventory of warehouses " mechanism.
Example IV:
Corresponding to above method embodiment, the embodiment of the invention also provides a kind of storehouse Data Audit devices, hereafter
The storehouse Data Audit device of description can correspond to each other reference with above-described storehouse Data Audit method.
Shown in Figure 4, which comprises the following modules:
Storage data acquisition module 101 is pointed out in library, and storage data are pointed out in the library for receiving the transmission of library point audit server；
Library point audit server from the core switch of library point, is obtained library and points out storage data by Port Mirroring；
Storage business datum obtains module 102 out, for receiving the storage business datum out of center audit server transmission；
Center audit server from the service convergence interchanger at store management center, obtains out storage business number by Port Mirroring
According to；
Data validity detection module 103, for judging that storage data and storage business out are pointed out in library according to detected rule
Whether data match；
Alarm module 104, for if it is not, then exporting out the warning message of storage business datum exception.
Using device provided by the embodiment of the present invention, receives the library that library point audit server is sent and point out storage data；
Library point audit server from the core switch of library point, is obtained library and points out storage data by Port Mirroring；Reception center is examined
Count the storage business datum out that server is sent；Center audit server is converged by Port Mirroring from the business at store management center
In poly- interchanger, obtains out and be put in storage business datum；According to detected rule, judge that library points out storage data and goes out storage business datum
Whether match；If it is not, then exporting out the warning message of storage business datum exception.
Pass through Port Mirroring from the core switch of library point using library point audit server, obtains library and point out storage number
According to the record data that storage data are the data and outbound link that are put in storage link are pointed out in library.That is, obtained library point
Storage data are the true data of library point out.Simultaneously as it is to pass through end by library point audit server that storage data are pointed out in library
What port mirror image was acquired from the core switch of library point, therefore, it will not influence the business fortune of original Intelligent storehouse system
Row.Correspondingly, it is obtained from the service convergence interchanger at store management center using center audit server by Port Mirroring
Storage business datum will not equally influence the regular traffic operation of original treasury management system out.Storage business datum should be gone out
What as each library point was uploaded to store management center goes out storage data.Then, it can judge that library point enters and leaves according to detected rule
Whether library data match with storage business datum out, and if the determination result is YES, then showing this, storage business datum is true out, without
Distort, if judging result be it is no, show that this goes out to be put in storage data and be tampered, it is exportable at this time go out storage business datum it is abnormal
Warning message.
That is, device provided by the embodiment of the present invention, can not influence the normal of original treasury management system
In the case where operation, the authenticity for the data that each library point uploads is judged, and then ensured the audit to storehouse data
It is true and effective audit.When being applied in large storehouse management system, as national reserved grain intelligent grain depot system in, can
The authenticity of the business datum of the upload of each library point is screened, the audit accuracy of grain depot data can be promoted, further
Be conducive to implement " taking an inventory of warehouses " mechanism.
In a kind of specific embodiment of the invention, further includes:
Video detection module, for receiving the storage video out of center audit server transmission；It is carried out to storage video is gone out
Structuring obtains out the structured message of vehicle in storage video；According to vehicle detection rule, structured message is examined
It surveys, determines whether structured message closes rule；If it is not, then exporting out the warning message of storage video violation.
In a kind of specific embodiment of the invention, further includes:
Bank settlement detection module, for receiving the bank settlement data of bank audit server transmission；Bank audit server
Through Port Mirroring from bank's convergence switch at store management center, bank settlement data are obtained；It detects and advises according to bank settlement
Then, bank settlement data are detected, determines whether bank settlement data close rule；If it is not, then output bank settlement data violation
Warning message.
In a kind of specific embodiment of the invention, further includes:
Authentic Assessment module, for judging that library points out storage data and goes out storage business datum according to detected rule
After whether matching, if it is, determining to be put in storage business datum as truthful data, and the true evaluation result of output data.
Embodiment five:
Corresponding to above method embodiment, the embodiment of the invention also provides a kind of readable storage medium storing program for executing, are described below
A kind of readable storage medium storing program for executing can correspond to each other reference with a kind of above-described storehouse Data Audit method.
A kind of readable storage medium storing program for executing is stored with computer program on readable storage medium storing program for executing, and computer program is held by processor
The step of storehouse Data Audit method of above method embodiment is realized when row.
The readable storage medium storing program for executing be specifically as follows USB flash disk, mobile hard disk, read-only memory (Read-Only Memory,
ROM), the various program storage generations such as random access memory (Random Access Memory, RAM), magnetic or disk
The readable storage medium storing program for executing of code.
Professional further appreciates that, unit described in conjunction with the examples disclosed in the embodiments of the present disclosure
And algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware and
The interchangeability of software generally describes each exemplary composition and step according to function in the above description.These
Function is implemented in hardware or software actually, the specific application and design constraint depending on technical solution.Profession
Technical staff can use different methods to achieve the described function each specific application, but this realization is not answered
Think beyond the scope of this invention.
Claims (10)
1. a kind of storehouse Data Audit method characterized by comprising
It receives the library that library point audit server is sent and points out storage data；The library point audit server passes through Port Mirroring from library
In the core switch of point, obtains the library and point out storage data；
What reception center audit server was sent goes out storage business datum；The center audit server passes through Port Mirroring from library
In the service convergence interchanger of room administrative center, the storage business datum out is obtained；
According to detected rule, judge that the library points out storage data and goes out to be put in storage whether business datum matches with described；
Go out to be put in storage the warning message of business datum exception if it is not, then output is described.
2. storehouse Data Audit method according to claim 1, which is characterized in that further include:
Receive the storage video out that the center audit server is sent；
Go out to be put in storage video progress structuring to described, acquisition is described to go out to be put in storage the structured message of vehicle in video；
According to vehicle detection rule, the structured message is detected, determines whether the structured message closes rule；
Go out to be put in storage the warning message of video violation if it is not, then output is described.
3. storehouse Data Audit method according to claim 1, which is characterized in that further include:
Receive the bank settlement data that bank audit server is sent；The bank audit server passes through Port Mirroring from the library
In bank's convergence switch of room administrative center, the bank settlement data are obtained；
According to bank settlement detected rule, the bank settlement data are detected, determine whether the bank settlement data close rule；
If it is not, then exporting the warning message of the bank settlement data violation.
4. storehouse Data Audit method according to any one of claims 1 to 3, which is characterized in that described according to detection
Rule judges that the library points out storage data and goes out to be put in storage after whether business datum match with described, further includes:
If it is, going out storage business datum described in determining for truthful data, and the true evaluation result of output data.
5. a kind of storehouse Data Audit device characterized by comprising
Storage data acquisition module is pointed out in library, and storage data are pointed out in the library for receiving the transmission of library point audit server；The library
Point audit server from the core switch of library point, is obtained the library and points out storage data by Port Mirroring；
Storage business datum obtains module out, for receiving the storage business datum out of center audit server transmission；In described
Heart audit server from the service convergence interchanger at store management center, obtains the storage business number out by Port Mirroring
According to；
Data validity detection module, for judging that storage data and the storage industry out are pointed out in the library according to detected rule
Whether business data match；
Alarm module, for if it is not, then the output warning message for being put in storage business datum exception out.
6. a kind of storehouse data accountability system characterized by comprising
Be connected library point audit server with the bypass of the core switch of each library point；It is each described with store management central data
The convergence switch of library point bypasses the center audit server that is connected；And respectively with the library point audit server and it is described in
The database server that heart audit server is connected；
Wherein, the library point audit server, for obtaining library from the service convergence interchanger and pointing out by Port Mirroring
Data are put in storage, and storage data are pointed out into the library and are sent to the database server；
The center audit server, for obtaining what each library point reported from the convergence switch by Port Mirroring
It is put in storage business datum out, and the business datum of storage out is sent to the data server；
The data server, for judging that storage data and the storage business number out are pointed out in the library according to detected rule
According to whether matching, if it is not, then described go out to be put in storage the warning message of business datum exception.
7. storehouse data accountability system according to claim 6, which is characterized in that further include:
Bank audit server, the bank audit server and bank's convergence switch at the store management center bypass phase
Connection；The bank audit server is sent to institute for obtaining bank's bank settlement data, and by bank's bank settlement data
State database server；
The database server judges whether bank's bank settlement data are normal, if not just according to bank settlement detected rule
Often, then bank's bank settlement data exception warning information is exported.
8. storehouse data accountability system according to claim 6, which is characterized in that further include:
The center audit server, which is also used to obtain out, is put in storage video data, and gives the video data transmitting of storage out to view
Frequency structuring server, the video structural server go out to be put in storage video data progress structuring processing to described, obtain vehicle
Structured message, and the vehicle structure information is sent to the database server；
The database server is with judging whether the vehicle structure information is normal, if abnormal, according to vehicle detection rule
Then export out storage video data abnormality alarming information.
9. according to the described in any item storehouse data accountability systems of claim 6 to 8, which is characterized in that the library point audit clothes
Business device is specifically used for through Port Mirroring, from the network data obtained in library point acquisition network in the core switch；To institute
It states network data to be parsed, obtains original storage data out；To it is described it is original go out storage data parse, and to parsing
To data be reconstructed, obtain the library and point out storage data.
10. a kind of readable storage medium storing program for executing, which is characterized in that be stored with computer program, the meter on the readable storage medium storing program for executing
It is realized when calculation machine program is executed by processor as described in any one of Claims 1-4 the step of storehouse Data Audit method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811527161.0A CN109615297A (en) | 2018-12-13 | 2018-12-13 | A kind of storehouse Data Audit method, apparatus, system and readable storage medium storing program for executing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811527161.0A CN109615297A (en) | 2018-12-13 | 2018-12-13 | A kind of storehouse Data Audit method, apparatus, system and readable storage medium storing program for executing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109615297A true CN109615297A (en) | 2019-04-12 |
Family
ID=66008354
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811527161.0A Pending CN109615297A (en) | 2018-12-13 | 2018-12-13 | A kind of storehouse Data Audit method, apparatus, system and readable storage medium storing program for executing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109615297A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111897830A (en) * | 2020-07-31 | 2020-11-06 | 上海交大慧谷通用技术有限公司 | Case quality detection system |
| CN112787949A (en) * | 2020-09-17 | 2021-05-11 | 中兴通讯股份有限公司 | Flow acquisition and transportation management method, control device and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010012170A1 (en) * | 2008-07-28 | 2010-02-04 | 成都市华为赛门铁克科技有限公司 | Database security monitoring method, device and system |
| CN104394038A (en) * | 2014-12-08 | 2015-03-04 | 公安部第三研究所 | System and method for automatic detection and pre-alarming of network-off bypass |
| CN106850285A (en) * | 2017-01-19 | 2017-06-13 | 薛辉 | Video security monitoring device, auditing system and its deployment architecture and method |
| CN108763543A (en) * | 2018-05-31 | 2018-11-06 | 郑州信大天瑞信息技术有限公司 | Database audit monitors system |
-
2018
- 2018-12-13 CN CN201811527161.0A patent/CN109615297A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010012170A1 (en) * | 2008-07-28 | 2010-02-04 | 成都市华为赛门铁克科技有限公司 | Database security monitoring method, device and system |
| CN104394038A (en) * | 2014-12-08 | 2015-03-04 | 公安部第三研究所 | System and method for automatic detection and pre-alarming of network-off bypass |
| CN106850285A (en) * | 2017-01-19 | 2017-06-13 | 薛辉 | Video security monitoring device, auditing system and its deployment architecture and method |
| CN108763543A (en) * | 2018-05-31 | 2018-11-06 | 郑州信大天瑞信息技术有限公司 | Database audit monitors system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111897830A (en) * | 2020-07-31 | 2020-11-06 | 上海交大慧谷通用技术有限公司 | Case quality detection system |
| CN112787949A (en) * | 2020-09-17 | 2021-05-11 | 中兴通讯股份有限公司 | Flow acquisition and transportation management method, control device and storage medium |
| CN112787949B (en) * | 2020-09-17 | 2023-05-16 | 中兴通讯股份有限公司 | Flow acquisition and delivery management method, control device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8783555B2 (en) | Vault management method and system | |
| CN106506454B (en) | Cheat business recognition method and device | |
| CN104424694B (en) | The state analysis and forecasting system and its method of bank note treatment device | |
| CN109598505A (en) | A kind of qualitative data treating method and apparatus based on block chain | |
| CN111415753A (en) | Epidemic situation monitoring and early warning method and system based on block chain | |
| US11049070B2 (en) | Cash-point inventory management with demand forecasting | |
| CN109784759A (en) | A kind of Internal Audit system based on block chain technology | |
| CN105847302A (en) | Abnormity detection method and device | |
| CN110599670B (en) | Abnormal detection method and system for number of paper money in money box, server and financial equipment | |
| CN109508825A (en) | Employee's image method for prewarning risk and relevant apparatus | |
| JP2004334526A (en) | Calculation program and method for illegal determination score value, and calculation system for illegal determination score value of credit card | |
| CN107329877A (en) | Air ticket business monitoring execution system and method | |
| CN107767588A (en) | A kind of cash box condition detection method and atm device | |
| CN109615297A (en) | A kind of storehouse Data Audit method, apparatus, system and readable storage medium storing program for executing | |
| WO2019014821A1 (en) | Fault early warning method for financial terminal, terminal device and storage medium | |
| CN111539803A (en) | Pledge financing monitoring method, system and computer readable storage medium | |
| CN108550009A (en) | A kind of national treasury intelligent monitor system and its monitoring method based on WSN | |
| CN108257018A (en) | The examining report generation method and device of insurance system again | |
| CN110414806A (en) | Employee's method for prewarning risk and relevant apparatus | |
| CN106951360A (en) | Data statistics integrity degree computational methods and system | |
| CN110009347A (en) | A kind of method and device of block chain Transaction Information audit | |
| CN113837701A (en) | Storage supervisory systems based on RFID label | |
| CN106021857A (en) | A health diagnosis system and method | |
| CN203414995U (en) | Land use tax payment checking managing system | |
| CN107240015A (en) | The method for early warning of vehicle, device and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190412 |
|
| RJ01 | Rejection of invention patent application after publication |