Modelling for data segregation

View previous topic View next topic Go down

Modelling for data segregation

Post  farooq78 on Sun Jul 29, 2012 3:52 pm

Business scenario

Organization - User = Many To Many
An organization has many users and a user can see his own and child organizations under its hierarchy (organization is a parent child hierarchy)

Organization - Sections = One To Many
An organization can have more than one sections

User - Sections = Many To Many
A user can see more than one sections and a section can be seen by more than one users (in different organizations)

Sections - Item Category = Many To Many
A section covers more than one item categories and an item category can be covered by more than one sections (in different organizations)

Item Category - Item = One To Many
An item category can have more than one items

Item - Fact (any) = One to Many
An item (conform dimension) can have more than one occurrence in any give fact


Problem:
I have to restrict data with respect to user organizations, sections, item categories and items
I have implemented the parent-child organization using kimball helper table for handling complex hierarchies
I tried to put organization, section, item category, item in one dimension but an item category can be moved to any other section and a section can be closed
Didn't merge item and item category as my item list will be around 100k and filtering text based category might impact performance

Looking for some quick replies

farooq78

Posts : 5
Join date : 2012-06-10

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum