Yahoo7 swaps SQL for graph database

 

Changes information architecture to improve user experience.

Yahoo7 is rolling out a semantic publishing platform across the web sites that promote Channel 7’s local free to air programs, building its new content systems atop an open source graph database.

Craig Penfold, CTO Yahoo7 was inspired by a similar project undertaken by the BBC, which initially launched semantic web publishing for the channel’s 2010 World Cup website to increase viewer engagement.

After conducting research and discussions with BBC and Yahoo, the Yahoo7 team chose to change the datastore from a standard SQL database to a graph database.

Leveraging know-how from Yahoo US, Yahoo7 partnered with an American open source company called Systap for assistance in designing the semantic site. Systap offers consulting services around the Bigdata open-source graph database, which is written entirely in Java.

The front-end of Yahoo7's new site is based on HTML5.

Penfold told iTnews that standard TV websites group content for any show into format types such as galleries, videos, articles, “but that’s not the way viewers want to interact with a TV website."

Viewers, he said, "want to view all the relevant content dynamically, [as they relate to] teams, competitors, locations and judges.

“By changing the underlying datastore we are able to pull in all the content around a character dynamically and at scale.”

A team of eight - including a product manager, editor, engineering, front end developers and data scientists developed and rolled out the semantic web publishing, initially on the Home and Away web site.

In order to graphically represent the content, the team are required to understand the format, e.g. text, video, image, but also its context. Relationships are then inferred between the entities into a graphical structure. For example, a scripted drama would involve cast, characters, episodes and storylines.

Native advertising is now injected into the stream of content rather than being served in an embedded site. This allows advertisers to customise the advertising to reflect the themes of the program and improve engagement with the advertising.

The new site resulted in a 30 percent increase in page opens, 65 percent increase in video starts and a 200 percent increase in time spent on the site.

After the Home and Away site, the technology was rolled out to 'My Kitchen Rules' and 'House Rules' with 'X Factor' joining the semantic structure soon.

Copyright © iTnews.com.au . All rights reserved.


Yahoo7 swaps SQL for graph database
Craig Penfold, CTO, Yahoo7.
 
 
 
Top Stories
Meet FABACUS, Westpac's first computer
GE225 operators celebrate gold anniversary.
 
NSW Govt gets ready to throw out the floppy disks
[Opinion] Dominic Perrottet says its time for government to catch up.
 
iiNet facing new copyright battle with Hollywood
Fighting to protect customer details.
 
 
Craig Penfold, CTO, Yahoo7.
Sign up to receive iTnews email bulletins
   FOLLOW US...
Latest Comments
Polls
In which area is your IT shop hiring the most staff?




   |   View results
IT security and risk
  26%
 
Sourcing and strategy
  12%
 
IT infrastructure (servers, storage, networking)
  22%
 
End user computing (desktops, mobiles, apps)
  15%
 
Software development
  25%
TOTAL VOTES: 346

Vote
Would your InfoSec team be prepared to share threat data with the Australian Government?

   |   View results
Yes
  58%
 
No
  42%
TOTAL VOTES: 144

Vote