{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,12,29]],"date-time":"2022-12-29T05:20:50Z","timestamp":1672291250666},"reference-count":32,"publisher":"Association for Computing Machinery (ACM)","issue":"13","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2014,8]]},"abstract":"<jats:p>\n            Business planning as well as analytics on top of large-scale database systems is valuable to decision makers, but planning operations known and implemented so far are very basic. In this paper we propose a new planning operation called\n            <jats:italic>interval disaggregate<\/jats:italic>\n            , which goes as follows. Suppose that the planner, typically the management of a company, plans sales revenues of its products in the current year. An interval of the expected revenue for each product in the current year is computed from historical data in the database as the prediction interval of linear regression on the data. A total target revenue for the current year is given by the planner. The goal of the interval disaggregate operation is to find an appropriate disaggregation of the target revenue, considering the intervals.\n          <\/jats:p>\n          <jats:p>We formulate the problem of interval disaggregation more precisely and give solutions for the problem. Multidimensional geometry plays a crucial role in the problem formulation and the solutions. We implemented interval disaggregation into the planning engine of SAP HANA and did experiments on real-world data. Our experiments show that interval disaggregation gives more appropriate solutions with respect to historical data than the known basic disaggregation called referential disaggregation. We also show that interval disaggregation can be combined with the deseasonalization technique when the dataset shows seasonal fluctuations.<\/jats:p>","DOI":"10.14778\/2733004.2733011","type":"journal-article","created":{"date-parts":[[2015,5,12]],"date-time":"2015-05-12T15:37:52Z","timestamp":1431445072000},"page":"1381-1392","source":"Crossref","is-referenced-by-count":0,"title":["Interval disaggregate"],"prefix":"10.14778","volume":"7","author":[{"given":"Sang K.","family":"Cha","sequence":"first","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea and Seoul National University, Seoul, Korea"}]},{"given":"Kunsoo","family":"Park","sequence":"additional","affiliation":[{"name":"SAP Labs Korea Seoul, Korea and Seoul National University, Seoul, Korea"}]},{"given":"Changbin","family":"Song","sequence":"additional","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea"}]},{"given":"Kihong","family":"Kim","sequence":"additional","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea"}]},{"given":"Cheol","family":"Ryu","sequence":"additional","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea and Seoul National University, Seoul, Korea"}]},{"given":"Sunho","family":"Lee","sequence":"additional","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea and Seoul National University, Seoul, Korea"}]}],"member":"320","published-online":{"date-parts":[[2014,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"CGAL Computational Geometry Algorithms Library http:\/\/www.cgal.org  CGAL Computational Geometry Algorithms Library http:\/\/www.cgal.org"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687576"},{"key":"e_1_2_1_3_1","volume-title":"Introduction to Algorithms","author":"Cormen T. H.","year":"2009","unstructured":"T. H. Cormen , C. E. Leiserson , R. L. Rivest , and C. Stein . Introduction to Algorithms . The MIT press , 3 th Edition, 2009 . T. H. Cormen, C. E. Leiserson, R. L. Rivest, and C. Stein. Introduction to Algorithms. The MIT press, 3th Edition, 2009.","edition":"3"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-31235-9_7"},{"issue":"3","key":"e_1_2_1_5_1","first-page":"1","article-title":"A survey of forecast models for energy demand and supply","volume":"2","author":"Dannecker L.","year":"2001","unstructured":"L. Dannecker , G. Hackenbroich , M. Boehm , U. Fischer , F. Rosenthal , and W. Lehner . A survey of forecast models for energy demand and supply . Journal of the ACM , 2 ( 3 ): 1 -- 35 , 2001 . L. Dannecker, G. Hackenbroich, M. Boehm, U. Fischer, F. Rosenthal, and W. Lehner. A survey of forecast models for energy demand and supply. Journal of the ACM, 2(3):1--35, 2001.","journal-title":"Journal of the ACM"},{"key":"e_1_2_1_6_1","volume-title":"Cost and Management Accounting. CengageBrain.com","author":"Drury C.","year":"2007","unstructured":"C. Drury . Cost and Management Accounting. CengageBrain.com , 7 th Edition, 2007 . C. Drury. Cost and Management Accounting. CengageBrain.com, 7th Edition, 2007.","edition":"7"},{"key":"e_1_2_1_7_1","unstructured":"JD Edwards World Forecasting Guide Release A9.3 2013 from Oracle: http:\/\/docs.oracle.com\/cd\/E26228_01\/doc.93\/e20706.pdf  JD Edwards World Forecasting Guide Release A9.3 2013 from Oracle: http:\/\/docs.oracle.com\/cd\/E26228_01\/doc.93\/e20706.pdf"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1201\/9781420035315"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1009726021843"},{"key":"e_1_2_1_10_1","volume-title":"Cost Accounting: A Managerial Emphasis","author":"Horngren C. T.","year":"2011","unstructured":"C. T. Horngren , S. M. Datar , and M. Rajan . Cost Accounting: A Managerial Emphasis . Prentice Hall , 14 th Edition, 2011 . C. T. Horngren, S. M. Datar, and M. Rajan. Cost Accounting: A Managerial Emphasis. Prentice Hall, 14th Edition, 2011.","edition":"14"},{"key":"e_1_2_1_11_1","unstructured":"IBM Cognos Express Advisor User Guide Version 9.0.0 2009 from IBM Corp: http:\/\/download.boulder.ibm.com\/ibmdl\/pub\/software\/data\/cognos\/documentation\/docs\/en\/9.0.0\/ea_ug.pdf  IBM Cognos Express Advisor User Guide Version 9.0.0 2009 from IBM Corp: http:\/\/download.boulder.ibm.com\/ibmdl\/pub\/software\/data\/cognos\/documentation\/docs\/en\/9.0.0\/ea_ug.pdf"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-37574-3_2"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/1739041.1739126"},{"key":"e_1_2_1_14_1","volume-title":"Technical Report","author":"Kroshko D. L.","year":"2014","unstructured":"D. L. Kroshko . Technical Report , 2014 , from OpenOpt : http:\/\/openopt.org\/interalg D. L. Kroshko. Technical Report, 2014, from OpenOpt: http:\/\/openopt.org\/interalg"},{"key":"e_1_2_1_15_1","volume-title":"Basic Statistics For Business and Economics","author":"Lind D. A.","year":"2006","unstructured":"D. A. Lind , W. G. Marchal , and S. A. Wathen . Basic Statistics For Business and Economics . Boston : McGraw-Hill\/Irwin , 2006 . D. A. Lind, W. G. Marchal, and S. A. Wathen. Basic Statistics For Business and Economics. Boston: McGraw-Hill\/Irwin, 2006."},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1287\/mnsc.30.6.765"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.5555\/581165"},{"key":"e_1_2_1_18_1","volume-title":"Introduction to Linear Regression Analysis","author":"Montgomery D. C.","year":"2012","unstructured":"D. C. Montgomery , E. A. Peck , and G. G. Vining . Introduction to Linear Regression Analysis . Wiley , 5 th Edition, Vol. 821 , 2012 . D. C. Montgomery, E. A. Peck, and G. G. Vining. Introduction to Linear Regression Analysis. Wiley, 5th Edition, Vol. 821, 2012.","edition":"5"},{"key":"e_1_2_1_19_1","volume-title":"from MathWorks","author":"User's Guide Optimization Toolbox\u2122","year":"2014","unstructured":"Optimization Toolbox\u2122 User's Guide , Release 2014a, 2014 , from MathWorks , Inc : http:\/\/www.mathworks.co.kr\/help\/releases\/R 2014 a\/pdf_doc\/optim\/optim_tb.pdf Optimization Toolbox\u2122 User's Guide, Release 2014a, 2014, from MathWorks, Inc: http:\/\/www.mathworks.co.kr\/help\/releases\/R2014a\/pdf_doc\/optim\/optim_tb.pdf"},{"key":"e_1_2_1_20_1","unstructured":"Oracle Hyperion Planning -- System 9 Release 9.3.1 2007 from Oracle: http:\/\/docs.oracle.com\/cd\/E10530_01\/doc\/epm.931\/hp_user.pdf  Oracle Hyperion Planning -- System 9 Release 9.3.1 2007 from Oracle: http:\/\/docs.oracle.com\/cd\/E10530_01\/doc\/epm.931\/hp_user.pdf"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(01)00023-0"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4612-1098-6"},{"key":"e_1_2_1_23_1","volume-title":"Pearson Education India","author":"Ross S.","year":"2012","unstructured":"S. Ross . A First Course in Probability . Pearson Education India , 9 th Edition, 2012 . S. Ross. A First Course in Probability. Pearson Education India, 9th Edition, 2012.","edition":"9"},{"key":"e_1_2_1_24_1","volume-title":"SAP EHP1 for SAP CRM 7.0","author":"SAP","year":"2013","unstructured":"SAP ERP , Business Functions , SAP EHP1 for SAP CRM 7.0 , 2013 : http:\/\/help.sap.com\/saphelp_crm700_ehp01\/helpdata\/en\/11\/53929b94c84bc89334719b1606c4de\/content.htm?frameset=\/en\/d5\/b9e2574bbd4373b59fce413325f731\/frameset.htm SAP ERP, Business Functions, SAP EHP1 for SAP CRM 7.0, 2013: http:\/\/help.sap.com\/saphelp_crm700_ehp01\/helpdata\/en\/11\/53929b94c84bc89334719b1606c4de\/content.htm?frameset=\/en\/d5\/b9e2574bbd4373b59fce413325f731\/frameset.htm"},{"key":"e_1_2_1_25_1","volume-title":"ver. 1.0","author":"Predictive Analysis Library SAP HANA","year":"2013","unstructured":"SAP HANA Predictive Analysis Library , ver. 1.0 , 2013 , from SAP : http:\/\/help.sap.com\/hana\/SAP_HANA_Predictive_Analysis_Library_PAL_en.pdf SAP HANA Predictive Analysis Library, ver. 1.0, 2013, from SAP: http:\/\/help.sap.com\/hana\/SAP_HANA_Predictive_Analysis_Library_PAL_en.pdf"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-0-85729-546-0"},{"key":"e_1_2_1_27_1","volume-title":"Database System Concepts","author":"Silberschatz A.","year":"2009","unstructured":"A. Silberschatz , H. F. Korth , and S. Sudarshan . Database System Concepts . Hightstown : McGraw-Hill , 6 th Edition, 2009 . A. Silberschatz, H. F. Korth, and S. Sudarshan. Database System Concepts. Hightstown: McGraw-Hill, 6th Edition, 2009.","edition":"6"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0377-2217(00)00329-5"},{"key":"e_1_2_1_29_1","volume-title":"Calculus and Analytic Geometry","author":"Thomas G. B.","year":"1996","unstructured":"G. B. Thomas , R. L. Finney , and M. D. Weir . Calculus and Analytic Geometry . Reading, Massachusetts : Addison-Wesley , Vol. 9 , 1996 . G. B. Thomas, R. L. Finney, and M. D. Weir. Calculus and Analytic Geometry. Reading, Massachusetts: Addison-Wesley, Vol. 9, 1996."},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1016\/0025-5564(85)90096-3"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1008775517030"},{"key":"e_1_2_1_32_1","first-page":"185","volume-title":"You Shrink!","author":"Woeginger G. J.","year":"2003","unstructured":"G. J. Woeginger . Exact algorithms for NP-hard problems: a survey. Combinatorial Optimization---Eureka , You Shrink! , pages 185 -- 207 , Springer Berlin Heidelberg , 2003 . G. J. Woeginger. Exact algorithms for NP-hard problems: a survey. Combinatorial Optimization---Eureka, You Shrink!, pages 185--207, Springer Berlin Heidelberg, 2003."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2733004.2733011","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:36:42Z","timestamp":1672220202000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2733004.2733011"}},"subtitle":["a new operator for business planning"],"short-title":[],"issued":{"date-parts":[[2014,8]]},"references-count":32,"journal-issue":{"issue":"13","published-print":{"date-parts":[[2014,8]]}},"alternative-id":["10.14778\/2733004.2733011"],"URL":"https:\/\/doi.org\/10.14778\/2733004.2733011","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2014,8]]}}}