Dimensional Model for Online Job Portal

View previous topic View next topic Go down

Dimensional Model for Online Job Portal

Post  arunay1 on Thu Apr 08, 2010 5:59 am

This is with respect to designing a warehouse for Online Job Portal. The brief business environment is as given below

User has many versions of “Curriculum Vitae” on the site
Corporate posts Job
Candidates apply to the posed job

1.Users are created on Job portal. There are two types of user
a. Job Seekers - Candidates
b.Job Providers – Corporate

2.Each Curriculum Vitae has multiple:-
a. Desired Role: Project Manager, Project Lead
b. Applicable Functional Areas: Shipping, Supply Chain
c. Preferred Location: Boston, New York, Ohio
User can change attributes of Curriculum Vitae at any point like a adding a new preferred location or adding a new Functional area.

3. Corporate post job.
4. Each Job has multiple fulfillment criteria
a. Role: Project Manager, Supervisor
b. Job Location: Boston, Bejing, Tokyo
c. Education: Undergraduate, Diploma in Science

5. Applicants apply for a job online.

The questions which are usually asked are:-
1. No of applications per day.
2. Number of candidates for each job criteria.
3. No of applications which do not meet job criteria
4. Avg. number of applications per user
5. Avg. number of applications per “Curriculum Vitae”

I read the book The Data warehouse Toolkit by Ralph Kimball but could find a definitive answer solution. I thought of using Bridge tables and keeping all combinations of Roles, Locations, Education, and Functional area. But after some calculation I find the number of combinations is huge. Please help and suggest some options

Thanks in advance.
Arunay

arunay1

Posts : 2
Join date : 2010-04-08

View user profile

Back to top Go down

Re: Dimensional Model for Online Job Portal

Post  ngalemmo on Thu Apr 08, 2010 11:39 am

The number of combinations you calculate and the number of combinations that actually exist are two different things. The latter is a much, much smaller number... by many orders of magnitude.

Wither you need to create unique groups or simply have an associative entity is a matter of the nature of the data and the kinds of analysis you want to do.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensional Model for Online Job Portal

Post  arunay1 on Fri Apr 09, 2010 3:17 am

Thanks you very much for your response ngalemmo.

arunay1

Posts : 2
Join date : 2010-04-08

View user profile

Back to top Go down

Re: Dimensional Model for Online Job Portal

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum