Apparatus and Method for On-Demand In-Memory Database Management Platform

• US 20120095959A1
• Filed: 10/25/2011
• Published: 04/19/2012
• Est. Priority Date: 12/05/2005
• Status: Active Grant

• Current Assignee: InteliTrac, Inc.
• Original Assignee: InteliTrac, Inc.
• Inventors: Chen, Tianlong
• Granted Patent: US 8,464,013 B2
• Time in Patent Office: Days
• US Class Current: 707/610
• CPC Class Codes: G06F 12/0292 using tables or multilevel address translation means G06F12/023 takes precedence; address translation in virtual memory systems G06F12/10

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

1-5. -5. (canceled)

6. A method for implementing a dynamic replication in a memory or non-memory based block storage system storing data, said block storage system may include one or multiple of storage servers, comprising steps of:

providing one or multiple replication blocks for a first block in said block storage system, and said replication blocks replicate partial or whole data of said first block;

redirecting an access to said first block to said replication blocks for data access;

wherein said step of redirecting comprises the steps of;

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;

providing a block address in said block ID lookup table to access to each said block, wherein said block address includes said block ID;

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

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.

7. A method according claim 6 wherein a first criteria is defined in said block storage system, one or multiple said replication blocks will be created for said first block when said first criteria is meet, and said accessing to said first block is to be directed to said replication blocks and said first block for data access.

8. A method according claim 7 wherein a second criteria is defined in said block storage system, the number of created said replication blocks can be decreased when said second criteria is meet, and said accessing to said first block is to be directed to left-over said replication blocks and said first block for data access.

9. A method according to claim 7 wherein the said creation is automatically triggered by said block storage system when said first criteria is meet.

10. A method according to claim 8 wherein said decreasing is automatically triggered by said block storage system when said second criteria is meet.

11. A method according to claim 6 wherein said replication blocks of said first block can be on the servers that are different from the server where said first block is located.

12-28. -28. (canceled)