search

cambridge-cares / TheWorldAvatar

A knowledge-graph-based digital twin of the world.
https://theworldavatar.io/
MIT License
86 stars 25 forks source link

Add ability to specify indices to when uploading data to PostGIS #423

Open gpeb2 opened 2 years ago

gpeb2 commented 2 years ago

When uploading data to PostGIS through the stack-data-uploader it would be very beneficial to be able to specify columns that should be indexed as indices can massively speed up certain SQL queries and therefore SPARQL queries made through Ontop.

cmclscourtney commented 1 year ago

This index (for efficiency reasons) should be numeric and used to generate the iri which should also contain a unique table identifier. If the index is a string you can use the sql function hastext to generate a numeric one.