Design issue: symfony2 , doctrine2, mysql DB

Question

I am wondering how to design this best, so i do not re-invent the wheel

i have a rating Entity:

    /**
 * Type of the read of this comment,for example quality
 *
 * @ORM\Column(type="string")
 */
protected $type;
/** @ORM\Column(type="datetime") */
protected $created;

/** @ORM\Column(type="integer") */
protected $thread;
/**
 *
 *
 * @ORM\ManyToOne(targetEntity="User")
 */
private $user;

/**
 * @ORM\Column(type="decimal", scale=2)
 */
protected $value;

where the type, is the type of rating, for example for "file.quality" or "file.story", for shared videos.

now i want to open the details page for the video, and have the total rating showing (as average of all users....also there are ratings, which have nothing to do with users, but coming from other places ....like IMDB (internet movie database) ratings.

i am thinking of adding a CompleteRating entity, where i save the average rating and update it directly, whenever a user adds a new vote into Rating Entity. Maybe through a listener class in symfony2.

is this the best design way? how would you handle this best?

CriticalImpact · Accepted Answer · 2012-03-30 12:22:13Z

1

I believe there a couple of ways you could do it, whether or not there is a best way is really dependant on how often you want your ratings to update, whether or not you want the server to get stressed, etc

1) You could have two columns in your video entity, CompleteRating, LastRatingUpdateTime. In your repository you could have a GetRating function, whenever it's called it checks the last update time, if it's say an hour later compared to the last rating update, run a database query that updates the rating and output the new rating. This of course means users have to wait to see their votes count but it means that server stress is going to be lower.

2) Perhaps you could hate two separate ratings, 1 for outsourced ratings(IMDB, etc) that only gets updated every night via a cronjob and then the individual ratings that get either calculated when a user adds a rating or even just on the fly, databases are very quick at this sort of thing.

My vote would be 2, it really depends how intensive the code you have in place for scraping IMDB ratings is.

answered Mar 30, 2012 at 12:22

CriticalImpact

6904 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Confidence Over a year ago

thanks man, how about 3. adding a row with IMDB rating (non user rating), in the rating table, but with 0 or null as user-id? i tried it though with doctrine2, and it gives me an error, as of user does not exist...so maybe this is another workaround?....also there are different kinds of ratings in the same ratings table: "rating_quality", "rating_sound"....etc...also i am planning in future to put rating for users like "rating_user_credibilty"....etc.

Cerad Over a year ago

/** @ORM\Column(name="user_id",nullable=true) */ will take care of the user does not exist problem.

Collectives™ on Stack Overflow

Design issue: symfony2 , doctrine2, mysql DB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related