一种利用二进制属性压缩数据库的方法

A Method of Utilizing Binary System to Compress Database

针对关系型数据库中大多数属性取值只有两种(例如0,1或者ture,false)的数据表,提出了一种无损压缩方法,根据标识列进行聚合,将多行数据的二进制属性合并成一个多位二进制数存储,极大地压缩了数据存储占用的物理空间。并在这种存储方式下,实现了与原存储方式功能完全相同的查改增删等数据库操作,利用实例验证了这种存储方式下,数据库操作的效率的提升。

For some tables in relational database, in which the collection of data items are only attributed to two types （eg 0, 1 or true, false）, a new method of lossless compression which will largely reduce the usage of physical memory is presented by combining each binary attributes of many rows into one binary number according to the identity column. Besides, this method will maintain the same functionality as the original one such as selecting, updating, inserting and deleting, and verifies the increased efficiency in database manipulation with an example.