search

spine-tools / Spine-Database-API

Database interface to Spine generic data model
https://www.tools-for-energy-system-modelling.org/
GNU Lesser General Public License v3.0
6 stars 5 forks source link

Index (dimension) name clashes - how to handle? #241

Open soininen opened 1 year ago

soininen commented 1 year ago

Currently, it is possible to have clashing index names in indexed values, e.g. all nested Map indices are called 'x' by default. Also, it is possible to name the indices as 'parameter', 'entity_class', 'alternative' etc. potentially clashing with "implicit" index names. It is starting to be a bit of a problem already when plotting data in Toolbox (see spine-tools/Spine-Toolbox#2057).

I am not sure if there is much we can do about it with the current design, but maybe this is something we can set straight with the upcoming new database structure with its Dimensions. Any ideas?

jkiviluo commented 11 months ago

Dimensions should handle this. Dimension table will have unique name constraint.