Skip to main content
SpringerLink
Log in
Book cover

Multidimensional Views on Enterprise Information Systems pp 113–121Cite as

Is SAP HANA Useful for Optimization? An Exploration of LP Implementation Alternatives

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Information Systems and Organisation ((LNISO,volume 12))

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.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

References

  1. Kurbel, K.: Enterprise Resource Planning and Supply Chain Management. Functions, Business Processes and Software for Manufacturing Companies. Springer, Heidelberg (2013)

    Google Scholar 

  2. Hoppe, M.: Sales and Inventory Planning with SAP APO. Galileo Press, Boston (2007)

    Google Scholar 

  3. Word, J.: SAP HANA Essentials, 2nd edn. Epistemy Press (2012)

    Google Scholar 

  4. 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)

    Google Scholar 

  5. IBM ILOG CPLEX Optimization Studio. http://www-03.ibm.com/software/products/en/ibmilogcpleoptistud/. Accessed 6 Sept 2014

  6. Gurobi Optimization. http://www.gurobi.com/en. Accessed 6 Sept 2014

  7. LINGO 14.0. Optimization modeling software for linear, nonlinear, and integer programming. http://www.lindo.com/. Accessed 6 Sept 2014

  8. 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

  9. Berkelaar, M.: Package ‘lpSolve’. Version 5.6.10. http://cran.r-project.org/web/packages/lpSolve/lpSolve.pdf. Accessed 6 Sept 2014

  10. Netlib.org: The NETLIB LP test problem set. http://www.netlib.org/lp/data/. Accessed 6 Sept 2014

Download references

Author information

Authors and Affiliations

  1. Chair of Business Informatics, European University Viadrina Frankfurt (Oder), Grosse Scharrnstrasse 59, 15230, Frankfurt (Oder), Germany

    Karl Kurbel & Dawid Nowak

Authors
  1. Karl Kurbel
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Dawid Nowak
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Karl Kurbel .

Editor information

Editors and Affiliations

  1. University of Innsbruck, Innsbruck, Austria

    Felix Piazolo

  2. Institute of Computer Science, University of Innsbruck, Innsbruck, Austria

    Michael Felderer

Rights and permissions

Reprints 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

Publish with us

Policies and ethics

Search

Navigation