Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Internal memory database system and method and device for implementing internal memory data base

A database and memory technology, applied in the database field, can solve problems such as waste of table space, dynamic expansion of difficult data table space, serious problems, etc., and achieve the effects of reducing resource occupation, flexible creation and management, and flexible storage

Inactive Publication Date: 2008-12-03
HUAWEI TECH CO LTD
View PDF0 Cites 80 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the existing in-memory database storage method is difficult to realize the dynamic expansion of the data table space; in addition, since the table records are stored in a fixed data structure, the waste of table space for the database table with variable-length fields is also serious

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
  • Internal memory database system and method and device for implementing internal memory data base
  • Internal memory database system and method and device for implementing internal memory data base
  • Internal memory database system and method and device for implementing internal memory data base

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0065] In the embodiment of the present invention, according to the function of the storage space of the memory database in the shared memory, the storage space is divided into a first storage area, a second storage area and a third storage area, such as Figure 1A shown. Wherein, the first storage area stores description information of the database (or database system definition information), the second storage area stores index information for locating table records, and the third storage area stores table records of database tables. The first storage area, the second storage area and the third storage area can be distributed continuously or non-continuously in physical space; similarly, each storage area in the first storage area, the second storage area and the third storage area Zones can be distributed continuously or discontinuously in physical space.

[0066] The structure of an in-memory database system in this embodiment is as follows: Figure 1B As shown, it includ...

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 memory database system which comprises a communication interface, a establishing device, a write operation device, a query operation device and a relief operation device; the establishing device is used for establishing a first storage area of the description information of a memory database in a shared memory, storing a second storage area used for locating the index information of table records and a third storage area used for storing the table records, and storing the description information of the memory database into the first storage area; the third storage area comprises storage units which are matched with the table records in size, and each storage unit stores one table record of the database, a physical block is formed by the storage units which have the same size and are continuous in physical space, and a logical block is linked by one physical block or a plurality of the same physical blocks. The invention also discloses a method for establishing the memory database, a method and the device for establishing multiple indexes. The invention realizes the loose coupling of the memory database table structure and the data storage structure, and can flexibly establish and manage the memory database.

Description

technical field [0001] The invention relates to database technology in the field of computer and communication, in particular to a memory database technology. Background technique [0002] The current in-memory database maps all the data in the commonly used database tables in the system to the shared memory of the host, and stores each fixed database table in the shared memory by using a fixed data structure array, that is, the data in the memory A storage area is used as a table space of a database table. According to the actual size of the table records, the storage area is divided into multiple memory blocks to save the data in the database table; a memory index is established on the key fields in the database table, through which The in-memory index provides real-time access to key data. The memory system provides an API (Application Programming Interface) interface for modifying and retrieving data in the memory database tables. When an application accesses these data...

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 HUAWEI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com