QAGen:根据真实场景生成数据库测试数据丨DB Paper Reading 线上直播
DB Paper Reading 这周继续来营业啦!我们希望通过对业界学术论文的分享,带大家了解数据库学术界最新的研究方向。6 月 16 日晚 PingCAP 研发工程师韩飞将为大家解读 QAGen: Generating query-aware test databases。该论文使用一种符号化的计算方式,根据真实的数据库 Schema 和 Query 模拟生成数据库测试数据。感兴趣的朋友不要错过,赶紧报名约起来~
直播季
PingCAP Paper Reading
时间:2021 年 6 月 16 日晚 19:00-20:00
19:00 - 20:00
QAGen: Generating query-aware test databases
PingCAP 研发工程师
韩飞
专注于 SQL 优化器和执行器
Content:
PingCAP 研发工程师韩飞将为大家解读 QAGen: Generating query-aware test databases。该论文使用一种符号化的计算方式,根据真实的数据库 Schema 和 Query 模拟生成数据库测试数据。
Today, a common methodology for testing a database management system (DBMS) is to generate a set of test databases and then execute queries on top of them. However, for DBMS testing, it would be a big advantage if we can control the input and/or the output (e.g., the cardinality) of each individual operator of a test query for a particular test case. Unfortunately, current database generators generate databases independent of queries. As a result, it is hard to guarantee that executing the test query on the generated test databases can obtain the desired (intermediate) query results that match the test case. In this paper, we propose a novel way for DBMS testing. Instead of first generating a test database and then seeing how well it matches a particular test case (or otherwise use a trial-and-error approach to generate another test database), we propose to generate a query-aware database for each test case. To that end, we designed a query-aware test database generator called QAGen. In addition to the database schema and the set of basic constraints defined on the base tables, QAGen takes the query and the set of constraints defined on the query as input, and generates a query-aware test database as output. The generated database guarantees that the test query can get the desired (intermediate) query results as defined in the test case. This approach of testing facilitates a wide range of DBMS testing tasks such as testing of memory managers and testing the cardinality estimation components of query optimizers.
报名方式:扫描二维码即可参与报名~
关注公众号:拾黑(shiheibook)了解更多
[广告]赞助链接:
四季很好,只要有你,文娱排行榜:https://www.yaopaiming.com/
让资讯触达的更精准有趣:https://www.0xu.cn/
随时掌握互联网精彩
- 1 钓鱼台漫步和意悠长 4967040
- 2 小龙虾身价暴跌 4915461
- 3 儿子讲述父亲疑被当猎物枪杀 4852619
- 4 4.0版消博会 外资看中三个“新” 4752020
- 5 大姐先被五步蛇咬后被蜱虫叮险丧命 4608289
- 6 姑父强奸猥亵侄女7年被判13年 4550251
- 7 11岁男孩被教训后举报爷爷有枪 4446128
- 8 老人在成都居家4个月燃气费1.5万 4383901
- 9 福州发生重大航空器事故系谣言 4209953
- 10 社保专家谈调整养老金领取年龄 4176695