Hybrid In-Memory/Out-of-core Database Management Systems
Real applications do not always allow keeping the whole data set in memory, forcing the systems to combine in-memory and out-of-core techniques, or even, sometimes, to swap from in-memory to out-of-core in some cases. In this situation, access methods become especially important since they allow mapping the actual storage of data to the real access of the operations performed on the records processed. A proper mapping of the access methods for both in-memory and out-of-core DBMS storage would allow increasing the memory locality in both situations, improving the throughput of DBMSs as an average.
Actually we are working along with IBM, with a CAS grant, on the use of the memory hierarchy for in-core and out-of-core DBMSs, taking a special look at SolidDB as a specific example. We will work on access methods that are respectful with in-memory and out-of-core data, paying also attention to the mapping of the access methods to the memory hierarchy. The importance of multicore processing power will be cared for because there is an important synergy between the ways data are managed in the memory hierarchy and the way processors access the data.
People involved in the project
PhD student: Joan Guisado-Gámez
PhD Advisor: Victor Muntés-Mulero & Josep Lluís Larriba Pey