The Open Query GRAPH computation engine, or OQGRAPH as the engine itself is called, allows you to handle hierarchies (tree structures) and complex graphs (nodes having many connections in several directions).
The OQGRAPH storage engine exists as a separate package in the repositories for MariaDB 10.0.7 and later. On Ubuntu and Debian the package is called
mariadb-plugin-oqgraph. On Red Hat, CentOS, and Fedora the package is called
MariaDB-oqgraph-engine. To install the plugin, first install the appropriate package and then install the plugin using the INSTALL SONAME or INSTALL PLUGIN commands.
On Debian and Ubuntu, install the package as follows:
sudo apt-get install mariadb-plugin-oqgraph
or (for MariaDB 10.0)
sudo apt-get install mariadb-oqgraph-engine-10.0
Note that OQGRAPH v3 requires libjudy, which is not in the official Red Hat/Fedora repositories. This needs to be installed first, for example:
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -Uvh epel-release-6-8.noarch.rpm
Then install the package, as follows:
sudo yum install MariaDB-oqgraph-engine
On either system you can then launch the
mysql command-line client and install the plugin in MariaDB as follows:
INSTALL SONAME 'ha_oqgraph';
More information on this engine is found on the OpenQuery website: https://openquery.com.au/products/graph-engine
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.