O'Reilly logo

Amazon SimpleDB Developer Guide by Prabhakar Chaganti, Rich Helms

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Querying

We have our data stored nicely in SimpleDB domains. Now we are going to learn the different ways to retrieve the stored data. Most of us are used to using Structured Query Language (SQL) for retrieving data from relational databases. SimpleDB uses a select syntax that is very similar to its counterpart in SQL for the queries. In this chapter, we will explore the query syntax provided by SimpleDB with a lot of samples and learn about:

  • The basic select syntax
  • Quoting values inside select expressions
  • Predicates in select expressions
  • Comparison operators
  • Set operations
  • Sorting
  • Counting the results from SimpleDB queries
  • Queries on multi-valued attributes
  • GetAttributes

Sample data

We are going to use songs as our dataset. The following screenshot ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required