Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for querying data based on data characteristics

A technology for querying data and data features. It is used in electrical digital data processing, digital data information retrieval, and special data processing applications. It can solve problems such as inability to understand tables and query fields, and achieve the effect of reducing familiarity requirements.

Active Publication Date: 2021-04-27
KOUBEI SHANGHAI INFORMATION TECH CO LTD
View PDF11 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But usually when the business is inquiring, sometimes only one query data is obtained, but the corresponding table, query field, etc. cannot be understood. At this time, people who are not familiar with the business cannot obtain the corresponding query results based on the query data

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
  • Method and device for querying data based on data characteristics
  • Method and device for querying data based on data characteristics
  • Method and device for querying data based on data characteristics

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0059] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0060] figure 1 A flowchart showing a method for querying data based on data characteristics according to an embodiment of the present invention. Such as figure 1 As shown, the method for querying data based on data characteristics specifically includes the following steps:

[0061] Step S101, according to the query operation, obtain the query data entered on the page.

[0062] Such as figure 2 As shown, after the user clicks ...

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 method and device for querying data based on data characteristics. The method includes: acquiring query data input on a page according to a query operation; The characteristic value, and the characteristic value corresponding to the query field of the first data table; according to the association relationship between the characteristic value and the table name, the characteristic value and the query field stored in advance, obtain the table name of the first data table and the query field of the first data table; assemble Generate a query statement including the table name of the first data table, the query field of the first data table and query data; execute the query statement to obtain the query result of the first data table, and display the query result on the page. The invention reduces the familiarity requirements of business operators for business data, and can automatically obtain corresponding table names and query fields without specifying specific table names and query fields, and obtain corresponding query results only by using query data.

Description

technical field [0001] The invention relates to the field of software, in particular to a method and device for querying data based on data characteristics. Background technique [0002] When querying data, you generally need to provide the table to be queried, query fields, and query data, so that query statements can be generated based on the above data, and corresponding query results can be obtained. Query the product id value XXX in the product table to obtain the corresponding product information, and then display the product information. But usually when the business is inquiring, sometimes only one query data is obtained, but the corresponding table, query field, etc. cannot be understood. At this time, people who are not familiar with the business cannot obtain the corresponding query results based on the query data. Based on this problem, a method for data query based on the characteristics of the data itself is needed, so as to reduce the requirements for personn...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/248
Inventor 卜乐
Owner KOUBEI SHANGHAI INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products