# US 7,318,076 B2 · Memory-resident database management system and implementation thereof

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

- Number: US 7,318,076 B2
- Document ID: US7318076B2
- Status: Granted
- Kind: B2
- Application number: 10/347,678
- Filed: 2003-01-22
- Published: 2004-07-22
- Granted: 2008-01-08
- Earliest claimed: 2003-01-22
- Assignees: InteliTrac, Inc.
- Inventors: Tianlong Chen; Jonathan Vu
- Web page: https://patentgrep.com/patent/US7318076B2

## CPC

- G06F 16/284: {Relational databases}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 11/1446: Point-in-time backing up or restoration of persistent data
- Y10S 707/99932: Access augmentation or optimizing
- Y10S 707/99937: Sorting
- Y10S 707/99944: Object-oriented database structure
- Y10S 707/99955: Archiving or backup
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

A comprehensive Memory-Resident Database Management System architecture and implementation is disclosed where a) all data storage in database is in memory, b) all database management functionality is in memory except backup and recovery storage based on hard disk, c) all database objects including tables, views, triggers, procedures, functions . . . are in memory, d) all data security is at memory level, e) all data indexed, sorted and searched based on the selected search algorithms are in memory, f) all logging functionality to refresh in-between transactions reside in memory. Therefore, the processing speed of database query will take advantage of speed of RAM (Random Access Memory) without sacrifice any speed losing on Hard disk I/O. Not only the whole database is running in RAM, but also all or pre-selected database table columns are default to be indexed. All internal processing of database query is based on indexed columns.

## Claims

### Claim 1

A method for configuring a memory-resident database comprising the steps of:
creating and managing a memory pool;
building a data memory structure using a relative memory address;
creating a database object in memory;
importing data from an external database into said database object based on a set of configuration parameters;
repeating said creating a database object and importing data steps for substantially all data in said external database;
indexing, sorting, and categorizing all imported data during the importing process;
executing substantially all queries directly from memory;
backing up data, data objects and data memory structure to one of other memory or nonvolatile storage; and
restoring backed-up data, data objects and data memory structure from said one of other memory or said nonvolatile storage.

### Claim 2 (depends on 1)

A method for configuring a memory-resident database according to claim 1 wherein said set of configuration parameters comprises at least one of data types, data sizes, indexing, and memory page size.

### Claim 3 (depends on 1)

A method for configuring a memory-resident database according to claim 1 wherein said external database is not a said memory-resident database and the speed of said restoring a said memory-resident database is substantially faster than that of said importing from a said external database.