D4M: Bringing Associative Arrays to Database Engines

TL;DR

D4M is introduced as a unifying tool that enables associative array operations across multiple database engines, simplifying data analysis workflows and supporting various backend systems like SciDB and Accumulo.

Contribution

The paper presents D4M's extension to support multiple database engines, including SciDB, providing a federated interface for associative array operations.

Findings

D4M now supports SciDB alongside Accumulo.

Performance benchmarks demonstrate efficient data operations.

Unified interface simplifies multi-database data analysis.

Abstract

The ability to collect and analyze large amounts of data is a growing problem within the scientific community. The growing gap between data and users calls for innovative tools that address the challenges faced by big data volume, velocity and variety. Numerous tools exist that allow users to store, query and index these massive quantities of data. Each storage or database engine comes with the promise of dealing with complex data. Scientists and engineers who wish to use these systems often quickly find that there is no single technology that offers a panacea to the complexity of information. When using multiple technologies, however, there is significant trouble in designing the movement of information between storage and database engines to support an end-to-end application along with a steep learning curve associated with learning the nuances of each underlying technology. In this article, we present the Dynamic Distributed Dimensional Data Model (D4M) as a potential tool to unify database and storage engine operations. Previous articles on D4M have showcased the ability of D4M to interact with the popular NoSQL Accumulo database. Recently however, D4M now operates on a variety of backend storage or database engines while providing a federated look to the end user through the use of associative arrays. In order to showcase how new databases may be supported by D4M, we describe the process of building the D4M-SciDB connector and present performance of this connection.