Links Table Data Model for Scalable Peer Communications
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems, such as relational and object-oriented models, are inefficient for supporting peer-to-peer communications services due to their inability to effectively handle diverse data types and numerous links between data items, limiting their scalability and flexibility in capturing web-type data.
Innovation Solution
A peer-based communications system utilizing a links table data model where members and topics are represented as objects with object links and property links, stored in a single table, allowing for efficient linking and privacy settings management, enabling scalable and flexible data storage and retrieval.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If relational database models are used, then data storage efficiency is improved, but the ability to handle diverse data types and numerous links between data items deteriorates
Solution Approach 1:
The patent applies a unified data model where all data items (members, topics, content) are represented as objects with uniform properties and relationships. This universal object model allows the system to handle diverse data types and numerous links efficiently, as all entities follow the same structural patterns and can be queried using consistent methods, resolving the contradiction between storage efficiency and adaptability.
2Adaptability or versatility
If object oriented data models are used, then data representation flexibility is improved, but efficiency deteriorates due to distinction between data representation and relationships
Solution Approach 1:
The patent merges data representation and relationships into a unified object model where both are expressed through the same structural mechanisms. Objects contain both their own properties (representation) and relationships to other objects (links), eliminating the inefficiency of separate handling and enabling efficient retrieval through unified query operations.
3Adaptability or versatility
If server-based systems with central databases are used, then on-line community formation is improved, but scalability and robustness deteriorate
Solution Approach 1:
The patent segments the centralized database into distributed data storage across multiple peer nodes. Each peer maintains local data and relationships, eliminating the single point of failure in centralized systems. This segmentation enables the system to scale robustly while maintaining community formation capabilities through distributed object resolution and linking.
Data Source
AI summary
A peer-based communications service is provided in which linking relationships between members and topics of interest and the properties of members and topics of interest are represented by links in a links table. Each row in the links table corresponds to a link. Each row contains an association portion and a descriptive attribute portion. Link associations are used to associate member and topic objects to each other and are used to associate a member or topic with a property of that member or topic. The descriptive attributes include privacy settings that are used to restrict access to content in the service. Members may be related to each other as friends, friends of friends, or through other relationships. The privacy settings may be used to restrict viewing of links and properties to appropriate members.