Enhancement for graph operations in relational database for criminal intelligence domain Online publication date: Mon, 04-Jan-2021
by Mateusz Piech; Marcin Łoś; Robert Marcjan
International Journal of Intelligent Information and Database Systems (IJIIDS), Vol. 14, No. 1, 2021
Abstract: The aim of the research was to improve the performance of graph operations in relational database for semi-structured data. First of all, this required us to select a model that allows storing semi-structured data with relations. For this purpose, we selected one of the existing solutions, which stores semi-structured data in a model built using JSON as a native type and adapted it to our requirements. Secondly, we created an algorithm based on common table expression with recursion with the extension of JSON to facilitate more complex graph analysis of data. We compared proposed solutions with Neo4j, chosen as a representative of graph databases. The results show that we obtained an improvement in execution performance in some cases. Although we focused our use cases on criminal intelligence domain, the research output can be applied to every domain with semi-structured data.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Intelligent Information and Database Systems (IJIIDS):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com
Our Blog 
Follow us on Twitter 
Visit us on Facebook