Enhancement to replace pivot table solution

BAW acceleration tool uses the pivot tables to improve the search performance, but this solution is not so perfect, refer to below.

1. BAW is a shared environment, all the process apps' data are store in pivots tables

2. as every process flow has its own exposed fields, these fields will occupy database column, and will hit database max column limitation, e.g. Oracle table has max 1000 columns limitation

3. all the fields in pivot tables may be used as search criteria, but we can't create index for all the fields, as too many indexes will cause DB performance issue as well. And in most scenario, the pivot table has no index for exposed fields, it will cause performance issue when the pivot table has huge data. Also, on the perspective of user, to tune the index for every new process app launching is unsustainable as well.

So, we would like a enhancement that can replace pivot table solution to improve the search.

Idea priority

High

Post comment

Guest

Reply
| Jun 28, 2024

Delivered in BAW 24.0.0.0. Advanced searches does not depend on the BAW database but instead a data lake (ElasticSearch or OpenSearch).
See:
https://www.ibm.com/docs/en/baw/24.x?topic=information-whats-new-in-24000#wn_2400__wn_pfs__title__1

Sections: Advanced searches in federated and nonfederated environments, Federated data repository BPD indexing

0 reply Hide replies

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Shape the future of IBM!

Search existing ideas

Post your ideas

Please use the following category to raise ideas for these offerings for all environments (traditional on premises, containers, on cloud):

Specific links you will want to bookmark for future use

Enhancement to replace pivot table solution

Please enter your email address

RELATED IDEAS

Enhancement to replace pivot table solution