| | Posted: 24 Nov 2023 18:07 | |
totototo
Posts: 10
Joined: 2023-11-23
| | Hello,
I have just noticed in the sports table, 'ESports' is spelled like this.
While for the league 4514, the sport is noted 'Esports'.
This is a small inconsistency (S instead of s) but it is a bit worrying.
1) I am new to this, I have looked at it briefly, but have no idea how to correct it. I can't see any access to league tables.
2) I am very worried that the database is full of such inconsistencies. The name 'Esports' should only be written once in your database. It should not be possible to have such an inconsistency. Is the whole database like this?
I should not need to explain that in relational databases, each information should only be stored once and when needed retrieved via ids. But most likey the explanation is another one: strings are modified after fetching the info from the database.
In any case, that's wrong.
Let me know!
| |
 |
| | Posted: 24 Nov 2023 18:20 | |
totototo
Posts: 10
Joined: 2023-11-23
| | Similarly, league 4975 has 'Olympics' for sport but there is no Olympics in the sports list.
| |
|
| | Posted: 24 Nov 2023 18:32 | |
totototo
Posts: 10
Joined: 2023-11-23
| | League 5305 has 'MotorSport' instead of 'Motorsport'.
| |
|
| | Posted: 24 Nov 2023 19:25 | |
zag
Posts: 3,330
Joined: 2020-03-23
| | Yes all the fun of importing from multiple sources 
I'm happy to correct on the backend. Thanks for the feedback. It may take a few days but I will normalise it.
Just a reminder that we are a community driven DB, we don't just resell other peoples services. We create our own data and it has evolved over time. But saying that, this is definitely worth fixing so thanks for bringing it up.
| |
|
| | Posted: 24 Nov 2023 23:18 | |
totototo
Posts: 10
Joined: 2023-11-23
| | Great to read.
I can certainly understand how hard it must be to get data from different sources. It must be a nightmare.
This said, I don't know how the data is structured internally but it should not be possible to enter a sport string that is not in the list of sports. There needs to be a check when the data is imported. It should be rejected until the inconsistency is resolved.
My 2 cents.
zag | |
|
| | Posted: 26 Nov 2023 22:31 | |
totototo
Posts: 10
Joined: 2023-11-23
| | You probably already know that but there are many team names that have the same id but different spellings. This is the same type of error that the ones shown above. This should absolutely not be possible in a DBMS.
| |
|
| | Posted: 27 Nov 2023 08:19 | |
zag
Posts: 3,330
Joined: 2020-03-23
| | You probably already know that but there are many team names that have the same id but different spellings. This is the same type of error that the ones shown above. This should absolutely not be possible in a DBMS.
Well technically you are correct 
...but in the real world teams change name and keep the same ID.
It happens all the time in sports when a sports club rebrands.
| |
|
| | Posted: 04 Dec 2023 19:34 | |
zag
Posts: 3,330
Joined: 2020-03-23
| | The strSport categories have now been normalized.
This was actually a bug from the SEO improvements I've been making recently.
| |
|