Contents

SimpleGraph

SimpleGraph is an open source project that allows to wrap Systems APIs in a way that graph algorithms and storage can be applied. As an implementation Apache Tinkerpop/Gremlin is used.


Modules

SimpleGraphModulenameurldocumentation
SimpleGraph-ExcelExcelhttps://poi.apache.org/spreadsheet/quick-guide.htmlmakes Microsoft Excel workbooks accessible via the Apache POI API
SimpleGraph-FileSystemFileSystemhttps://docs.oracle.com/javase/8/docs/api/java/io/File.htmlyour FileSystem accessible via the Java FileSystem API
SimpleGraph-JSONJSONhttps://www.json.org/makes JSON parse results accessible to Graph processing.
SimpleGraph-MapSystemMapSystemhttps://docs.oracle.com/javase/8/docs/api/java/util/Map.htmlsupplies a simple wrapper for a graph with nodes that have key/value pairs in form of HashMaps. We would not really need this since Apache Tinkerpop/Gremlin already supplies us with properties per node/vertex. Still this system is useful as a helper system and to illustrate the wrapping concepts and possibilities of SimpleGraph
SimpleGraph-MediaWikiMediaWikihttps://www.mediawiki.org/wiki/API:Main page MediaWikimakes MediaWiki site content accessible to Graph processing. It exposes the MediaWiki API using the mediawiki-japi Library by BITPlan.
SimpleGraph-PowerPointPowerPointhttps://poi.apache.org/slideshow/xslf-cookbook.htmlmakes Microsoft PowerPoint presentations accessible via the Apache POI API
SimpleGraph-SMWSMWhttps://www.semantic-mediawiki.org/wiki/Help:APImakes SemanticMediaWiki accessible via the SMW API
SimpleGraph-SQLSQLhttps://docs.oracle.com/javase/8/docs/api/java/sql/package-summary.htmlmakes relational SQL databases accessible via the Java JDBC API.
SimpleGraph-TripleStoreTripleStorehttps://github.com/BITPlan/org.sidif.triplestoremakes BITPlan's SIDIF TripleStore accessible
SimpleGraph-WikiDataWikiDatahttps://github.com/Wikidata/Wikidata-Toolkitmakes WikiData data available via the Wikidata-Toolki API
SimpleGraph-pdfpdfmakes pdf-files accessible


Motivation

Solving IT Problems across System boundaries can get very difficult. There may be a wealth of APIs which first looks helpful but given the diversity of approaches it a daunting task will need to be tackled to get reasonable results. More often than not projects are not even started since the cost/benefit ratio is not good enough. SimpleGraph aims to supply a unified graph API access to Systems for which this makes sense. In fact for most systems it makes sense to have a graph API. Quite a few problems will get much easier to solve if the subdivision of the problem is done with the goal to apply graph algorithms.


Use Cases

Mix and Match Office and other data

Let's assume we have a business that works in the following manner:

  1. There are pricelist for product categories in Microsoft Excel files
  2. Product specifications are in PDF Format - the files are referenced in the Excel files
  3. Invoices are written in Microsoft Word
  4. There is an address book of customers in VCard format
  5. Orders are handled via e-mail (that is automatically produced by the companies shop website)
  6. Monthly reports are created with PowerPoint

The monthly reports should in the future be modified to give geographical information. Basically a revenue/region sales count per product/region information is wanted.

The 1000 dollar question - can this report be created efficiently semi-manually with reasonable software effort? Sadly it sounds more like 10.000 or 100.000 dollar question.

There are at least 6 different systems involved. SimpleGraph simplifies accessing all 6 systems.

{{SimpleArticle|title=Examples|text=

Air Routes

The AirRoutes example Adobe SVG Viewer plugin (for Internet Explorer) or use Firefox, Opera or Safari instead.

Installation

SimpleGraph-Installation

Tutorial

SimpleGraph-Tutorial


In Internet Explorer versions up to 8, things inside the canvas are inaccessible!