CN114077606A - Data processing method and device, computer equipment and storage medium - Google Patents
Data processing method and device, computer equipment and storage medium Download PDFInfo
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational 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
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:
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.
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:
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.
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.
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.
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.
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.
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.
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) |
-
2021
- 2021-11-18 CN CN202111372309.XA patent/CN114077606A/en active Pending
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 |