Scalable Database Management Software on a Cluster of Nodes Using a Shared-Distributed Flash Memory

A computer-program product comprising:

• a computer-readable storage medium having computer-executable program code means tangibly embodied therein, which when executed on a computing device manages a distributed database stored across multiple nodes of flash memory, the computer-executable storage program code means in the computer-program product comprising:
• query processing means for processing a database query received from a user, the database query specifying a target database record in a database;
• local buffer cache means for storing cached database records in a volatile memory;
• table reader means for reading the target database record from the local buffer cache means when a hit occurs;
• table writer means for writing to the target database record in the local buffer cache means when a hit occurs and the target database record is in the local buffer cache means;
• Sharing Data Fabric (SDF) thread means, activated by a GET command from the table reader means when the hit does not occur in the local buffer cache means, for sending a request message over an interconnect from a first node to a target storage node in a plurality of nodes, and for identifying the target storage node using an identifier of the target database record;
• storage thread means, executing on the target storage node, for reading the target database record from the flash memory at the target storage node that stores a portion of the database, and for sending the target database record over the interconnect to the SDF thread means on the first node;
• and
• miss loader means, in the SDF thread means, for receiving the target database record from the target storage node over the interconnect, and for writing the target database record into the local buffer cache means, and for activating the table reader means to read the target database record as a hit,
• whereby the target database record is retrieved from the target storage node using the SDF thread means transparently to the table reader means.