Data partitioning method for distributed parallel database system

A data partitioning and database technology, applied in the field of distributed parallel database systems, can solve problems such as increasing query response time, affecting query efficiency, and consuming network bandwidth, so as to reduce query response time, improve query efficiency, and avoid network transmission consumption. when the effect

Active Publication Date: 2013-07-17
BORQS BEIJING +2
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This kind of data transfer between nodes during query is also called dynamic repartitioning (Dynamic Repartitioning), which will not only consume network bandwidth, but also generate time-consuming transmission, greatly increasing query response time and affecting query efficiency.

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 partitioning method for distributed parallel database system
  • Data partitioning method for distributed parallel database system
  • Data partitioning method for distributed parallel database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The preferred embodiments of the present invention will be described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described here are only used to illustrate and explain the present invention, and are not intended to limit the present invention.

[0025] When building a database system or a data warehouse based on a distributed database, the actual fact data and the data used to describe attributes are generally separated by different tables, and the actual fact data is stored in a class called fact Table (Fact table), and data describing attributes from different perspectives are placed in different dimension tables (Dimension table). For example, a Sales database or data warehouse can be designed like this. Each sales record should include the product sold, the customer sold, the supplier of the product, the time of sale, the quantity sold, and the income obtained. For specific digital data such as sales qu...

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

A data partitioning method for a distributed parallel database system, comprising creating fact tables and dimension tables according to a constructed distributed parallel database system, inserting records of the dimension tables and the fact tables into nodes according to partitioning rules, replicating the records of dimension tables into the nodes that include fact tables, performing data deletion, and performing data update.

Description

technical field [0001] The invention relates to a distributed parallel database system, in particular to a data partition method of the distributed parallel database system. Background technique [0002] Storing data in databases is a common method of data management, especially in relational databases. We can choose a mature database management system (DBMS: Database Management System) according to the data needs to be managed, and use a standard data definition language (such as SQL DDL) to define data tables (Table) or relations (Relation), data structures , index, primary key (Primary Key) and foreign key (Foreign Key) and other information of the database data management program (Database Schema), deploy the database system. According to the data manipulation language (such as SQL DML) provided by the DBMS, the application program can perform data manipulation, such as inserting, querying, updating, importing and exporting, etc. [0003] In many current industry appli...

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
CPCG06F17/30584G06F16/278
Inventor 张卫平张松波刘为怀
Owner BORQS BEIJING
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