Cyclo graph

The Cyclo graph has Product and Stage vertices and a bidirecional sendW edge.

The raw material is a product that enters the process through a stage. Then, it becomes a work-in-process asset (WiP) that is sent from one stage to another, until the final product is obtained. The sendW edge expects to send WiPs along the production flow. Clustered by timestep, it should attach ascending sequences of serial numbers to facilitate estimation of production rate.

// cyclo-v1-schema
schema.vertexLabel('Stage').
       ifNotExists().
       partitionBy('stage_name', Text).
       create();

schema.vertexLabel('Product').
       ifNotExists().
       partitionBy('product_name', Text).
       property('latitude', Double).
       property('longitude', Double).
       property('coordinates', Point).
       create();

schema.edgeLabel('sendW').
       ifNotExists().
       from('Stage').
       to('Stage').
       clusterBy('timestep', Int, Desc).
       create();

schema.edgeLabel('sendW').
       ifNotExists().
       from('Stage').
       to('Product').
       clusterBy('timestep', Int, Desc).
       create();

schema.edgeLabel('sendW').
       ifNotExists().
       from('Product').
       to('Stage').
       clusterBy('timestep', Int, Desc).
       create();

More details are shown at the links below:

• Cyclo-v1 schema generated in Gremlin for the Cyclo graph.
• Corresponding CQL schema for Cassandra.
• The schema is inspired by the Datastax graph-book.

P&Q Factory

The P&Q Factory deploys a Process across its Facility to transform products [RM-1, RM-2, RM-3 & P-Part] into products [P & Q]. The Stages with Skills A, B, C, and D are organized in a network:

graph LR PP[P-Part $5/u] --> D1[D 15min/u] --> P[P $90/u 100u/wk] RM1[RM1 $20/u] --> A1[A 15min/u] --> C1[C 10min/u] --> D1 RM2[RM2 $20/u] --> B2[B 15min/u] --> C2[C 5min/u] --> D1 C2 --> D2[D] RM3[RM3 $20/u] --> A3[A 10min/u] --> B3[B 15min/u] --> D2[D 5min/u] --> Q[Q $100/U 50u/wk]

The Process contains a coupĺe Cyclos for P & Q respectively. The flow in the network start from raw materials side of the Cyclo with transformations that generate intermediary assets, or work-in-process. The WiPs become final products at the other end of the Cyclo. The Process may be represented by a graph with the respective product and stage vertices, as shown below:

Published in Business Amplifier, also e-book and Amplificador de Negócios.