Extracting Data from NoSQL Databases: A Step towards Interactive Visual Analysis of NoSQL Data

Learn how to enable support for NoSQL databases in Spotfire, a software platform for data analysis and visualization. Explore solutions for extracting and importing non-relational data into Spotfire's tabular data model.

Introduction

This thesis investigates how to enable support for NoSQL databases in Spotfire, a software platform for data analysis and visualization. The author explores solutions to the problems that arise when extracting and importing data from NoSQL databases, which have non-relational data models and lack explicit schemas, into Spotfire's tabular data model.

Highlights

• Provides general solutions for supporting NoSQL databases in applications that interact with databases in a similar way as Spotfire
• Describes two concrete tools for importing data from Cassandra and Neo4j into the Spotfire platform
• Includes a data model mapping from the NoSQL system to Spotfire tables, sampling and clustering for finding schemas, and an extraction mechanism tailored to the particular system's query interface

Recommendation

This course is recommended for data analysts, data scientists, and developers who work with NoSQL databases and need to integrate their data into interactive visual analysis tools like Spotfire. The solutions presented can serve as a starting point for further investigations or as a basis for extensions.