Cube Matrix program provides the capability to manipulate relational database. This feature is very useful to deal with big data in an efficient way especially if one has geodatabase files. We will demonstrate this using a simple example here.
We have three data base files and each of them contains information about the network,
Based on the database, we can retrieve link information of the network.
In the attached sample catalog, we use JOINTODBI to deploy the relational database. Also, one may use LOOKUP to do the same thing.Note: please pay special attention to the use of JOINCOND sub keyword to check the status from a JOINTODBI action in case of your data set contains duplicates in the joint fields.
Note, in the sample catalog, we use text files as look up tables. One can use DBF files instead as well. For more details on the LOOKUP keyword, please go here.
jointDBI.zip