Abstract
While SAP HANA is reported to significantly speed up business information systems that rely on large databases, it is unclear whether HANA has the same power to impact optimization modules. Optimization problems occur both in enterprise resource planning and supply chain management. This paper explores factors influencing the performance of linear optimization programs running inside and outside HANA. Basic simplex implementations in R, SQLScript, JavaScript, and Java are used for comparison. A number of test cases from the Netlib library are employed to evaluate the different approaches and to draw conclusions regarding further research needs.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Kurbel, K.: Enterprise Resource Planning and Supply Chain Management. Functions, Business Processes and Software for Manufacturing Companies. Springer, Heidelberg (2013)
Hoppe, M.: Sales and Inventory Planning with SAP APO. Galileo Press, Boston (2007)
Word, J.: SAP HANA Essentials, 2nd edn. Epistemy Press (2012)
Plattner, H.: A common database approach for OLTP and OLAP using an in-memory column database. In: Binning, C., Dageville, B. (eds.) Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data. Providence, RI, June 29–July 2, 2009. ACM, New York (2009)
IBM ILOG CPLEX Optimization Studio. http://www-03.ibm.com/software/products/en/ibmilogcpleoptistud/. Accessed 6 Sept 2014
Gurobi Optimization. http://www.gurobi.com/en. Accessed 6 Sept 2014
LINGO 14.0. Optimization modeling software for linear, nonlinear, and integer programming. http://www.lindo.com/. Accessed 6 Sept 2014
SAP SE: SAP HANA Developer Guide—SAP HANA Platform SPS 08, Document Version: 1.1—2014-08-21 (2014). http://help.sap.de/hana/SAP_HANA_Developer_Guide_en.pdf. Accessed 4 Sept 2014
Berkelaar, M.: Package ‘lpSolve’. Version 5.6.10. http://cran.r-project.org/web/packages/lpSolve/lpSolve.pdf. Accessed 6 Sept 2014
Netlib.org: The NETLIB LP test problem set. http://www.netlib.org/lp/data/. Accessed 6 Sept 2014
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer International Publishing Switzerland
About this paper
Cite this paper
Kurbel, K., Nowak, D. (2016). Is SAP HANA Useful for Optimization? An Exploration of LP Implementation Alternatives. In: Piazolo, F., Felderer, M. (eds) Multidimensional Views on Enterprise Information Systems. Lecture Notes in Information Systems and Organisation, vol 12. Springer, Cham. https://doi.org/10.1007/978-3-319-27043-2_9
Download citation
DOI: https://doi.org/10.1007/978-3-319-27043-2_9
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-27041-8
Online ISBN: 978-3-319-27043-2
eBook Packages: Business and ManagementBusiness and Management (R0)