The next step is to look at who will use the data and how they will use it. When you design your Streamed environment, take into account considerations such as.
Will some users only need to query (read) the data?
Which sites will create the data?
Which sites will be allowed to change or delete the data?
If data diverges, which version of the data is kept and which is overwritten?
In short, who owns the data? Let's talk about what this means.
Data ownership refers to the right to create, change, or delete data. Data ownership can be described by a level and model.
Data ownership can be enforced at the site, user, and table levels. Table level ownership can be further subsetted at the row (horizontal) and column (vertical) levels. For instance, regional databases may have access to personnel data, however, only headquarters can make changes to the data (Site level). A further limitation could be that only HR employees are allowed to change the data (user level). However, these HR...