all mySQL files are setup in C:\ProgramData\MySQL\MySQL Server 8.0\Data\msem_db

from msql console, use execute the following command:

D:\projects\graph_analysis\DataloadScript.sql

You can modify DataloadScript to add more columns such as contrast, brightness, etc. You also need to add index to these new added parameters.

// graph based analysis tools use klayout to open and view write_buffer.gds, which contains the circuit layout info

python read_from_gds.py // internally has the path to write_buffer.gds this decode info from gds file and write to a file: data/gds_polygon_and_label_try.txt you need to copy the above file to C:\ProgramData\MySQL\MySQL Server 8.0\Data\msem_db

from mysql console, run extract_relationships.sql which will load in data/gds_polygon_and_label_try.txt and compute all spatial overlap between polygons outputs to C:\ProgramData\MySQL\MySQL Server 8.0\Data\msem_db are:

node_features_length_reordered.txt node_labels_final_reordered.txt relationship_final_mysql_nodes_reordered.txt

all GCN model and data are saved in the folder: graph_analysis/GCN

ind.gds.tx and ind.gds.ty are the test data for GCN ind.gds.x and ind.gds.y are the training data for GCN to generate these, run the following command to install the GCN package

python setup.py To invoke the data processing pipeline for the algorithm python dataparse_gcn.py

to train and test, run GCN/train.py The model is saved in models.python

2nd approach is to use deepwalk, which takes relationship_final_mysql_nodes_reordered.txt

python deepwalk_fullyconnected.py

graph_clustering_gds is a clustering method using autoencoder-decoder approach input is the similarity matrix output