Graph Database results in Comindware Tracker flexibility
Monday, October 28, 2013 / Updated: February 15, 2023
As you probably know from my previous posts, Comindware Tracker is built around the brand new Comindware ElasticData technology. So what is behind that technology? Today I’m going to lift the veil on this modern technology and give you a short overview of its benefits over traditional databases.
When Comindware Tracker was designed by our development team, we studied in detail pre-existing solutions for business processes management. And it was clear that the main problem of these solutions is lack of flexibility. Changing the existing process workflow or simply adding a field to the form of the existing process may cause performance problems. Sometimes changing the existing workflow is impossible at all in a number of solutions which are built on relational databases.
Scientific remark: In relational databases the most effective way to store an object is to use a separate table for it, in which each row is an object and each column corresponds to the object field. So, if you need to add a field to the object, you have to update all existing objects with a default field value. If you need more flexibility, you can redesign your relational tables so that the field values will be stored in a separate table. But this will lead to performance problems – querying data from multiple tables is slower than querying from a single table.
Flexibility and performance were the key points in choosing graph database as storage for ElasticData technology. Comindware uses a special kind of graph database. Basically, we here at Comindware have developed our own highly-effective graph database named ElasticData, which can handle billions of bits of data. Its core is written in the most effective C++ language using most modern algorithms for retrieving and writing triples.
This way, all data in Comindware Tracker is stored in something comparable to the Internet. I guess you may agree with me that the Internet is much more flexible than a table or a set of tables. In the Internet data is interconnected with hyperlinks, and you can search, store, organize and reorganize, link and relink it. You don’t need a special query language to find the data you need on the Internet.
This concept results in Comindware Tracker flexibility, ease of use, ease of modifications and many, many other advantages that we speak of daily in our blog. So when you simply log in your free 30-day trial Cloud version of Comindware Tracker, now you know exactly why it is so comfortable to use and why this working environment is not only productive, it’s also cutting edge technology.
Whenever you have a question about it or want to request a post on our blog, simply ask me on twitter @AnastasiaPMP or comment here. Or simply register for your trial and our sales team will make a free non-commercial presentation for you.
Posted on: in Project World, Solutions