MapReduce + SQL from Greenplum

Comments off

Tag Database Schema

Source: http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html

mysqlicious sample datamysqlicious database stucture
In this solution, the schema has got just one table, it is denormalized.
This type is called “MySQLicious solution” because MySQLicious imports del.icio.us data into a table with this structure.

Intersection (AND)

Query for “search+webservice+semweb”:
SELECT *
FROM `delicious`
WHERE tags LIKE "%search%"
AND tags LIKE "%webservice%"
AND tags LIKE "%semweb%"

Union (OR)

Query for “search|webservice|semweb”:

SELECT *
FROM `delicious`
WHERE tags LIKE "%search%"
OR tags LIKE "%webservice%"
OR tags LIKE "%semweb%"

Minus

Query for “search+webservice-semweb”
SELECT *
FROM `delicious`
WHERE tags LIKE "%search%"
AND tags LIKE "%webservice%"
AND tags NOT LIKE "%semweb%"

Comments off

Basic Compute Cloud

Source : http://www.readwriteweb.com/archives/…compute_clouds.php

A traditional relational database architecture >

A compute cloud architecture, to resolve multiple issues, looks like >

Comments off