Re: data modeling appointment scheduling

2018-11-04 Thread Jonathan Haddad
Well, generally speaking I like to understand the problem before trying to fit a solution. If you're looking to set up millions of appointments for a business, that might quality for some amount of partitioning / bucketing. That said, you might be better off using time based buckets, say monthly o

Re: data modeling appointment scheduling

2018-11-04 Thread I PVP
For people(invitee), you are correct. They will not have millions of appointments. But, the organizer is a business.. a chain of businesses (Franchisor and Franchisees) that together across the country have dozens of thousands of appointments per day. Do you suggest removing the bucket , making

Re: data modeling appointment scheduling

2018-11-04 Thread Jonathan Haddad
Maybe I’m missing something, but it seems to me that the bucket might be a little overkill for a scheduling system. Do you expect people to have millions of appointments? On Sun, Nov 4, 2018 at 12:46 PM I PVP wrote: > Could you please provide advice on the modeling approach for the following >

data modeling appointment scheduling

2018-11-04 Thread I PVP
Could you please provide advice on the modeling approach for the following appointment scheduling scenario? I am struggling to model in an way that allows to satisfy the requirement to be able to update an appointment, specially to be able to change the start datetime and consequently the buc