Automatic library division and table division method and device, equipment and storage medium
An automatic technology of sub-database and sub-table, which is applied in the field of data processing, can solve the problems of low efficiency of sub-database and sub-table, and achieve the effect of improving 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
[0005] In view of this, it is necessary to provide an automatic method, device, equipment and storage medium for sub-database sub-table, to solve the problem of low efficiency of sub-database sub-table in the prior art, and manual operation of sub-database and table is required
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0030] Preferred embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings, wherein the accompanying drawings constitute a part of the application and together with the embodiments of the present invention are used to explain the principle of the present invention and are not intended to limit the scope of the present invention.
[0031] In the description of the present application, "plurality" means two or more, unless otherwise specifically defined.
[0032] Reference herein to an "embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the present invention. The occurrences of this phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is understood explicitly and implicitly...
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
Login to View More Abstract
The invention relates to an automatic database division and table division method and device, equipment and a storage medium. The method comprises the steps of obtaining file data of all application systems in a database; analyzing the file data, and determining different attribute characteristics of the file data; based on different attribute characteristics and time fields of the file data, according to a preset rule, establishing a sub-library and sub-table script; and running the library and table division script, and performing library division and table division on the file data of all the application systems. According to the automatic library and table division method, device and equipment and the storage medium provided by the invention, all file data in the database are obtained, all file data are analyzed, different attribute characteristics of all file data are obtained, and the library and table division script is established, so that library division and table division of file data of all application systems are realized, and the file data of all application systems are subjected to library division and table division. Automatic database division and table division are achieved through the script, the database division and table division efficiency is improved, and the defect that database division and table division need to be manually operated is overcome.
Description
technical field [0001] The invention relates to the technical field of data processing, in particular to a method, device, equipment and storage medium for automatic database and table division. Background technique [0002] Sub-database sub-table is to solve the problem of database performance degradation due to excessive data volume. The original independent database is split into several databases, and the large data table is split into several data tables, so that a single database and a single data The amount of data in the table becomes smaller, so as to achieve the purpose of improving the performance of the database. [0003] At present, all application system data are stored in the same database under the same user, and various data are related to each other. [0004] The current method of sub-database and sub-table of application system data is extremely inconvenient to sort out and filter the massive data. If it is necessary to sub-database various tables accordi...
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
Login to View More IPC IPC(8): G06F16/21G06F16/22G06F9/448
CPCG06F16/217G06F16/2282G06F9/4482
Inventor 耿潇汤表贤吴清亮罗亲庆苏元座
Owner 海南同享数字科技有限公司