13 papers · ranked by Valyu relevance
Victor Giannakouris, Immanuel Trummer
Analytical workloads operating on data stored in external database systems face a fundamental bottleneck: data access is guarded entirely by the database driver, like JDBC or ODBC, forcing all reads through query execution and other driver layers that are not designed for bulk columnar analytics. We present Jailbreak…
M. Nissan
Database audit and transaction logs are fundamental to forensic investigations, but they are vulnerable to tampering by privileged attackers. Malicious insiders or external threats with administrative access can alter, purge, or temporarily disable logging mechanisms, creating significant blind spots and rendering…
Lin, Shu, Marathe, Arunprasad P. + 10 more
—Huawei's cloud-native database system GaussDB for MySQL (also known as Taurus) stores data in a separate storage layer consisting of a pool of storage servers. Each server has considerable compute power making it possible to push data reduction operations (selection, projection, and aggregation) close to storage. This…
Yu Liang, Hong Hu
In this paper, we propose ParserFuzz, a novel fuzzing framework that automatically extracts grammar rules from DBMSs' built-in syntax definition files for SQL query generation. Without any input corpus, ParserFuzz can generate diverse query statements to saturate the grammar features of the tested DBMSs, which grammar…
Shuang Liu, Chenglin Tian, Jun Sun, Ruifeng Wang + 5 more
'Yongxin Zhao' 'Yinxing Xue' 'Junjie Wang' 'Xiaoyong Du'] Abstract—A Relational Database Management System (RDBMS) is one of the fundamental software that supports a wide range of applications, making it critical to identify bugs within these systems. There has been active research on testing RDBMS, most of which…
Shian Zhong, Manuel Rigger
Database Management System (DBMS) developers have implemented extensive test suites to test their DBMSs. For example, the SQLite test suites contain over 92 million lines of code. Despite these extensive efforts, test suites are not systematically reused across DBMSs, leading to wasted effort. Integration is…
S.-K. Chen, Ju Fan, Bin Wu, Nan Tang + 7 more
Language Models Authors: ['S.-K. Chen' 'Ju Fan' 'Bin Wu' 'Nan Tang' 'Chao Deng' 'Ping Wang' 'Ye Li' 'Jian Tan' 'Feifei Li' 'Jingren Zhou' 'Xiaoyong Du'] Database management system (DBMS) configuration debugging, e.g., diagnosing poorly configured DBMS knobs and generating troubleshooting recommendations, is crucial in…
Aleem Akhtar
—Databases are considered to be integral part of modern information systems. Almost every web or mobile application uses some kind of database. Database management systems are considered to be a crucial element from both business and technological standpoint. This paper divides different types of database management…
Qiushi Bai, Sadeem Alsudais, Chen Li
SQL query performance is critical in database applications, and query rewriting is a technique that transforms an original query into an equivalent query with a better performance. In a wide range of database-supported systems, there is a unique problem where both the application and database layer are black boxes, and…
Zhimin Lin, Yifu Liu, Zhiling Luo, Jinyang Gao + 1 more
The ability to convert natural language into structured query language (SQL) has made it much easier to interact with relational database management systems. In recent years, the use of large language models (LLMs) has significantly improved SQL generation tasks [11, 19]. This shift has enhanced the quality of…
Yang, Xinyue, Zheng, Chen + 5 more
—Configuration tuning is critical for database performance. Although recent advancements in database tuning have shown promising results in throughput and latency improvement, challenges remain. First, the vast knob space makes direct optimization unstable and slow to converge. Second, reinforcement learning pipelines…
C. Zhang, Manuel Rigger
Logic bugs are bugs that can cause database management systems (DBMSs) to silently produce incorrect results for given queries. Such bugs are severe, because they can easily be overlooked by both developers and users, and can cause applications that rely on the DBMSs to malfunction. In this work, we propose…
Aristide Grange
database itself Authors: ['Aristide Grange'] SQL adventure builder (SQLab) is an open-source framework for creating SQL games that are embedded within the very database they query. Students' answers are evaluated using query fingerprinting, a novel technique that allows for better feedback than traditional SQL online…