# US 2012/0095963 A1 · Apparatus and method for on-demand in-memory database management platform

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2012/0095963 A1
- Document ID: US20120095963A1
- Status: Published application
- Kind: A1
- Application number: 13/280,553
- Filed: 2011-10-25
- Published: 2012-04-19
- Earliest claimed: 2005-12-05
- Assignees: InteliTrac, Inc.
- Inventors: Tianlong Chen
- Web page: https://patentgrep.com/patent/US20120095963A1

## CPC

- G06F 12/0292: {using tables or multilevel address translation means (G06F12/023 takes precedence; address translation in virtual memory systems G06F12/10)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method and apparatus for constructing a memory-based database service platform, in which database can be on-loaded and off-loaded or unloaded as needed, and can reserve schedule and size of memory and other resources, including CPUs, network, backup, mirroring and recovery recourses. With the service platform, multiple different types of databases can be chosen by specifying data storage type and data operation interfaces, such as Relational Database (RDB), Biometric Database (BDB), Time Series Database (TDB), Data Driven Database (DDDB) and File-based Database (FDB) etc. Database types can be chosen either by user directly or by platform automatically or semi-automatically based on data types and data operation characteristics.

## Claims

### Claim at position 1

1-19. (canceled)

### Claim 20

A memory-based on-demand database system having a plurality of blocks of memory for data operation and storage, comprising:
means for loading a database partially or in whole from a secondary system into said memory blocks for data operation; and
means for unloading a said database from said memory blocks to said secondary system;
wherein said means for loading comprises:
means for providing a block ID lookup table, wherein each said block has a block entry in said block ID lookup table containing a block ID, and said block entry contains direct or indirect information of a physical location of said block in said block storage system;
means for providing a block address in said block ID lookup table to access to each said block, wherein said block address includes said block ID;
means for dynamically duplicating data stored in a first block in said block storage system into a second block in said block storage system, wherein said first block has a first block ID in said block ID lookup table and said second block has a second block address in said block ID lookup table and wherein a first block entry in said block ID lookup table corresponding to said first block contains different direct or indirect information of a physical location of said first block than a second block entry in said block ID lookup table corresponding to said second block; and
means for dynamically changing said second block address in said block ID lookup table to duplicate said first block address to re-direct said first block ID to the physical location of said second block in said block storage system, wherein after said dynamic change a plurality of entries in said block ID lookup table comprise said first block ID.

### Claim 21 (depends on 20)

A memory-based on-demand database system according to claim 20 further comprises an optional backup means to backup or replicate said database partially or in whole.

### Claim 22 (depends on 20)

A memory-based on-demand database system according to claim 20 further comprises a database administration management that includes at least database registration, database configuration and user account information.

### Claim 23 (depends on 22)

A memory-based on-demand database system according to claim 22 wherein said database configuration at least contains built-in or user-defined database types, built-in or user-defined database storage types, built-in or user-defined database query methods.

### Claim 24 (depends on 23)

A memory-based on-demand database system according to claim 23 wherein said database configuration further contains database operation toolsets.

### Claim 25 (depends on 22)

A memory-based on-demand database system according to claim 22 wherein user can choose a suitable said database type, a suitable database storage type and a suitable database query method when loading a said database into said memory for data operation.

### Claim 26 (depends on 20)

A memory-based on-demand database system according to claim 20 further comprises a recourse management which tracks at least memory usage and availability of said memory blocks in said on-demand database system.

### Claim 27 (depends on 23)

A memory-based on-demand database system according to claim 23 wherein said database type includes SQL-based relational database, and said query method includes SQL language.

### Claim 28 (depends on 24)

A memory-based on-demand database system according to claim 24 wherein user can choose a suitable said database operation toolset for his/her high-level data operation.