Stored procedure processing method and device

A storage process and processing method technology, applied in the field of storage process processing methods and devices, can solve the problems of reduced flexibility of storage process use, inability to perform secondary processing of result sets, etc., and achieve the effect of improving flexibility

Active Publication Date: 2016-07-06
HUAWEI TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The embodiment of the present invention provides a stored procedure processing method and device, which is used to solve the problem that the flexibili

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
  • Stored procedure processing method and device
  • Stored procedure processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] The embodiment of the present invention provides a stored procedure processing method and device, which implements secondary processing on the result set by compiling the stored procedure returning the result set into a query view.

[0058] The technical solutions of the present invention will be described below in conjunction with the accompanying drawings and various embodiments.

[0059] The stored procedure processing method and device provided by the embodiments of the present invention can be applied to various computers equipped with processors, such as general-purpose personal computers, portable devices (such as tablet computers), or smart phones. The storage process processing device is connected to the standard interface of the server where the database is located through a wired or wireless medium, and monitors and detects the access request initiated by an external program (such as a report platform) to the database.

[0060] refer to figure 1 As shown, in...

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 stored procedure processing method and device. A stored procedure of a return result set is compiled into a query view to achieve secondary processing of the result set. The method comprises the following steps: when a first stored procedure name is identified from a detected access request, obtaining a structured query language (SQL) code of the first stored procedure according to the first stored procedure name; generating a second stored procedure based on the SQL code of the first stored procedure; executing the second stored procedure to obtain a return result of the second stored procedure, wherein the return result of the second stored procedure is an SQL sentence corresponding to the return result of the first stored procedure; generating the SQL code of the query view of the second stored procedure based on the SQL sentence returned by the second stored procedure; and executing the SQL code of the query view of the second stored procedure to generate the query view of the second stored procedure.

Description

technical field [0001] The present invention relates to database technology, in particular to a stored procedure processing method and device. Background technique [0002] A stored procedure (English: StoredProcedure) is a set of SQL statements (that is, SQL code) in order to complete a specific function in a large database system, which is compiled and stored in the database. The user specifies the name of the stored procedure and gives parameters ( If the stored procedure has parameters) to call it. A stored procedure is an important object in the database and can be used for report development. [0003] The report development process is generally divided into two steps: data preparation and display style design, and data preparation generally has the following methods: [0004] The first method: directly write Structured Query Language (English: StructuredQuery Language, referred to as: SQL) statements; [0005] The second method: Modeling data tables by dragging and ...

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
IPC IPC(8): G06F17/30
Inventor 刘衍初
Owner HUAWEI 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

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