Redenormalisation: Building a search index, the other way

What happened
Why unobtanium doesn't go by the textbook when it comes to normalisation in the search index.
Summary assembled by rule from the sources below

Why unobtanium doesn't go by the textbook when it comes to normalisation in the search index.
Summary assembled by rule from the sources below