A Dynamic Storage Expansion Method Based on Database
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: 2021-06-22
杭州太美星程医药科技有限公司
View PDF4 Cites 0 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 present invention provides a dynamic storage extension method based on a database, comprising: constructing an extension table definition table, an extension storage field definition table and an extension field data storage table, waiting for data extension operation; The table sends out a data extension operation request; intercepts the data extension request; analyzes the data extension operation statement, checks whether there is an extension field in the extension table definition table, and if there is no extension field, the original data is directly written into the original table; if the extension field is included, at first find the defined extension field information from the extension storage field definition table; construct a statement for performing data extension operation to the extension field data storage table, and execute; the original table The data is written into the original table, the data expansion operation ends, and the next operation is awaited. The present invention can meet the demand for increased storage without redevelopment and deployment.
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 Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/23G06F16/242
CPCG06F16/2282G06F16/235G06F16/2433
Inventor 杨涛陈伟绩
Owner 杭州太美星程医药科技有限公司