Search indices, at least in my experience, are denormalised views of relational data.

For search a Graph database would be my go-to if starting one now, not a NoSQL one.