System Design Flashcards
1
Q
2^10
A
1024
2
Q
Gigabyte is 10 power of
A
10^9
3
Q
Web socket
A
Bidirectional connection mainly used for chat
4
Q
TCP server port limit
A
16 bit port number =
64,000 open connections max per server
5
Q
Count min sketch
A
Get approximate counts of large number of keys by using multiple hash functions with fixed size array.
Increment count in each array on hit.
The approximate count is the min of the hash of key from all arrays
6
Q
Spatial data
A
Grids and quad trees
7
Q
1 million requests per day is how many per second
A
12 or 10 requests per second
8
Q
1 billion bytes is how many in gb
A
33
9
Q
How does relational database achieve atomicity ?
A
Write ahead logging
10
Q
How does relational database achieve isolation ?
A
Locking records/rows for reads or writes
