Spectrum Computing

Thanks for the reply. If "undetermined" means there is some protection involved then the data looks suspicious to me. Around 60% (7369 out of 12329) of the "undetermined" downloads are tap files, meaning they have standard loaders. It's possible they have some other (non-tape bas...

1) The downloads table has a column schemetype_id, which can be NULL. There are also schemetypes with text "None" and "Undetermined". I assume "None" means explicit there is no scheme, which makes sense, but "Undetermined" seems to mean the same as NULL to me....

1) aliases contains a column `release_seq`. Should this sequence be called `alias_seq` instead? 2) The values in this sequence seem odd sometimes. For example, some entries have many records with sequence 0. (see entry_id 9292) I expected (entry_id, release_seq) to be unique. Is my assumption correc...

I agree about the "multiple tags" idea. It's not clear how practical moving to that would be though, rather than trying to fix up the data as much as possible within the existing schema. If a deeper analysis than I have done confirmed that there really it no meaningful difference between g...

There seem to be 3 genre types that are somehow educational types. > select * from genretypes where text like '%Edu%';; +----+--------------------+ | id | text | +----+--------------------+ | 69 | Educational (Misc) | | 18 | Game: Educational | | 36 | General: Education | +----+--------------------+...

I notice there are a smallish number of `entries` records (1499) where `genretype_id` is `null` Does this suggest: 1) Those entries in reality do have a genre, but it is not yet known/recorded? 2) Those entries in reality do have a genre, but it isn't one of the existing ones in `genretypes` table? ...