NDLI: The implementation of flash-aware buffer replacement algorithms in PostgreSQL

Content Provider	IEEE Xplore Digital Library
Author	Zhengdong Xia Tianming Bu
Copyright Year	2015
Description	Author affiliation: Shanghai Key Lab. of Trustworthy Comput., East China Normal Univ., Shanghai, China (Zhengdong Xia; Tianming Bu)
Abstract	Flash memory is growing maturer in technology, larger in capacity and cheaper in price. Many companys begin to use flash-based solid state disk instead of magnetic disk nowadays. Moreover, personal computers such as macbook, are using flash-based solid state disks. On account of the different characteristics between flash-based solid state disk and magnetic disk, more and more researchers begin to design the algorithms for flash-based database. PostgreSQL is the most famous opensource database, but PostgreSQL is aimed at magnetic disk currently. In this paper, we implement the CF-LRU, CCF-LRU, CCCF-LRU algorithms and integrate them into PostgreSQL. Finally, we use BenchmarkSQL to do the performance tests. The experiment results show that the performance of PostgreSQL using CF-LRU, CCF-LRU or CCCF-LRU is better than PostgreSQL using original algorithm when PostgreSQL is running in a flash-based solid state disk.
Starting Page	1215
Ending Page	1219
File Size	488809
Page Count	5
File Format	PDF
e-ISBN	9781467376822
DOI	10.1109/FSKD.2015.7382115
Language	English
Publisher	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Publisher Date	2015-08-15
Publisher Place	China
Access Restriction	Subscribed
Rights Holder	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Subject Keyword	Algorithm design and analysis solid state disk Databases flash-based database PostgreSQL Benchmark testing Solids buffer replacement algorithm High definition video Flash memories Clocks
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

2QW-Clock: An Efficient SSD Buffer Management Algorithm

Flash-Aware Buffer Management for Database Systems

Cost-Based Buffer Management Algorithm for Flash Database Systems

Considering block popularity in disk cache replacement for enhancing hit ratio with solid state drive

A buffer replacement algorithm exploiting multi-chip parallelism in solid state disks

Improving flash-based disk cache with Lazy Adaptive Replacement

ACR: An Adaptive Cost-aware Buffer Replacement Algorithm for Flash Storage Devices (2010)

CFDC: A Flash-aware Replacement Policy for Database Buffer Management (2009)

LDPC Soft Decoding with Reduced Power and Latency in 1X-2X NAND Flash-Based Solid State Drives

The implementation of flash-aware buffer replacement algorithms in PostgreSQL

Similar Documents

2QW-Clock: An Efficient SSD Buffer Management Algorithm

Flash-Aware Buffer Management for Database Systems

Cost-Based Buffer Management Algorithm for Flash Database Systems

Considering block popularity in disk cache replacement for enhancing hit ratio with solid state drive

A buffer replacement algorithm exploiting multi-chip parallelism in solid state disks

Improving flash-based disk cache with Lazy Adaptive Replacement

ACR: An Adaptive Cost-aware Buffer Replacement Algorithm for Flash Storage Devices (2010)

CFDC: A Flash-aware Replacement Policy for Database Buffer Management (2009)

LDPC Soft Decoding with Reduced Power and Latency in 1X-2X NAND Flash-Based Solid State Drives

The implementation of flash-aware buffer replacement algorithms in PostgreSQL