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

A data table import method, data manager and server

A data manager and data table technology, applied in the field of data processing, can solve problems such as low resource utilization and high pressure on the data manager, and achieve the effects of reducing calculation time, reducing data volume, and improving import speed

Inactive Publication Date: 2018-10-30
赵修文
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0015] The present invention provides a method for importing a data table, a data manager and a server, which are used to solve the problem of excessive pressure on the existing data manager and low resource utilization in the process of importing a data table into a distributed database in the prior art. low technical issues

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
  • A data table import method, data manager and server
  • A data table import method, data manager and server
  • A data table import method, data manager and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0060] In order to solve the technical problems of excessive pressure on the data manager and low resource utilization in the process of importing the data table into the distributed database in the prior art, the embodiment of the present invention proposes a data table Import method, data manager and server.

[0061] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0062] The term "and / or" in this a...

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

Provided are a data table importing method, data manager and server, the method comprising: a data manager reads the data of a first data table with the import order number set to 1 in M data tables to be imported, divides the data of the first data table into N parts according to the N servers in a distributed database, and transmits the N parts of data to the N servers respectively; according to the import order number, the data manager sequentially performs the following steps at least once on the i-th data table in the M data tables to be imported, i being an integer ranging from 2 to M: the data manager reads at least some of the foreign keys of the i-th data table, and transmits the at least some of the foreign keys to the N servers; the data manager receives N processing results obtained after the N servers connect the at least some of the foreign keys to the primary key of the (i-1)-th data table; and the data manager respectively transmits to the N servers the data corresponding to the N processing results.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a method for importing a data table, a data manager and a server. Background technique [0002] With the generation of large amounts of data in modern life and the development of science and technology, distributed databases have been widely used in various fields due to their advantages of being able to efficiently process large amounts of data. [0003] A distributed database may include one or more clients (Client) and multiple servers (Mserver), wherein the client is responsible for interacting with users, such as receiving user queries, modifying or importing instructions, etc., and the server is responsible for processing imports to The data in the database, such as storing and modifying the relevant information of the tables in the database, etc., in order to easily import the data into the distributed database, usually use the Data Manager (Data Manager), in practical 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
CPCG06F16/278G06F16/258
Inventor 黄坚坚王玉虎
Owner 赵修文
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

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

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