Skip to main content
SpringerLink
Log in

Reinventing the Energy Bill in Smart Cities with NoSQL Technologies

  • Conference paper
  • First Online:
Book cover Transactions on Engineering Technologies

Abstract

With the increasing use of electrical devices, cities consume more energy to sustain their daily activities, facing more challenges associated with energy control and distribution. This chapter revisits a previously proposed architecture to extract, load, transform, mine and forecast Big Data within a Smart City context, in order to discuss the adequacy of NoSQL databases to deliver a Smart City service that reinvents the traditional energy bill, using web and mobile applications. Citizens will benefit from a new form of self-monitoring their electricity and gas consumption, by comparing themselves to others within their cluster or region and by forecasting future energy consumptions. Moreover, the service also delivers to energy providers and cities a smarter overview of the energy landscape. The technological architecture was previously validated using simulated data from the United States of America (USA), due to its open availability, and revealed very satisfactory results concerning the performance of clustering and time series forecasting models. This chapter extends the previously proposed technological architecture, by providing real-time concurrent web and mobile access to citizens, while presenting a broad review of several NoSQL benchmarks available in the scientific community, knowledge that is essential in the adoption of a specific database to support these web and mobile applications.

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

Access this chapter

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 169.00
Price excludes VAT (USA)
  • Available as EPUB and 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
Hardcover Book
USD 219.99
Price excludes VAT (USA)
  • Durable hardcover 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

References

  1. Vilajosana I, Llosa J, Martinez B, Domingo-Prieto M, Angles A, Vilajosana X (2013) Bootstrapping smart cities through a self-sustainable model based on big data flows. IEEE Commun Mag 51(6):128–134

    Article  Google Scholar 

  2. Hedlund J (2013) The smart city: using IT to make cities more livable

    Google Scholar 

  3. Chen M, Mao S, Liu Y (2014) Big data: a survey. Mob Netw Appl 19(2):171–209

    Article  MathSciNet  Google Scholar 

  4. Krishnan K (2013) data warehousing in the age of big data, 1st edn. Morgan Kaufmann Publishers Inc., San Francisco

    Google Scholar 

  5. Zikopoulos P, Eaton C (2011) Understanding big data: analytics for enterprise class hadoop and streaming data, 1st edn. McGraw-Hill Osborne Media, New York

    Google Scholar 

  6. Costa C, Santos MY (2015) Improving cities sustainability through the use of data mining in a context of big city data. In: Proceedings of The World Congress on Engineering 2015, London, U.K., (Lecture Notes in Engineering and Computer Science) pp 320–325

    Google Scholar 

  7. Gama J (2010) Knowledge discovery from data streams. Taylor & Francis Group, Boca Raton

    Google Scholar 

  8. Commercial and Residential Reference Building Models (2013) Commercial and residential hourly load profiles for all TMY3 locations in the United States’, Catalog, 2013 [Online]. Available: http://en.openei.org/doe-opendata/dataset/commercial-and-residential-hourly-load-profiles-for-all-tmy3-locations-in-the-united-states. Accessed 01 Dec 2014

  9. Xie Y, Zheng H, Zhang L-Z (2007) Electricity price forecasting by clustering-LSSVM. In: International power engineering conference, IPEC 2007, pp 697–702

    Google Scholar 

  10. Zhou H, Wu XH, Li XG (2011) An ANFIS model of electricity price forecasting based on subtractive clustering. In: 2011 IEEE power and energy society general meeting, pp 1–5

    Google Scholar 

  11. Azevedo F, Vale ZA (2006) Forecasting electricity prices with historical statistical information using neural networks and clustering techniques. In: Power systems conference and exposition, 2006. PSCE ’06. 2006 IEEE PES, pp 44–50

    Google Scholar 

  12. Alzate C, Sinn M (2013) Improved electricity load forecasting via Kernel Spectral clustering of smart meters. In: 2013 IEEE 13th international conference on data mining (ICDM), pp 943–948

    Google Scholar 

  13. Gu Y-D, Cheng J-Z, Wang Z-Y (2011) An fuzzy forecasting algorithm for short term electricity loads based on partial clustering. In: 2011 international conference on machine learning and cybernetics (ICMLC), 2011, vol 4, pp 1560–1565

    Google Scholar 

  14. Alahakoon D, Yu X (2013) Advanced analytics for harnessing the power of smart meter big data. In: 2013 IEEE international workshop on intelligent energy systems (IWIES), pp 40–45

    Google Scholar 

  15. Simmhan Y, Aman S, Kumbhare A, Liu R, Stevens S, Zhou Q, Prasanna V (2013) Cloud-based software platform for big data analytics in smart grids. Comput Sci Eng 15(4):38–47

    Article  Google Scholar 

  16. Arenas-Martínez M, Herrero-Lopez S, Sanchez A, Williams JR, Roth P, Hofmann P, Zeier A (2010) A comparative study of data storage and processing architectures for the smart grid. In: 2010 first IEEE international conference on smart grid communications (SmartGridComm), pp 285–290

    Google Scholar 

  17. Mayilvaganan M, Sabitha M (2013) A cloud-based architecture for big-data analytics in smart grid: a proposal. In: 2013 IEEE international conference on computational intelligence and computing research (ICCIC), pp 1–4

    Google Scholar 

  18. Abramova V, Bernardino J, Furtado P (2014) Which NoSQL database? A performance overview. Open J. Databases 1(2):17–24

    Google Scholar 

  19. Leavitt N (2010) Will NoSQL databases live up to their promise? Computer 43(2):12–14

    Article  Google Scholar 

  20. Tiwari S (2011) Professional NoSQL. Wiley, New York

    Google Scholar 

  21. Tudorica BG, Bucur C (2011) A comparison between several NoSQL databases with comments and notes. In: 2011 10th Roedunet international conference (RoEduNet), pp 1–5

    Google Scholar 

  22. Cooper BF (2015) Yahoo! cloud serving benchmark, 31 Mar 2010 [Online]. Available: https://s.yimg.com/ge/labs/v1/files/ycsb-v4.pdf. Accessed 11 Mar 2015

  23. Cooper BF, Silberstein A, Tam E, Ramakrishnan R, Sears R (2010) Benchmarking cloud serving systems with YCSB. In: Proceedings of the 1st ACM symposium on cloud computing, New York, NY, USA, pp 143–154

    Google Scholar 

  24. Kashyap S, Zamwar S, Bhavsar T, Singh S (2013) Benchmarking and analysis of NoSQL technologies. Int J Emerg Technol Adv Eng 3(9):422–426

    Google Scholar 

  25. Dory T, Mejías B, Van Roy P, Tran N-L (2011) Comparative elasticity and scalability measurements of cloud databases. In: Proceedigs of the 2nd ACM symposium on cloud computing (SoCC), vol 11

    Google Scholar 

  26. Rabl T, Gómez-Villamor S, Sadoghi M, Muntés-Mulero V, Jacobsen H-A, Mankovskii S (2012) Solving big data challenges for enterprise application performance management. Proc VLDB Endow 5(12):1724–1735

    Article  Google Scholar 

  27. Dede E, Govindaraju M, Gunter D, Canon RS, Ramakrishnan L (2013) Performance evaluation of a mongodb and hadoop platform for scientific data analysis. In: Proceedings of the 4th ACM workshop on scientific cloud computing, pp 13–20

    Google Scholar 

  28. Chevalier M, El Malki M, Kopliku A, Teste O, Tournier R (2015) Benchmark for OLAP on NoSQL technologies comparing NoSQL multidimensional data warehousing solutions. In: 2015 IEEE 9th international conference on research challenges in information science (RCIS), pp 480–485

    Google Scholar 

  29. Abubakar Y, Adeyi TS, Auta IG (2014) Performance evaluation of NoSQL systems using YCSB in a resource austere environment. Perform Eval 7(8)

    Google Scholar 

Download references

Acknowledgments

This work was supported by FCT—Fundação para a Ciência e Tecnologia, within the Project Scope: UID/CEC/00319/2013 and funded by the SusCity project, MITP-TB/CS/0026/2013.

Author information

Authors and Affiliations

  1. ALGORITMI Research Centre, University of Minho, Campus de Azurém, 4800-058, Guimarães, Portugal

    Carlos Costa & Maribel Yasmina Santos

Authors
  1. Carlos Costa
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Maribel Yasmina Santos
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding authors

Correspondence to Carlos Costa or Maribel Yasmina Santos .

Editor information

Editors and Affiliations

  1. Intl Association of Engineers, Hong Kong, Hong Kong

    Sio-iong Ao

  2. Department of Multimedia Engineering, Mokpo National University, Chonnam, Korea (Republic of)

    Gi-Chul Yang

  3. Cranfield University, Cranfield, Bedfordshire, United Kingdom

    Len Gelman

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media Singapore

About this paper

Cite this paper

Costa, C., Santos, M.Y. (2016). Reinventing the Energy Bill in Smart Cities with NoSQL Technologies. In: Ao, Si., Yang, GC., Gelman, L. (eds) Transactions on Engineering Technologies. Springer, Singapore. https://doi.org/10.1007/978-981-10-1088-0_29

Download citation

  • DOI: https://doi.org/10.1007/978-981-10-1088-0_29

  • Published:

  • Publisher Name: Springer, Singapore

  • Print ISBN: 978-981-10-1087-3

  • Online ISBN: 978-981-10-1088-0

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation