Media Metadata Processing via Flat Table Structures

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing media stream containers, such as MPEG 7, lack efficient mechanisms for transforming, embedding, extracting, and reasoning media metadata, particularly due to complex XML-based protocols that require cumbersome data manipulation and querying processes.

Innovation Solution

A system that parses metadata components from media data streams, marks them with computational closures, and uses serialized semantic data structures like RDF to facilitate efficient processing, embedding, and reasoning, enabling scalable and flexible media stream processing across heterogeneous environments.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If XML-based protocols are used for metadata processing, then media stream containers can store metadata, but the processing becomes complicated and time-consuming due to complex data manipulation and querying processes

Engineering Contradiction:
Improvemetadata processing capabilityVSAvoidprocessing time
Core Design Contradiction:
Quantity of substanceVSLoss of time

Solution Approach 1:

The patent changes the data representation parameter from XML-based hierarchical structures to flat table structures with standardized columns (id, title, artist, album, year, genre). This parameter change transforms complex XML parsing and tree traversal operations into simple SQL queries, dramatically reducing processing time while maintaining comprehensive metadata processing capability

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The patent replaces the mechanical XML parsing and tree manipulation system with a database-driven SQL query system. Instead of manually navigating complex XML structures through programming layers, the system uses standardized database tables and SQL queries to retrieve and process metadata, simplifying the processing mechanism and reducing computational complexity

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Quantity of substance

If XML-based protocols are used for metadata processing, then media stream containers can store metadata, but the query expressions become complicated due to multiple ways to map XML to logical trees

Engineering Contradiction:
Improvemetadata processing capabilityVSAvoidquery expression complexity
Core Design Contradiction:
Quantity of substanceVSDevice complexity

Solution Approach 1:

The patent changes the data structure parameter from hierarchical XML trees to flat relational tables with explicit column definitions. This eliminates the ambiguity of XML mapping by providing a single, unambiguous table schema that directly represents the logical structure, making query expressions simple and deterministic without requiring complex mapping logic

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The patent segments the metadata into separate, well-defined table columns (id, title, artist, album, year, genre) rather than nesting everything in XML attributes and elements. This segmentation makes the data structure explicit and simple, allowing straightforward SQL queries without needing to navigate complex hierarchical relationships or deal with multiple valid XML mappings

Inventive Principle:
Principle #1Segmentation

3Adaptability or versatility

If existing media stream containers like MPEG 7 are used, then audio, video and metadata processing mechanisms are built-in, but transformation, embedding, extracting, and reasoning capabilities are limited

Engineering Contradiction:
Improvemetadata processing versatilityVSAvoidprocessing mechanism simplicity
Core Design Contradiction:
Adaptability or versatilityVSEase of manufacture

Solution Approach 1:

The patent creates a universal database layer that handles multiple metadata processing functions (transformation, embedding, extraction, reasoning) through a single standardized interface. The flat table structure with standardized columns serves as a universal data model that can support various processing operations without requiring separate specialized mechanisms for each function, making the system both versatile and simple

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS9141618B2Method and apparatus for processing metadata in one or more media streams
Publication Date: 2015.09.22 GOOGLE LLC
  • US9141618B2 patent drawing
  • US9141618B2 patent drawing
  • US9141618B2 patent drawing

AI summary

An approach is provided for processing metadata in one or more media streams. A media metadata processing platform determines to parse from a media data stream for metadata components. The media metadata processing platform also causes, at least in part, a storing of the parsed metadata components. The media metadata processing platform further determines to mark the media data stream with one or more hooks for embedding the parsed metadata components, one or more computational closures, or a combination thereof, the one or more computational closures being serialized.