Prime URI Generation for Database Manageability

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database systems become unmanageable due to the numerous different Uniform Resource Identifiers (URIs) referencing the same content, making it difficult to create an effective index for web content.

Innovation Solution

A system and method that generates a new or 'prime' URI by applying a regular expression associated with a domain to an input URI, allowing multiple URIs to be associated with a single entry in a database, using a computer system configured to receive and process URIs, analyze them with a domain-specific regular expression, and retrieve information from a database.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If each different URI is placed into a database for the web site, then the database would contain comprehensive information about all web pages, but the database would quickly become unmanageable

Engineering Contradiction:

Improvecomprehensive information storageVSAvoiddatabase manageability

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The patent merges multiple different URIs that reference the same content into a single canonical URI entry in the database. By identifying that different URIs point to equivalent web pages and consolidating them under one canonical representation, the system maintains comprehensive information about all web pages while avoiding database bloat from redundant entries.

Inventive Principle:

Principle #5Merging (Combining)

Solution Approach 2:

The patent creates a simplified canonical URI as a representative copy for multiple original URIs. Instead of storing every variant URI, the system generates a standardized canonical form that represents the same content, reducing database complexity while preserving the ability to track and manage all referenced web pages.

Inventive Principle:

Principle #26Copying

2Loss of information

If multiple different URIs are stored in the database, then all web page references are captured, but the database becomes difficult to manage and query

Engineering Contradiction:

Improveweb page reference trackingVSAvoiddatabase query efficiency

Core Design Contradiction:

Loss of informationVSEase of operation

Solution Approach 1:

The patent combines multiple URI variants into a single canonical URI entry, maintaining complete tracking of web page references through the canonical form. This merging approach ensures no reference information is lost while dramatically improving query efficiency by eliminating redundant entries that would otherwise complicate database operations.

Inventive Principle:

Principle #5Merging (Combining)

3Adaptability or versatility

If numerous different URIs are associated with the same content, then all variations are recorded, but the database structure becomes complex and unmanageable

Engineering Contradiction:

ImproveURI variation coverageVSAvoiddatabase structure

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements a universal canonical URI structure that can represent multiple different URI variations through a single standardized form. This canonical representation serves multiple functions: it tracks all URI variations, provides a consistent database entry structure, and enables efficient querying while maintaining adaptability to cover diverse URI formats and patterns.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS9037585B2Method and system for generating prime uniform resource identifiers

Publication Date: 2015.05.19 WISER SOLUTIONS INC

AI summary

A system and method for mapping an input uniform resource identifier (URI) to an entry in a database. The system cleans an input URI to produce a prime URI that references an entry in a database. The prime URI is created by applying a regular expression determined for a particular domain to the input URI. Once the prime URI is generated, the prime URI can be used to retrieve information from a database.