Dataware for data-driven transformation

Mapr Clarity For Data Warehouse Optimization With Arcadia Data

Advanced DWO strategies, with MapR and Arcadia Data, can deliver even more opportunities for optimization and analytical insights

Download the PDF

OVERVIEW OF DATA WAREHOUSE OPTIMIZATION

Data warehouse optimization (DWO) is an implementation strategy in which your data warehouse runs only the workloads that are best served by it. For example, data and analytics that require the fastest interactive responses should reside in a data warehouse. In contrast, massive historical data sets are ideally handled by other platforms.

Many organizations try to put all analytical workloads into their data warehouse, but this is problematic for two main reasons. First, data warehouses are expensive, and other technology options are better suited for workloads that don’t require the fastest levels of responsiveness. Second, data warehouses were not designed for many of the modern data types available today and require excessive IT time and effort to prepare these data types for analysis.

Basic DWO strategies only address the use cases below:

  • Low-cost storage of archive data that is infrequently accessed
  • Resource-intensive extract, transform, load (ETL) processing
  • Large-scale batch analysis on historical data with minimal response requirements

Advanced DWO strategies, with MapR and Arcadia Data, can deliver even more opportunities for optimization and analytical insights.

MapR DWO architecture diagram with Arcadia Data

MapR + Arcadia Data DWO Solution

  • A powerful platform for offloading your existing data warehouse workloads.
  • Bypass your data warehouse and place newer data sets, especially IoT data, log files, and other streaming sources, into the DWO solutions.

To learn more, visit our Quick Start Solution.

With the MapR Arcadia Data DWO Solution You Get:

White Glove Treatment – A Free Data Assessment

  • Not all data is appropriate for your data warehouse.
  • MapR Professional Services identifies which data sets and processes should be offloaded to a MapR cluster.

Free On-Demand Training

GOING BEYOND BASIC DATA WAREHOUSE OPTIMIZATION

OPPORTUNITIES FOR ADDITIONAL OPTIMIZATION

A joint MapR and Arcadia Data deployment helps you make smarter decisions and offload the right workloads from your data warehouse. Examples include:

Interactive Analytics for End Users — MapR and Arcadia Data cost-effectively provide fast, interactive, BI-style analytics suited for most end user requirements.

Visualizations on Machine Learning Outputs — MapR is an ideal platform for machine learning frameworks, and Arcadia Data helps to make sense of all the outputs via visualizations.

Analytics on Enriched Data Sets — Add external data sets such as location-based intelligence to more easily uncover hidden insights. Use Arcadia Data visualizations (including mapping technologies) to get deeper insights from your enriched data.

Internet of Things (IoT) and Log File Data Analysis — Unstructured data types grow rapidly and can only be efficiently stored in a MapR cluster that handles the large volume and fast growth.

POLICY-BASED DATA TIERING

A sound DWO strategy entails optimal data tiering across systems, including within your DWO platform. With MapR Policy-Based Data Tiering, you get an automated tiering approach that conveniently balances performance, cost, and capacity tradeoffs by storing, managing, and analyzing data in different data tiers: hot, warm, and cold.

Arcadia Data dashboard

Solution Features

  • Cost-effective storage of all data types and formats from many data sources.
  • Advanced data management with volumes, snapshots, and data tiering.
  • High performance on a scale-out architecture.
  • Drag and drop UI for creating dashboards, deployed as analytical applications.
  • Dashboard acceleration to provide responsive analytics to a large user base.
  • Visual recommendations engine with over 30 visual types to best represent your data.
  • Search-based BI to ask natural language questions and get visualized answers.

Solution Benefits

  • Maximize the value of your data warehouse by allocating more workloads to MapR and Arcadia Data.
  • Derive greater insights from correlating and enriching large data sets from multiple sources.
  • Eliminate data movement across data silos to promote self-service and minimize IT overhead.
  • Simplify analytical lifecycle to reduce time-to-insight and promote analytics agility.
  • Grow users and data sets incrementally and efficiently by adding nodes to the cluster.

Getting Started

Customers should begin their journey with MapR Professional Services to help define their DWO strategy and ensure workloads are operating on the right platform. DWO starts with identifying the workloads to move to MapR and Arcadia Data. From there, the deployment can grow to add newer data sources that give you more business-critical insights.

About MapR

MapR Technologies, provider of the industry’s leading data platform for AI and analytics, addresses the data complexities of high-scale and mission-critical distributed processing from the cloud to the edge, IoT analytics, and container persistence. Global 2000 enterprises trust the MapR Data Platform to help them solve their most complex AI and analytics challenges. To learn more, visit mapr.com.

About Arcadia Data

Arcadia Data provides the first visual analytics and BI platform native to big data that delivers the scale, performance, and agility business users need for both real-time and historical insights. Its flagship product, Arcadia Enterprise, was built from inception for big data platforms in the cloud and/or on-premises, and streamlines the self-service analytics process with search-based BI and visualization recommendations. To learn more, visit www.arcadiadata.com.

Mapr Clarity For Data Warehouse Optimization With Arcadia Data