CN114443654B - Method and system for on-line modifying length of database table space data block - Google Patents
Method and system for on-line modifying length of database table space data block Download PDFInfo
- Publication number
- CN114443654B CN114443654B CN202210046141.1A CN202210046141A CN114443654B CN 114443654 B CN114443654 B CN 114443654B CN 202210046141 A CN202210046141 A CN 202210046141A CN 114443654 B CN114443654 B CN 114443654B
- Authority
- CN
- China
- Prior art keywords
- data block
- table space
- temporary
- original
- block
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 80
- 230000004048 modification Effects 0.000 claims description 12
- 238000012986 modification Methods 0.000 claims description 12
- 238000004886 process control Methods 0.000 claims description 4
- 238000005457 optimization Methods 0.000 abstract 1
- 230000000694 effects Effects 0.000 description 4
- FDWIKIIKBRJSHK-UHFFFAOYSA-N 2-(2-methyl-4-oxochromen-5-yl)acetic acid Chemical compound C1=CC=C2OC(C)=CC(=O)C2=C1CC(O)=O FDWIKIIKBRJSHK-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/235—Update request formulation
Abstract
The invention provides a method and a system for modifying the length of a data block in a database table space on line, wherein the method comprises the steps of creating a temporary table space according to the sum of the sizes of objects in an original table space, wherein the length of the data block in the temporary table space is different from the length of the data block in the original table space; acquiring an object data block of an original table space, moving the object data block, merging the object data block of the original table space if the temporary table space data block is bigger, and writing the merged object data block into the temporary table space data block; if the temporary table space data block is smaller, splitting the object data block of the original table space, and respectively writing the object data block into the temporary table space data block; and after the object processing to the original table space is completed, deleting the original table space, and modifying the name of the temporary table space into the name of the original table space. The invention provides a new choice for the database to adjust the performance of the database by changing the size of the data block, and is convenient for the optimization of the database.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a method and a system for modifying the length of a database table space data block on line.
Background
The data BLOCK length db_block_size is generally set to be a multiple of the operating system BLOCK, i.e., 2K,4K,8K,16K or 32K, as the minimum operation unit of the database, but its SIZE is generally affected by the use of the database. For online transactions, the characteristic is that the transaction amount is large, but the data amount of each transaction is small, so that the DB_BLOCK_SIZE is enough to set a small point, typically 4K or 8K, and the data read once is set to be too large is partly useless, and the read-write time of the database can be dragged, and unnecessary I/O operation is increased. For data warehouse and ERP applications, the data volume per transaction is large, so DB_BLOCK_SIZE is typically set to be relatively large, typically 8K,16K or 32K, and if DB_BLOCK_SIZE is small, the I/O times naturally increase and the consumption increases.
The DB BLOCK SIZE is somewhat larger than the index because the number of rows one DB BLOCK can read the index at a time is larger than DB BLOCK SIZE. For a record with a relatively large row, if one db_block is not placed on the next row, the database needs to be row-linked when reading the data, and the row-linking affects the reading performance. This can be avoided if DB BLOCK SIZE is a little larger.
A database may require the use of different sized data blocks due to different uses, but the impact of data block size on performance may not be considered when creating the database or tablespace, and the need to resize data blocks to improve performance may be realized only when performance is impacted by data block size, but it is cumbersome to resize data blocks for an already online production database. After a tablespace is created, its block size is no longer changed, and if the block size used by the objects (tables, indexes, etc.) therein is to be adjusted, it is necessary to create a tablespace that uses the particular data block size and then MOVE the objects in the tablespace to the new tablespace via the MOVE command. Alternatively, the data in the tablespace is derived, then the tablespace is deleted to reconstruct the tablespace, and then the data is returned to the tablespace. The two modes can cause the problem that objects under the table space cannot be accessed in the operation process, and the normal use of the database is affected.
Disclosure of Invention
The invention provides a method and a system for modifying the length of a data block in a database table space on line, which are used for solving the problem that the normal use of a database is affected by the conventional data block length adjustment mode.
In order to achieve the above purpose, the present invention adopts the following technical scheme:
the first aspect of the present invention provides a method for modifying the length of a data block in a database table space on line, the method comprising the steps of:
creating a temporary table space according to the sum of the sizes of the objects in the original table space, wherein the length of a data block in the temporary table space is different from the length of the data block in the original table space;
acquiring an object data block of an original table space, moving the object data block, merging the object data block of the original table space if the temporary table space data block is bigger, and writing the merged object data block into the temporary table space data block; if the temporary table space data block is smaller, splitting the object data block of the original table space, and respectively writing the object data block into the temporary table space data block; setting a read-write strategy for the surface space data block in the moving process;
repeating the previous step until the object of the original table space is processed, deleting the original table space, and modifying the name of the temporary table space into the name of the original table space.
Further, the method comprises the following steps:
and adding a processing process for modifying the length of the data block of the table space, and adding process parameters, wherein the process parameters are used for specifying the number of processes for modifying the data block of the simultaneous processing object.
Further, the specific processing procedure of the database in the read-write strategy for performing the read operation on the current object is as follows:
if the read data block is still in the original table space, reading according to the size of the original data block;
if the read data block is in the temporary table space, the temporary table space data block is smaller than the original table space data block, the data block corresponding to the original table space object is read, the data blocks are combined, and the length of the original table space data block is returned to the database;
if the read data block is in the temporary table space, the temporary table space data block is larger than the original table space data block, the data block corresponding to the original table space object is read, the data block is split, and the data block is returned to the database according to the length of the original table space data block.
Further, the specific processing procedure of the database in the read-write strategy for writing the current object is as follows:
if the data block to be written is in the original table space, writing is carried out according to the size of the original data block;
if the data block to be written is in the temporary table space, the temporary table space data block is larger than the original table space data block, and the data block to be written is not a new block, finding a combined data block corresponding to the data block to be written in the temporary table space, and updating the combined data block to complete writing; if the data block to be written is a new block, merging the new block and writing the new block into the temporary table space data block;
if the data block to be written is in the temporary table space, the temporary table space data block is smaller than the original table space data block, and the data block to be written is not a new block, finding a split data block corresponding to the data block to be written in the temporary table space, and updating the split data block to complete writing; if the data block to be written is a new block, the new block is split and written into temporary tablespace data blocks.
Further, the writing of the temporary tablespace data block further comprises: the data block header data is constructed for the temporary tablespace data block.
Further, the method includes calling a command for modifying the tablespace data block before creating the temporary tablespace.
Further, the data block length is one of 2K,4K,8K,16K or 32K.
A second aspect of the present invention provides a system for modifying a database tablespace data block length online, the system comprising:
a temporary table space creation unit that creates a temporary table space according to a sum of sizes of objects in the original table space, the length of a data block in the temporary table space being different from the length of the data block in the original table space;
an object moving unit for acquiring an object data block of the original table space, moving the object data block, merging the object data block of the original table space if the temporary table space data block becomes large, and writing the merged object data block into the temporary table space data block; if the temporary table space data block is smaller, splitting the object data block of the original table space, and respectively writing the object data block into the temporary table space data block; setting a read-write strategy for the surface space data block in the moving process;
and the table space replacing unit deletes the original table space after the object processing of the original table space is finished, and modifies the name of the temporary table space into the name of the original table space.
Further, the system also includes a process control unit for adding a processing process for modification of the tablespace data block length and adding a process parameter for specifying the number of processes for simultaneous processing of the object data block modification.
Further, the object moving unit also comprises a data read-write processing subunit, and the data read-write processing subunit is used for controlling the read-write operation of the data block by the database in the moving process of the data block.
The system for modifying the length of the database table space data block according to the second aspect of the present invention can implement the method according to the first aspect and the methods according to the implementations of the first aspect, and achieve the same effects.
The effects provided in the summary of the invention are merely effects of embodiments, not all effects of the invention, and one of the above technical solutions has the following advantages or beneficial effects:
the invention establishes the temporary table space based on the total size of the objects in the original table space, moves the objects from the original table space to the temporary table space, and sets the read-write strategy of the database in the moving process, so that the normal use of the objects is not affected in the whole moving process. In addition, the number of processes of the processing object is controlled through parameters, so that IO efficiency of object processing is controlled, and resource consumption is avoided. When the object data block is processed, the data block size change is realized through data block merging and splitting under the condition that the reading and writing of the data block are not affected. Through the method, the change of the size of the data block of the tablespace is finished on line, meanwhile, the situation that the object cannot be accessed due to the fact that the tablespace is rebuilt or the object tablespace is modified by a MOVE command is avoided through logic processing, the availability of a database is improved, the complexity of operation is reduced, the operation efficiency of changing the size of the data block of the tablespace is improved, and the data risk of batch operation of personnel is reduced. A new choice is provided for the database to adjust the performance of the database by changing the size of the data block, so that the database is convenient to optimize.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the description of the embodiments or the prior art will be briefly described below, and it will be obvious to those skilled in the art that other drawings can be obtained from these drawings without inventive effort.
FIG. 1 is a schematic flow chart of an embodiment of the method of the present invention;
FIG. 2 is a flow chart of one implementation of the method according to the present invention;
fig. 3 is a schematic diagram of an embodiment of the system of the present invention.
Detailed Description
In order to clearly illustrate the technical features of the present solution, the present invention will be described in detail below with reference to the following detailed description and the accompanying drawings. The following disclosure provides many different embodiments, or examples, for implementing different structures of the invention. In order to simplify the present disclosure, components and arrangements of specific examples are described below. Furthermore, the present invention may repeat reference numerals and/or letters in the various examples. This repetition is for the purpose of simplicity and clarity and does not in itself dictate a relationship between the various embodiments and/or configurations discussed. It should be noted that the components illustrated in the figures are not necessarily drawn to scale. Descriptions of well-known components and processing techniques and processes are omitted so as to not unnecessarily obscure the present invention.
As shown in fig. 1 and 2, a method for modifying the length of a database table space data block on line according to an embodiment of the present invention includes the following steps:
s1, creating a temporary table space according to the sum of the sizes of objects in the original table space, wherein the length of a data block in the temporary table space is different from the length of the data block in the original table space;
s2, acquiring an object data block of the original table space, moving the object data block, merging the object data block of the original table space if the temporary table space data block is bigger, and writing the merged object data block into the temporary table space data block; if the temporary table space data block is smaller, splitting the object data block of the original table space, and respectively writing the object data block into the temporary table space data block;
and S3, repeating the operation in the previous step until the object processing of the original table space is completed, deleting the original table space, and modifying the name of the temporary table space into the name of the original table space.
In step S2, in the process of moving the original tablespace object to the temporary tablespace, since the object has not yet been completely moved to the temporary tablespace, the object data block is still processed with the size of the data block in the original tablespace, and the database may read and write the object as follows.
Case one: when the read data block is still in the original table space, the data block is read according to the original data block size.
And a second case: when the read data block is in the temporary table space, the size of the data block is changed, and the data block needs to be processed and then is read by the database. If the temporary tablespace data block is smaller than the original data block, reading a corresponding number of data blocks, merging the data, and returning the merged data to the database for reading according to the original tablespace data block size. If the temporary tablespace data block is larger than the original data block, the read data block splits the data, and then returns the data to the database for reading according to the original tablespace data block size.
And a third case: when the data block to be written is still in the original table space, the data block is written according to the original data block size.
Case four: when a written data block is in the temporary table space, the size of the data block is changed, and the data block needs to be processed and then written into the temporary table space. If the temporary table space data block is larger than the data block to be written, if the data block to be written is not a new block, the data block is already merged and written into the temporary table space, the merged data block corresponding to the data block to be written needs to be found in the temporary table space, and the merged data block is updated to complete writing. If the data block is a new block, the written data blocks are merged and written into the temporary table space. If the temporary table space data block is smaller than the data block to be written, if the data block to be written is not a new block, the data block is split and written into the temporary table space, the split data block corresponding to the data block to be written needs to be found in the temporary table space, and the split data block is updated to complete writing. If the data block is a new block, the written data block is split and written into the temporary table space.
After the data block is completely moved to the temporary table space, the object completes the movement to the temporary table space, all read-write requests after the movement to the temporary table space occur in the temporary table space, the situation that the data block is combined and split can not occur when the data block is read-written, and the object completes the data block modification.
As shown in fig. 2, in one implementation of the embodiment of the present invention, a command to modify a data block in a tablespace is newly added: alter tablespace tb _ name modify blocksize to nK, n takes on the value 2/4/8/16/32. After the command is executed, the operations of steps S1 to S3 are performed.
In another implementation manner of the embodiment of the present invention, a processing procedure BSMn (block size modify process, n is a procedure number) is added to modify the length of the tablespace data block online, and the procedure modifies the size of the data block according to the above steps. When processing the objects, one process only processes the data block of one object at the same time, and then continues to process other objects after the processing is completed until all the processing is completed.
In order to accelerate the modification of the object data block, a process parameter, namely a block size_modification_process, is added, wherein the process parameter is used for designating the number of processes for simultaneously processing the modification of the object data block, and the default is 1 and the maximum is 10. When a plurality of processes are designated, the corresponding processes such as BSM1/BSM2 … are started after the database, each process only processes the data block of one object at the same time, and the other objects are continuously processed after the processing is finished, and the processes are exited after the processing is finished. The more processes, the higher the processing efficiency, but the more I/O consumption, the parameter value can be adjusted according to the resource consumption. The parameter can be adjusted at any time according to the resource consumption condition, and when the value is increased, a new process is started immediately, and the object is allocated for processing. When the value is reduced, the processes which have already processed the object are preferentially recycled until the number of the remaining processes meets the parameter requirement.
The method further comprises the following steps of: the data block header data is constructed for the temporary tablespace data block.
The data block length is one of 2K,4K,8K,16K or 32K.
As shown in fig. 3, an embodiment of the present invention provides a system for modifying a database tablespace data block length online, the system including a temporary tablespace creation unit 1, an object moving unit 2, a tablespace replacement unit 3, and a process control unit 4:
the temporary table space creating unit 1 creates a temporary table space according to the sum of the sizes of the objects in the original table space, wherein the length of the data block in the temporary table space is different from the length of the data block in the original table space; the object moving unit 2 acquires the object data block of the original table space, moves the object data block, and if the temporary table space data block becomes large, merges the object data block of the original table space and writes the merged object data block into the temporary table space data block; if the temporary table space data block is smaller, splitting the object data block of the original table space, and respectively writing the object data block into the temporary table space data block; setting a read-write strategy for the surface space data block in the moving process; the table space replacing unit 3 deletes the original table space after the object processing of the original table space is completed, and modifies the temporary table space name to the original table space name. The process control unit 4 is configured to increase a processing process for modifying the length of the tablespace data block, and increase a process parameter for specifying the number of processes modified by the simultaneous processing object data block.
The object moving unit 2 further comprises a data read-write processing subunit 21 for controlling read-write operations of the data blocks by the database during the movement of the data blocks.
The database may read and write the object as follows.
Case one: when the read data block is still in the original table space, the data block is read according to the original data block size.
And a second case: when the read data block is in the temporary table space, the size of the data block is changed, and the data block needs to be processed and then is read by the database. If the temporary tablespace data block is smaller than the original data block, reading a corresponding number of data blocks, merging the data, and returning the merged data to the database for reading according to the original tablespace data block size. If the temporary tablespace data block is larger than the original data block, the read data block splits the data, and then returns the data to the database for reading according to the original tablespace data block size.
And a third case: when the data block to be written is still in the original table space, the data block is written according to the original data block size.
Case four: when a written data block is in the temporary table space, the size of the data block is changed, and the data block needs to be processed and then written into the temporary table space. If the temporary table space data block is larger than the data block to be written, if the data block to be written is not a new block, the data block is already merged and written into the temporary table space, the merged data block corresponding to the data block to be written needs to be found in the temporary table space, and the merged data block is updated to complete writing. If the data block is a new block, the written data blocks are merged and written into the temporary table space. If the temporary table space data block is smaller than the data block to be written, if the data block to be written is not a new block, the data block is split and written into the temporary table space, the split data block corresponding to the data block to be written needs to be found in the temporary table space, and the split data block is updated to complete writing. If the data block is a new block, the written data block is split and written into the temporary table space.
While the foregoing description of the embodiments of the present invention has been presented in conjunction with the drawings, it should be understood that it is not intended to limit the scope of the invention, but rather, it is intended to cover all modifications or variations within the scope of the invention as defined by the claims of the present invention.
Claims (7)
1. A method for modifying the length of a block of data in a database table space on-line, said method comprising the steps of:
creating a temporary table space according to the sum of the sizes of the objects in the original table space, wherein the length of a data block in the temporary table space is different from the length of the data block in the original table space;
acquiring an object data block of an original table space, moving the object data block, merging the object data block of the original table space if the temporary table space data block is bigger, and writing the merged object data block into the temporary table space data block; if the temporary table space data block is smaller, splitting the object data block of the original table space, and respectively writing the object data block into the temporary table space data block; setting a read-write strategy for the surface space data block in the moving process;
repeating the operation of the previous step until the object of the original table space is processed, deleting the original table space, and modifying the name of the temporary table space into the name of the original table space;
the specific processing procedure of the database in the read-write strategy for performing the read operation on the current object is as follows:
if the read data block is still in the original table space, reading according to the size of the original data block;
if the read data block is in the temporary table space, the temporary table space data block is smaller than the original table space data block, the data block corresponding to the original table space object is read, the data blocks are combined, and the length of the original table space data block is returned to the database;
if the read data block is in the temporary table space, the temporary table space data block is larger than the original table space data block, the data block corresponding to the original table space object is read, the data block is split, and the data block is returned to the database according to the length of the original table space data block;
the specific processing procedure of the database in the read-write strategy for writing the current object is as follows:
if the data block to be written is in the original table space, writing is carried out according to the size of the original data block;
if the data block to be written is in the temporary table space, the temporary table space data block is larger than the original table space data block, and the data block to be written is not a new block, finding a combined data block corresponding to the data block to be written in the temporary table space, and updating the combined data block to complete writing; if the data block to be written is a new block, merging the new block and writing the new block into the temporary table space data block;
if the data block to be written is in the temporary table space, the temporary table space data block is smaller than the original table space data block, and the data block to be written is not a new block, finding a split data block corresponding to the data block to be written in the temporary table space, and updating the split data block to complete writing; if the data block to be written is a new block, the new block is split and written into temporary tablespace data blocks.
2. The method for online modification of database tablespace data block lengths according to claim 1, further comprising the steps of:
and adding a processing process for modifying the length of the data block of the table space, and adding process parameters, wherein the process parameters are used for specifying the number of processes for modifying the data block of the simultaneous processing object.
3. The method for online modification of a database tablespace data block length of claim 1, wherein said writing temporary tablespace data blocks further comprises: the data block header data is constructed for the temporary tablespace data block.
4. A method of modifying a length of a tablespace data block of a database online according to any one of claims 1-3, further comprising invoking a command to modify the tablespace data block prior to creating the temporary tablespace.
5. A method of on-line modification of a data block length in a database table space according to any of claims 1-3, wherein the data block length is one of 2K,4K,8K,16K or 32K.
6. A system for modifying the length of a block of database tablespace data on-line, said system comprising:
a temporary table space creation unit that creates a temporary table space according to a sum of sizes of objects in the original table space, the length of a data block in the temporary table space being different from the length of the data block in the original table space;
an object moving unit for acquiring an object data block of the original table space, moving the object data block, merging the object data block of the original table space if the temporary table space data block becomes large, and writing the merged object data block into the temporary table space data block; if the temporary table space data block is smaller, splitting the object data block of the original table space, and respectively writing the object data block into the temporary table space data block; setting a read-write strategy for the surface space data block in the moving process;
a table space replacing unit for deleting the original table space after the object processing of the original table space is completed, and modifying the name of the temporary table space into the name of the original table space;
the object moving unit also comprises a data read-write processing subunit, and is used for controlling read-write operation of the data block by the database in the moving process of the data block;
the specific processing procedure of the database for reading the data block is as follows:
if the read data block is still in the original table space, reading according to the size of the original data block;
if the read data block is in the temporary table space, the temporary table space data block is smaller than the original table space data block, the data block corresponding to the original table space object is read, the data blocks are combined, and the length of the original table space data block is returned to the database;
if the read data block is in the temporary table space, the temporary table space data block is larger than the original table space data block, the data block corresponding to the original table space object is read, the data block is split, and the data block is returned to the database according to the length of the original table space data block;
the specific processing procedure of the database for writing the data block is as follows:
if the data block to be written is in the original table space, writing is carried out according to the size of the original data block;
if the data block to be written is in the temporary table space, the temporary table space data block is larger than the original table space data block, and the data block to be written is not a new block, finding a combined data block corresponding to the data block to be written in the temporary table space, and updating the combined data block to complete writing; if the data block to be written is a new block, merging the new block and writing the new block into the temporary table space data block;
if the data block to be written is in the temporary table space, the temporary table space data block is smaller than the original table space data block, and the data block to be written is not a new block, finding a split data block corresponding to the data block to be written in the temporary table space, and updating the split data block to complete writing; if the data block to be written is a new block, the new block is split and written into temporary tablespace data blocks.
7. The system for on-line modification of a tablespace data block length of a database as defined in claim 6, further comprising a process control unit for adding a process for processing the modification of the tablespace data block length and adding a process parameter for specifying a number of processes for concurrently processing the modification of the object data block.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210046141.1A CN114443654B (en) | 2022-01-14 | 2022-01-14 | Method and system for on-line modifying length of database table space data block |
| PCT/CN2022/121923 WO2023134224A1 (en) | 2022-01-14 | 2022-09-27 | Method for online modification of length of data block in database table space |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210046141.1A CN114443654B (en) | 2022-01-14 | 2022-01-14 | Method and system for on-line modifying length of database table space data block |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114443654A CN114443654A (en) | 2022-05-06 |
| CN114443654B true CN114443654B (en) | 2024-01-26 |
Family
ID=81367288
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210046141.1A Active CN114443654B (en) | 2022-01-14 | 2022-01-14 | Method and system for on-line modifying length of database table space data block |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN114443654B (en) |
| WO (1) | WO2023134224A1 (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114443654B (en) * | 2022-01-14 | 2024-01-26 | 苏州浪潮智能科技有限公司 | Method and system for on-line modifying length of database table space data block |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1526107A (en) * | 2001-05-30 | 2004-09-01 | ���Ĺ��ʹ�˾ | Integrating tablespaces with different block sizes |
| CN105814562A (en) * | 2013-12-13 | 2016-07-27 | 国际商业机器公司 | Incremental and collocated redistribution for expansion of online shared nothing database |
| CN107193943A (en) * | 2017-05-19 | 2017-09-22 | 郑州云海信息技术有限公司 | A kind of method and apparatus of RDBMS online datas migration |
| CN109299072A (en) * | 2018-10-16 | 2019-02-01 | 郑州云海信息技术有限公司 | A kind of method and device that database migrates online |
| CN110019138A (en) * | 2017-12-29 | 2019-07-16 | 中国移动通信集团公司 | A kind of transmission table space Autonomic Migration Framework method and system based on Zabbix |
| CN110764943A (en) * | 2019-10-21 | 2020-02-07 | 中国民航信息网络股份有限公司 | Data processing method and device for Oracle database |
| CN113868188A (en) * | 2021-08-25 | 2021-12-31 | 苏州浪潮智能科技有限公司 | Method, system, equipment and medium for modifying storage position of database file |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6122640A (en) * | 1998-09-22 | 2000-09-19 | Platinum Technology Ip, Inc. | Method and apparatus for reorganizing an active DBMS table |
| CN100342377C (en) * | 2003-04-16 | 2007-10-10 | 华为技术有限公司 | Method of raising officiency of data processing |
| US10073888B1 (en) * | 2017-02-27 | 2018-09-11 | Timescacle, Inc. | Adjusting partitioning policies of a database system in view of storage reconfiguration |
| CN110909087A (en) * | 2019-11-28 | 2020-03-24 | 北京思特奇信息技术股份有限公司 | Method and device for modifying table structure of online DDL (distributed data storage) of relational database |
| CN114443654B (en) * | 2022-01-14 | 2024-01-26 | 苏州浪潮智能科技有限公司 | Method and system for on-line modifying length of database table space data block |
-
2022
- 2022-01-14 CN CN202210046141.1A patent/CN114443654B/en active Active
- 2022-09-27 WO PCT/CN2022/121923 patent/WO2023134224A1/en unknown
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1526107A (en) * | 2001-05-30 | 2004-09-01 | ���Ĺ��ʹ�˾ | Integrating tablespaces with different block sizes |
| CN105814562A (en) * | 2013-12-13 | 2016-07-27 | 国际商业机器公司 | Incremental and collocated redistribution for expansion of online shared nothing database |
| CN107193943A (en) * | 2017-05-19 | 2017-09-22 | 郑州云海信息技术有限公司 | A kind of method and apparatus of RDBMS online datas migration |
| CN110019138A (en) * | 2017-12-29 | 2019-07-16 | 中国移动通信集团公司 | A kind of transmission table space Autonomic Migration Framework method and system based on Zabbix |
| CN109299072A (en) * | 2018-10-16 | 2019-02-01 | 郑州云海信息技术有限公司 | A kind of method and device that database migrates online |
| CN110764943A (en) * | 2019-10-21 | 2020-02-07 | 中国民航信息网络股份有限公司 | Data processing method and device for Oracle database |
| CN113868188A (en) * | 2021-08-25 | 2021-12-31 | 苏州浪潮智能科技有限公司 | Method, system, equipment and medium for modifying storage position of database file |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2023134224A1 (en) | 2023-07-20 |
| CN114443654A (en) | 2022-05-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9678969B2 (en) | Metadata updating method and apparatus based on columnar storage in distributed file system, and host | |
| CN105144160A (en) | A method to accelerate queries using dynamically generated alternate data formats in flash cache | |
| CN104112008A (en) | Multi-table data association inquiry optimizing method and device | |
| CN114443654B (en) | Method and system for on-line modifying length of database table space data block | |
| US11188535B2 (en) | Distributed join operation processing method, apparatus, device, and storage medium | |
| CN107766374B (en) | Optimization method and system for storage and reading of massive small files | |
| CN107608773A (en) | task concurrent processing method, device and computing device | |
| AU2004230500B2 (en) | A method for improving data processing efficiency | |
| DE102014116031A1 (en) | SWAT command and API for atomic swapping and trimming of LBAs | |
| DE102019116546A1 (en) | METHOD FOR FAST BOAT READING | |
| CN105718561A (en) | Particular distributed data storage file structure redundancy removing construction method and system | |
| KR20160100211A (en) | Method and device for constructing on-line real-time updating of massive audio fingerprint database | |
| CN106919697B (en) | Method for simultaneously importing data into multiple Hadoop assemblies | |
| CN114138776A (en) | Method, system, apparatus and medium for graph structure and graph attribute separation design | |
| US20180018361A1 (en) | Index Table Update Method, and Device | |
| DE102015203202B4 (en) | Storage subsystem with continuous read following wrapped read | |
| CN111352936A (en) | Method and storage medium for ES index reconstruction | |
| US20150039558A1 (en) | Database management method, database system and medium | |
| CN110211234A (en) | A kind of grid model sewing system and method | |
| CN113535729A (en) | Method for realizing row and column mixed storage based on RocksDB | |
| CN113268457A (en) | Self-adaptive learning index method and system supporting efficient writing | |
| CN103377292A (en) | Database result set caching method and device | |
| CN117235028A (en) | Data query method and device based on log file | |
| CN110515897B (en) | Method and system for optimizing reading performance of LSM storage system | |
| CN111459408A (en) | Method and system for improving data search rate in DRAM |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |