Skip to content

Commit f7a0e94

Browse files
author
Mohamed Sarwat
committed
Update README.txt
data loading and recommendation query
1 parent 74486a2 commit f7a0e94

File tree

1 file changed

+10
-1
lines changed

1 file changed

+10
-1
lines changed

README.txt

Lines changed: 10 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
R### Welcome to RecDB.
1+
### Welcome to RecDB.
22
An Open Source Recommendation Engine Built Entirely Inside PostgreSQL 9.2. RecDB allows application developers to build recommendation applications in a heartbeat through a wide variety of built-in recommendation algorithms like user-user collaborative filtering, item-item collaborative filtering, singular value decomposition. Applications powered by RecDB can produce online and flexible personalized recommendations to end-users. You can check out the code, as follows:
33

44
```
@@ -63,8 +63,17 @@ perl clean.pl [db_name] [server_host]
6363

6464

6565
### Loading Data
66+
We provide the MovieLens data to build a "Hello-World" movie recommendation application using RecDB. You can load the data using the sql script called "initmovielens1mdatabase.sql" stored in "./PostgreSQL" directory. We provide the dataset at "./PostgreSQL/moviedata / MovieLens1M/" directory.
6667

6768
### Recommendation Query
69+
In the recommendation query, the user needst specify the ratings table and also specify where the user, item, and rating value columns are in that table. Moreover, the user has to designate the recommendation algorithm to be used to generate recommendation. An example is given below:
70+
71+
```
72+
SELECT * FROM RATINGS R
73+
RECOMMEND R.itemid TO R.userid ON R.ratingval
74+
USING ItemCosCF
75+
WHERE R.userid = 1
76+
```
6877

6978
### Materializing Recommenders
7079

0 commit comments

Comments
 (0)