QuestionQ105

VerifiedStoring the data

You use Bigtable to store and serve stock-market data for each major index. To support the trading application, you must retrieve only the latest streaming stock prices. How should you design the row key and tables so the data can be accessed with the simplest query?

Explanation

A reversed timestamp orders rows from newest to oldest in Bigtable. Keeping each index in its own table lets a forward read of the first row return that index’s latest price, without a reverse scan or filtering through records for other indices.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!