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 …

Making cost-based query optimization asymmetry-aware

D Bausch, I Petrov, A Buchmann - Proceedings of the Eighth …, 2012 - dl.acm.org
The architecture and algorithms of database systems have been built around the properties
of existing hardware technologies. Many such elementary design assumptions are 20--30 …

Scan and join optimization by exploiting internal parallelism of flash-based solid state drives

W Lai, Y Fan, X Meng - … Conference, WAIM 2013, Beidaihe, China, June …, 2013 - Springer
Nowadays, flash-based solid state drives (SSDs) are gradually replacing hard disk drives
(HDDs) as the primary non-volatile storage in both desktop and enterprise applications …

[PDF][PDF] Do query optimizers need to be SSD-aware?

S Pelley, K LeFevre, TF Wenisch - ADMS@ VLDB, 2011 - adms-conf.org
Flash-based solid state disks (SSDs) are beginning to supplant conventional rotating disks
for performance-critical data in myriad DBMS applications, including decision support …

[PDF][PDF] Optimizing Database Operators by Exploiting Internal Parallelism of Solid State Drives.

Y Fan, W Lai, X Meng - IEEE Data Eng. Bull., 2014 - Citeseer
With the development of flash memory technology, flash-based solid state drives (SSDs) are
gradually used in more and more devices and applications. In addition to characteristics of …

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 …

[图书][B] Balancing vectorized query execution with bandwidth-optimized storage

M Żukowski - 2009 - dare.uva.nl
The continuous evolution of computer hardware in the past decades has resulted in a rapid
increase of available computing power. However, not all application areas benefited from …

Optimizing database index performance for solid state drives

SM Ash, KI Lin - Proceedings of the 18th International Database …, 2014 - dl.acm.org
As Solid State Disk (SSD) drive technology matures and costs continue to decrease, it is
becoming a viable replacement for traditional, rotational hard disk drives. SSDs are based …

Query processing techniques for solid state drives

D Tsirogiannis, S Harizopoulos, MA Shah… - Proceedings of the …, 2009 - dl.acm.org
Solid state drives perform random reads more than 100x faster than traditional magnetic
hard disks, while offering comparable sequential read and write bandwidth. Because of their …

Cheap data analytics using cold storage devices

R Borovica-Gajić, R Appuswamy… - Proceedings of the VLDB …, 2016 - dl.acm.org
Enterprise databases use storage tiering to lower capital and operational expenses. In such
a setting, data waterfalls from an SSD-based high-performance tier when it is" …