Method and system for screening and transferring organizational data during corporate split

By selecting an appropriate system separation construction method and exporting and importing the target database, the problem of organizational data transfer in corporate mergers and acquisitions was solved, achieving efficient and secure data transmission and business continuity.

CN116670665BActive Publication Date: 2026-04-14ARMIQ CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-08-20
Publication Date
2026-04-14

AI Technical Summary

Technical Problem

During corporate mergers and acquisitions, existing technologies are insufficient for accurately screening and transferring organizational data, making it difficult to maintain business continuity and posing issues of data security and downtime.

Method used

By selecting the system separation construction method from the cleanup or migration methods, and considering factors such as downtime of object data, data security, storage costs, and differences in database systems, a suitable system separation method is selected, and the data is exported and imported into the target database for extraction and transfer.

Benefits of technology

It enables efficient data transfer to the organization while ensuring data security and minimizing downtime, thus guaranteeing business continuity and data integrity.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116670665B_ABST
    Figure CN116670665B_ABST
Patent Text Reader

Abstract

A method and system for screening and transferring organization data at the time of enterprise split are disclosed. An organization data transfer method of one embodiment can include exporting a system schema for a first database of a first organization from the first database of the first organization, which includes second organization-oriented transfer target data of the first organization, constructing a second database of a second organization in a system of the second organization as a target database for the transfer target data by importing the exported system schema to the system of the second organization, extracting the transfer target data from the first database, and transferring the extracted transfer target data to the second database of the second organization.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to a method and system for screening and transferring organizational data during corporate restructuring. Background Technology

[0002] In recent years, there has been a surge in mergers and acquisitions (M&A) between overseas and domestic companies. M&A is becoming a key term in business operations and is attracting considerable attention.

[0003] Enterprises can leverage external resources to continuously pursue growth and development, and enjoy the benefits of shortened entry times into new markets, avoidance of friction with existing market players, increased market dominance, and the introduction of advanced technologies. Furthermore, to adapt to environmental changes, mergers and acquisitions (M&A) activities are gradually increasing, involving the restructuring and sale of existing marginal enterprises and the acquisition of businesses to secure new business momentum.

[0004] In this scenario, the acquiring company will request the transfer of the seller's IT systems to ensure the continued business continuity of the acquiring organization, while the seller will prefer that its own organizational data, which is not intended for sale, not be transferred as business assets. Therefore, the demand for technologies that can accurately filter, separate, transfer, and transform large amounts of data within a system according to specific requirements is increasing. Summary of the Invention

[0005] Technical issues

[0006] This invention provides an organizational data transfer method and system that utilizes migration to transfer data.

[0007] This invention provides a method and system for transferring organizational data, which can transfer organizational data by selecting a system separation and construction method that meets the conditions from cleaning and migration methods.

[0008] Technical solution

[0009] The present invention provides a method for organizing data transfer, executed in a computer device including at least one processor, characterized by comprising the following steps:

[0010] Using at least one of the aforementioned processors, a system separation construction method is selected, wherein the selected method is either a cleanup method or a migration method, and the selection is based on at least one of the following: the downtime of the transferred object data, the required data security, storage costs, and whether the operating system and database management system of the system used for the first database of the first organization and the system used for the second database of the second organization are the same, and wherein the system separation construction method is selected in one of the following ways:

[0011] In response to the relatively large volume of the aforementioned transfer objects and / or with a priority to minimize downtime, the aforementioned system separation construction method was selected as the cleanup method;

[0012] In response to the priority given to data security, the aforementioned system separation construction method was selected as the migration method;

[0013] In response to the fact that the system used for the first database is different from the system used for the second database, the separate construction method of the system is selected as the migration method;

[0014] In response to the selection of the above migration method as the separate construction method for the above system,

[0015] The system architecture of the first database is derived from the first database of the first organization that includes the object data, using at least one of the processors described above;

[0016] By using at least one of the processors described above, the exported system architecture is imported into the system of the second organization, and the second database of the second organization is generated in the system of the second organization. The second database is the target database to which the object data is to be transferred.

[0017] The object data is extracted from the first database using at least one of the aforementioned processors; and

[0018] The extracted object data is transmitted to the second database of the second organization via at least one of the processors described above.

[0019] In response to the selection of the above cleanup method as the separate construction method for the above system,

[0020] The third database is generated by copying the first database using at least one of the aforementioned processors;

[0021] Using at least one of the aforementioned processors, a fourth database is generated by cleaning up data from the third database that has not been migrated from the first organization to the second organization; and

[0022] The generated fourth database is provided to the second organization by at least one of the processors described above.

[0023] According to one embodiment, the present invention is characterized in that the system architecture described above may include at least one of the table structures, computer programs, and processes used in the system of the first database described above.

[0024] According to another embodiment, the present invention is characterized in that the above extraction step may include the following steps: using the structure of the first organization and the structure of the second organization to be divided from the first organization, the migration conditions of the transfer object data are determined at at least one of the company code level, business area level and factory level.

[0025] According to another embodiment, the present invention is characterized in that the above extraction step may further include the following step: filtering the data based on the above migration conditions of the above-mentioned transfer object data by mapping objects corresponding to specific company codes at the above-mentioned company code level, specific business areas at the above-mentioned business area level, or specific factories at the above-mentioned factory level.

[0026] According to another embodiment, the above-described organizational data transfer method may further include the following step: deleting data corresponding to the transfer object data extracted from the first database by at least one processor.

[0027] The present invention provides a computer program stored in a computer-readable recording medium that, when combined with a computer device, executes the above-described methods in the computer device.

[0028] The present invention provides a computer-readable recording medium having a computer program recorded thereon for performing the above-described method in a computer device.

[0029] This invention provides a system for organizing data transfer, characterized in that it includes at least one processor for executing readable instructions in a computer.

[0030] At least one of the processors is configured to select a system separation build method, wherein the selected method is either a cleanup method or a migration method, and the selection is based on at least one of the following: the downtime of the transferred object data, the required data security, storage costs, and whether the operating system and database management system of the system used for the first database of the first organization and the system used for the second database of the second organization are the same, and wherein the system separation build method is selected in one of the following ways:

[0031] In response to the relatively large volume of the aforementioned transfer objects and / or with a priority to minimize downtime, the aforementioned system separation construction method was selected as the cleanup method;

[0032] In response to the priority given to data security, the aforementioned system separation construction method was selected as the migration method;

[0033] In response to the fact that the system used for the first database is different from the system used for the second database, the separate construction method of the system is selected as the migration method;

[0034] In response to selecting the above migration method as the above system decoupling construction method, the at least one processor is further configured as follows:

[0035] The system architecture of the first database is derived from the first database of the first organization that includes the aforementioned object data;

[0036] By importing the exported system architecture into the system of the second organization, the second database of the second organization is generated in the system of the second organization. The second database is the target database to which the object data is to be transferred.

[0037] Extract the object data from the first database; and

[0038] The extracted object data is transmitted to the second database of the second organization.

[0039] In response to selecting the above-mentioned cleanup method as the above-mentioned system decoupling construction method, the at least one processor is further configured to

[0040] The third database is generated by copying the first database described above;

[0041] A fourth database is generated by cleaning up data from the third database that was not migrated from the first organization to the second organization; and

[0042] The generated fourth database is provided to the second organization.

[0043] The effects of the invention

[0044] This invention allows for the transfer of data using a migration method.

[0045] This invention allows for the transfer of organizational data by selecting a suitable system separation and construction method from the cleanup and migration methods. Attached Figure Description

[0046] Figure 1 A diagram illustrating an example of a network environment according to an embodiment of the present invention.

[0047] Figure 2 A block diagram illustrating an example of a computer device according to an embodiment of the present invention.

[0048] Figure 3 The diagram illustrates an example of the overall architecture and process of tissue separation according to an embodiment of the present invention.

[0049] Figure 4An example of an organizational structure according to an embodiment of the present invention is shown.

[0050] Figure 5 An example of the definition of an organizational structure and an example of the definition of migration conditions according to an embodiment of the present invention are shown.

[0051] Figure 6 The figure illustrates an example of a cleaning method according to an embodiment of the present invention.

[0052] Figure 7a The figure illustrates an example of a migration method according to an embodiment of the present invention.

[0053] Figure 7b The figure illustrates another example of a migration method according to an embodiment of the present invention.

[0054] Figure 8 A diagram illustrating an example of a business object according to an embodiment of the present invention.

[0055] Figure 9 The diagram illustrates an example of classifying business objects into application domains according to an embodiment of the present invention.

[0056] Figure 10 A diagram illustrating an example of the process of constructing a handover scenario according to an embodiment of the present invention.

[0057] Figure 11 A diagram illustrating an example of extracting transfer object data according to an embodiment of the present invention.

[0058] Figure 12 and Figure 13 A diagram illustrating an example of data transmission according to an embodiment of the present invention.

[0059] Figure 14 A flowchart illustrating an example of an organizational data transfer method according to an embodiment of the present invention.

[0060] Figure 15 A diagram illustrating an example of a data deletion process according to an embodiment of the present invention. Best practice

[0061] This invention can be modified in many ways and has many embodiments. Specific embodiments will be illustrated in the accompanying drawings and described in detail in the description. However, this is not intended to limit the invention to specific implementations, but should be understood to include all modifications, equivalent technical solutions, and even alternative technical solutions within the scope of the invention's concept and technology. Similar reference numerals are used for similar structural elements in the description of the various drawings.

[0062] The terms “first,” “second,” “A,” and “B,” etc., can be used to describe various structural elements, but the aforementioned structural elements should not be limited to these terms. These terms are used only for the purpose of distinguishing one structural element from other structural elements. For example, without departing from the scope of the invention claims, a first structural element may be named a second structural element, and similarly, a second structural element may be named a first structural element. The term “and / or” includes a combination of multiple related descriptions or any one of multiple related descriptions.

[0063] When a structural element is mentioned as being "connected" or "linked" to other structural elements, although it may be directly connected or linked to these other structural elements, it should be understood that other structural elements may also exist in between. Conversely, when a structural element is mentioned as being "directly connected" or "directly linked" to other structural elements, it should be understood that no other structural elements exist in between.

[0064] The terminology used in this application is for illustrative purposes only and is not intended to limit the invention. Unless the context clearly indicates otherwise, singular expressions include plural expressions. In this application, terms such as "comprising" or "having" refer to the presence of features, numbers, steps, actions, structural elements, accessories, or combinations thereof as described in the specification, and should not be construed as pre-excluding the presence or additional possibilities of one or more other features, numbers, steps, actions, structural elements, accessories, or combinations thereof.

[0065] Unless otherwise defined, all terms used in this specification, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains. Multiple terms whose commonly used meanings are the same as those defined in dictionaries should be interpreted as having the same meaning as the related art in the context of this document, and should not be interpreted in an idealized or overly formalized sense unless explicitly defined in this application.

[0066] Hereinafter, embodiments will be described in detail with reference to the accompanying drawings.

[0067] The tissue data screening and separation system of this invention can be implemented by at least one computer device, and the tissue data screening and separation method of this invention can be executed by at least one computer device included in the tissue data screening and separation system. A computer program of this invention can be installed and driven in the computer device, and the computer device can execute the tissue data screening and separation method of this invention according to the control of the driven computer program. The aforementioned computer program can be stored in a computer-readable recording medium that executes the tissue data screening and separation method in the computer device by being combined with the computer device.

[0068] Figure 1A diagram illustrating an example of a network environment according to an embodiment of the present invention. Figure 1 The network environment shown is an example including multiple electronic devices 110, 120, 130, 140, multiple servers 150, 160, and a network 170. The above... Figure 1 For the purpose of illustrating the present invention, the number of electronic devices or servers is not limited. Figure 1 .and, Figure 1 The network environment described is merely an example of an environment applicable to this embodiment, and the environment applicable to this embodiment is not limited to this one. Figure 1 The network environment.

[0069] Multiple electronic devices 110, 120, 130, and 140 can be fixed or mobile terminals manifested through computer devices. For example, the multiple electronic devices 110, 120, 130, and 140 include smartphones, mobile phones, navigators, computers, laptops, digital broadcasting terminals, personal digital assistants (PDAs), portable multimedia players (PMPs), tablet computers, etc. As an example, Figure 1 The image shows the shape of a smartphone as an example of electronic device 110, but in embodiments of the invention, electronic device 110 may actually be one of various physical computer systems that communicate with other electronic devices 120, 130, 140 and / or servers 150, 160 via a network 170 using wireless or wired communication methods.

[0070] The communication method is not limited and may include communication methods using communication networks (e.g., mobile communication networks, wired networks, wireless networks, broadcast networks) that may be included in network 170, as well as short-range wireless communication between multiple devices. For example, network 170 may include any one or more of the following networks: personal area network (PAN), local area network (LAN), campus area network (CAN), metropolitan area network (MAN), wide area network (WAN), broadband network (BBN), and the Internet. Furthermore, network 170 may include any one or more of the following network topologies, but is not limited to: bus network, star network, ring network, mesh network, star-bus network, tree network, and hierarchical network.

[0071] Servers 150 and 160 can be computer devices or multiple computer devices that communicate with multiple electronic devices 110, 120, 130, and 140 via network 170 to provide instructions, code, files, content, services, etc. For example, server 150 can be a system that provides services (such as archiving services, file publishing services, map services, content services, group call services (or voice conferencing services), information services, email services, social networking services, translation services, financial services, settlement services, retrieval services, etc.) to multiple electronic devices 110, 120, 130, and 140 accessed via network 170.

[0072] Figure 2 This is a block diagram illustrating an example of a computer device according to an embodiment of the present invention. The aforementioned plurality of electronic devices 110, 120, 130, 140 or plurality of servers 150, 160 can be accessed via... Figure 2 The computer device 200 shown in the figure implements this.

[0073] like Figure 2 As shown, this computer device 200 may include a memory 210, a processor 220, a communication interface 230, and an input / output interface 240. The memory 210, as a computer-readable recording medium, may include random access memory (RAM), read-only memory (ROM), and permanent mass storage devices such as hard disk drives. ROM and hard disk drives are separate permanent storage devices distinct from the memory 210, but may also be included in the computer device 200. Furthermore, the memory 210 may store an operating system and at least one program code. These software structural elements may be loaded into the memory 210 from a separate computer-readable recording medium independent of the memory 210. This separate computer-readable recording medium may include floppy disk drives, hard disks, magnetic tapes, DVD / CD-ROM drives, memory cards, and other computer-readable recording media. In another embodiment, the software structural elements may also be loaded into the memory 210 via the communication interface 230, without using a computer-readable recording medium. For example, software structural elements may be loaded into the memory 210 of computer device 200 based on a computer program installed from a file received via network 170.

[0074] Processor 220 can perform basic calculations, logic, and input / output operations, and can thus process instructions of computer programs. Instructions can be provided to processor 220 via memory 210 or communication interface 230. For example, processor 220 can execute received instructions according to program code stored in a storage device such as memory 210.

[0075] The communication interface 230 provides the function of enabling the computer device 200 to communicate with other devices (such as the aforementioned multiple storage devices) via the network 170. For example, the processor 220 of the computer device 200 can, under the control of the communication interface 230, transmit requests or instructions, data, files, etc., generated according to program code stored in storage devices such as the memory 210, to other devices via the network 170. Conversely, signals, instructions, data, files, etc., provided from other devices can be provided to the computer device 200 via the communication interface 230 through the network 170. Signals or instructions, data, etc., received through the communication interface 230 can be transmitted to the processor 220 or the memory 210, and files, etc., can be stored in the storage medium (the aforementioned permanent storage devices) also included in the computer device 200.

[0076] The input / output interface 240 can be a unit for interfacing with the input / output device 250. For example, the input device may include a microphone, keyboard, or mouse, and the output device may include a display, speaker, or other similar devices. Alternatively, the input / output interface 240 can also be a unit for interfacing with a device that integrates input and output functions, such as a touchscreen. The input / output device 250 can also be integrated with the computer device 200 into a single device.

[0077] Furthermore, in other embodiments, the computer device 200 may also include a larger... Figure 2 The structure may have fewer or more structural elements. However, it is not necessary to clearly show most of the structural elements of the prior art. For example, the computer device 200 may be implemented to include at least a portion of the input / output devices 250 described above, or may also include other structural elements such as a radio transceiver, a database, etc.

[0078] Figure 3 The diagram illustrates an example of the overall architecture and process of tissue separation according to an embodiment of the present invention. Figure 3 The tissue separation process in the embodiments can be achieved by... Figure 2 The computer device 200 described herein shall perform the operation. The computer device 200 may be a physical device for transferring transfer data of a first organization to a second organization via a relay system.

[0079] In step 310, the computer device 200 may define a separation baseline and a separation method. The separation method may correspond to the system separation construction method described later. This step 310 may include: step 311, defining the handover object organization; step 312, determining the system separation construction method; and step 313, designing and constructing the system architecture.

[0080] In step 311, computer device 200 may define the transfer object organization. (See reference...) Figure 4 and Figure 5 This will explain in more detail the method for defining the organization of the objects to be transferred.

[0081] As an example, Figure 4 An example of an organizational structure according to an embodiment of the present invention is shown. Original data 410 (Origin) shows an example of an organizational structure for division or sale. In original data 410 (Origin), it is assumed that data for two companies, C100 and C200, are managed through System A. Furthermore, it is assumed that the first company C100 comprises three business areas B100, B200, and B300; the first business area B100 includes a first factory P100 and a second factory P110; the second business area B200 includes a third factory P200; and the third business area B300 includes a fourth factory P300.

[0082] In this case, Company Code Level 420 illustrates an example of separating an organization from the original data 410 based on its company code. More specifically, the data of the first company, C100, can be transferred, and the data of the second company, C200, can be deleted.

[0083] Furthermore, Business Area Level 430 (B / A Level) illustrates an example of separating organizations from the Origin data 410 based on Business Area (B / A). More specifically, data from the first Business Area B100 may be transferred, while data from the remaining areas (Second Company C200, Second Business Area B200, and Third Business Area B300) may be deleted.

[0084] Furthermore, Plant Level 440 illustrates an example of separating an organization from the Origin based on the Plant. More specifically, the data of the first Plant P100 can be transferred, while the data of the remaining Plants (Second Company C200, Second Business Area B200, Third Business Area B300, and Second Plant P110) can be deleted.

[0085] For the transferee organization, the computer device 200 can define the transferee organization by receiving information that classifies the transferee organization according to at least one of the systems, business areas, and plants.

[0086] Figure 5 An example of the definition of an organizational structure and an example of the definition of migration conditions according to an embodiment of the present invention are shown. Figure 5 Tables 510, 520, and 530 show the breakdown based on business area. Figure 4 This is an example of defining migration conditions when migrating the original data 410 (Origin) to the business domain level 430 (B / A Level). That is, as shown in the first table 510, the computer device 200 can... Figure 4 In Company Code Level 420, company code "C100" is defined as a migration target, while "C200" and "C300" are defined as non-migration targets. Furthermore, as shown in Table 520 (Second Table), in Business Area Level 430 (B / A Level), computer device 200 can define business area "B100" as a migration target, while "B200" and "B300" are defined as non-migration targets. Also, as shown in Table 530 (Third Table), in Business Area Level 430 (B / A Level), computer device 200 can define factories "P100" and "P110" as migration targets, while "P200" and "P300" are defined as non-migration targets.

[0087] Refer again Figure 3 In step 312, the computer device 200 can determine the system separation construction method. As examples of methods for physically separating and constructing the system, a cleaning method and a migration method can be used. For example, the cleaning method involves deleting all data from the seller's organization's data except for the data to be transferred to the buyer's organization before transferring it. This method is suitable for situations where the volume of the transfer target data is large and downtime needs to be minimized. Downtime can refer to the time the system cannot be used due to the system separation construction. On the other hand, the migration method involves extracting and transferring the data to be transferred to the buyer's organization from the seller's organization's data. This method is suitable for situations where the volume of the transfer target data is small and data security is a priority. In other words, the computer device 200 can consider various factors such as the organization's separation period, the transfer target, and the system location to determine the method of physical system separation as either a cleaning method or a migration method. (See reference...) Figure 6 Figure 7 will explain the cleaning and migration methods in more detail.

[0088] In step 313, the computer device 200 may design and configure a system architecture. The system architecture may include the target system and / or the target system's database, which becomes the object of data transfer. (See also...) Figure 6 Figure 7 will illustrate the process of designing and configuring the system architecture in more detail.

[0089] Figure 6This diagram illustrates an example of a cleanup method according to an embodiment of the present invention. As described above, a cleanup method and a migration method can be used to physically separate the system. The cleanup method can be performed by deleting data other than that of the seller organization. The cleanup method can be used when the volume of the transfer object is relatively large and / or when minimizing downtime is a priority. For this purpose, the computer device 200 can generate a second database 620 by copying a first database 610 containing the transfer object data of a first organization. In this case, the computer device 200 can receive conditions for deleting objects and filter data by mapping the conditions for deleting objects to business objects in the second database 620. Furthermore, the computer device 200 can extract the filtered data from the second database 620 and generate a third database 630 to be transferred by deleting data matching the extracted data from tables within the second database 620. On the other hand, the extracted data can be stored as a file 640.

[0090] In this cleanup method, the system architecture of the third database 630 of the third organization is formed by copying the first database 610 of the first organization from the second database 620. Since the third database 630 can be generated by deleting non-transfer data from the second database, it can be automatically transferred to and built to the second organization.

[0091] Figure 7a The figure illustrates an example of a migration method according to an embodiment of the present invention. The migration method can be performed by transferring data from a seller organization. In this case, the migration method can be used when the volume of the transfer object is relatively large and / or data security is a priority. For this purpose, computer device 200 can generate a second database 720 by copying a first database 710 of the first organization, in which the transfer object data of the first organization to the second organization is contained. In this case, to construct a system architecture, computer device 200 can export a system architecture for the second database 720. The system architecture may include at least one of the table structures, computer programs, and processes used in the system of the second database 720. In the target system (the system of the second organization) for receiving the transfer object data, a third database 730 should be prepared to be in a data-free state in order to receive the transfer object data. In this case, since the basic database environment driving the target system is required, computer device 200 can import the exported system architecture into the third database 730. As another example, computer device 200 can build a system architecture by transmitting the third database 730 to a second organization after generating a third database 730 by deleting all data from the copied second database 720.

[0092] Subsequently, the computer device 200 can retrieve the transfer object data from the second database 720, and can perform the migration by transmitting the retrieved transfer object data to the third database 730 of the second organization. In this case, the transfer object data retrieved from the second database 730 can be stored in a separate file 740 or a table 750 of the database, and then transmitted to the third database 730.

[0093] Figure 7b The figure illustrates another example of a migration method according to an embodiment of the present invention. According to the embodiment, in this migration method, the transfer target data can also be directly transferred from the database of the first organization to the database of the target system (the system of the second organization), without copying the database of the first organization. (The following will be...) Figure 7b The embodiments illustrate the process of transferring data without copying the database of the first organization.

[0094] Computer device 200 can directly transfer transfer object data from a first database 710 of the first organization, which contains transfer object data from the first organization to the second organization, to a third database 730 of the second organization. First, to construct the system architecture, computer device 200 can export a system architecture for the first database 710. This system architecture may include at least one of the table structures, computer programs, and processes used in the system of the first database 710. In the target system (the system of the second organization) used to receive the transfer object data, the third database 730 should be prepared to be in a data-free state in order to receive the transfer object data. In this case, since the basic database environment driving the target system is required, computer device 200 can import the exported system architecture into the third database 730.

[0095] Subsequently, the computer device 200 can extract the transfer object data from the first database 710, and the migration can be performed by transmitting the extracted transfer object data to the third database 730 of the second organization. In this case, the transfer object data extracted from the first database 710 can be stored in a separate file 740 or a table 750 of the database, and then transmitted to the third database 730.

[0096] Since cleanup involves deleting data and transferring it immediately, it can be done online, while migration can be done offline.

[0097] In one embodiment, the source system, including the first databases 610 and 710 of the first organization, may be located in an on-premise environment, while the target system, including the third databases 630 and 730 of the second organization, may be located in a cloud environment. In another embodiment, both the source system and the target system may be located in an on-premise environment. In yet another embodiment, both the source system and the target system may be located in a cloud environment.

[0098] Even with different operating systems and database management systems (DBMS), migration methods can be used for cross-platform migration, thus being independent of the target system's environment. However, downtime due to migration should be considered based on the target system's location and environment.

[0099] Refer again Figure 3 In step 320, the computer device 200 can analyze the data. The data may include data from a copied database (for example, a second database 620, 720). In step 320, after grouping the data based on the hierarchical relationship between tables, the computer device 200 can classify the data by considering its type and characteristics, thereby modularizing the data according to its intended use through selection, combination, exclusion, etc.

[0100] This step 320 may include: step 321, analyzing the table; step 322, defining the object; step 323, classifying the object; and step 324, analyzing by mapping the object and company code.

[0101] In step 321, the computer device 200 can analyze the table. The computer device 200 can analyze the tables of the database that have been copied for data grouping and classification. In this case, the computer device 200 can analyze the table size, number of table entries, table fields, field data distribution, data missing value ratio, and field usage (WUL.where-used-list) of each domain. Furthermore, the computer device 200 can analyze the dependencies between tables, the distinction between titles and items in the dependency relationship, the organization within each table, time, creator, and the existence of characteristic fields. In addition, the computer device 200 can analyze the table's (1) application domain (=module), (2) host, transaction, structure, system, and other type classifications, and (3) voucher, statistics, history, log, and other characteristics.

[0102] In step 322, the computer device 200 can define objects. For example, the computer device 200 can define multiple tables (table groups) bound together based on the dependency relationship between tables as objects. An object, as the smallest unit of process handling, can consist of more than one table. For example, the smallest unit of process handling can be a material master, customer master, price terms, customer credit, sales order, payment request, financial invoice, account balance, profitability analysis, interface login, user login history, etc., but is not limited to these. For example, the smallest unit of process handling can be changed according to the characteristics of the organization. Figure 8 and Figure 9 This will provide a more detailed description of the object.

[0103] Figure 8 A diagram illustrating an example of a business object according to an embodiment of the present invention. Figure 8 The diagram shows: Business object 1 (Object#1), including Table 1 (Table#1), Table 2 (Table#2), and Table 3 (Table#3); Business object 2 (Object#2), including Table 4 (Table#4) and Table 5 (Table#5); and Business object 3 (Object#3), including Table 6 (Table#6). It is known that Table 1 (Table#1), Table 2 (Table#2), and Table 3 (Table#3) have dependent attributes, and Table 4 (Table#4) and Table 5 (Table#5) also have dependent attributes. Such business objects are based on the dependent attributes between tables within a database and can be obtained by grouping the data contained in the database into the smallest processing unit. For example, computer device 200 can group multiple tables with dependent attributes in a database (for example, second databases 620 and 720) into a single object, and multiple objects can be defined according to the database. The dependent attributes between tables can mean that two tables each include data identified by the same key value. In this case, the data identified by the same key value in multiple tables with dependent attributes can include at least one different field.

[0104] Figure 9 The diagram illustrates an example of classifying business objects into application domains according to an embodiment of the present invention. Figure 9 This example illustrates how business object 1 (Object #1) and business object 2 (Object #2) are classified as Application Area 1, and business object 3 (Object #3) is classified as Application Area 2. Application areas can be categorized as production, sales, materials, financial accounting, management accounting, infrastructure, communications, industry, etc., and can be defined in various ways depending on the enterprise's settings for maintaining and managing the database.

[0105] Refer again Figure 3 In step 323, the computer device 200 may classify the objects. In this case, the computer device 200 may classify the objects according to modules, types, and / or characteristics.

[0106] The relevant content of the modules has been described above, and the objects can correspond to the application domain. In order to classify objects by module, the computer device 200 can group objects by module in a manner consistent with each program. For example, the computer device 200 can classify objects according to production, sales, materials, financial accounting, management accounting, infrastructure, communications, industry, etc.

[0107] The type of object can mean host data, transaction data, structured data, control data, system data, etc. For example, if the data of the corresponding object is the data that serves as the basis for data occurrence, the computer device 200 can classify it as host data; if the data of the corresponding object is data that occurs continuously due to time, organization, etc., the computer device 200 can classify it as transaction data.

[0108] The characteristics of an object can be categorized as follows: a document that signifies a continuous transaction such as a voucher or order; a status that records the current production status of a product; a history that stores changes to files such as documents; and a summary that records the total transaction amount of a customer over a specified period.

[0109] In step 324, computer device 200 can perform analysis using mapping objects and company codes. In this case, computer device 200 can simulate matching by performing data missing measurement analysis on the transfer object organization defined in step 311 and the objects defined in step 322, thereby selecting the transfer object field in the benchmark table within the object.

[0110] More specifically, the computer device 200 can select fields within a table to serve as the basis for the transfer. Field selection can be achieved using data values, missing data rates, etc. Table 1 shows an example of selecting the most suitable field by analyzing the missing data rate.

[0111] Table 1

[0112]

[0113] Furthermore, Table 2 shows an example of calculating the number of transfer object data items by analyzing the number of data items for each organization code within the analysis field.

[0114] Table 2

[0115]

[0116] according to Figure 5 Table 520, the second data row in Table 2, is shown as an example of identifying the second data row as the transfer object because business area "B100" is the transfer object. In step 330, computer device 200 can retrieve the data. Figure 3 In the embodiments described, an example of transferring data via migration is illustrated. In this case, step 330 may include: step 331, constructing a transfer scenario; step 332, extracting transfer object data; and step 333, compressing and storing the transfer object data.

[0117] In step 331, the computer device 200 can construct a handover scenario.

[0118] Figure 10 A diagram illustrating an example of the process of constructing a handover scenario according to an embodiment of the present invention.

[0119] In step 1010, the computer device 200 can construct objects. For example, the computer device 200 can construct relationships between objects and tables within those objects. In this case, when an object consists of multiple tables, the computer device 200 can construct an object including a header table that can serve as a base and item tables with hierarchical relationships. Furthermore, when an object consists of a single table, the computer device 200 can construct the object independently, regardless of the relationships between the tables. This step 1010 may include: step 1011, defining the object; step 1012, constructing relationships between the object and the tables; step 1013, constructing relationships between objects; and step 1014, defining exception handling rules.

[0120] In step 1011, the computer device 200 may define an object name and a description of the object.

[0121] In step 1012, the computer device 200 can construct relationships between objects and tables. As an example, when an object consists of multiple tables, the computer device 200 can use Structured Query Language (SQL) conditions to express the relationships between the tables.

[0122] In step 1013, the computer device 200 can construct relationships between objects. When individual objects are combined under a condition, the computer device 200 can distinguish them into title objects and item objects, expressing them using relationships. These relationships between objects can be used when, after extracting object data from one object, it is necessary to use the extracted object data to extract the corresponding object's subordinate objects.

[0123] In step 1014, the computer device 200 may define exception handling rules. When it is necessary to append and / or remove data according to the individual tables within an object, the computer device 200 may use such exception handling rules to append and / or remove data.

[0124] In step 1020, the computer device 200 may generate a scene. This step 1020 may include: step 1021, defining a set of objects; step 1022, mapping objects and handover conditions; and step 1023, defining the job processing order.

[0125] In step 1021, computer device 200 may define an object set. A scenario can be defined by a set of objects that become migration objects. For example, computer device 200 can uniformly construct an object set as a scenario by treating all objects as objects, or it can define scenarios separately according to individual business characteristics such as financial or sales data. Such scenarios are repeatable and can serve as units for future migration operations.

[0126] In step 1022, the computer device 200 can map objects and transfer conditions. For example, the computer device 200 can map transfer conditions for each object. In this case, typically, the company code can serve as the base condition. Furthermore, according to embodiments, a period can also be used as a base condition alone, or a combination of the company code and the period can be used as a base condition, and other base conditions required by the user can be defined. The user-required base conditions can be individually input into the computer device 200.

[0127] Table 3 shows examples of mapping handover conditions to business objects, illustrating an example of a migration baseline based on the separation of company code units.

[0128] Table 3

[0129]

[0130] For example, when a specific company code is designated as the transfer object, since business areas and plants are subordinate to the company in terms of company structure, "customer mainframes," "material mainframes," "financial accounting vouchers," and "material receipt and payment vouchers," which are business objects related to the corresponding company code, can all become transfer bases. On the other hand, when a specific plant is designated as the transfer object, "material mainframes" and "material receipt and payment vouchers," which are business objects related to the corresponding plant, can become transfer objects. As a more concrete example, when in Figure 4 When a company is separated at Plant Level 440, the "Material Master" and "Material Income and Expenditure Vouchers" identified through Plant 1 P100 can become the data to be transferred. Exception 1: Besides the company code, migration can be carried out by incorporating a period into the transfer basis. For example, when the separated company changes from a business unit to a corporation based on a specific time, migration can be carried out by business area before the specific time, and by company code after the specific time.

[0131] Example 2 of the exception to the condition other than the company code: For example, in cases where there is no company code or the company changes frequently due to resignations, personnel transfers, or dispatches (e.g., personnel data), in addition to the company code basis, "employee number" can also be defined as a migration condition.

[0132] Exception 3 to conditions other than company code: When data such as documents, drawings, and emails do not have a company code as a basis, the data generator can still be used as the basis for execution. For example, if the company to which the generator belongs is the transfer target, the corresponding data can also become a separate transfer target.

[0133] In step 1023, the computer device 200 may define the job processing sequence. For example, the computer device 200 may define the data extraction and processing sequence for each object. In this case, the computer device 200 can typically reduce the overall job time by prioritizing the processing of objects with larger sizes or greater quantities, and processing those with smaller sizes or greater quantities last.

[0134] Refer again Figure 3 In step 332, the computer device 200 can extract the transfer target data. The reason for extracting the transfer target data from the database (for example, the second database 720) is to accurately filter and extract the target data, ensuring consistency in the extraction of other related data by using the extracted data. If an error occurs during the transfer process due to transmission failure or other reasons, the transfer can be re-performed without re-extracting the data.

[0135] In step 333, the computer device 200 may compress and store the transfer object data. In this case, the computer device 200 may use lossless compression algorithms such as ZIP, CTW, LZ77, LZW, gzip, bzip2, DEFLATE, etc., to compress the extracted data and store it in a table or as a file.

[0136] As an example, computer device 200 can retrieve data using a table storage medium. Within a business object consisting of multiple tables, computer device 200 can filter and extract a parent table based on conditions for the transferred object, and then store it in a storage table. Furthermore, computer device 200 can use data in the storage table to store matching filtered data from child tables in the storage table. In this case, computer device 200 can filter matching data from the parent and child tables by reading data from the storage table, and then store it in the storage table.

[0137] As another example, computer device 200 can retrieve data using a file storage medium. Within a business object consisting of multiple tables, the parent table can be filtered and extracted based on conditions for the transferred object, and then stored in a file. Furthermore, computer device 200 can filter matching data from the parent and child tables by reading data from the file, and then store that data in the file as well.

[0138] Figure 11The diagram illustrates an example of extracting transfer object data according to an embodiment of the present invention. The computer device 200 can filter (1. Select) and extract data from the parent table 1111 of the database 1110, and then store (2. Save) it in file 1 (1120). Then, the computer device 200 can read (3. Read) the data stored in file 1 (1120), filter (4. Select) in the database 1110 and extract other related data (data stored in the child table 1112 of the parent table 1111), and then store (5. Save) it in file 2 (1130). Therefore, the computer device 200 can maintain consistency between tables, extract data from the second database 1110, and handle subsequent recovery of the database 1110 due to erroneous migration conditions by using the data stored in file 1 (1120) and file 2 (1130) as backup data.

[0139] Although in this Figure 11 The embodiments illustrate an example of storing the extracted data in a file, but as mentioned above, the extracted data may also be stored in a table in the same database 1110 or another separate database.

[0140] In this way, computer device 200 can store the extracted data in tables within the same or different separate databases, or as files on a local or remote system. In this case, when storing data in a database or file, as described above, computer device 200 can compress and store the extracted data using a lossless compression algorithm. When compressing and storing data, it can also be done by recording a portion of the compressed data in a separate index table.

[0141] Refer again Figure 3 In step 340, the computer device 200 can transmit data. Step 340 may include: step 341, transmitting compressed data; and step 342, importing the transmitted data into a target database.

[0142] In step 341, computer device 200 may transmit compressed data. The compressed data may refer to the data compressed and stored in step 333.

[0143] In step 342, computer device 200 can import the data to be transmitted into the target database. Data extracted from the database (for example, second database 720) can be compressed and stored in a table or file, and then transmitted to the target database of the target system via computer device 200. When the compressed storage medium is a file, computer device 200 can transmit the file directly, or transmit the data after decompressing it by reading the file. When the compressed storage medium is a table of the database, computer device 200 can transmit the data in the form of compressed blocks, or transmit the data after decompressing the compressed blocks.

[0144] Figure 12 and Figure 13 A diagram illustrating an example of data transmission according to an embodiment of the present invention.

[0145] Figure 12 This shows an example of the transfer object data extracted from database 1210 being stored in files 1220 and 1230. Figure 13 An example is shown where the data of the transferred object extracted from database 1310 is stored in storage table 1311 of database 1310.

[0146] Computer device 200 can transmit extracted and stored data to a target database by reading it from multiple files 1220, 1230 or storage table 1311. After transmission, the transmitted data can be stored in the target database. As an example, computer device 200 can decompress compressed data after transmission to import it into the target database.

[0147] According to an embodiment, in order to quickly transfer data, the computer device 200 can perform data transmission and import in parallel. Since compressed data is stored in compressed blocks, it can be transmitted individually or in bundles.

[0148] Furthermore, the following techniques can be used to shorten data transfer time.

[0149] Index drop and / or rebuild techniques: Computer device 200 can drop indexes on tables within the target database, transfer the data, and generate indexes after the transfer is complete. This can improve data import speed. According to an embodiment, the import to the target database can also be performed by a system including the target database, rather than by computer device 200.

[0150] On the other hand, data transfer to heterogeneous systems can be considered. Data transfer can be performed even when the source and target systems have different operating systems or database management systems (DBMS). For example, if the table structures of the source and target system databases are identical, data transfer can be performed. As explained earlier with reference to Figure 7, since the computer device 200 can import the system architecture of the second database 720 into the third database 730, the table structures are identical, thus enabling data transfer to a cloud environment or between heterogeneous clouds.

[0151] Furthermore, computer device 200 can delete data from the original database (for example, the first database 710 in Figure 7). In this case, computer device 200 can use the extracted transfer object data to delete data from the original database that matches the extracted data. This operation of deleting transfer object data from the original database can be performed when there is a deletion request for the data of the acquiring company after the separation of the corresponding organization, based on security considerations. Typically, such deletion requests may occur in the case of mergers and acquisitions (M&A) between competing companies and / or when the separation target organization is a legal entity (Company).

[0152] The following section will explain the selection of system separation construction methods in more detail. As mentioned above, system separation construction methods can include cleanup and migration. The cleanup method involves building the system by deleting data other than the separated objects after copying the original system. The migration method involves building the system by only filtering and transferring the separated object data from the original system. The cleanup method prioritizes business continuity. Its advantage lies in its ability to perform online data cleanup, minimizing downtime since it can be done after business operations have commenced. Conversely, the migration method prioritizes data security. For example, it prevents the data assets of data-selling companies from being leaked outside their own networks. Alternatively, a hybrid approach combining cleanup and migration can be used. For example, using a system delivery method after cleanup can improve data security. However, in this case, business downtime may increase.

[0153] As a factor in determining the system's decoupling construction method, the delivery time between the seller and the acquirer should be clearly defined. For example, if the seller requires delivery within 3 days of settlement, considering factors such as data volume, system performance, network bandwidth, and the target system's construction environment (cloud), the best approach if delivery can be made within 3 days of the application date would be a migration method with excellent security. If delivery via migration is difficult within 3 days, a cleanup method that minimizes downtime can be used.

[0154] Table 4 shows a comparison between the cleanup method and the migration method.

[0155] Table 4

[0156]

[0157] Migration can be used when the volume of the data to be transferred is within 10% of the total volume of the original system. However, when using migration, if there is a possibility of exceeding the acquisition deadline required by the acquiring company, other methods should be explored. Besides negotiating the acquisition deadline, other methods may include temporary increases in server configuration to improve performance, increases in network bandwidth, data archiving, and building a dedicated migration server. If even using these other methods makes it difficult to achieve the target deadline through migration, a cleanup approach can be used. Figure 14 This is a flowchart illustrating an example of an organizational data transfer method according to an embodiment of the present invention. The organizational data transfer method of this embodiment can be executed by a computer device 200 for transferring data between a first organization and a second organization. In this case, the processor 220 of the computer device 200 can execute control instructions from operating system code or at least one computer program code stored in the memory 210. The processor 220 can control the computer device 200 according to the control instructions provided by the code stored in the computer device 200, causing the computer device 200 to perform... Figure 14 The method includes steps 1410 to 1460.

[0158] In step 1410, computer device 200 can generate a second database by copying a first database of the first organization, in which the transfer object data of the first organization to the second organization is contained. In this case, the first database may be located in the system of the first organization, and the second database may be located in computer device 200. In this case, computer device 200 can perform migration via the second database. On the other hand, according to different embodiments, in the migration method, the first database of the first organization may not be copied, but the transfer object data may be directly transferred from the first database to a third database of the target system (the system of the second organization). In this case, step 1410 may be omitted, and the second database described below may correspond to the first database of the first organization.

[0159] In step 1420, computer device 200 may export a system architecture for the second database. The system architecture may include at least one of the table structures, computer programs, and processes used in the system of the second database.

[0160] In step 1430, computer device 200 can construct a third database for the second organization by importing the exported system architecture into the second organization's system, serving as the target database for the transferred data. Since the system architecture is used to construct the third database for the second organization, migration is also possible between different heterogeneous systems, such as operating systems or database management systems (DBMS), between the source and target systems for data transfer.

[0161] In step 1440, the computer device 200 may extract transfer object data from the second database. As an example, the computer device 200 may use the structure of the first organization and the structure of the second organization from which the first organization is divided to determine the migration conditions of the transfer object data at at least one level: company code level, business area level, and factory level. In this case, the computer device 200 can filter the transfer object data based on migration conditions by mapping objects corresponding to a specific company code at the company code level, a specific business area at the business area level, or a specific factory at the factory level. The data filtering and extraction of the filtered data have been described in detail previously.

[0162] In step 1450, the computer device 200 can transmit the extracted transfer data to a third database of the second organization. The transfer data can be stored in a table or a file. The computer device 200 can transmit the data stored in the table individually or in bundles in block form, or transmit the file to the third database. The transmitted transfer data can be imported into the third database. According to an embodiment, the transfer data can be compressed and stored in a table or file. After decompression in a system including the third database, the decompressed data can be imported into the decompressed third database. Furthermore, to expedite data transfer, data transmission and import into the third database can be performed in parallel.

[0163] In step 1460, computer device 200 may delete data from the first database corresponding to the transfer object data retrieved from the second database. This step 1470 is performed only upon receiving a deletion request for security reasons.

[0164] Figure 15 The diagram illustrates an example of a data deletion process according to an embodiment of the present invention. As an example, if computer device 200 receives a deletion request, it can confirm the data to be transferred to the database of the second organization in files 1510 and 1520, where the transfer object data is extracted and stored. Subsequently, computer device 200 can improve the security of the transfer object data by deleting the confirmed data from the database 1530 of the first organization.

[0165] on the other hand, Figure 14Steps 1410 to 1460 can be performed if the migration method is determined to be a system-separated construction method. For example, based on at least one of the following: downtime of the data to be transferred, required data security, storage costs, and whether the operating systems and database management systems of the systems used for the databases of the first organization and the databases used for the databases of the second organization are the same, the computer device 200 can determine the system-separated construction method as either a cleanup method or a migration method. When the migration method is determined to be this system-separated construction method, the following steps can be performed: Figure 14 Steps 1410 to 1460 in the above. Alternatively, the cleanup method may include cleaning up non-transferable object data from the second database to generate a fourth database, and then providing the generated fourth database to the second organization. This cleanup method has been described in detail previously.

[0166] Thus, according to embodiments of the present invention, data can be transferred using a migration method. Furthermore, according to different embodiments, organizational data can be transferred by selecting a suitable system separation construction method from the cleanup and migration methods.

[0167] The systems or devices described above can be implemented using hardware structural elements, software structural elements, or a combination of hardware and software structural elements. For example, the devices and structural elements described in the embodiments can be implemented using one or more general-purpose or special-purpose computers, such as processors, controllers, arithmetic logic units (ALUs), digital signal processors, microcomputers (field programmable gate arrays), field programmable gate arrays (FPGAs), programmable logic units (PLUs), microprocessors, or any other device that executes instructions and responds accordingly. The processing device can execute an operating system (OS) and one or more software applications running on the aforementioned operating system. Furthermore, the processing device can access, store, manipulate, process, and generate data in response to the execution of the software. For ease of understanding, it can be described as using a single processing device, but those skilled in the art will understand that a processing device can include multiple processing elements and / or various types of processing elements. For example, a processing device can include multiple processors or include one processor and one controller. It can also be other processing configurations, such as parallel processors.

[0168] Software can include computer programs, code, instructions, or combinations thereof, and is capable of configuring a processing device to operate as needed, or of commanding the processing device independently or collectively. Software and / or data can embody in any type of machine, component, physical device, virtual equipment, computer storage medium, or device for interpretation by the processing device or for providing instructions or data to the processing device. Software can be distributed across networked computer systems and stored or executed in a distributed manner. Software and data can be stored on more than one computer-readable recording medium.

[0169] The method based on the embodiments can be implemented in the form of program instructions executable by various computer devices and recorded in a computer-readable medium. The aforementioned computer-readable medium can include program instructions, data files, data structures, etc., either individually or in combination. The medium can continue to store a computer-executable program, or temporarily store it for execution or download. Furthermore, the medium can be various recording units or storage units in the form of a single or multiple hardware components, and is not limited to a medium directly connected to a computer system, but can be distributed across a network. Examples of media include magnetic media such as hard disks, floppy disks, and magnetic disks; optical recording media such as CD-ROMs and DVDs; magneto-optical media such as floppy disks; and read-only memory (ROM), random access memory (RAM), flash memory, etc., which can store program instructions. Furthermore, examples of other media may include application stores for distributing applications or web pages that provide or distribute various other software; recording media or storage media managed in servers, etc. Examples of program instructions include not only machine language code generated by a compiler, but also high-level language code that can be executed by a computer using an interpreter, etc. Detailed Implementation

[0170] As described above, although limited embodiments and accompanying drawings have been referenced, those skilled in the art can make various modifications and variations based on the above description. For example, appropriate results can be achieved even if the technology is performed in a different order than the method described, and / or the structural elements of the system, structure, device, circuit, etc., are combined or integrated in a different form than the method described, or replaced or substituted by other structural elements or equivalent technical solutions.

[0171] Therefore, other implementation methods, other embodiments, and contents equivalent to the scope of protection of the invention are also within the scope of protection of the invention.

Claims

1. A method for organizing data transfer, performed in a computer device including at least one processor, characterized in that, Includes the following steps: Using at least one of the aforementioned processors, a system separation construction method is selected, wherein the selected method is either a cleanup method or a migration method, and the selection is based on at least one of the following: the downtime of the transferred object data, the required data security, storage costs, and whether the operating system and database management system of the system used for the first database of the first organization and the system used for the second database of the second organization are the same, and wherein the system separation construction method is selected in one of the following ways: In response to the relatively large volume of the aforementioned transfer objects and / or with a priority to minimize downtime, the aforementioned system separation construction method was selected as the cleanup method; In response to the priority given to data security, the aforementioned system separation construction method was selected as the migration method; In response to the fact that the system used for the first database is different from the system used for the second database, the separate construction method of the system is selected as the migration method; In response to the selection of the above migration method as the separate construction method for the above system, The system architecture of the first database is derived from the first database of the first organization that includes the object data, using at least one of the processors described above; By using at least one of the processors described above, the exported system architecture is imported into the system of the second organization, and the second database of the second organization is generated in the system of the second organization. The second database is the target database to which the object data is to be transferred. The object data is extracted from the first database using at least one of the aforementioned processors; and The extracted object data is transmitted to the second database of the second organization via at least one of the processors described above. In response to the selection of the above cleanup method as the separate construction method for the above system, The third database is generated by copying the first database using at least one of the aforementioned processors; Using at least one of the aforementioned processors, a fourth database is generated by cleaning up data from the third database that has not been migrated from the first organization to the second organization; and The generated fourth database is provided to the second organization by at least one of the processors described above.

2. The organizational data transfer method according to claim 1, characterized in that, The aforementioned system architecture includes at least one of the table structures, computer programs, and processes used in the system of the aforementioned first database.

3. The organizational data transfer method according to claim 1, characterized in that, The steps for performing the above extraction include the following steps: using the structure of the first organization and the structure of the second organization to be divided from the first organization, determining the migration conditions of the transferred object data at at least one of the company code level, business area level, and factory level.

4. The organizational data transfer method according to claim 3, characterized in that, The extraction process also includes the following steps: filtering data based on the migration conditions of the transferred object data by mapping objects corresponding to specific company codes at the company code level, specific business areas at the business area level, or specific factories at the factory level.

5. The organizational data transfer method according to claim 1, characterized in that, It also includes the following step: deleting data corresponding to the transfer object data extracted from the first database by at least one of the processors described above.

6. A computer-readable recording medium, characterized in that, The computer program is recorded for performing the method according to any one of claims 1 to 5 in a computer device.

7. A system for organizing data transfer, characterized in that, Includes at least one processor for executing readable instructions within the computer. At least one of the processors is configured to select a system separation build method, wherein the selected method is either a cleanup method or a migration method, and the selection is based on at least one of the following: the downtime of the transferred object data, the required data security, storage costs, and whether the operating system and database management system of the system used for the first database of the first organization and the system used for the second database of the second organization are the same, and wherein the system separation build method is selected in one of the following ways: In response to the relatively large volume of the aforementioned transfer objects and / or with a priority to minimize downtime, the aforementioned system separation construction method was selected as the cleanup method; In response to the priority given to data security, the aforementioned system separation construction method was selected as the migration method; In response to the fact that the system used for the first database is different from the system used for the second database, the separate construction method of the system is selected as the migration method; In response to selecting the above migration method as the above system decoupling construction method, the at least one processor is further configured as follows: The system architecture of the first database is derived from the first database of the first organization that includes the aforementioned object data; By importing the exported system architecture into the system of the second organization, the second database of the second organization is generated in the system of the second organization. The second database is the target database to which the object data is to be transferred. Extract the object data from the first database; and The extracted object data is transmitted to the second database of the second organization. In response to selecting the above-mentioned cleanup method as the above-mentioned system decoupling construction method, the at least one processor is further configured to The third database is generated by copying the first database described above; A fourth database is generated by cleaning up data from the third database that was not migrated from the first organization to the second organization; and The generated fourth database is provided to the second organization.

Citation Information

Patent Citations

  • Method and system for providing data migration

    US20120124081A1

  • Method and system for archiving data from a source database to a target database

    US20150081642A1