CN103593447B - Data processing method and device applied to database table - Google Patents

Data processing method and device applied to database table Download PDF

Info

Publication number
CN103593447B
CN103593447B CN201310577207.0A CN201310577207A CN103593447B CN 103593447 B CN103593447 B CN 103593447B CN 201310577207 A CN201310577207 A CN 201310577207A CN 103593447 B CN103593447 B CN 103593447B
Authority
CN
China
Prior art keywords
database table
data
interim
handover operation
data processing
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
Application number
CN201310577207.0A
Other languages
Chinese (zh)
Other versions
CN103593447A (en
Inventor
吴充
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Gridsum Technology Co Ltd
Original Assignee
Beijing Gridsum Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Gridsum Technology Co Ltd filed Critical Beijing Gridsum Technology Co Ltd
Priority to CN201310577207.0A priority Critical patent/CN103593447B/en
Publication of CN103593447A publication Critical patent/CN103593447A/en
Application granted granted Critical
Publication of CN103593447B publication Critical patent/CN103593447B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2358Change logging, detection, and notification

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

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

Data processing method for database table and device
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(Delete)Data, data base can delete the data in table one by one, can record corresponding when deleting data Daily record.
Truncate(Block)Table, can directly block whole table, will not log, but require not have the external key of other tables with This table associates.
Drop(Remove)Table, directly can delete whole table.
Delete data is very low due to having substantial amounts of read-write operation, efficiency in log.Truncate table is being deposited Cannot use when external key associates.And Drop table is needing table to retain, only delete inapplicable during data.
For prior art to the data-handling efficiency in database table than relatively low problem, not yet propose at present effectively Solution.
Content of the invention
Present invention is primarily targeted at providing a kind of data processing method for database table and device, existing to solve There is technology to the data-handling efficiency in database table than relatively low problem.
To achieve these goals, according to an aspect of the invention, it is provided a kind of data processing side of database table Method.The data processing method of the database table according to the present invention includes:Obtain the interim table consistent with database table structure;And By handover operation by the data exchange of database table in interim table.
Further, by handover operation, the data exchange of database table is included to interim table:Judge database table Whether there is subregion;If it is judged that database table has subregion, then pass through handover operation by the subregion of database table from database table In be transferred in interim table;And if it is judged that database table does not have subregion, then pass through handover operation directly to database table Swap with the data in interim table.
Further, by handover operation, the data exchange of database table is included to interim table:By handover operation Modification database table in metadata configuration information by the data exchange of database table in interim table.
Further, before obtaining the interim table consistent with database table structure, method also includes:According to database table Create interim table.
Further, by handover operation, the data exchange of database table is included to interim table:Delete database table In data, by handover operation by the data exchange of database table in interim table after, method also includes:To interim table Execution removes operation.
To achieve these goals, according to a further aspect in the invention, there is provided a kind of data processing dress of database table Put.The data processing equipment of the database table according to the present invention includes:Judge module, for judging whether database table has point Area;Shift module, for when judging that database table has subregion, by handover operation by the subregion of database table from data base It is transferred in table in interim table;And Switching Module, for when judging that database table does not have subregion, then passing through handover operation Directly the data in database table and interim table is swapped.
Further, shift module is additionally operable to change the configuration information of metadata in database table by number by handover operation According to storehouse table data exchange in interim table.
Further, data processing equipment also includes:Creating unit, for obtaining face consistent with database table structure When table before, according to database table create interim table.
Further, data processing equipment includes:Switch unit also includes removing module, for deleting in database table Data;And remove unit, for by handover operation by the data exchange of database table in interim table after, to interim Table execution removes operation.
By the present invention, using the interim table that acquisition is consistent with database table structure;And will be described by handover operation The data exchange of database table, in described interim table, solves in prior art to the data-handling efficiency ratio in database table Relatively low problem, and then reached the effect improving the data-handling efficiency in tables of data.
Brief description
The accompanying drawing constituting the part of the application is used for providing a further understanding of the present invention, the schematic reality of the present invention Apply example and its illustrate, for explaining the present invention, not constituting inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the flow chart of the data processing method of database table according to a first embodiment of the present invention;
Fig. 2 is the flow chart of the data processing method of database table according to a second embodiment of the present invention;
Fig. 3 is the schematic diagram of the data processing equipment of database table according to a first embodiment of the present invention;And
Fig. 4 is the schematic diagram of the data processing equipment of database table according to a second embodiment of the present invention.
Specific embodiment
It should be noted that in the case of not conflicting, the embodiment in the application and the feature in embodiment can phases Mutually combine.To describe the present invention below with reference to the accompanying drawings and in conjunction with the embodiments in detail.
Embodiments provide a kind of data processing method of tables of data, the method may operate in computer program On.
Fig. 1 is the flow chart of the data processing method of database table according to a first embodiment of the present invention.As illustrated, should The data processing method of database table comprises the steps:
Step S101, obtains the interim table consistent with database table structure.
The structure of tables of data includes field name, type etc., obtains the interim table consistent with data list structure and includes obtaining With the field name of database table structure, type is consistent, index is consistent, table compress mode one is made peace, and Primary key is consistent, wherein, Index includes clustered index and Nonclustered index.
In order to ensure not malfunction in data processing, set up the interim table consistent with database table structure.Wherein, quilt Storing in the database table processing needs data to be processed, and interim table can need processed number with the table of data storage storehouse According to.
Step S102, by handover operation by the data exchange of database table in interim table.Handover operation can be directed to All data in database table are it is also possible to for the partial data in database table.So-called handover operation is exactly by data base Data in table moves on in interim table, can remove many data simultaneously or the entirety of database table data removes, but, no Log, is not related to reading and writing data IO, only the data in database table is entered when needing retention data database table structure Row is processed.
By above step, batch hand-off process can be carried out to the data in database table, improve data processing Efficiency, can preserve the table structure of database table simultaneously.
Fig. 2 is the flow chart of the data processing method of database table according to a second embodiment of the present invention.As illustrated, should The data processing method of database table comprises the steps:
Step S201, obtains the interim table consistent with database table structure.
The structure of tables of data includes field name, type etc., obtains the interim table consistent with data list structure and includes obtaining With the field name of database table structure, type is consistent, index is consistent, table compress mode one is made peace, and Primary key is consistent, wherein, Index includes clustered index and Nonclustered index.
In order to ensure not malfunction in data processing, set up the interim table consistent with database table structure.Wherein, quilt Storing in the database table processing needs data to be processed, and interim table can need processed number with the table of data storage storehouse According to.
Step S202, judges whether database table has subregion.Database table partitioned storage data can improve data base's , therefore, often there is subregion in performance in more complicated database table, if database table has subregion, need first to determine needs Which subregion is the data processing be in, and the data in this subregion is processed.
The data being partitioned storage is physically multiple files, but remains a table, the operation to table in logic As before subregion, therefore, method provided in an embodiment of the present invention can also be applied in the database table after being partitioned.No By being the database table that is partitioned again without in the database table being partitioned, can be carried out the insertion of data, deletion, inquiry With operations such as renewals.Certainly, the embodiment of the present invention more concerned be database table data be delete.
Step S203, if it is judged that database table has subregion, then passes through handover operation by the subregion of database table from number It is transferred in interim table according in the table of storehouse.
Before the data in database table is processed, first determine whether whether database table has subregion, if data Storehouse table has subregion, then the data needing the subregion carrying out data processing is transferred in interim table.During transfer, only turn Move the data needing subregion to be processed, corresponding data list structure is not changed to this subregion.Meanwhile, in blank interim table Empty content is switched in corresponding database table, it is achieved thereby that the switching of database table.
Step S204, if it is judged that database table does not have subregion, then passes through handover operation directly to database table and facing When table in data swap.If it is judged that there is no subregion in database table, can be directly to all in database table Data switches over operation.Corresponding with interim table for data in database table clear data is swapped, it is achieved thereby that The switching of data.
In above process, due to being only the exchange of data, so just can complete in the very short time, such as 1 second. Therefore, in the deletion to data, improve the efficiency of data deletion.Simultaneously as the database table that is stored with interim table In data, data can be recovered in the case of delete by mistake.
Further, by handover operation, the data exchange of database table is included to interim table:By handover operation Modification database table in metadata configuration information by the data exchange of database table in interim table.
By handover operation, the metadata in database table is switched in interim table by atomic operation, will data Metadata in the table of storehouse is switched in interim table, and metadata corresponding position in database table is sky, that is, by data base The content deleted is needed to delete in table, the structure of retention data storehouse table simultaneously, and content is deleted.
Further, before obtaining the interim table consistent with database table structure, interim table is created according to database table.
The interim table creating is consistent with the structure of database table, and including field name, type is consistent, index is consistent, gauge pressure Contracting mode one is made peace, and Primary key is consistent, and wherein, index includes clustered index and Nonclustered index.
Further, by handover operation, the data exchange of database table is included to interim table:Delete database table In data, by handover operation by the data exchange of database table in interim table after, to interim table execution remove behaviour Make.
The interim table structure set up is consistent with database table, but its content is empty, by the data exchange of database table While to interim table, the content pages of interim table are switched in database table, and in database table, the content of relevant position is sky, that is, Data in database table is deleted.If the data being switched in interim table is no longer necessary to retain, only need to will be direct for interim table Delete, it is achieved thereby that the content in database table is deleted, improve to data-handling efficiency in database table.
Present invention also offers a kind of data processing equipment of database table.
Fig. 3 is the schematic diagram of the data processing equipment of database table according to a first embodiment of the present invention.As illustrated, should Device includes acquiring unit 10 and switch unit 20.
Acquiring unit 10 is used for obtaining the interim table consistent with database table structure.The structure of tables of data includes field name Title, type etc., obtain the interim table consistent with data list structure and include obtaining and the field name of database table structure, type one Cause, index is consistent, table compress mode one is made peace, and Primary key is consistent, wherein, index includes clustered index and Nonclustered index.
In order to ensure not malfunction in data processing, set up the interim table consistent with database table structure.Wherein, quilt Storing in the database table processing needs data to be processed, and interim table can need processed number with the table of data storage storehouse According to.
Switch unit 20 be used for by handover operation by the data exchange of database table in interim table.
Handover operation can be for all data in database table it is also possible to for the partial data in database table. So-called handover operation is exactly to move on in interim table by the data in database table, can remove many data or data base simultaneously The entirety of table data removes, but, not log, it is not related to reading and writing data IO, when needing retention data database table structure Only the data in database table is processed.
By apparatus above, batch hand-off process can be carried out to the data in database table, improve data processing Efficiency, can preserve the table structure of database table simultaneously.
Fig. 4 is the schematic diagram of the data processing equipment of database table according to a second embodiment of the present invention.As illustrated, should The data processing equipment of database table includes acquiring unit 10 and switch unit 20, and wherein, switch unit 20 includes judge module 201st, shift module 202 and Switching Module 203.
Judge module 201 is used for judging whether database table has subregion.Database table partitioned storage data can improve number According to the performance in storehouse, therefore, in more complicated database table, often there is subregion, if database table has subregion, need first really Surely need data to be processed to be in which subregion, and the data in this subregion is processed.
The data being partitioned storage is physically multiple files, but remains a table, the operation to table in logic As before subregion, therefore, method provided in an embodiment of the present invention can also be applied in the database table after being partitioned.No By being the database table that is partitioned again without in the database table being partitioned, can be carried out the insertion of data, deletion, inquiry With operations such as renewals.Certainly, the embodiment of the present invention more concerned be database table data be delete.
Shift module 202 is used for when judging that database table has subregion, by handover operation by the subregion of database table It is transferred to from database table in interim table.
Before the data in database table is processed, first determine whether whether database table has subregion, if data Storehouse table has subregion, then the data needing the subregion carrying out data processing is transferred in interim table.During transfer, only turn Move the data needing subregion to be processed, corresponding data list structure is not changed to this subregion.Meanwhile, in blank interim table Empty content is switched in corresponding database table, it is achieved thereby that the switching of database table.
Switching Module 203 is used for when judging that database table does not have subregion, then pass through handover operation directly to data base Data in table and interim table swaps.If it is judged that there is no subregion in database table, can be directly in database table All data switch over operation.Corresponding with interim table for data in database table clear data is swapped, thus Achieve the switching of data.
In above process, due to being only the exchange of data, so just can complete in the very short time, such as 1 second. Therefore, in the deletion to data, improve the efficiency of data deletion.Simultaneously as the database table that is stored with interim table In data, data can be recovered in the case of delete by mistake.
Further, shift module 202 is additionally operable to change the configuration information of metadata in database table by handover operation By the data exchange of database table in interim table.
By handover operation, the metadata in database table is switched in interim table by atomic operation, will data Metadata in the table of storehouse is switched in interim table, and metadata corresponding position in database table is sky, that is, by data base The content deleted is needed to delete in table, the structure of retention data storehouse table simultaneously, and content is deleted.
Further, this data processing equipment also includes creating unit, and this creating unit is used in acquisition and database table Before the consistent interim table of structure, interim table is created according to database table.
The interim table creating is consistent with the structure of database table, and including field name, type is consistent, index is consistent, gauge pressure Contracting mode one is made peace, and Primary key is consistent, and wherein, index includes clustered index and Nonclustered index.
Further, the switch unit 20 of data processing equipment also includes removing module, and this removing module is used for deleting number According to the data in the table of storehouse, also include removing unit, for by handover operation by the data exchange of database table to interim table In after, to interim table execution remove operation.
The interim table structure set up is consistent with database table, but its content is empty, by the data exchange of database table While to interim table, the content pages of interim table are switched in database table, and in database table, the content of relevant position is sky, that is, Data in database table is deleted.If the data being switched in interim table is no longer necessary to retain, only need to will be direct for interim table Delete, it is achieved thereby that the content in database table is deleted, improve to data-handling efficiency in database table.
Obviously, those skilled in the art should be understood that each module of the above-mentioned present invention or each step can be with general Computing device realizing, they can concentrate on single computing device, or be distributed in multiple computing devices and formed Network on, alternatively, they can be realized with the executable program code of computing device, it is thus possible to they are stored To be executed by computing device in the storage device, or they be fabricated to each integrated circuit modules respectively, or by they In multiple modules or step be fabricated to single integrated circuit module to realize.So, the present invention be not restricted to any specific Hardware and software combines.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for the skill of this area For art personnel, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, made any repair Change, equivalent, improvement etc., should be included within the scope of the present invention.

Claims (8)

1. a kind of data processing method for database table is it is characterised in that include:
Obtain the interim table consistent with database table structure;And
By handover operation by the data exchange of described database table in described interim table,
Wherein, by handover operation, the data exchange of described database table is included to described interim table:
Judge whether described database table has subregion;
If it is judged that described database table has subregion, then by described handover operation by the subregion of described database table from described It is transferred in database table in described interim table;And
If it is judged that described database table does not have subregion, then by described handover operation directly to described database table and described Data in interim table swaps,
Empty content in blank interim table is switched in corresponding database table.
2. data processing method according to claim 1 is it is characterised in that by handover operation by described database table Data exchange includes to described interim table:
By the configuration information that described handover operation changes metadata in described database table, the data of described database table is cut Change in described interim table.
3. data processing method according to claim 1 is it is characterised in that obtaining face consistent with database table structure When table before, methods described also includes:
Described interim table is created according to described database table.
4. data processing method according to claim 1 is it is characterised in that by handover operation by described database table Data exchange includes to described interim table:Delete the data in described database table, by handover operation by described data After the data exchange of storehouse table is in described interim table, methods described also includes:
Described interim table is executed and removes operation.
5. a kind of data processing equipment for database table is it is characterised in that include:
Acquiring unit, for obtaining the interim table consistent with database table structure;And
Switch unit, for by handover operation by the data exchange of described database table in described interim table, described switching Unit includes:
Judge module, for judging whether described database table has subregion;
Shift module, for when judging that described database table has subregion, by described handover operation by described database table Subregion be transferred to from described database table in described interim table;And
Switching Module, for when judging that described database table does not have subregion, then passing through described handover operation directly to described Data in database table and described interim table swaps,
Empty content in blank interim table is switched in corresponding database table.
6. data processing equipment according to claim 5 is it is characterised in that described shift module is additionally operable to cut by described Change and operate the configuration information changing metadata in described database table by the data exchange of described database table to described interim table In.
7. data processing equipment according to claim 5 is it is characterised in that described data processing equipment also includes:
Creating unit, for, before obtaining the interim table consistent with database table structure, creating institute according to described database table State interim table.
8. data processing equipment according to claim 5 is it is characterised in that described data processing equipment includes:
Described switch unit also includes removing module, for deleting the data in described database table;And
Remove unit, for by handover operation by the data exchange of described database table in described interim table after, right Described interim table execution removes operation.
CN201310577207.0A 2013-11-18 2013-11-18 Data processing method and device applied to database table Active CN103593447B (en)

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 CN103593447A (en) 2014-02-19
CN103593447B true 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)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
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
CN110413593B (en) * 2019-06-19 2024-05-17 平安银行股份有限公司 Data migration method, device, computer equipment and storage medium
CN110333970B (en) * 2019-07-10 2021-09-07 中国民航信息网络股份有限公司 Data recovery method and device

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
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

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080120304A1 (en) * 2006-11-21 2008-05-22 Calio Robert J Method and system for providing high performance data modification of relational database tables

Patent Citations (5)

* Cited by examiner, † Cited by third party
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
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

Also Published As

Publication number Publication date
CN103593447A (en) 2014-02-19

Similar Documents

Publication Publication Date Title
CN103593447B (en) Data processing method and device applied to database table
CN102156751B (en) Method and device for extracting video fingerprint
CN106874348B (en) File storage and index method and device and file reading method
CN103593298B (en) Method for recovering internal storage and device
US20100114843A1 (en) Index Compression In Databases
CN102622185B (en) The method of storage file and storage allocation method in multiple storage unit
CN102129425B (en) The access method of big object set table and device in data warehouse
CN103246549B (en) A kind of method and system of data conversion storage
EP3438845A1 (en) Data updating method and device for a distributed database system
CN110928498B (en) Directory traversal method, device, equipment and storage medium
CN103617508A (en) Configurable business rule plug-in extension apparatus and business rule plug-in extension method
CN106294886A (en) A kind of method and system of full dose extracted data from HBase
CN106469152A (en) A kind of document handling method based on ETL and system
CN105653258A (en) Code processing method and apparatus
CN104965835A (en) Method and apparatus for reading and writing files of a distributed file system
CN104346347A (en) Data storage method, device, server and system
CN106020717B (en) Data processing method and electronic equipment
CA2702133A1 (en) Redistribute native xml index key shipping
CN104778252A (en) Index storage method and index storage device
CN103092955B (en) Checkpointed method, Apparatus and system
CN102780780B (en) Method, equipment and system for data processing in cloud computing mode
CN109558270A (en) Method and apparatus, the method and apparatus of data convert of data backup
US10761940B2 (en) Method, device and program product for reducing data recovery time of storage system
CN104298570A (en) Data processing method and device
CN101980195B (en) Mobile communication terminal-based database index repair method and device

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 GRIDSUM 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 GRIDSUM TECHNOLOGY Co.,Ltd.

Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A

Patentee before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd.

PP01 Preservation of patent right

Effective date of registration: 20240604

Granted publication date: 20170208