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

Calling method and device of storage process, storage medium and terminal

A stored procedure and user account technology, which is applied in the communication field, can solve problems such as inability to satisfy users' dynamic viewing, slow data update efficiency, etc., and achieve the effect of solving slow data update efficiency and fast update efficiency

Active Publication Date: 2018-07-06
PING AN TECH (SHENZHEN) CO LTD
View PDF4 Cites 5 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 and device of storage process, storage medium and terminal
  • Calling method and device of storage process, storage medium and terminal
  • Calling method and device of storage process, storage medium and terminal

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 invention is applicable to the technical field of communication, and provides a calling method and device of a storage process, a storage medium and a terminal. The method comprises the steps thata report response function is created in an Oracle database, wherein the report response function is used for responding to a calling request of a report system to call the storage process in the Oracle database; when a data request message sent by the report system is acquired, the data request message is analyzed to obtain request parameters; the request parameters are transmitted to the reportresponse function, and the storage process corresponding to the request parameters is called by the report response function; the storage process is executed to process data in the Oracle database, and the processed data is read to respond to the data request of the report system. The problems that a report system in the prior art cannot call the storage process in the Oracle database and the data updating efficiency is low are solved.

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2291G06F16/2379G06F16/284
Inventor 温善安李磊陈宝花金鑫杨雨芬
Owner PING AN TECH (SHENZHEN) CO LTD