Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Method for handling uncertainty of return results of trigger

A technology that returns results and uncertainty, applied in the direction of program control devices, etc., can solve problems such as increased background load, error reporting, and many fields in the data table, and achieve the effect of simplifying complex problems, accurate processing, and simple clarity

Active Publication Date: 2012-10-03
福建汇智数字通达科技有限公司
View PDF1 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In actual work, some businesses involving databases not only have a heavy workload, but also deal with various data and relationships very complicated. There are many fields in the data table. If it is handed over to the background for processing, it will be processed quickly without the database. The uncertainty of the cursor return value when designing triggers often leads to program errors on the database side, which affects the smooth flow of the system. In addition, the database programming language is not as concise and clear as a high-level language, and many developers will give up programming on the database side. Development, and turn the work to the background, which will increase the load on the background, let the powerful database be idle, and only process some SQL statements
[0007] The so-called uncertainty of the return value of the cursor result means that when a result set is returned, sometimes it is one result, sometimes it is multiple results. When multiple results are encountered, an error will be reported when using an implicit cursor. On the contrary, the same An error will be reported. There is no effective solution to this problem, and some database processing software does not have the function of debugging triggers, which makes the problem difficult

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
  • Method for handling uncertainty of return results of trigger
  • Method for handling uncertainty of return results of trigger

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0020] Currently, in the development of database triggers, cursors are usually used. Its main function is to return one or more records through some conditions, and calculate by extracting fields from the records, so as to achieve the purpose of database processing transactions independently. In the use of cursors, there is uncertainty in the number of results returned, and the trigger programming language is not as flexible and concise as other object-oriented development languages, so the application of triggers is not widespread, making some powerful databases Did not give full play to its powerful performance. In this solution, when using the implicit cursor, there is an attribute to handle exceptions, which is the key to solving the problem. It is precisely because the exception can be caught that we can know how many results the...

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 mainly provides a method for handling uncertainty of return results of a trigger, relating to the technical field of computer software. The method specifically includes the following steps that first of all, a variable is stated and is assigned; when processing a cursor, the variable value is changed according to different numbers of the return results through the corresponding abnormal handlings conducted to different return results in an Oracle database, for example, the variable is 1 at the beginning, when the cursor returns one result, the value remains unchanged, when the cursor returns a plurality of results, the variable value is assigned to be 2 and when the cursor returns no result, the variable value is assigned to be 0; and finally different program segments are executed with respect to different variable values by judging the sentences. In such a way, the return results are of clear structure and are simple and explicit, and therefore the trigger can accurately handle the return results of the cursor, the complicated problem is simplified and the expected target is accomplished. The invention aims to solve the technical problem of providing a method for handling the uncertainty of the return results of the trigger so as to ingeniously solve the problem of uncertainty of the return results of the trigger of a database by analyzing the results.

Description

technical field [0001] The invention relates to the technical field of computer software, in particular to a method for dealing with the uncertainty of trigger return results. Background technique [0002] With the rapid development of the current Internet, the requirements for data storage and communication have also increased dramatically, thus accelerating the continuous updating of database software. In the past, database software can generally only meet local data storage and access, and has the characteristics of small capacity and difficult interaction. With the continuous expansion of the network scale, people need a large-scale, distributed, mass-storage database management software. The oracle database software emerges as the times require, and is widely used in many large-scale network communication systems. Nowadays, some domestic enterprises often choose oracle database when developing application systems, so that they can meet their needs in different fields. ...

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): G06F9/44
Inventor 何泾沙王经纬张玉强
Owner 福建汇智数字通达科技有限公司
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
Eureka Blog
Learn More
PatSnap group products