Item operations enable you to add update and delete items from a table You can

Item operations enable you to add update and delete

This preview shows page 255 - 264 out of 275 pages.

Item operations enable you to add, update, and delete items from a table. You can update existing attribute values, add new attributes, and delete existing attributes from an item. You can also perform conditional updates. For example, if you are updating a price value, you can set a condition so the update happens only if the current price is $15. You can retrieve a single item or multiple items from a table. AWS Training and Certification Appendix © 2018 Amazon Web Services, Inc. or its affiliates All rights reserved. 255
Image of page 255
If you want to read the data using non-key attributes, you can use a secondary index to do this. A local secondary index is an index that has the same partition key as the table, but a different sort key. For more information, see: AWS Training and Certification Appendix © 2018 Amazon Web Services, Inc. or its affiliates All rights reserved. 256
Image of page 256
A global secondary index is an index with a partition key and sort key that can be different from those on the table. They can be thought of as “pivot charts” for your table. The global secondary index must be created at the time the table is created. For more information, see: AWS Training and Certification Appendix © 2018 Amazon Web Services, Inc. or its affiliates All rights reserved. 257
Image of page 257
AWS Training and Certification Appendix © 2018 Amazon Web Services, Inc. or its affiliates All rights reserved. 258
Image of page 258
AWS Training and Certification Appendix © 2018 Amazon Web Services, Inc. or its affiliates All rights reserved. 259
Image of page 259
For more information, see: scaling_typesof AWS Training and Certification Appendix © 2018 Amazon Web Services, Inc. or its affiliates All rights reserved. 260
Image of page 260
AWS Training and Certification Appendix © 2018 Amazon Web Services, Inc. or its affiliates All rights reserved. 261
Image of page 261