Strategy for customizing table division according to service code based on Spring and Mybatis

By adopting a custom table sub-data by business code on Spring and Mybatis platforms, the problem that the existing technology cannot effectively process associated table data is solved, dynamic table adjustment and database sub-data support are implemented, and data operation performance is improved.

CN119669233AInactive Publication Date: 2025-03-21QUANTONG JINXIN HLDG (GUANGDONG) CO LTD
6 Cites 0 Cited by

Patent Information

Application Number
CN202510083421.3
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-01-20
Publication Date
2025-03-21
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

When processing associated table data, the prior art cannot meet the requirements of pagination query, deletion and modification operations, and requires major changes to the original code.

Method used

Using Spring and Mybatis-based custom table subtable strategy based on business code, the CodeShardInterceptor table interceptor and code-shard-service table subtable services are used to dynamically adjust the data table situation and support the database.

Benefits of technology

It realizes customizing the subtable according to the business code, dynamically adjusting the data subtable situation, locking business code-related data, supporting database division, improving data query and operation performance, and more effectively utilizing the database index and speeding up data retrieval.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The invention discloses a Spring and Mybatis-based self-defined table division strategy according to a service code, and relates to the technical field of relational number libraries, the strategy comprises a table division client and a table division server, the table division client comprises a CodeShard Aop table division section, a CodeShard Interceptor table division interceptor and a CodeTableShard table division context; and the sub-table server side comprises a code-hard-service sub-table service, and the sub-table server side comprises a code-hard-service sub-table service. According to the method, table division is carried out according to the service code, tables which are related to the code and need to be subjected to table division are uniformly partitioned, which sub-table the data exists can be self-defined, the table division condition of the data can be dynamically adjusted, the data related to the service code can be locked in the adjusting process, in addition, the database division condition is supported, the data are dispersed into a plurality of tables, and the table division efficiency is improved. The data volume of a single table is reduced, so that the data query and operation performance is improved, the index of the database can be more effectively utilized, the index efficiency is improved, and the data retrieval speed is increased.
Need to check novelty before this filing date? Find Prior Art