发明名称 Database operations on a columnar table database
摘要 A computer system includes at least one processor and at least one memory operably coupled to the at least one processor. The memory includes a memory pool and a database partitioned into multiple fragments. Each of the fragments is allocated a block of memory from the memory pool and the fragments store compressed data in a columnar table format. A database operation is applied in a compressed format to the compressed data in at least one of the fragments.
申请公布号 US9418091(B2) 申请公布日期 2016.08.16
申请号 US201314033203 申请日期 2013.09.20
申请人 SAP SE 发明人 Li Wen-Syan;Dong Bin;Wei Zheng Long;Chen Yingyu;Shen Yongyuan
分类号 G06F17/30 主分类号 G06F17/30
代理机构 Brake Hughes Bellermann LLP 代理人 Brake Hughes Bellermann LLP
主权项 1. A computer system, comprising: at least one processor; and at least one memory operably coupled to the at least one processor, the memory comprising: a memory pool,a database partitioned into a plurality of fragments, wherein each of the fragments is allocated a block of memory from the memory pool and the fragments store compressed data in a columnar table format, anda change log that is configured to store uncompressed data,wherein a database operation is applied in a compressed format to the compressed data in at least one of the fragments, the database operation including an insert operation that causes inserting of new data in compressed format to one of the fragments, andan update operation that causes: locating a corresponding row of data in one of the fragments,if a memory space in the fragment is sufficient to include one or more updated values in the data in compressed format, compressing the updated values and replacing the updated values in the data, andif the memory space in the fragment is not sufficient to include the updated values in the data in compressed format, recording the updated values in the change log in an uncompressed format.
地址 Walldorf DE