MapR Speeds Up Secure BI/Analytics for Operational Data

New Apache Drill 1.11 query engine natively integrates with MapR-DB to provide analytics performance improvements for self-service business intelligence.

MapR Technologies

Data management software maker MapR Technologies is boldly going where it has never gone before: It has added an afterburner of sorts to its platform.

The San Jose, Calif.-based company now claims up to 10 times more speed in analytics query performance for both historical and operational data using the MapR Converged Data Platform.  

To do this, MapR natively integrated new Apache Drill 1.11 with MapR-DB, a database for global data-intensive applications, enabling DataOps teams to build applications that accelerate more accurate decision making from all data with a fast and secure self-service BI environment.

Additional enhancements include enterprise-grade security enhancements that democratize data access for a broad set of users without compromising data privacy, and SQL access for data scientists across on-prem, cloud and edge environments, the company said.

'Massive Refresh' of MapR Platform

“We’ve rolled out a massive refresh of the MapR control system,” Anil Gadre, Executive Vice President, Chief Product Officer told eWEEK. “This allows customers to administer and manage all their data –and entire clusters held—with correlation all in a single pane of glass.

“While we were going through beta (trials) on this version, we had a customer that told us, ‘During our beta testing, I’ve not needed to go to any tool for the last five weeks. Every one of my main workloads is using this tool, and it has everything in it we need.’"

New features of Apache Drill 1.11 on the MapR Converged Data Platform include:

  • Operational Analytics with MapR-DB Integration: Up to 10X performance improvements for broad set of BI/Adhoc queries by leveraging native secondary index technology on MapR-DB; End to End flexible SQL query capabilities on JSON data.
  • Enterprise-grade Security: Versatile authentication mechanisms--PAM, Kerberos & MapR; SecurityAdvanced encryption to protect sensitive data as they are accessed, processed and delivered to end users – SSL & AES 256 GCM support.
  • SQL Analytics Access for Data Scientists: Direct integration into MapR Data Science Refinery enables self-service data exploration and discovery, making data scientists more productive.

Apache Drill is an open-source distributed SQL query engine integrated into the MapR converged data platform, which offers fast and secure self-service BI SQL analytics at scale. Drill’s distributed shared-nothing architecture enables incremental scale-out with low-cost hardware to meet increasing demands of query response and user concurrency.

ANSI SQL compliance, SQL user interface tools, and MapR supported integrations with popular BI tools such as Tableau, MicroStrategy and Qlik allow the backend to be changed without disrupting current BI analyst workflows. With the ability to discover schemas on-the-fly, Drill is a pioneer in in-place analytics on historical data stored in popular file formats such as Parquet, JSON, CSV and TSV in MapR-XD alongside operational data stored in MapR-DB.

The updated platform is available now. For more information, go here.

Chris Preimesberger

Chris J. Preimesberger

Chris J. Preimesberger is Editor of Features & Analysis at eWEEK, responsible in large part for the publication's coverage areas. In his 12 years and more than 3,900 stories at eWEEK, he...