IDEAS home Printed from https://ideas.repec.org/a/eee/renene/v123y2018icp513-525.html
   My bibliography  Save this article

A database infrastructure to implement real-time solar and wind power generation intra-hour forecasts

Author

Listed:
  • Pedro, Hugo T.C.
  • Lim, Edwin
  • Coimbra, Carlos F.M.

Abstract

This paper presents a simple forecasting database infrastructure implemented using the open-source database management system MySQL. This proposal aims at advancing the myriad of solar and wind forecast models present in the literature into a production stage. The paper gives all relevant details necessary to implement a MySQL infra-structure that collects the raw data, filters unrealistic values, classifies the data, and produces forecasts automatically and without the assistance of any other computational tools. The performance of this methodology is demonstrated by creating intra-hour power output forecasts for a 1 MW photovoltaic installation in Southern California and a 10 MW wind power plant in Central California. Several machine learning forecast models are implemented (persistence, auto-regressive and nearest neighbors) and tested. Both point forecasts and prediction intervals are generated with this methodology. Quantitative and qualitative analyses of solar and wind power forecasts were performed for an extended testing period (4 years and 6 years, respectively). Results show an acceptable and robust performance for the proposed forecasts.

Suggested Citation

  • Pedro, Hugo T.C. & Lim, Edwin & Coimbra, Carlos F.M., 2018. "A database infrastructure to implement real-time solar and wind power generation intra-hour forecasts," Renewable Energy, Elsevier, vol. 123(C), pages 513-525.
    • Handle: RePEc:eee:renene:v:123:y:2018:i:c:p:513-525
    DOI: 10.1016/j.renene.2018.02.043
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0960148118301873
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.renene.2018.02.043?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Badescu, Viorel & Gueymard, Christian A. & Cheval, Sorin & Oprea, Cristian & Baciu, Madalina & Dumitrescu, Alexandru & Iacobescu, Flavius & Milos, Ioan & Rada, Costel, 2013. "Accuracy analysis for fifty-four clear-sky solar radiation models using routine hourly global irradiance measurements in Romania," Renewable Energy, Elsevier, vol. 55(C), pages 85-103.
    2. Voyant, Cyril & Notton, Gilles & Kalogirou, Soteris & Nivet, Marie-Laure & Paoli, Christophe & Motte, Fabrice & Fouilloy, Alexis, 2017. "Machine learning methods for solar radiation forecasting: A review," Renewable Energy, Elsevier, vol. 105(C), pages 569-582.
    3. Blonbou, Ruddy, 2011. "Very short-term wind power forecasting with neural networks and adaptive Bayesian learning," Renewable Energy, Elsevier, vol. 36(3), pages 1118-1124.
    4. Chu, Yinghao & Li, Mengying & Pedro, Hugo T.C. & Coimbra, Carlos F.M., 2015. "Real-time prediction intervals for intra-hour DNI forecasts," Renewable Energy, Elsevier, vol. 83(C), pages 234-244.
    5. Dong, Qingli & Sun, Yuhuan & Li, Peizhi, 2017. "A novel forecasting model based on a hybrid processing strategy and an optimized local linear fuzzy neural network to make wind power forecasting: A case study of wind farms in China," Renewable Energy, Elsevier, vol. 102(PA), pages 241-257.
    6. Neves, Diana & Brito, Miguel C. & Silva, Carlos A., 2016. "Impact of solar and wind forecast uncertainties on demand response of isolated microgrids," Renewable Energy, Elsevier, vol. 87(P2), pages 1003-1015.
    7. Simão, H.P. & Powell, W.B. & Archer, C.L. & Kempton, W., 2017. "The challenge of integrating offshore wind power in the U.S. electric grid. Part II: Simulation of electricity market operations," Renewable Energy, Elsevier, vol. 103(C), pages 418-431.
    8. Reikard, Gordon & Haupt, Sue Ellen & Jensen, Tara, 2017. "Forecasting ground-level irradiance over short horizons: Time series, meteorological, and time-varying parameter models," Renewable Energy, Elsevier, vol. 112(C), pages 474-485.
    9. Draxl, Caroline & Clifton, Andrew & Hodge, Bri-Mathias & McCaa, Jim, 2015. "The Wind Integration National Dataset (WIND) Toolkit," Applied Energy, Elsevier, vol. 151(C), pages 355-366.
    10. Archer, C.L. & Simão, H.P. & Kempton, W. & Powell, W.B. & Dvorak, M.J., 2017. "The challenge of integrating offshore wind power in the U.S. electric grid. Part I: Wind forecast error," Renewable Energy, Elsevier, vol. 103(C), pages 346-360.
    11. Foley, Aoife M. & Leahy, Paul G. & Marvuglia, Antonino & McKeogh, Eamon J., 2012. "Current methods and advances in forecasting of wind power generation," Renewable Energy, Elsevier, vol. 37(1), pages 1-8.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Yang, Hufang & Jiang, Ping & Wang, Ying & Li, Hongmin, 2022. "A fuzzy intelligent forecasting system based on combined fuzzification strategy and improved optimization algorithm for renewable energy power generation," Applied Energy, Elsevier, vol. 325(C).
    2. Luis Mazorra-Aguiar & Philippe Lauret & Mathieu David & Albert Oliver & Gustavo Montero, 2021. "Comparison of Two Solar Probabilistic Forecasting Methodologies for Microgrids Energy Efficiency," Energies, MDPI, vol. 14(6), pages 1-26, March.
    3. Fatemi, Seyyed A. & Kuh, Anthony & Fripp, Matthias, 2018. "Parametric methods for probabilistic forecasting of solar irradiance," Renewable Energy, Elsevier, vol. 129(PA), pages 666-676.
    4. Yang, Dazhi & Wu, Elynn & Kleissl, Jan, 2019. "Operational solar forecasting for the real-time market," International Journal of Forecasting, Elsevier, vol. 35(4), pages 1499-1519.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Jha, Sunil Kr. & Bilalovic, Jasmin & Jha, Anju & Patel, Nilesh & Zhang, Han, 2017. "Renewable energy: Present research and future scope of Artificial Intelligence," Renewable and Sustainable Energy Reviews, Elsevier, vol. 77(C), pages 297-317.
    2. Shahriari, M. & Cervone, G. & Clemente-Harding, L. & Delle Monache, L., 2020. "Using the analog ensemble method as a proxy measurement for wind power predictability," Renewable Energy, Elsevier, vol. 146(C), pages 789-801.
    3. Da Liu & Kun Sun & Han Huang & Pingzhou Tang, 2018. "Monthly Load Forecasting Based on Economic Data by Decomposition Integration Theory," Sustainability, MDPI, vol. 10(9), pages 1-22, September.
    4. Dokur, Emrah & Erdogan, Nuh & Salari, Mahdi Ebrahimi & Karakuzu, Cihan & Murphy, Jimmy, 2022. "Offshore wind speed short-term forecasting based on a hybrid method: Swarm decomposition and meta-extreme learning machine," Energy, Elsevier, vol. 248(C).
    5. Moldovan, Camelia Liliana & Păltănea, Radu & Visa, Ion, 2020. "Improvement of clear sky models for direct solar irradiance considering turbidity factor variable during the day," Renewable Energy, Elsevier, vol. 161(C), pages 559-569.
    6. Han, Chanok & Vinel, Alexander, 2022. "Reducing forecasting error by optimally pooling wind energy generation sources through portfolio optimization," Energy, Elsevier, vol. 239(PB).
    7. Gu, Bo & Zhang, Tianren & Meng, Hang & Zhang, Jinhua, 2021. "Short-term forecasting and uncertainty analysis of wind power based on long short-term memory, cloud model and non-parametric kernel density estimation," Renewable Energy, Elsevier, vol. 164(C), pages 687-708.
    8. Yu, Guangzheng & Liu, Chengquan & Tang, Bo & Chen, Rusi & Lu, Liu & Cui, Chaoyue & Hu, Yue & Shen, Lingxu & Muyeen, S.M., 2022. "Short term wind power prediction for regional wind farms based on spatial-temporal characteristic distribution," Renewable Energy, Elsevier, vol. 199(C), pages 599-612.
    9. Reikard, Gordon & Hansen, Clifford, 2019. "Forecasting solar irradiance at short horizons: Frequency and time domain models," Renewable Energy, Elsevier, vol. 135(C), pages 1270-1290.
    10. Duarte Jacondino, William & Nascimento, Ana Lucia da Silva & Calvetti, Leonardo & Fisch, Gilberto & Augustus Assis Beneti, Cesar & da Paz, Sheila Radman, 2021. "Hourly day-ahead wind power forecasting at two wind farms in northeast Brazil using WRF model," Energy, Elsevier, vol. 230(C).
    11. Samu, Remember & Calais, Martina & Shafiullah, G.M. & Moghbel, Moayed & Shoeb, Md Asaduzzaman & Nouri, Bijan & Blum, Niklas, 2021. "Applications for solar irradiance nowcasting in the control of microgrids: A review," Renewable and Sustainable Energy Reviews, Elsevier, vol. 147(C).
    12. Banshwar, Anuj & Sharma, Naveen Kumar & Sood, Yog Raj & Shrivastava, Rajnish, 2018. "An international experience of technical and economic aspects of ancillary services in deregulated power industry: Lessons for emerging BRIC electricity markets," Renewable and Sustainable Energy Reviews, Elsevier, vol. 90(C), pages 774-801.
    13. Lledó, Ll. & Torralba, V. & Soret, A. & Ramon, J. & Doblas-Reyes, F.J., 2019. "Seasonal forecasts of wind power generation," Renewable Energy, Elsevier, vol. 143(C), pages 91-100.
    14. Ahmed, Adil & Khalid, Muhammad, 2019. "A review on the selected applications of forecasting models in renewable power systems," Renewable and Sustainable Energy Reviews, Elsevier, vol. 100(C), pages 9-21.
    15. Paulescu, Marius & Paulescu, Eugenia, 2019. "Short-term forecasting of solar irradiance," Renewable Energy, Elsevier, vol. 143(C), pages 985-994.
    16. Jordehi, A. Rezaee, 2018. "How to deal with uncertainties in electric power systems? A review," Renewable and Sustainable Energy Reviews, Elsevier, vol. 96(C), pages 145-155.
    17. Johann Baumgartner & Katharina Gruber & Sofia G. Simoes & Yves-Marie Saint-Drenan & Johannes Schmidt, 2020. "Less Information, Similar Performance: Comparing Machine Learning-Based Time Series of Wind Power Generation to Renewables.ninja," Energies, MDPI, vol. 13(9), pages 1-23, May.
    18. Cheng, William Y.Y. & Liu, Yubao & Bourgeois, Alfred J. & Wu, Yonghui & Haupt, Sue Ellen, 2017. "Short-term wind forecast of a data assimilation/weather forecasting system with wind turbine anemometer measurement assimilation," Renewable Energy, Elsevier, vol. 107(C), pages 340-351.
    19. Lan, Hai & Yin, He & Hong, Ying-Yi & Wen, Shuli & Yu, David C. & Cheng, Peng, 2018. "Day-ahead spatio-temporal forecasting of solar irradiation along a navigation route," Applied Energy, Elsevier, vol. 211(C), pages 15-27.
    20. Nie, Yuhao & Li, Xiatong & Paletta, Quentin & Aragon, Max & Scott, Andea & Brandt, Adam, 2024. "Open-source sky image datasets for solar forecasting with deep learning: A comprehensive survey," Renewable and Sustainable Energy Reviews, Elsevier, vol. 189(PB).

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:renene:v:123:y:2018:i:c:p:513-525. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.journals.elsevier.com/renewable-energy .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.