The Northern California Oracle Users Group meeting Thursday, May 17, at PayPal in San Jose was a huge success.
Griddable.io demonstrated its new SaaS service for heterogenous database synchronization, using a grid running on Amazon AWS during the meeting. The Griddable.io demo synchronized two databases using a huge dataset of 311 calls from the City of New York.[i] After the source and target databases were connected to the grid, Griddable.io automatically copied the initial records in the source, and then synchronized each new record from the source to the target as it was added in the source.
Griddable.io also demonstrated the use of its policy engine to filter and transform data during synchronization. Only records for one selected city agency, the NYPD, were synchronized to the target demonstrating how selective data synchronization can enable both database reorganization and privacy.
After the event, the Northern California user group hosted its annual karaoke competition at Casino Matrix in San Jose. Many local data architects, DBAs, software developers, solution architects and other attendees demonstrated impressive musical talent.
[i] This data is publicly available from https://nycopendata.socrata.com/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9