NoSQL-based single field section index query method for distributed Internet of things data

A query method and technology of the Internet of Things, applied in the field of single-field interval index query methods, can solve the problems of complexity, poor scalability, and high IO pressure under big data, and achieve the effect of improving data search and reducing wasted time.

Inactive Publication Date: 2016-03-30
FUJIAN AGRI & FORESTRY UNIV
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Although the relational database is very powerful, it cannot cope with all application scenarios well
The scalability of MySQL is poor and complex technology is req

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
  • NoSQL-based single field section index query method for distributed Internet of things data
  • NoSQL-based single field section index query method for distributed Internet of things data
  • NoSQL-based single field section index query method for distributed Internet of things data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0019] The present invention provides a single-field interval index retrieval method for distributed Internet of Things data based on a NoSQL database. The method includes: creating a NoSQL database and importing the Internet of Things data into the database; creating an index table corresponding to the database; directly Search the index table to get the field attributes of the database; update the index table when the database is added, deleted or modified to achieve data consistency; if you cannot find the data when searching the index table, go to the database to search.

[0020] Such as figure 1 As shown, the embodiment of the present invention provides an index table for creating a single-field index retrieval method based on NoSQL database-based distributed Internet of Things data, and the specific implementation steps include:

[0021]...

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 present invention aims to provide a NoSQL-based single field section index query method for distributed Internet of things data. The method is characterized by comprising the following steps: step S0: creating a NoSQL database and importing Internet of things data into the database; step S1: creating an index table corresponding to the database, wherein the index table stores indexes and a field attribute in the database; step S2: directly searching, according to a field section, the index table to obtain the field attribute of the database; and step S3: when the database is added, deleted or modified, updating the index table so as to achieve data consistency. According to the NoSQL-based single field section index method for the distributed Internet of things data provided by the present invention, a search for the field attribute of a NoSQL database can be implemented by directly searching the index table generated by the database, thereby reducing the wasted time of searching the NoSQL database, and improving the data search.

Description

technical field [0001] The invention relates to a NoSQL-based single-field interval index query method for distributed Internet of Things data. technical field [0002] The invention relates to the field of software development, in particular to a NoSQL-based single-field interval index query method for distributed Internet of Things data. Background technique [0003] The traditional relational database has good performance, high stability, long history, and is easy to use, powerful, and has accumulated a large number of successful cases. In the Internet field, MySQL has become the absolute king. It is no exaggeration to say that MySQL has made outstanding contributions to the development of the Internet. [0004] Although a relational database is very powerful, it cannot cope with all application scenarios well. MySQL has poor scalability and requires complex technology to implement. Under big data, IO pressure is high, and table structure changes are difficult, which...

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
IPC IPC(8): G06F17/30
CPCG06F16/2228G06F16/2455G06F16/27
Inventor 张振昌黄绍平陈日清陈大耀
Owner FUJIAN AGRI & FORESTRY UNIV
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap