Analytics Service Governance Dashboard for System Metadata Visualization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Analytics system administrators lack a system-wide view of objects within an analytics service instance, making it difficult to map relationships between objects, identify top users, analyze workload, and diagnose performance issues.

Innovation Solution

A data analytics system that implements an analytics service governance process to generate data visualizations of system-level metadata, providing a governance dashboard with pre-generated DV options based on selected metadata, allowing administrators to select object categories and filters, and producing governance DVs that depict relationships between objects at the system level.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If system-level metadata is protected for security reasons, then system security is improved, but administrators cannot access system-wide information for governance and monitoring

Engineering Contradiction:
Improvesystem securityVSAvoidsystem-wide metadata accessibility
Core Design Contradiction:
ReliabilityVSLoss of information

Solution Approach 1:

The system segments metadata accessibility by creating different views: a protected system-level metadata database and a curated governance dashboard that displays only selected metadata. This segmentation allows security protection while providing necessary governance information to administrators.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The governance dashboard acts as an intermediary layer between the protected system-level metadata database and administrators. It selectively exposes non-sensitive metadata through pre-configured data visualizations without requiring direct database access, thus maintaining security while enabling governance.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Reliability

If administrators have no access to system-level metadata, then system security is maintained, but the ability to monitor and manage system performance and object relationships deteriorates

Engineering Contradiction:
Improvesystem securityVSAvoidsystem governance capability
Core Design Contradiction:
ReliabilityVSEase of operation

Solution Approach 1:

The system provides self-service governance capabilities through pre-configured data visualizations and templates that automatically display relevant system metadata. Administrators can monitor system performance, object relationships, and usage patterns without needing to manually query or access the underlying metadata database.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary actions by pre-configuring data visualizations and metadata selections that are most relevant for governance. This allows administrators to immediately access useful information without needing to understand or configure complex metadata queries, improving ease of operation while maintaining security.

Inventive Principle:
Principle #10Preliminary action

3Loss of information

If all system-level metadata is made accessible, then complete system visibility is achieved, but security risks and exposure of sensitive information increase

Engineering Contradiction:
Improvesystem metadata visibilityVSAvoidsecurity risks from exposed information
Core Design Contradiction:
Loss of informationVSObject-affected harmful factors

Solution Approach 1:

The system applies local quality by selectively exposing only specific non-sensitive metadata through the governance dashboard while keeping sensitive metadata protected. Different portions of the metadata have different accessibility qualities: some are visible for governance purposes, while others remain hidden to prevent security risks.

Inventive Principle:
Principle #3Local quality

4Loss of information

If administrators can query the analytics system database directly, then complete system information access is enabled, but system complexity and security management become more difficult

Engineering Contradiction:
Improvesystem information accessibilityVSAvoiddatabase access management complexity
Core Design Contradiction:
Loss of informationVSDevice complexity

Solution Approach 1:

The governance dashboard serves as an intermediary that simplifies database access management. Instead of allowing direct complex queries to the analytics system database, the dashboard provides curated, pre-configured access to specific metadata through visualizations, reducing complexity while maintaining necessary information accessibility.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS20250147986A1Analytics service governance
Publication Date: 2025.05.08 ORACLE INT CORP
  • US20250147986A1 patent drawing
  • US20250147986A1 patent drawing
  • US20250147986A1 patent drawing

AI summary

Various embodiments of the present technology generally relate to systems and methods for providing an analytics service governance system to provide data visualizations of system-level metadata. In certain embodiments, a method may comprise operating a data analytics system to implement an analytics service governance process to generate data visualizations (DVs) of system-level metadata using an analytics service configured to generate DVs of user-provided datasets. The analytics service governance process may include establishing a connection to an analytics system database containing the system-level metadata as a dataset, generating a governance dashboard providing access to pre-generated DV options based on selected metadata related to user-created objects in the analytics system database, receiving a user selection of object categories and filters from pre-generated DV options, and producing a governance DV based on the user selection depicting a relationship of objects at the system level from the object categories.