Unlock instant, AI-driven research and patent intelligence for your innovation.

Data processing method and system applied to database

A data processing and database technology, applied in the field of data processing, can solve problems such as low efficiency, long online transaction time, and database performance degradation, and achieve the effect of reducing centralized distribution

Active Publication Date: 2016-08-24
CHINA CONSTRUCTION BANK
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method has the following disadvantages: it only calculates the database for data storage, and when the database is accessed too intensively, it is easy to cause database performance degradation; when some data needs to be migrated to other databases, only a single record can be exported, and then imported to In other databases, this method is inefficient, resulting in long online transaction time and affecting all data access related to the database, with a wide range of influence

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
  • Data processing method and system applied to database
  • Data processing method and system applied to database
  • Data processing method and system applied to database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] In order to facilitate the understanding of various aspects, features and advantages of the technical solutions of the present invention, the present invention will be specifically described below in conjunction with the accompanying drawings. It should be understood that the various implementations described below are only for illustration, rather than limiting the protection scope of the present invention.

[0020] figure 1 It is a schematic flowchart of a data processing method applied to a database according to an embodiment of the present invention. refer to figure 1 , the method includes:

[0021] 10: Determine the mapping relationship between the primary key, the data table number, and the database number according to the preset mapping strategy. In other words, it is to determine the mapping relationship between the primary key, data table, and database.

[0022] 12: According to the mapping relationship between the primary key, the data table number and the...

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 data processing method and system applied to a database. The method comprises the following steps of determining a mapping relation among a primary key, a data table number and a database number according to a preset mapping strategy; and storing data corresponding to the primary key into a data table of the corresponding database according to the mapping relation among the primary key, the data table number and the database number. By adopting the method and the system, the data can be uniformly distributed in the database, and the method and the system support quick data migration processing.

Description

technical field [0001] The present invention relates to the field of data processing, and more specifically, to a data processing method and system applied to a database. Background technique [0002] In order to support access scenarios with high concurrency and a large amount of data, existing technologies usually adopt database sub-database strategies to improve the concurrent processing capabilities of applications. However, sub-database application data will involve the issue of how data is distributed and data migration. At present, there is no good method that can ensure the uniform distribution of data and support the rapid migration of data (for example, hot data) at the same time. [0003] For example, the existing database sub-database method is to calculate which database the records / data should be distributed in through the consistent hash algorithm, and then store them in the database. This method has the following disadvantages: it only calculates the databa...

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
IPC IPC(8): G06F17/30
Inventor 邢磊舒展聂砂贾国琛杨宇鹏
Owner CHINA CONSTRUCTION BANK
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