Database Row Annotation via Segmented PCOR Tables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems lack the ability for individual end users to enter free-form data as user comments on data stored in user tables, constraining user interaction and limiting analysis capabilities for both users and third parties.
Innovation Solution
A method and apparatus that allow users to annotate data in user tables with free-form data by using a system tablespace with a data dictionary and a user tablespace, including a Personal Comment on Row (PCOR) Indicator table and a PCOR table, enabling users to define their own annotations and linking them to both system and user tables.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If database systems use predefined data structures and schemas, then data storage and retrieval are efficient and reliable, but users cannot enter free-form comments or annotations on data rows
Solution Approach 1:
The patent segments the database structure into multiple components: a data dictionary table storing column definitions, a user table storing actual data rows, and a separate comment table storing user annotations. This segmentation allows free-form comments to be added without modifying the core data structure, resolving the contradiction between adaptability and complexity.
Solution Approach 2:
The patent introduces an intermediary comment table that links user comments to specific data rows through foreign key relationships. This intermediary structure enables free-form annotations while maintaining the integrity of the original predefined database schema, allowing users to add comments without altering the core data storage structure.
2Ease of operation
If database systems allow free-form user comments on data rows, then user interaction and analysis capabilities are enhanced, but data storage and retrieval complexity increases
Solution Approach 1:
By separating comment storage from data storage into distinct tables, the system enhances user interaction capabilities while keeping the core data structure simple and efficient. Users can freely annotate data rows without affecting the underlying data storage and retrieval mechanisms.
Solution Approach 2:
The comment table structure is designed to be universal, supporting comments on any data row through parameterized foreign key relationships. This multi-functional design allows the same storage structure to handle comments across different user tables and data types, simplifying the overall system while enhancing user interaction.
3Adaptability or versatility
If predefined menu choices are used for user input, then data consistency and reliability are maintained, but user flexibility and customization are limited
Solution Approach 1:
The patent separates structured data storage from unstructured comment storage into different tables. This segmentation allows the core data to maintain strict consistency through predefined schemas while user comments provide flexibility in a separate, non-critical storage area, thus maintaining both reliability and adaptability.
Solution Approach 2:
The system applies different quality requirements to different parts of the database: strict data consistency rules for the main data tables and flexible, free-form input for the comment table. This local differentiation of quality standards allows users to have comment freedom while the core data maintains its consistency and reliability.
Data Source
AI summary
A pair of system tables are created in a system tablespace of a database and store free-form data that is defined by, and provided by, an end user. The information in a first system table determines whether a user table in a user tablespace of the database is capable of being annotated with the free-form data. The second system table stores the free-form data that is used to annotate that user table. So maintained, third parties can access the free-form data for analysis.