On April 3rd, Tea Pain released an article, “The Trump-Russia Data Machine” that got the internet buzzin’ about the possibility that the unexplained computer traffic between Trump Tower, Russia’s Alfa Bank and Spectrum Health had been deciphered. In just 3 days, over 80,000 viewers read how these 3 unrelated businesses were possibly sharing a growing database of targeted voter rolls through a process known as Database Replication.
Database Replication is a simple concept where 2 or more large databases in different locations stay in sync with one another by broadcasting hourly changes to each other. Building on the analysis of data scientists, Tea Pain was able to theorize that this common business practice is how the data was being stored and passed back and forth to Russian intelligence without raising undue suspicion.
But the article raised additional questions. The new hourly replication theory could be easily debunked if there were more than 24 connections made between Trump Tower and Alfa Bank in one day. Tea Pain contacted key sources on Twitter and soon got his hands on the leaked raw data. Tea loaded the IP transactions into SQL Server and proceeded to see if his theory would stand up against the raw data. What he found caused him to erupt into a cautious “end zone dance” of patriotic optimism.
The data was totaled by connections per day and reflected precisely what Tea Pain’s theory had predicted. Since data is only copied when changes were made, there would scarcely be a day where changes were being made every hour of the day. Tea Pain also discovered that there were few connections during the early days of the database, but those connections grew as the databases grew in size. These connections ceased entirely when the suspicious traffic was discovered and Trump IT pulled the process offline.
UPDATE: Trump Tower uses a Contact Management System from Cendyn that uses SQL Server. The tools needed to achieve this replication were already installed. Tea Pain has been in touch with one Ivy League college and a number of media outlets. This new explanation is causing data analysts to look in new places to reconstruct what appears to be massive data collusion between the Trump Campaign and Russian Intelligence.