Unlock instant, AI-driven research and patent intelligence for your innovation.

Calling method, device, storage medium and terminal of stored procedure

A technology of stored procedures and user accounts, applied in the field of communication, can solve the problems of slow data update efficiency and inability to meet users' dynamic viewing, and achieve the effect of solving slow data update efficiency and fast update efficiency

Active Publication Date: 2021-03-02
PING AN TECH (SHENZHEN) CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The embodiment of the present invention provides a calling method, device, storage medium and terminal of a stored procedure to solve the problems in the prior art that the data updating efficiency of the reporting system is slow and the user cannot dynamically view the latest 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
  • Calling method, device, storage medium and terminal of stored procedure
  • Calling method, device, storage medium and terminal of stored procedure
  • Calling method, device, storage medium and terminal of stored procedure

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0053] figure 1 It shows the first implementation flow of the calling method of the stored procedure provided by the embodiment of the present invention.

[0054] In the embodiment of the present invention, the calling method of the stored procedure is applied to a terminal, including but not limited to a computer, a server, and the like.

[0055] refer to figure 1 , the calling method of the stored procedure includes:

[0056] In step S101, a report response function is created in the Oracle database, and the report response function is used to call a stored procedure in the Oracle database in response to a calling request of the report system.

[0057] In the embodiment of the present invention, the report system is Pentaho report system. The Oracle database is a database related to the Pentaho reporting system, which stores various table information and table data. There are usually multiple native stored procedures in the Oracle database. These stored procedures refer to...

Embodiment 2

[0117] Figure 5 A structural diagram of a device for invoking a stored procedure provided by an embodiment of the present invention is shown. For convenience of description, only parts related to the embodiment of the present invention are shown.

[0118] In the embodiment of the present invention, the calling device of the stored procedure is used to realize the above-mentioned figure 1 , figure 2 , image 3 , Figure 4 The calling method of the stored procedure described in the embodiments may be a software unit, a hardware unit, or a combination of software and hardware built in the server.

[0119] refer to Figure 5 , the calling device of the stored procedure includes:

[0120] Create module 51, be used for creating report response function in Oracle database, described report response function is used for calling the stored procedure in Oracle database in response to the call request of reporting system;

[0121] The obtaining module 52 is used to analyze the da...

Embodiment 3

[0141] This embodiment provides a computer-readable storage medium, and a computer program is stored on the computer-readable storage medium. When the computer program is executed by a processor, the calling method of the stored procedure in Embodiment 1 is implemented. To avoid repetition, details are not repeated here. . Alternatively, when the computer program is executed by the processor, the functions of the modules / units in the stored procedure calling device in Embodiment 2 are implemented. In order to avoid repetition, details are not repeated here.

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 present invention is applicable to the technical field of communication, and provides a calling method, device, storage medium and terminal of a stored procedure. The method includes: creating a report response function in an Oracle database, and the report response function is used to respond to a report system Invocation request calls the stored procedure in the Oracle database; when the data request message sent by the reporting system is obtained, the data request message is parsed to obtain request parameters; the request parameters are passed into the report response function, and the report is The response function calls the stored procedure corresponding to the request parameter; executes the stored procedure to process the data in the Oracle database, reads the processed data, and responds to the data request of the report system; the present invention solves the problem of In the prior art, the report system cannot call the stored procedure in the Oracle database, and the data update efficiency is slow.

Description

technical field [0001] The invention belongs to the technical field of communication, and in particular relates to a calling method, device, storage medium and terminal of a stored procedure. Background technique [0002] Pentaho is currently the most popular open-source business intelligence software. It is a BI suite with workflow as the core, emphasizing solution-oriented rather than tool components. It integrates a large number of machine learning algorithms that can undertake data mining tasks, including data preprocessing, Classification, regression, clustering, association rule analysis, and visualizing data on an interactive interface. However, existing BI report tools do not have the function of carrying data processing. The Pentaho report system mainly uses the HSQLDB database as the database, and the database is only updated once a day. When users view data on the Pentaho report system, due to the slow update efficiency of HSQLDB, users cannot obtain the latest ...

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/28G06F16/23G06F16/22
CPCG06F16/2291G06F16/2379G06F16/284
Inventor 温善安李磊陈宝花金鑫杨雨芬
Owner PING AN TECH (SHENZHEN) CO LTD