Geographic entity data space-time integrated modeling method, system, equipment and medium

Abstract

The invention discloses a geographic entity data space-time integrated modeling method, system and device and a medium. The method comprises the steps that S1, geographic entity primitives, attributes and relation table structures are separately designed; s2, designing a geographic entity database structure space-time table; s3, geographic entity attribute JSON large field storage is carried out; s4, materialized view integrated geographic entity data organization; s5, updating the historical version record of the geographic entity data; and S6, geographic entity data version snapshot organization. According to the method, a tense database management mode is designed, geographic entity space identity codes serve as a bridge, space and time changes, attribute information changes and entity semantic relation changes experienced by a geographic entity from birth to extinction are recorded according to a time machine concept, and a database materialized view mode and time sequence nodes serve as references; and forming a series of space-time object version snapshots of the geographic entity, thereby realizing space-time integrated fusion storage of geographic entity attributes, primitives and semantic relationship data.

Description

Technical Field

[0001] The present invention relates to the technical field of geographic entity data base construction, and particularly relates to a method, system, device and medium for modeling geographic entity data. Background Art

[0002] A geographic entity is a geographic object that occupies a certain and continuous spatial position and range in the real world and has the same attribute or complete function alone. A geographic entity can be regarded as a management object, which can conveniently realize the association of geographic information with social attribute information such as society, economy, and natural resources. It is a carrier for the association of various types of information, realizes the fusion of multi-source spatio-temporal data, and better directly supports specific application scenarios. A geographic entity includes three parts according to the data content: entity primitives, entity attributes, and entity relationship data.

[0003] Since the concept of geographic entities was proposed, many countries have carried out research, experiments and applications on geographic entities and the construction of geographic entity databases. Many domestic related scholars have also explored the data standards and production models of geographic entities, and have successively issued a number of relevant standards, specifications and technical outlines for the construction of geographic entities and geographic entity databases, and have carried out practices and applications in new basic surveying and mapping pilot projects in many places across the country, forming a number of geographic entity database achievements.

[0004] When the traditional method of hierarchical database construction of geographic information data with scale as the core and traditional layer-by-layer storage method are applied to the process of storing, updating and managing geographic entity data, there are problems such as the isolation of geographic entity data versions, the fragmentation of the spatio-temporal characteristics of geographic entity data, and the inflation of maintenance volume caused by too many layers, and it cannot adapt to the data characteristics of entity, semantics, multi-temporal and multi-form of geographic entity data. Summary of the Invention

[0005] The purpose of the present invention is to provide a spatio-temporal integration modeling method for geographic entity data, which can solve at least one of the above technical problems.

[0006] The present invention also provides a system, device and computer-readable storage medium based on the above spatio-temporal integration modeling method for geographic entity data.

[0007] According to the first aspect of the present invention, there is provided a spatio-temporal integration modeling method for geographic entity data, which includes: S1. Separate design of the structure of geographic entity primitives, attributes, and relationship tables: Separate the structure of the geographic entity primitive data, attribute data, and relationship data in the geographic entity data, design different database tables correspondingly, store the geographic entity primitive data, attribute data, and relationship data into different database tables respectively, and use the geographic entity spatial identity code for data association; S2. Design of the spatio-temporal table for the geographical entity database structure: Design the historical version records for each database table. Add a timestamp field to each table to record the history of data changes in the database. Adopt the method of not overwriting the original data to form a spatio-temporal table. S3. Storage of geographical entity attribute JSON large fields: Adopt the design of JSON large fields to store geographical entity attribute data. Convert the variable-length attribute field structures of different classifications of geographical entities into fixed-structure attribute field structures, so as to unify the design of multiple geographical entity attribute tables with different table structures of different classifications into a spatio-temporal geographical entity attribute table. S4. Materialized view Figure 1 Integrated organization of geographical entity data: Adopt the database materialized view organization method. Use the geographical entity spatial identity code as the primary key to associate the geographical entity primitive data, attribute data, and relationship data to form a complete geographical entity. Organize the geographical entity data of a specific version at a certain time node in the timestamp sequence, so as to form a complete geographical entity data object version at a specific time node. S5. Update of the historical version records of geographical entity data: The update of the historical version records of geographical entity data adopts the new addition without overwriting mode. Add the new version data and the current timestamp to the relevant database tables designed separately, so as to form multiple time series versions of geographical entity data sorted in timestamp order, with the geographical entity spatial identity code as the main line, forming a geographical entity data pool. S6. Organization of geographical entity data version snapshots: Based on the geographical entity data pool, design a snapshot organization mode. Based on this snapshot organization mode, geographical entity data snapshot products at a specific time node or in a time-sequential version can be formed according to time rules.

[0008] According to the spatio-temporal integration modeling method of geographical entity data, in step S6, the snapshot organization mode designed based on the geographical entity data pool includes: using the organization method of the database materialized view, according to the target time node, find the geographical entity data version with the closest distance to the target time node for the same geographical entity spatial identity code in the geographical entity data pool, so as to assemble a batch of geographical entity data into the geographical entity data product of this time node version.

[0009] According to the spatio-temporal integration modeling method of geographical entity data, in step S1, the geographical entity primitive data includes geographical entity point primitive data, geographical entity line primitive data, geographical entity surface primitive data, geographical entity volume primitive data, and geographical entity model data.

[0010] According to the spatio-temporal integration modeling method for geographical entity data, in step S1, different database tables are correspondingly designed, including a geographical entity table, a geographical entity attribute table, a geographical entity surface graphic element table, a geographical entity point graphic element table, a geographical entity line graphic element table, a geographical entity solid graphic element table, a geographical entity model table, and a geographical entity semantic relationship table.

[0011] According to the second aspect of the present invention, there is provided a spatio-temporal integration modeling system for geographical entity data, including a processor and a memory. The memory stores multiple instructions. The processor loads the instructions from the memory to execute the spatio-temporal integration modeling method for geographical entity data according to any one of claims 1-4.

[0012] According to the third aspect of the present invention, there is provided an electronic device, including a memory, a processor, and a computer program stored on the memory. The processor executes the computer program to implement the steps of the spatio-temporal integration modeling method for geographical entity data according to any one of claims 1-4.

[0013] According to the fourth aspect of the present invention, there is provided a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the spatio-temporal integration modeling method for geographical entity data according to any one of claims 1-4 are implemented.

[0014] Beneficial effects: In view of the problems of storage, update, and management of geographical entity data, the present invention designs a temporal database management mode. Taking the spatial identity coding of geographical entities as a bridge, and using the concept of a time machine to record the spatial and temporal changes, attribute information changes, and entity semantic relationship changes experienced by a geographical entity from its birth to its demise. Based on the database materialized view and time series nodes, a series of spatio-temporal object version snapshots of geographical entities are formed, so as to realize the spatio-temporal integration storage of geographical entity attribute, graphic element, and semantic relationship data, and can solve problems such as the isolation of geographical entity data versions and the fragmentation of the spatio-temporal characteristics of geographical entity data, and can adapt to the data characteristics of geographical entity data such as materialization, semanticization, multi-temporality, and multi-morphology.

[0015] Additional aspects and advantages of the present invention will be given in part in the following description, become apparent in part from the following description, or be understood through the practice of the present invention. Description of the Drawings

[0016] The present invention will be further described below with reference to the drawings and embodiments: Figure 1 Schematic diagram for the separated design of the geographical entity graphic element, attribute, and relationship table structures; Figure 2 Schematic diagram for the storage of large JSON fields of geographical entity attributes; Figure 3 For the materialized view Figure 1Schematic diagram of integrated geographical entity data organization; Figure 4 Schematic diagram for updating historical version records of geographical entity data; Figure 5 Schematic diagram of the organization mode of geographical entity data version snapshots. Specific implementation manners

[0017] This part will describe in detail the specific embodiments of the present invention. The preferred embodiments of the present invention are shown in the drawings. The function of the drawings is to supplement the description of the text part of the specification, enabling people to intuitively and vividly understand each technical feature and the overall technical solution of the present invention. However, it should not be construed as a limitation on the protection scope of the present invention.

[0018] Refer to Figures 1-5 , the spatio-temporal integrated modeling method for geographical entity data in the embodiments of the present invention includes the following steps: S1. Separate design of the structure of geographical entity graphic elements, attributes, and relationship tables: Separate the structure of geographical entity graphic element data, attribute data, and relationship data in geographical entity data, design different database tables correspondingly, store the geographical entity graphic element data, attribute data, and relationship data into different database tables respectively, and use the geographical entity spatial identity code for data association; see Figure 1 .

[0019] S2. Design of spatio-temporal tables for the geographical entity database structure: Design historical version records for each separated database table involved in the geographical entity database. Add a timestamp field to each table to record the data change history in the database instead of directly overwriting the original data, thereby forming spatio-temporal tables; see Figure 1 .

[0020] S3. Storage of geographical entity attributes in JSON large fields: Use JSON large fields to design and store geographical entity attribute data, convert the variable-length attribute field structures of different classifications of geographical entities into fixed-structure attribute field structures, so as to uniformly design multiple geographical entity attribute tables with different table structures for different classifications into a spatio-temporal geographical entity attribute table; see Figure 2 .

[0021] S4. Materialized view Figure 1 Integrated geographical entity data organization: Adopt the database materialized view organization method, use the geographical entity spatial identity code as the primary key to associate geographical entity graphic elements, attributes, and relationship data to form a complete geographical entity, and organize the geographical entity data of a specific version at a certain time node in the timestamp sequence, thereby forming a complete geographical entity data object version at a specific time node; seeFigure 3 。

[0022] S5. Update of the historical version record of geographic entity data: The update mode of the historical version record of geographic entity data is new addition without overwriting, that is, the old data is not deleted, and the update is in the new addition mode. The new version data and the current timestamp are added to the relevant database tables designed separately for geographic entity data, so as to form multiple time-series versions of geographic entity data sorted in timestamp order with the spatial identity code of geographic entities as the main line, and finally form a geographic entity data pool in the form of a kind of time machine for geographic entity data; see Figure 4 。

[0023] S6. Snapshot organization of geographic entity data versions: Based on the geographic entity data pool, a snapshot organization mode is designed. Based on this snapshot organization mode, snapshot products of geographic entity data at a certain specific time node or in a time-series manner (daily, monthly, annually) can be formed according to time rules.

[0024] Among them, in step S6, the snapshot organization mode designed based on the geographic entity data pool includes: using the organization method of database materialized views, and according to the target time node, finding the geographic entity data version with the closest distance to the target time node for the same geographic entity spatial identity code in the geographic entity data pool, so as to assemble this batch of geographic entity data into the geographic entity data product of this time node version.

[0025] In step S1, the geographic entity primitive data includes geographic entity point primitive data, geographic entity line primitive data, geographic entity surface primitive data, geographic entity solid primitive data, and geographic entity model data. Correspondingly, different database tables are designed, including geographic entity table, geographic entity attribute table, geographic entity surface primitive table, geographic entity point primitive table, geographic entity line primitive table, geographic entity solid primitive table, geographic entity model table, and geographic entity semantic relationship table.

[0026] The present invention also provides a spatio-temporal integrated modeling system for geographic entity data, which includes a processor and a memory. The memory stores multiple instructions; the processor loads the instructions from the memory to execute the spatio-temporal integrated modeling method for geographic entity data as described above.

[0027] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored on the memory. The processor executes the computer program to implement the steps of the spatio-temporal integrated modeling method for geographic entity data as described above.

[0028] The present invention also provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the spatio-temporal integrated modeling method for geographic entity data as described above are implemented.

[0029] Although the methods described above have been illustrated and described as a series of acts for simplicity of explanation, it should be understood and appreciated that the methods are not limited by the order of the acts, because in accordance with one or more embodiments, some acts may occur in a different order and / or concurrently with other acts not illustrated and described herein or other acts that would be understood by those skilled in the art. Those skilled in the art will further appreciate that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the embodiments disclosed herein can be implemented as electronic hardware, computer software, or a combination of both. To clearly illustrate this interchangeability of hardware and software, the various illustrative components, blocks, modules, circuits, and steps have been described above in terms of their functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the overall system. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention. The various illustrative logical blocks, modules, and circuits described in connection with the embodiments disclosed herein can be implemented using a general purpose processor, a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or any combination thereof designed to perform the functions described herein. A general purpose processor may be a microprocessor, but in the alternative, the processor may be any conventional processor, controller, microcontroller, or state machine. The processor may also be implemented as a combination of computing devices, such as a combination of a DSP and a microprocessor, multiple microprocessors, one or more microprocessors in conjunction with a DSP core, or any other such configuration. The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of both. The software module may reside in RAM memory, flash memory, ROM memory, EPROM memory, EEPROM memory, registers, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art. An exemplary storage medium is coupled to the processor such that the processor can read from, and write to, the storage medium. In the alternative, the storage medium may be integral to the processor. The processor and the storage medium may reside in an ASIC. The ASIC may reside in a user terminal. In the alternative, the processor and the storage medium may reside as discrete components in a user terminal. In one or more exemplary embodiments, the described functionality may be implemented in hardware, software, firmware, or any combination thereof. If implemented in software as a computer program product, the functions may be stored on or transmitted via a computer readable medium as one or more instructions or code.Computer-readable media includes both computer storage media and communication media, which includes any medium that facilitates the transfer of a computer program from one place to another. The storage media can be any available media that can be accessed by a computer. By way of example and not limitation, such computer-readable media can include RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer. Any connection is also properly termed a computer-readable media. For example, if software is transferred from a web site, server, or other remote source using coaxial cable, fiber optic cable, twisted pair, Digital Subscriber Line (DSL), or wireless technologies such as infrared, radio, and microwave, then the coaxial cable, fiber optic cable, twisted pair, DSL, or wireless technologies such as infrared, radio, and microwave are included in the definition of the medium. As used herein, disk and disc include compact disc (CD), laser disc, optical disc, digital versatile disc (DVD), floppy disk and Blu-ray disc, where disk typically reproduces data magnetically, while disc reproduces data optically with a laser. Combinations of the above should also be included within the scope of computer-readable media.

[0030] The embodiments of the present invention have been described in detail above in conjunction with the accompanying drawings. However, the present invention is not limited to the above embodiments. Within the knowledge of those of ordinary skill in the art in the said technical field, various changes can be made without departing from the spirit of the present invention.

Claims

1. A spatial-temporal integrated modeling method for geographic entity data, characterized in that: include: S1. Separate design of geographic entity primitives, attributes, and relationship table structures: Separate the geographic entity metadata, attribute data, and relationship data in the geographic entity data, design different database tables accordingly, store the geographic entity metadata, attribute data, and relationship data in different database tables, and use the geographic entity spatial identity coding to associate the data; S2. Design of spatial-temporal table of geographic entity database structure: Design a historical version record for each database table. Add a timestamp field to each table to record the data change history in the database without overwriting the original data, thus forming a spatiotemporal table. S3, geographic entity attribute JSON large field storage: The JSON large field is used to design and store geographic entity attribute data, and the indefinite-length attribute field structure of different categories of geographic entities is converted into a fixed-structure attribute field structure, so that multiple geographic entity attribute tables with different table structures of different categories can be unified into a spatiotemporal geographic entity attribute table; S4. Materialized view integrated geographic entity data organization: The database materialized view organization method is adopted, and the geographic entity spatial identity code is used as the primary key to associate the geographic entity metadata, attribute data and relationship data to form a complete geographic entity, and the geographic entity data is organized into a specific version at a certain time node in the timestamp sequence, thereby forming a complete geographic entity data object version at a specific time node; S5. Update of historical version records of geographic entity data: The update of historical version records of geographic entity data adopts the mode of adding without overwriting, adding the new version data and the current timestamp to the related database table with separate design, thus forming multiple time series versions of geographic entity data sorted in timestamp order with geographic entity spatial identity coding as the main line, forming a geographic entity data pool; S6. Geographic entity data version snapshot organization: A snapshot organization model is designed based on the geographic entity data pool. Based on this snapshot organization model, a geographic entity data snapshot product at a specific time node or a time-series version can be formed according to time rules.

2. The spatial-temporal integrated modeling method for geographic entity data according to claim 1, characterized in that: In step S6, designing a snapshot organization mode based on the geographic entity data pool includes: By utilizing the organization method of database materialized views, according to the target time node, a geographic entity data version with the same geographic entity spatial identity code closest to the target time node is found in the geographic entity data pool, so as to assemble a batch of geographic entity data into the geographic entity data product of the time node version.

3. The spatial-temporal integrated modeling method for geographic entity data according to claim 1, characterized in that: In step S1, the geographic entity metadata includes geographic entity point metadata, geographic entity line metadata, geographic entity surface metadata, geographic entity body metadata and geographic entity model data.

4. The spatial-temporal integrated modeling method for geographic entity data according to claim 3, characterized in that: In step S1, different database tables are designed correspondingly, including a geographic entity table, a geographic entity attribute table, a geographic entity surface primitive table, a geographic entity point primitive table, a geographic entity line primitive table, a geographic entity body primitive table, a geographic entity model table and a geographic entity semantic relationship table.

5. The spatial and temporal integrated modeling system for geographic entity data is characterized by: It comprises a processor and a memory, wherein the memory stores a plurality of instructions; the processor loads instructions from the memory to execute the spatial-temporal integrated modeling method for geographic entity data as described in any one of claims 1-4.

6. An electronic device comprising a memory, a processor and a computer program stored in the memory, characterized in that: The processor executes the computer program to implement the steps of the method for spatiotemporal integrated modeling of geographic entity data as described in any one of claims 1-4.

7. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method for spatiotemporal integrated modeling of geographic entity data described in any one of claims 1 to 4 are implemented.

Images