Application of different databases in charging management systems

Computer technology is now ubiquitous. In order to deal with different situations, many different databases, such as MySQL, SQL Server, Oracle, PostgreSQL, SQLite, Redis, MongoDB, and Elasticsearch. They are all excellent, but they also have their own strengths in doing things. So, how are they used in the Charging Management Platform System?

Why use MySQL?

MySQL is a type of relational database—it’s open-source, easy to use, and pretty reliable. It works really well when you need to read data a lot. That’s why it’s good for storing basic info in charging pile systems. I will store basic information in MySQL, like region, city, charging station, charging pile, member information, charging records, etc. This information has a well-defined structure and needs to be read frequently, making MySQL suitable.

MySQL overall architecture

Why use Redis?

Redis is a database characterized by its open-source, nature and high-performance, in-memory database. Because data is mainly stored in memory, its read and write speeds are very fast. So it’s great for caching in charging pile systems. During the connection process of charging piles, the charging pile information needs to be checked and used a lot. Therefore, we put that connection-related info into Redis, the connection information required during the connection process, instead of fetching it from MySQL every time. This significantly increases the system’s maximum number of charging pile connections, and it takes some pressure off the server.

Redis is an in-memory database

Why use MongoDB?

MongoDB is a document-oriented database characterized by its open-source nature. It’s good because it can handle lots of writes quickly, and you can change the data’s format easily. Due to its high write throughput and dynamically changing fields, it is suitable for storing charging pile interaction logs in the charging pile management system. We store the communication logs between the charging piles and the system in a MongoDB. Since these logs are mostly written (and only looked up when we need to check something), MongoDB works really well here.

MongoDB version 1.6 introdu

Update cookies preferences

Get a Quick Quote!

x

    Get a Quick Quote!

    x