Abstract Multi-cultural integration is an inevitable path to enhance the inheritance and protection of the Central Plains culture and to innovate the teaching mode of vocal music in colleges and universities. In this paper, we constructed a university vocal music teaching database system based on distributed database, and used semi-connection algorithm to query and optimize the data related to the integration of Central Plains culture into vocal music teaching resources. In order to make up for the defects of the semi-connection algorithm when facing a large number of tuples, the semi-connection algorithm is improved by introducing the idea of symmetric homology to realize the massive data scheduling of the vocal music teaching resources database. For the college vocal teaching database constructed in this paper, the query optimization test and performance test are carried out, and the teaching practice application is carried out with the vocal teaching database. The results show that the query throughput rate of vocal music teaching resources reaches 3.18*103MB/s under Read-only load when the number of running rounds reaches 16 rounds, and when the number of concurrent users of the vocal music teaching database is 1000, the CPU occupancy rate and memory utilization rate are 1.37% and 1.06%, respectively. By integrating Zhongyuan culture into the vocal music teaching database, more than 70% of the students indicated that it could enhance their interest in learning about Zhongyuan culture. The use of technology to realize the integration of vocal music teaching and the culture of the Central Plains provides a new reference for the inheritance and protection of the culture of the Central Plains.