Logo des Repositoriums

Auflistung nach Autor:in "Butzmann, Lars"

1 - 2 von 2
  • Konferenzbeitrag
    Available-to-promise on an in-memory column store
    (Datenbanksysteme für Business, Technologie und Web (BTW), 2011) Tinnefeld, Christian; Müller, Stephan; Kaltegärtner, Helen; Hillig, Sebastian; Butzmann, Lars; Eickhoff, David; Klauck, Stefan; Taschik, Daniel; Wagner, Björn; Xylander, Oliver; Tosun, Cafer; Zeier, Alexander; Plattner, Hasso
    Available-To-Promise (ATP) is an application in the context of Supply Chain Management (SCM) systems and provides a checking mechanism that calculates if the desired products of a customer order can be delivered on the requested date. Modern SCM systems store relevant data records as aggregated numbers which implies the disadvantages of maintaining redundant data as well as inflexibility in querying the data. Our approach omits aggregates by storing all individual data records in an in-memory, column-store and scans through all relevant records on-the-fly for each check. We contribute by describing the novel data organization and a lockingfree, highly-concurrent ATP checking algorithm. Additionally, we explain how new business functionality such as instant rescheduling of orders can be realized with our approach. All concepts are implemented within a prototype and benchmarked by using an anonymized SCM dataset of a Fortune 500 consumer products company. The paper closes with a discussion of the results and gives an outlook how this approach can help companies to find the right balance between low inventory costs and high order fulfillment rates.
  • Konferenzbeitrag
    Generic Business Simulation Using an In-Memory Column Store
    (Datenbanksysteme für Business, Technologie und Web (BTW 2015), 2015) Butzmann, Lars; Klauck, Stefan; Müller, Stephan; Uflacker, Matthias; Sinzig, Werner; Plattner, Hasso
    Value driver trees are a well-known methodology to model dependencies such as the definition of key performance indicators. While the models have well-known semantics, they lack the right tool support for business simulations, because a flexible implementation that supports multidimensional, hierarchical value driver trees and data bindings is very complex and computationally challenging. This paper tackles this problem by proposing an approach for generic enterprise simulations which are based on value driver trees. Our approach is two-fold: we present the definition of a simulation meta model at design time, and the run-time simulation tool. The simulation meta model describes the structure of the dependency graph, the data binding, and the parametrization of the model to simulate data changes. The simulation tool can then be used to create and edit simulation model instances and run simulations in real-time by leveraging an in-memory column store. Besides the formal description of the approach, this work presents a prototypical implementation of the simulation tool and an evaluation using data of a consumer packaged goods company.