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 processing 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 de-complicating the traversal stage in an in-memory database paradigm leading to faster reporting times.
Keywords
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Tinnefeld, C., Wagner, B., Plattner, H.: Operating on Hierarchical Enterprise Data in an In-Memory Column Store
Papadimitriou, C.H., Sideri, M.: On the Floyd–Warshall algorithm for logic programs. The Journal of Logic Programming 41(1), 129–137 (1999)
Adam Drozdek’s Data Structures and Algorithms in C++, p. 173. PWS Publishing (1996)
Ordonez, C.: Optimization of linear recursive queries in SQL. IEEE Transactions on Knowledge and Data Engineering 22(2), 264–277 (2010)
Abadi, D.J., Samuel, R., Madden, N.: Column-Stores vs. Row-Stores: How different are they really? In: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data. ACM (2008)
Data in an In-Memory Column Store, Carlos Ordonez Optimization of Linear Recursive Queries in SQL
Knolmeyer, G., Mertens, P., Zeier, A., Dickersbach, J.: The SAP HANA Database – An Architecture Overview
Supply chain management and advanced planning-—basics, overview and challenges
H Stadtler - European journal of operational research–Elsevier (2005)
Agarwal, R.C., Aggarwal, C.C., Prasad, V.V.V.: A tree projection algorithm for generation of frequent item sets. Journal of Parallel and Distributed Computing 61(3), 350–371 (2001)
Carlos Ordonez, Optimization of Linear Recursive Queries in SQL
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Dasgupta, S.S., Mahanta, P., Pradeep, S., Subramanian, G. (2014). Reporting Optimizations with Bill of Materials Hierarchy Traversal in In-Memory Database Domain Using Set Oriented Technique. In: Meersman, R., et al. On the Move to Meaningful Internet Systems: OTM 2014 Workshops. OTM 2014. Lecture Notes in Computer Science, vol 8842. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-45550-0_13
Download citation
DOI: https://doi.org/10.1007/978-3-662-45550-0_13
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-662-45549-4
Online ISBN: 978-3-662-45550-0
eBook Packages: Computer ScienceComputer Science (R0)