{"id":967230,"date":"2023-11-08T16:46:43","date_gmt":"2023-11-09T00:46:43","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?post_type=msr-project&#038;p=967230"},"modified":"2023-11-08T16:46:45","modified_gmt":"2023-11-09T00:46:45","slug":"query-acceleration-for-data-lakes","status":"publish","type":"msr-project","link":"https:\/\/www.microsoft.com\/en-us\/research\/project\/query-acceleration-for-data-lakes\/","title":{"rendered":"Query Acceleration for Data Lakes"},"content":{"rendered":"<section class=\"mb-3 moray-highlight\">\n\t<div class=\"card-img-overlay mx-lg-0\">\n\t\t<div class=\"card-background  has-background-catalina-blue card-background--full-bleed\">\n\t\t\t\t\t<\/div>\n\t\t<!-- Foreground -->\n\t\t<div class=\"card-foreground d-flex mt-md-n5 my-lg-5 px-g px-lg-0\">\n\t\t\t<!-- Container -->\n\t\t\t<div class=\"container d-flex mt-md-n5 my-lg-5 \">\n\t\t\t\t<!-- Card wrapper -->\n\t\t\t\t<div class=\"w-100 w-lg-col-5\">\n\t\t\t\t\t<!-- Card -->\n\t\t\t\t\t<div class=\"card material-md-card py-5 px-md-5\">\n\t\t\t\t\t\t<div class=\"card-body \">\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\n<h1 class=\"wp-block-heading\" id=\"query-acceleration-for-data-lakes\">Query Acceleration for Data Lakes<\/h1>\n\n\n\n<p>Accelerating query processing on open data formats<\/p>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/section>\n\n\n\n\n\n<p>As businesses become more data-driven, there is an increasing interest in adopting data lakes (e.g., <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-fabric\">Microsoft Fabric<\/a>) in large enterprises. A data lake is a large storage repository that stores a vast amount of data in a variety of open data formats, making it accessible for all use cases (e.g., AI\/data science\/BI\/reporting) that have arisen or could arise. This includes text-based raw data formats such as CSV and JSON, row-wise binary formats such as Apache Avro, and batched column-wise formats such as Apache Parquet and ORC. In data lakes, data is ingested in its native open format without expensive and time-consuming data preparation. <\/p>\n\n\n\n<p>We are innovating on the storage tier of this emerging architecture to accelerate query processing on various open data formats. Our research has been commercialized and widely used in several products of Microsoft. Example techniques we developed include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Mison<\/strong>. Mison is a fast parser for raw data formats such as CSV and JSON. It is order of magnitude faster than the traditional finite state machine-based approach. Our new parsing technique allows query engines to push down projections and filters of queries into the parser, and thus avoids a great deal of wasted work by only parsing fields that are relevant to the queries. It also breaks the dependences in state transitions of the traditional approach and thus enables the parser to parse a vector of characters in parallel with SIMD instructions.<\/li>\n\n\n\n<li><strong>Parquet-select<\/strong>. Parquet-select is an Apache Parquet reader that is up to one order of magnitude faster than the open-source Parquet reader. It enables predicate pushdown in Parquet and thus avoids expensive decompression on unnecessary compressed column values. Our techniques extensively use Bit Manipulation Instructions (BMI), a special instruction set extension of the X86 architecture, widely available in Intel\/AMD CPUs.<\/li>\n<\/ul>\n\n\n\n\n\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Accelerating query processing on open data formats As businesses become more data-driven, there is an increasing interest in adopting data lakes (e.g., Microsoft Fabric) in large enterprises. A data lake is a large storage repository that stores a vast amount of data in a variety of open data formats, making it accessible for all use [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"footnotes":""},"research-area":[13563],"msr-locale":[268875],"msr-impact-theme":[],"msr-pillar":[],"class_list":["post-967230","msr-project","type-msr-project","status-publish","hentry","msr-research-area-data-platform-analytics","msr-locale-en_us","msr-archive-status-active"],"msr_project_start":"","related-publications":[386768,581830,764968,950403],"related-downloads":[],"related-videos":[],"related-groups":[],"related-events":[],"related-opportunities":[],"related-posts":[],"related-articles":[],"tab-content":[],"slides":[],"related-researchers":[{"type":"user_nicename","display_name":"Yinan Li","user_id":35012,"people_section":"Related people","alias":"yinali"},{"type":"user_nicename","display_name":"Badrish Chandramouli","user_id":31166,"people_section":"Related people","alias":"badrishc"}],"msr_research_lab":[199565],"msr_impact_theme":[],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/967230"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-project"}],"version-history":[{"count":6,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/967230\/revisions"}],"predecessor-version":[{"id":969435,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/967230\/revisions\/969435"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=967230"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=967230"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=967230"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=967230"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=967230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}