Service data inquiry method, device, electronic device and storage medium

A technology of business data and query methods, which is applied in the computer field and can solve problems such as long query time of business data, impact of database, failure to meet requirements, etc.

Pending Publication Date: 2019-03-22
CHINA PING AN LIFE INSURANCE CO LTD
View PDF6 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, there are various reporting systems in the industry. These reporting systems generally support the WEB display page of a table corresponding to the SQL configuration items of a system database, but there are not many query SQL configuration items of different systems and different types of databases corresponding to the WEB of a table. The display page, and the OVS visualization system provides such a function: real-time automatic analysis of the core business item indicators of the business system, which can be applied to business statistics and data analysis during abnormal business periods and holidays. Operation and maintenance personnel are dealing with system accidents In the process or in the daily business statistics report, it is usually required to complete in a short time, but manually counting from each database one by one, the efficiency is relatively low, and cannot meet the requirements
[0003] In addition, the existing statistical tools for core business items are generally executed serially according to the inspection items, which leads to a long time for querying business data, and does not consider database performance issues. When selecting dozens of business items involving multiple databases , the database will be affected

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 data inquiry method, device, electronic device and storage medium
  • Service data inquiry method, device, electronic device and storage medium
  • Service data inquiry method, device, electronic device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0053] figure 1 It is a flow chart of the business data query method provided in Embodiment 1 of the present invention. According to different requirements, the execution sequence in the flowchart can be changed, and some steps can be omitted.

[0054] Step S1, establishing database connection pools corresponding to multiple application systems.

[0055] The basic principle of the database connection pool is to maintain a certain number of database connections in the internal object pool, and expose methods for acquiring and returning database connections to the outside. For example, external users can obtain the connection through the getConnection method, and then return the connection through the releaseConnection method after use. Note that the connection is not closed at this time, but is recycled by the connection pool manager and prepared for the next use. Specifically include steps:

[0056] a. Create a ConnectionPool instance, and initialize and create a preset val...

Embodiment 2

[0104] Figure 4 It is a functional module diagram in a preferred embodiment of the service data query device of the present invention.

[0105] In some embodiments, the service data query device 40 runs in an electronic device. The service data query device 40 may include a plurality of functional modules composed of program code segments. The program codes of each program segment in the service data query device 40 can be stored in a memory, and executed by at least one processor to execute (see for details figure 1 and related descriptions) business data query.

[0106] In this embodiment, the service data query device 40 can be divided into multiple functional modules according to the functions it performs. The functional modules may include: a building module 401 , a receiving module 402 , a query module 403 and a display module 404 . The module referred to in the present invention refers to a series of computer program segments that can be executed by at least one pr...

Embodiment 3

[0156] Figure 5 It is a schematic diagram of the electronic device provided by Embodiment 3 of the present invention.

[0157] The electronic device 5 includes: a memory 51 , at least one processor 52 , a computer program 53 stored in the memory 51 and operable on the at least one processor 52 , and at least one communication bus 54 .

[0158] When the at least one processor 52 executes the computer program 53, the steps in the above embodiments of the service data query method are realized.

[0159] Exemplarily, the computer program 53 may be divided into one or more modules / units, and the one or more modules / units are stored in the memory 51 and executed by the at least one processor 52, To complete the present invention. The one or more modules / units may be a series of computer program instruction segments capable of accomplishing specific functions, and the instruction segments are used to describe the execution process of the computer program 53 in the electronic devic...

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

A service data query method includes: establishing a database connection pool corresponding to a plurality of application systems; Receiving an externally inputted query request, wherein the query request comprises one or more business item query requests; Querying services from different databases in the database connection pool according to the query application and obtaining a query result; Anddisplaying query results obtained from databases corresponding to the plurality of application systems into the same table. The invention also provides a service data inquiry device, an electronic device and a storage medium. The invention can realize SQL inquiry request configuration items of different types of databases of different systems, display service items in different types of databasesof the different systems in a WEB display page of a table, and realize business process optimization. The invention can realize SQL inquiry request configuration items of different types of databasesof different systems, display service items in different types of databases of the different systems in a WEB display page of a table, and realize business process optimization.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a business data query method, device, electronic equipment and storage medium. Background technique [0002] At present, there are various reporting systems in the industry. These reporting systems generally support the WEB display page of a table corresponding to the SQL configuration items of a system database, but there are not many query SQL configuration items of different systems and different types of databases corresponding to the WEB of a table. The display page, and the OVS visualization system provides such a function: real-time automatic analysis of the core business item indicators of the business system, which can be applied to business statistics and data analysis during abnormal business periods and holidays. Operation and maintenance personnel are dealing with system accidents In the process or in the daily business statistics report, it is usually requ...

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/2455G06F16/248G06F16/25
Inventor 胡博
Owner CHINA PING AN LIFE INSURANCE 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

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