{"title":"用深度强化学习学习分区建议器","authors":"Benjamin Hilprecht, Carsten Binnig, Uwe Röhm","doi":"10.1145/3329859.3329876","DOIUrl":null,"url":null,"abstract":"In this paper we introduce a partitioning advisor for analytical workloads based on Deep Reinforcement Learning. In contrast to existing approaches for automated partitioning design, an RL agent learns its decisions based on experience by trying out different partitionings and monitoring the rewards for different workloads. In our experimental evaluation with a distributed database and various complex schemata, we show that our learned partitioning advisor is thus not only able to find partitionings that outperform existing approaches for automated data partitioning but is also able to find non-obvious partitionings.","PeriodicalId":118194,"journal":{"name":"Proceedings of the Second International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","volume":"25 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2019-07-05","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"20","resultStr":"{\"title\":\"Towards learning a partitioning advisor with deep reinforcement learning\",\"authors\":\"Benjamin Hilprecht, Carsten Binnig, Uwe Röhm\",\"doi\":\"10.1145/3329859.3329876\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"In this paper we introduce a partitioning advisor for analytical workloads based on Deep Reinforcement Learning. In contrast to existing approaches for automated partitioning design, an RL agent learns its decisions based on experience by trying out different partitionings and monitoring the rewards for different workloads. In our experimental evaluation with a distributed database and various complex schemata, we show that our learned partitioning advisor is thus not only able to find partitionings that outperform existing approaches for automated data partitioning but is also able to find non-obvious partitionings.\",\"PeriodicalId\":118194,\"journal\":{\"name\":\"Proceedings of the Second International Workshop on Exploiting Artificial Intelligence Techniques for Data Management\",\"volume\":\"25 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2019-07-05\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"20\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the Second International Workshop on Exploiting Artificial Intelligence Techniques for Data Management\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3329859.3329876\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the Second International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3329859.3329876","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Towards learning a partitioning advisor with deep reinforcement learning
In this paper we introduce a partitioning advisor for analytical workloads based on Deep Reinforcement Learning. In contrast to existing approaches for automated partitioning design, an RL agent learns its decisions based on experience by trying out different partitionings and monitoring the rewards for different workloads. In our experimental evaluation with a distributed database and various complex schemata, we show that our learned partitioning advisor is thus not only able to find partitionings that outperform existing approaches for automated data partitioning but is also able to find non-obvious partitionings.