Dynamic OLAP Cube Creation with Automated Security

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Static OLAP cubes are limited by a fixed number of predefined dimensions and require manual security setup for each cube, making them rigid and inefficient for dynamic data management and security administration.

Innovation Solution

A dynamic OLAP cube creation method that computes relationships between entities in a data source to define arbitrarily large dimensions and automatically derives permission settings, allowing for runtime reconfiguration and centralized security management.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If static OLAP cubes are used with predefined dimensions, then the cube structure is simple and secure, but the adaptability to dynamic data management is limited

Engineering Contradiction:

Improveadaptability to dynamic data managementVSAvoidcube structure complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements dynamic OLAP cubes that can be created and modified at runtime based on data source specifications. The cube dimensions are no longer fixed during design but are dynamically determined by analyzing entity relationships in the data source, allowing the cube structure to adapt to changing data management requirements without manual reconfiguration.

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

The system automatically derives cube dimensions and security settings by analyzing the data source specification and entity relationships. The cube creation process is self-service, where the system autonomously determines the appropriate dimensions and permission settings without requiring manual intervention from database administrators, thereby reducing administrative burden while maintaining security.

Inventive Principle:

Principle #25Self-service

2Productivity

If manual security setup is performed for each OLAP cube, then security can be customized, but the administrative burden and time consumption increase

Engineering Contradiction:

Improvesecurity administration efficiencyVSAvoidtime for security setup

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The system automatically derives security settings by analyzing the data source specification and entity relationships. The cube creation process is self-service, where the system autonomously determines the appropriate dimensions and permission settings without requiring manual intervention from database administrators, thereby reducing administrative burden while maintaining security.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

Security settings are pre-derived and configured automatically during the cube creation process based on the data source specification. This preliminary action eliminates the need for subsequent manual security configuration, as the system has already established appropriate permission settings before the cube is put into use.

Inventive Principle:

Principle #10Preliminary action

3Adaptability or versatility

If predefined dimensions are used in OLAP cubes, then the cube structure is simplified, but the ability to handle complex data relationships is reduced

Engineering Contradiction:

Improvehandling of complex data relationshipsVSAvoiddimension definition complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent changes the approach from fixed predefined dimensions to dynamically determined dimensions based on data source specifications. The system analyzes entity relationships and automatically determines the appropriate dimensions, allowing the cube to adapt to complex data relationships while simplifying the user experience through automated dimension derivation.

Inventive Principle:

Principle #35Parameter changes

Data Source

PatentUS7587410B2Dynamic cube services

Publication Date: 2009.09.08 MICROSOFT TECHNOLOGY LICENSING LLC

AI summary

A method and system for dynamic creation of an OLAP cube is disclosed which enables OLAP cubes to be created from custom database entities and custom database entity relationships. A created cube may be implemented on a local or remote data server using a variety of modular database protocols. A computer-readable medium and system for OLAP cube data permission derivation is also disclosed. OLAP cube data permissions are derived from category data associated with an OLAP database. The resulting cube data permissions are associated with data in the OLAP cube.