Data processing method, device, computer equipment and storage medium

Abstract

The present disclosure proposes a data processing method, device, computer equipment and storage medium, which relate to the field of data processing technology. The method includes: determining the reference relationship of each field in the data table to be copied; when any field in the data table to be copied references a public data table, obtaining the first target data referenced by any field from the public data table according to the reference relationship of any field; determining the first index field corresponding to the first target data; obtaining the first index data corresponding to the first index field from the first target data; copying the first index data, and updating the reference relationship of any field according to the first index data. Therefore, by updating the reference relationship of any field that references public data to the first index data corresponding to the public data it references, not only the export of the reference relationship of any field is realized, but also the copying of the complete data in the public data table is avoided, thereby improving the efficiency of data export and reducing costs.

Description

Technical Field

[0001] The present disclosure relates to the field of data processing technology, and in particular to a data processing method, device, computer equipment and storage medium. Background Art

[0002] In various business systems, two types of data are usually stored: one is the data configured by the user, and the other is the public data built into the system, such as the corpus or speech of the relevant industry.

[0003] In the related art, when copying a business system such as a robot dialogue system, the business system is usually broken down into sub-modules, and relevant copy codes are written for the sub-modules. The dependencies between modules also need to be transferred by writing codes, so as to complete the copying of the business system. However, in the case where public data is referenced by multiple modules, it is necessary to write relevant logic codes in each module, which results in low efficiency and high cost of data import and export. Summary of the invention

[0004] The present disclosure aims to solve one of the technical problems in the related art at least to some extent.

[0005] The first embodiment of the present disclosure provides a data processing method, including:

[0006] Determine the reference relationship of each field in the data table to be copied;

[0007] In the case where any field in the to-be-copied data table references a public data table, obtaining first target data referenced by any field from the public data table according to the reference relationship of any field;

[0008] Determine a first index field corresponding to the first target data;

[0009] Acquire first index data corresponding to the first index field from the first target data;

[0010] The first index data is copied, and a reference relationship of any one of the fields is updated according to the first index data, so that the updated reference relationship of any one of the fields points to the first index data.

[0011] A second aspect of the present disclosure provides a data processing device, including:

[0012] A first determination module is used to determine the reference relationship of each field in the data table to be copied;

[0013] A first acquisition module is used to acquire first target data referenced by any field in the data table to be copied from the public data table according to the reference relationship of any field when the field references the public data table;

[0014] A second determining module, used to determine a first index field corresponding to the first target data;

[0015] A second acquisition module, configured to acquire first index data corresponding to the first index field from the first target data;

[0016] The first updating module is used to copy the first index data, and update the reference relationship of any field according to the first index data, so that the updated reference relationship of any field points to the first index data.

[0017] The third aspect embodiment of the present disclosure proposes a computer device, including: a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the data processing method proposed in the first aspect embodiment of the present disclosure is implemented.

[0018] The fourth aspect embodiment of the present disclosure proposes a non-temporary computer-readable storage medium storing a computer program, which, when executed by a processor, implements the data processing method proposed in the first aspect embodiment of the present disclosure.

[0019] The fifth aspect embodiment of the present disclosure proposes a computer program product. When the instruction processor in the computer program product executes, the data processing method proposed in the first aspect embodiment of the present disclosure is executed.

[0020] The data processing method, device, computer equipment and storage medium provided by the present disclosure have the following beneficial effects:

[0021] In the disclosed embodiment, the reference relationship of each field in the data table to be copied is first determined. When any field in the data table to be copied references a public data table, the first target data referenced by any field is obtained from the public data table according to the reference relationship of any field. Then, the first index field corresponding to the first target data is determined. Then, the first index data corresponding to the first index field is obtained from the first target data. Finally, the first index data is copied, and the reference relationship of any field is updated according to the first index data so that the updated reference relationship of any field points to the first index data. Thus, when copying data, by updating the reference relationship of any field that references public data to the first index data corresponding to the public data it references, not only the export of the reference relationship of any field is realized, but also the copying of the complete data in the public data table is avoided, thereby improving the efficiency of data export and reducing costs.

[0022] Additional aspects and advantages of the present disclosure will be given in part in the following description and in part will be obvious from the following description or learned through practice of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] The above and / or additional aspects and advantages of the present disclosure will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0024] Figure 1 A flowchart of a data processing method provided by an embodiment of the present disclosure;

[0025] Figure 2 A flowchart of a data processing method provided by another embodiment of the present disclosure;

[0026] Figure 3 A schematic diagram of the structure of a data processing device provided by an embodiment of the present disclosure;

[0027] Figure 4 A block diagram of an exemplary computer device suitable for implementing embodiments of the present disclosure is shown. DETAILED DESCRIPTION

[0028] Embodiments of the present disclosure are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present disclosure, and should not be construed as limiting the present disclosure.

[0029] The following describes the data processing method, apparatus, computer device, and storage medium according to the embodiments of the present disclosure with reference to the accompanying drawings.

[0030] Figure 1 A flowchart of a method for processing data provided by an embodiment of the present disclosure.

[0031] The embodiment of the present disclosure takes the data processing method being configured in a data processing device as an example. The data processing device can be applied to any computer device so that the computer device can perform the data processing function.

[0032] Among them, the computer device can be a personal computer (PC), a cloud device, a mobile device, etc. The mobile device can be, for example, a mobile phone, a tablet computer, a personal digital assistant, a wearable device, a car device, etc., which are hardware devices with various operating systems, touch screens and / or display screens.

[0033] like Figure 1As shown, the data processing method may include the following steps:

[0034] Step 101, determining the reference relationship of each field in the data table to be copied.

[0035] It is understandable that a data storage system can store multiple data tables, and there may be reference relationships between data tables. The reference relationship of each field in the data table can be stored in the field attributes of each field, or marked in other tag forms, which is not limited in this disclosure.

[0036] For example, field a in data table A references field b in data table B; or, field a in data table A references field b and field c in data table B, etc., which is not limited in the present disclosure.

[0037] Optionally, a data export request may be received first, wherein the export request includes an identifier of a data table to be exported, and then the data table to be copied is obtained according to the identifier of the data table, and finally each field in the data table to be copied is parsed to determine the reference relationship of each field.

[0038] The identifier of the data table may include the storage address, name, etc. of the data table, which is not limited in the present disclosure.

[0039] Alternatively, when exporting data, you can first determine the priority of each data table based on the reference relationship between each data table in the source business system, and then export each data table in order from high to low priority.

[0040] It should be noted that the more a data table is referenced, the more important it is, and the higher its corresponding priority can be set, so that the data table can be exported first when exporting data.

[0041] Step 102: when any field in the data table to be copied references a public data table, first target data referenced by any field is obtained from the public data table according to the reference relationship of any field.

[0042] For example, field a in the to-be-copied data table A references field b in the public data table B, wherein the data corresponding to field b is the first target data.

[0043] It should be noted that the above examples are merely simple illustrations and cannot be used as specific limitations on the first target data in the embodiments of the present disclosure.

[0044] Step 103: determine a first index field corresponding to the first target data.

[0045] In the present disclosure, since the first target data is data in a public data table, and the public data table is basic data in each business system, when copying business data, in order to reduce the amount of data processing, only the relationship between the data table to be copied and the first target data and the partial data that can uniquely identify the first target data can be recorded. Therefore, in the present disclosure, after determining the first target data, the first index field corresponding to the first target data can be determined first.

[0046] The first index field may be one or more data fields used to index the first target data, which is not limited in the present disclosure.

[0047] For example, if the first target data corresponding to field a in the data table to be copied is "XXX Company, Zhang San, Male, Sales Director, Bachelor's Degree", then the corresponding first index field can be "Company Name" and "Position", or it can also be "Name" and "Position", etc., and the present disclosure does not limit this.

[0048] In addition, since the data types or contents in the public data tables may be different in different business systems, the index fields that can uniquely locate a piece of data in the public data tables may be different. In the present disclosure, the type of the first target data can be determined first, and then the first index field corresponding to the first target data can be determined based on the association between the data type and the index field.

[0049] For example, the public data table pre-defines that the index fields corresponding to the sensitive word table are "classification number" and "sensitive word". When the first target data obtained according to the reference relationship of any field is data in the sensitive word table, the first index fields corresponding to the first target data can be determined to be: "classification number" and "sensitive word". For example, if the first target data contains: "classification number, user ID, sensitive word, other related indexes", it can be determined that the corresponding first index fields are "classification number" and "sensitive word".

[0050] It should be noted that the above examples are merely simple illustrations and cannot be used as specific limitations on the first target data, the first index field, etc. in the embodiments of the present disclosure.

[0051] Step 104: Obtain first index data corresponding to the first index field from the first target data.

[0052] For example, the first target data may be "XXX Company, Zhang San, Male, Sales Director, Bachelor's Degree". If the first index field is "Company Name" and "Position", then based on the first index field, the first index data "XXX Company" and "Sales Director" can be extracted from the first target data; or, the first index field is "Name" and "Position", then the corresponding first index data is "Zhang San" and "Sales Director".

[0053] It should be noted that the above examples are merely simple illustrations and cannot be used as specific limitations on the first target data in the embodiments of the present disclosure.

[0054] Step 105 , copy the first index data, and update the reference relationship of any field according to the first index data, so that the updated reference relationship of any field points to the first index data.

[0055] For example, before the reference relationship in the data table to be copied is updated, field a in the data table to be copied A references field b in the public data table B. If the first target data pointed to by field b is: "XXX Company, Zhang San, Male, Sales Director, Bachelor's Degree", in the present disclosure, in order to minimize the amount of data to be copied, after determining the first target data to be copied, only the first index field "name" corresponding to the first target data and the first index data corresponding to "position" can be copied, and the reference relationship of field a can be updated according to the first index data. For example, after the reference relationship of field a is updated, the first index data, such as "Zhang San" and "Sales Director", can be directly referenced.

[0056] It can be understood that after the first index data is determined, the reference relationship of any field in the data table to be copied is updated according to the first index data, so that the updated reference relationship points to the first index data, thereby exporting the data and reference relationship in the data table to be copied, avoiding the export of all data in the public database, and improving the efficiency of data export.

[0057] It can be understood that when importing the exported data into a new business system, the corresponding complete public data in the new system can be located in the new business system based on the first index data, and then the reference relationship of any field can be updated to the index field corresponding to the complete public data in the new business system, thereby completing the import of data and reference relationship.

[0058] In the disclosed embodiment, the reference relationship of each field in the data table to be copied is first determined. When any field in the data table to be copied references a public data table, the first target data referenced by any field is obtained from the public data table according to the reference relationship of any field. Then, the first index field corresponding to the first target data is determined. Then, the first index data corresponding to the first index field is obtained from the first target data. Finally, the first index data is copied, and the reference relationship of any field is updated according to the first index data so that the updated reference relationship of any field points to the first index data. Thus, when copying data, by updating the reference relationship of any field that references public data to the first index data corresponding to the public data it references, not only the export of the reference relationship of any field is realized, but also the copying of the complete data in the public data table is avoided, thereby improving the efficiency of data export and reducing costs.

[0059] The above embodiment describes a method for exporting data from a public data table when any field in the data table to be copied references a public data table. In a possible implementation, the reference relationship of the data table to be inserted can also be updated to reference the public database in the current system to implement the import of public data. Figure 2 The above process is further explained.

[0060] Figure 2 A flowchart of a data processing method provided by an embodiment of the present disclosure is shown in FIG. Figure 2 As shown, the data processing method may include the following steps:

[0061] Step 201, determining the reference relationship of each field in the data table to be inserted.

[0062] The data table to be inserted may be any data table to be imported into the current system.

[0063] Optionally, a data insertion request may be received, wherein the data insertion request includes an identifier of a data table to be inserted, and then the data table to be inserted is obtained based on the identifier of the data table, and finally each field in the data table to be inserted is parsed to determine a reference relationship between each field in the data table to be inserted.

[0064] The identifier of the data table to be inserted may include the storage address, name, etc. of the data table to be inserted, which is not limited in the present disclosure.

[0065] Step 202: when any field in the data table to be inserted references the second index data, determine the second target data corresponding to the second index data in the public data table.

[0066] Optionally, you can first determine the index field corresponding to the second index data, then determine the type of the second target data based on the association between the data type and the index field, and finally traverse the public data tables in the current system to obtain the type of the second target data in the public data table and the second target data corresponding to the second index data.

[0067] For example, the second index data corresponding to field a in the data table to be inserted can be "XXX Company" and "Sales Director", and the corresponding index fields are "Company Name" and "Position". Then, based on the association between the data type recorded in the public data table in the current business system and the index field, the type of the second target data is determined to be the position information of XXX Company. Finally, based on the type of the second target data and the second index data, the second target data is determined to be "XXX Company, Sales Director, Zhang San, Male, Bachelor's Degree".

[0068] It should be noted that the above examples are merely simple illustrations and cannot be used as specific limitations on the second index data, the second target data, etc. in the embodiments of the present disclosure.

[0069] Step 203: Determine the identifier of the second target data in the current system.

[0070] Among them, the identifier of the second target data in the current system can be the position of the second target data in the public data table. For example, the identifier of the second target data in the current system can be field c, or field d, etc. in the public data table in the current system. This disclosure does not limit this.

[0071] Step 204: update the reference relationship of any field according to the identifier of the second target data in the current system.

[0072] For example, the reference relationship of field a in the data table to be inserted is to reference the second index data. Then, based on the second index data, the corresponding complete data in the current system is determined to be the second target data. Then, based on the identifier of the second target data in the current system, the reference relationship of field a can be updated so that field a references the identifier of the second target data in the current system. For example, before the reference relationship of field a in the data table to be inserted is updated, it references the second index data "XXX Company" and "Sales Director". If the second target data corresponding to the second index data is: "XXX Company, Sales Director, Zhang San, Male, Undergraduate", and the index identifier of the public data table in the current system is field c, then the reference relationship of field a in the data table to be inserted is updated to reference field c in the public data table.

[0073] Step 205: inserting the data table with the updated reference relationship into the current system.

[0074] In the disclosed embodiment, after the reference relationship of each field in the data table to be inserted is updated, the updated data table can be inserted into the current system. Thus, there is no need to copy the common data in the current system. Only by simply updating the index relationship can the import of other data tables that reference the common data table be achieved, thereby reducing the amount of data imported and improving the efficiency of data import.

[0075] The disclosed embodiment first determines the reference relationship of each field in the data table to be inserted, and then, if any field in the data table to be inserted refers to the second index data, determines the second target data corresponding to the second index data in the public data table, and then updates the reference relationship of any field according to the identifier of the second target data in the current system, and finally inserts the data table with the updated reference relationship in the current system. Thus, by updating the reference relationship of each field in the data table to be inserted based on the relationship between the public data table and the second index data in the current system, not only the amount of data during data import is reduced, but also the efficiency of data import is improved and the cost is reduced.

[0076] In order to implement the above embodiments, the present disclosure also proposes a data processing device.

[0077] Figure 3 A schematic diagram of the structure of a data processing device provided in an embodiment of the present disclosure.

[0078] like Figure 3 As shown, the data processing device 300 may include: a first determination module 310 , a first acquisition module 320 , a second determination module 330 , a second acquisition module 340 , and a first update module 350 .

[0079] The first determination module 310 is used to determine the reference relationship of each field in the data table to be copied;

[0080] A first acquisition module 320 is used to acquire first target data referenced by any field in the data table to be copied from the public data table according to the reference relationship of any field when the field references a public data table;

[0081] A second determination module 330, configured to determine a first index field corresponding to the first target data;

[0082] A second acquisition module 340 is used to acquire first index data corresponding to the first index field from the first target data;

[0083] The first updating module 350 is used to copy the first index data, and update the reference relationship of any field according to the first index data, so that the updated reference relationship of any field points to the first index data.

[0084] In a possible implementation, the second determining module 330 is specifically configured to:

[0085] determining a type of the first target data;

[0086] According to the association relationship between the data type and the index field, a first index field corresponding to the first target data is determined.

[0087] In a possible implementation, the first determining module 310 is specifically configured to:

[0088] Receiving a data export request, wherein the export request includes an identifier of a data table to be exported;

[0089] According to the identifier of the data table, obtaining the data table to be copied;

[0090] Each field in the to-be-copied data table is parsed to determine the reference relationship of each field.

[0091] In a possible implementation, the method further includes:

[0092] The third determination module is used to determine the reference relationship of each field in the data table to be inserted;

[0093] A fourth determination module, configured to determine, when any field in the data table to be inserted references the second index data, the second target data corresponding to the second index data in the public data table;

[0094] a fifth determining module, configured to determine an identifier of the second target data in the current system;

[0095] A second updating module, configured to update the reference relationship of any one of the fields according to an identifier of the second target data in the current system;

[0096] The insert module is used to insert the data table with updated reference relationship into the current system.

[0097] In a possible implementation manner, the fourth determining module is specifically configured to:

[0098] Determining an index field corresponding to the second index data;

[0099] Determining the type of the second target data according to the association relationship between the data type and the index field;

[0100] The public data table in the current system is traversed to obtain the second target data corresponding to the type of the second target data in the public data table.

[0101] The functions and specific implementation principles of the above modules in the embodiments of the present disclosure can be referred to the above method embodiments, and will not be repeated here.

[0102] The data processing device of the disclosed embodiment first determines the reference relationship of each field in the data table to be copied. When any field in the data table to be copied references a public data table, the first target data referenced by any field is obtained from the public data table according to the reference relationship of any field, and then the first index field corresponding to the first target data is determined, and then the first index data corresponding to the first index field is obtained from the first target data. Finally, the first index data is copied, and the reference relationship of any field is updated according to the first index data so that the updated reference relationship of any field points to the first index data. Therefore, when copying data, by updating the reference relationship of any field that references public data to the first index data corresponding to the public data it references, not only the export of the reference relationship of any field is realized, but also the copying of the complete data in the public data table is avoided, thereby improving the efficiency of data export and reducing costs.

[0103] In order to implement the above embodiments, the present disclosure further proposes a computer device, including: a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the data processing method proposed in the above embodiments of the present disclosure is implemented.

[0104] In order to implement the above embodiments, the present disclosure further proposes a non-temporary computer-readable storage medium storing a computer program, which, when executed by a processor, implements the data processing method proposed in the above embodiments of the present disclosure.

[0105] In order to implement the above embodiments, the present disclosure further proposes a computer program product. When an instruction processor in the computer program product executes, the data processing method proposed in the above embodiments of the present disclosure is executed.

[0106] Figure 4 A block diagram of an exemplary computer device suitable for implementing embodiments of the present disclosure is shown. Figure 4 The computer device 12 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0107] like Figure 4 As shown, the computer device 12 is in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that connects various system components (including the system memory 28 and the processing unit 16).

[0108] The bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor or a local bus using any of a variety of bus structures. For example, these architectures include but are not limited to Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MAC) bus, Enhanced ISA bus, Video Electronics Standards Association (VESA) local bus and Peripheral Component Interconnection (PCI) bus.

[0109] The computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0110] The memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 4 not shown, usually called a "hard drive"). Although Figure 4 Not shown in the figure, a disk drive for reading and writing a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing a removable non-volatile optical disk (e.g., a compact disc read only memory (CD-ROM), a digital versatile disc read only memory (DVD-ROM), or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the various embodiments of the present disclosure.

[0111] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in the memory 28, such program modules 42 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 42 generally perform the functions and / or methods of the embodiments described in the present disclosure.

[0112] The computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), one or more devices that enable a user to interact with the computer device 12, and / or any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed via an input / output (I / O) interface 22. In addition, the computer device 12 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 20. As shown, the network adapter 20 communicates with other modules of the computer device 12 via a bus 18. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0113] The processing unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, such as implementing the methods mentioned in the above embodiments.

[0114] The technical solution disclosed in the present invention first determines the reference relationship of each field in the data table to be copied. When any field in the data table to be copied references a public data table, the first target data referenced by any field is obtained from the public data table according to the reference relationship of any field. Then, the first index field corresponding to the first target data is determined. Then, the first index data corresponding to the first index field is obtained from the first target data. Finally, the first index data is copied, and the reference relationship of any field is updated according to the first index data so that the updated reference relationship of any field points to the first index data. Therefore, when copying data, by updating the reference relationship of any field that references public data to the first index data corresponding to the public data it references, not only the export of the reference relationship of any field is realized, but also the copying of the complete data in the public data table is avoided, thereby improving the efficiency of data export and reducing costs.

[0115] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present disclosure. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0116] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of the features. In the description of the present disclosure, "plurality" means at least two, such as two, three, etc., unless otherwise clearly and specifically defined.

[0117] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code that includes one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present disclosure includes additional implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present disclosure belong.

[0118] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute the instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purpose of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), a fiber optic device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or processing in other suitable ways if necessary, and then stored in a computer memory.

[0119] It should be understood that the various parts of the present disclosure can be implemented in hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one of the following technologies known in the art or a combination thereof can be used to implement: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0120] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0121] In addition, each functional unit in each embodiment of the present disclosure may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0122] The storage medium mentioned above may be a read-only memory, a disk or an optical disk, etc. Although the embodiments of the present disclosure have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limitations of the present disclosure. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present disclosure.

Claims

1. A data processing method, characterized in that: include: Determine the reference relationship of each field in the data table to be copied; In the case where any field in the to-be-copied data table references a public data table, obtaining first target data referenced by any field from the public data table according to the reference relationship of any field; Determine a first index field corresponding to the first target data; Acquire first index data corresponding to the first index field from the first target data, wherein the target data includes an index field and index data, the index field is a field corresponding to the target data, and the index data is a field value corresponding to the target data; The first index data is copied, and a reference relationship of any one of the fields is updated according to the first index data, so that the updated reference relationship of any one of the fields points to the first index data.

2. The method according to claim 1, characterized in that The determining a first index field corresponding to the first target data includes: determining a type of the first target data; According to the association relationship between the data type and the index field, a first index field corresponding to the first target data is determined.

3. The method according to claim 1, characterized in that The step of determining the reference relationship between the fields in the data table to be copied includes: Receiving a data export request, wherein the export request includes an identifier of a data table to be exported; According to the identifier of the data table, obtaining the data table to be copied; Each field in the to-be-copied data table is parsed to determine the reference relationship of each field.

4. The method according to any one of claims 1 to 3, characterized in that: Also includes: Determine the reference relationship of each field in the data table to be inserted; In the case where any field in the to-be-inserted data table references second index data, determining second target data corresponding to the second index data in the public data table; Determining an identifier of the second target data in the current system; updating the reference relationship of any one of the fields according to the identifier of the second target data in the current system; In the current system, the data table with the updated reference relationship is inserted.

5. The method according to claim 4, characterized in that The determining the second target data corresponding to the second index data in the public data table includes: Determining an index field corresponding to the second index data; Determining the type of the second target data according to the association relationship between the data type and the index field; The public data table in the current system is traversed to obtain the second target data corresponding to the type of the second target data in the public data table.

6. A data processing device, characterized in that: include: A first determination module is used to determine the reference relationship of each field in the data table to be copied; A first acquisition module is used to acquire first target data referenced by any field in the data table to be copied from the public data table according to the reference relationship of any field when the field references the public data table; A second determining module, used to determine a first index field corresponding to the first target data; A second acquisition module is used to acquire first index data corresponding to the first index field from the first target data, wherein the target data includes an index field and index data, the index field is a field corresponding to the target data, and the index data is a field value corresponding to the target data; The first updating module is used to copy the first index data, and update the reference relationship of any field according to the first index data, so that the updated reference relationship of any field points to the first index data.

7. The device according to claim 6, characterized in that The second determining module is specifically used to: determining a type of the first target data; According to the association relationship between the data type and the index field, a first index field corresponding to the first target data is determined.

8. The device according to claim 6, characterized in that The first determining module is specifically configured to: Receiving a data export request, wherein the export request includes an identifier of a data table to be exported; According to the identifier of the data table, obtaining the data table to be copied; Each field in the to-be-copied data table is parsed to determine the reference relationship of each field.

9. The device according to any one of claims 6 to 8, characterized in that: Also includes: The third determination module is used to determine the reference relationship of each field in the data table to be inserted; A fourth determination module, configured to determine, when any field in the data table to be inserted references the second index data, the second target data corresponding to the second index data in the public data table; a fifth determining module, configured to determine an identifier of the second target data in the current system; A second updating module, configured to update the reference relationship of any one of the fields according to an identifier of the second target data in the current system; The insert module is used to insert the data table with updated reference relationship into the current system.

10. The device according to claim 9, characterized in that The fourth determining module is specifically used for: Determining an index field corresponding to the second index data; Determining the type of the second target data according to the association relationship between the data type and the index field; The public data table in the current system is traversed to obtain the second target data corresponding to the type of the second target data in the public data table.

11. A computer device, characterized in that: The method comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, the method for processing data as claimed in any one of claims 1 to 5 is implemented.

12. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the data processing method according to any one of claims 1 to 5 is implemented.

13. A computer program product, characterized in that The invention comprises a computer program, which, when executed by a processor, implements the data processing method according to any one of claims 1 to 5.

Images