electronics
electronics/televisions
electronics/televisions/tube
electronics/televisions/lcd
electronics/televisions/plasma
electronics/portable electronics
electronics/portable electronics/mp3 players
electronics/portable electronics/mp3 players/flash
electronics/portable electronics/cd players
electronics/portable electronics/2 way radios
Alternatively it would make more sense to base the materialized path off of an immutable field such as the PKey of the record (in the same order as the paths above, from the article): 1
1/2
1/2/4
1/2/5
1/2/6
1/3
1/3/7
1/3/7/10
1/3/8
1/3/9
This has the following advantages: * Node insertion/deletion overhead is low / does not require updating other nodes unlike nested set model
* Query for subnodes is easy: "select * from tree where path like 'electronics/televisions'". To get only direct subnodes add a parent_id specifier.
* Getting the full path for a node is easy: it's built into the node itself
* Node depth is easy: count the number of path "segments"
Downsides: * Moving sub-tree requires updating all sub-node paths
Hope this helps someone!
From my simple understanding, this is a management application layered on top of the Mechanical Turk platform which is able to provide more robust/advanced management and analytics in terms of tracking the quality and speed of repeat turkers, as well as being able to integrate with other commoditized/outsourced labor systems. Due to being able to maintain more state concerning tasks and turkers, they are able to provide valuable intelligence about how trustworthy and accurate the results are.
It was very interesting during the Q&A when Bradley Horowitz asked the company rep if he thought that Amazon might simply do this themselves - but the presenter stated firmly that they had a pretty good personal relationship with the people at Amazon and they took pride on the turk service as really being a black box type of platform.
Regardless, the main problem this business faces (which was handily pointed out by the experts) is the issue of gaining traction - how do you make big businesses aware of this as a possible solution to their labor issues? Even at MySpace where they pay 300 people to moderate photos for obscenity they have not realized they could much more effectively and cheaply be leveraging MT for this task.