Reporting optimizations with bill of materials hierarchy traversal in in-memory database domain using set oriented technique

Abstract

Customers with production environment with massive customization in their logic leads to the challenge of traversing the Bill of Materials data hierarchy and its effective management for real time reporting which is required to accommodate diverse operations. There are various techniques to streamline the process of reporting but in present scenario, customers are doing it in batch rocessing manner and the reports are generated for past data and the tools and techniques used require human intervention. This paper comes up with effective in-memory database technique to traverse the complex BOM data hierarchy and facilitate in real time reporting. This not only helps the customer to customize their databases and have complex hierarchies but also helps in real time reporting which facilitates the customers to have insights to their business in real time with the advantage of streamlining their past and present performances and predict the future performances to edge the competition. The experiment was done with a top FMCG company data which provided us with the insights of decomplicating the traversal stage in an in-memory database paradigm leading to faster reporting times.