Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How Does Automatic Caching Work with Row-Level Security in Oracle Analytics DV?

Received Response
11
Views
2
Comments
Rank 6 - Analytics Lead

Oracle Analytics DV automatically caches the most frequently queried data to improve performance. However, if a dataset is sourced from a subject area with row-level security (RLS) applied, the query results can vary for each user.

Given that the dataset output differs based on user access, does the automatic caching mechanism still result in cache hits? Or does every user’s query create a unique cache entry, making caching ineffective?

Are there any best practices to optimize caching when RLS is involved?

Appreciate any insights from the community!

Tagged:

Answers

  • Rank 7 - Analytics Coach

    How Does Automatic Caching Work with Row-Level Security in Oracle Analytics DV?

    Hi @Dhaval Parikh Stantec,

    Please take a look into the following document especially 'About Cache Hits' which might be useful to understand the various scenarios.

    Site faviconConfiguring Oracle Analytics Cloud

    Hope this help.

    Cheers,

  • Rank 7 - Analytics Coach

    Hi @Dhaval Parikh Stantec,

    Additionally it depends on how the way 'Row Level Security' has been configured using semantic model or database.

    If row-level security has been implemented in the semantic model, it provide some benefits like:
    a) All the users share cache for better performance.
    b) All the users share the same database connection pool for better performance.
    etc.

    If it is done via, database using Virtual Private Database (VPD) feature:
    Oracle Analytics query engine matches a list of security-sensitive variables to each prospective cache hit.
    Cache hits will only occur for those cache entries which included and matched all security-sensitive variables.

    Please take a look into the following Oracle Note for more details.

    Site faviconBuilding Semantic Models in Oracle Analytics Cloud

    Hope this help.

    Cheers,

Welcome!

It looks like you're new here. Sign in or register to get started.