BONSAMURAIS / schema

Relational database schemas for BONSAI
BSD 3-Clause "New" or "Revised" License
0 stars 2 forks source link

Reference unit is not implemented #5

Open cmutel opened 4 years ago

cmutel commented 4 years ago

@boweidema I am having trouble understanding the language here, or at least how it would be implemented. For example, the wiki says:

Reference unit: This is the quantity of the flow to which the quantity of a datapoint should be seen as proportional to. For example, a flow of a specific quantity of CO2 from an activity may be related to another flow of this activity (e.g. 1 km) or to a time period (it may for example be the annual operation of this activity). In RDF, these relations must be made explicit for each datapoint, while in most raw data sources, the reference unit is implicit in the underlying schema (e.g. a schema-specification can be that numbers are always given per unit of the determining output of the activity).

However, it seems like we could just add a self-referential foreign key in flow which would accomplish the same, and drop the idea of a activities having reference flows altogether. It seems like there could be plenty of data sources where we might only have either activities or flows. Seems like an artificial limitation.