TRIADB v0.9

Self-Service Data Management & Analytics Framework

This is a public announcement of the first official open-source release of TRIADB project at GitHub. Previous announcements of the project, older release, information about associative semiotic hypergraph technology and a historical record of R3DM/S3DM multi-perspective associative data model can be found at HEALIS site that will be no longer maintained by the author.

At A Glance

TRIADB is an innovative, multi-perspective development framework written in Python with the scope to assist power BI users and developers to build easily web applications and/or Jupyter notebooks, i.e. reports, that are based on interactive computing and exploratory, visual analysis. It’s main unique and valuable characteristics are:

1. Interactive visual exploratory analytics powered by TriaClick associative semiotic hypergraph engine. The technology is based on ClickHouse columnar DBMS and its output can be easily transformed to enable hypergraph traversal, associative selection and cross-filtering with states on coordinated visualizations.

Coordinated update of GUI components based on associative selection and filtering

Visualization of hypergraph paths based on TRIADB associations

2. User defined business models in the form of a hypergraph. Data modeling plays a central role in TRIADB. Management of meta-data, loading and filtering processes are innately related, associated, with the business model you define.

Business model based on Northwind database with Associative Entities in yellow

3. Interactive programming with high-level OOP components and methods tailored to fit database management and analytics. TRIADB powerful transformations, including list items, tuples and associations enable the user to analyze data quickly and intuitively.

Examine visually how the domain set values of attributes are related

Aggregation in a filtered state and transformation to tuples and bar chart

Screen Capture Demo

Watch a demonstration of the main features of TRIADB in the current release with a focus on the key aspects highlighted in the previous section.

What problem TRIADB solves and how

The project started long time ago from a personal need to integrate an electronic medical record database used in a neurosurgery clinic with several other specialized databases for neurosurgical disorders. Integration, correlation, aggregation and visual exploration will always be the holy grail of business analytics. Associative technology in general is a specific solution that has not been opened to the public until now although it is applied by one of the most successful BI companies. The implementation of associative semiotic hypergraph engine in TRIADB opens a path for other competitive, cost effective (not only RAM based), efficient solutions sharing the same principles in data modeling and database management.

Future Plans

TRIADB is a middleware, one part is closely coupled with the physical layer of the data store engine and the other part is closer to the application layer. Therefore the project can be expanded in two directions, optimization and improvement of associative semiotic hypergraph engine on one hand, efficient and effective transformations and visual exploration on the other hand.

In spite of the growing development of TRIADB which requires urgently funding for resources, the critical factor for the success of this project is how exactly it is going to be applied to solve particular users’ problems. This step requires that users become aware of what are the advantages in using TRIADB and what they can achieve.