Environmental element event data query method and system based on heterogeneous database

A technology of environmental elements and event data, applied in the field of database query, can solve problems such as data synchronization and achieve good versatility

Inactive Publication Date: 2019-12-03
INST OF URBAN ENVIRONMENT CHINESE ACAD OF SCI +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This query method has high query efficiency, but it needs to import the data in each source database in advance, and also faces the problem of data synchronization between the source database and the intermediate database

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
  • Environmental element event data query method and system based on heterogeneous database
  • Environmental element event data query method and system based on heterogeneous database
  • Environmental element event data query method and system based on heterogeneous database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] refer to figure 1 As shown, the present invention provides a method for querying environmental element event data based on a heterogeneous database. The method is carried out based on a pre-established environmental element event database and an environmental Internet of Things system metadata database. The environmental element event database includes environmental elements Information, specifically the indicator description and indicator standard name corresponding to the environmental element event, the metadata database of the environmental Internet of things system includes the relevant information of the data storage layer in each environmental Internet of things system, and the data storage layer is stored in the environmental Internet of things system A database of environmental data, in this embodiment, it is a database for storing data information corresponding to environmental element events, and the relevant information of the data storage layer specifically ...

Embodiment 2

[0055] refer to figure 2 As shown, the present invention also provides a heterogeneous database-based environmental element event data query system, including an environmental element event database, an environmental Internet of Things system meta database, an environmental Internet of Things system, a unified query interface, a processor, a memory, and A computer program stored in the memory and operable on the processor, when the processor executes the computer program, implements the steps in the above method embodiment of Embodiment 1 of the present invention.

[0056] Specifically, the processor in this embodiment includes an event query module, a query conversion module, and a query execution module, and the unified query interface includes an environmental element event input module and a result display module.

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 relates to an environmental element event data query method and system based on a heterogeneous database. The method is carried out based on a pre-established environment element event library and an environment Internet of Things system meta-database, and specifically comprises the following steps: S1, querying the environment element event library according to a to-be-queried environment element event input by a unified query interface, and obtaining corresponding environment element information; s2, querying an environment Internet of Things system metadata base according to ato-be-queried environment element event input by the unified query interface, and obtaining corresponding metadata information; s3, combining the acquired environmental element information with metadata information to obtain query request information; and S4, converting the query request information into a database query language set related to the database, and performing query on the corresponding database. According to the invention, the heterogeneity of the storage layer of the environment Internet of Things system is overcome, and the cross-database query of the environment element eventin the heterogeneous database is realized.

Description

technical field [0001] The invention relates to the field of database query, in particular to a heterogeneous database-based environmental element event data query method and system. Background technique [0002] Most of the existing environmental IoT systems use databases to store data. However, different environmental IoT systems use different databases when designing and implementing systems, even if different systems use the same database and store the same environmental elements. data, but different systems may adopt different data patterns when designing tables, for example, different table names and field names. This heterogeneity makes managers initiate storage structures for different environmental IoT systems. Irrelevant data query requests, such as querying data with a noise decibel value greater than 80 decibels in a specified time period, at this time, such data query requests must be manually converted according to the database and data mode used by each enviro...

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): G06F16/2453G06F16/242
Inventor 王豪伟郑如滨赵景柱
Owner INST OF URBAN ENVIRONMENT CHINESE ACAD OF SCI
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