A priority-based data placement method for databases using solid-state drives

CH Wu, CW Huang, CY Chang - … of the 2018 Conference on Research …, 2018 - dl.acm.org
When applications require high I/O performance, solid-state drives (SSDs) are often
preferable because they perform better than traditional hard-disk drives (HDDs). Therefore …

A data management method for databases using hybrid storage systems

CH Wu, CW Huang, CY Chang - ACM SIGAPP Applied Computing …, 2019 - dl.acm.org
When applications require high I/O performance, solid-state drives (SSDs) are often
preferable because they perform better than traditional hard-disk drives (HDDs). Therefore …

Record placement based on data skew using solid state drives

J Suzuki, S Venkataraman, S Agarwal… - Workshop on Big Data …, 2014 - Springer
Integrating a solid state drive (SSD) into a data store is expected to improve its I/O
performance. However, there is still a large difference between the price of an SSD and a …

Effective Use of SSDs in Database Systems

P Ghodsnia - 2018 - uwspace.uwaterloo.ca
With the advent of solid state drives (SSDs), the storage industry has experienced a
revolutionary improvement in I/O performance. Compared to traditional hard disk drives …

Optimizing databases by learning hidden parameters of solid state drives

A Kakaraparthy, JM Patel, K Park… - Proceedings of the VLDB …, 2019 - dl.acm.org
Solid State Drives (SSDs) are complex devices with varying internal implementations,
resulting in subtle differences in behavior between devices. In this paper, we demonstrate …

SSD-Aware Temporary Data Management Policy for Improving Query Performance

Z Guo, J Wang, C Wang, X Meng - … , WAIM 2014, Macau, China, June 16 …, 2014 - Springer
As data volume grows rapidly and queries become more complex, database engine has to
deal with larger amount of temporary data when performing operators such as sort and join …

Bt-Join: a join operator for asymmetric storage device

NL Evangelista, J de Aguiar M. Filho… - Proceedings of the 30th …, 2015 - dl.acm.org
Nowadays the use of solid state drives (SSDs) is a reality for storing large databases. SSDs
are capable to provide IOPS rates up to three orders of magnitude greater than the rates …

Parallel I/O aware query optimization

P Ghodsnia, IT Bowman, A Nica - Proceedings of the 2014 ACM …, 2014 - dl.acm.org
New trends in storage industry suggest that in the near future a majority of the hard disk
drive-based storage subsystems will be replaced by solid state drives (SSDs). Database …

An object placement advisor for DB2 using solid state storage

M Canim, GA Mihaila, B Bhattacharjee… - Proceedings of the …, 2009 - dl.acm.org
Solid state disks (SSDs) provide much faster random access to data compared to
conventional hard disk drives. Therefore, the response time of a database engine could be …

Workload-Driven Data Placement for Tierless In-Memory Database Systems

B Hurdelhey, M Weisgut, M Boissier - 2023 - dl.gi.de
High main memory consumption is a significant cost factor for in-memory database systems.
Tiering, ie, placing parts of the data on memory or storage devices other than DRAM …