Razvoj metodološkog pristupa za projektovanje i korišćenje hibridne SQL/NoSQL baze podataka

Abstract

Ova disertacija je nastala iz potrebe teoretskog, razvojnog i praktičnog rešavanja problema projektovanja i korišćenja hibridne SQL/NoSQL baze podataka. Različiti tipovi baza podataka, kako je opisano u nastavku, sadrže specifičnosti koje je potrebno uzeti u obzir prilikom razvoja metodološkog pristupa za realizaciju procesa projektovanja i korišćenja. Disertacija je napisana kao rezultat sprovođenja procesa naučnog istraživanja, pregleda oblasti istraživanja, analize postojećih rešenja i pristupa, razvoja novih pristupa projektovanja i korišćenja (sa svim njihovim sastavnim delovima), primene novorazvijenih pristupa na primere iz prakse, testiranja izabranih aspekata performansi (po određenim kriterijumima) i komparativne analize postignutih rezultata hibridne baze podataka projektovane primenom novog pristupa i „tradicionalno“ projektovane baze podataka. Cilj ove doktorske disertacije je bio razvoj novog pristupa za projektovanje hibridne SQL/NoSQL baze podataka i integraciju i uniformno korišćenje njenih komponenti (SQL i NoSQL baza podataka). U doktorskoj disertaciji su analizirani pogodni kriterijumi za donošenje odluke o opravdanosti prelaska sa postojeće SQL baze podataka na hibridnu bazu podataka. Uključivanje aspekata projektovanja novih i redizajna postojećih baza podataka u novorazvijeni pristup, proširio je opseg njegove moguće primene. Za potrebe pristupa razvijena je i nova arhitektura, koja je omogućila da se nad celokupnom hibridnom bazom podataka (i svim bazama podataka koje čine njene sastavne komponente) upravlja meta podacima, pravilima integriteta, pravilima mapiranja i izvršavanjem naredbi kao nad jedinstvenom logičkom bazom podatka.

This dissertation has originated out of the need for theoretical, developmental and practical solving of the issue of the design and integral and uniform usage of hybrid SQL/NoSQL databases. As described in the course of this dissertation, various types of databases contain specificities that have to be taken into account when developing a methodological approach for the realization of aforementioned processes of database design and usage. The dissertation is written based on many activities. It was driven by conducting scientific research, review of research areas, analysis of existing solutions and approaches. Besides that, dissertation included development of new approach for design and usage (with all their integral parts), application of newly developed approach to examples from practice, testing of chosen aspects of performances (based on certain criteria) and comparative analysis of achieved results of hybrid database developed by applying a new approach and ‘traditionally’ designed database. The aim of this doctoral dissertation was the development of a new approach for the design of hybrid SQL/NoSQL database and integration and uniform usage of its components (SQL and NoSQL databases). A criterion for making a decision on the justification of transition from existing SQL database to hybrid database has been defined in this dissertation. Including aspect of new database design, as well as including aspect of existing database redesign expanded the scope of newly developed approach. For the approach needs, a new architecture has also been developed, which enabled managing metadata, integrity rules, mapping rules and statement execution over the entire hybrid database (including all its component databases) as over a unique logical database.