Memory-resident database management system and implementation thereof

• US 20040143562A1
• Filed: 01/22/2003
• Published: 07/22/2004
• Est. Priority Date: 01/22/2003
• Status: Active Grant

• Current Assignee: InteliTrac, Inc.
• Original Assignee: InteliTrac, Inc.
• Inventors: Chen, Tianlong, Vu, Jonathan
• Granted Patent: US 7,318,076 B2
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 11/1446 Point-in-time backing up or restoration of persistent data
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99955 Archiving or backup

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

1. A system for managing a database, said database comprising database objects and data, comprising:

a processor; and

a system memory;

wherein substantially all of said database objects and data are stored in said memory.

2. A system for managing a database according to claim 1 wherein said system memory comprises:

a first memory on a first device; and

a second memory on a second device.

3. A system for managing a database, said database comprising database objects and data comprising:

a plurality of devices, each said device comprising a processor and a memory;

wherein substantially all of said database objects and data are stored in said plurality of device memories.

4. A method for managing a database, said database comprising database objects and data, said method comprising the steps of:

storing substantially all of said database objects and data in said database in memory; and

performing substantially all database operations on said database objects and data in said memory.

5. A method according to claim 4 wherein said operations comprise queries.

6. A method according to claim 4 wherein said operations comprise at least one of:

user creation;

assign and access privilege; and

create and execute database triggers, functions, procedures or packages.

7. A method according to claim 4 wherein said operations comprise at least one operation other than a query.

8. A method according to claim 4 wherein said database comprises a relational database.

9. A method according to claim 4 wherein said database comprises an object database.

10. A method for configuring a memory-resident database comprising the steps of:

creating a database object in memory;

importing data from an external database into said database object based on a set of configuration parameters; and

indexing, sorting, and categorizing all imported data during the importing process;

executing substantially all queries directly from memory.

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