[ https://issues.apache.org/jira/browse/RANGER-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Velmurugan Periasamy updated RANGER-2219: ----------------------------------------- Fix Version/s: (was: master) (was: 0.7.0) 2.0.0 0.7.2 > 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: Sub-task > Components: Ranger > Affects Versions: 0.7.0, master > Reporter: Abhay Kulkarni > Assignee: Abhay Kulkarni > Priority: Major > Fix For: 0.7.2, 2.0.0 > > > 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)