JCSE, vol. 12, no. 2, pp.63-76, 2018

DOI: http://dx.doi.org/10.5626/JCSE.2018.12.2.63

Interval Disaggregation with Product Life Cycles and Constraints

Sunho Lee, Cheol Ryu, Sang Kyun Cha, Kunsoo Park, Jungsuk Oh, Kihong Kim, and Changbin Song
Seoul National University, Seoul, Korea SAP Labs Korea, Seoul, Korea

Abstract: Disaggregation is a common operation in business applications. One of the main disaggregation operations in use has been referential disaggregation, but a more advanced disaggregation operation called interval disaggregation has recently been introduced. In this paper we significantly generalize the model of interval disaggregation in the previous work. Through nonlinear regression, we apply interval disaggregation to the products with product life cycle curves. We implemented interval disaggregation with product life cycles as a relational operator in a commercial in-memory database system and did experiments on real-world data. Our experiments show that interval disaggregation with product life cycles outperforms previous disaggregation operations. We also present a technique that combines constraints such as factory capacities into interval disaggregation, so that we can find a product mix that maximizes profit subject to the constraints.

Keyword: Disaggregation; Product life cycles; Constraints; Nonlinear regression

Full Paper:   250 Downloads, 1441 View