Woon-Sul Seol

Hybrid transactional/analytical processing (HTAP) would overload database systems. To alleviate performance interference between transactions and analytics, recent research pursues the potential of in-storage processing (ISP) using commodity computational storage devices (CSDs). However, in-storage query processing faces technical challenges in HTAP environments. Continuously updated data versions pose two hurdles: (1) data items keep changing, and (2) finding visible data versions incurs excess

Journaling file systems (JFS), which base their architecture on traditional database logging, write journals sequentially through a form of centralized logging, primarily to restore file systems in the face of an unexpected failure. Due to the extra write operations required for journaling, the performance of the JFS is negatively impacted, thus suffering performance degradation. The fast non-volatile memory (NVM) was expected to easily address such performance issues by providing NVM space as s

Today's large data centers become cautious about its massive energy consumption. Range of efforts were made to reduce energy consumption from hardware to software level. Meanwhile, advance of technologies and engineering efforts makes flash-based drive an affordable option with higher capacity in the storage. Though this class of storage drive basically use less energy, the energy efficiency of I/O operation varies with different size of I/O requests. We observed that the energy efficiency is de

Cloud database management systems (DBMSs) often decouple database instances from physical storage to provide reliability and high availability to users. This design can robustly handle a single point of failure, but needs substantial effort to attain good performance. In this paper, we analyze the decoupled architecture and present important optimization issues that we faced in implementing the design. For implementing the prototyped system, we decouple MariaDB into a database instance and stora