Internet Live Statistics How much data do we create every minute ? - PowerPoint PPT Presentation

Internet Live Statistics

How much data do we create every minute ? Forbes, May 2018 • Snapchat users share 527,760 photos • More than 120 professionals join LinkedIn • Users watch 4,146,600 YouTube videos • 456,000 tweets are sent on Twitter • Instagram users post 46,740 photos

How much data do we create every minute ? Forbes, May 2018 • We send 16 million text messages • There are 990,000 Tinder swipes • 103,447,520 spam emails sent • There are 154,200 calls on Skype

How much data do we create every minute ? Forbes, May 2018 • The Weather Channel gets 18,055,556 forecast requests • Venmo processes $US 51,892 peer-to-peer transactions • Spotify adds 13 new songs • Uber riders take 45,788 trips! • 600 new page edits to Wikipedia

pID name team teamPhone pos1 pos2 pos3 1 Pessi Argentina 54-11-1000-1000 str for 2 Ricardo Portugal 351-2-7777-7777 rm dm 3 Neumann Brazil 55-21-4040-2020 for lb rb 4 Baily Wales 44-29-1876-1876 dm st 5 Marioso Argentina 54-11-1000-1000 sw dm st 6 Pare Brazil 55-21-4040-2020 go

Insert Anomaly pID name team teamPhone pos1 pos2 pos3 1 Pessi Argentina 54-11-1000-1000 str for 2 Ricardo Portugal 351-2-7777-7777 rm dm 3 Neumann Brazil 55-21-4040-2020 for lb rb 4 Baily Wales 44-29-1876-1876 dm st 5 Marioso Argentina 54-11-1000-1000 sw dm st 6 Pare Brazil 55-21-4040-2020 go ➡ ∅ ∅ ∅ ∅ ∅ Iceland 354-5-109-20 We can't add another team until we have a player on that team since the pID is the primary key.

Update Anomaly ➡ pID name team teamPhone pos1 pos2 pos3 1 Pessi Argentina 54-11-1000-1000 str for 2 Ricardo Portugal 351-2-7777-7777 rm dm 3 Neumann Brazil 55-21-4040-2020 for lb rb ➡ 4 Baily Wales 44-29-1876-1876 dm st 5 Marioso Argentina 54-11-1000-1000 sw dm st 6 Pare Brazil 55-21-4040-2020 go If the Argentina team moves to a new facility in the suburbs, the teamPhone number will most likely change. 
 This is made more difficult/error prone since there are multiple tuples that require update.

Delete Anomaly pID name team teamPhone pos1 pos2 pos3 ➡ ➡ 1 Pessi Argentina 54-11-1000-1000 str for 2 Ricardo Portugal 351-2-7777-7777 rm dm 3 Neumann Brazil 55-21-4040-2020 for lb rb 4 Baily Wales 44-29-1876-1876 dm st 5 Marioso Argentina 54-11-1000-1000 sw dm st 6 Pare Brazil 55-21-4040-2020 go If Ricardo retires from the Portugal team to become a coach for Sporting Clube de Portugal, 
 we will need to delete his entry in this table. However, if we do that, we will lose the team and 
 teamPhone information since he is the only player from Portugal in the table.

Microsoft SQL Server TDE