Database Table Commenting in Documents for Row and Column Annotation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing document editing systems, such as Word and Excel, lack the ability to facilitate row-level or column-level comments on database tables, limiting user interaction and flexibility in commenting on structured data.
Innovation Solution
A method and apparatus that enable the display of database tables in documents, allowing users to mark target areas within these tables for commenting, record correlations between comment information and target areas, and display comment information related to the position of the target area, thereby supporting row-level and column-level comments.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If traditional text-editable documents are used with simple tables, then ease of operation is maintained, but the ability to comment on structured data at row or column level is lost
Solution Approach 1:
The patent segments the table into discrete row and column elements that can be individually selected and commented on. Users can select specific rows or columns as target areas for commenting, enabling precise structured data annotation without overwhelming interface complexity.
Solution Approach 2:
The patent introduces a comment box as an intermediary element that mediates between the user and the table structure. The comment box receives comments and automatically associates them with the selected target area, simplifying the interaction while enabling sophisticated commenting capabilities.
2Adaptability or versatility
If database tables are integrated into documents, then structured storage and SQL query capabilities are improved, but the complexity of the system increases
Solution Approach 1:
The patent makes the table component multi-functional by integrating database table capabilities with document editing and commenting features. The same table structure serves both as a data container with SQL query capabilities and as a commentable element, eliminating the need for separate systems.
Solution Approach 2:
The patent merges the database table functionality with the document editing interface. The table is rendered directly within the document, allowing users to interact with database data and add comments in a unified environment rather than switching between separate applications.
3Loss of information
If comment information is displayed in relation to target area positions, then information expression clarity is improved, but the rendering complexity increases
Solution Approach 1:
The patent applies local quality by positioning comment information specifically at the location of the target area (row or column) within the table. Each comment is rendered in proximity to its associated target, providing clear spatial context without requiring global repositioning of all elements.
Solution Approach 2:
The patent performs preliminary action by pre-establishing the correlation between comment information and target areas during the commenting phase. The system stores the relationship between comments and their target areas, enabling efficient retrieval and positioning during rendering without complex real-time calculations.
Data Source
AI summary
The embodiments of the present disclosure relate to a method and apparatus for processing information in a document, and a device and a medium. The method includes: displaying a database table in the document in response to receiving a table creation operation in the document; marking a target area and displaying a comment box on an interface of the document in response to receiving a comment request for the target area in the database table, wherein the target area comprises at least one of: at least one cell row, or at least one cell column; and recording a correlation between comment information and the target area and displaying the comment information in the document in response to receiving the comment information through the comment box, wherein a display position of the comment information in the document is related to a position of the target area in the database table.