This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
:param { | |
// Define the file path root and the individual file names required for loading. | |
// https://neo4j.com/docs/operations-manual/current/configuration/file-locations/ | |
file_path_root: 'file:///', // Change this to the folder your script can access the files at. | |
file_0: 'territories.csv', | |
file_1: 'regions.csv', | |
file_2: 'suppliers.csv', | |
file_3: 'shippers.csv', | |
file_4: 'products.csv', | |
file_5: 'categories.csv', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Academic paper on Foreign Key Detection - First step includes calculating inclusions which even with SPIDER algorithm is computationally expensive and requires access to full table data. | |
// https://www.semanticscholar.org/paper/A-Machine-Learning-Approach-to-Foreign-Key-Rostin-Albrecht/691f6eeabbe00451567c9facc282ce9820e9792b | |
// Article on more lightweight approach - Based solely on column name analysis | |
// https://www.tonic.ai/blog/foreign-key-detection | |
// Data for testing efficacy of algorithms | |
// https://github.com/tdoehmen/gitschemas | |
// Quick pything snippet to transform download from the above from a large json map into array of maps |