Spatio-temporal data indexing method in non-relational database

A spatiotemporal data and database technology, applied in the database field, can solve the problems of inappropriate database, difficult to guarantee index consistency, inappropriate for massive data, etc., to achieve good scalability, meet real-time requirements, and improve storage and query efficiency. Effect

Active Publication Date: 2017-12-01
CHINESE ACAD OF SURVEYING & MAPPING
View PDF5 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

This patented technology allows for efficient storing and accessing large amounts of space by assigning each location an identifiable label based upon their current position within it's geographic area. It also uses partitions between different locations to efficiently store and retrieve this data without causing incorrect indexes due to adding/removing objects from other areas. Additionally, there can be multiple copies of these data across various servers if needed. Overall, this system makes searching and retrieving data faster than previous methods while still providing accurate results over long periods of time.

Problems solved by technology

Technological Problem addressed in this patents is how to efficiently manage and process huge amounts of temporal and spatially correlated data without overwhelming up any available computing devices at home, school settings, industrial environments, and even within mobile apps. Current solutions involve storing them locally, limiting their usages, requiring expensive hardware infrastructure, slowdowns during updates, and increasing overhead expenses associated with accessing and analyzing them manually. There is currently no solution for efficient handling and deployment of spatial datasets containing temporally varying data called “spat” type assets.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Spatio-temporal data indexing method in non-relational database
  • Spatio-temporal data indexing method in non-relational database
  • Spatio-temporal data indexing method in non-relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0089] The present invention is based on the New Map software spatial database engine API, utilizes above-mentioned technology to develop the data driver program (hereinafter referred to as NM-TSDE) based on Cassandra distributed NoSQL database. The test environment uses three VMWare virtual machines (1CPU, dual-core, 4G memory, 50GB hard disk, Windows Server 2008 operating system). The comparison test uses the Oracle database and ArcSDE (spatial data geometric information is stored using ST_GEOMETRY objects) on the same computer (CPU 8-core 3.6GHz, 4G memory, 100M Ethernet card), the same network bandwidth (100M Ethernet), the same The storage and query efficiency test was performed under the Oracle database server (CPU 8-core 2.40GHz, 16G memory, 100M Ethernet card).

[0090] The experimental data used the March 2016 vector data provided by Open Street Map (OSM), Japan in Asia, and the format is Shapefile. The data size is 3.29GB, and there are 8 layers in total, including 2...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a spatio-temporal data indexing method in a non-relational database. A spatial index based on a quadtree and a Hilbert curve is established for spatio-temporal data in a distributed environment; temporal attributes of the spatio-temporal data are combined to form a unified spatio-temporal index; the spatio-temporal index is divided into two parts of partition keys and sorting keys, and consistent hash is used to realize distributed storage and routing of spatial data in a dynamic network topology; and when a query request is received, the partition keys and the sorting keys of a query range are determined according to temporal and spatial ranges, retrieval is carried out in storage nodes, and a query result is returned. According to the method, the storage and query efficiency of the spatio-temporal data is improved, each storage node only needs to maintain allocated data thereof, addition or deletion of the storage nodes will not cause an index error, real-time performance requirements on data accessing under a high-concurrency condition are met, and the database extendibility is good.

Description

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Owner CHINESE ACAD OF SURVEYING & MAPPING
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products