R3DM/S3DM in OrientDB
Populate Item Collections and Value Type System
Initialization
Package
Load Package
Environment
Select Environment
Systems
Entities
Read Data Values in Memory
Get Dataset
Get Full Path and File Names
Get Columns for Each Table
Read Data
Get Headers for Each TSV File
Get Body for Each TSV File
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 |
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 |
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
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
One-To-One: Between the NAMES of the Columns and the VALUE TYPES of the mapped Attributes
One-To-One: Between the NAMES of the Columns and the NAMES of the mapped Attributes
Add References
Add Values
#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
#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
Add Associations
Digestion of parts.tsv
Get Mapping
Many-To-One: From any field of a Dataset onto the Attributes of Part Entity
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
One-To-One: Between the NAMES of the Columns and the VALUE TYPES of the mapped Attributes
One-To-One: Between the NAMES of the Columns and the NAMES of the mapped Attributes
Add References
Add Values
#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
#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
Add Associations
Digestion of catalog.tsv
Get Mapping
Many-To-One: From any field of a Dataset onto the Attributes of Catalog Entity
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
One-To-One: Between the NAMES of the Columns and the VALUE TYPES of the mapped Attributes
One-To-One: Between the NAMES of the Columns and the NAMES of the mapped Attributes
Add References
Add Values
#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
#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
Add Associations
End