Papers
Topics
Authors
Recent
Search
2000 character limit reached

Evaluation of NoSQL in the Energy Marketplace with GraphQL Optimization

Published 7 Mar 2024 in cs.DB | (2403.04935v1)

Abstract: The growing popularity of electric vehicles in the United States requires an ever-expanding infrastructure of commercial DC fast charging stations. The U.S. Department of Energy estimates 33,355 publicly available DC fast charging stations as of September 2023. Range anxiety is an important impediment to the adoption of electric vehicles and is even more relevant in underserved regions in the country. The peer-to-peer energy marketplace helps fill the demand by allowing private home and small business owners to rent their 240 Volt, level-2 charging facilities. The existing, publicly accessible outlets are wrapped with a Cloud-connected microcontroller managing security and charging sessions. These microcontrollers act as Edge devices communicating with a Cloud message broker, while both buyer and seller users interact with the framework via a web-based user interface. The database storage used by the marketplace framework is a key component in both the cost of development and the performance that contributes to the user experience. A traditional storage solution is the SQL database. However, difficulty in scaling across multiple nodes and cost of its server-based compute have resulted in a trend in the last 20 years towards other NoSQL, serverless approaches. In this study, we evaluate the NoSQL vs. SQL solutions through a comparison of Google Cloud Firestore and Cloud SQL MySQL offerings. The comparison pits Google's serverless, document-model, non-relational, NoSQL against the server-base, table-model, relational, SQL service. The evaluation is based on query latency, flexibility/scalability, and cost criteria. Through benchmarking and analysis of the architecture, we determine whether Firestore can support the energy marketplace storage needs and if the introduction of a GraphQL middleware layer can overcome its deficiencies.

Authors (1)
Definition Search Book Streamline Icon: https://streamlinehq.com
References (33)
  1. Airbnb, 2022. URL https://www.airbnb.com. Accessed: 2022-08-13.
  2. Apollo. Apollo server, 2023. URL https://www.apollographql.com/docs/apollo-server. Accessed: 2023-09-09.
  3. R. Cattell. Scalable SQL and NoSQL data stores. SIGMOD Rec., 39(4):12–27, May 2011. ISSN 0163-5808. doi: 10.1145/1978915.1978919. URL https://doi.org/10.1145/1978915.1978919.
  4. D. D. Chamberlin. Early history of SQL. IEEE Annals of the History of Computing, 34(4):78–82, 2012. doi: 10.1109/MAHC.2012.61.
  5. Statistical challenges of administrative and transaction data. Journal of the Royal Statistical Society. Series A (Statistics in Society), 181(3):pp. 555–605, 2018. ISSN 09641998, 1467985X. URL https://www.jstor.org/stable/48547504.
  6. X. Dong and X. Li. A novel distributed database solution based on MySQL. In 2015 7th International Conference on Information Technology in Medicine and Education (ITME), pages 329–333, 2015. doi: 10.1109/ITME.2015.48.
  7. EVAdoption. US charging network rankings, 2022. URL https://evadoption.com/ev-charging-stations-statistics/us-charging-network-rankings.
  8. Migrating to GraphQL: A practical assessment. In 2019 IEEE 26th International Conference on Software Analysis, Evolution and Reengineering (SANER), pages 140–150, 2019. doi: 10.1109/SANER.2019.8667986.
  9. Google. Firestore, 2023a. URL https://cloud.google.com/sql/firestore. Accessed: 2023-06-19.
  10. Google. Pricing: Firestore, 2023b. URL https://cloud.google.com/firestore/pricing. Accessed: 2023-06-22.
  11. Google. Geo queries, 2023c. URL https://cloud.google.com/firestore/docs/solutions/geoqueries. Accessed: 2023-09-10.
  12. Google. Cloud SQL for MySQL, 2023d. URL https://cloud.google.com/sql/mysql. Accessed: 2023-06-19.
  13. Google. Pricing: Cloud SQL MySQL, 2023e. URL https://cloud.google.com/sql/pricing#mysql-pg-pricing. Accessed: 2023-06-22.
  14. How do i choose the right NoSQL solution? a comprehensive theoretical and experimental survey. Big Data and Information Analytics, 1(2):185–216, 2016.
  15. R. Irle. The electric vehicle world sales database, 2023. URL https://www.ev-volumes.com. Accessed: 2023-06-16.
  16. Spanner: Google’s globally distributed database. ACM Trans. Comput. Syst., 31(3), Aug 2013. ISSN 0734-2071. doi: 10.1145/2491245. URL https://doi.org/10.1145/2491245.
  17. A heterogeneous IoT data analysis framework with collaboration of edge-cloud computing: Focusing on indoor pm10 and pm2. 5 status prediction. Sensors, 19(14):3038, 2019.
  18. Performance evaluation of IoT data management using MongoDB versus MySQL databases in different cloud environments. IEEE Access, 8:110656–110668, 2020. doi: 10.1109/ACCESS.2020.3002164.
  19. Microsoft. Analyze data in Excel, 2023. URL https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4. Accessed: 2023-06-21.
  20. A survey and comparison of relational and non-relational database. International Journal of Engineering Research & Technology, 1(6):1–5, 2012.
  21. D. Ongaro and J. Ousterhout. The Raft consensus algorithm, 2023. URL https://raft.github.io/. Accessed: 2023-07-04.
  22. R. Pandey. Performance benchmarking and comparison of cloud-based databases MongoDB (NoSQL) vs MySQL (relational) using YCSB. Technical report, Technical Report. https://doi. org/10.13140/RG. 2.2. 10789.32484, 2020.
  23. J. Pokorny. NoSQL databases: A step to database scalability in web environment. In Proceedings of the 13th International Conference on Information Integration and Web-Based Applications and Services, iiWAS ’11, page 278–283, New York, NY, USA, 2011. Association for Computing Machinery. ISBN 9781450307840. doi: 10.1145/2095536.2095583. URL https://doi.org/10.1145/2095536.2095583.
  24. Mysql conceptual architecture. Technical report, University of Waterloo, 2002.
  25. Firestore: The NoSQL serverless database for the application developer. In 2023 IEEE 39th International Conference on Data Engineering (ICDE), pages 3367–3379, 2023.
  26. Solar Energy Industries Association. Solar data facts sheet, 2022. URL https://www.seia.org/research-resources/solar-data-cheat-sheet. Accessed: 2022-08-13.
  27. Stripe. Stripe payment processing platform for the Internet, 2023. URL https://www.stripe.com. Accessed: 2023-06-16.
  28. T. Taipalus and V. Seppänen. SQL education: A systematic mapping study and future research agenda. ACM Trans. Comput. Educ., 20(3), Aug 2020. doi: 10.1145/3398377. URL https://doi.org/10.1145/3398377.
  29. Uber, 2022. URL https://www.uber.com. Accessed: 2022-08-13.
  30. U.S. Department of Energy. Alternate fueling station locator, 2022a. URL https://afdc.energy.gov/stations/#/analyze. Accessed: 2022-08-02.
  31. U.S. Department of Energy. Light-duty vehicle registration counts by state and fuel type, 2022b. URL https://afdc.energy.gov/vehicle-registration. Accessed: 2024-01-17.
  32. R. Yadav and A. Rahut. FlexiRaft: Flexible Quorums with Raft. The Conference on Innovative Data Systems Research (CIDR), 2023.
  33. Yahoo! Yahoo cloud serving benchmark, 2010. URL https://research.yahoo.com/news/yahoo-cloud-serving-benchmark/. Accessed: 2023-06-19.

Summary

No one has generated a summary of this paper yet.

Sign Up to Summarize

Paper to Video (Beta)

No one has generated a video about this paper yet.

Sign Up to Generate All Videos Subscribe on YouTube

Whiteboard

No one has generated a whiteboard explanation for this paper yet.

Sign Up to Generate

Open Problems

We haven't generated a list of open problems mentioned in this paper yet.

Generate Now

Continue Learning

We haven't generated follow-up questions for this paper yet.

Generate Now

Collections

Sign up for free to add this paper to one or more collections.

Sign Up