Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management最新文献

Research challenges in deep reinforcement learning-based join query optimization 基于深度强化学习的连接查询优化研究挑战

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management Pub Date : 2020-06-14 DOI: 10.1145/3401071.3401657

R. Guo, Khuzaima S. Daudjee

引用次数: 13

Bandit join: preliminary results 土匪加入:初步结果

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management Pub Date : 2020-06-14 DOI: 10.1145/3401071.3401655

Vahid Ghadakchi, Mian Xie, Arash Termehchy

引用次数: 4

Best of both worlds: combining traditional and machine learning models for cardinality estimation 两全其美:结合传统和机器学习模型进行基数估计

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management Pub Date : 2020-06-14 DOI: 10.1145/3401071.3401658

Lucas Woltmann, Claudio Hartmann, Dirk Habich, Wolfgang Lehner

{"title":"Best of both worlds: combining traditional and machine learning models for cardinality estimation","authors":"Lucas Woltmann, Claudio Hartmann, Dirk Habich, Wolfgang Lehner","doi":"10.1145/3401071.3401658","DOIUrl":"https://doi.org/10.1145/3401071.3401658","url":null,"abstract":"Cardinality estimation is a high-profile technique in database management systems with a serious impact on query performance. Thus, a lot of traditional approaches such as histograms-based or sampling-based methods have been developed over the last decades. With the advance of Machine Learning (ML) into the database world, cardinality estimation profits from several methods improving its quality as shown in different recent papers. However, neither an ML model nor a traditional approach meets all requirements for cardinality estimation, so that a one size fits all approach is difficult to imagine. For that reason, we advocate a better interlacing of ML models and traditional approaches for cardinality estimation and thoroughly consider their potential, advantages, and disadvantages in this paper. We start by proposing a classification of different estimation techniques and their usability for cardinality estimation. Then, we motivate a novel hybrid approach as the core proof of concept of this paper which uses the best of both worlds: ML models and the proven histogram approach. For this, we show in which cases it is beneficial to use ML models or when we can trust the traditional estimators. We evaluate our hybrid approach on two real-world data sets and conclude what can be done to improve the coexistence of traditional and ML approaches in DBMS. With all our proposals, we use ML to improve DBMS without abandoning years of valuable research in cardinality estimation.","PeriodicalId":371439,"journal":{"name":"Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","volume":"52 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2020-06-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"131830698","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 5

PartLy 部分

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management Pub Date : 2020-06-14 DOI: 10.1145/3401071.3401660

A. S. Abdelhamid, Walid G. Aref

引用次数: 3

Automated tuning of query degree of parallelism via machine learning 通过机器学习自动调优查询并行度

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management Pub Date : 2020-06-14 DOI: 10.1145/3401071.3401656

Zhiwei Fan, Rathijit Sen, Paraschos Koutris, Aws Albarghouthi

引用次数: 9

RadixSpline: a single-pass learned index RadixSpline:单次学习索引

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management Pub Date : 2020-04-30 DOI: 10.1145/3401071.3401659

Andreas Kipf, Ryan Marcus, Alexander van Renen, Mihail Stoian, A. Kemper, Tim Kraska, Thomas Neumann

引用次数: 112

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management 第三届利用人工智能技术进行数据管理国际研讨会论文集

Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management Pub Date : 1900-01-01 DOI: 10.1145/3401071

引用次数: 1