Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Logic data partition method and system

A data logic and data sharding technology, applied in the database field, can solve problems such as inability to realize effective data sharding, achieve non-blocking, high-performance, distributed, high scalability, overcome limitations, and have strong adaptability

Inactive Publication Date: 2014-06-04
CHINA MOBILE GRP BEIJING
View PDF8 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] In order to solve the technical problem that effective data fragmentation cannot be realized in the prior art, the present invention proposes a method and system for data logical partitioning, which is suitable for various large-scale RAC data centers, can realize fast distributed computing, and data fragmentation is flexible

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
  • Logic data partition method and system
  • Logic data partition method and system
  • Logic data partition method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] Specific embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0021] figure 1 It is a schematic structural diagram of the data logical partition system in Embodiment 1 of the present invention. Such as figure 1 As shown, the data logical partition system is suitable for the RAC database of the telecom CRM system, including the client 101 , the application node 102 and the database node 103 .

[0022] The client is connected to the application node, and the application node is connected to the database node.

[0023] Among them, the client is used to obtain the application nodes to be accessed through the key fields passed in from the front end at the application access layer.

[0024] The application node is used to set the customer number as the unique identifier for the business data, use the customer number as the key value, and use not less than one stage of elimination and remainder hash algorith...

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 logic data partition method and system which are suitable for a RAC data base of a telecom CRM system. The method comprises the steps that a customer number is set for business data and serves as the only identification, the customer number is used as a key value and elimination and remainder Hash algorithm no less than one period is adopted to conduct data partition on the business data. The technical scheme of the logic data partition method and system is strong in adaptability, can adapt to all kinds of large-scale RAC data centers, and because multi-stage Hash logic module value partition and partition route visiting are adopted, non-blocking, high-performance and distributed high-expansivity can be achieved and the defect of a data partition table is overcome.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and system for data logical partitioning. Background technique [0002] Real-time application clusters (Real Application Clusters, RAC) multi-node distributed cloud computing solutions have become a necessary technical means for data centers in the telecommunications industry. RAC increases the overall processing capacity of the database by adding database instance nodes, and at the same time overcomes the host (instance) single point of failure. However, the overall capability of RAC does not increase linearly with the increase in the number of database instance nodes. Because of the consistent communication between nodes, memory merging will consume certain resources and limit the improvement of the overall capability. Reduce capacity. At present, the customer relationship management system (Customer Relationship Management, CRM) of provincial-level telecommunicati...

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/2379
Inventor 崔希宁杨海威张雨晴姚勇
Owner CHINA MOBILE GRP BEIJING
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products