{"title":"具有灵活性能 SLA 和价格的无服务器查询处理","authors":"Haoqiong Bian, Dongyang Geng, Yunpeng Chai, Anastasia Ailamaki","doi":"arxiv-2409.01388","DOIUrl":null,"url":null,"abstract":"Serverless query processing has become increasingly popular due to its\nauto-scaling, high elasticity, and pay-as-you-go pricing. It allows cloud data\nwarehouse (or lakehouse) users to focus on data analysis without the burden of\nmanaging systems and resources. Accordingly, in serverless query services,\nusers become more concerned about cost-efficiency under acceptable performance\nthan performance under fixed resources. This poses new challenges for\nserverless query engine design in providing flexible performance service-level\nagreements (SLAs) and cost-efficiency (i.e., prices). In this paper, we first define the problem of flexible performance SLAs and\nprices in serverless query processing and discuss its significance. Then, we\nenvision the challenges and solutions for solving this problem and the\nopportunities it raises for other database research. Finally, we present\nPixelsDB, an open-source prototype with three service levels supported by\ndedicated architectural designs. Evaluations show that PixelsDB reduces\nresource costs by 65.5% for near-real-world workloads generated by Cloud\nAnalytics Benchmark (CAB) while not violating the pending time guarantees.","PeriodicalId":501123,"journal":{"name":"arXiv - CS - Databases","volume":"95 1","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2024-09-02","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Serverless Query Processing with Flexible Performance SLAs and Prices\",\"authors\":\"Haoqiong Bian, Dongyang Geng, Yunpeng Chai, Anastasia Ailamaki\",\"doi\":\"arxiv-2409.01388\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Serverless query processing has become increasingly popular due to its\\nauto-scaling, high elasticity, and pay-as-you-go pricing. It allows cloud data\\nwarehouse (or lakehouse) users to focus on data analysis without the burden of\\nmanaging systems and resources. Accordingly, in serverless query services,\\nusers become more concerned about cost-efficiency under acceptable performance\\nthan performance under fixed resources. This poses new challenges for\\nserverless query engine design in providing flexible performance service-level\\nagreements (SLAs) and cost-efficiency (i.e., prices). In this paper, we first define the problem of flexible performance SLAs and\\nprices in serverless query processing and discuss its significance. Then, we\\nenvision the challenges and solutions for solving this problem and the\\nopportunities it raises for other database research. Finally, we present\\nPixelsDB, an open-source prototype with three service levels supported by\\ndedicated architectural designs. Evaluations show that PixelsDB reduces\\nresource costs by 65.5% for near-real-world workloads generated by Cloud\\nAnalytics Benchmark (CAB) while not violating the pending time guarantees.\",\"PeriodicalId\":501123,\"journal\":{\"name\":\"arXiv - CS - Databases\",\"volume\":\"95 1\",\"pages\":\"\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2024-09-02\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"arXiv - CS - Databases\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/arxiv-2409.01388\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"arXiv - CS - Databases","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/arxiv-2409.01388","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Serverless Query Processing with Flexible Performance SLAs and Prices
Serverless query processing has become increasingly popular due to its
auto-scaling, high elasticity, and pay-as-you-go pricing. It allows cloud data
warehouse (or lakehouse) users to focus on data analysis without the burden of
managing systems and resources. Accordingly, in serverless query services,
users become more concerned about cost-efficiency under acceptable performance
than performance under fixed resources. This poses new challenges for
serverless query engine design in providing flexible performance service-level
agreements (SLAs) and cost-efficiency (i.e., prices). In this paper, we first define the problem of flexible performance SLAs and
prices in serverless query processing and discuss its significance. Then, we
envision the challenges and solutions for solving this problem and the
opportunities it raises for other database research. Finally, we present
PixelsDB, an open-source prototype with three service levels supported by
dedicated architectural designs. Evaluations show that PixelsDB reduces
resource costs by 65.5% for near-real-world workloads generated by Cloud
Analytics Benchmark (CAB) while not violating the pending time guarantees.