For the URL Filter, the database is stored directly on the SWG appliance.  It is updated multiple times throughout the day, as often as once per hour.  Typical update size is ~300MB.