Database interactive processing method and system

An interactive processing and database technology, applied in the direction of electrical digital data processing, special data processing applications, multi-programming devices, etc., can solve problems such as many concurrent programs, database suspension and no longer responding to requests, etc.

Active Publication Date: 2008-06-04
ADVANCED NEW TECH CO LTD
View PDF0 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a database interactive processing method and system to solve the problem in the prior art that the database hangs up and no longer responds to requests due to the existence of many concurrent programs

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
  • Database interactive processing method and system
  • Database interactive processing method and system
  • Database interactive processing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] In order to solve the problem in the prior art that there are too many concurrent programs causing the database to hang and no longer respond to requests, the present invention controls the number of concurrent processing programs at the database control layer according to the average processing time of concurrent programs and the longest execution time.

[0036] see figure 1 , the database interaction processing system in this embodiment includes an application interface 101 , a processing module 102 , a statistical module 103 and an execution module 104 .

[0037] The application interface 101 receives requests for accessing databases from the application layer.

[0038] The processing module 102 generates a unique identifier for each request, obtains the number of concurrent programs and the number of currently executing concurrent programs from the statistics module 103, and judges whether the number of currently executing concurrent programs is less than the number...

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 discloses a database interactive processing method and a system thereof and solves the problems that the prior art has more concurrent programmes and causes that a database is suspended and can no longer respond requests. The method of the invention is as follows: a request of accessing the database is accepted; the concurrent number is acquired and is a maximum quantity which allows processing the concurrent programmes simultaneously; whether the quantity of the current processing concurrent programmes is less than the concurrent number is judged; if yes, the request is processed, otherwise, the request is refused. The system comprises an application interface, a processing module and an execution module.

Description

technical field [0001] The invention relates to the application field of computers and databases, in particular to a database interactive processing method and system. Background technique [0002] In a large-scale database-based system, the processing capacity of the database will continue to decrease as time increases and the amount of data continues to increase. Moreover, this performance degradation is a gradual process that cannot be predicted well, and the resulting consequences It is at a certain point that the response speed of the system becomes slower and slower, and it becomes more and more unstable. Occasionally, the response of some applications becomes extremely slow. At this time, if there are more concurrency, the system will hang no longer Respond to requests. [0003] Currently commonly used solutions are mainly focused on monitoring, then manual analysis, and then improve query performance one by one. Monitoring is often added to the application program ...

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/30G06F9/46
Inventor 沈少峰吕开利
Owner ADVANCED NEW 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