Research on Multi Field Enumeration Algorithm in Distributed Database

Research on Multi Field Enumeration Algorithm in Distributed Database

연구 분야: Databases

학회: 2025 IEEE 6th International Seminar on Artificial Intelligence, Networking and Information Technology (AINIT)

Most mainstream distributed database middleware only supports single-field sharding, which cannot meet multi-field sharding needs. To address this and eliminate the problems of high complexity, high overhead and unfavorable maintenance of multi-field sharding, this paper proposes a strategy to combine multiple fields into a composite field and designs a multi-field enumeration sharding algorithm. Using Docker containers, sharding servers are set up, and after updating the Mycat configuration files and starting the service, data is inserted into the MySQL database. Results show that this algorithm effectively shards data based on user-selected composite fields, distributing data across multiple database servers and resolving single server performance bottlenecks.