Storing fields with nested values in Apache SOLR

Question

I have a Doc[id, text, creator, date] object which has a one-many relationship with Topic[name, description, sentiment] objects. Here is one way to design this schema

A fully flat structure, i.e. 1 field for each doc property and 3 fields each for each topic. So, if I have 5 topics for a doc, I will have 3*5=15 Topic fields. The problem is this is too flat and I am losing the hierarchy. Moreover, as every doc will have a different topic count, I have to allocate a large number of fields for topics irrespective of whether I need it or not. I guess this is not a problem in SOLR but it is not flexible from a programming and data storage point of view. Moreover, I also will like to query on each of this doc and topic properties.

Is there a better SOLR way which is more structured and hierarchical?

Persimmonium · Accepted Answer · 2013-12-28 20:44:59Z

1

As you say, flattening the docs is no problem at all in Solr, even though from a SQL standpoint looks wasteful.

But, if you want to keep a more SQL-like relationships, look at Block joins in Solr. I would go with flattening unless joins are strongly required, it would simplify your config.

answered Dec 28, 2013 at 20:44

Persimmonium

15.8k12 gold badges51 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Storing fields with nested values in Apache SOLR

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related