Project

General

Profile

Feature #539

Network graph visualisation

Added by Stefan Eichert about 3 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Low
Category:
UI
Target version:
Start date:
2015-10-13
Due date:
% Done:

0%

Estimated time:
16.00 h
Found in version:

Description

A nice feature would be to visualise an entities relation to other entities in the browser for example with http://visjs.org/
Easy to use js library. Easy to implement.

To do:
(recursive) Query for central node and related nodes with some iterations - in ajax/php and push to js
create network graph with vis.js
style, format etc...

Examples:
http://visjs.org/network_examples.html

Query draft nodes:

SELECT uid AS id, entity_name_uri as label, classes_uid as group FROM openatlas.tbl_entities WHERE uid in
(
with recursive links (uid_from, uid_to) AS (
Select links_entity_uid_from, links_entity_uid_to
FROM openatlas.tbl_links
WHERE links_entity_uid_from = 5684
UNION
Select uid_to, links_entity_uid_to
FROM openatlas.tbl_links, links
WHERE links_entity_uid_from = uid_to

)
SELECT distinct uid_from FROM links ORDER BY uid_from)

Query draft links:
with recursive links (uid_from, uid_to) AS (
Select links_entity_uid_from, links_entity_uid_to
FROM openatlas.tbl_links
WHERE links_entity_uid_from = 5684
UNION
Select uid_to, links_entity_uid_to
FROM openatlas.tbl_links, links
WHERE links_entity_uid_from = uid_to

)
SELECT distinct uid_from as from, uid_to AS to FROM links ORDER BY uid_from

draft example:
http://homepage.univie.ac.at/stefan.eichert/networkgraph/

History

#1 Updated by Stefan Eichert about 3 years ago

  • Description updated (diff)

#2 Updated by Stefan Eichert about 3 years ago

  • Description updated (diff)

#3 Updated by Stefan Eichert about 3 years ago

  • Description updated (diff)

#4 Updated by Stefan Eichert about 3 years ago

  • Description updated (diff)

#5 Updated by Stefan Eichert about 3 years ago

  • Description updated (diff)

#6 Updated by Stefan Eichert almost 3 years ago

Ready to be implemented.
tbd together: queries to get data from db...
@alex: Worksession in 2016?

#7 Updated by Alexander Watzinger over 2 years ago

  • Status changed from New to Assigned

#8 Updated by Alexander Watzinger about 2 years ago

  • Target version set to Wishlist

#9 Updated by Alexander Watzinger almost 2 years ago

  • Status changed from Assigned to Acknowledged
  • Assignee deleted (Stefan Eichert)

Already implemented in Demo Version with vis.js but is too slow for a generalized implementation in the main version. Maybe look for a faster library?

#10 Updated by Alexander Watzinger almost 2 years ago

  • Category set to UI
  • Status changed from Acknowledged to In Progress
  • Assignee set to Alexander Watzinger
  • Target version changed from Wishlist to 2.4.0
  • Estimated time set to 16.00 h

Found 3d.js which is faster and testing at the moment with MEDCON data.

#11 Updated by Alexander Watzinger over 1 year ago

  • Status changed from In Progress to Closed

Also available in: Atom PDF