Now that the tag synonyms are implemented, how does it affect the monthly data dump?
Should the data dump have the list of tag synonyms?
Yes, this should be added since it's public information. I don't think there will be many queries wanting to run on this table, but making the data available will let us get statistics on the tag synonym performance itself.
Adding this information as a new table would make the most sense, and it wouldn't be difficult to implement. Here is how the schema would look in Data Explorer:
TagSynonyms ----------- SourceTagId (FK to Tags.Id) TargetTagId (FK to Tags.Id) Creator (FK to Users.Id) CreatedDate (DateTime, NOT NULL) RenameCount (int, NOT NULL) LastRenameTime (DateTime, NULL) PK: (SourceTagId, TargetTagId)
The only column I'm not sure about is
The tag synonym system is still in development, so I would imagine this is already