Composite Key Generation for OLAP Record Identification

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing systems face difficulties in uniquely identifying and efficiently managing records of aggregate data, particularly in online analytical processing (OLAP) data sources, which hinders record retrieval and sharing across different systems, complicating analytics and advertising tasks.

Innovation Solution

The techniques generate composite keys by concatenating values for each dimension of OLAP records, enabling unique identification and caching of records, facilitating simpler analytic views and improved data management.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of manufacture

If unique identifiers are assigned incrementally to entities, then entity identification is simple and direct, but this approach cannot be applied to aggregate data records that lack inherent unique identifiers

Engineering Contradiction:

Improveease of identifier generationVSAvoidapplicability to aggregate data

Core Design Contradiction:

Ease of manufactureVSAdaptability or versatility

Solution Approach 1:

The patent introduces a composite key as an intermediary mechanism that bridges the gap between simple incremental ID generation and the needs of aggregate data. The composite key serves as a mediator that combines multiple dimension values to create a unique identifier for OLAP records, allowing the system to maintain simple identification methods while adapting to data sources that don't provide inherent unique identifiers

Inventive Principle:

Principle #24Intermediary (Mediator)

2Reliability

If composite keys are generated by concatenating dimension values, then unique identification of aggregate records is achieved, but the complexity of key generation and management increases

Engineering Contradiction:

Improveunique identification capabilityVSAvoidcomplexity of key generation system

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The patent segments the identifier generation process into distinct components: dimension value extraction, concatenation operations, and caching mechanisms. By breaking down the composite key generation into these manageable segments, the system achieves reliable unique identification while keeping each individual component simple and well-defined

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent implements preliminary action by pre-computing and caching composite keys before they are needed for record retrieval. This allows the system to establish unique identification in advance, reducing the complexity of real-time key generation and lookup operations

Inventive Principle:

Principle #10Preliminary action

3Productivity

If cached records are used for sharing amongst requesters, then data retrieval efficiency is improved, but managing and retrieving individual records becomes complex without unique identifiers

Engineering Contradiction:

Improvedata retrieval efficiencyVSAvoidease of record management

Core Design Contradiction:

ProductivityVSEase of operation

Solution Approach 1:

The composite key acts as an intermediary that enables efficient cached record sharing while maintaining ease of operation. It serves as the bridge between the caching mechanism and record retrieval operations, allowing requesters to efficiently access shared data without dealing with the underlying complexity of aggregate data structure

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS11256722B2Techniques for modeling aggregation records

Publication Date: 2022.02.22 YAHOO ASSETS LLC

AI summary

Techniques and technologies described herein can generate and provide identifiers, such as unique identifiers, for individual records of aggregate data. Such identifiers allow systems to cache and reuse individual records of aggregate data. Also, such identifiers can facilitate simpler analytic views of aggregate data.