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

Database table splitting method and system, electronic equipment and storage medium

A database and subsystem technology, applied in the field of database processing, can solve problems such as low data search efficiency, achieve the effects of improving retrieval performance, avoiding IO contention, and small data volume

Pending Publication Date: 2021-02-09
WUHAN HONGXIN TECH DEV CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a database table splitting method, system, electronic equipment, and storage medium to solve the defect of low data search efficiency in the prior art and realize fast data search

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
  • Database table splitting method and system, electronic equipment and storage medium
  • Database table splitting method and system, electronic equipment and storage medium
  • Database table splitting method and system, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] 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.

[0039] see figure 1 , providing a method for splitting a database table, including: S1, searching for multiple attribute values ​​of each attribute in the basic database table according to a specified dimension; S2, performing a specified operation operation on multiple attribute values ​​of each attribute, Obtain the attribute value of each attr...

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 embodiment of the invention provides a database table splitting method and system, electronic equipment and a storage medium. The method comprises the following steps: searching a plurality of attribute values of each attribute in a basic database table according to a specified dimension; performing specified operation calculation on the plurality of attribute values of each attribute to obtain an attribute value of each attribute after the specified operation calculation; and storing the attribute value of each attribute after the specified operation operation into a specified dimension database table. According to the embodiment of the invention, the original basic database table is split into the database tables of each dimension according to different specified dimensions, and thedata volume in the database table of each dimension is smaller than that in the original database table, so that the searching speed and the searching efficiency are higher than those of searching data in one original database table, and meanwhile, the pressure of a server for storing each database table is also reduced, and the performance problem caused by overlarge data volume of a single tableis optimized.

Description

technical field [0001] The invention relates to the technical field of database processing, in particular to a database table splitting method, system, electronic equipment and storage medium. Background technique [0002] With the rapid development of software and big data technology, data collection, query, and statistics are becoming more and more frequent. The traditional data processing method is to collect data, insert into database tables, and then query and count according to the data fields. , the database server and background server will not have any pressure. When the amount of data reaches a certain level, for example, the amount of data of tens of millions and above, the query statistics of the database will become very slow and inefficient, which may seriously cause server downtime , and the data is concentrated in one or several tables, when the amount of data is large, the risk will be great, and it is easy to cause the database server to go down. [0003] ...

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): G06F16/22G06F16/2453G06F16/2458
CPCG06F16/2264G06F16/2282G06F16/2453G06F16/2462
Inventor 陈巍王黎
Owner WUHAN HONGXIN TECH DEV CO LTD
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