Database-based dynamic storage extension method
A technology of data expansion and expansion method, which is applied in the direction of database indexing, database update, electronic digital data processing, etc., which can solve the problems of software modification and long cost, and achieve the effect of meeting the demand for increased storage
Active Publication Date: 2020-06-05
杭州太美星程医药科技有限公司
View PDF4 Cites 4 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0006] First, it is necessary to modify the schema and code of the database at the same time. This operation will inevitably increase the instability of the system, especially for occasions that require frequent processing;
[0007] Second, the software needs to be modified and retested;
[0008] To sum up, the traditional solution will take a long time to deliver the software system, and the software system needs to be modified, re-deployed and installed
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
[0079] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following briefly introduces the drawings that need to be used in the description of the embodiments. Obviously, the accompanying drawings in the following description are only some examples or embodiments of the present application, and those skilled in the art can also apply the present application to other similar scenarios. Unless otherwise apparent from context or otherwise indicated, like reference numerals in the figures represent like structures or operations.
[0080] As indicated in this application and claims, the terms "a", "an", "an" and / or "the" do not refer to the singular and may include the plural unless the context clearly indicates an exception. Generally speaking, the terms "comprising" and "comprising" only suggest the inclusion of clearly identified steps and elements, and these steps and elements do not constitute an exclusive list, and ...
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 provides a database-based dynamic storage extension method, which comprises the following steps of: constructing an extension table definition table, an extension storage field definition table and an extension field data storage table, and waiting for data extension operation; sending a data extension operation request to an original table in the extension table definition table; intercepting the data extension request; analyzing the data extension operation statement, checking whether an extension field exists in the extension table definition table or not, and directly writingoriginal data into an original table if the extension field does not exist in the extension table definition table; if the extension field is contained in the extension storage field definition table, firstly finding defined extension field information from the extension storage field definition table; constructing a statement for performing data extension operation on the extension field data storage table, and executing the statement; writing the data of the original table into the original table, ending the data expansion operation, and waiting for the next operation. According to the method and the device, the requirement of increasing storage can be met under the condition of not redeveloping and deploying.
Description
technical field [0001] The invention mainly relates to a storage expansion method, in particular to a database-based dynamic storage expansion method. Background technique [0002] In a software system based on relational database storage, data is stored through data tables. The data tables of relational databases need to be defined in advance, and then operations such as adding, deleting, modifying, and querying data tables are performed. When the demand side puts forward the need to increase the storage field, [0003] If you use a relational database, in order to meet the needs of the demand side to increase storage, the usual practice is to first add database fields, then modify the software code, and then deploy and deliver. [0004] If you use a non-relational database, it will be difficult to ensure transactional consistency. [0005] The disadvantages of traditional solutions include the following three aspects: [0006] First, it is necessary to modify the schema...
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/22G06F16/23G06F16/242
CPCG06F16/2282G06F16/235G06F16/2433
Inventor 杨涛陈伟绩
Owner 杭州太美星程医药科技有限公司