Business rule basic data buffer method

A technology of basic data and buffering methods, applied in the field of data communication, can solve problems such as inefficiency, and achieve the effect of improving response efficiency and reducing access intensity

Inactive Publication Date: 2008-02-20
JIDONG GROUP HLDG
View PDF0 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the billing system, initiating a billing request often encounters a query operation on the database, which mainly involves various pre-set billing rules, and it is obviously a waste of time to initiate a query request to the database server every time. an inefficient method

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
  • Business rule basic data buffer method
  • Business rule basic data buffer method
  • Business rule basic data buffer method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0029] As shown in Figure 1, it is a schematic diagram of the implementation method of the present invention, a buffering method of business rule basic data, which is characterized in that it adopts C, C++ or C# language programming, and runs on a PC server based on X86 architecture, its method for:

[0030] First assumptions were made about the following factors:

[0031] a. The basic data of business rules are stored in the database server of the system;

[0032] b. The basic data of the business rules will change, but the changes are relatively small, ranging from no change to a few days, to a few minutes at most;

[0033] c. It is not required that changes in the basic data of business rules take effect immediately, that is to say, a delay of tens of seconds or even 1 minute can be allowed;

[0034] d. The business rule basic data in the cache does not need to be modified;

[0035] e. The amount of basic business rule data is not very large, and the main memory of the c...

specific Embodiment approach

[0038] 1) First create a trigger for each business rule basic data table, which monitors the update status of each table and writes the update status to the "Business Rule Basic Data Timestamp Table". The structure of the table is as follows:

[0039] "Business rule basic data timestamp table" in the database

name

type

Meaning (Description)

physical table name

string

physical table name

timestamp

datetime

The last update time of the physical table

[0040] 2) In the actual implementation process, there is not a one-to-one correspondence between the basic data table of business rules in the database (referred to as "physical table") and the data table to be buffered in the memory (referred to as "memory table"). A physical table may correspond to a buffer table in memory, for example, multiple "physical tables" are naturally connected to a "memory table", or conversely, a "physical table" is split into multiple "memory...

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 utility model relates to a basic data buffering method in business transaction, which is used for reducing database load and promoting system response speed in a transaction system under large concurrent access requests. The utility model can timely and effectively buffer the transaction basic data into a system main memory by making use of relative stability of the transaction basic data and the caching capability of the system main memory, so as to promote the system response speed.

Description

technical field [0001] The invention relates to a buffering method for basic data of business rules, which is a method for reducing database pressure and improving system response speed in the case of large concurrent access requests of business systems. It can be applied to various high-concurrency billing systems, domain name services, load balancing control services, etc., and belongs to the field of data communication technology. Background technique [0002] In the billing system, initiating a billing request often encounters a query operation on the database, which mainly involves various pre-set billing rules, and it is obviously a waste of time to initiate a query request to the database server every time. an inefficient method. Contents of the invention [0003] The purpose of the present invention is to provide a buffering method of business rule basic data which reduces the access intensity to the database server and improves the response efficiency of the syst...

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/30H04M3/24
Inventor 彭亮王磊
Owner JIDONG GROUP HLDG
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