This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updateson them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Storing of enriched/additional information outside of the standard data model
in DNB we have to save a lot of information outside of the out of the box FTM Data Model. The main strategies available out of the box are:
- use object values/id references --> this leads to a quick proliferation in key value objects which impact readability/maintainability and performance if overused.
- us the extension table format --> maintaining these extension table increases the amount of table joins necessary and they are complex to create and maintain. Changes over time lead to repeated scripts which add on to the previous one. In FTM CPP we are already at 55 scripts to be run to deploy the extension tables of the solution
- store in ISF which is expensive to retrieve/parse and store
DNB would like to ask for a better way to manage this information. One solution that could be available is DB2 purexml. It would provide the ability to use documents with relative ease of access without having to parse entire documents ( as per ISF ). For example and additional column type to the object values could be purexml.
Whatever is choosen it should be visible through the UI but still remain flexible and easy/quick to access.
IBM consultant Criostoir Hyde has been working on some ideas. This case is to be regarded as a feature request by DNB to support Criostoirs suggestions.
Do not place IBM confidential, company confidential, or personal information into any field.