Ask HN: Good datasets for studying RDBMS in depth
2 comments
See
https://www.microsoft.com/en-us/download/details.aspx?id=524...
and other data generators for various TPC tasks. These usually have a knob you can turn to scale the size up or down.
https://www.microsoft.com/en-us/download/details.aspx?id=524...
and other data generators for various TPC tasks. These usually have a knob you can turn to scale the size up or down.
Sakila is BSD and used on a few sites I visit: https://www.jooq.org/sakila
I have a fundamental knowledge on RDMS and have done data modelling in Postgresql (to some extend). I could able to make sense of what is Normalization, Joins, locks (specifically optimistic locking) etc.
I have learnt all these in my side projects mainly, or in production where the data isn't much huge. I haven't got any chance to debug a slow query or even select Indexing strategies etc which I guess is really important to understand RDMBS or postgresql in general.
I wanted to know are there any open source datasets, which will helpful for self studying or even debugging slow queries / seeing their indexing strategies etc.
Any answer would be appreciated.