Extracting Data from NoSQL Databases - A Step towards Interactive Visual Analysis of NoSQL Data
Year: 2012
Type: dissertation
Abstract: Businesses and organizations today generate increasing volumes of data. Being able to analyze and visualize this data to find trends that can be used as input\nwhen making business decisions is an important factor for competitive advantage. Spotfire is a software platform for doing this. Spotfire uses a tabular data model similar to the relational model used in relational database management\nsystems (RDBMSs), which are commonly used by companies for storing data. Extraction and import of data from RDBMSs to Spotfire is generally a simple task.\nIn recent years, because of changing application requirements, new types\nof databases under the general term NoSQL have become popular. NoSQL\ndatabases differ from RDBMSs mainly in that they use non-relational data models, lack explicit schemas and scale horizontally. Some of these features cause problems for applications like Spotfire when extracting and importing\ndata.\nThis thesis investigates how these problems can be solved, thus enabling support for NoSQL databases in Spotfire. The approach and conclusions are valid for any application that interacts with databases in a similar way as Spotfire.\nGeneral solutions for supporting NoSQL databases are suggested. Also, two concrete tools for importing data from Cassandra and Neo4j that have been implemented in the Spotfire platform are described. The presented solutions\ncomprise a data model mapping from the NoSQL system to Spotfire tables,sampling and possibly clustering for finding schemas, and an extraction mechanism\ntailored to the particular system's query interface.\nThe suggested solutions are not claimed to be complete. Rather, the work in this thesis can serve as a starting point for more thorough investigations or\nas a basis for something that can be extended.
Author: Petter Näsholm
Language: English
Subfield: Information Systems
Field: Computer Science
Domain: Physical Sciences
Open Access status: green
OpenAlex ID: W23697387
