I'm trying to build a query optimizer for survey response data, all questions are stored in a collection and have some fields are
Now I'm trying to build a query tool where user can run query like
Q.option_marked == 1 && Q.option_marked == 2 // i.e where option_marked is 1 and 2 both Q1 == Q2 // i.e all the questions where options selected are same as other Q.option_marked == 1 || (Q1 == Q2) // i.e. multiple conditions
Well this can be more generalized.
Currently I've come across various techniques like
bitmap indexing(although not supported in mongodb yet), wildcard indexing but, I cannot optimize this query as it's dynamic and question has like 10 varieties least, the survey data will be huge e.g. the CSV file is over 10GB.
Can someone guide me into the right direction?