17806359. DATABASE COMPRESSION ORIENTED TO COMBINATIONS OF RECORD FIELDS simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)
Contents
DATABASE COMPRESSION ORIENTED TO COMBINATIONS OF RECORD FIELDS
Organization Name
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor(s)
DATABASE COMPRESSION ORIENTED TO COMBINATIONS OF RECORD FIELDS - A simplified explanation of the abstract
This abstract first appeared for US patent application 17806359 titled 'DATABASE COMPRESSION ORIENTED TO COMBINATIONS OF RECORD FIELDS
Simplified Explanation
This patent application describes a method, system, and computer program for compressing databases by optimizing the storage of combinations of fields within a database record. Here are the key points:
- The technology focuses on identifying combinations of fields within a database record that have higher access frequencies than a predetermined threshold.
- Once these combinations are determined, the record is reorganized to store the fields of each combination in a contiguous storage space.
- The reorganized record is then compressed using a compression scheme specifically designed for the identified combinations of fields.
Potential applications of this technology:
- Database management systems: This innovation can be implemented in various database management systems to improve storage efficiency and optimize access to frequently accessed combinations of fields.
- Big data analytics: As the volume of data continues to grow, efficient database compression techniques can enhance the performance of big data analytics platforms by reducing storage requirements and improving data retrieval speeds.
Problems solved by this technology:
- Inefficient storage: Traditional database storage methods may not effectively utilize storage space, leading to wasted resources and slower data access.
- Slow data retrieval: Without optimized storage and compression techniques, accessing specific combinations of fields within a database record can be time-consuming, especially when dealing with large datasets.
Benefits of this technology:
- Improved storage efficiency: By identifying and organizing frequently accessed combinations of fields, this technology reduces the overall storage footprint of a database, resulting in cost savings and improved resource utilization.
- Faster data retrieval: Storing related fields in contiguous storage spaces allows for quicker access to specific combinations of fields, enhancing the overall performance of database queries and data retrieval operations.
Original Abstract Submitted
This disclosure provides a computer-implemented method, a computer system and a computer program product for database compression oriented to combinations of fields of a database record. One or more combinations of fields of a record of a database are determined that satisfy a frequency criterion indicating that access frequencies of the one or more combinations of fields are higher than an access frequency threshold. The record is reorganized based on the one or more combinations of fields to store fields of each combination of the one or more combinations of fields in a respective contiguous storage space. The reorganized record is compressed by applying a compression scheme to the one or more combinations of fields.
