MemSQL has enabled in-the-moment analytics for a contact tracing app from True Digital Group Co., Ltd. (True Digital Group), the digital arm of True Corporation Public Company Limited, Thailandas leading telecommunication company.

The web portal aims to prevent COVID-19 spread in Thailand by using anonymized cell phone location data on 500,000 location events every second for over 30 million mobile phones to track population movement in two-minute intervals. This vast amount of real-time, geospatial data provides a view of population densities enabling the Thai government authorities to see when large gatherings are forming and quickly helps them to adapt their policies.

Prior to this pandemic, True Digital Groupas analytics team was already leading in the analytics space for telco, with the successful deployment of a platform able to crunch trillions of relevant customer data points like location, browsing etc. True Digital Groupas Analytics team successfully launched location services based on this, for example, to optimize retail branch locations. The computation strategy was to land data in Hadoop, then run map-reduce operations on the data on a scheduled batch basis every 24 hours to create the aggregates and derived data. However, the tool was designed to operate in batch mode and did not require a real-time result.

Then the pandemic hit, which changed everything. Now, the need changed from a adelayed-data-is-good-enougha mindset to an ain-the-moment, analytics with an SLAa mindset, as every second means increased potential for new cases. In order for the project to produce a meaningful result, the data process needs to be precise, accurate, and lightning fast.

Given how quickly the coronavirus was spreading, True Digital Groupas analytics team evaluated its options and went directly to MemSQL. It is known that MemSQL has a reputation for speed, scale and structured query language (SQL).

For fast-changing data, the response time of the backend database is a crucial component in ensuring a fast user experience. Based on its expertise in this space, True Digital Group identified MemSQL as being uniquely suited to these types of workloads, which require scaling to address the addition of new data and entail highly-concurrent lookup queries as well as complex analytic queries at speed.

MemSQL supports more than a trillion rows per second on raw data and comfortably handles the ingestion of 500,000 events per second.

The first...

To continue reading