Skip to main content

Analytical Possibilities of SAP HANA – On the Example of Energy Consumption Forecasting

  • Conference paper
Advances in Systems Science

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 240))

Abstract

The vast amount of data that organizations should gather, store and process, entails a set of new requirements towards the analytical solutions used by organizations. These requirements have become drivers for the development of the in-memory computing paradigm, which enables the creation of applications running advanced queries and performing complex transactions on very large sets of data in a much faster and scalable way than the traditional solutions. The main aim of our work is to examine the analytical possibilities of the in-memory computing solution, on the example of SAP HANA, and their possible applications. In order to do that we apply SAP HANA and its components to the challenge of forecasting of the energy demand in the energy sector. In order to examine the analytical possibilities of SAP HANA, a number of experiments were conducted. Their results are described in this paper.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Farber, F., May, N., Lehner, W., Grosse, P., Muller, I., Rauhe, H., Dees, J.: The SAP HANA database – an architecture overview. IEEE Data Eng. Bull., 28–33 (2012)

    Google Scholar 

  2. Plattner, H., Zeier, A.: In-Memory Data Management: An Inflection Point for Enterprise Applications. Springer, Heidelberg (2011)

    Book  Google Scholar 

  3. Gartner, P.R.: Gartner says in-memory computing is racing towards mainstream adoption (April 3, 2013), http://www.gartner.com/newsroom/id/2405315

  4. Weron, R.: Modeling and Forecasting Electricity Loads and Prices: A Statistical Approach. John Wiley and Sons Ltd. (2006)

    Google Scholar 

  5. Färber, F., Cha, S.K., Primsch, J., Bornhövd, C., Sigg, S., Lehner, W.: Sap hana database: data management for modern business applications. SIGMOD Rec. 40(4), 45–51 (2012)

    Article  Google Scholar 

  6. Bernard, M.: SAP High-Performance Analytic Appliance 1.0 (SAP HANA) - A First Look at the System Architecture (2011)

    Google Scholar 

  7. Aragon, Y.: Séries temporelles avec R. Méthodes et cas, 1st edn. Springer, Collection Pratique R (2011)

    Book  MATH  Google Scholar 

  8. SAP: SAP HANA R Integration Guide (2013)

    Google Scholar 

  9. SAP: SAP HANA Predictive Analysis Library (PAL) Reference (2012)

    Google Scholar 

  10. Schellong, W.: Energy Demand Analysis and Forecast. In: Energy Management Systems, pp. 101–120. InTech (2011)

    Google Scholar 

  11. Wang, J., Ma, X., Wu, J., Dong, Y.: Optimization models based on gm (1) and seasonal fluctuation for electricity demand forecasting. International Journal of Electrical Power & Energy Systems 43(1), 109–117 (2012)

    Article  Google Scholar 

  12. McLoughlin, F., Duffy, A., Conlon, M.: Evaluation of time series techniques to characterise domestic electricity demand. Energy 50, 120–130 (2013)

    Article  Google Scholar 

  13. Zadeh, S., Masoumi, A.: Modeling residential electricity demand using neural network and econometrics approaches. In: 2010 40th International Conference on Computers and Industrial Engineering (CIE), pp. 1–6 (July 2010)

    Google Scholar 

  14. Kiran, M.S., Ozceylan, E., Gunduz, M., Paksoy, T.: A novel hybrid approach based on particle swarm optimization and ant colony algorithm to forecast energy demand of turkey. Energy Conversion and Management 53(1), 75–83 (2012)

    Article  Google Scholar 

  15. Shakouri, G.H., Nadimi, R., Ghaderi, F.: A hybrid tsk-fr model to study short-term variations of the electricity demand versus the temperature changes. Expert Systems with Applications 36(2, pt. 1), 1765–1772 (2009)

    Article  Google Scholar 

  16. Charytoniuk, W., Chen, M.S.S., Kotas, P., Van Olinda, P.: Demand forecasting in power distribution systems using nonparametric probability density estimation. IEEE Transactions on Power Systems 14(4), 1200–1206 (1999)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Tomasz Rudny .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer International Publishing Switzerland

About this paper

Cite this paper

Rudny, T., Kaczmarek, M., Abramowicz, W. (2014). Analytical Possibilities of SAP HANA – On the Example of Energy Consumption Forecasting. In: Swiątek, J., Grzech, A., Swiątek, P., Tomczak, J. (eds) Advances in Systems Science. Advances in Intelligent Systems and Computing, vol 240. Springer, Cham. https://doi.org/10.1007/978-3-319-01857-7_14

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-01857-7_14

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-01856-0

  • Online ISBN: 978-3-319-01857-7

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics