Document Type

Project

Lead Author Type

CIS Masters Student

Advisors

Dr. Jonathan Leidig, jonathan.leidig@gvsu.edu

Embargo Period

12-15-2017

Abstract

Today, countless businesses use relational databases to store essential information. That data, however, doesn’t always come in the same structure. XML files, for example, may have various schemas for a document type, outlined by numerous XSD files. It may not always make sense to use a traditional relational database for this storage, as NoSQL solutions offer flexibility, speed, and powerful visualization tools. Often enough these documents and schemas are known and used by numerous branches or offices in a company, but need to be stored in a centrally located database. The goal of this work is to solve the problem of saving XML files of various schema types in the same database, by dynamically altering the schema of the database to accommodate the new file structures. In addition to relational database storage, the XML files are also mapped to a graph database to accommodate additional business needs such as visualizing relationships among the data using more powerful methods than traditional data stores. This project also aims to minimize the effort spent by a software developer persisting data with different schema types as well as time allocated to creating methods for storing newly added schemas to the data persistence workflow. It achieves this by automating the process, using several existing persistence frameworks such as Java Architecture for XML Binding (JAXB), Hibernate Object-Relational Mapping (ORM), and the Neo4J Object Graph Mapping Library (OGM). This work intends to integrate these technologies into a cohesive, easily configurable, highly extensible framework that provides a largely automated solution to dynamically mapping evolving data structures to multiple data persistence paradigms.

Download

Share

COinS