5 Tables in ScyllaDB

 

This chapter covers

  • Completing query-first design by reviewing your work
  • Replicating your keyspaces appropriately
  • Creating tables for the restaurant review application

For a book with the word Action in its title, you may think you’re doing a lot of design work and not spending much time exercising the database. A good design, however, is the cornerstone of a well-functioning ScyllaDB cluster. How you query the data drives how you store it, so changes in how you query it can be very expensive. You may need to completely rearchitect your data!

This chapter focuses on finishing your design. You’ll look at the work you’ve done thus far: validating that the design meets the requirements and taking an overall look at your design to see if there’s anything worth changing or improving from a design or performance pitfall perspective (and you’ll learn some tips for things to watch out for). With that design, you’ll translate your work to actual keyspaces and tables, getting ready to begin filling it with data. Before you can query, you have to complete your query-first design.

5.1 Completing your query-first design

5.1.1 Reviewing restaurant reviews

5.1.2 The final two questions

5.1.3 Bucketing

5.1.4 Finishing the design

5.2 Keyspace configuration

5.2.1 SimpleStrategy

5.2.2 NetworkTopologyStrategy

5.3 Creating your application’s tables

5.3.1 Articles

5.3.2 Article summaries

5.3.3 Authors

Summary