How to design Redis data structures in order to perform queries similar to DB queries in redis?
<p>I have tables like Job, JobInfo. And i want to perform queries like below - </p>

<p>"SELECT J.JobID FROM Job J, JobInfo B WHERE B.JobID = J.JobID AND BatchID=5850 AND B.Status=0 AND J.JobType&lt;>2"</p>

<p>How shall i go about writing my redis data types so that i can map such queries in redis? </p>

<p>IF i try to map the rows of table job in a redis hash for e.g. (hash j jobid 1 status 2) &amp; similarly the rows of table JobInfo in again a redis hash as (hash jinfo jobid 1 jobtype 3.)</p>

<p>So my tables can be a set of hashes. Job table can be set with entries JobSet:jobid &amp; JobInfo table can be set with entries like JobInfoSet:jobid </p>

<p>But i am confused in when i will do a SINTER on JobSet &amp; JobInfoSet. how am i going to query that hash to get keys? As in the hash content of set jobSet is not identical to hash content of table JobInfoSet (they may have different key value pair.</p>

<p>So what exactly am i going to get as an output of SINTER? And how am i going to query that output as key-value pair?</p>

<p>So the tables will be a collection of redis hashes</p>