PROPOSAL FOR JOB PORTAL DEVELOPMENT – 7C Frameworks – Recommender System
PROPOSAL FOR JOB PORTAL DEVELOPMENT – 7C Frameworks – Recommender System
0 0
jmp
Job Matching Portal PresentationOn Github duybuivn / jmp
PROPOSAL FOR JOB PORTAL DEVELOPMENT
Duy T. Bui duybui.vn@gmail.com Long P. Vu longvu88@gmail.comWhat is job matching portal?
Job Portal + Recommender System + Matching System
7C Frameworks
Bens Paradamean-2008
Context.
Content.
Community.
Customization.
Communication.
Connection.
Commerce.
Sudiana & Ben Parademean-01/2014
Liferay Enterprise Framework
10
Why use liferay portal for JMP
Recommender System
"Recommender engines (REs) also known as recommender systems are software tools and techniques providing suggestions to a user. The suggestions provided are aimed at supporting their users in various decision making processes such as what items to buy, what music to listen, what profiles to browse, or what news to read" " Recommender Systems Handbook - 2011 Francesco Ricci, Lior Rokach, Bracha Shapira, Paul B. KantorCollaborative filtering
Content-based filtering
The flow of information in Recommender system
Matching System
Problem???
Steaming process
Dynamic Database
In Content+ In Schema+In Query
Diagram of Dynamic database management
Structure of Dynamic database management system
Examples
* Meta-Table
tableID | TableName
--------------------------------------
1 | LearningOpportunity
2 | JobVacancy
3 | LWCArticle
4 | author
5 | LFMArticle
6 | LearningInstitution
7 | Job
8 | Language
9 | Skill
10 | Tag
* Meta-Column
ColID | ColName | TableID
------------------------------------------------------
1 | JobID | 7
2 | JobTitle | 7
3 | JobDescription | 7
4 | LanguageID | 8
5 | Language_Name | 8
* Meta-Row
RowID | RowType | ColID | TableID | Row Content
---------|--------------|------------|--------------------------------------
1 | Varchar | 2 | 7 | Java Developer
2 | Varchar | 2 | 7 | Software Engineer
3 | Varchar | 5 | 8 | Khmer
*Meta-document
DocumentID | Documents Content | RowID
--------------------------------------------------------
1 | Java Developer at CSC Vietnam | 1
2 | Software Engineer in 3 year | 2
3 | Software Engineer and speak Khmer | 23
*Meta-store
DocunementID | ColID | TableID | RowID
-------------------------------------------------------
1 | 2 | 2 | 1
2 | 2 | 2 | 2
3 | 25 | 24 | 23
*Folder
FolderID | FolderName
_____________________
7 | Job
8 | Skill
9 | Language
Advanced Search
IR+Full-text search+Boolean Search
Query creating a document
CREATE TABLE `document` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) DEFAULT NULL,
`body` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`body`)
) ENGINE=MyISAM;
Query inserting document
INSERT INTO `document` VALUES
(1,'Database Admin','using MySQL query to manage System ...'),
(2,'Experience Database','Five years experience in ...'),
(3,'Description','I am admin of CSC Vietnam ...'),
(4,'Language','1. Mother tongue: Vietnamese, 2. Frequency in English ...'),
(5,'Database Tools','using MySQL Workbench, MySQL GUI Tools ...'),
(6,'Database Security','When configured properly, Database ...');
;
Tables
+----+--------------------+----------------------------------------------------------+
| id | title | body |
+----+--------------------+----------------------------------------------------------+
| 1 | Database Admin | using MySQL query to manage System ... |
| 2 | Experience Database| Five years experience in ... |
| 3 | Description | I am admin of CSC Vietnam ... |
| 4 | Language | 1. Mother tongue: Vietnamese, 2. Frequency in English ...|
| 5 | Database Tools | using MySQL Workbench, MySQL GUI Tools ... |
| 6 | Database Security | uWhen configured properly, Database ... |
+----+--------------------+----------------------------------------------------------+
Searching "MySQL"
mysql> select * from document WHERE MATCH(title,body) AGAINST ('MySQL');
+----+--------------------+-------------------------------------------------+
| id | title | body |
+----+--------------------+-------------------------------------------------+
| 5 | Database Tools | using MySQL Workbench, MySQL GUI Tools ... |
| 1 | Database Admin | using MySQL query to manage System ...' |
+----+--------------------+-------------------------------------------------+
2 rows in set (0.01 sec)
Tables
+----+--------------------+----------------------------------------------------------+
| id | title | body |
+----+--------------------+----------------------------------------------------------+
| 1 | Database Admin | using MySQL query to manage System ... |
| 2 | Experience Database| Five years experience in ... |
| 3 | Description | I am admin of CSC Vietnam ... |
| 4 | Language | 1. Mother tongue: Vietnamese, 2. Frequency in English ...|
| 5 | Database Tools | using MySQL Workbench, MySQL GUI Tools ... |
| 6 | Database Security | uWhen configured properly, Database ... |
+----+--------------------+----------------------------------------------------------+
Searching "MySQL admin"
mysql> select * from document WHERE MATCH(title,body) AGAINST ('MySQL admin');
+----+--------------------+-------------------------------------------------+
| id | title | body |
+----+--------------------+-------------------------------------------------+
| 1 | Database Admin | using MySQL query to manage System ...' |
| 5 | Database Tools | using MySQL Workbench, MySQL GUI Tools ... |
| 3 | Description | I am admin of CSC Vietnam ... |
+----+--------------------+-------------------------------------------------+
2 rows in set (0.01 sec)
Natural Query Language
mysql> select * from articles WHERE MATCH(title,body) AGAINST ('database');
Empty set (0.00 sec)
OR
mysql> select * from articles WHERE MATCH(title,body) AGAINST ('database' IN BOOLEAN MODE);
+----+--------------------+----------------------------------------------------------+
| id | title | body |
+----+--------------------+----------------------------------------------------------+
| 1 | Database Admin | using MySQL query to manage System ... |
| 2 | Experience Database| Five years experience in ... |
| 5 | Database Tools | using MySQL Workbench, MySQL GUI Tools ... |
| 6 | Database Security | When configured properly, Database ... |
+----+--------------------+----------------------------------------------------------+
6 rows in set (0.00 sec)
AND/NOT
mysql> select * from articles WHERE MATCH(title,body) AGAINST ('+database -admin' IN BOOLEAN MODE);
+----+---------------------+------------------------------------------+
| id | title | body |
+----+---------------------+------------------------------------------+
| 2 | Experience Database | Five years experience in ... |
| 5 | Database Tools | using MySQL Workbench, MySQL GUI Tools...|
| 6 | Database Security | uWhen configured properly, Database ... | |
+----+---------------------+------------------------------------------+
1 row in set (0.01 sec)