CN103593447A - Data processing method and device applied to database table - Google Patents
Data processing method and device applied to database table Download PDFInfo
- Publication number
- CN103593447A CN103593447A CN201310577207.0A CN201310577207A CN103593447A CN 103593447 A CN103593447 A CN 103593447A CN 201310577207 A CN201310577207 A CN 201310577207A CN 103593447 A CN103593447 A CN 103593447A
- Authority
- CN
- China
- Prior art keywords
- database table
- data
- temporary
- data processing
- subregion
- 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.)
- Granted
Links
Images
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/2358—Change logging, detection, and notification
Abstract
The invention discloses a data processing method and device applied to a database table. The method comprises the steps of obtaining a temporary table having identical structure with the database table, and switching data in the database table into the temporary table through a switching operation. Through the data processing method and device applied to the database table, the effect of improving the data processing efficiency in a data table can be achieved.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of data processing method for database table and device.
Background technology
When deleting the data of a tables of data, there are several conventional schemes:
Delete(deletes) data, database is the data in delete list one by one, when deleting data, can record corresponding daily record.
Truncate(blocks) table, can directly block whole table, can log, but require do not have the external key of other tables associated with this table.
Drop(removes) table, can be directly whole list deletion.
Delete data are owing to having a large amount of read-write operations when the log, and efficiency is very low.Truncate table cannot be used when existing external key associated.And Drop table retains at needs table, inapplicable while only deleting data.
For the prior art problem lower to the data-handling efficiency in database table, effective solution is not yet proposed at present.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of data processing method for database table and device, to solve prior art to the lower problem of the data-handling efficiency in database table.
To achieve these goals, according to an aspect of the present invention, provide a kind of data processing method of database table.According to the data processing method of database table of the present invention, comprise: obtain the temporary table consistent with database table structure; And by blocked operation by the data exchange of database table in temporary table.
Further, by blocked operation, the data exchange of database table is comprised to temporary table: judge whether database table has subregion; If judge database table, there is subregion, by blocked operation, the subregion of database table is transferred in temporary table from database table; And if judge database table and there is no subregion, by blocked operation, directly the data in database table and temporary table are exchanged.
Further, by blocked operation, the data exchange of database table is comprised to temporary table: the configuration information by metadata in blocked operation Update Table storehouse table by the data exchange of database table in temporary table.
Further, before obtaining the temporary table consistent with database table structure, method also comprises: according to database table, create temporary table.
Further, by blocked operation, the data exchange of database table is comprised to temporary table: the data in delete database table, by blocked operation by after the data exchange of database table is in temporary table, method also comprises: temporary table is carried out and to be removed operation.
To achieve these goals, according to a further aspect in the invention, provide a kind of data processing equipment of database table.According to the data processing equipment of database table of the present invention, comprise: judge module, for judging whether database table has subregion; Shift module for when judging database table and have subregion, is transferred in temporary table by blocked operation by the subregion of database table from database table; And Switching Module, for when judging database table and there is no subregion, by blocked operation, directly the data in database table and temporary table are exchanged.
Further, shift module also for the configuration information by blocked operation Update Table storehouse table metadata by the data exchange of database table in temporary table.
Further, data processing equipment also comprises: creating unit, for before obtaining the temporary table consistent with database table structure, creates temporary table according to database table.
Further, data processing equipment comprises: switch unit also comprises removing module, for the data of delete database table; And remove unit, for by blocked operation by the data exchange of database table after temporary table, temporary table is carried out and is removed operation.
By the present invention, adopt and obtain the temporary table consistent with database table structure; And by blocked operation by the data exchange of described database table in described temporary table, solved problem to the data-handling efficiency in database table lower in prior art, and then reached the effect that improves the data-handling efficiency in tables of data.
Accompanying drawing explanation
The accompanying drawing that forms the application's a part is used to provide a further understanding of the present invention, and schematic description and description of the present invention is used for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is according to the process flow diagram of the data processing method of the database table of first embodiment of the invention;
Fig. 2 is according to the process flow diagram of the data processing method of the database table of second embodiment of the invention;
Fig. 3 is according to the schematic diagram of the data processing equipment of the database table of first embodiment of the invention; And
Fig. 4 is according to the schematic diagram of the data processing equipment of the database table of second embodiment of the invention.
Embodiment
It should be noted that, in the situation that not conflicting, embodiment and the feature in embodiment in the application can combine mutually.Describe below with reference to the accompanying drawings and in conjunction with the embodiments the present invention in detail.
The embodiment of the present invention provides a kind of data processing method of tables of data, and the method may operate on computer program.
Fig. 1 is according to the process flow diagram of the data processing method of the database table of first embodiment of the invention.As shown in the figure, the data processing method of this database table comprises the steps:
Step S101, obtains the temporary table consistent with database table structure.
The structure of tables of data comprises field name, type etc., obtain the temporary table consistent with data list structure comprise obtain consistent with field name, the type of database table structure, index is consistent, table compress mode one Primary key of making peace is consistent, wherein, index comprises clustered index and Nonclustered index.
In order to guarantee not make mistakes in data handling procedure, set up the temporary table consistent with database table structure.Wherein, stored and need processed data in processed database table, temporary table can need processed data in stored data base table.
Step S102, by blocked operation by the data exchange of database table in temporary table.Blocked operation can be for all data in database table, also can be for the partial data in database table.So-called blocked operation is exactly that the data in database table are moved on in temporary table, the integral body that can simultaneously remove many data or database table data removes, but, log not, do not relate to reading and writing data IO, when need to retaining database table structure, only the data in database table are processed.
By above step, can carry out batch hand-off process to the data in database table, improved the efficiency of data processing, list structure that simultaneously can save data storehouse table.
Fig. 2 is according to the process flow diagram of the data processing method of the database table of second embodiment of the invention.As shown in the figure, the data processing method of this database table comprises the steps:
Step S201, obtains the temporary table consistent with database table structure.
The structure of tables of data comprises field name, type etc., obtain the temporary table consistent with data list structure comprise obtain consistent with field name, the type of database table structure, index is consistent, table compress mode one Primary key of making peace is consistent, wherein, index comprises clustered index and Nonclustered index.
In order to guarantee not make mistakes in data handling procedure, set up the temporary table consistent with database table structure.Wherein, stored and need processed data in processed database table, temporary table can need processed data in stored data base table.
Step S202, judges whether database table has subregion.Database table partitioned storage data can improve the performance of database, therefore, in more complicated database table, often there is subregion, if database table has subregion, need to first determine and need data to be processed in which subregion, and the data in this subregion are processed.
The data that are partitioned storage are a plurality of files physically, but remain in logic a table, and the operation of his-and-hers watches is also the same with before subregion, and therefore, the method that the embodiment of the present invention provides also can be applied in the database table after being partitioned.In the database table no matter being partitioned or the database table not being partitioned, can carry out the operations such as insertion, deletion, inquiry and renewal of data.Certainly, the embodiment of the present invention is more concerned about be database table data be to delete.
Step S203, has subregion if judge database table, by blocked operation, the subregion of database table is transferred in temporary table from database table.
Before the data in database table are processed, first judge whether database table has subregion, if database table has subregion, to carrying out the data of the subregion of data processing, be transferred in temporary table.In the process shifting, only shift the data that need subregion to be processed, the data list structure that this subregion is corresponding is not changed.Meanwhile, the blank content in blank temporary table is switched in corresponding database table, thereby has realized the switching of database table.
Step S204, does not have subregion if judge database table, by blocked operation, directly the data in database table and temporary table is exchanged.If judged in database table, there is no subregion, can directly to all data in database table, carry out blocked operation.Data in database table and the corresponding clear data of temporary table are exchanged, thereby realized the switching of data.
In said process, owing to being only the exchange of data, so just can complete 1 second for example in the very short time.Therefore,, when the deletion to data, improved the efficiency that data are deleted.Meanwhile, due to the data that store in temporary table in database table, in the situation that deleting, mistake can recover data.
Further, by blocked operation, the data exchange of database table is comprised to temporary table: the configuration information by metadata in blocked operation Update Table storehouse table by the data exchange of database table in temporary table.
Pass through blocked operation, metadata in database table is switched in temporary table by atomic operation, the metadata being about in database table is switched in temporary table, metadata corresponding position in database table is empty, namely will in database table, need the content of deleting to delete, retain the structure of database table simultaneously, and content is deleted.
Further, before obtaining the temporary table consistent with database table structure, according to database table, create temporary table.
The temporary table creating is consistent with the structure of database table, comprises field name, type is consistent, index is consistent, it is consistent to show compress mode one Primary key of making peace, and wherein, index comprises clustered index and Nonclustered index.
Further, by blocked operation, the data exchange of database table is comprised to temporary table: the data in delete database table, by blocked operation by after the data exchange of database table is in temporary table, temporary table is carried out and to be removed operation.
The temporary table structure of setting up is consistent with database table, but its content is empty, by the data exchange of database table in temporary table, the content pages of temporary table is switched in database table, in database table, the content of relevant position is empty, and the data in database table are deleted.If the data that are switched in temporary table no longer need to retain, only temporary table directly need be deleted, thereby realized, the content in database table is deleted, improved data-handling efficiency in database table.
The present invention also provides a kind of data processing equipment of database table.
Fig. 3 is according to the schematic diagram of the data processing equipment of the database table of first embodiment of the invention.As shown in the figure, this device comprises acquiring unit 10 and switch unit 20.
Acquiring unit 10 is for obtaining the temporary table consistent with database table structure.The structure of tables of data comprises field name, type etc., obtain the temporary table consistent with data list structure comprise obtain consistent with field name, the type of database table structure, index is consistent, table compress mode one Primary key of making peace is consistent, wherein, index comprises clustered index and Nonclustered index.
In order to guarantee not make mistakes in data handling procedure, set up the temporary table consistent with database table structure.Wherein, stored and need processed data in processed database table, temporary table can need processed data in stored data base table.
Switch unit 20 for by blocked operation by the data exchange of database table to temporary table.
Blocked operation can be for all data in database table, also can be for the partial data in database table.So-called blocked operation is exactly that the data in database table are moved on in temporary table, the integral body that can simultaneously remove many data or database table data removes, but, log not, do not relate to reading and writing data IO, when need to retain database table structure, only the data in database table are processed.
By above device, can carry out batch hand-off process to the data in database table, improved the efficiency of data processing, list structure that simultaneously can save data storehouse table.
Fig. 4 is according to the schematic diagram of the data processing equipment of the database table of second embodiment of the invention.As shown in the figure, the data processing equipment of this database table comprises acquiring unit 10 and switch unit 20, and wherein, switch unit 20 comprises judge module 201, shift module 202 and Switching Module 203.
Judge module 201 is for judging whether database table has subregion.Database table partitioned storage data can improve the performance of database, therefore, in more complicated database table, often there is subregion, if database table has subregion, need to first determine and need data to be processed in which subregion, and the data in this subregion are processed.
The data that are partitioned storage are a plurality of files physically, but remain in logic a table, and the operation of his-and-hers watches is also the same with before subregion, and therefore, the method that the embodiment of the present invention provides also can be applied in the database table after being partitioned.In the database table no matter being partitioned or the database table not being partitioned, can carry out the operations such as insertion, deletion, inquiry and renewal of data.Certainly, the embodiment of the present invention is more concerned about be database table data be to delete.
Shift module 202, for when judging database table and have subregion, is transferred to the subregion of database table in temporary table by blocked operation from database table.
Before the data in database table are processed, first judge whether database table has subregion, if database table has subregion, to carrying out the data of the subregion of data processing, be transferred in temporary table.In the process shifting, only shift the data that need subregion to be processed, the data list structure that this subregion is corresponding is not changed.Meanwhile, the blank content in blank temporary table is switched in corresponding database table, thereby has realized the switching of database table.
Switching Module 203, for when judging database table and there is no subregion, directly exchanges the data in database table and temporary table by blocked operation.If judged in database table, there is no subregion, can directly to all data in database table, carry out blocked operation.Data in database table and the corresponding clear data of temporary table are exchanged, thereby realized the switching of data.
In said process, owing to being only the exchange of data, so just can complete 1 second for example in the very short time.Therefore,, when the deletion to data, improved the efficiency that data are deleted.Meanwhile, due to the data that store in temporary table in database table, in the situation that deleting, mistake can recover data.
Further, shift module 202 also for the configuration information by blocked operation Update Table storehouse table metadata by the data exchange of database table in temporary table.
Pass through blocked operation, metadata in database table is switched in temporary table by atomic operation, the metadata being about in database table is switched in temporary table, metadata corresponding position in database table is empty, namely will in database table, need the content of deleting to delete, retain the structure of database table simultaneously, and content is deleted.
Further, this data processing equipment also comprises creating unit, and this creating unit, for before obtaining the temporary table consistent with database table structure, creates temporary table according to database table.
The temporary table creating is consistent with the structure of database table, comprises field name, type is consistent, index is consistent, it is consistent to show compress mode one Primary key of making peace, and wherein, index comprises clustered index and Nonclustered index.
Further, the switch unit 20 of data processing equipment also comprises removing module, and this removing module, for the data of delete database table, also comprises and removes unit, for by blocked operation by the data exchange of database table after temporary table, temporary table is carried out and to be removed operation.
The temporary table structure of setting up is consistent with database table, but its content is empty, by the data exchange of database table in temporary table, the content pages of temporary table is switched in database table, in database table, the content of relevant position is empty, and the data in database table are deleted.If the data that are switched in temporary table no longer need to retain, only temporary table directly need be deleted, thereby realized, the content in database table is deleted, improved data-handling efficiency in database table.
Obviously, those skilled in the art should be understood that, above-mentioned each module of the present invention or each step can realize with general calculation element, they can concentrate on single calculation element, or be distributed on the network that a plurality of calculation elements form, alternatively, they can be realized with the executable program code of calculation element, thereby, they can be stored in memory storage and be carried out by calculation element, or they are made into respectively to each integrated circuit modules, or a plurality of modules in them or step are made into single integrated circuit module to be realized.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. for a data processing method for database table, it is characterized in that, comprising:
Obtain the temporary table consistent with database table structure; And
By blocked operation by the data exchange of described database table in described temporary table.
2. data processing method according to claim 1, is characterized in that, by blocked operation, the data exchange of described database table is comprised to described temporary table:
Judge whether described database table has subregion;
If judge described database table, there is subregion, by described blocked operation, the subregion of described database table is transferred in described temporary table from described database table; And
If judge described database table, there is no subregion, by described blocked operation, directly the data in described database table and described temporary table are exchanged.
3. data processing method according to claim 1, is characterized in that, by blocked operation, the data exchange of described database table is comprised to described temporary table:
The configuration information of revising metadata in described database table by described blocked operation by the data exchange of described database table in described temporary table.
4. data processing method according to claim 1, is characterized in that, before obtaining the temporary table consistent with database table structure, described method also comprises:
According to described database table, create described temporary table.
5. data processing method according to claim 1, it is characterized in that, by blocked operation, the data exchange of described database table is comprised to described temporary table: delete the data in described database table, by blocked operation by after the data exchange of described database table is in described temporary table, described method also comprises:
Described temporary table is carried out and removed operation.
6. for a data processing equipment for database table, it is characterized in that, comprising:
Acquiring unit, for obtaining the temporary table consistent with database table structure; And
Switch unit, for by blocked operation by the data exchange of described database table to described temporary table.
7. data processing equipment according to claim 6, is characterized in that, described switch unit comprises:
Judge module, for judging whether described database table has subregion;
Shift module for when judging described database table and have subregion, is transferred in described temporary table by described blocked operation by the subregion of described database table from described database table; And
Switching Module, for when judging described database table and there is no subregion, directly exchanges the data in described database table and described temporary table by described blocked operation.
8. data processing equipment according to claim 6, is characterized in that, described shift module also for the configuration information of revising described database table metadata by described blocked operation by the data exchange of described database table in described temporary table.
9. data processing equipment according to claim 6, is characterized in that, described data processing equipment also comprises:
Creating unit, for before obtaining the temporary table consistent with database table structure, creates described temporary table according to described database table.
10. data processing equipment according to claim 6, is characterized in that, described data processing equipment comprises:
Described switch unit also comprises removing module, for deleting the data of described database table; And
Remove unit, for by blocked operation by the data exchange of described database table after described temporary table, described temporary table is carried out and is removed operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310577207.0A CN103593447B (en) | 2013-11-18 | 2013-11-18 | Data processing method and device applied to database table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310577207.0A CN103593447B (en) | 2013-11-18 | 2013-11-18 | Data processing method and device applied to database table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103593447A true CN103593447A (en) | 2014-02-19 |
| CN103593447B CN103593447B (en) | 2017-02-08 |
Family
ID=50083588
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310577207.0A Active CN103593447B (en) | 2013-11-18 | 2013-11-18 | Data processing method and device applied to database table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103593447B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104392001A (en) * | 2014-12-15 | 2015-03-04 | 北京国双科技有限公司 | Database inquiry method and device |
| CN104408179A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Method and device for processing data from data table |
| CN104965879A (en) * | 2015-06-12 | 2015-10-07 | 小米科技有限责任公司 | Method and device for altering table structure of data table |
| CN106649355A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Method and device for processing data |
| CN110333970A (en) * | 2019-07-10 | 2019-10-15 | 中国民航信息网络股份有限公司 | A kind of data reconstruction method and device |
| CN110413593A (en) * | 2019-06-19 | 2019-11-05 | 平安银行股份有限公司 | Data migration method, device, computer equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101145158A (en) * | 2007-06-06 | 2008-03-19 | 中兴通讯股份有限公司 | Data base table partition method |
| US20080120304A1 (en) * | 2006-11-21 | 2008-05-22 | Calio Robert J | Method and system for providing high performance data modification of relational database tables |
| CN101504664A (en) * | 2009-03-18 | 2009-08-12 | 中国工商银行股份有限公司 | Apparatus and method for extracting, converting and loading total source data |
| CN102411569A (en) * | 2010-09-20 | 2012-04-11 | 上海众融信息技术有限公司 | Database conversion and cleaning information processing method |
| USRE43391E1 (en) * | 1992-04-30 | 2012-05-15 | Straform Data Mgmt Limited Liability Company | Database program with automatic creation of user features |
| CN102456024A (en) * | 2010-10-26 | 2012-05-16 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for asynchronously processing newly added large data volume |
-
2013
- 2013-11-18 CN CN201310577207.0A patent/CN103593447B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| USRE43391E1 (en) * | 1992-04-30 | 2012-05-15 | Straform Data Mgmt Limited Liability Company | Database program with automatic creation of user features |
| US20080120304A1 (en) * | 2006-11-21 | 2008-05-22 | Calio Robert J | Method and system for providing high performance data modification of relational database tables |
| CN101145158A (en) * | 2007-06-06 | 2008-03-19 | 中兴通讯股份有限公司 | Data base table partition method |
| CN101504664A (en) * | 2009-03-18 | 2009-08-12 | 中国工商银行股份有限公司 | Apparatus and method for extracting, converting and loading total source data |
| CN102411569A (en) * | 2010-09-20 | 2012-04-11 | 上海众融信息技术有限公司 | Database conversion and cleaning information processing method |
| CN102456024A (en) * | 2010-10-26 | 2012-05-16 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for asynchronously processing newly added large data volume |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104392001A (en) * | 2014-12-15 | 2015-03-04 | 北京国双科技有限公司 | Database inquiry method and device |
| CN104408179A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Method and device for processing data from data table |
| CN104392001B (en) * | 2014-12-15 | 2017-11-14 | 北京国双科技有限公司 | Data base query method and device |
| CN104408179B (en) * | 2014-12-15 | 2018-11-06 | 北京国双科技有限公司 | Data processing method and device in tables of data |
| CN104965879A (en) * | 2015-06-12 | 2015-10-07 | 小米科技有限责任公司 | Method and device for altering table structure of data table |
| CN104965879B (en) * | 2015-06-12 | 2019-03-26 | 小米科技有限责任公司 | Modify the method and device of the table structure of tables of data |
| CN106649355A (en) * | 2015-10-30 | 2017-05-10 | 北京国双科技有限公司 | Method and device for processing data |
| CN110413593A (en) * | 2019-06-19 | 2019-11-05 | 平安银行股份有限公司 | Data migration method, device, computer equipment and storage medium |
| CN110333970A (en) * | 2019-07-10 | 2019-10-15 | 中国民航信息网络股份有限公司 | A kind of data reconstruction method and device |
| CN110333970B (en) * | 2019-07-10 | 2021-09-07 | 中国民航信息网络股份有限公司 | Data recovery method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103593447B (en) | 2017-02-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103593447A (en) | Data processing method and device applied to database table | |
| CN101826107B (en) | Hash data processing method and device | |
| US20100114843A1 (en) | Index Compression In Databases | |
| CN106547644B (en) | Incremental backup method and equipment | |
| CN103020255A (en) | Hierarchical storage method and hierarchical storage device | |
| CN103559301A (en) | Method of data update, database trigger and SE (search engine) | |
| CN104778222A (en) | Media library establishing and updating method on basis of USB (Universal Serial Bus) storage equipment | |
| CN110888837B (en) | Object storage small file merging method and device | |
| CN104679851A (en) | Data deleting method and terminal | |
| EP3438845A1 (en) | Data updating method and device for a distributed database system | |
| CN106469152A (en) | A kind of document handling method based on ETL and system | |
| US20190018878A1 (en) | Dual overlay query processing | |
| CN106294886A (en) | A kind of method and system of full dose extracted data from HBase | |
| CN108121774B (en) | Data table backup method and terminal equipment | |
| CN104965835A (en) | Method and apparatus for reading and writing files of a distributed file system | |
| KR101640733B1 (en) | System for Managing data based In-Memory DataBase and method thereof | |
| CN102541952A (en) | Method and device for acquiring history data on basis of database | |
| CN106020717B (en) | Data processing method and electronic equipment | |
| KR101588375B1 (en) | Method and system for managing database | |
| CN108646987A (en) | A kind of management method of file volume, device, storage medium and terminal | |
| CN107609068B (en) | Data non-inductive migration method | |
| CN101980195B (en) | Mobile communication terminal-based database index repair method and device | |
| US20190332484A1 (en) | Method, device and program product for reducing data recovery time of storage system | |
| CN102915324B (en) | Data storage and retrieval device and data storage and retrieval method | |
| CN105260423A (en) | Duplicate removal method and apparatus for electronic cards |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Data processing method and device applied to database table Effective date of registration: 20190531 Granted publication date: 20170208 Pledgee: Shenzhen Black Horse World Investment Consulting Co., Ltd. Pledgor: Beijing Guoshuang Technology Co.,Ltd. Registration number: 2019990000503 |
|
| CP02 | Change in the address of a patent holder | ||
| CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: Beijing Guoshuang Technology Co.,Ltd. |