A method and device for processing data tables
A data table and data technology, applied in the Internet field, can solve problems such as increasing data update frequency and increasing server load, and achieve the effect of reducing costs
Active Publication Date: 2022-04-26
南京星云数字技术有限公司
View PDF5 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] However, due to the increase in the number of tables, the database needs to track the data in the table and refresh it dynamically. Compared with the traditional single-table solution, the data update frequency is greatly increased, and the database needs to occupy a lot of computing and storage resources of the server to refresh the database frequently. table, and the maintenance process needs to be re-executed after each refresh, resulting in a synchronous increase in the frequency of the maintenance process, thus greatly increasing the load on the server
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
[0029] In order to enable those skilled in the art to better understand the technical solutions of the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. Hereinafter, embodiments of the present invention will be described in detail, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present invention and should not be construed as limiting the present invention. Those skilled in the art will understand that unless otherwise stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the word "comprising" used in the description of the present invention refe...
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 embodiment of the invention discloses a method and device for processing a data table, relates to the technical field of the Internet, and can reduce the running load of a server. The invention includes: importing the data to be stored into a database instance, and splitting at least two sub-tables in the database instance according to the sub-table rules corresponding to the current time period; generating the primary key ID of the obtained sub-table, and importing the sub-table Table index table, the primary key ID includes: information used to indicate the time dimension when the data is stored; when a query request is received, the primary key ID is queried and the time period corresponding to the sub-table is determined, and according to the determined time period The sub-table rules access data. The invention is applicable to the data sub-table management of the relational database.
Description
technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and device for processing data tables. Background technique [0002] With the development of Internet technology, the transaction volume of online payment business has increased dramatically year by year. At present, a large-scale relational database is used to support the development of online payment business. [0003] In a relational database, after receiving new data, maintenance processes such as re-splitting, hashing, and data sorting need to be performed on the updated data according to established rules. Since the amount of data in a traditional single table in a relational database has reached the limit of practical application, if it continues to increase, it will encounter performance bottlenecks. Therefore, there is also a scheme to split the existing data into multiple sub-tables in proportion. In this way, performance bottlenecks can be addressed by i...
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 Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/28
CPCG06F16/2282G06F16/284
Inventor 卢启祯章程罗群
Owner 南京星云数字技术有限公司