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] [Updated] (RANGER-2219) De-normalize schema for storing tags and related objects
Date Thu, 04 Oct 2018 15:16:00 GMT

     [ https://issues.apache.org/jira/browse/RANGER-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Abhay Kulkarni updated RANGER-2219:
-----------------------------------
    Issue Type: Sub-task  (was: Task)
        Parent: RANGER-2203

> 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.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)

Mime
View raw message