Realization method of main memory database under host system

A host system and database technology, applied in the field of data processing, can solve the problem that the efficiency of database data access cannot meet the performance requirements of hot table access, and achieve the effect of meeting performance requirements

Active Publication Date: 2015-05-13
AGRICULTURAL BANK OF CHINA
View PDF5 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In view of this, the present application provides a method for implementing an in-memory database under the host system to solve the problem that the data access efficiency of the database in the prior art cannot meet the performance requirements of the application when accessing the hot table

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
  • Realization method of main memory database under host system
  • Realization method of main memory database under host system
  • Realization method of main memory database under host system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0070] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0071] At present, large commercial banks still mainly use IBM mainframe systems to process intra-bank transactions. Based on this current situation, the present invention proposes a method for implementing an in-memory database under a host system to solve the problem that the existing data access efficiency cannot meet the performance requirements of applications when accessing hot tables.

[0072] The flow of a method for implementing an in-memory database under a host system dis...

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 realization method of a main memory database under a host system. The realization method includes arranging initial data; performing Hash computing on the data after being arranged, subjecting a result of Hash computing to building according to memory table rules pre-established in the main memory database to generate a memory table source file, and organizing to generate a memory table; loading the memory table source file, setting a downloading instruction CICS LOAD, sending an entry address of the memory table source file to a program through CICS LOAD when a program in a CICS Region calls the main memory database, and establishing SQL sentence mapping. The above process shows that in the realization method, indexes and data in the memory table are constructed in a memory, and performance expenditure of data exchange between the memory and a magnetic disk is reduced in the process of access, so that access performance is higher than the main memory database, and performance requirements when application accesses a hotlist can be further met.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to an implementation method of an in-memory database under a host system. Background technique [0002] At present, large commercial banks still mainly use the IBM mainframe system to process intra-bank transactions. The mainframe system used in the banking industry is limited to the IBM platform, so the relational database management system DB2 database is widely used. However, relational databases like DB2 are best at handling collections rather than individual records. The difference in efficiency between loop-by-item processing and batch processing is in geometric units when processing the same number of records. [0003] In practical applications, in order to improve the efficiency of small table access, DB2 provides a buffer pool bufferpool to reduce the overhead of disk I / O access. [0004] However, judging from the current application status of DB2 databa...

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/30
Inventor 朱浩
Owner AGRICULTURAL BANK OF CHINA
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