Structured query language command generation method and device based on index system

A structured query and index system technology, applied in the field of data processing, can solve the problems of complex and cumbersome report association processing, unfavorable unified maintenance, and low processing efficiency, so as to facilitate unified maintenance and effective management, improve the efficiency of command generation, and avoid caliber inconsistent effect

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

AI Technical Summary

Problems solved by technology

Among them, the first processing method is to obtain various data processing scripts by manually writing structured query language instructions (that is, SQL instructions), and associate and bind data sources and report presentations. This processing method requires a lot of manpower The cost and processing efficiency are low, and the report association processing is complicated and cumbersome, which is not conducive to unified maintenance
The second processing method is to automatically generate SQL instructions based on data tables and multi-table associations, and then bind them to the visual interface of the report. This processing method requires a large amount of data table maintenance, and there will be overlap between data tables indicators, when a data table changes, other data tables do not perceive it, causing serious data quality problems

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
  • Structured query language command generation method and device based on index system
  • Structured query language command generation method and device based on index system
  • Structured query language command generation method and device based on index system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0078] 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.

[0079] Figure 1a A schematic flow diagram showing a method for generating a structured query language instruction based on an index system according to an embodiment of the present invention, as shown in Figure 1a As shown, the method includes the following steps:

[0080] Step S100, according to the data table, construct an index system including a plurality of index models and data subject marts.

[0081] This method can be exe...

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 structured query language instruction generation method and device based on an index system, wherein, the structured query language instruction generation method based on theindex system comprises the following steps: constructing the index system including a plurality of index models and a data subject market according to a data table; configuring data subjects in the data subject market to obtain configuration data corresponding to the data subjects; generating a structured query language instruction corresponding to the data subject according to the configurationdata; and obtaining the access service by using the structured query language instruction. According to the technical scheme provided by the invention, the structured query language instructions suitable for various business requirements can be generated quickly, automatically and flexibly, the association mapping relationship between the index system and the SQL service is established, various business requirements are effectively met, the uniqueness of data indicators is ensured, and the problem of index inconsistence is effectively avoided.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for generating structured query language instructions based on an index system. Background technique [0002] With the rapid development of information technology, we ushered in the era of big data, which requires data processing of massive data. Generally, by analyzing and processing the data, the data is converted into dimensions that are easy for users to understand, and the data indicators that users need are obtained from various possible dimensions, and visualized reports are obtained, so that users can quickly and intuitively understand business development and determine business Develop strategy. In the prior art, reports are generally obtained through the following two processing methods. Among them, the first processing method is to obtain various data processing scripts by manually writing structured query language instructions (that is, S...

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/245G06F16/22
Inventor 张永志赵国旗曹铁铮由治国陈洪常炜
Owner KOUBEI SHANGHAI INFORMATION TECH CO LTD
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