Abhay Kulkarni created RANGER-2219:
--------------------------------------

             Summary: 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: Improvement
          Components: Ranger
    Affects Versions: master
            Reporter: Abhay Kulkarni
            Assignee: Abhay Kulkarni
             Fix For: 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)

Reply via email to