Supercharge Your Innovation With Domain-Expert AI Agents!

Method and device for database splitting

A database and data table technology, applied in the database field, can solve the problems of occupying system resources, unintuitive data allocation, time-consuming, etc., and achieve the effect of improving query efficiency

Active Publication Date: 2018-11-16
TAIKANG LIFE INSURANCE CO LTD +1
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this kind of method usually needs to use the hash value model to calculate each time, which is time-consuming and takes up system resources. Moreover, the data distribution after calculation is not intuitive, and the user cannot pre-judge the exact location of the data after redistribution. It must be split in the whole set After the program is completed, it will be known through the system display

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
  • Method and device for database splitting
  • Method and device for database splitting
  • Method and device for database splitting

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] figure 1 is a flow chart of a method for splitting a database according to an exemplary embodiment, and this embodiment is applicable to splitting a data table in a database into at least two databases, such as figure 1 As shown, the method for database splitting described in this embodiment includes:

[0039] In step S110, the preset position in the name of the data table to be allocated in the database is marked with an identifier of a sort relationship.

[0040] In step S120, the data table to be allocated is allocated to at least two sub-databases, wherein the sub-database where the allocated data table is located is determined according to the identifier of the sort relationship in the data table name.

[0041] Based on the above, the technical solution of the present disclosure can pre-judge the exact location of the split data, and improve the query efficiency after the split of the database.

Embodiment 2

[0043] figure 2 is a flow chart of a database splitting method shown according to an exemplary embodiment, such as figure 2 As shown, the method for database splitting described in this embodiment includes:

[0044] In step S210, the preset position in the name of the data table to be allocated in the database is marked with an identifier of a sorting relationship. Among them, the "preset position" can be set according to the needs. For example, for the data table name "ABC**", you can set "**" as the default position of the identifier, such as "ABC45", "ABC64", etc. Both are data table names. The preset position in this embodiment not only refers to the Arabic numerals in the penultimate and penultimate digits of the data table name, if the number of data tables is large, it may also be represented by three or more sorting numbers , and the sorting number can also be in other positions of the data table name, such as the first two or the first three or even the first few...

Embodiment 3

[0063] Figure 4 is a schematic diagram of a database splitting device according to an exemplary embodiment, such as Figure 4 As shown, the apparatus 1000 includes a name identification unit 310 and a data table allocation unit 320 .

[0064] The name identifying unit 310 is used to mark the preset position in the name of the data table to be allocated in the database with an identifier of sorting relationship. The identifiers of the sorting relationship in this embodiment include sequential numbers, or sequential uppercase letters, or sequential lowercase letters, or a combination of at least two of sequential numbers, uppercase letters, and lowercase letters. The data table allocating unit 320 is used for allocating the data table to be allocated to at least two sub-databases, wherein the sub-database where the allocated data table is located is determined according to the identifier of the sort relationship in the data table name.

[0065] Wherein the data table allocati...

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 relates to a database splitting method and device. The method includes the steps that preset positions in the names of data tables to be distributed in a database are identified with identifiers of a sorting relation; the data tables to be distributed are distributed into at least two sub-databases so that the sub-databases where the distributed data tables are located can be determined according to the identifiers of the sorting relation in the names of the data tables. By means of the technical scheme, accurate positions after data splitting can be judged in advance, and thus the querying efficiency after database splitting can be improved.

Description

technical field [0001] The present disclosure relates to the field of databases, in particular to a database splitting method and device. Background technique [0002] With the promotion of distributed layout and management mode, database splitting and integration are becoming more and more common. The basic idea of ​​database splitting is to split a database into multiple data parts, and each data part is stored in a different database on, thereby alleviating the performance problem of a single database. [0003] For enterprise-level databases with a huge amount of data, the requirements for splitting are very high. It is necessary to ensure scientific splitting to avoid duplication or data loss, and to ensure that subsequent queries are convenient and fast. [0004] The method provided by the related technology is to split the database by taking modulus of the hash value. However, this kind of method usually needs to use the hash value model to calculate each time, which...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/21G06F16/2282
Inventor 潘高峰
Owner TAIKANG LIFE INSURANCE CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com