Method and system for high performance transaction processing using a relational database management system

摘要

An approach for optimizing a database management system is disclosed. A summary table that is used to generate a plurality of tables is stored in a solid state disk. The plurality of tables are stored in the memory of a database server. In addition, a transaction log associated with the plurality of tables are stored on the solid state disk. According to one embodiment of the present invention, this approach is applied to a connection management system in a satellite communication system, wherein the connection management utilizes a relational database to track the communication connections.