NoSQL document store translation to data vault based EDW
Katerina Cernjeka, Danijela Jakšić, Vladan M. Jovanovic · 2018
With evolution of technology and Web 2.0 tools NoSQL stores appeared as a common solution to data storage and management demands in modern databases and applications. Relational databases were not designed to cope with agility challenges, scale, commodity storage and processing power demanded by modern applications. Many industries today are choosing NoSQL database technology over relational databases (or at least combining them) in order to gain needed flexibility and scalability. Due to the limitations of relational databases, most researchers are oriented toward relational database transformations and data migration to different types of NoSQL stores. Our research goes in the opposite direction - we aim to develop a metamodel for translating a NoSQL document store (MongoDB) into a data vault based enterprise data warehouse. The reason we do so is to integrate different data sources into a data vault central repository and develop a new data warehouse system catalog that will track changes in both relational and NoSQL schemas. The integration of relational database and NoSQL store would help extract wider knowledge through BI tools, enable data traceability, trend discovery and will accommodate auditing process. The main contributions of this paper are translation rules that accommodate the translation between NoSQL MongoDB document store and data vault based enterprise data warehouse.