Method for improving processing performance of database-based service system

A business system and processing performance technology, applied in the field of improving the processing performance of database-based business systems, can solve problems such as limiting the processing performance of business systems, and achieve the effect of improving resource utilization

Inactive Publication Date: 2012-05-02
SHANGHAI LIANGJIANG COMM SYST
View PDF0 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] Many shortcomings of the existing technology l

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 improving processing performance of database-based service system
  • Method for improving processing performance of database-based service system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The present invention will be further described below in conjunction with accompanying drawing.

[0030] see figure 1 , the figure shows a method for improving the processing performance of the database-based business system of the present invention, the business system includes business SQL, business layer cache, page replacement algorithm and database,

[0031] After the business system queries the required business data from the database, it opens up a business layer cache locally for storage, and directly reads from the business layer cache when it is queried a second time;

[0032] The information cached in the business layer is processed through the page replacement algorithm. The page replacement algorithm is used to judge the validity of the data stored in the business layer cache and clear invalid data, so as to ensure that the limited business layer cache can be fully utilized.

[0033] The business query SQL execution process is as follows:

[0034] 1. If t...

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 method for improving the processing performance of a database-based service system. The service system comprises a service SQL (structured query language), a service layer cache, a page replacement algorithm and a database; after the service system inquires required service data from the database, a local service layer cache is created to store the required service data, and when the second inquiry is performed, the data is directly read from the service layer cache; the information of the service layer cache is processed by using the page replacement algorithm, and the page replacement algorithm is used for judging the validity of stored data in the service layer cache and clearing invalid data. By using the method disclosed by the invention, the processing performance of the service system can be further improved, and the boundedness, low resource utilization rate and dependence of a traditional method are avoided; the method is implemented by using the existing mature cache technique and the page replacement algorithm, so that the improvement is performed completely from the point of the service system without the limitation to the SQL optimization and dependence on the database optimization, and the resources of a service server are fully used.

Description

technical field [0001] The invention relates to a method for improving the processing performance of a database-based business system, specifically, a method for improving its business processing performance and increasing its throughput when the database-based business system adopts the method. Background technique [0002] Generally, a database-based business system includes two parts, one is the business server, and the other is the database server. At present, the general practice is to optimize the SQL (Structured Query Language) statements used in the business processing process on the business layer and optimize its parameter configuration on the database, so as to achieve the purpose of improving the performance of the business system. [0003] Optimize SQL: make full use of primary keys and indexes; only return necessary data. [0004] Optimize database parameter configuration: modify the memory used, number of threads, page size, data storage method, etc. [0005...

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 SHANGHAI LIANGJIANG COMM SYST
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