Mongo Index for which documents have a nested key?

Question

I have objects that look like:

{
  ...
  sources: {
    source_1: { [metadata about source_1] },
    source_z: { [metadata about source_z] },
    source_a: { [metadata about source_a] }
  }
}

If a document has data from a source, the entry with that name exists. Otherwise it does not exist. eg this has only data from source_a:

{
  ...
  sources: {
    source_a: { [metadata about source_a] }
  }
}

What index can help me speed up looking for documents which have data from a given source? To be more precise, I don't care what data that source contributed, only that it is included (there is an entry with that key in the sources object).

Should I make an index for each source, eg {"sources.source_z": 1} ?

Want to be most efficient, so as to not index all the data in the source, just the existence of it.

score 1 · Answer 1 · edited Sep 28 '15 at 22:01

1

I would change the structure of your document into following if your sources are many in the order of hundreds. Otherwise you have to create index for each source value which is not practical:

{
  ...
  sources: [
    {type: "source_1", data: {...}},
    {type: "source_z", data: {...}},
    {type: "source_a", data: {...}}
  ]
}

With this data structure I would create an index on sources.type field.

edited Sep 28 '15 at 22:01

Jordan Warbelow-Feldstein

10,510
12
48
79

answered Sep 17 '15 at 15:30

cubbuk

7,800
4
35
62

Did you mean for sources to be an array or dictionary? – Jordan Warbelow-Feldstein Sep 27 '15 at 13:35
I meant array, I made an typo in the answer, I changed it now. – cubbuk Sep 27 '15 at 21:03

Mongo Index for which documents have a nested key?

1 Answers1