In the current BDC model, the bands are related to the collections table and there is no sensor table. The relationship is 1:N from collection to bands, so the same band cannot be in more than one collection at the same time.
In the case of the DGI catalog, as there is more than one collection that uses the same sensor, there is duplication of band information, which may not be the ideal.
To resolve this issue, I would suggest creating a sensor table between collections and bands.
Taking advantage of this possible normalization, wouldn't it be interesting to normalize more by creating tables to contain satellites and processing levels? I would just like to raise this issue.
In the current BDC model, the bands are related to the
collections
table and there is no sensor table. The relationship is 1:N from collection to bands, so the same band cannot be in more than one collection at the same time.In the case of the DGI catalog, as there is more than one collection that uses the same sensor, there is duplication of band information, which may not be the ideal.
To resolve this issue, I would suggest creating a
sensor
table betweencollections
andbands
.Taking advantage of this possible normalization, wouldn't it be interesting to normalize more by creating tables to contain satellites and processing levels? I would just like to raise this issue.
Thank you in advance.