分布式数据库分片策略的优化与性能评估

针对大规模单表数据量造成的查询性能瓶颈,提出了一种数据分片优化方案,提升分布式数据库的查询效率。本研究比较了SpringBoot框架下的各种分片策略,并制定了性能对比测试方法,验证了不同分片策略对查询性能的影响。该方案可以为应对海量数据场景下的查询优化提供有益的参考。

zip
java_code.zip 预估大小:46个文件
folder
shardingjdbcten 文件夹
file
shardingjdbcten.iml 80B
file
pom.xml 8KB
folder
target 文件夹
folder
test-classes 文件夹
file
logback.xml 3KB
file
application-sharding-data-fragment.properties 3KB
file
application.yml 132B
file
application-origin.properties 289B
file
application-sharding-encrypt-databases.properties 1KB
file
application-sharding-master-slave.properties 1KB
file
application-sharding-ms-df.properties 4KB
folder
net 文件夹
folder
zhuisuyun 文件夹
folder
sharding 文件夹
folder
jdbc 文件夹
folder
test 文件夹
file
MyTest.class 5KB
folder
maven-status 文件夹
folder
maven-compiler-plugin 文件夹
folder
compile 文件夹
folder
default-compile 文件夹
file
inputFiles.lst 828B
file
createdFiles.lst 330B
folder
generated-test-sources 文件夹
folder
test-annotations 文件夹
folder
classes 文件夹
file
logback.xml 3KB
file
application-sharding-data-fragment.properties 3KB
file
application.yml 132B
file
application-origin.properties 289B
file
application-sharding-encrypt-databases.properties 1KB
file
application-sharding-master-slave.properties 1KB
file
application-sharding-ms-df.properties 4KB
folder
net 文件夹
folder
zhuisuyun 文件夹
folder
sharding 文件夹
folder
jdbc 文件夹
folder
core 文件夹
file
MyTableShardingAlgorithm.class 5KB
file
ShardingJdbcApplication.class 2KB
folder
mapper 文件夹
file
GoodsMapper.class 3KB
folder
service 文件夹
file
CsvService.class 3KB
file
GoodsService.class 4KB
folder
entity 文件夹
file
Goods.class 2KB
folder
generated-sources 文件夹
folder
annotations 文件夹
folder
src 文件夹
folder
test 文件夹
folder
java 文件夹
folder
net 文件夹
folder
zhuisuyun 文件夹
folder
sharding 文件夹
folder
jdbc 文件夹
folder
test 文件夹
file
MyTest.java 3KB
folder
main 文件夹
folder
java 文件夹
folder
net 文件夹
folder
zhuisuyun 文件夹
folder
sharding 文件夹
folder
jdbc 文件夹
folder
core 文件夹
file
MyTableShardingAlgorithm.java 5KB
folder
mapper 文件夹
file
GoodsMapper.java 3KB
folder
service 文件夹
file
CsvService.java 2KB
file
GoodsService.java 4KB
file
ShardingJdbcApplication.java 1KB
folder
entity 文件夹
file
Goods.java 1KB
folder
resources-dev 文件夹
file
logback.xml 3KB
file
application.yml 132B
file
application-origin.properties 289B
file
application-sharding-data-fragment_ten.properties 3KB
file
application-sharding-data-fragment_twenty.properties 5KB
file
application-sharding-data-fragment_hundred.properties 3KB
folder
.idea 文件夹
file
uiDesigner.xml 9KB
file
$PRODUCT_WORKSPACE_FILE$ 493B
file
misc.xml 517B
file
vcs.xml 183B
file
encodings.xml 172B
file
compiler.xml 536B
file
workspace.xml 14KB
file
.gitignore 38B
...
zip 文件大小:52.4KB