| 发明名称 |
SUPPORTING UPDATABLE REPEATED VALUES OVER VARIABLE SCHEMA |
| 摘要 |
Data within a database is partitioned into one or more sets of read-only data pages and one or more sets of append-only data pages, wherein each set of read-only data pages is associated to one of the one or more sets of append-only data pages. A repeated map is maintained for at least one of the one or more sets of append-only data pages. An operational position map is maintained for at least one of the one or more sets of append-only data pages. A request is received to update one or more records in a given set of read-only pages, wherein at least one of the one or more records comprises repeated values. The repeated map and operational position map of the append-only pages associated with the given set of read-only pages are updated in response to the request. The one or more sets of append-only pages are automatically merged with their respective set of read-only pages on a periodic basis to create one or more new sets of read-only pages. |
| 申请公布号 |
US2017109392(A1) |
申请公布日期 |
2017.04.20 |
| 申请号 |
US201514886684 |
申请日期 |
2015.10.19 |
| 申请人 |
International Business Machines Corporation |
发明人 |
Hamedani Mohammad S. |
| 分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A method, comprising steps of:
partitioning data within a database into one or more sets of read-only data pages and one or more sets of append-only data pages, wherein each set of read-only data pages is associated to one of the one or more sets of append-only data pages; maintaining a repeated map for at least one of the one or more sets of append-only data pages; maintaining an operational position map for at least one of the one or more sets of append-only data pages; receiving a request to update one or more records in a given set of read-only pages, wherein at least one of the one or more records comprises repeated values; updating the repeated map and operational position map of the append-only pages associated with the given set of read-only pages in response to the request; and automatically merging the one or more sets of append-only pages with their respective set of read-only pages on a periodic basis to create one or more new sets of read-only pages; wherein the steps are performed by at least one processor device coupled to a memory. |
| 地址 |
Armonk NY US |
