Method and device for accessing database

Abstract

The invention provides a method and a device for accessing a database. The method specifically includes: presetting a sharding identification generating rule; receiving a database write access request which carries to-be-written data; according the database write access request, dynamically acquiring a currently available database and database list information in the database, and acquiring a corresponding library index and a corresponding list index; according to the sharding identification generating rule, splicing the library index and the list index together with static positions to acquire a sharding identification corresponding to the database write access request; according to the sharding identification generating rule, routing the library index and the list index in the sharding identification corresponding to the database write access request; writing the to-be-written data into a data list in a database corresponding to a routing result. By the method and the device, convenience in database maintenance can be improved, and physical resources of a database system can be saved.

Description

technical field [0001] The present application relates to the field of database technology, in particular to a method and device for accessing a database. Background technique [0002] At present, with the development of society, a large amount of data in the application system needs to be stored, and a certain data access method is used to process the stored data according to the needs of different users. The database is a technology that meets this demand, and it is simple To put it bluntly, a database is a collection of data stored in a way that can be persisted and manipulated. [0003] When the amount of data to be stored reaches a certain level (for example: hundreds of millions of levels), using a single database for data storage management will cause problems such as capacity bottlenecks and performance bottlenecks, which will affect the improvement of application system processing capabilities, thereby affecting faster business. At the same time, a single database ...

AI Technical Summary

Problems solved by technology

After the sub-database and table-splitting rules are modified, all the data with the penultimate digits of the user IDs in the original A and B databases with 6, 7, 8, and 9 must be migrated to the C database, otherwise the new sub-database and table rules will be used Some data in the old database will be unreadable; and the data migration will undoubtedly increase the difficulty of database maintenance and consume a lot of CPU resources or memory resources

Images