Service information index query method and related equipment

A technology of business information and query methods, which is applied in the field of business information index query methods and related equipment, can solve problems such as time-consuming, timeliness cannot be guaranteed, and multi-index assembly and analysis cannot be realized, so as to promote consistency and improve business The effect of insight

Pending Publication Date: 2021-03-16
CHINA LIFE INSURANCE COMPANY
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The limitation of the system is that it can only analyze a single indicator, and cannot realize the assembly analysis of multiple indicators and common dimensions
[0006] When there is a large amount of data, it can only be pre-processed into an intermediate table. When querying indicators on the page, it is obtained from the intermediate table. This requires pre-processing in advance, which consumes a lot of time and cannot guarantee timeliness

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
  • Service information index query method and related equipment
  • Service information index query method and related equipment
  • Service information index query method and related equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] In order to make the purpose, technical solutions and advantages of the present disclosure clearer, the present disclosure will be further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0030] It should be noted that, unless otherwise defined, the technical terms or scientific terms used in one or more embodiments of the present specification shall have ordinary meanings understood by those skilled in the art to which the present disclosure belongs. "Comprising" or "comprising" and similar words mean that the elements or items appearing before the word include the elements or items listed after the word and their equivalents, without excluding other elements or items. Words such as "connected" or "connected" are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect.

[0031] As mentioned in the background technology section, when using t...

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

One or more embodiments of the invention provide a service information index query method and related equipment. The service information index query method and the related equipment can perform corresponding data query on a plurality of indexes at the same time and display all the indexes on a foreground page. Firstly, a foreground page converts elements selected and determined by a user into datain a JSON format and sends the data to a background; the background analyzes the JSON data by to obtain indexes, and performs mapping conversion on the indexes to enable the indexes to correspond tocolumn fields of a specified table in the HIVE library; the indexes are grouped according to tables to which the indexes belong, and SQL retrieval statements are generated for each group, wherein whena parameter index in the indexes can hit a field on the HIVE table, the field value is spliced in the SQL statement, and otherwise, a special character NULL is used for bit compensation; and splicingthe SQL statements by using an operator UNION ALL and performing querying, and displaying all query results on a foreground page.

Description

technical field [0001] One or more embodiments of this specification relate to the field of intelligent application systems, and in particular to an index query method and related equipment for business information. Background technique [0002] In the field of BI (business intelligence application system), representative tools include Microsoft's products SSRS (MicrosoftSQL Server Reporting Services, reporting tool) and PowerBI (data visualization tool), these tools implement reports in traditional relational data table objects The presentation of indicators and indicators is powerful and widely used. However, commercial products not only have the characteristics of technical closure, but also have no advantage in the efficiency of data transmission between heterogeneous databases, and the reports and indicators that need to be displayed need to be prepared in advance in a relational data table. Extended indicators have higher upgrade and maintenance costs. [0003] The B...

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 Applications(China)
IPC IPC(8): G06F16/242G06F16/245G06F16/248
CPCG06F16/2433G06F16/245G06F16/248
Inventor 白龙陈辰张浩王厚玉黄艳袁慧斌胡帅
Owner CHINA LIFE INSURANCE COMPANY
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