CN106407292A - Method and device for detecting geometric variation of vector data in spatial database - Google Patents
Method and device for detecting geometric variation of vector data in spatial database Download PDFInfo
- Publication number
- CN106407292A CN106407292A CN201610757048.6A CN201610757048A CN106407292A CN 106407292 A CN106407292 A CN 106407292A CN 201610757048 A CN201610757048 A CN 201610757048A CN 106407292 A CN106407292 A CN 106407292A
- Authority
- CN
- China
- Prior art keywords
- data
- geometric
- tables
- change
- detected
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2237—Vectors, bitmaps or matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for detecting geometric variation of vector data in a spatial database. The geometric variation of the vector data in the spatial database is acquired by a log analysis method, variation information is extracted by parsing and contrastively analyzing geometric data, and results are classified into three kinds: no variation, spatial displacement variation, and both boundary and spatial displacement variation. According to the method and the device, monitoring on the variation of the vector data can be achieved by only starting log analysis, so that online real-time variation detection can also be achieved, and periodical non-real time detection can also be configured in combination with log backup management; the vector data in a log is parsed according to a storage scheme of the spatial data, so that the method and the device can be adaptive to the spatial databases of different storage modes; different geometric data variation types can be worked out by analyzing according to detection, and spatial data topological relations, related business data logic and database operation behaviors can be audited, thus ensuring security and logic completeness of the database.
Description
Technical field
The invention belongs to field of computer technology and in particular in a kind of spatial database vector data Geometrical change detection
Method and device.
Background technology
Data safety is most important for operating information system operation, and data base is not only the basis of operation system operation,
It is also the critical asset of enterprise and administration section, therefore safeguard the safety of data base it is ensured that the integrity of data is consistent with logic
Property is extremely important.Spatial database as stores the data base of spatial data, vector or raster data according to certain rule,
Structure, data type are stored in relational database, realize reading and the write behaviour of spatial data by specific operational approach
Make.In operating information system running, the change of vector data geometric shape in spatial database is due to operation flow
Caused by propulsion, its data topology relation is complete, and logical relation is consistent between business datum.Surprisingly or illegally grasp when there is data
When making, the integrity of geological information and logicality may be destroyed.For example, in Urbanization Progress land used process of supervision,
One piece of construction land plot data needs to look into flow process through strict criticizing for benefit, if bigger than reply plot in order to obtain
Area or more vantage point, are integrally put down being modified to plot geometrical boundary by illegal means for ground link or by plot
Move, will produce and mismatch plot geometric data with boundary mark record, the mistake in this plot geometric data can incoming use simultaneously
The follow-up business flow processs such as ground, lead to serious consequence.
Vector data Geometrical change is detected, and extracts change information, it is possible to achieve data integrity inspection and dynamic
State mutation analysises, are monitored to unexpected or illegal database manipulation, improve spatial database safety.Realize space at present
In data base, vector data change-detection mainly has two kinds of technical scheme：
A kind of vector data state being to record in spatial database different time node, extracts same vector data and exists
The state of any two timing node is analyzed, and can obtain geometry between this two timing nodes for this vector data
Change information.However, each mutation analysises of this method are required for extracting the complete vector data of two timing nodes, operation stream
Journey complexity is loaded down with trivial details, poor in timeliness, and the time granularity requirement simultaneously for data backup is higher, secondly, vector number in operation system
Related according to usual and other business datum tables, the method afterwards comparing cannot meet the demand of real time modifying checking.
Another kind is setting trigger on the vector data table in spatial database, when having in vector data space field
When additions and deletions change operation, trigger obtains Geometrical change data, obtains Geometrical change information by geometric data before and after analysis operation,
Realize the purpose of detection vector data Geometrical change.Although this method real-time is higher, need to existing space data base
Modify, database security can be brought with adverse effect, the rising of simultaneity factor coupling, be also unfavorable for realizing change inspection
The integrated application of brake.
Content of the invention
The technical problem to be solved is how to realize vector data Geometrical change in spatial database online
Real-time detection, improve change find and extract ageing.
For this technical problem, the invention provides the side that in a kind of spatial database, vector data Geometrical change detects
Method, including：
S1：Obtain the tables of data related to vector data to be detected and described tables of data corresponding day in spatial database
Will, is parsed to described daily record using log analysis tool, obtains described tables of data and is carrying out before data manipulation first
The second tables of data after the operation of tables of data data；
S2：Using default analytic method, obtain more than the first before described data manipulation according to described first tables of data
What data object, obtains the second geometric data object after described data manipulation according to described second tables of data；
S3：Described first geometric data object and described second geometric data object are carried out spatial overlay analysis, if closing
And after obtain a geometric object, then described data manipulation do not cause described vector data to be detected geometrical boundary change and
Spatial position change；Otherwise, described data manipulation causes geometrical boundary change or the space of described vector data to be detected
Change in location.
Preferably, also include：
If described first geometric data object and described second geometric data object are carried out spatial overlay analysis, after merging
Obtain at least two geometric objects, then contrast described first geometric data object and the seat of described second geometric data object one by one
Mark sequence, judges the corresponding point of coordinate sequence and the described second geometric data object accordingly of described first geometric data object
The corresponding point of coordinate sequence whether consistent in the deviation of X-direction, and whether deviation in the Y direction consistent；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence consistent and deviation in the Y direction is also consistent in the deviation of X-direction, then judge described data manipulation
Cause the spatial position change of described vector data to be detected, do not cause the geometrical boundary of described vector data to be detected to become
Change；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence X-direction deviation is inconsistent or Y-direction on deviation inconsistent, then judge described data behaviour
Cause geometrical boundary change and the spatial position change of described vector data to be detected.
Preferably, the corresponding daily record of described tables of data includes online daily record and archive log.
Preferably, described data manipulation includes insertion, deletes and update；
If the data manipulation that described tables of data is inserted, described tables of data the data manipulation inserted it
Front tables of data is sky, and corresponding geometric data object is also sky；
If the data manipulation that described tables of data is deleted, described tables of data the data manipulation deleted it
Tables of data afterwards is sky, and corresponding geometric data object is also sky.
Preferably, also include before described step S1：With arrow to be detected in preset time period acquisition spatial database
Whether the related tables of data of amount data and the corresponding daily record of described tables of data, occur Geometrical change to carry out vector data to be detected
It is periodically detected.
On the other hand, present invention also offers the device that in a kind of spatial database, vector data Geometrical change detects, wrap
Include：
Extracting change information module, for obtaining related to vector data to be detected tables of data in spatial database and institute
State the corresponding daily record of tables of data, using log analysis tool, described daily record is parsed, obtain described tables of data and entering line number
According to the second tables of data after the first tables of data data operation before operation；
Parsing module, for using default analytic method, obtaining in described data manipulation according to described first tables of data
The first front geometric data object, obtains the second geometric data pair after described data manipulation according to described second tables of data
As；
Analysis module, for carrying out space overlapping by described first geometric data object and described second geometric data object
Analysis, if obtaining a geometric object after merging, described data manipulation does not cause the geometry of described vector data to be detected
Border change and spatial position change；Otherwise, described data manipulation causes the geometrical boundary change of described vector data to be detected
Change or spatial position change.
Preferably, if described analysis module is additionally operable to described first geometric data object and described second geometric data pair
As carrying out spatial overlay analysis, after merging, obtain at least two geometric objects, then contrast described first geometric data object one by one
With the coordinate sequence of described second geometric data object, judge described first geometric data object the corresponding point of coordinate sequence and
Whether the corresponding point of coordinate sequence of described second geometric data object is consistent in the deviation of X-direction accordingly, and in the Y direction
On deviation whether consistent；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence consistent and deviation in the Y direction is also consistent in the deviation of X-direction, then judge described data manipulation
Cause the spatial position change of described vector data to be detected, do not cause the geometrical boundary of described vector data to be detected to become
Change；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence X-direction deviation is inconsistent or Y-direction on deviation inconsistent, then judge described data behaviour
Cause geometrical boundary change and the spatial position change of described vector data to be detected.
Preferably, the corresponding daily record of described tables of data includes online daily record and archive log.
Preferably, described data manipulation includes insertion, deletes and update；
If the data manipulation that described tables of data is inserted, described tables of data the data manipulation inserted it
Front tables of data is sky, and corresponding geometric data object is also sky；
If the data manipulation that described tables of data is deleted, described tables of data the data manipulation deleted it
Tables of data afterwards is sky, and corresponding geometric data object is also sky.
Preferably, also include cycle detection module, for every preset time period obtain spatial database in to be detected
Whether the related tables of data of vector data and the corresponding daily record of described tables of data, occur Geometrical change to enter vector data to be detected
Line period detects.
In the method and device of vector data Geometrical change detection in the spatial database that the present invention provides, divided using daily record
The method of analysis, to obtain the vector data Geometrical change in spatial database, is parsed by geometric data and relative analyses is to change
Information is extracted, result is classified as do not change, space displacement, border and space displacement all change.The method and dress
Put and existing space data base need not be modified it is only necessary to log enable analysis can achieve vector data change monitoring, both
Can achieve online real-time change detection it is also possible to combine Log backup management, be configured to periodically non real-time detection, according to sky
Between the storage scheme of data the vector data in daily record is parsed, can adapt to the spatial database of different storage modes,
Different geometric data change types are drawn according to detection and analysis, can be to spatial data topological relation, associated traffic data logical sum
Database manipulation behavior is audited, and ensures safety and the logic integrity of data base.
Brief description
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
Have technology description in required use accompanying drawing be briefly described it should be apparent that, drawings in the following description are these
Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also root
Obtain other accompanying drawings according to these accompanying drawings.
Fig. 1 is the flow process of the method for vector data Geometrical change detection in the spatial database that one embodiment of the invention provides
Schematic diagram；
Fig. 2 is the apparatus function group of vector data Geometrical change detection in the spatial database that one embodiment of the invention provides
The structural representation becoming；
Fig. 3 is overlay analysis (merging) schematic diagram that one embodiment of the invention provides；
Fig. 4 is the structure of the device of vector data Geometrical change detection in the spatial database that one embodiment of the invention provides
Block diagram.
Specific embodiment
Purpose, technical scheme and advantage for making the embodiment of the present invention are clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described it is clear that described embodiment is
The a part of embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment being obtained under the premise of not making creative work, broadly falls into the scope of protection of the invention.
Fig. 1 is that the flow process of the method for vector data Geometrical change detection in the spatial database that the present embodiment provides is illustrated
Figure.Include referring to Fig. 1 the method：
S1：Obtain the tables of data related to vector data to be detected and described tables of data corresponding day in spatial database
Will, is parsed to described daily record using log analysis tool, obtains described tables of data and is carrying out before data manipulation first
The second tables of data after the operation of tables of data data；
S2：Using default analytic method, obtain more than the first before described data manipulation according to described first tables of data
What data object, obtains the second geometric data object after described data manipulation according to described second tables of data；
S3：Described first geometric data object and described second geometric data object are carried out spatial overlay analysis, if closing
And after obtain a geometric object, then described data manipulation do not cause described vector data to be detected geometrical boundary change and
Spatial position change；Otherwise, described data manipulation causes geometrical boundary change or the space of described vector data to be detected
Change in location.
It should be noted that in relational database, storage format is long binary system, ST_Geometry due to spatial data
(ESRI) or the form such as SDO_Geometry (Oracle Spatial), need the data being provided using its respective stored scheme
Data is resolved to geometric data object by read method and program.
In the method for vector data Geometrical change detection in the spatial database that the present embodiment provides, using log analysis
Method, to obtain the vector data Geometrical change in spatial database, is parsed by geometric data and relative analyses is to change information
Extracted, result is classified as do not change, space displacement, border and space displacement all change.The method need not be to existing
There is spatial database to modify it is only necessary to log enable analysis can achieve vector data change monitoring, both can achieve online
Real-time change detection, it is also possible to combine Log backup management, is configured to periodically non real-time detection, depositing according to spatial data
Storage scheme parses to the vector data in daily record, can adapt to the spatial database of different storage modes, according to detection point
Analysis draws different geometric data change types, can be to spatial data topological relation, associated traffic data logical sum database manipulation
Behavior is audited, and ensures safety and the logic integrity of data base.
Further, the method also includes：
If described first geometric data object and described second geometric data object are carried out spatial overlay analysis, after merging
Obtain at least two geometric objects, then contrast described first geometric data object and the seat of described second geometric data object one by one
Mark sequence, judges the corresponding point of coordinate sequence and the described second geometric data object accordingly of described first geometric data object
The corresponding point of coordinate sequence whether consistent in the deviation of X-direction, and whether deviation in the Y direction consistent；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence consistent and deviation in the Y direction is also consistent in the deviation of X-direction, then judge described data manipulation
Cause the spatial position change of described vector data to be detected, do not cause the geometrical boundary of described vector data to be detected to become
Change；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence X-direction deviation is inconsistent or Y-direction on deviation inconsistent, then judge described data behaviour
Cause geometrical boundary change and the spatial position change of described vector data to be detected.
It should be noted that when identifying whether to occur geometrical boundary change and spatial position change, being contrast more than the first
Whether what corresponding point of data object and the corresponding point of the second geometric data object all there occurs that identical moves, and that is, every bit is
No identical change (having identical Δ X) has been carried out on X-axis, and identical change also all carried out on Y-axis (there is phase
Same Δ Y), if so, then judge that described data manipulation causes the spatial position change of described vector data to be detected, do not draw
Play the geometrical boundary change of described vector data to be detected, otherwise, it is determined that described data manipulation causes described vector to be detected
The geometrical boundary change of data and spatial position change.
As one kind more specifically embodiment, referring to Fig. 2, carry out spatial database change-detection first, then carry again
Take change information.
During carrying out spatial database change-detection, first, vector data data operation row to be measured will be set
For specifically：
Some vector datas are stored, generally only related to business vector data just needs to carry out in spatial database
Change-detection is it is therefore desirable to set vector data to be detected.
Vector data shows as multiple tables of data in physical store, is entered by identical dataset name between multiple tables
Row association, can carry out uniqueness association to data table related by vector data title, therefore setting vector data to be detected
Shi Zhiding vector data title to be detected.
In data base, the operation to tables of data can be divided into insertion, updates and delete three types, each type of data
Operation has corresponded to different vector data Geometrical change types.Update shows as newly-increased spatial data pair in vector data
As updating operation and showing as spatial data object change, deletion action shows as spatial data object and disappears.According to service operation
Needs, setting which data manipulation to vector data to be detected needs detected, and the data manipulation behavior not being detected is not
Need to execute follow-up change detection and analysis.
Second, carry out daily record on-line analysis, particular because Large-scale Relational Database is generally according to first writing daily record
The mode of write data carries out data manipulation afterwards, so have recorded complete data operation information in database journal, to ensure
The integrity of operation and restorability, therefore whole change informations of this data base of daily record real time record.
Data base management system provides corresponding log analysis tool (LogMiner of such as Oracle) and comes to its day
Will is read out and parses, as long as therefore starting log analytical tool carries out real time parsing to online/archive log, you can obtain
Database manipulation message, including to the insertion of total data table, renewal and deletion action.
3rd, extract object variations data, further, in the method for the invention, the corresponding daily record bag of described tables of data
Include online daily record and archive log.
Specifically, to any one data table handling, daily record can record REDO SQL and UNDO SQL.REDO SQL is
Again realize the sentence of this operation, which represent the data mode after data manipulation, UNDO SQL is the sentence cancelling this operation,
Represent the data mode before data manipulation, therefore in log recording, contain the complete of tables of data latter two state before operation
Information.
In the database manipulation message that log analysis obtain, search for the tables of data related to vector data to be detected and phase
Answer the record that data manipulation is consistent, dumped in delta data table, provide basic data for extracting change information.
Due to the indispensable mechanism of write daily record inherently Database Systems, therefore this programme will not come very to data library tape
Big performance consumption.If necessary to concentrate analysis archive log in certain period of time, need to consume certain computing resource, permissible
It is analyzed by other main frames are filed in daily record, realizing systematic entirety can optimize.
During extracting change information, first, spatial data parsing to be carried out, specifically, with simple types data
Directly can be changed by type and obtain data difference, spatial data storage format in relational database is long binary system, ST_
The forms such as Geometry (ESRI) or SDO_Geometry (Oracle Spatial), need to be carried using its respective stored scheme
For method for reading data and program, data is resolved to geometric data object (point, line or face).Can from daily record UNDO data
Extract geometry data object before change, can extract out geometric data object after change from daily record REDO data.
It is sky for geometry data object before update change, for geometric data object after deletion action change be
Sky, updates two geometric data objects before and after operation can obtain change.
Second, parameter extraction to be changed, specifically, the change of insertion and deletion action generation is directly designated as geometry pair
As increasing newly and eliminating.
The change updating operation generation needs the geometric data object before and after change is analyzed, and realizes to change
The classification of type：
(1) two geometric data objects are carried out spatial overlay analysis, using merging method, obtain output result (as Fig. 3
Shown, INPUT is that the geometric data object of input corresponds to, and OUTPUT is the geometric object of output).When output data is several for one
During what object, represent to update and do not cause geometrical boundary change and spatial position change；When output data is multiple geometric objects
When, represent that geometrical boundary or locus there occurs change.
(2) when previous step output result is latter event, contrast geometric data object coordinates sequence one by one.If sat
There is consistent deviation in mark, represent that geometric data object there occurs translation, boundary shape is not changed in the x-direction and the z-direction；No
Then, represent that geometric data object all there occurs change on border and locus.
Further, described data manipulation includes insertion, deletes and update；
If the data manipulation that described tables of data is inserted, described tables of data the data manipulation inserted it
Front tables of data is sky, and corresponding geometric data object is also sky；
If the data manipulation that described tables of data is deleted, described tables of data the data manipulation deleted it
Tables of data afterwards is sky, and corresponding geometric data object is also sky.
Further, also include before described step S1：Every preset time period obtain spatial database in to be detected
Whether the related tables of data of vector data and the corresponding daily record of described tables of data, occur Geometrical change to enter vector data to be detected
Line period detects.
On the other hand, Fig. 4 is the device of vector data Geometrical change detection in the spatial database that the present embodiment provides
Structured flowchart, referring to Fig. 4, in this spatial database, the device 20 of vector data Geometrical change detection includes：
Extracting change information module 21, for obtain related to vector data to be detected tables of data in spatial database and
The corresponding daily record of described tables of data, is parsed to described daily record using log analysis tool, obtains described tables of data and carrying out
The second tables of data after the first tables of data data operation before data manipulation；
Parsing module 22, for using default analytic method, obtaining grasping in described data according to described first tables of data
The first geometric data object before work, obtains the second geometric data pair after described data manipulation according to described second tables of data
As；
Analysis module 23, for carrying out space and folding described first geometric data object and described second geometric data object
Bonus point is analysed, if obtaining a geometric object after merging, described data manipulation does not cause the several of described vector data to be detected
What border change and spatial position change；Otherwise, described data manipulation causes the geometrical boundary of described vector data to be detected
Change or spatial position change.
In the device of vector data Geometrical change detection in the spatial database that the present invention provides, using the side of log analysis
Method, to obtain the vector data Geometrical change in spatial database, is entered to change information by geometric data parsing and relative analyses
Row extracts, result is classified as do not change, space displacement, border and space displacement all change.This device need not be to existing
Spatial database is modified it is only necessary to log enable analysis can achieve vector data change monitoring, both can achieve real online
When change-detection it is also possible to combine Log backup management, be configured to periodically non real-time detection, according to spatial storage methods
Scheme parses to the vector data in daily record, can adapt to the spatial database of different storage modes, according to detection and analysis
Draw different geometric data change types, can be to spatial data topological relation, associated traffic data logical sum database manipulation row
For being audited, ensure safety and the logic integrity of data base.
Further, if described analysis module is additionally operable to described first geometric data object and described second geometric data
Object carries out spatial overlay analysis, obtains at least two geometric objects after merging, then contrast described first geometric data pair one by one
As the coordinate sequence with described second geometric data object, judge the corresponding point of coordinate sequence of described first geometric data object
Whether the corresponding point of coordinate sequence of described second geometric data object is consistent in the deviation of X-direction accordingly, and in Y side
Whether deviation upwards is consistent；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence consistent and deviation in the Y direction is also consistent in the deviation of X-direction, then judge described data manipulation
Cause the spatial position change of described vector data to be detected, do not cause the geometrical boundary of described vector data to be detected to become
Change；
If the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The corresponding point of coordinate sequence X-direction deviation is inconsistent or Y-direction on deviation inconsistent, then judge described data behaviour
Cause geometrical boundary change and the spatial position change of described vector data to be detected.
Further, the corresponding daily record of described tables of data includes online daily record and archive log.
Further, described data manipulation includes insertion, deletes and update；
If the data manipulation that described tables of data is inserted, described tables of data the data manipulation inserted it
Front tables of data is sky, and corresponding geometric data object is also sky；
If the data manipulation that described tables of data is deleted, described tables of data the data manipulation deleted it
Tables of data afterwards is sky, and corresponding geometric data object is also sky.
Further, also include cycle detection module, for every preset time period obtain spatial database in to be checked
Survey the related tables of data of vector data and the corresponding daily record of described tables of data, whether Geometrical change is occurred to vector data to be detected
It is periodically detected.
The present invention to obtain the vector data Geometrical change in spatial database using the method for log analysis, by geometry
Data parsing and relative analyses are extracted to change information, and the real-time monitoring data realizing vector data Geometrical change obtains
Take, complete the analysis of delta data.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, made any repair
Change, equivalent, improvement etc., should be included within the scope of the present invention.
Claims (10)
1. a kind of method that in spatial database, vector data Geometrical change detects is it is characterised in that include：
S1：Obtain the tables of data related to vector data to be detected and the corresponding daily record of described tables of data in spatial database, adopt
With log analysis tool, described daily record is parsed, obtain described tables of data and carrying out the first tables of data before data manipulation
The second tables of data after data operation；
S2：Using default analytic method, obtain the first geometry number before described data manipulation according to described first tables of data
According to object, obtain the second geometric data object after described data manipulation according to described second tables of data；
S3：Described first geometric data object and described second geometric data object are carried out spatial overlay analysis, if after merging
Obtain a geometric object, then described data manipulation does not cause the geometrical boundary of described vector data to be detected to change and space
Change in location；Otherwise, described data manipulation causes geometrical boundary change or the locus of described vector data to be detected
Change.
2. according to the method in claim 1 it is characterised in that also including：
If described first geometric data object and described second geometric data object are carried out spatial overlay analysis, obtain after merging
At least two geometric objects, then contrast described first geometric data object and the coordinate sequence of described second geometric data object one by one
Row, judge the corresponding point of coordinate sequence of described first geometric data object and the seat of described second geometric data object accordingly
Whether the mark corresponding point of sequence is consistent in the deviation of X-direction, and whether deviation in the Y direction is consistent；
If the seat of the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
Unanimously and deviation in the Y direction is also consistent in the deviation of X-direction for the mark corresponding point of sequence, then judge that described data manipulation causes
The spatial position change of described vector data to be detected, does not cause the geometrical boundary of described vector data to be detected to change；
If the seat of the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The mark corresponding point of sequence X-direction deviation is inconsistent or Y-direction on deviation inconsistent, then judge that described data manipulation is drawn
Geometrical boundary change and the spatial position change of described vector data to be detected are played.
3. according to the method in claim 2 it is characterised in that the corresponding daily record of described tables of data includes online daily record and filing
Daily record.
4. according to the method in claim 2 it is characterised in that described data manipulation includes insertion, deletes and update；
If the data manipulation that described tables of data is inserted, described tables of data is before the data manipulation inserted
Tables of data is sky, and corresponding geometric data object is also sky；
If the data manipulation that described tables of data is deleted, described tables of data is after the data manipulation deleted
Tables of data is sky, and corresponding geometric data object is also sky.
5. the method according to any one of claim 1-4 is it is characterised in that also include before described step S1：Every
Preset time period obtains the tables of data related to vector data to be detected and the corresponding daily record of described tables of data in spatial database,
Geometrical change whether is occurred to be periodically detected vector data to be detected.
6. the device that in a kind of spatial database, vector data Geometrical change detects is it is characterised in that include：
Extracting change information module, for obtaining related to vector data to be detected tables of data in spatial database and described number
According to the corresponding daily record of table, using log analysis tool, described daily record is parsed, obtain described tables of data and carrying out data behaviour
The second tables of data after the first tables of data data operation before work；
Parsing module, for using default analytic method, obtaining before described data manipulation according to described first tables of data
First geometric data object, obtains the second geometric data object after described data manipulation according to described second tables of data；
Analysis module, for carrying out space overlapping and dividing described first geometric data object and described second geometric data object
Analysis, if obtaining a geometric object after merging, described data manipulation does not cause the geometrical edge of described vector data to be detected
Boundary's change and spatial position change；Otherwise, described data manipulation causes the geometrical boundary change of described vector data to be detected
Or spatial position change.
If 7. according to the device in claim 6 it is characterised in that described analysis module is additionally operable to described first geometric data
Object and described second geometric data object carry out spatial overlay analysis, obtain at least two geometric objects, then one by one after merging
Contrast described first geometric data object and the coordinate sequence of described second geometric data object, judge described first geometric data
The corresponding point of coordinate sequence of the corresponding point of coordinate sequence of object and accordingly described second geometric data object is in X-direction
Whether deviation is consistent, and whether deviation in the Y direction is consistent；
If the seat of the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
Unanimously and deviation in the Y direction is also consistent in the deviation of X-direction for the mark corresponding point of sequence, then judge that described data manipulation causes
The spatial position change of described vector data to be detected, does not cause the geometrical boundary of described vector data to be detected to change；
If the seat of the corresponding point of coordinate sequence of described first geometric data object and accordingly described second geometric data object
The mark corresponding point of sequence X-direction deviation is inconsistent or Y-direction on deviation inconsistent, then judge that described data manipulation is drawn
Geometrical boundary change and the spatial position change of described vector data to be detected are played.
8. according to the device in claim 7 it is characterised in that the corresponding daily record of described tables of data includes online daily record and filing
Daily record.
9. according to the device in claim 7 it is characterised in that described data manipulation includes insertion, deletes and update；
If the data manipulation that described tables of data is inserted, described tables of data is before the data manipulation inserted
Tables of data is sky, and corresponding geometric data object is also sky；
If the data manipulation that described tables of data is deleted, described tables of data is after the data manipulation deleted
Tables of data is sky, and corresponding geometric data object is also sky.
10. the device according to any one of claim 6-9 is it is characterised in that also include cycle detection module, for every
Obtain the tables of data related to vector data to be detected and described tables of data corresponding day in spatial database every preset time period
Whether will, occur Geometrical change to be periodically detected vector data to be detected.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610757048.6A CN106407292B (en) | 2016-08-29 | 2016-08-29 | The method and device of vector data Geometrical change detection in a kind of spatial database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610757048.6A CN106407292B (en) | 2016-08-29 | 2016-08-29 | The method and device of vector data Geometrical change detection in a kind of spatial database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106407292A true CN106407292A (en) | 2017-02-15 |
| CN106407292B CN106407292B (en) | 2019-08-13 |
Family
ID=58002511
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610757048.6A Active CN106407292B (en) | 2016-08-29 | 2016-08-29 | The method and device of vector data Geometrical change detection in a kind of spatial database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106407292B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107944036A (en) * | 2017-12-13 | 2018-04-20 | 美林数据技术股份有限公司 | A kind of acquisition methods of collection of illustrative plates variation |
| CN112613892A (en) * | 2020-12-25 | 2021-04-06 | 北京知因智慧科技有限公司 | Data processing method and device based on business system and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101661497A (en) * | 2009-09-10 | 2010-03-03 | 北京农业信息技术研究中心 | Remote sensing land use change detection method and system thereof |
| US20100092045A1 (en) * | 2008-10-15 | 2010-04-15 | The Boeing Company | System and method for airport mapping database automatic change detection |
| CN105630988A (en) * | 2015-12-23 | 2016-06-01 | 中山大学 | Method and system for rapidly detecting space data changes and updating data |
-
2016
- 2016-08-29 CN CN201610757048.6A patent/CN106407292B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100092045A1 (en) * | 2008-10-15 | 2010-04-15 | The Boeing Company | System and method for airport mapping database automatic change detection |
| CN101661497A (en) * | 2009-09-10 | 2010-03-03 | 北京农业信息技术研究中心 | Remote sensing land use change detection method and system thereof |
| CN105630988A (en) * | 2015-12-23 | 2016-06-01 | 中山大学 | Method and system for rapidly detecting space data changes and updating data |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107944036A (en) * | 2017-12-13 | 2018-04-20 | 美林数据技术股份有限公司 | A kind of acquisition methods of collection of illustrative plates variation |
| CN107944036B (en) * | 2017-12-13 | 2021-12-24 | 美林数据技术股份有限公司 | Method for acquiring map change difference |
| CN112613892A (en) * | 2020-12-25 | 2021-04-06 | 北京知因智慧科技有限公司 | Data processing method and device based on business system and electronic equipment |
| CN112613892B (en) * | 2020-12-25 | 2024-03-15 | 北京知因智慧科技有限公司 | Data processing method and device based on service system and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106407292B (en) | 2019-08-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108959400B (en) | Bank system historical data cleaning method and device | |
| US5197001A (en) | Bill of material and project network processing | |
| CN107657049B (en) | Data processing method based on data warehouse | |
| US11868330B2 (en) | Method for indexing data in storage engine and related apparatus | |
| CN104317624B (en) | Data assembly method based on plug-in unit treatment | |
| CN103617277A (en) | Method for restoring data table content deleted mistakenly | |
| KR20220064016A (en) | Method for extracting construction safety accident based data mining using big data | |
| CN106155838A (en) | A kind of database back-up data restoration methods and device | |
| CN109298978A (en) | A kind of restoration methods and system of the data-base cluster of designated position | |
| CN108153804A (en) | A kind of metadata daily record update method of symmetric distributed file system | |
| CN115858513A (en) | Data governance method, data governance device, computer equipment and storage medium | |
| CN106155832A (en) | Method, device and the Android device that a kind of data are recovered | |
| CN106802928B (en) | Power grid historical data management method and system | |
| CN106407292A (en) | Method and device for detecting geometric variation of vector data in spatial database | |
| US20180129711A1 (en) | Transaction-Based Refresh of a Long Database Transaction's Workspace | |
| US20160123120A1 (en) | Systems, methods, and computer medium to optimize storage for hydrocarbon reservoir simulation | |
| KR20070099149A (en) | Method of automatically loading meta data in meta data repository | |
| CN114564737A (en) | Method for defining upgrade maintenance authority based on configuration file and variable | |
| Zeleny et al. | Cluster-based Page Segmentation-a fast and precise method for web page pre-processing | |
| Alotaibi | ETDC: an efficient technique to cleanse data in the data warehouse | |
| Li et al. | Efficient entity resolution based on sequence rules | |
| CN115952160B (en) | Data checking method | |
| CN107145601A (en) | A kind of efficient adduction relationship finds algorithm | |
| Kvet et al. | Data Management in Hierarchical Database-Branches Notification | |
| CN106294626A (en) | A kind of method that parallel playback file system redoes log |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |