R3DM/S3DM in OrientDB

Populate Item Collections and Value Type System

Initialization

Package

Load Package

index_1.png

index_2.png

index_3.png

index_4.png

index_5.png

index_6.png

index_7.png

index_8.png

index_9.png

index_10.png

index_11.png

index_12.png

index_13.png

index_14.png

index_15.png

index_16.png

index_17.png

index_18.png

index_19.gif

Environment

Select Environment

index_20.png

Systems

index_21.png

index_22.png

Entities

index_23.png

index_24.png

index_25.png

index_26.png

index_27.png

index_28.png

index_29.png

index_30.png

Read Data Values in Memory

Get Dataset

Get Full Path and File Names

index_31.png

index_32.png

index_33.png

index_34.png

index_35.png

Get Columns for Each Table

index_36.png

index_37.gif

index_38.png

index_39.gif

index_40.png

index_41.png

Read Data

Get Headers for Each TSV File

index_42.png

index_43.png

Get Body for Each TSV File

index_44.png

1081 Acme Widget Suppliers 1 Grub St., Potemkin Village, IL 61801 ILLINOIS USA 10
1082 Big Red Tool and Die 4 My Way, Bermuda Shorts, OR 90305 OREGON USA 20
1083 Perfunctory Parts 99 Short Pier, Terra Del Fuego, TX 41299 MADRID SPAIN 30
1084 Alien Aircaft Inc. 2 Groom Lake, Rachel, NV 51902 NOTTINGHAM UK 10

index_45.png

991 Left Handed Bacon Stretcher Cover Red 15.5 lb
992 Smoke Shifter End Black 3.75 lb
993 Acme Widget Washer Red 142.88 kg
994 Acme Widget Washer Silver 142.88 kb
995 I Brake for Crop Circles Sticker
996 Anti-Gravity Turbine Generator Cyan
997 Anti-Gravity Turbine Generator Magenta
998 Fire Hydrant Cap Red 7.2 lb
999 7 Segment Display Green 2.1 gr

index_46.png

1081 991 36.1 300 20/12/2014 TRUE
1081 992 42.3 400 20/12/2014 TRUE
1081 993 15.3 200 03/03/2014 FALSE
1081 994 20.5 100 03/03/2014 FALSE
1081 995 20.5 FALSE
1081 996 124.23 FALSE
1081 997 124.23 FALSE
1081 998 11.7 400 10/09/2014 TRUE
1081 999 75.2 FALSE
1082 991 16.5 200 10/09/2014 TRUE
1082 997 0.55 100 10/09/2014 TRUE
1082 998 7.95 200 03/03/2014 FALSE
1083 998 12.5 FALSE
1083 999 1 FALSE
1084 994 57.3 100 20/12/2014 TRUE
1084 995 22.2 FALSE
1084 998 48.6 200 20/12/2014 TRUE

Digestion of suppliers.tsv

Get Mapping

Many-To-One: From any field of a Dataset onto the Attributes of Supplier Entity

index_47.png

index_48.png

index_49.png

index_50.gif

One-To-One: Each Column of a Table is mapped onto only one Attribute of an Entity

Filter Mapping Rules with those columns of a Dataset Table

index_51.png

index_52.png

index_53.png

index_54.gif

One-To-One: Between the NAMES of the Columns and the VALUE TYPES of the mapped Attributes

index_55.png

index_56.png

index_57.png

index_58.png

One-To-One: Between the NAMES of the Columns and the NAMES of the mapped Attributes

index_59.png

index_60.png

index_61.png

index_62.png

Add References

Add Values

index_63.png

#44:0 #47:0 #46:0 #47:1 #47:2 #44:1
#44:2 #47:3 #46:1 #47:4 #47:2 #44:3
#44:4 #47:5 #46:2 #47:6 #47:7 #44:5
#44:6 #47:8 #46:3 #47:9 #47:10 #44:1

Add Attribute Items

index_64.png

#54:0 #55:0 #56:0 #57:0 #58:0 #59:0
#54:1 #55:1 #56:1 #57:1 #58:0 #59:1
#54:2 #55:2 #56:2 #57:2 #58:1 #59:2
#54:3 #55:3 #56:3 #57:3 #58:2 #59:0

Add Entity Items

index_65.png

index_66.png

Add Associations

index_67.png

index_68.png

Digestion of parts.tsv

Get Mapping

Many-To-One: From any field of a Dataset onto the Attributes of Part Entity

index_69.png

index_70.png

index_71.png

index_72.gif

One-To-One: Each Column of a Table is mapped onto only one Attribute of an Entity

Filter Mapping Rules with those columns of the Dataset Table

index_73.png

index_74.png

index_75.png

index_76.gif

One-To-One: Between the NAMES of the Columns and the VALUE TYPES of the mapped Attributes

index_77.png

index_78.png

index_79.png

index_80.png

One-To-One: Between the NAMES of the Columns and the NAMES of the mapped Attributes

index_81.png

index_82.png

index_83.png

index_84.png

Add References

Add Values

index_85.png

#44:7 #47:11 #47:12 #45:0 #47:13
#44:8 #47:14 #47:15 #45:1 #47:13
#44:9 #47:16 #47:12 #45:2 #47:17
#44:10 #47:16 #47:18 #45:2 #47:19
#44:11 #47:20 Missing[] Missing[] Missing[]
#44:12 #47:21 #47:22 Missing[] Missing[]
#44:13 #47:21 #47:23 Missing[] Missing[]
#44:14 #47:24 #47:12 #45:3 #47:13
#44:15 #47:25 #47:26 #45:4 #47:27

Add Attribute Items

index_86.png

#60:0 #61:0 #62:0 #63:0 #64:0
#60:1 #61:1 #62:1 #63:1 #64:0
#60:2 #61:2 #62:0 #63:2 #64:1
#60:3 #61:2 #62:2 #63:2 #64:2
#60:4 #61:3 Missing[] Missing[] Missing[]
#60:5 #61:4 #62:3 Missing[] Missing[]
#60:6 #61:4 #62:4 Missing[] Missing[]
#60:7 #61:5 #62:0 #63:3 #64:0
#60:8 #61:6 #62:5 #63:4 #64:3

Add Entity Items

index_87.png

index_88.png

Add Associations

index_89.png

index_90.png

index_91.png

Digestion of catalog.tsv

Get Mapping

Many-To-One: From any field of a Dataset onto the Attributes of Catalog Entity

index_92.png

index_93.png

index_94.png

index_95.gif

One-To-One: Each Column of a Table is mapped onto only one Attribute of an Entity

Filter Mapping Rules with those columns of the Dataset Table

index_96.png

index_97.png

index_98.png

index_99.gif

One-To-One: Between the NAMES of the Columns and the VALUE TYPES of the mapped Attributes

index_100.png

index_101.png

index_102.png

index_103.png

One-To-One: Between the NAMES of the Columns and the NAMES of the mapped Attributes

index_104.png

index_105.png

index_106.png

index_107.png

Add References

Add Values

index_108.png

#44:0 #44:7 #45:5 #44:16 #49:0 #47:28
#44:0 #44:8 #45:6 #44:17 #49:0 #47:28
#44:0 #44:9 #45:7 #44:18 #49:1 #47:29
#44:0 #44:10 #45:8 #44:19 #49:1 #47:29
#44:0 #44:11 #45:8 Missing[] Missing[] #47:29
#44:0 #44:12 #45:9 Missing[] Missing[] #47:29
#44:0 #44:13 #45:9 Missing[] Missing[] #47:29
#44:0 #44:14 #45:10 #44:17 #49:2 #47:28
#44:0 #44:15 #45:11 Missing[] Missing[] #47:29
#44:2 #44:7 #45:12 #44:18 #49:2 #47:28
#44:2 #44:13 #45:13 #44:19 #49:2 #47:28
#44:2 #44:14 #45:14 #44:18 #49:1 #47:29
#44:4 #44:14 #45:15 Missing[] Missing[] #47:29
#44:4 #44:15 #45:16 Missing[] Missing[] #47:29
#44:6 #44:10 #45:17 #44:19 #49:0 #47:28
#44:6 #44:11 #45:18 Missing[] Missing[] #47:29
#44:6 #44:14 #45:19 #44:18 #49:0 #47:28

Add Attribute Items

index_109.png

#54:0 #60:0 #65:0 #66:0 #67:0 #68:0
#54:0 #60:1 #65:1 #66:1 #67:0 #68:0
#54:0 #60:2 #65:2 #66:2 #67:1 #68:1
#54:0 #60:3 #65:3 #66:3 #67:1 #68:1
#54:0 #60:4 #65:3 Missing[] Missing[] #68:1
#54:0 #60:5 #65:4 Missing[] Missing[] #68:1
#54:0 #60:6 #65:4 Missing[] Missing[] #68:1
#54:0 #60:7 #65:5 #66:1 #67:2 #68:0
#54:0 #60:8 #65:6 Missing[] Missing[] #68:1
#54:1 #60:0 #65:7 #66:2 #67:2 #68:0
#54:1 #60:6 #65:8 #66:3 #67:2 #68:0
#54:1 #60:7 #65:9 #66:2 #67:1 #68:1
#54:2 #60:7 #65:10 Missing[] Missing[] #68:1
#54:2 #60:8 #65:11 Missing[] Missing[] #68:1
#54:3 #60:3 #65:12 #66:3 #67:0 #68:0
#54:3 #60:4 #65:13 Missing[] Missing[] #68:1
#54:3 #60:7 #65:14 #66:2 #67:0 #68:0

Add Entity Items

index_110.png

index_111.png

Add Associations

index_112.png

index_113.png

index_114.png

End

index_115.png

index_116.png

index_117.png

index_118.png

index_119.png

index_120.png

Created with the Wolfram Language