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

Relational database data management method and device and electronic equipment

A data management and database technology, applied in the database field, can solve problems such as high consumption and affecting normal business, and achieve the effects of improving efficiency, reducing hardware resource pressure, and reducing computing efficiency

Pending Publication Date: 2022-04-29
北京自如信息科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Such a large amount of data consumes a lot of resources such as IO, CPU, and memory of the database every time the data is called from the form for analysis and calculation, which affects normal business

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
  • Relational database data management method and device and electronic equipment
  • Relational database data management method and device and electronic equipment
  • Relational database data management method and device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] 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 accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments It is some embodiments of the present invention, but not all of them. Based on the implementation manners in the present invention, all other implementation manners obtained by those skilled in the art without creative efforts fall within the protection scope of the present invention.

[0024] see figure 1 and figure 2 , in one embodiment, a relational database data management method specifically includes the following steps:

[0025] Step S101: Obtain current data in the main table of the target relational database.

[0026] Step S102: File the current data into several sub-tables based on the current data type...

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 relational database data management method and device and electronic equipment. The method comprises the steps of obtaining current data in a main table of a target relational database; and based on the current data type of the current data, filing the current data into a plurality of sub-tables. According to the technical scheme provided by the invention, the data in the relational database form is archived according to different data categories, and different categories of data are migrated into different sub-tables, so that the data in the main table cannot be overstocked along with the continuous increase of time based on an archiving and cleaning strategy. According to the technical scheme, when the data is read and analyzed, the data can be read and analyzed in all the data tables in a classified mode, searching and retrieval of the whole data volume in the main table are not needed, the data analysis efficiency of the database is greatly improved, the hardware resource pressure of the database is reduced, and the occupancy rate of the hardware resources of the database is reduced when the data is called.

Description

technical field [0001] The invention relates to the field of databases, in particular to a relational database data management method, device and electronic equipment. Background technique [0002] At present, in order to facilitate data management, relational databases are widely used. The data in the database is stored in the form of forms, but there are often more and more data due to historical reasons. For example, the registered users of a certain software are constantly changing to generate new changed data. In the credit assessment scenario of payment software, every time a user fulfills a contract, a new piece of performance data will be generated for subsequent credit score assessment, which will increase the amount of data in the form at a high speed. Usually, this part of data is called dynamic data. . Such a large amount of data consumes a lot of resources such as IO, CPU, and memory of the database every time the data is called from the form for analysis and c...

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/21G06F16/22G06F16/23G06F16/28
CPCG06F16/214G06F16/215G06F16/2282G06F16/2365G06F16/284
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