Abstract: This paper aims to further improve the data storage density and reduce the retrieval time of space weather data of the Meridian Project. The storage structure, row key structure and secondary index structure of data records were designed to improve the storage density, reduce the number of rows and indexes and avoid the overly dispersed storage of data records of the same source in a short period of time. The retrieval scheme suitable for querying scenarios of the data records was designed in order to reduce the data retrieval time. The experimental results show that the designed scheme can improve the data storage density in various scenarios. The time for obtaining data records is also greatly reduced, and it can meet the requirements of the design indicators for data storage and retrieval of the Meridian Project.