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

Table space storage capacity estimation method and device, equipment and medium

A storage capacity and table space technology, applied in database indexing, special data processing applications, structured data retrieval, etc., can solve the problem of unknown loading data capacity, save a lot of time and improve estimation efficiency

Pending Publication Date: 2022-06-03
AGRICULTURAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When loading data from the upstream system to the big data platform, the capacity of the data to be loaded cannot be directly obtained from the upstream system. Since the capacity of the loaded data is unknown, there are certain risks when importing data

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
  • Table space storage capacity estimation method and device, equipment and medium
  • Table space storage capacity estimation method and device, equipment and medium
  • Table space storage capacity estimation method and device, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

[0048] The present application provides a method for estimating the storage capacity of a table space. Next, the method for estimating the storage capacity of a table space provided by the present application will be introduced in detail through the following embodiments.

[0049] see figure 1 , showing a schematic flowchart of a table space storage capacity estimation method provided by an embodiment of the present application, where th...

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 provides a table space storage capacity estimation method and device, equipment and a medium, and the method comprises the steps: creating a temporary table in a target database according to a table structure of a source database table where to-be-loaded data is located, and randomly loading sample data to the temporary table from the source database table; calculating table space storage capacity occupied by the sample data in the temporary table, and calculating the quantity of the sample data; according to the table space storage capacity occupied by the sample data in the temporary table and the number of the sample data, determining the attribute value of the sample data as the attribute value of the to-be-loaded data; estimating the quantity of the to-be-loaded data according to the sample data to obtain a quantity estimation value of the to-be-loaded data; and according to the attribute value of the to-be-loaded data and the number estimation value of the to-be-loaded data, calculating a table space storage capacity estimation value occupied by the to-be-loaded data in the source database table. Therefore, the table space storage capacity estimation value occupied by the to-be-loaded data in the source database table can be calculated.

Description

technical field [0001] The present application relates to the technical field of data storage, and in particular, to a method, apparatus, device and medium for estimating storage capacity of a table space. Background technique [0002] In recent years, with the rapid development of China's emergency, the banking industry has also expanded rapidly. The banking business is becoming more and more extensive, the number of customers is increasing, and the transaction system is becoming more and more complex. The data accumulated by commercial banks has also increased exponentially. The collection, cleaning, mining, sorting and reporting of these massive data have brought great challenges to traditional banks in storing and utilizing these massive data. For example, in the application of regulatory reporting, the massive amount of reporting data involved needs to be loaded from the upstream source system to the downstream big data platform, and then the data of the big data platf...

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/22
CPCG06F16/2282
Inventor 冯耀武俱青段亚峰
Owner AGRICULTURAL BANK OF CHINA