DOI: 10.17587/prin.9.147-155

New Storage Devices and their Impact on Database Technology

S. D. Kuznetsov, kuzloc@ispras.ru, Ivannikov Institute for System Programming of the RAS, Moscow, 109004, Russian Federation, Lomonosov Moscow State University, Moscow, 119991, Russian Federation, Moscow Institute of Physics and Technology, Moscow Region, 141700, Russian Federation, Higher School of Economics, Moscow, 101000, Russian Federation

Corresponding author: Kuznetsov Sergey D., Senior Researcher, Ivannikov Institute for System Programming of the RAS, Moscow, 109004, Russian Federation, Lomonosov Moscow State University, Moscow, 119991, Russian Federation, Moscow Institute of Physics and Technology, Moscow Region, 141700, Russian Federation, Higher School of Economics, Moscow, 101000, Russian Federation, E-mail: kuzloc@ispras.ru

At the beginning of the paper, it is demonstrated that the technology of the most widely used SQL-oriented DBMS is inextricably linked with HDD technology. Features of HDD affect the data structures and algorithms for performing operations, methods of managing the buffer pool of the DBMS, transaction management, query optimization, etc. An alternative to a disk DBMS is an in-memory DBMS, storing databases entirely in the main memory. Despite the fact that in-memory DBMS has a number of advantages over disk DBMS, at present there is practically no competition. This, first of all, is due to natural limitations on the size of databases, inherent in in-memory DBMS. At present, new types of data storage hardware have appeared: SSD — block solid-state drives and SCM — storage-class memory (non-volatile main memory). SSD characteristics made it expedient to develop a DBMS in terms of their exclusive use, so far no such DBMS has been created, and SSDs are used simply instead of HDDs in DBMS that do not take their features into account. The availability of SCM allows one to radically simplify the architecture of the database and significantly improve their performance. To do this, you need to review many of the ideas used in disk-based databases.

Keywords: SQL-based DBMS; Hard Disk Drive with movable Heads; cost-based query optimization; main-memory DBMS; Flash-based Solid State Drive; non-volatile main memory; storage-class memory

pp. 147–155

For citation:
Kuznetsov S. D. New Storage Devices and their Impact on Database Technology, Programmnaya Ingeneria, 2018, vol. 9, no. 4, pp. 147—155.