CN112732816A - Data export method and system - Google Patents
Data export method and system Download PDFInfo
- Publication number
- CN112732816A CN112732816A CN202110027235.XA CN202110027235A CN112732816A CN 112732816 A CN112732816 A CN 112732816A CN 202110027235 A CN202110027235 A CN 202110027235A CN 112732816 A CN112732816 A CN 112732816A
- Authority
- CN
- China
- Prior art keywords
- external
- information
- file
- response
- determining
- 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 OR CALCULATING; 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0602—Interfaces specially adapted for storage systems specifically adapted to achieve a particular effect
- G06F3/0608—Saving storage space on storage systems
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0628—Interfaces specially adapted for storage systems making use of a particular technique
- G06F3/0638—Organizing or formatting or addressing of data
- G06F3/0643—Management of files
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0668—Interfaces specially adapted for storage systems adopting a particular infrastructure
- G06F3/0671—In-line storage system
- G06F3/0683—Plurality of storage devices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Human Computer Interaction (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data export method and a system, wherein the method comprises the following steps: initializing metadata information of the metadata data in response to insertion of a general table of the database into the metadata data; detecting whether external table description information of an external file exists in response to receiving an insert command directed to write tuple data of the normal table to the external file of the writable external table; inserting an external file writable with the external table into the external table description information in response to determining that the external table description information exists; scanning and acquiring metadata in the common table to determine whether the metadata needs to be exported based on the metadata information; the metaset data is flushed to the disk file in response to determining that the metaset data needs to be exported. The invention can save storage and transmission resources and improve the overall efficiency of the system.
Description
Technical Field
The present invention relates to the field of artificial intelligence, and more particularly, to a method and system for exporting data.
Background
In the current big data era, greenplus (gp) as a big data analysis and processing platform for parallel computing needs to load massive data for analysis, and export a large amount of processed data to cooperate with other data platforms, so as to fully exert own advantages. In order to fully utilize the advantages of the MPP (massively parallel processing) architecture, parallel export of mass data can be realized through gpfdist (the file distribution program of greenplus) and external table technology. The write-only gpfdist external table can send the tables in the GP database to the gpfdist service process in parallel and store as a text format. When INSERT operation is executed on the write-only external table, each segment sends respective data to a gpfdist process, and after grouping the requests, the gpfdist writes the requests into a disk file according to the received sequence. When data is derived through a writable gpfdist external table, it is inevitable that an error occurs. If an error occurs, the file data that has been created will not be cleared, and when the data export of the table is performed again, all the data in the table will be re-exported again, which is very unfriendly, especially if most of the data has been exported. This not only causes time waste, but also causes that some data in the external file are actually duplicated, even duplicated or duplicated (every time data export is executed, all data in the table will be exported again), and further causes waste of storage space and disk input/output resources, which affects performance.
Aiming at the problems that data export content is repeated and resources are wasted in the prior art, so that the performance is influenced, no effective solution is available at present.
Disclosure of Invention
In view of this, an object of the embodiments of the present invention is to provide a data exporting method and system, which can save storage and transmission resources and improve the overall efficiency of the system.
In view of the above object, a first aspect of the embodiments of the present invention provides a data export method, including performing the following steps:
initializing metadata information of the metadata data in response to insertion of a general table of the database into the metadata data;
detecting whether external table description information of an external file exists in response to receiving an insert command directed to write tuple data of the normal table to the external file of the writable external table;
inserting an external file writable with the external table into the external table description information in response to determining that the external table description information exists;
scanning and acquiring metadata in the common table to determine whether the metadata needs to be exported based on the metadata information;
the metaset data is flushed to the disk file in response to determining that the metaset data needs to be exported.
In some embodiments, the metadata information includes header information and external data, the header information including an external file and an export flag bit;
the method further comprises the following steps: while initializing the metadata information of the tuple data, the external file of the header information is also reset and the flag of the export flag bit is cleared.
In some embodiments, the method further comprises: in response to determining that the external table description information does not exist, allocating memory to create the external table description information, and initializing and resetting the external file, the number of tuple attributes of the writable external table, and the converted text format data in the external table description information.
In some embodiments, inserting the external file of the writable external table into the external table description information comprises: the external file information writable with the external table is inserted into the external file reset in the external table description information.
In some implementations, determining whether the metadata data needs to be derived based on the metadata information includes:
determining that tuple data needs to be exported in response to determining that the external file of header information is reset;
determining that metadata needs to be exported in response to determining that the external file of the external table description information does not include external file information;
determining that the tuple data needs to be derived in response to determining that the derived flag bit of the header information is unmarked.
In some embodiments, the method further comprises: in response to a successful flush of the tuple data to the disk file, a flag is assigned to the derived flag bit of the header information to update the tuple data in the normal table.
In some embodiments, the method further comprises: in response to a failure to flush the tuple data to the disk file, re-waiting for receipt of the insert command.
A second aspect of an embodiment of the present invention provides a data export system, including:
a processor; and
a memory storing program code executable by the processor, the program code when executed performing the steps of:
initializing metadata information of the metadata data in response to insertion of a general table of the database into the metadata data;
detecting whether external table description information of an external file exists in response to receiving an insert command directed to write tuple data of the normal table to the external file of the writable external table;
inserting an external file writable with the external table into the external table description information in response to determining that the external table description information exists;
scanning and acquiring metadata in the common table to determine whether the metadata needs to be exported based on the metadata information;
the metaset data is flushed to the disk file in response to determining that the metaset data needs to be exported.
In some embodiments, the metadata information includes header information and external data, the header information including an external file and an export flag bit;
the method also comprises the following steps: when the metadata information of the metadata group data is initialized, the external file of the header information is reset and the mark of the export mark bit is cleared; in response to determining that the external table description information does not exist, allocating a memory to create the external table description information, and initializing and resetting an external file, the number of tuple attributes writable with the external table, and the converted text format data in the external table description information;
inserting the external file of the writable external table into the external table description information includes: the external file information writable with the external table is inserted into the external file reset in the external table description information.
In some implementations, determining whether the metadata data needs to be derived based on the metadata information includes: determining that tuple data needs to be exported in response to determining that the external file of header information is reset; determining that metadata needs to be exported in response to determining that the external file of the external table description information does not include external file information; determining that the tuple data needs to be derived in response to determining that the derived flag bit of the header information is unmarked.
The invention has the following beneficial technical effects: according to the data export method and system provided by the embodiment of the invention, the metadata information of the metadata is initialized by responding to the insertion of the common table of the database into the metadata; detecting whether external table description information of an external file exists in response to receiving an insert command directed to write tuple data of the normal table to the external file of the writable external table; inserting an external file writable with the external table into the external table description information in response to determining that the external table description information exists; scanning and acquiring metadata in the common table to determine whether the metadata needs to be exported based on the metadata information; in response to the technical scheme that the tuple data needs to be exported, the tuple data is refreshed on the disk file, so that the storage and transmission resources can be saved, and the overall efficiency of the system is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic flow chart of a data export method according to the present invention;
fig. 2 is a branch flow chart of the data export method provided by the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the following embodiments of the present invention are described in further detail with reference to the accompanying drawings.
It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are used for distinguishing two entities with the same name but different names or different parameters, and it should be noted that "first" and "second" are merely for convenience of description and should not be construed as limitations of the embodiments of the present invention, and they are not described in any more detail in the following embodiments.
In view of the foregoing, a first aspect of the embodiments of the present invention provides an embodiment of a data export method that saves storage and transmission resources and improves overall system efficiency. Fig. 1 is a flow chart illustrating a data export method provided by the present invention.
The data export method, as shown in fig. 1, includes the following steps:
step S101, in response to the insertion of the metadata into the common table of the database, the metadata information of the metadata is initialized;
step S103, in response to receiving an insertion command for writing tuple data of the ordinary table to an external file of the writable external table, detecting whether external table description information of the external file exists;
step S105, in response to determining that the external table description information exists, inserting an external file in which the external table can be written into the external table description information;
step S107, scanning and acquiring the metadata in the common table to determine whether the metadata needs to be exported based on the metadata information;
step S109, in response to determining that the tuple data needs to be exported, flushes the tuple data onto the disk file.
The invention aims to ensure the effective export of data, avoid the waste of storage space and the occupation of excessive input and output resources, save the export time of mass data, effectively reduce the unnecessary workload caused by network problems, insufficient equipment resources or artificial misoperation and improve the working efficiency.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), a Random Access Memory (RAM), or the like. Embodiments of the computer program may achieve the same or similar effects as any of the preceding method embodiments to which it corresponds.
In some embodiments, the metadata information includes header information and external data, the header information including an external file and an export flag bit; the method further comprises the following steps: while initializing the metadata information of the tuple data, the external file of the header information is also reset and the flag of the export flag bit is cleared.
In some embodiments, the method further comprises: in response to determining that the external table description information does not exist, allocating memory to create the external table description information, and initializing and resetting the external file, the number of tuple attributes of the writable external table, and the converted text format data in the external table description information.
In some embodiments, inserting the external file of the writable external table into the external table description information comprises: the external file information writable with the external table is inserted into the external file reset in the external table description information.
In some implementations, determining whether the metadata data needs to be derived based on the metadata information includes:
determining that tuple data needs to be exported in response to determining that the external file of header information is reset;
determining that metadata needs to be exported in response to determining that the external file of the external table description information does not include external file information;
determining that the tuple data needs to be derived in response to determining that the derived flag bit of the header information is unmarked.
In some embodiments, the method further comprises: in response to a successful flush of the tuple data to the disk file, a flag is assigned to the derived flag bit of the header information to update the tuple data in the normal table.
In some embodiments, the method further comprises: in response to a failure to flush the tuple data to the disk file, re-waiting for receipt of the insert command.
The following further illustrates embodiments of the invention in accordance with the specific example shown in fig. 2.
Referring to fig. 2, in step 1, when inserting tuple data into a normal table of a database, a record normal table information module is entered, in which information of the tuple, including header information and user data, is initialized. Here, the external file and the export flag bit in the header information of each tuple are set to 0, and then step 2 is performed;
entering a SQL command waiting module in the step 2, waiting for an INSERT command which can write an external table and input by a user in the module, writing the tuple of the common table into an external file by the command, executing the step 3 when the command is issued, and continuing to execute the step 2 and continuing to wait for the SQL command;
entering a module for detecting the external table description information in the step 3, judging whether the external table description information exists in the module, if not, entering the step 4, otherwise, entering the step 5;
entering an external table description information initialization module in step 4, wherein a memory is allocated to store external table description information, and external files, the tuple attribute number of the external table and the converted text format data in the description information are initialized to 0 (null), and then step 5 is executed;
entering an external table description information updating module in the step 5, wherein if the external file in the external table description information is null (0), the external file specified in the writable external table is opened, and the external file information is recorded in the corresponding external table description information, otherwise, the step 6 is executed without updating;
entering a module for obtaining the element groups of the common table in the step 6, sequentially scanning and obtaining each element group in the common table in the module, and then executing the step 7;
entering a module for detecting a common table tuple in the step 7, wherein in the module, firstly, whether an external file field in tuple header information is empty is detected, and if the external file field in the tuple header information is empty, entering a step 8; otherwise, detecting whether the external file in the external table description information is in the recorded external file information of the tuple, if not, entering step 8, if yes, finding the external disk file information of the current external table in the tuple header information, detecting whether the export marker bit of the tuple in the information is 0, if 0, entering step 8, and if not, returning to step 6;
entering a write-in external file module in the step 8, converting the tuple of the common table into a text format in the module, writing the tuple into a file, entering the step 9 if the tuple is successful, and returning to the step 2 if the tuple is not successful;
entering into a module for updating the ordinary table tuple in step 9, in the module, recording the external file defined in the currently writable external table into the header information of the tuple, and updating the export flag bit of the tuple to be 1, if the external file has been recorded by the tuple, finding the file to be written currently in all the external files recorded by the tuple, and setting the export flag bit of the tuple corresponding to the file to be 1.
As can be seen from the foregoing embodiments, the data export method provided by an embodiment of the present invention initializes metadata information of metadata by inserting the metadata in response to a general table of a database; detecting whether external table description information of an external file exists in response to receiving an insert command directed to write tuple data of the normal table to the external file of the writable external table; inserting an external file writable with the external table into the external table description information in response to determining that the external table description information exists; scanning and acquiring metadata in the common table to determine whether the metadata needs to be exported based on the metadata information; in response to the technical scheme that the tuple data needs to be exported, the tuple data is refreshed on the disk file, so that the storage and transmission resources can be saved, and the overall efficiency of the system is improved.
It should be particularly noted that, the steps in the embodiments of the data deriving method described above can be mutually intersected, replaced, added, or deleted, so that these reasonable permutation and combination transformations should also belong to the scope of the present invention, and should not limit the scope of the present invention to the described embodiments.
In view of the foregoing, a second aspect of the embodiments of the present invention provides an embodiment of a data export system that saves storage and transmission resources and improves overall efficiency of the system. The system comprises:
a processor; and
a memory storing program code executable by the processor, the program code when executed performing the steps of:
initializing metadata information of the metadata data in response to insertion of a general table of the database into the metadata data;
detecting whether external table description information of an external file exists in response to receiving an insert command directed to write tuple data of the normal table to the external file of the writable external table;
inserting an external file writable with the external table into the external table description information in response to determining that the external table description information exists;
scanning and acquiring metadata in the common table to determine whether the metadata needs to be exported based on the metadata information;
the metaset data is flushed to the disk file in response to determining that the metaset data needs to be exported.
In some embodiments, the metadata information includes header information and external data, the header information including an external file and an export flag bit;
the method also comprises the following steps: when the metadata information of the metadata group data is initialized, the external file of the header information is reset and the mark of the export mark bit is cleared; in response to determining that the external table description information does not exist, allocating a memory to create the external table description information, and initializing and resetting an external file, the number of tuple attributes writable with the external table, and the converted text format data in the external table description information; inserting the external file of the writable external table into the external table description information includes: the external file information writable with the external table is inserted into the external file reset in the external table description information.
In some implementations, determining whether the metadata data needs to be derived based on the metadata information includes: determining that tuple data needs to be exported in response to determining that the external file of header information is reset; determining that metadata needs to be exported in response to determining that the external file of the external table description information does not include external file information; determining that the tuple data needs to be derived in response to determining that the derived flag bit of the header information is unmarked.
As can be seen from the above embodiments, the system provided by the embodiments of the present invention initializes metadata information of metadata by inserting the metadata in response to a general table of a database; detecting whether external table description information of an external file exists in response to receiving an insert command directed to write tuple data of the normal table to the external file of the writable external table; inserting an external file writable with the external table into the external table description information in response to determining that the external table description information exists; scanning and acquiring metadata in the common table to determine whether the metadata needs to be exported based on the metadata information; in response to the technical scheme that the tuple data needs to be exported, the tuple data is refreshed on the disk file, so that the storage and transmission resources can be saved, and the overall efficiency of the system is improved.
It should be particularly noted that the embodiment of the system described above employs the embodiment of the data export method to specifically describe the working process of each module, and those skilled in the art can easily think that these modules are applied to other embodiments of the data export method. Of course, since the steps in the data deriving method embodiment can be mutually intersected, replaced, added, and deleted, these reasonable permutation and combination transformations should also belong to the scope of the present invention for the system, and should not limit the scope of the present invention to the embodiment.
The foregoing is an exemplary embodiment of the present disclosure, but it should be noted that various changes and modifications could be made herein without departing from the scope of the present disclosure as defined by the appended claims. The functions, steps and/or actions of the method claims in accordance with the disclosed embodiments described herein need not be performed in any particular order. Furthermore, although elements of the disclosed embodiments of the invention may be described or claimed in the singular, the plural is contemplated unless limitation to the singular is explicitly stated.
Those of ordinary skill in the art will understand that: the discussion of any embodiment above is meant to be exemplary only, and is not intended to intimate that the scope of the disclosure, including the claims, of embodiments of the invention is limited to these examples; within the idea of an embodiment of the invention, also technical features in the above embodiment or in different embodiments may be combined and there are many other variations of the different aspects of an embodiment of the invention as described above, which are not provided in detail for the sake of brevity. Therefore, any omissions, modifications, substitutions, improvements, and the like that may be made without departing from the spirit and principles of the embodiments of the present invention are intended to be included within the scope of the embodiments of the present invention.
Claims (10)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110027235.XA CN112732816B (en) | 2021-01-09 | 2021-01-09 | Data export method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110027235.XA CN112732816B (en) | 2021-01-09 | 2021-01-09 | Data export method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112732816A true CN112732816A (en) | 2021-04-30 |
| CN112732816B CN112732816B (en) | 2022-08-02 |
Family
ID=75590049
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110027235.XA Active CN112732816B (en) | 2021-01-09 | 2021-01-09 | Data export method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112732816B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362617A (en) * | 2019-06-24 | 2019-10-22 | 北京人大金仓信息技术股份有限公司 | Method and system for quickly exporting batch data from database based on multi-concurrency technology |
| US20190340171A1 (en) * | 2017-01-18 | 2019-11-07 | Huawei Technologies Co., Ltd. | Data Redistribution Method and Apparatus, and Database Cluster |
-
2021
- 2021-01-09 CN CN202110027235.XA patent/CN112732816B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190340171A1 (en) * | 2017-01-18 | 2019-11-07 | Huawei Technologies Co., Ltd. | Data Redistribution Method and Apparatus, and Database Cluster |
| CN110362617A (en) * | 2019-06-24 | 2019-10-22 | 北京人大金仓信息技术股份有限公司 | Method and system for quickly exporting batch data from database based on multi-concurrency technology |
Non-Patent Citations (2)
| Title |
|---|
| HUA LI 等: "《Metadata system modeling and testing》", 《2016 6TH INTERNATIONAL CONFERENCE ON ELECTRONICS INFORMATION AND EMERGENCY COMMUNICATION (ICEIEC)》 * |
| 徐曼: "《Oracle数据库的备份与恢复》", 《计算机应用》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112732816B (en) | 2022-08-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107391628B (en) | Data synchronization method and device | |
| CN112965939A (en) | File merging method, device and equipment | |
| CN111897828B (en) | Data batch processing implementation method, device, equipment and storage medium | |
| WO2021012932A1 (en) | Transaction rollback method and device, database, system, and computer storage medium | |
| CN114741449A (en) | Object storage method and device based on distributed database | |
| CN114281242B (en) | Memory load balancing method, device and equipment | |
| CN106021566A (en) | Method, device and system for improving concurrent processing capacity of single database | |
| CN112182028A (en) | Data line number query method and device based on table of distributed database | |
| CN111752941B (en) | Data storage and access method and device, server and storage medium | |
| CN112732816B (en) | Data export method and system | |
| CN112711627B (en) | Data importing method, device and equipment of Greemplum database | |
| CN112463880B (en) | A blockchain data storage method and related device | |
| CN110288340B (en) | A Data Collection Storage Method Based on Java Smart Contract | |
| CN110795915B (en) | XML file batch modification method, system, device and computer-readable storage medium | |
| CN100511152C (en) | Method for managing priority queue | |
| CN117235117A (en) | Data processing methods, devices, electronic equipment and storage media | |
| CN111638924B (en) | MapReduce data computing acceleration method and system | |
| CN113051301B (en) | Object storage method, system and equipment | |
| CN117194372A (en) | Data migration method, device, electronic equipment and storage medium | |
| CN114416090A (en) | A method and device for converting a single-page application framework Vue component | |
| CN115544321B (en) | Method and device for realizing graph database storage and storage medium | |
| CN113742133A (en) | Metadata recovery method, device and system and computer readable storage medium | |
| CN113721846B (en) | Method, system, equipment and medium for optimizing mechanical hard disk input and output performance | |
| CN117891400B (en) | Model simulation data storage method, device, equipment and storage medium | |
| CN118409716B (en) | Data writing management method, device and medium based on server super fusion |
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 | ||
| CP03 | Change of name, title or address |
Address after: Building 9, No.1, guanpu Road, Guoxiang street, Wuzhong Economic Development Zone, Wuzhong District, Suzhou City, Jiangsu Province Patentee after: Suzhou Yuannao Intelligent Technology Co.,Ltd. Country or region after: China Address before: Building 9, No.1, guanpu Road, Guoxiang street, Wuzhong Economic Development Zone, Wuzhong District, Suzhou City, Jiangsu Province Patentee before: SUZHOU LANGCHAO INTELLIGENT TECHNOLOGY Co.,Ltd. Country or region before: China |
|
| CP03 | Change of name, title or address |