ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhay Kulkarni (JIRA)" <j...@apache.org>
Subject [jira] [Created] (RANGER-2219) De-normalize schema for storing tags and related objects
Date Wed, 12 Sep 2018 16:52:00 GMT
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)

Mime
View raw message