Selective Column Data Transfer in Database Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems, such as HANA, perform inefficient data import and export operations by transferring all columns of a data table, which is resource-intensive and time-consuming, especially when only some columns need to be transferred.
Innovation Solution
Implementing a method where a user can selectively designate columns for data transfer by modifying metadata associated with the columns, allowing only the specified data to be transferred during import or export operations, maintaining the data table structure intact.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all columns of a data table are transferred during import or export operations, then complete data transfer is achieved, but resource consumption and transfer time increase significantly
Solution Approach 1:
The patent extracts only the necessary columns from the data table for transfer operations. By allowing users to specify which columns should be included in import/export operations, the system transfers only the required data portions rather than all columns, thereby reducing transfer time while maintaining completeness of the needed data.
Solution Approach 2:
The patent implements partial action by enabling selective column transfer. Instead of transferring all columns (excessive action), the system allows users to designate specific columns for transfer, performing only the necessary data movement operations. This partial approach reduces resource consumption and transfer time while achieving the required data transfer completeness.
2Reliability
If all columns of a data table are transferred during import or export operations, then complete data transfer is achieved, but memory resource consumption increases
Solution Approach 1:
The patent extracts only the necessary columns from the data table for transfer operations. By allowing users to specify which columns should be included in import/export operations, the system transfers only the required data portions rather than all columns, thereby reducing memory resource consumption while maintaining completeness of the needed data.
Solution Approach 2:
The patent implements partial action by enabling selective column transfer. Instead of transferring all columns (excessive action), the system allows users to designate specific columns for transfer, performing only the necessary data movement operations. This partial approach reduces memory resource consumption and energy usage while achieving the required data transfer completeness.
3Productivity
If metadata is modified to designate columns for selective transfer, then data transfer efficiency is improved, but system complexity increases
Solution Approach 1:
The patent applies universality by using existing metadata structures in the database system to serve multiple functions: storing column information and indicating whether columns should be transferred during import/export operations. This approach avoids creating separate complex control mechanisms while achieving selective column transfer capability.
Solution Approach 2:
The patent changes the state or value of existing metadata parameters to indicate column transfer preferences. By modifying metadata attributes rather than introducing new complex data structures or control systems, the patent achieves selective column transfer with minimal increase in system complexity.
Data Source
AI summary
Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.