[ https://issues.apache.org/jira/browse/RANGER-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhay Kulkarni updated RANGER-2219: ----------------------------------- Affects Version/s: 0.7.0 Fix Version/s: 0.7.0 Issue Type: Task (was: Improvement) > De-normalize schema for storing tags and related objects > -------------------------------------------------------- > > Key: RANGER-2219 > URL: https://issues.apache.org/jira/browse/RANGER-2219 > Project: Ranger > Issue Type: Task > Components: Ranger > Affects Versions: 0.7.0, master > Reporter: Abhay Kulkarni > Assignee: Abhay Kulkarni > Priority: Major > Fix For: 0.7.0, master > > > Currently, tag-definitions, tags and service-resources are stored in database > using a normalized form. When constructing resource->tag mappings, this > schema design may lead to a large number of database accesses, thereby > causing a major performance bottleneck when the number of resource->tag > associations is large. > Denormalized schema will reduce the number of database accesses, and improve > overall performance significantly. -- This message was sent by Atlassian JIRA (v7.6.3#76005)