Media Sensors for the Global Brain + databases (Semantic, SQL)
Dynamic rating systems are typically built with Ajax, JSON, php and an SQL database. For the Media Sensors it’s helpful to be able to track who’s designated a rating (so incorporate some type of log-in for each rating or recognition of cookie information), allow only one rating per user on any particular item on a site and to facilitate analysis of that rating on an ongoing and dynamic basis. Elements of semantic search querying will also need to be included.
Ultimately, the Media Sensors solution will be integrated with comments and rss feeds in an intuitive manner as shown by this example using a 5-star rating solution.
There are lots of ways to include comments in rating systems and what would be interesting is to investigate whether it’s possible to modularize comment panels so they can be propagated elsewhere to similar content.
In any case, I spent this weekend creating SQL databases. Here’s an example of an extremely simple one with its query:
//declare the SQL statement that will query the database
$query = “SELECT id, name, year “;
$query .= “FROM cars “;
$query .= “WHERE name=’BMW’”;
with its generated result:
It isn’t only the front-end UI / applet that needs to be user-friendly and simple. The back-end or database also has to be highly functional and enable accurate surfacing of previously input user-generated content so that it’s searchable, semantic, can be analyzed and serves to also calibrate 360-2020 insights on users’ tastes, preferences and perceptions — in conjunction with the front-end Media Sensors.
It’s shaping up, as they say………………….
Tags: global brain, Media Sensors, Rating systems, SQL
