Extracting Data from NoSQL Databases: A Step towards Interactive Visual Analysis of NoSQL Data
Petter Nasholm
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.
Technical TutorialsData VisualizationNoSQL
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.