So, I’ve created an app/database that catalogs and compares information about professional lighting fixtures.
Each fixture has a list of various features/attributes that are associated with it.
Fixture A has features [Iris, AnimationWheel, GoboWheel, Strobe]
Fixture B has features [Iris, FramingShutters, GoboWheel, Frost, ColorMixing, ColorWheel]
Fixture C has features [FramingShutters, GoboWheel, Strobe, ColorWheel]
and so and so on for as many as 1000 fixtures or so.
What I need help with is figuring out the process of ranking/comparing all of these fixtures based on their features. So two fixtures with the exact same set of features would be a perfect match, whereas two fixtures with none of the same features would be not at a match at all. And then a ranking of similar fixtures in between.
The idea is that viewing a page of any single fixture will provide a list of “similar fixtures” ranked by how similar this page’s features are to other fixtures’ features.
The features are known, in that I have a table of “features” that each “fixture” references.
I keep thinking/hoping that the “rank by” function would be helpful in this, but I just can’t quite figure out how. I know I need to involve more numbers somewhere in all of this…
I have no doubt there is a solution to this, and while I have a fairly strong understanding of databases and basic expressions, this sort of data science is just a little beyond me. Any help you can provide would be amazing! Thanks!