Film and Video Labelling Body of NZ
This site is a constant stream of updating data. The organisation has a database with hundreds of thousands of film (and other types of media) rating information. The purpose of the site is to display some of the vast information they have on a website in a way that helps the FVLB do what they do without answering queries all day long when people/organisations need to find out rating information for various media types.
The data that they hold in their internal system (a custom application that uses Microsoft SQL to store the data) needed to be synchronised to the website – constantly. After researching their specific requirements, I decided an XML Web-Service would be the best way to get the data from the SQL server in-house to the MySQL server at the web host.
The system checks for new records frequently, and only grabs the records that are new or have changed since the last sync. There is all sorts of filtering to only display the types of records that the FVLB wanted to have displayed to the public.
In addition to the synchronisation system, there is also a powerful search system for the public to find what they want on the website.
The latest films and displayed on the home-page of the FVLB website along with an RSS feed for those who constantly monitor the information.