| 发明名称 |
Reporting and summarizing metrics in sparse relationships on an OLTP database |
| 摘要 |
Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables. |
| 申请公布号 |
US9619549(B2) |
申请公布日期 |
2017.04.11 |
| 申请号 |
US201615155372 |
申请日期 |
2016.05.16 |
| 申请人 |
International Business Machines Corporation |
发明人 |
Banerjee Biswadeep;Lamb Michael L.;Phelps Mack E.;Santharam Vishnukumar T |
| 分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
Woycechowsky David B. |
| 主权项 |
1. A computer program product comprising software stored on a software storage device, the software comprising:
first program instructions programmed to select a set of base tables in a transactional database; and second program instructions programmed to create a factless materialized query table, having maximum sparsity, for the set of base tables; wherein: the set of base tables includes at least two base tables; the set of base tables includes a set of keys including at least two distinct primary keys; the factless materialized query table includes one record associated with each record in the set of base tables; and each record in the materialized query table includes a value for every primary key in the set of base tables. |
| 地址 |
Armonk NY US |
