Memory-resident database management system and implementation thereof
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.
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.
2. 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.
3. 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.