Azure Table Storage: Storing Relationships -

-

when storing 1 many relationship in azure table storage (such storing id of owner of record) store both partitionkey , rowkey 2 separate fields? or somehow concatenate 2 fields 1 field purpose of simpler storage?

edit - more clarity on i'm asking

i know table storage not relational. , i'm not looking foreign key integrity or cascading deletes or that.

but without being "relational" there still common need store pointer record in table. has thousands of uses. example of storing user created record 1 example. storing sort of list or array example (such list of "work experience" records in resume, or list of contact addresses person record.)

because "primary key" of azure table storage table 2 fields, i'm wondering if there common convention on how store information. "best practice?"

the options see are:

  • concatenate partitionkey , rowkey 1 field , store "foreign key" (i know there no real foreign keys).
  • store both fields separately , use foreign key.
  • a third option haven't though tof.

is there "best practice" here? there reason choose 1 method on another?

first thing azure table storage not relational database natively supports one-to-many relationships. anyways can develop scenario mentioned. key point partitionkey + rowkey must unique in table. in given partition (represented partitionkey), cannot duplicate rowkey.

so guess concatenation right way. otherwise if use partitionkey , rowkey main table partitionkey , rowkey in second table won't able have one-to-many relationship. because one record in main table have many records in second table , these records in second table cannot have same partitionkey , rowkey values.

please note concatenating partitionkey , rowkey result in separate partitions in second table every record in main table. , if have scenario want query multiple partitions in second table, slow.

the important point when designing structure of tables storage main consideration data access pattern. should see how access data , design structure accordingly.

hope helps.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more