Amazon DynamoDB 数据建模核心概念.pdf

1、 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.D A T 3 1 1Data modeling core concepts forAmazon DynamoDBJason HunterPr.Solution Architect,DynamoDB,Amazon Web Services 2025,Amazon Web Services,Inc.or its affiliate

2、s.All rights reserved.A day in the libraryCore data modeling conceptsTechniques for scaling 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.A day in the library 2025,Amazon Web Services,Inc.or its affiliates.All ri

3、ghts reserved.The DynamoDB data model.as phonebooks in a library 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.The DynamoDB data model 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Base table(white pages books)City(PK)Name(SK)Phone numberZIPEntityLas VegasHu

4、nter,Jason555-867-530988901Las VegasJW Marriott702-869-777788901HotelLas VegasShriver,Sean212-804-600389125Las VegasVenetian,The702-414-100088901CasinoWhat queries can we do,and which cant we do?2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Local secondary index(yellow pages boo

5、ks)LSICity(LSI PK)Entity(LSI SK)NameZIPPhone numberLas VegasCasinoVenetian,The88901702-414-1000Las VegasHotelJW Marriott88901702-869-7777What queries can we do,and which cant we do?2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Global secondary index(by ZIP code)-GSIZip(GSI PK)Na

6、me(GSI SK)Phone numberBusiness entity88901Hunter,Jason555-867-530988901JW Marriott702-869-7777Hotel88901Venetian,The702-414-1000CasinoWhat queries can we do,and which cant we do?2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Updates?Entries are in the base table,LSI,and GSIUpdate