bitplan / com.bitplan.simplegraph Goto Github PK

The MediaWiki Module shall MediaWiki site content accessible to Graph processing with Gremlin

see https://stackoverflow.com/questions/49254524/simplegraph-powerpoint-module-does-not-work-as-expected

The SQL Module shall make relational SQL databases accessible via the Java JDBC API

I asked the question on Stackoverflow and was requested to file an issue here:

https://stackoverflow.com/q/51800068/10211666

https://bitplan.github.io/com.bitplan.simplegraph/

is not showing the submodules or only showing a single module.

https://maven.apache.org/plugins/maven-site-plugin/examples/multimodule.html

Currently only the parent pom is deployed but not any jars ...

https://stackoverflow.com/questions/37808944/nexus-staging-maven-plugin-on-a-complex-maven-project

We need a CalDAV-Module to navigate Calendar Data.

Thanks for fixing #12.
I wonder what the traditional implementation would look like.
The aim is to be able to discuss the benefits of graphs in this context

Currently the label is shown e.g. "knows" instead of "weight"

The idea is to build up a system of modules implementing an interface to often used standard systems or datasources. The wanted interface offers a simple graph representation of the datastructure of the system or datasource where it is implemented for. The requirement is to set up a graph with typecasting nodes and links. The nodes represent interfaces to navigate the graph on the one hand. On the other hand there are domain specific interfaces leading to the domain specific informations as well as technical specific interfaces for example as domain specific access.

At the beginning the following modules are required:

Module to

• access a file system (see issue #2)
• access a database (encapsulate sql see issue #3 )
• access to mediawikis (see issue #4)

many useful modules shall follow.

Excel formular usually contain cell references in the form A1, B2, C3.
When the excel sheet is imported into the graph it would be nice to be able to know the reference in graph style.

E.g. if the modern example of tinkerpop see http://tinkerpop.apache.org/docs/current/reference/ is used and an excel row represents a vertex and a column represents a property then given
A=name
B=age

and Row 3 being for marko with
A3=marko
B3=29
and Row 4 being for vadas with
A4=vadas
B4=27

then when a formular is given with B3/B4 to compute the average age of both this should be represented as something like person(marko).age/person(vadas).age. Especially this should hold true when graphs are converted to excel.

This module is used to index a series of pdf files with a pre-defined set of keywords

refactor Testcase content to GraphRythmContext

If a cell in an Excel sheet is empty then the analysis with TinkerPop3 shows that the following cell is shifted to this.
ex. below
The analysis withTinkerPop3.dumpGraph shows for ID = 4
name=josh
city=32

id name city age
1 marko rom 29
4 josh          32

getting the "backlink" to the "payload" entity of a vertex is currently done by accessing the "mysimplenode" property:
FileNode fileNode=(FileNode) node.property("mysimplenode").value();
This is not good information hiding:

• the "mysimplenode" should be accessed via a constant
• better there should be a FileNode.of(node) function.

see https://stackoverflow.com/questions/50314987/gremlin-text-comparison-predicates

I tried to create a CSV file, but result was also a xlsx file instead, although it was named *.csv. It is possible to create such a file from its filename in a correct format or should there exist a method or parameters to create a csv file explicite (also a parameter for the delimter). Perhaps also other export formats from Excel.

A CSV file make only sense for a single sheet. So a CSV converter should create separate files with -<sheet[name] | sheet[number]>.csv

public void testCreateExcelCSVTracks() throws Exception {
    ExcelSystem es = new ExcelSystem();
    Graph graph = TinkerGraph.open();
    graph.io(IoCore.graphml()).readGraph("tracks.graphml");
    if (debug)
      LOGGER.log(Level.INFO, graph.toString());

    GraphTraversalSource g = graph.traversal();
    // es.setDebug(true);
    Workbook wb = es.createWorkBook(g);
    assertEquals(3, wb.getNumberOfSheets());
    es.save(wb, "tracks.csv");
  }

To allow to retrieve the childs in an xml tree there should be a childindex property.
This is a good start to start having a naming convention for properties. E.g. in this case XmlSystem.childindex would be the name of a property to make the property name "qualified".

Inspired by the Stackoverflow question Auto connect Vertices having coordinates
and some needs in the BITPlan OpenSource RADOLAN library project there shall be a Geo module.
It should support:

• Reading in geojson https://tools.ietf.org/html/rfc7946 and making the data available for inspection via gremlin
• Reading in Unlocodes https://www.unece.org/cefact/locode/service/location for a given country/countries

Typical geo spatial relations should be available for query see e.g.
https://stackoverflow.com/questions/44526498/how-to-issue-geo-spatial-queries-using-gremlin-3-via-orientdb-3-0-0m1

This seems also to be a good starting point for tutorial material.

for a start use blue for vertices and green for edges

By default the excel module assumes the first row to be the title row.
It should be possible to define a different row as the title row.

The Filesystem module shall make the Filesystem tree that is accessible via the java.io.File API available for graph processing.

Makes HTML page parse results accessible for Graph Processing via the HTML Cleaner API

The CardDAV-Module should make CardDAV-file (.vcf) content accessible to Graph processing with Gremlin.

The Excel module seems to name all nodes as "row". The nodes should have the name of the sheet to distinguish the nodes from other sheets.

This Module shall make the GitHub GraphQL v4 API for Graph processing with Gremlin.

e.g.

http://api.openchargemap.io/v2/poi/?output=json&latitude=50.598&longitude=7.434&maxresults=10

returns an array which is not handled properly as of Version 0.0.3

The PowerPoint Module shall make PowerPoint content accessible to Graph processing with Gremlin
Presentations with their slides and slidecontent like notes, tables according to the Apache POI
interfaces should be made available.

It should be possible to create presentations from Graph data (presentation slides, tables, notes, headlines, ...)

For better understandability there should be a "rows" edge going from sheet vertex to it's rows as well as a "sheet" edge going from the row vertex to it's sheet vertex.