Phocas Software selected as preferred data analytics technology by ADS Solutions

Business Intelligence

Dremio | September 15, 2023

Dremio, a renowned easy and open data lakehouse solution provider, has recently introduced its next-gen Reflections technology, marking a transformative milestone in SQL query acceleration. Dremio Reflections facilitate sub-second analytics performance across an organization's entire data ecosystem, irrespective of data location. This groundbreaking technology is redefining data access and analysis, ensuring that valuable insights are derived efficiently and swiftly, all while reducing costs to merely one-third of a typical cloud data warehouse. Reflections represent Dremio's innovative SQL query acceleration technology. Queries that leverage Reflections exhibit performance gains ranging from 10 to 100 times faster than their non-accelerated counterparts. This latest release introduces the Dremio Reflection Recommender, a pioneering feature that empowers users to accelerate Business Intelligence workloads in a matter of seconds. The Reflection Recommender automatically evaluates an organization's SQL queries and generates recommended Reflections to accelerate them. Tomer Shiran, founder of Dremio, commented, Dremio Reflections accelerate SQL queries by orders of magnitude, eliminating the need for BI extracts/imports and enabling companies to run their most mission-critical BI workloads directly on a lakehouse. With automatic recommendations and next-generation incremental updates, we've made it even easier for organizations to take advantage of this innovative technology. [Source: Business Wire] Reflection Recommender eliminates the need for labor-intensive manual data and workload analysis, making the process of obtaining the fastest and most intelligent query results effortless, requiring only a few simple actions. The user-friendly nature of the Reflection Recommender puts advanced query acceleration capabilities within the reach of all users, significantly saving both time and expenses. Dremio has also refined the process of refreshing Reflections to further bolster query performance and drive cost efficiencies. It now intelligently refreshes Reflections on Apache Iceberg tables, promptly capturing incremental data changes. This innovative approach obviates the requirement for complete data refreshes, resulting in speedier updates and reduced compute expenses. Dremio Reflections eliminates the need for data teams to export data from the data lakehouse into BI extracts or imports for analytical reasons and overcomes performance bottlenecks for BI dashboards and reports. In addition, Reflections negate the necessity of creating precomputed tables within the data lake or data warehouse to achieve sub-second performance for BI workloads, reducing the workload and complexity for data teams. About Dremio Dremio is a leading, easy and open data lakehouse solution provider, offering organizations the versatility of self-service analytics coupled with the functionality of a data warehouse and the flexibility of a data lake. Dremio's platform empowers users to harness the lightning-fast SQL query service alongside various processing engines, all on the same dataset. The company distinguishes itself through a pioneering data-as-code methodology akin to Git, which facilitates data experimentation, version control, and governance. This innovative approach enhances agility and empowers organizations to explore and manage their data resources with unprecedented efficiency. Furthermore, Dremio offers a fully managed service that expedites organizations' entry into analytics, allowing them to commence their data-driven journey within minutes.

Read More