Metadata-Based Hypermedia Link Service for Database Objects

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional user interfaces for object-relational databases require hand-coding hypermedia links between objects, which is cumbersome and inefficient, especially when links need to be reused across different applications or user interfaces, and do not effectively utilize object relationships for navigation.

Innovation Solution

A system that provides a link service to automatically create hypermedia links between objects based on association metadata, allowing clients to request links and traverse them dynamically, decoupling link presentation from object presentation and enabling extensibility through registered hypermedia providers.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If hand-coding hypermedia links between objects is used, then user interface customization is possible, but development time and complexity increase significantly

Engineering Contradiction:
ImproveUser interface customizationVSAvoidDevelopment time
Core Design Contradiction:
Ease of operationVSLoss of time

Solution Approach 1:

The system enables self-service by allowing the database schema itself to generate hypermedia links automatically. The link service queries the database schema to retrieve association metadata and dynamically creates links without requiring manual programming, thus eliminating the time-consuming hand-coding process while preserving customization capabilities through schema-driven configuration

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary action by pre-defining associations between objects in the database schema before runtime operation. The link service leverages these pre-established relationships and association metadata to automatically generate hypermedia links, eliminating the need for manual link creation during development and enabling rapid system deployment

Inventive Principle:
Principle #10Preliminary action

2Adaptability or versatility

If hand-coding hypermedia links is used, then specific navigation paths can be implemented, but reusability across applications is limited

Engineering Contradiction:
ImproveNavigation path customizationVSAvoidLink reusability
Core Design Contradiction:
Adaptability or versatilityVSEase of manufacture

Solution Approach 1:

The system achieves universality by creating a reusable link service that operates across multiple applications and databases. The service uses standardized SQL queries to retrieve association metadata from the database schema, generating hypermedia links that can be consistently reused across different applications without requiring application-specific coding, thus enabling both customization and reusability

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

Solution Approach 2:

The link service acts as an intermediary between the database schema and the user interface. It queries the schema for association metadata and translates these relationships into hypermedia links, serving as a reusable mediator that can be applied across different applications without requiring manual intervention in each application's link definition

Inventive Principle:
Principle #24Intermediary (Mediator)

3Adaptability or versatility

If conventional user interfaces are used, then existing frameworks can be leveraged, but object relationships are not effectively utilized for navigation

Engineering Contradiction:
ImproveFramework compatibilityVSAvoidNavigation efficiency
Core Design Contradiction:
Adaptability or versatilityVSProductivity

Solution Approach 1:

The system enables self-service by allowing the database schema to automatically provide navigation capabilities through hypermedia links. The link service queries the schema for association metadata and generates navigation paths without requiring manual programming, thus maintaining framework compatibility while significantly improving navigation efficiency through automated object relationship utilization

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS7769750B2Metadata based hypermedia management system
Publication Date: 2010.08.03 MICROSOFT TECHNOLOGY LICENSING LLC
  • US7769750B2 patent drawing
  • US7769750B2 patent drawing
  • US7769750B2 patent drawing

AI summary

A system supplies links between objects. A link service receives a hypermedia link request from a client. The hypermedia request identifies a source object. A link provider analyzes association metadata and creates hypermedia links between the source object and associated objects identified from the metadata.