Naslov
NoSQL Document Store Translation to Data Vault Based EDW

Autori
Černjeka, Katerina ; Jakšić, Danijela ; Jovanović, Vladan

Vrsta, podvrsta i kategorija rada
Radovi u zbornicima skupova, cjeloviti rad (in extenso), znanstveni

Izvornik
Proceedings of the 41th International Convention on Information and Communication Technology, Electronics and Microelectronics - MIPRO / - , 2018, 1197-1202

Skup
41th International Convention on Information and Communication Technology, Electronics and Microelectronics - MIPRO

Mjesto i datum
Opatija, Hrvatska, 23.05.2018. - 25.05.2018

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
NoSQL ; data vault ; data warehouse ; relational database ; metamodel ; translation rules ; system catalog

Sažetak
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.

Izvorni jezik
Engleski

Znanstvena područja
Informacijske i komunikacijske znanosti

POVEZANOST RADA