Queries
Query (pseudo-code)
One possible query (implemented as procedural pseudo-code):
tweets = {} // map from date to int
// Clear count for each date
for each date between '2016/03/01' and today:
tweets[date] = 0
// How many accounts started on 3/1/16? Record tweets by date for each.
accounts = 0
for each account in allAccounts:
if account.created == '2016/03/01':
accounts += 1
for each tweet in account.tweets:
tweets[date(tweet.timestamp)] += 1
// Print results, sorted by date
for each date between '2016/03/01' and today:
averageTweets = tweets[date] / accounts
print date, averageTweets
|