Couchbase Query


#1

I am trying to figure out if NoSQL / Couchbase is a good fit for my App. I have Data which stored in a json doc and i need to query. In my case there is a Array NPANXX which has 4 fields and i need to be able to query all docs to find if there is a match for me. In SQl it would be like

Select * from table where NPA = NPA and NPX = NPX and Start >= Start and End <= End

If so how could i do that in Couchbase and to make it faster would i create a View ?

{ "TYPE": "NECA4VH", "LOCALITY": "BEAR VALLEY", "CLLI": "BVLYCA11RS0", "VERT": 8300, "HORIZ": 8333, "COCODE": 5170, "LATA": 738, "CODE": { "NPANXX": [ { "NPA": 209, "NXX": 753, "START": 1000, "END": 1999 }, { "NPA": 209, "NXX": 753, "START": 2000, "END": 2999 }, { "NPA": 209, "NXX": 753, "START": 6000, "END": 6999 } ] } }