The embodiment of the invention discloses a queriable
compression method for a
database two-dimensional table. Wherein the
database is additionally provided with a
data structure to compress and represent the two-dimensional table; the
data structure comprises a value array, a field value learning type mapping tree graph and a
primary key learning type mapping tree graph; the method comprises the following steps: executing construction operation to construct value arrays of all
byte array type fields, field value learning type mapping tree graphs of all
byte array type fields and a unique
primary key learning type mapping tree graph; and performing addition, deletion, modification and query operations on the major key learning type mapping tree graph according to a received operation instruction, wherein the addition, deletion, modification and query operations comprise major key single-point query, major key range query, two-dimensional table
record addition operation, two-dimensional table
record deletion operation and two-dimensional table
record modification operation. According to the method, the storage space of the
primary key and the
byte array type field value can be greatly compressed, and the addition, deletion, modification and check operation of the two-dimensional table record can be more efficiently executed.