Method and apparatus for implementing and using an alternate database engine with existing database engine

An apparatus for processing a database command, comprising:

• a processor;
• and
• a memory in operative communication with the processor, the memory for storing a plurality of processing instructions for directing the processor to:
• receive, from a user, a database command requiring data from a first database engine, the first database engine having a command layer for processing database commands;
• and
• process the database command using only a command layer of an alternate database engine without accessing the command layer of the first database engine.

A method for implementing and using an alternate database engine in conjunction with an established database engine, the method comprising:

• providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands;
• establishing an alternate database engine on the computing system;
• receiving a database command from one of the plurality of users, the database command directed to data stored by the first database engine;
• and
• processing the database command using only the alternate database engine without accessing the command layer of the first database engine.

An apparatus for implementing and using an alternate database engine in conjunction with an established database engine, comprising:

• means for providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands;
• means for establishing an alternate database engine on the computing system;
• means for receiving a database command from one of the plurality of users, the database command directed to data stored by the first database engine;
• and
• means for processing the database command using only the alternate database engine without accessing the command layer of the first database engine.

An apparatus for implementing and using an alternate database engine in conjunction with an established database engine, comprising:

• a processor;
• and
• a memory in operative communication with the processor, the memory for storing a plurality of processing instructions directing the processor to:
• provide access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands;
• establish an alternate database engine on the computing system;
• receive a database command from one of the plurality of users, the database command directed to data stored by the first database engine;
• and
• process the database command using only the alternate database engine without accessing the command layer of the first database engine.

A computer-readable medium encoded with processing instructions for performing a method of implementing and using an alternate database engine in conjunction with an established database engine, the method comprising:

• providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands;
• establishing an alternate database engine on the computing system;
• receiving a database command from one of the plurality of users, the database command directed to data stored by the first database engine;
• and
• processing the database command using only the alternate database engine without accessing the command layer of the first database engine.

A method for implementing and using an alternate database engine in conjunction with an established database engine, the method comprising:

• providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands, the first database engine further maintaining a first database file including first data;
• establishing an alternate database engine on the computing system, the alternate database engine maintaining a second database file including second data;
• receiving a database command from one of the plurality of users, the database command directed to at least one of said first and second data;
• and
• processing the database command using only the alternate database engine without accessing the command layer of the first database engine.

An apparatus for implementing and using an alternate database engine in conjunction with an established database engine, comprising:

• means for providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands, the first database engine further maintaining a first database file including first data;
• means for establishing an alternate database engine on the computing system, the alternate database engine maintaining a second database file including second data;
• means for receiving a database command from one of the plurality of users, the database command directed to at least one of said first and second data;
• and
• means for processing the database command using only the alternate database engine without accessing the command layer of the first database engine.

An apparatus for implementing and using an alternate database engine in conjunction with an established database engine, comprising:

• a processor;
• and
• a memory in operative communication with the processor, the memory for storing a plurality of processing instructions directing the processor to:
• provide access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands, the first database engine further maintaining a first database file including first data;
• establish an alternate database engine on the computing system, the alternate database engine maintaining a second database file including second data;
• receive a database command from one of the plurality of users, the database command directed to at least one of said first and second data;
• and
• process the database command using only the alternate database engine without accessing the command layer of the first database engine.

A computer-readable medium encoded with processing instructions for performing a method of implementing and using an alternate database engine in conjunction with an established database engine, the method comprising:

• providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands, the first database engine further maintaining a first database file including first data;
• establishing an alternate database engine on the computing system, the alternate database engine maintaining a second database file including second data;
• receiving a database command from one of the plurality of users, the database command directed to at least one of said first and second data;
• and
• processing the database command using only the alternate database engine without accessing the command layer of the first database engine.

A method for implementing and using an alternate database engine in conjunction with an established database engine, the method comprising:

• providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands;
• establishing an alternate database engine on the computing system;
• receiving a read-only database command from one of the plurality of users, the read-only database command directed to data stored by the first database engine;
• and
• processing the database command using only the alternate database engine without accessing the command layer of the first database engine, wherein the alternate database engine executes read-only database commands.

A method for implementing and using an alternate database engine in conjunction with an established database engine, the method comprising:

• providing access to a first database engine to a plurality of users on a computing system, the first database engine having a command layer for processing database commands, the first database engine further maintaining a first database file including first data;
• establishing an alternate database engine on the computing system, the alternate database engine maintaining a second database file including second data;
• receiving a read-only database command from one of the plurality of users, the read-only database command directed to at least one of said first and second data;
• and
• processing the database command using only the alternate database engine without accessing the command layer of the first database engine, wherein the alternate database engine executes only read-write database commands.

A method for processing a database command, performed by an alternate database engine, the method comprising:

• receiving, from a user, a database command directed to a first database engine, the first database engine having a command layer for processing database commands;
• processing the database command using only a command layer of the alternative database engine without accessing the command layer of the first database engine, said processing further comprising:
• evaluating the database command to determine system usage of the query at the database engine, prior to execution of the database command, said evaluating based on at least one of:
• a parameter of the, a number of relational databases for the database command, a size of a data field to be searched for the database command, an availability of resources of the database engine, a number of relational database tables to be employed for the database command, a limitation imposed on a size of a query result set, a number of columns of data to be returned in a query result set, a cost of a similar stored database command and a number of function calls for the database command;
• determining a threshold value for system usage of the alternate database engine, wherein the threshold value is based on at least one of:
• estimated processor usage, estimated memory usage, input/output resource usage and disk resource usage of the alternate database engine;
• if the system usage surpasses a threshold value, performing at least one of the following:
• submitting the database command to the alternate database engine with a limit on a number of returns responsive to the database command, editing the database command, and rejecting the database command;
• determining whether the database command requires accessing data maintained by the first database engine, and if not, accessing second data stored only by the alternate database engine;
• determining whether the database command requires accessing temporally sensitive data, and if so, accessing a transaction log of the first database engine;
• translating the database command to a native format of the alternate database engine;
• generating a result of the database command;
• and
• transmitting the result to the user in a format of the first database engine.