s taken negotiating the information governance arrangements. Social Finance Limited +44 (0) 20 7770 6836 87 Vauxhall Walk, London SE11 5HJ socialfinance.org.uk 85 Warehousing This describes the step in the processing of data where the data is being kept once it has been cleaned, formatted and matched. This is where most data is pulled from for users of the TFD to view. Planned Switch to Remotely Hosted “Data Lake” Bristol City Council is moving to a Data Lake approach for storing the data. This means that larger amounts of raw data would be kept on the server without first transforming it into a predetermined shape, alongside any processed data which is later derived from it. The advantages of this change would include, data not having to be transformed into a tightly defined schema for data before it is added, and defining schemas and data structures would not have to be done in advance. It would also retain flexibility in that, if you need to change the shape of the final product, you could easily adjust the code for transforming the raw data and run it again to get the updated version. In tandem with this architectural change, the council has been considering moving to a “cloud-based” hosting solution with Microsoft Azure. This would mean there is no up-front cost of purchasing computers to hold the database, as the council would not own the servers the TFD is on, but rather rent storage and processing on Microsoft’s network. This would mean cheaper up-front costs and reasonable storage costs, but likely higher costs of renting the processing power to perform data processing and transformation, which could potentially make the new system more expensive to run overall. Scaling the system to add more processing storage and processing power when needed would also be sim