Design of Flash-Based DBMS: An In-Page Logging Approach

Summary: Proposes in-page logging (IPL) for flash-memory DBMS to mitigate high write latency and exploit flash characteristics for better performance. Demonstrates empirical gains over disk-based designs and shows IPL can be extended to support full transactional recovery. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3901
Venue: SIGMOD
Year: 2007
Pagerank: 0.00017615543
Overall Rank: 488 | 96.66%
DOI: 10.1145/1247480.1247488

Incoming Non-self Citations Over Time

Authors

1. Sang-Won Lee (Sungkyunkwan University)
2. Bongki Moon (University of Arizona)

BibTeX Citation

@inproceedings{lee_sigmod07,
        title = {{Design of Flash-Based DBMS: An In-Page Logging Approach}},
        author = {Lee, Sang-Won and Moon, Bongki},
        series = {{SIGMOD} '07},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1247480.1247488},
        url = {https://dl.acm.org/doi/10.1145/1247480.1247488},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 30 of 30 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
512	Tree Indexing on Solid State Drives	2010	VLDB	0.00017196795
561	A Case for Flash Memory SSD in Enterprise Database Applications	2008	SIGMOD	0.00016525248
961	Lazy-Adaptive Tree: An Optimized Index Structure for Flash Devices	2009	VLDB	0.00012941098
999	Flashing Up the Storage Layer	2008	VLDB	0.00012740138
1,105	FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance	2009	SIGMOD	0.00012151254
1,130	Query Processing on Smart SSDs: Opportunities and Challenges	2013	SIGMOD	0.00012052236
1,311	uFLIP: Understanding Flash IO Patterns	2009	CIDR	0.00011207712
1,435	Online Maintenance of Very Large Random Samples on Flash Storage	2008	VLDB	0.00010800274
1,455	Query Processing Techniques for Solid State Drives	2009	SIGMOD	0.00010733981
1,461	LLAMA: A Cache/Storage Subsystem for Modern Hardware	2013	VLDB	0.00010703712
2,661	LazyFTL: A Page-level Flash Translation Layer Optimized for NAND Flash Memory	2011	SIGMOD	8.2842959e-05
2,906	Optimizing Optimistic Concurrency Control for Tree-Structured, Log-Structured Databases	2015	SIGMOD	7.9741374e-05
3,055	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.8079566e-05
3,095	Turbocharging DBMS Buffer Pool Using SSDs	2011	SIGMOD	7.7641876e-05
3,747	B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives	2012	VLDB	7.1555585e-05
4,870	Optimistic Concurrency Control by Melding Trees	2011	VLDB	6.4709622e-05
4,893	Page-Differential Logging: An Efficient and DBMS-Independent Approach for Storing Data into Flash Memory	2010	SIGMOD	6.4565717e-05
5,144	Data Management Over Flash Memory	2011	SIGMOD	6.3473454e-05
5,165	Advances in Flash Memory SSD Technology for Enterprise Database Applications	2009	SIGMOD	6.3371139e-05
5,831	Operation-Aware Buffer Management in Flash-based Systems	2011	SIGMOD	6.0733385e-05
6,949	SQLite Optimization with Phase Change Memory for Mobile Applications	2015	VLDB	5.7306218e-05
7,525	Towards Cost-Effective Storage Provisioning for DBMSs	2012	VLDB	5.6029996e-05
7,935	System Co-Design and Data Management for Flash Devices	2011	VLDB	5.5181056e-05
10,197	ART That Lasts: Persistent Multiversion Adaptive Radix Trees with Fast Atomic Range Queries	2026	SIGMOD	5.093636e-05
10,543	How to Write to SSDs	2026	VLDB	5.093636e-05
10,659	Boosting OLTP Performance with Per-Page Logging on NVDIMM	2025	SIGMOD	5.093636e-05
11,575	In-Page Shadowing and Two-Version Timestamp Ordering for Mobile DBMSs	2022	VLDB	5.093636e-05
11,977	From In-Place Updates to In-Place Appends: Revisiting Out-of-Place Updates on Flash	2017	SIGMOD	5.093636e-05
12,460	Secure Personal Data Servers: a Vision Paper	2010	VLDB	5.093636e-05
13,693	IPL-P: In-Page Logging with PCRAM	2011	VLDB	-

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
99	The Design of the POSTGRES Storage System	1987	VLDB	0.00034506601
1,731	Write-Optimized B-Trees	2004	VLDB	9.9081882e-05
1,881	PicoDBMS: Scaling down Database Techniques for the Smartcard	2000	VLDB	9.5516239e-05
3,120	LGeDBMS: a Small DBMS for Embedded System with Flash Memory	2006	VLDB	7.73635e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,120	LGeDBMS: a Small DBMS for Embedded System with Flash Memory	2006	VLDB
2	841	Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems	2015	SIGMOD
3	999	Flashing Up the Storage Layer	2008	VLDB
4	1,258	Managing Non-Volatile Memory in Database Systems	2018	SIGMOD
5	1,480	Write-Behind Logging	2017	VLDB
6	1,105	FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance	2009	SIGMOD
7	13,693	IPL-P: In-Page Logging with PCRAM	2011	VLDB
8	561	A Case for Flash Memory SSD in Enterprise Database Applications	2008	SIGMOD
9	7,422	Flash Device Support for Database Management	2011	CIDR
10	4,893	Page-Differential Logging: An Efficient and DBMS-Independent Approach for Storing Data into Flash Memory	2010	SIGMOD