Relational Databases as Graph Databases = Conscious (openCypher-2-SQL)
A restricted subset of openCypher graph queries over any relational database is the Conscious initiative. The queries are read-only and with out metagraph queries at this stage. Conscious is a closed-source modification of Microsoft’s openCypher to SQL transpiler beneath the MIT license, and the place Conscious generates SQL to function over any relational/SQL database.
With that in thoughts…allow us to start by understanding the scope…
“Any relational database” within the context of Conscious signifies that openCypher queries are transformed to SQL that targets any precise relational database, slightly than relational databases that need to have specifically modified tables for graph-type-queries or that inject information as JSON into fields and performing graph-like queries over that JSON information.
openCypher queries are transformed to SQL to run towards any stock-standard relational database.
Applicability to your online business — The Information Science
You might have an present information warehouse, semantic layer or database that could be a relational in nature and that makes use of SQL as the first question language…and also you wish to question your information property utilizing graph queries.
Conversely you will have an pressing must migrate out of your present graph database to a relational/SQL based mostly database and want instruments for the information migration testing and implementation. Conscious, an openCypher-to-SQL transpiler is designed to be the software that you just use to attain your goals.
Extant implementations of graph queries over relational databases require particular tables for efficient node sorts and edge sorts (say tables with single column major keys). The Conscious implementation permits you to run filter openCypher queries over your relational database the place your tables have multi-column major keys.
On this article, we expose how this may be carried out with no threat to your present relational information stack, by adopting a knowledge science technique the place meta-information in regards to the homomorphic graph construction of your relational information is saved inside JSON within the feedback part of your DDL. For example, ORACLE, SQL Server…
