StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORecruitment Management Portal Datastore / Schema Design For MongoDB
text
Body
copied!<p>I want to use MongoDB for creating a SAAS Recruitment Management Portal, which will address following use cases,</p> <ol> <li><p>One smart HR Manager would register their company on portal ( hence two resources found so far An HR Manager , and A Company )</p></li> <li><p>Company will have it's own profile page like <a href="http://myportal.com/abccompany" rel="nofollow">http://myportal.com/abccompany</a> ( same as twitter does )</p></li> <li><p>After registration HR Manager can invite other HR managers from her company ( business validation applied here is same as yammer , domain name based access user1@company1.com can invite anyuser@company1.com )</p></li> <li><p>After inviting all possible employees , HR Manager will start posting Jobs ( we found third resource now , A New Job Opening !! )</p></li> <li><p>After creating a new Job Posting we get URI for that Job , which could be published in Social media, other job portals etc..</p></li> <li><p>If communicated right, A Candidate would get interested in a Job Opening at Abc Company and he will make a Job application after registering a Candidate profile on our portal. ( we found two more resources now Candidate and A Job Application )</p></li> <li><p>Job Application is the resource where we will have most of the transactional data , this resource will keep changing fast as Job Application will traverses thru and will capture multiple phases of recruitment activities ), rest of the resources are mostly read only.</p></li> <li><p>Down the line, there will be a huge database of Candidates which is intended to be kept separate from other data so as to reuse them as Candidate Profile, that means Candidate data is not tied to a specific Company.</p></li> </ol> <p>How do I model this in MongoDb ( preferably using Morphia - A java library ) to achieve following goals,</p> <ul> <li>To get optimize queries on Job Application resource</li> <li>To get the advantage of full text search provided by MongoDB </li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload