Existing Solutions Prove Inadequate in Many Ways
Current solutions in use, namely MySQL and Microsoft SQL Server, utilize multiple tables to cope with the large quantities of energy data involved, measured in trillions of rows. Tables exist for each plaza, type of energy consumption, time, and monthly energy summaries and so on. As a result Wanda found it had to manage tens of thousands of tables leading to significant complexity, operational inefficiencies, and increased cost. The business wanted real-time reports, but the current solutions were unable to deliver real-time reporting and analysis and could only serve up reports from a cache of older stale data. The problems would only get worse, as Wanda predicts to grow to nearly 500 plazas, almost tripling the daily data ingest volume, and accounting for some 70 trillion rows of data and 100s of TB by 2021 exceeding the scale available from the existing solutions.