The Queen Anne Curiosity Shop has been successfully using a relational database, as described in Chapter 7, for a while now, but its business is expanding rapidly; its time for some Big Data solutions! In particular, the company now has 12 different locations (not just one) and a large and growing number of customers and curiosities. It is ready to embrace polyglot persistence.

Design and justify one possible scheme for sharding and replicating all or part of the QACS data.

Give an example of how part of the QACS database might benefit from being stored in a key-value DBMS. Justify your choice.

As part of her expansion, the Queen Anne Curiosity Shop now does deliveries to its customers and pickups from its vendors and thus includes latitude and longitude coordinates for each of its customers and vendors. In order to plan deliveries and pickups, it is helpful to know which customers and vendors are near each other and how far apart they are. Show, in a way similar to Figure 13-8 or Figure 13-9, how some of the QACS customer and vendor data might be stored in a graph DBMS. Make up suitable latitude, longitude, and distance values