Galvanalyser: A Battery Test Database

Adam Lewis-Douglas,Luke Pitt,David A. Howey

DOI: https://doi.org/10.48550/arXiv.2010.14959

2020-10-28

Abstract:Performance and lifetime testing of batteries requires considerable effort and expensive specialist equipment. A wide range of potentiostats and battery testers are available on the market, but there is no standardisation of data exchange and data storage between them. To address this, we present Galvanalyser, a battery test database developed to manage the growing challenges of collating, managing and accessing data produced by multiple different battery testers. Collation is managed by a client-side application, the `Harvester', which pushes new data up to a PostgreSQL database on a server. Data access is possible in two ways: firstly, a web application allows data to be searched and viewed in a browser, with the option to plot data; secondly, a Python application programming interface (API) can connect directly to the database and pull requested data sets into Python. We hope to make Galvanalyser openly available soon. If you wish to test the system, please contact us for early access.

Systems and Control,Databases

What problem does this paper attempt to address?

This paper attempts to solve several key problems in battery test data management and storage:

1. **Data Fragmentation**: There are currently many different brands of battery test equipment on the market (such as MACCOR, BioLogic, etc.), and each device has its own proprietary control and data management software. The data generated by these devices is usually stored on local computers in various formats, resulting in scattered data that is difficult to integrate.

2. **Data Security and Integrity in Long - term Experiments**: Battery cycle test experiments may last for weeks, months or even years. During this period, hardware or software failures may lead to data loss or damage. Especially during long - running processes, locally - stored data is more vulnerable.

3. **Convenience of Data Access**: Due to the dispersion of devices and data storage, researchers face challenges when accessing and comparing experimental data from different systems. In addition, physical access to battery test devices may also be restricted, and there are security and permission management issues for remote access.

To solve these problems, the author proposes a battery test database system named **Galvanalyser**. The main functions of this system include:

- **Data Collection and Parsing**: Automatically scan and upload new data from different battery test devices to the central PostgreSQL database through the client - side application "Harvester".

- **Data Storage and Backup**: All data is stored in a centralized PostgreSQL database in a standardized format to ensure data security and easy querying, and support protection measures such as RAID systems and off - site backups.

- **Data Access and Visualization**: Provide two ways to access data:
- Search, view and plot data in the browser through a web application;
- Use the Python API to directly extract the required data sets from the database for complex analysis.

In short, Galvanalyser aims to simplify the management of multi - source battery test data, improve data security and accessibility, and thus accelerate battery design and development work.