Matches in SemOpenAlex for { <https://semopenalex.org/work/W2985275869> ?p ?o ?g. }
- W2985275869 abstract "Database administrators (DBAs) were traditionally responsible for optimizing the on-premise database workloads. However, with the rise of cloud data services, where cloud providers offer fully managed data processing capabilities, the role of a DBA is completely missing. At the same time, optimizing query workloads is becoming increasingly important for reducing the total costs of operation and making data processing economically viable in the cloud. This paper revisits workload optimization in the context of these emerging cloud-based data services. We observe that the missing DBA in these newer data services has affected both the end users and the system developers: users have workload optimization as a major pain point while the system developers are now tasked with supporting a large base of cloud users. We present Peregrine, a workload optimization platform for cloud query engines that we have been developing for the big data analytics infrastructure at Microsoft. Peregrine makes three major contributions: (i) a novel way of representing query workloads that is agnostic to the query engine and is general enough to describe a large variety of workloads, (ii) a categorization of the typical workload patterns, derived from production workloads at Microsoft, and the corresponding workload optimizations possible in each category, and (iii) a prescription for adding workload-awareness to a query engine, via the notion of query annotations that are served to the query engine at compile time. We discuss a case study of Peregrine using two optimizations over two query engines, namely Scope and Spark. Peregrine has helped cut the time to develop new workload optimization features from years to months, benefiting the research teams, the product teams, and the customers at Microsoft." @default.
- W2985275869 created "2019-11-22" @default.
- W2985275869 creator A5008214623 @default.
- W2985275869 creator A5017315700 @default.
- W2985275869 creator A5042701714 @default.
- W2985275869 creator A5060868585 @default.
- W2985275869 creator A5061137265 @default.
- W2985275869 creator A5067471025 @default.
- W2985275869 creator A5079846990 @default.
- W2985275869 date "2019-11-20" @default.
- W2985275869 modified "2023-09-22" @default.
- W2985275869 title "Peregrine" @default.
- W2985275869 cites W1161092233 @default.
- W2985275869 cites W2043885422 @default.
- W2985275869 cites W2081728040 @default.
- W2985275869 cites W2096544401 @default.
- W2985275869 cites W2100773341 @default.
- W2985275869 cites W2126547925 @default.
- W2985275869 cites W2167978511 @default.
- W2985275869 cites W2257756289 @default.
- W2985275869 cites W2432911982 @default.
- W2985275869 cites W2521550930 @default.
- W2985275869 cites W2535959639 @default.
- W2985275869 cites W2612261081 @default.
- W2985275869 cites W2622443349 @default.
- W2985275869 cites W2788151607 @default.
- W2985275869 cites W2799060872 @default.
- W2985275869 cites W2799237774 @default.
- W2985275869 cites W2883510886 @default.
- W2985275869 cites W2886887279 @default.
- W2985275869 cites W2894398417 @default.
- W2985275869 cites W2944240329 @default.
- W2985275869 cites W2948983265 @default.
- W2985275869 cites W2955798121 @default.
- W2985275869 cites W2962771342 @default.
- W2985275869 cites W2963853546 @default.
- W2985275869 cites W2970373351 @default.
- W2985275869 cites W68941528 @default.
- W2985275869 doi "https://doi.org/10.1145/3357223.3362726" @default.
- W2985275869 hasPublicationYear "2019" @default.
- W2985275869 type Work @default.
- W2985275869 sameAs 2985275869 @default.
- W2985275869 citedByCount "23" @default.
- W2985275869 countsByYear W29852758692020 @default.
- W2985275869 countsByYear W29852758692021 @default.
- W2985275869 countsByYear W29852758692022 @default.
- W2985275869 countsByYear W29852758692023 @default.
- W2985275869 crossrefType "proceedings-article" @default.
- W2985275869 hasAuthorship W2985275869A5008214623 @default.
- W2985275869 hasAuthorship W2985275869A5017315700 @default.
- W2985275869 hasAuthorship W2985275869A5042701714 @default.
- W2985275869 hasAuthorship W2985275869A5060868585 @default.
- W2985275869 hasAuthorship W2985275869A5061137265 @default.
- W2985275869 hasAuthorship W2985275869A5067471025 @default.
- W2985275869 hasAuthorship W2985275869A5079846990 @default.
- W2985275869 hasConcept C111919701 @default.
- W2985275869 hasConcept C124101348 @default.
- W2985275869 hasConcept C151730666 @default.
- W2985275869 hasConcept C157692150 @default.
- W2985275869 hasConcept C192028432 @default.
- W2985275869 hasConcept C199360897 @default.
- W2985275869 hasConcept C23123220 @default.
- W2985275869 hasConcept C2778476105 @default.
- W2985275869 hasConcept C2779343474 @default.
- W2985275869 hasConcept C2781215313 @default.
- W2985275869 hasConcept C41008148 @default.
- W2985275869 hasConcept C510870499 @default.
- W2985275869 hasConcept C75684735 @default.
- W2985275869 hasConcept C77088390 @default.
- W2985275869 hasConcept C79158427 @default.
- W2985275869 hasConcept C79974875 @default.
- W2985275869 hasConcept C86803240 @default.
- W2985275869 hasConcept C99016210 @default.
- W2985275869 hasConceptScore W2985275869C111919701 @default.
- W2985275869 hasConceptScore W2985275869C124101348 @default.
- W2985275869 hasConceptScore W2985275869C151730666 @default.
- W2985275869 hasConceptScore W2985275869C157692150 @default.
- W2985275869 hasConceptScore W2985275869C192028432 @default.
- W2985275869 hasConceptScore W2985275869C199360897 @default.
- W2985275869 hasConceptScore W2985275869C23123220 @default.
- W2985275869 hasConceptScore W2985275869C2778476105 @default.
- W2985275869 hasConceptScore W2985275869C2779343474 @default.
- W2985275869 hasConceptScore W2985275869C2781215313 @default.
- W2985275869 hasConceptScore W2985275869C41008148 @default.
- W2985275869 hasConceptScore W2985275869C510870499 @default.
- W2985275869 hasConceptScore W2985275869C75684735 @default.
- W2985275869 hasConceptScore W2985275869C77088390 @default.
- W2985275869 hasConceptScore W2985275869C79158427 @default.
- W2985275869 hasConceptScore W2985275869C79974875 @default.
- W2985275869 hasConceptScore W2985275869C86803240 @default.
- W2985275869 hasConceptScore W2985275869C99016210 @default.
- W2985275869 hasLocation W29852758691 @default.
- W2985275869 hasOpenAccess W2985275869 @default.
- W2985275869 hasPrimaryLocation W29852758691 @default.
- W2985275869 hasRelatedWork W11430368 @default.
- W2985275869 hasRelatedWork W13730588 @default.
- W2985275869 hasRelatedWork W3266680 @default.
- W2985275869 hasRelatedWork W5211984 @default.
- W2985275869 hasRelatedWork W5304494 @default.
- W2985275869 hasRelatedWork W5839577 @default.