CN114077606A - Data processing method and device, computer equipment and storage medium - Google Patents

Data processing method and device, computer equipment and storage medium Download PDF

Info

Publication number
CN114077606A
CN114077606A CN202111372309.XA CN202111372309A CN114077606A CN 114077606 A CN114077606 A CN 114077606A CN 202111372309 A CN202111372309 A CN 202111372309A CN 114077606 A CN114077606 A CN 114077606A
Authority
CN
China
Prior art keywords
data
field
index
data table
determining
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111372309.XA
Other languages
Chinese (zh)
Inventor
姬宁
李晴阳
李柏润
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jingdong Technology Information Technology Co Ltd
Original Assignee
Jingdong Technology Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Jingdong Technology Information Technology Co Ltd filed Critical Jingdong Technology Information Technology Co Ltd
Priority to CN202111372309.XA priority Critical patent/CN114077606A/en
Publication of CN114077606A publication Critical patent/CN114077606A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases

Abstract

The disclosure provides a data processing method and device, computer equipment and a storage medium, and relates to the technical field of data processing. The method comprises the following steps: determining the reference relation of each field in the data table to be copied; under the condition that any field in a data table to be copied refers to a public data table, acquiring first target data referred by any field from the public data table according to the reference relation of any field; determining a first index field corresponding to first target data; acquiring first index data corresponding to a first index field from first target data; and copying the first index data and updating the reference relation of any field according to the first index data. Therefore, the reference relation of any field for referencing the public data is updated to the first index data corresponding to the public data referenced by the field, so that the export of the reference relation of any field is realized, the copying of the complete data in the public data table is avoided, the efficiency of exporting the data is improved, and the cost is reduced.

Description

Data processing method and device, computer equipment and storage medium
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a data processing method and apparatus, a computer device, and a storage medium.
Background
In various business systems, two types of data are usually stored, one is data configured by a user, and the other is public data built in the system, such as corpora or dialogues in related industries.
In the related art, when a business system, such as a robot dialog system, is copied, the business system is usually disassembled into sub-modules, related copy codes are written for the sub-modules, and the codes are also written for transmission in the dependency relationship existing between the modules, so that the copying of the business system is completed. However, in the case that common data is referred to by a plurality of modules, related logic codes need to be written in each module, so that the efficiency of importing and exporting data is low, and the cost is high.
Disclosure of Invention
The present disclosure is directed to solving, at least to some extent, one of the technical problems in the related art.
An embodiment of a first aspect of the present disclosure provides a data processing method, including:
determining the reference relation of each field in the data table to be copied;
under the condition that any field in the data table to be copied refers to a public data table, acquiring first target data referred by any field from the public data table according to the reference relation of any field;
determining a first index field corresponding to the first target data;
acquiring first index data corresponding to the first index field from the first target data;
and copying the first index data, and updating the reference relationship of any field according to the first index data so as to enable the updated reference relationship of any field to point to the first index data.
An embodiment of a second aspect of the present disclosure provides a data processing apparatus, including:
the first determining module is used for determining the reference relation of each field in the data table to be copied;
a first obtaining module, configured to, when any field in the to-be-copied data table refers to a public data table, obtain, according to a reference relationship of the any field, first target data referred to by the any field from the public data table;
the second determining module is used for determining a first index field corresponding to the first target data;
a second obtaining module, configured to obtain, from the first target data, first index data corresponding to the first index field;
and the first updating module is used for copying the first index data and updating the reference relation of any field according to the first index data so as to enable the updated reference relation of any field to point to the first index data.
An embodiment of a third aspect of the present disclosure provides a computer device, including: the present invention relates to a data processing method, and a computer program stored in a memory and executable on a processor, where the processor executes the program to implement the data processing method as set forth in the embodiments of the first aspect of the present disclosure.
A fourth aspect of the present disclosure provides a non-transitory computer-readable storage medium, which stores a computer program, and when the computer program is executed by a processor, the computer program implements a method for processing data as set forth in the first aspect of the present disclosure.
A fifth aspect of the present disclosure provides a computer program product, which when executed by an instruction processor in the computer program product performs the method for processing data provided in the first aspect of the present disclosure.
The data processing method, the data processing device, the computer equipment and the storage medium have the following beneficial effects:
in the embodiment of the disclosure, a reference relationship of each field in a data table to be copied is determined, when any field in the data table to be copied references a public data table, first target data referenced by any field is acquired from the public data table according to the reference relationship of any field, then a first index field corresponding to the first target data is determined, first index data corresponding to the first index field is acquired 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 data copying is carried out, the reference relation of any field which refers to the public data is updated to the first index data corresponding to the public data which refers to the field, so that the reference relation of any field is exported, the situation that the complete data in the public data table is copied is avoided, the efficiency of exporting the data is improved, and the cost is reduced.
Additional aspects and advantages of the disclosure will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the disclosure.
Drawings
The foregoing and/or additional aspects and advantages of the present disclosure will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
fig. 1 is a schematic flow chart illustrating a data processing method according to an embodiment of the present disclosure;
fig. 2 is a schematic flow chart of a data processing method according to another embodiment of the disclosure;
fig. 3 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure;
FIG. 4 illustrates a block diagram of an exemplary computer device suitable for use in implementing embodiments of the present disclosure.
Detailed Description
Reference will now be made in detail to the embodiments of the present disclosure, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the drawings are exemplary and intended to be illustrative of the present disclosure, and should not be construed as limiting the present disclosure.
A method, an apparatus, a computer device, and a storage medium for processing data of the embodiments of the present disclosure are described below with reference to the accompanying drawings.
Fig. 1 is a schematic flow chart of a data processing method according to an embodiment of the present disclosure.
The embodiment of the present disclosure is exemplified in that the data processing method is configured in a data processing apparatus, and the data processing apparatus may be applied to any computer device, so that the computer device may perform a data processing function.
The Computer device may be a Personal Computer (PC), a cloud device, a mobile device, and the like, and the mobile device may be a hardware device having various operating systems, touch screens, and/or display screens, such as a mobile phone, a tablet Computer, a Personal digital assistant, a wearable device, and an in-vehicle device.
As shown in fig. 1, the data processing method may include the steps of:
step 101, determining the reference relation of each field in the data table to be copied.
It is understood that a plurality of data tables may be stored in one data storage system, and there may be a reference relationship between the data tables. The reference relationship of each field in the data table may be stored in the field attribute of each field or marked in other tag forms, which is not limited in this disclosure.
For example, field a in data table a references field B in data table B; alternatively, the field a in the data table a refers to the field B and the field c in the data table B, and so on, which is not limited in this disclosure.
Optionally, a data export request may be received first, where the export request includes an identifier of the data table to be exported, 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 analyzed to determine a reference relationship of each field.
The identifier of the data table may include a storage address, a name, and the like of the data table, which is not limited in this disclosure.
Or, when data is exported, the priority of each data table can be determined according to the reference relationship among the data tables in the source service system, and then the data tables are exported in sequence according to the priority from high to low.
It should be noted that the more references a data table is referenced, the more important it is, the higher the priority corresponding to it can be set, so that when data is exported, the data table can be exported preferentially.
And 102, under the condition that any field in the data table to be copied refers to the public data table, acquiring first target data referred by any field from the public data table according to the reference relation of any field.
For example, a field a in the data table to be copied refers to a field B in the public data table B, where data corresponding to the field B is the first target data.
It should be noted that the above examples are only simple examples, and should not be taken as specific limitations of the first target data in the embodiments of the present disclosure.
Step 103, determining a first index field corresponding to the first target data.
In the present disclosure, since the first target data is data in the common data table, and the common data table is basic data in each service system, in order to reduce the processing amount of data when performing service data replication, only the relationship between the data table to be replicated and the first target data may be recorded, and only partial data of the first target data may be uniquely determined. Therefore, in the present disclosure, after the first target data is determined, the first index field corresponding to the first target data may be determined first.
The first index field may be one or more data fields for indexing the first target data, which is not limited in this disclosure.
For example, the first target data corresponding to the field a in the data table to be copied is "XXX company, zhang san, man, sales chief, and home", and the corresponding first index field may be "company name" and "position", or may also be "name" and "position", and the disclosure does not limit this.
In addition, since the data types or contents in the common data table may be different in different service systems, the index field that can uniquely locate one piece of data in the common data table may be different. In this disclosure, the type of the first target data may be determined first, and then the first index field corresponding to the first target data may be determined according to the association relationship between the data type and the index field.
For example, the public data table defines in advance that the index fields corresponding to the sensitive word list are "class number" and "sensitive word", and when the first target data obtained according to the reference relationship of any field is data in the sensitive word list, it can be determined that the first index field corresponding to the first target data is: "class number" and "sensitive word". For example, if the first target data includes: the category number, the user identifier, the sensitive word, and other associated indexes may be determined as the category number and the sensitive word.
It should be noted that the above example is only a simple example, and cannot be taken as a specific limitation of the first target data, the first index field, and the like in the embodiment of the present disclosure.
And 104, acquiring first index data corresponding to the first index field from the first target data.
For example, the first target data may be "XXX company, zhang san, man, general prison of sale, hometown", if the first index field is "company name" and "job position"; based on the first index field, first index data of "XXX company" and "sales headquarters" can be extracted from the first target data; alternatively, the first index field is "name" and "position"; the corresponding first index data is "zhangsan" and "sales chief".
It should be noted that the above examples are only simple examples, and should not be taken as specific limitations of the first target data in the embodiments of the present disclosure.
And 105, copying the first index data, and updating 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.
For example, before the reference relationship in the data table to be copied is not updated, the field a in the data table to be copied refers to the field B in the public data table B, and if the first target data pointed by the field B is: "XXX company, Zhang San, Man, sales President, Benke". In order to reduce the amount of copied data as much as possible, after the first target data to be copied is determined, only the first index data corresponding to the first index field "name" and "position" corresponding to the first target data may be copied, and the reference relationship of the field a is updated according to the first index data, for example, after the reference relationship of the field a is updated, the first index data, such as "zhang san" and "sales chief can be directly referred to.
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 the reference relationship in the data table to be copied, avoiding exporting all the data in the public database, and improving the efficiency of exporting the data.
It can be understood that, when importing the exported data into a new business system, the corresponding complete public data in the new business system can be located based on the first index data, and then the reference relationship of any field is updated to the index field corresponding to the complete public data in the new business system, thereby completing the importing of the data and the reference relationship.
In the embodiment of the disclosure, a reference relationship of each field in a data table to be copied is determined, when any field in the data table to be copied references a public data table, first target data referenced by any field is acquired from the public data table according to the reference relationship of any field, then a first index field corresponding to the first target data is determined, first index data corresponding to the first index field is acquired 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 data copying is carried out, the reference relation of any field which refers to the public data is updated to the first index data corresponding to the public data which refers to the field, so that the reference relation of any field is exported, the situation that the complete data in the public data table is copied is avoided, the efficiency of exporting the data is improved, and the cost is reduced.
In a possible implementation manner, the reference relationship to be inserted into the data table may be updated to refer to the public database in the current system, so as to implement import of the public data. The above process is further explained below with reference to fig. 2.
Fig. 2 is a schematic flow chart of a data processing method according to an embodiment of the present disclosure, and as shown in fig. 2, the data processing method may include the following steps:
step 201, determining the reference relationship of each field to be inserted into the data table currently.
The data table to be inserted may be any data table to be imported into the current system.
Optionally, a data insertion request may be received, where the data insertion request includes an identifier of the data table to be inserted, then the data table to be inserted is obtained according to the identifier of the data table, and finally each field in the data table to be inserted is analyzed to determine a reference relationship of each field in the data table to be inserted.
The identifier of the data table to be inserted may include a storage address, a name, and the like of the data table to be inserted, which is not limited in this disclosure.
Step 202, determining second target data corresponding to the second index data in the public data table under the condition that any field in the data table to be inserted refers to the second index data.
Optionally, the index field corresponding to the second index data may be determined first, then the type of the second target data is determined according to the association relationship between the data type and the index field, and finally the common data table in the current system is traversed to obtain the type of the second target data in the common data table and the second target data corresponding to the second index data.
For example, the second index data corresponding to the field a to be inserted into the data table may be "XXX company" and "sales chief, the corresponding index field is" company name "and" job ", then, according to the association relationship between the data type and the index field recorded in the public data table in the current business system, the type of the second target data is determined to be the job information of the XXX company, and finally, according to the type of the second target data and the second index data, the second target data is determined to be" XXX company, sales chief, zhang, male, and home.
It should be noted that the above examples are only simple examples, and should not be taken as specific limitations of the second index data, the second target data, and the like in the embodiments of the present disclosure.
Step 203, the identification of the second target data in the current system is determined.
The identifier of the second target data in the current system may be a location of the second target data in the public data table, for example, the identifier of the second target data in the current system may be a field c, a field d, or the like in the public data table in the current system, which is not limited in this disclosure.
And step 204, updating the reference relation of any field according to the identification of the second target data in the current system.
For example, the reference relationship of the field a to be inserted into the data table is to reference the second index data, then the corresponding complete data in the current system is determined to be the second target data according to the second index data, and then the reference relationship of the field a is updated according to the identifier of the second target data in the current system, so that the field a references the identifier of the second target data in the current system. For example, the reference relationship of the field a to be inserted into the data table refers to the second index data "XXX company" and "sales headquarters" before the update. If the second target data corresponding to the second index data is: "XXX company, sales chief, zhang san, man, this department", and the index of the public data table of the second target data in the current system is identified as field c, the reference relationship of field a to be inserted into the data table is updated to refer to field c of the public data table.
Step 205, inserting the data table with updated reference relationship in the current system.
In the embodiment of the disclosure, after the reference relationship of each field to be inserted into the data table is updated, the updated data table can be inserted into the current system, so that public data does not need to be copied in the current system, and other data tables referencing the public data table can be imported only through simple index relationship updating, thereby reducing the data import amount and improving the data import efficiency.
According to the embodiment of the disclosure, a reference relationship of each field in a current data table to be inserted is determined, then second target data corresponding to second index data in a public data table is determined under the condition that any field in the data table to be inserted refers to the second index data, then the reference relationship of any field is updated according to the identification of the second target data in a current system, and finally the data table with the updated reference relationship is inserted in the current system. Therefore, the reference relation of each field in the data table to be inserted is updated based on the relation between the public data table and the second index data in the current system, so that the data volume during data import is reduced, the efficiency of data import is improved, and the cost is reduced.
In order to implement the above embodiments, the present disclosure also provides a data processing apparatus.
Fig. 3 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure.
As shown in fig. 3, the data processing apparatus 300 may include: a first determining module 310, a first obtaining module 320, a second determining module 330, a second obtaining module 340, and a first updating module 350.
The first determining module 310 is configured to determine a reference relationship of each field in the data table to be copied;
a first obtaining module 320, configured to, when any field in the to-be-copied data table refers to a public data table, obtain, according to a reference relationship of the any field, first target data referred to by the any field from the public data table;
a second determining module 330, configured to determine a first index field corresponding to the first target data;
a second obtaining module 340, configured to obtain, from the first target data, first index data corresponding to the first index field;
a first updating module 350, configured 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.
In a possible implementation manner, the second determining module 330 is specifically configured to:
determining a type of the first target data;
and determining a first index field corresponding to the first target data according to the incidence relation between the data type and the index field.
In a possible implementation manner, the first determining module 310 is specifically configured to:
receiving a data export request, wherein the export request comprises an identifier of a data table to be exported;
acquiring the data table to be copied according to the identifier of the data table;
and analyzing each field in the data table to be copied to determine the reference relation of each field.
In one possible implementation manner, the method further includes:
the third determining module is used for determining the reference relationship of each field to be inserted into the data table;
a fourth determining module, configured to determine, when any field in the to-be-inserted data table references second index data, second target data corresponding to the second index data in the common data table;
a fifth determining module, configured to determine an identifier of the second target data in a current system;
the second updating module is used for updating the reference relation of any field according to the identification of the second target data in the current system;
and the inserting module is used for inserting the data table with the updated reference relation in the current system.
In a possible implementation manner, the fourth determining module is specifically configured to:
determining an index field corresponding to the second index data;
determining the type of the second target data according to the incidence relation between the data type and the index field;
and traversing the public data table in the current system to acquire second target data corresponding to the type of the second target data in the public data table.
The functions and specific implementation principles of the modules in the embodiments of the present disclosure may refer to the embodiments of the methods, and are not described herein again.
The data processing device of the embodiment of the disclosure first determines a reference relationship of each field in a data table to be copied, acquires first target data referenced by any field from a public data table according to the reference relationship of any field when any field in the data table to be copied references the public data table, then determines a first index field corresponding to the first target data, acquires first index data corresponding to the first index field from the first target data, finally copies the first index data, and updates 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. Therefore, when data copying is carried out, the reference relation of any field which refers to the public data is updated to the first index data corresponding to the public data which refers to the field, so that the reference relation of any field is exported, the situation that the complete data in the public data table is copied is avoided, the efficiency of exporting the data is improved, and the cost is reduced.
In order to implement the foregoing embodiments, the present disclosure also provides a computer device, including: the present disclosure relates to a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the data processing method as set forth in the foregoing embodiments of the present disclosure.
In order to achieve the above embodiments, the present disclosure also proposes a non-transitory computer-readable storage medium storing a computer program, which when executed by a processor implements a processing method of data as proposed by the foregoing embodiments of the present disclosure.
In order to implement the foregoing embodiments, the present disclosure also proposes a computer program product, which when executed by an instruction processor in the computer program product, performs the processing method of data as proposed by the foregoing embodiments of the present disclosure.
FIG. 4 illustrates a block diagram of an exemplary computer device suitable for use in implementing embodiments of the present disclosure. The computer device 12 shown in fig. 4 is only one example and should not bring any limitations to the functionality or scope of use of the embodiments of the present disclosure.
As shown in FIG. 4, computer device 12 is in the form of a general purpose computing device. The components of 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 couples various system components including the system memory 28 and the processing unit 16.
Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. 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 Interconnect (PCI) bus, to name a few.
Computer device 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by computer device 12 and includes both volatile and nonvolatile media, removable and non-removable media.
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. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, and commonly referred to as a "hard drive"). Although not shown in FIG. 4, a disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a Compact disk Read Only Memory (CD-ROM), a Digital versatile disk Read Only Memory (DVD-ROM), or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the disclosure.
A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in 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 examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally perform the functions and/or methodologies of the embodiments described in this disclosure.
Computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with computer device 12, and/or with any devices (e.g., network card, modem, etc.) that enable computer device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Moreover, 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 Network adapter 20. As shown, network adapter 20 communicates with the other modules of computer device 12 via bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with 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, among others.
The processing unit 16 executes various functional applications and data processing, for example, implementing the methods mentioned in the foregoing embodiments, by executing programs stored in the system memory 28.
According to the technical scheme, the reference relation of each field in the data table to be copied is determined, under the condition that any field in the data table to be copied refers to a public data table, first target data which are referred by any field are obtained from the public data table according to the reference relation of any field, then a first index field corresponding to the first target data is determined, first index data corresponding to the first index field are obtained from the first target data, the first index data are copied finally, and the reference relation of any field is updated according to the first index data, so that the updated reference relation of any field points to the first index data. Therefore, when data copying is carried out, the reference relation of any field which refers to the public data is updated to the first index data corresponding to the public data which refers to the field, so that the reference relation of any field is exported, the situation that the complete data in the public data table is copied is avoided, the efficiency of exporting the data is improved, and the cost is reduced.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present disclosure. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present disclosure, "a plurality" means at least two, e.g., two, three, etc., unless explicitly specifically limited otherwise.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing steps of a custom logic function or process, and alternate implementations are included within the scope of the preferred embodiment of the present disclosure in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the embodiments of the present disclosure.
The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present disclosure may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. If implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present disclosure may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc. Although embodiments of the present disclosure have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present disclosure, and that changes, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present disclosure.

Claims (13)

1. A method for processing data, comprising:
determining the reference relation of each field in the data table to be copied;
under the condition that any field in the data table to be copied refers to a public data table, acquiring first target data referred by any field from the public data table according to the reference relation of any field;
determining a first index field corresponding to the first target data;
acquiring first index data corresponding to the first index field from the first target data;
and copying the first index data, and updating the reference relationship of any field according to the first index data so as to enable the updated reference relationship of any field to point to the first index data.
2. The method of claim 1, wherein the determining the first index field to which the first target data corresponds comprises:
determining a type of the first target data;
and determining a first index field corresponding to the first target data according to the incidence relation between the data type and the index field.
3. The method of claim 1, wherein the determining the reference relationship of each field in the data table to be copied comprises:
receiving a data export request, wherein the export request comprises an identifier of a data table to be exported;
acquiring the data table to be copied according to the identifier of the data table;
and analyzing each field in the data table to be copied to determine the reference relation of each field.
4. The method of any of claims 1-3, further comprising:
determining the reference relationship of each field to be inserted into the data table;
determining second target data corresponding to second index data in the public data table under the condition that any field in the data table to be inserted refers to the second index data;
determining the identification of the second target data in the current system;
updating the reference relation of any field according to the identification of the second target data in the current system;
and inserting the data table with updated reference relation in the current system.
5. The method of claim 4, wherein the determining second target data corresponding to the second index data in the common data table comprises:
determining an index field corresponding to the second index data;
determining the type of the second target data according to the incidence relation between the data type and the index field;
and traversing the public data table in the current system to acquire second target data corresponding to the type of the second target data in the public data table.
6. An apparatus for processing data, comprising:
the first determining module is used for determining the reference relation of each field in the data table to be copied;
a first obtaining module, configured to, when any field in the to-be-copied data table refers to a public data table, obtain, according to a reference relationship of the any field, first target data referred to by the any field from the public data table;
the second determining module is used for determining a first index field corresponding to the first target data;
a second obtaining module, configured to obtain, from the first target data, first index data corresponding to the first index field;
and the first updating module is used for copying the first index data and updating the reference relation of any field according to the first index data so as to enable the updated reference relation of any field to point to the first index data.
7. The apparatus of claim 6, wherein the second determining module is specifically configured to:
determining a type of the first target data;
and determining a first index field corresponding to the first target data according to the incidence relation between the data type and the index field.
8. The apparatus of claim 6, wherein the first determining module is specifically configured to:
receiving a data export request, wherein the export request comprises an identifier of a data table to be exported;
acquiring the data table to be copied according to the identifier of the data table;
and analyzing each field in the data table to be copied to determine the reference relation of each field.
9. The apparatus of any of claims 6-8, further comprising:
the third determining module is used for determining the reference relationship of each field to be inserted into the data table;
a fourth determining module, configured to determine, when any field in the to-be-inserted data table references second index data, second target data corresponding to the second index data in the common data table;
a fifth determining module, configured to determine an identifier of the second target data in a current system;
the second updating module is used for updating the reference relation of any field according to the identification of the second target data in the current system;
and the inserting module is used for inserting the data table with the updated reference relation in the current system.
10. The apparatus of claim 9, wherein the fourth determining module is specifically configured to:
determining an index field corresponding to the second index data;
determining the type of the second target data according to the incidence relation between the data type and the index field;
and traversing the public data table in the current system to acquire second target data corresponding to the type of the second target data in the public data table.
11. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing a method of processing data as claimed in any one of claims 1 to 5 when executing the program.
12. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out a method for processing data according to any one of claims 1 to 5.
13. A computer program product, characterized in that it comprises a computer program which, when being executed by a processor, carries out a method of processing data according to any one of claims 1 to 5.
CN202111372309.XA 2021-11-18 2021-11-18 Data processing method and device, computer equipment and storage medium Pending CN114077606A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111372309.XA CN114077606A (en) 2021-11-18 2021-11-18 Data processing method and device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111372309.XA CN114077606A (en) 2021-11-18 2021-11-18 Data processing method and device, computer equipment and storage medium

Publications (1)

Publication Number Publication Date
CN114077606A true CN114077606A (en) 2022-02-22

Family

ID=80283916

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111372309.XA Pending CN114077606A (en) 2021-11-18 2021-11-18 Data processing method and device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN114077606A (en)

Similar Documents

Publication Publication Date Title
WO2019051945A1 (en) Insurance data checking method and apparatus, computer device, and storage medium
CN109960678B (en) Naming processing method and computer processing device
CN111813804A (en) Data query method and device, electronic equipment and storage medium
CN109522332A (en) Customer profile data merging method, device, equipment and readable storage medium storing program for executing
CN114461691A (en) Control method and device of state machine, electronic equipment and storage medium
US8312418B2 (en) Visualization of implicit relationships in a trace query for model driven development
CN109033456B (en) Condition query method and device, electronic equipment and storage medium
CN114860699A (en) Data quality detection method, device, equipment and storage medium
CN110990346A (en) File data processing method, device, equipment and storage medium based on block chain
US20170124219A1 (en) Determining data field offsets using a document object model representation
CN111061740B (en) Data synchronization method, device and storage medium
CN108228611B (en) Document information copying method and device
US20110022901A1 (en) Method for testing hard disks under an extensible firmware interface
CN111897837B (en) Data query method, device, equipment and medium
CN114077606A (en) Data processing method and device, computer equipment and storage medium
CN110674084A (en) Method, apparatus, and computer-readable storage medium for data protection
CN114527907A (en) Menu data processing method and device, computer equipment and storage medium
CN103870603A (en) Directory management method and electronic device
CN114328552A (en) Database management method, system and computer readable medium
CN114116907A (en) Database synchronization method and device, electronic equipment and storage medium
CN109783745B (en) Method, device and computer equipment for personalized typesetting of pages
CN110413165B (en) Icon configuration method and device, electronic equipment and computer readable medium
CN109086328B (en) Method and device for determining upper and lower position relation, server and storage medium
CN114064652A (en) Data processing method and device, computer equipment and storage medium
CN111881381A (en) Display method, device, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination