4.1. CCMS KPI Analysis
In the following, a selected subset of results from the project is presented. The focus is placed on findings that are particularly relevant to the evaluation of the CCMS data and its usage characteristics. The term question in this context refers to the company-specific questions introduced in Chapter Phase 4: Exploratory Data Analysis. Moreover, for each analysis, an accompanying CSV file was generated to enable further examination beyond the presented results.
4.1.1. Question 1: Topic Usage and Reuse Frequency
The first analysis addresses the question of which topics are used and how frequently they are reused across documents. It also serves as a characterization step for the investigated content and supports the understanding of its behavior in the following AI readiness analytics. As shown in
Figure 2, the distribution of topic (re-)use number is illustrated using a bar chart, where the x-axis represents the number of times a topic is used and the y-axis indicates the number of topics corresponding to each usage frequency.
The results show a strongly left-skewed distribution. Approximately 450 topics are used only once, while around 60 topics appear twice. Beyond this point, the number of topics decreases rapidly as reuse frequency increases. At the same time, a small number of topics exhibit exceptionally high reuse rates. These topics, located at the right end of the distribution, can be considered standard topics that are repeatedly reused across multiple documents, indicating a high level of content standardization within the CCMS.
This analysis is particularly helpful as it provides insights into content reuse patterns and the degree of standardization within the CCMS. It identifies topics with a lower reuse rate, while highly reused topics indicate standard topics that are critical for consistency and maintenance.
As an extension of the first analysis, a scatter plot was used to examine the correlation between topic length and reuse frequency. As shown in
Figure 3, the x-axis represents the word count of each topic, while the y-axis indicates the number of times the topic is reused across documents. Each data point corresponds to an individual topic, and the overall distribution of points allows for an assessment of potential correlations between topic size and reuse behavior.
The results indicate that higher reuse rates are generally associated with topics of smaller content size. However, the large number of topics characterized by both low reuse rates and small size reflects the variant-specific content creation processes typical of manufacturing environments with a high degree of product specificity. As expected, large topics exhibit comparatively low reuse rates. Overall, the observed reuse behavior confirms the general tendency previously identified in REx analytics within the machinery industry.
The interactive design of the visualization further supports the analysis. Hovering over individual data points reveals additional metadata, such as topic ID, title, word count, and number of uses, as illustrated in the figure. Selecting a data point opens a detailed information panel at the bottom of the page, providing further insights into the corresponding topic. Most visualizations were implemented as interactive elements to align with the analytical requirements and practical needs of industrial partners.
4.1.2. Question 2: Distribution of Explosion Safety—Related Topics Across Documents
The second analysis addresses, as an example for industry-relevant content analytics, the specific question of how many topics related to explosion safety (ATEX [
13]) exist and in which documents they are applied. To answer this project-specific question, two complementary analyses were conducted: a metadata-based analysis and a keyword-based analysis. The keyword-based analysis serves as a validation step to assess the completeness of the topic metadata.
The metadata-based analysis reveals a clear clustering of documents with respect to explosion safety topics. As illustrated in
Figure 4, documents on the left side of the distribution contain a relatively high number of explosion safety-related topics, whereas documents on the right side only include a limited number of relevant topics.
The keyword-based analysis of all documents, on the other hand, shows a similar distribution. The keywords like “explosion” were given by the company. As shown in
Figure 5, the upper bar chart illustrates the number of topics per document in which explosion safety-related keywords occur, while the lower bar chart depicts the total number of keyword occurrences for the previously analyzed topics per document.
The strong alignment between these two analyses indicates a high level of agreement between the metadata of topics per document and actual content. This suggests that the ATEX conformity metadata reliably reflects the presence of explosion safety-related information at the module level. Consequently, the metadata can be considered as a basis for identifying and analyzing explosion safety content across documents, while the keyword-based analysis serves as an effective validation of metadata completeness and consistency.
4.1.3. Question 3: Overview of the Usage of Topics in Documents and Products
The final analysis of content management properties addresses the question of whether there are topics that are used across all documents of a given product. To enable a simultaneous exploration of topic usage patterns across documents and products, a 3D interactive visualization was used. This visualization allows for examining the relationships between topics, documents, and products.
As illustrated in
Figure 6, the visualization is generated as a three-dimensional voxel structure. The x-axis represents the topic IDs, the y-axis corresponds to the document IDs, and the z-axis illustrates the extrinsic product metadata (P_Ext). Each data point, therefore, represents the occurrence of a specific topic within a particular document for a given product. The interactive design allows filtering by individual products, enabling a focused analysis of topic usage within a single product’s documentation set, as shown in
Figure 6.
By hovering over individual data points, detailed information is provided, including the number of documents in which a topic is used in comparison with the total number of documents available for the selected product. Topics whose data points form a nearly continuous line across the document axis indicate usage in almost all documents associated with that product. Such linear patterns indicate product-wide topic reuse. There is a relatively high number of documents per product because the documents are produced for customer-specific orders.
This visualization and corresponding analysis support the identification of potential standard topics that are consistently applied across all documents of a product. These topics can be interpreted as standard topics.
4.2. AI Readiness
For the core project research area, an overview of Similarity Difference (SimDiff) and Similarity Width (SimWidth) introduced in [
3] of the available ensembles was generated. SimDiff measures how strongly similarity values vary, for example, how homogeneous the similarity structure is. This means: If the SimDiff is low, topics are more similar. If the SimDiff is high, topics are less similar.
The SimWidth describes the number of topics in the ensemble that lie above a specific similarity threshold. This number corresponds to the context given to a RAG process in case of a request as described in [
3].
Figure 7 shows box plots of the Mean SimDiff (MSD) (on the top) and SimWidth at a threshold of 0.86 (on the bottom), comparing individual product sub-ensembles (marked blue) with the global ensemble (marked red) arranged in descending order.
The graph reveals variations between products. A number of products show higher MSD values, suggesting the presence of a larger number of distinct topics. The global ensemble shows, in consequence, a quite broad similarity distribution, as it compares all available topics. Nevertheless, the investigated product ensembles have, in many cases, a high (compressed) MSD value distribution, which is above 0.6. Deviations can be identified and investigated by content architects. As a consequence, the ensembles exhibit low similarity widths, indicating that topics are quite distinct, and therefore RAG processes will reveal answers generated from a small number of context topics. Also, in this case, the discovered single deviation and SimWidth peak can be further investigated.
In contrast,
Figure 8 compares document-level sub-ensembles (marked blue) with the global ensemble (marked red). The analysis reveals that on the document level, content is much more homogeneous at high MSD values, showing more stable similarity patterns and fewer extreme variations. The global ensemble is more heterogeneous, showing larger spread and width in high similarity values. This is indicative of lower semantic distinctiveness, i.e., a certain number of linguistically similar topics.
For the first product-related data set in
Figure 7, based on the SimDiff and SimWidth analysis depicting the boxplot overview, two sub-ensembles with comparably high and low Mean Similarity Difference (MSD 0.7 and 0.4) were selected.
For each selected case, a report of an RAG query pre-test was generated, which contains the user request and the retrieved context. The retrieved context corresponds to the content with the highest cosine similarity score relative to a predefined threshold. The RAG report includes the responses generated by different LLMs. Within the scope of this project, five LLMs were evaluated.
First, a product sub-ensemble with a high MSD of 0.7 was examined by a request extracted from the topics selected for the pre-test. The same request was submitted to the global ensemble. The original question was in German, being consistent with the language of the content. In this first request pre-test, both for the sub-ensemble and the global ensemble, the correct topic was retrieved as the primary response (marked with the red boxes in
Figure 9). Regarding the response quality, all evaluated LLMs produced correct responses. However, in most cases, the answers included more information than required, which may potentially confuse users. Additionally, structural differences across LLMs were observed. For example, some models provided short summaries or explicitly mentioned the topic from which the information was derived. From these observations, it can be concluded that sub-ensembles with higher MSD values tend to be easier for the retrieval process to separate and result in more precise retrieval behavior, particularly when comparing sub-ensembles to global ensembles.
Secondly, a product sub-ensemble with a low MSD of 0.4 was analyzed. For the product sub-ensemble, the correct topic was retrieved as the primary result (
Figure 9). Therefore, the LLM response was correct. In contrast, for the global ensemble, the correct topic was not among the top five topics with the highest cosine similarity values. Therefore, the generated answers were incorrect. In conclusion, the criteria by which sub-ensembles are generated seem to be more meaningful than MSD. The results show that with a lower MSD, the cosine Similarity Difference between these topics is much smaller. Therefore, it is much more difficult to find a threshold that specifies only one topic as context. With the global ensemble, the result is worse because many more topics could be retrieved as context.
For the analysis of the document sub-ensembles, the ensemble with the highest (MSD 0.72) and the lowest MSD (0.67) were chosen. As indicated by the MSD values, the variance was relatively small; however, it was still assessed for completeness.
For the sub-ensemble with the highest MSD, the following has been observed. For both the sub-ensemble and the global ensemble, the correct topic was chosen as context. With a threshold of 0.5, the sub-ensemble had better results than the global ensemble. In conclusion, response quality improved with fewer “wrong” topics selected as context.
For the request test of the document sub-ensemble with the lowest MSD, for both the sub-ensemble and the global ensemble, the correct topic was retrieved as context. Therefore, the response quality did not differ. In conclusion, in this specific case, if the MSD of the sub-ensemble and global ensemble are more similar, the results tend to get more similar too.
Based on these results, the question arose as to whether topic size provides any insight into AI readiness in the context of MSD. Therefore, scatter plots were generated, revealing the correlation between topic size and MSD for the global ensemble and the sub-ensembles. For the global ensemble (
Figure 10), smaller topics generally clustered towards higher MSD values, while distinct outliers with low MSD were detectable. Similar tendencies appeared for the document sub-ensembles (
Figure 11). For the product sub-ensembles (
Figure 12), there were more outliers with higher and lower MSD values. This could be because there were generic topics but also highly specific topics in those sub-ensembles.