Fragmentation database access method and database system

An access method and database technology, applied in database distribution/replication, electronic digital data processing, structured data retrieval, etc., can solve problems such as inapplicability to multi-database systems, and achieve the effect of ensuring correctness and improving efficiency

Active Publication Date: 2014-06-11
厦门见福连锁管理有限公司
View PDF7 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved by the present invention is to overcome the defect that the Mybatis system in the prior art is not suitable for the multi-database system of the sharding framework, provide a method for accessing the fragmented database and its database system, and utilize the existing Mybatis and Spring framework , realize the operation of the sharding database through the routing strategy

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Fragmentation database access method and database system
  • Fragmentation database access method and database system
  • Fragmentation database access method and database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] The present invention is further illustrated below by means of examples, but the present invention is not limited to the scope of the examples.

[0057] The database system of this embodiment adopts Mybatis and Spring framework to realize the operation on the sharding database, that is, to realize the configurability of database access. It is convenient to configure the database access routing strategy through the configuration file. And it makes the development of database applications transparent. In addition, the problem that the efficiency of data access is likely to decrease with the increase of the database is suppressed. And ensure the correctness of data access. That is, multi-database commit or multi-database rollback is implemented in multi-database transaction operations to ensure data consistency and correctness. SQL operations such as summation, counting, query maximum value, query minimum value, sorting, paging, etc. of the multi-database can be used no...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a fragmentation database access method and a database system. The fragmentation database access method is used for frameworks of Mybatis and Spring and includes the following steps that 1 databases to be accessed are located through a Spring configuration file based on a database affair; 2 an access thread is built for each database to be accessed; 3 a database operation interface of the Mybatis operates the databases to be accessed and correlated to the access threads through the access threads, collects fed back data of the access threads and generates an execution result; 4 an affair management interface of the Spring detects whether the database affair is executed successfully based on the execution result of the database operation interface and executes corresponding submitting and rolling back. A database system using the fragmentation database access method is further provided. By means of the method and the system, the existing frameworks are utilized to achieve paging database operation through a routing strategy.

Description

technical field [0001] The invention relates to a sliced ​​database access method and a database system, in particular to a sliced ​​database access method and a database system suitable for Mybatis and Spring frameworks. Background technique [0002] Database expansion is an eternal topic. For traditional relational databases, the method of vertical expansion (ScaleUp) is adopted, that is, to buy better machines and add more resources to achieve better performance (such as hardware upgrades, faster and more CPUs (central processing units) , more memory, more and larger disks, etc.). Relational databases have dominated the traditional enterprise application environment for nearly thirty years through the ScaleUp approach. However, with the surge in data volume in recent years, especially the emergence of the cloud computing model, this expansion mode is not suitable for some applications. At this time, a horizontal expansion (ScaleOut) mode appears, and sharding is one of ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/27
Inventor 郭清胡迪潘明国
Owner 厦门见福连锁管理有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap