Subscribe to PHP Freaks RSS

MySQL University: GRAPH computation engine for MySQL

Print
by Michał Jarosz on Nov 4, 2009 11:36:12 AM - 10,861 views

One of the things relational databases are not very good at is handling structures like trees (for example structure of categories in forum) or graphs (for example network of friends on social networking site).

GRAPH is a MySQL plugin which promises to handle such data in an easy and efficient manner using normal SQL syntax. I don't know any details, as MySQL University announcement was the first time I ever heard of this. Nevertheless the topic seems interesting, so if you would like to know more, attend MySQL Uni session this Thursday, November 5th at 10:00 GMT.

As usual session recording in flash format will also be available at a later time.

More information about GRAPH is available at OpenQuery's site

For more information about MySQL University, go to my introductory post

[added November 6th, 2009]

The presentation slides and flash recording of the session are now available at MySQL University's site

Comments

marginhound Sep 11, 2012 9:40:49 PM

Oh my!

This is a very nice find! I run a word game solver site where the underlying algorithm uses a graph data structure that I built in Python. I've noticed several of my competitors currently are using PHP / MySQL and was wondering
how they were able to get this to work....

Michał Jarosz Sep 12, 2012 6:46:18 AM

Hi amrginhound. You might be interested in a fact, that OQGraph engine (as it is now being called) is now bundled by default with MariaDB ( http://kb.askmonty.org/en/mariadb-versus-mysql-features/ ). You just need to enable it as explained here http://kb.askmonty.org/en/oqgraph-not-in-53/

Add Comment

Login or register to post a comment.