Schema Extraction of Document Database - MongoDB

Abstract

Moving to big data world, where data is increasing in unstructured fashion with high velocity. To store this bundle amount of data there is a need of data-stores. Traditionally relational databases are used, which are now not compatible to handle this large amount of data, so need to move on with non-relational data-stores. But the problem is only one non-relational data store cannot fulfill all needs, so there is a need of more than one non-relational data store according to applications. To use more than one data-store there is a need to integrate data at schema level. As non-relational data stores are schema less so proper knowledge of its schema is required. The purpose of this thesis is to explain schema extraction of document oriented database MongoDB. Databases including both relational and non-relational are discussed. Then, a brief overview of various existing command line tools used for analyzing and visualizing the schema is provided. The main focus of this study is to create GUI tool with the help of mongo Inspector. Explanation of basic steps must be followed to implement this idea of creating a GUI is also given and description of used Algorithm is provided. On the basis of the results of this research, it can be concluded that this tool is very helpful for DBA’s to manage document databases. This GUI based tool implemented in thesis defines the internal structure of schema in detail as it provides tree view, table view, and graph view of schema which is primarily need of data integration at schema level.