Sunday 15 April 2012

Office suite application to store tree and graph data structures

Some more thinking on from my post on formula driven image objects in an office suite, it occurs to me that the data structures that prevail in common office suite applications is limiting both users' productivity, but also their way of thinking. To paraphrase Maslow: if all you have is an office suite, every problem looks like a spreadsheet'. Users frequently jam data into a 2D array (spreadsheet) or just a text document, when it deserves better structure.

Two data structures that I think are important are trees and graphs, to store hierarchies and interrelationships respectively. I know these can be implemented by database tools and with scripting, but often these are a little out of reach of the average user. What the user needs is a highly visual way to store data in a tree or graph format: to be about to convert array data into tree/graph data; to be able to paste in; to be able to drag and drop. They need to be able to define additional properties for each node, and to make properties of one node, and relationships between nodes formula dependent. And they also need to be able to export the data in a visual format, e.g. for putting in a presentation.

The challenge: make all useful data structures accessible (and hence visualisable) to the average computer user, and expand their minds!

No comments: