CN116720490A - Data importing method and device - Google Patents
Data importing method and device Download PDFInfo
- Publication number
- CN116720490A CN116720490A CN202311008366.9A CN202311008366A CN116720490A CN 116720490 A CN116720490 A CN 116720490A CN 202311008366 A CN202311008366 A CN 202311008366A CN 116720490 A CN116720490 A CN 116720490A
- Authority
- CN
- China
- Prior art keywords
- tree
- target system
- coding rule
- data
- coding
- 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
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000010276 construction Methods 0.000 claims description 27
- 238000004590 computer program Methods 0.000 claims description 22
- 230000008676 import Effects 0.000 claims description 18
- 239000003086 colorant Substances 0.000 claims description 6
- 238000012790 confirmation Methods 0.000 claims description 3
- 238000004891 communication Methods 0.000 description 16
- 230000006870 function Effects 0.000 description 15
- 238000010586 diagram Methods 0.000 description 13
- 238000011161 development Methods 0.000 description 9
- 238000012545 processing Methods 0.000 description 7
- 238000013461 design Methods 0.000 description 6
- 239000000872 buffer Substances 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 2
- 238000009435 building construction Methods 0.000 description 2
- 230000001413 cellular effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000000547 structure data Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a data importing method and device, wherein the method comprises the following steps: determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm; determining a tree coding column according to the association relation, and loading the tree coding column to a target system; the application can facilitate the data importing operation and greatly reduce the importing cost.
Description
Technical Field
The present application relates to the field of data processing, and in particular, to a data importing method and apparatus.
Background
In the building construction industry, the engineering quantity list is one of the necessary dimensions of digital management, and the engineering quantity list of each project is numerous, from few thousands to hundreds of thousands. Typically, the initial data for the project work amount inventory is derived from a list of drawings provided by the architectural design institute. However, to achieve the importing of the engineering quantity list of each project into the system, the purely manual entry method is not practical, so that the importing operation needs to be performed by means of an Excel table. Under the condition, the tree structure data is automatically constructed according to the codes in Excel, and the efficient and easy-to-use importing function is crucial for successful landing of the informatization in the building construction industry.
However, in the construction enterprises, different types of projects such as highway engineering and house construction engineering are accepted, so that corresponding national standards are also different, and the coding rules of the engineering quantity lists are obviously different. Even for the same type of project, the coding rules of the project volume list may be different due to the different architectural design units of each project. In this case, the cost of introducing the engineering quantity list is high, and great difficulty is brought to development.
The inventors found that the data import development costs in the prior art are high. It is difficult to exhaust all possible coding rules due to the multiple architectural design homes and different engineering types involved. Furthermore, even under the same engineering type and the same architectural design unit, the habits of different designers may lead to differences in the coding rules of the engineering quantity list. These factors all result in very high development costs to deal with engineering quantity inventory coding rules.
The system delay risk is large. In the system online process, if customized development is not performed before a list of different coding rules is taken, the engineering quantity list cannot be timely input into the system. This will result in that the subsequent business will not be performed smoothly, and the originally established online plan will not be implemented. Eventually, project delay can be caused, and unnecessary economic loss and reputation influence are brought to enterprises.
Disclosure of Invention
Aiming at the problems in the prior art, the application provides the data importing method and the device, which can lead the data importing operation to be more convenient and greatly reduce the importing cost.
In order to solve at least one of the problems, the application provides the following technical scheme:
in a first aspect, the present application provides a data importing method, including:
determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
and determining a tree coding column according to the association relation, and loading the tree coding column to a target system.
Further, the determining the tree-shaped code column according to the association relation and loading the tree-shaped code column to a target system includes:
judging whether a corresponding coding rule exists in an item coding rule base of the target system or not;
and if the code exists, automatically constructing a tree type lead-in target system according to the coding rule in the target system.
Further, after the determining whether the corresponding encoding rule already exists in the item encoding rule base of the target system, the method includes:
if the corresponding coding rule does not exist, searching whether the affiliated engineering type exists in an engineering type coding rule library or not;
and if the tree type coding rule exists, tree type construction is carried out according to the engineering type coding rule.
Further, after the tree construction according to the engineering type coding rule, the method includes:
judging whether nodes which do not meet the rule and are not successfully constructed exist or not;
if yes, the searching and updating of the parent node are carried out again according to the tree construction algorithm.
Further, after the tree-based construction algorithm re-performs the search update of the parent node, the method includes:
if the nodes which do not accord with the rule exist or the nodes which are constructed in the tree form and are possibly problematic are judged, popping up the tree-form interface, and distinguishing the nodes from the tree-form interface by using colors;
and adjusting or directly confirming the problematic nodes, and pushing the coding rules forming the project into a project coding rule library.
In a second aspect, the present application provides a data importing apparatus, including:
the association relation determining module is used for determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
and the tree code loading module is used for determining a tree code column according to the association relation and loading the tree code column to a target system.
Further, the tree code loading module includes:
the coding rule judging unit is used for judging whether a corresponding coding rule exists in the item coding rule base of the target system or not;
and the automatic construction unit is used for automatically constructing a tree type lead-in target system according to the coding rules in the target system if the tree type lead-in target system exists.
Further, the tree code loading module further includes:
the engineering type searching unit is used for searching whether the engineering type exists in the engineering type coding rule library if the corresponding coding rule does not exist;
and the engineering code construction unit is used for constructing a tree according to the engineering type coding rule if the engineering code exists.
Further, the tree code loading module further includes:
a failure node query unit, configured to determine whether there are any nodes that fail to satisfy the rule and are not successfully constructed;
and the searching and updating unit is used for carrying out searching and updating on the parent node again according to the tree construction algorithm if the result is yes.
Further, the tree code loading module further includes:
a color distinguishing unit for popping up the tree-shaped interface if there is a node which does not meet the rule or a node which is built into the tree shape and is judged to be possibly problematic, and distinguishing the two by colors;
and the adjustment confirmation unit is used for adjusting or directly confirming the problematic node, and pushing the coding rules forming the project into the project coding rule library.
In a third aspect, the present application provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the data import method when executing the program.
In a fourth aspect, the present application provides a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the data import method.
In a fifth aspect, the application provides a computer program product comprising computer programs/instructions which when executed by a processor implement the steps of the data import method.
According to the technical scheme, the application provides a data importing method and device, and the association relation between the columns in the imported data table and the columns in the target system is determined according to a preset editing distance algorithm; and determining a tree coding column according to the association relation, and loading the tree coding column to a target system, so that the data importing operation is more convenient, and the importing cost is greatly reduced.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a data importing method according to an embodiment of the present application;
FIG. 2 is a second flow chart of a data importing method according to an embodiment of the present application;
FIG. 3 is a third flow chart of a data importing method according to an embodiment of the present application;
FIG. 4 is a flowchart of a data importing method according to an embodiment of the present application;
FIG. 5 is a flowchart of a data importing method according to an embodiment of the present application;
FIG. 6 is a block diagram of a data importing apparatus according to an embodiment of the present application;
FIG. 7 is a second block diagram of a data importing apparatus according to an embodiment of the present application;
FIG. 8 is a third block diagram of a data importing apparatus according to an embodiment of the present application;
FIG. 9 is a diagram showing a structure of a data import apparatus according to an embodiment of the present application;
FIG. 10 is a diagram showing a structure of a data import apparatus according to an embodiment of the present application;
fig. 11 is a schematic structural diagram of an electronic device in an embodiment of the application.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present application more apparent, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments of the present application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The technical scheme of the application obtains, stores, uses, processes and the like the data, which all meet the relevant regulations of national laws and regulations.
The development cost of data import in the prior art is considered to be high. It is difficult to exhaust all possible coding rules due to the multiple architectural design homes and different engineering types involved. Furthermore, even under the same engineering type and the same architectural design unit, the habits of different designers may lead to differences in the coding rules of the engineering quantity list. These factors all result in very high development costs to deal with engineering quantity inventory coding rules. The system delay risk is large. In the system online process, if customized development is not performed before a list of different coding rules is taken, the engineering quantity list cannot be timely input into the system. This will result in that the subsequent business will not be performed smoothly, and the originally established online plan will not be implemented. The application provides a data importing method and a device, which can cause project delay and bring unnecessary economic loss and reputation influence to enterprises, and the method and the device determine the association relationship between the columns in an imported data table and the columns in a target system according to a preset editing distance algorithm; and determining a tree coding column according to the association relation, and loading the tree coding column to a target system, so that the data importing operation is more convenient, and the importing cost is greatly reduced.
In order to make the data importing operation more convenient and greatly reduce the importing cost, the application provides an embodiment of a data importing method, referring to fig. 1, the data importing method specifically includes the following steps:
step S101: determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
optionally, after the local Excel is selected to be opened, the system automatically matches the column in the Excel with the column to be imported into the system according to the edit distance algorithm, establishes the association relationship, and confirms the coding column to be subjected to tree construction.
Step S102: and determining a tree coding column according to the association relation, and loading the tree coding column to a target system.
Optionally, the application can load the data of the code column into the system, if the system disk has the code rule in the item code rule base, automatically building a tree type according to the code rule in the system to be imported into the system if the code rule exists, if the code rule base does not exist, searching whether the project type to which the item belongs exists in the project type code rule base, if the project type code rule base exists, firstly performing tree type construction according to the project type code rule, if the project does not exist, then re-performing searching and updating of the father level node according to the tree type construction algorithm.
As can be seen from the above description, the data importing method provided by the embodiment of the present application can determine the association relationship between the columns in the imported data table and the columns in the target system according to the preset editing distance algorithm; and determining a tree coding column according to the association relation, and loading the tree coding column to a target system, so that the data importing operation is more convenient, and the importing cost is greatly reduced.
In an embodiment of the data importing method of the present application, referring to fig. 2, the following may be further included:
step S201: judging whether a corresponding coding rule exists in an item coding rule base of the target system or not;
step S202: and if the code exists, automatically constructing a tree type lead-in target system according to the coding rule in the target system.
Optionally, the application can load the data of the code column into the system, if the system disk has the code rule in the item code rule base, the tree type import system is automatically constructed according to the code rule in the system.
In an embodiment of the data importing method of the present application, referring to fig. 3, the following may be further included:
step S301: if the corresponding coding rule does not exist, searching whether the affiliated engineering type exists in an engineering type coding rule library or not;
step S302: and if the tree type coding rule exists, tree type construction is carried out according to the engineering type coding rule.
If the project coding rule base does not exist, searching whether the project type to which the project belongs exists in the project type coding rule base, and if so, firstly constructing a tree according to the project type coding rule.
In an embodiment of the data importing method of the present application, referring to fig. 4, the following may be further included:
step S401: judging whether nodes which do not meet the rule and are not successfully constructed exist or not;
step S402: if yes, the searching and updating of the parent node are carried out again according to the tree construction algorithm.
Optionally, in the application, if there are nodes which do not meet the rule and are not successfully constructed, the searching and updating of the parent node are carried out again according to the tree construction algorithm.
In an embodiment of the data importing method of the present application, referring to fig. 5, the following may be further included:
step S501: if the nodes which do not accord with the rule exist or the nodes which are constructed in the tree form and are possibly problematic are judged, popping up the tree-form interface, and distinguishing the nodes from the tree-form interface by using colors;
step S502: and adjusting or directly confirming the problematic nodes, and pushing the coding rules forming the project into a project coding rule library.
Optionally, in the present application, if there is a node which does not conform to the rule or is constructed into the tree to determine a node which may have a problem, the tree interface is popped up, and the two are distinguished by color, and the problematic node is adjusted or directly confirmed, so that the encoding rule forming the item is pushed into the item encoding rule library. When other functions are imported, the rule can be directly used for tree construction.
As can be seen from the above, the present application can achieve at least the following technical effects:
1. the development workload is reduced, and the working efficiency is improved: when a new project is introduced into a new coding scheme, customized development is not needed;
2. manual intervention is reduced, and error rate is reduced: the system automatically identifies the upper and lower relationships and identifies the nodes which are likely to have problems, and a user only needs to confirm whether the nodes which are likely to have problems or not and make corresponding adjustment.
In order to make the data importing operation more convenient and greatly reduce the importing cost, the present application provides an embodiment of a data importing apparatus for implementing all or part of the content of the data importing method, referring to fig. 6, the data importing apparatus specifically includes:
the association relation determining module 10 is used for determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
and the tree code loading module 20 is used for determining a tree code column according to the association relation and loading the tree code column to a target system.
As can be seen from the above description, the data importing device provided by the embodiment of the present application is capable of determining the association relationship between the columns in the imported data table and the columns in the target system according to the preset editing distance algorithm; and determining a tree coding column according to the association relation, and loading the tree coding column to a target system, so that the data importing operation is more convenient, and the importing cost is greatly reduced.
In an embodiment of the data importing apparatus of the present application, referring to fig. 7, the tree code loading module 20 includes:
a coding rule judging unit 21 for judging whether a corresponding coding rule already exists in an item coding rule base of the target system;
an automatic construction unit 22 for automatically constructing a tree-type import into the target system according to the coding rules in the target system, if any.
In an embodiment of the data importing apparatus of the present application, referring to fig. 8, the tree code loading module 20 further includes:
an engineering type searching unit 23, configured to search whether the engineering type to which the engineering type belongs exists in the engineering type coding rule library if the corresponding coding rule does not exist;
an engineering code construction unit 24 for performing tree construction according to the engineering type coding rule, if any.
In an embodiment of the data importing apparatus of the present application, referring to fig. 9, the tree code loading module 20 further includes:
a failed node query unit 25, configured to determine whether there are any nodes that fail to satisfy the rule and are not successfully constructed;
and the searching and updating unit 26 is configured to, if yes, re-perform searching and updating of the parent node according to the tree construction algorithm.
In an embodiment of the data importing apparatus of the present application, referring to fig. 10, the tree code loading module 20 further includes:
a color discrimination unit 27 for popping up the tree-type interface if there are nodes which do not meet the rule or nodes which are constructed into the tree-type and are judged to be possibly problematic, and discriminating the two with colors;
and the adjustment confirmation unit 28 is used for adjusting or directly confirming the problematic node, and pushing the coding rules forming the project into the project coding rule base.
In order to make the data importing operation more convenient and greatly reduce the importing cost, the application provides an embodiment of an electronic apparatus for implementing all or part of the content in the data importing method, wherein the electronic apparatus specifically comprises the following contents:
a processor (processor), a memory (memory), a communication interface (Communications Interface), and a bus; the processor, the memory and the communication interface complete communication with each other through the bus; the communication interface is used for realizing information transmission between the data importing device and related equipment such as a core service system, a user terminal, a related database and the like; the logic controller may be a desktop computer, a tablet computer, a mobile terminal, etc., and the embodiment is not limited thereto. In this embodiment, the logic controller may refer to the embodiment of the data importing method and the embodiment of the data importing apparatus in the embodiment, and the contents thereof are incorporated herein and will not be repeated here.
It is understood that the user terminal may include a smart phone, a tablet electronic device, a network set top box, a portable computer, a desktop computer, a Personal Digital Assistant (PDA), a vehicle-mounted device, a smart wearable device, etc. Wherein, intelligent wearing equipment can include intelligent glasses, intelligent wrist-watch, intelligent bracelet etc..
In practical applications, part of the data importing method may be executed on the electronic apparatus side as described above, or all operations may be completed in the client apparatus. Specifically, the selection may be made according to the processing capability of the client device, and restrictions of the use scenario of the user. The application is not limited in this regard. If all operations are performed in the client device, the client device may further include a processor.
The client device may have a communication module (i.e. a communication unit) and may be connected to a remote server in a communication manner, so as to implement data transmission with the server. The server may include a server on the side of the task scheduling center, and in other implementations may include a server of an intermediate platform, such as a server of a third party server platform having a communication link with the task scheduling center server. The server may include a single computer device, a server cluster formed by a plurality of servers, or a server structure of a distributed device.
Fig. 11 is a schematic block diagram of a system configuration of an electronic device 9600 according to an embodiment of the present application. As shown in fig. 11, the electronic device 9600 may include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. Notably, this fig. 11 is exemplary; other types of structures may also be used in addition to or in place of the structures to implement telecommunications functions or other functions.
In one embodiment, the data import method functionality may be integrated into the central processor 9100. The central processor 9100 may be configured to perform the following control:
step S101: determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
step S102: and determining a tree coding column according to the association relation, and loading the tree coding column to a target system.
As can be seen from the above description, the electronic device provided by the embodiment of the present application determines the association relationship between the columns in the imported data table and the columns in the target system according to the preset editing distance algorithm; and determining a tree coding column according to the association relation, and loading the tree coding column to a target system, so that the data importing operation is more convenient, and the importing cost is greatly reduced.
In another embodiment, the data import apparatus may be configured separately from the cpu 9100, for example, the data import apparatus may be configured as a chip connected to the cpu 9100, and the function of the data import method is implemented by control of the cpu.
As shown in fig. 11, the electronic device 9600 may further include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is noted that the electronic device 9600 need not include all of the components shown in fig. 11; in addition, the electronic device 9600 may further include components not shown in fig. 11, and reference may be made to the related art.
As shown in fig. 11, the central processor 9100, sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, which central processor 9100 receives inputs and controls the operation of the various components of the electronic device 9600.
The memory 9140 may be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information about failure may be stored, and a program for executing the information may be stored. And the central processor 9100 can execute the program stored in the memory 9140 to realize information storage or processing, and the like.
The input unit 9120 provides input to the central processor 9100. The input unit 9120 is, for example, a key or a touch input device. The power supply 9170 is used to provide power to the electronic device 9600. The display 9160 is used for displaying display objects such as images and characters. The display may be, for example, but not limited to, an LCD display.
The memory 9140 may be a solid state memory such as Read Only Memory (ROM), random Access Memory (RAM), SIM card, etc. But also a memory which holds information even when powered down, can be selectively erased and provided with further data, an example of which is sometimes referred to as EPROM or the like. The memory 9140 may also be some other type of device. The memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application/function storage portion 9142, the application/function storage portion 9142 storing application programs and function programs or a flow for executing operations of the electronic device 9600 by the central processor 9100.
The memory 9140 may also include a data store 9143, the data store 9143 for storing data, such as contacts, digital data, pictures, sounds, and/or any other data used by an electronic device. The driver storage portion 9144 of the memory 9140 may include various drivers of the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging applications, address book applications, etc.).
The communication module 9110 is a transmitter/receiver 9110 that transmits and receives signals via an antenna 9111. A communication module (transmitter/receiver) 9110 is coupled to the central processor 9100 to provide input signals and receive output signals, as in the case of conventional mobile communication terminals.
Based on different communication technologies, a plurality of communication modules 9110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, etc., may be provided in the same electronic device. The communication module (transmitter/receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide audio output via the speaker 9131 and to receive audio input from the microphone 9132 to implement usual telecommunications functions. The audio processor 9130 can include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 9130 is also coupled to the central processor 9100 so that sound can be recorded locally through the microphone 9132 and sound stored locally can be played through the speaker 9131.
The embodiment of the present application also provides a computer-readable storage medium capable of implementing all the steps in the data import method in which the execution subject is a server or a client in the above embodiment, the computer-readable storage medium storing thereon a computer program which, when executed by a processor, implements all the steps in the data import method in which the execution subject is a server or a client in the above embodiment, for example, the processor implements the following steps when executing the computer program:
step S101: determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
step S102: and determining a tree coding column according to the association relation, and loading the tree coding column to a target system.
As can be seen from the above description, the computer-readable storage medium provided by the embodiments of the present application determines the association relationship between the columns in the imported data table and the columns in the target system according to the preset edit distance algorithm; and determining a tree coding column according to the association relation, and loading the tree coding column to a target system, so that the data importing operation is more convenient, and the importing cost is greatly reduced.
The embodiments of the present application also provide a computer program product capable of implementing all the steps in the data importing method in which the execution subject is the server or the client in the above embodiments, where the computer program/instructions implement the steps of the data importing method when executed by the processor, for example, the computer program/instructions implement the steps of:
step S101: determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
step S102: and determining a tree coding column according to the association relation, and loading the tree coding column to a target system.
As can be seen from the above description, the computer program product provided by the embodiments of the present application determines the association relationship between the columns in the imported data table and the columns in the target system according to the preset editing distance algorithm; and determining a tree coding column according to the association relation, and loading the tree coding column to a target system, so that the data importing operation is more convenient, and the importing cost is greatly reduced.
It will be apparent to those skilled in the art that embodiments of the present application may be provided as a method, apparatus, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (devices), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principles and embodiments of the present application have been described in detail with reference to specific examples, which are provided to facilitate understanding of the method and core ideas of the present application; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in accordance with the ideas of the present application, the present description should not be construed as limiting the present application in view of the above.
Claims (13)
1. A method of importing data, the method comprising:
determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
and determining a tree coding column according to the association relation, and loading the tree coding column to a target system.
2. The data importing method according to claim 1, wherein the determining a tree-type code column according to the association relation and loading the tree-type code column to a target system includes:
judging whether a corresponding coding rule exists in an item coding rule base of the target system or not;
and if the code exists, automatically constructing a tree type lead-in target system according to the coding rule in the target system.
3. The data importing method according to claim 2, wherein after the determining whether the corresponding coding rule already exists in the item coding rule base of the target system, comprising:
if the corresponding coding rule does not exist, searching whether the affiliated engineering type exists in an engineering type coding rule library or not;
and if the tree type coding rule exists, tree type construction is carried out according to the engineering type coding rule.
4. A data importing method according to claim 3, wherein after said tree construction according to said engineering type coding rule, comprising:
judging whether nodes which do not meet the rule and are not successfully constructed exist or not;
if yes, the searching and updating of the parent node are carried out again according to the tree construction algorithm.
5. The data importing method according to claim 4, after the tree-based construction algorithm re-performs the search update of the parent node, comprising:
if the nodes which do not accord with the rule exist or the nodes which are constructed in the tree form and are possibly problematic are judged, popping up the tree-form interface, and distinguishing the nodes from the tree-form interface by using colors;
and adjusting or directly confirming the problematic nodes, and pushing the coding rules forming the project into a project coding rule library.
6. A data importing apparatus, comprising:
the association relation determining module is used for determining the association relation between the columns in the imported data table and the columns in the target system according to a preset editing distance algorithm;
and the tree code loading module is used for determining a tree code column according to the association relation and loading the tree code column to a target system.
7. The data importing apparatus of claim 6, wherein the tree code loading module comprises:
the coding rule judging unit is used for judging whether a corresponding coding rule exists in the item coding rule base of the target system or not;
and the automatic construction unit is used for automatically constructing a tree type lead-in target system according to the coding rules in the target system if the tree type lead-in target system exists.
8. The data importing apparatus of claim 7, wherein the tree code loading module further comprises:
the engineering type searching unit is used for searching whether the engineering type exists in the engineering type coding rule library if the corresponding coding rule does not exist;
and the engineering code construction unit is used for constructing a tree according to the engineering type coding rule if the engineering code exists.
9. The data importing apparatus of claim 7, wherein the tree code loading module further comprises:
a failure node query unit, configured to determine whether there are any nodes that fail to satisfy the rule and are not successfully constructed;
and the searching and updating unit is used for carrying out searching and updating on the parent node again according to the tree construction algorithm if the result is yes.
10. The data importing apparatus of claim 7, wherein the tree code loading module further comprises:
a color distinguishing unit for popping up the tree-shaped interface if there is a node which does not meet the rule or a node which is built into the tree shape and is judged to be possibly problematic, and distinguishing the two by colors;
and the adjustment confirmation unit is used for adjusting or directly confirming the problematic node, and pushing the coding rules forming the project into the project coding rule library.
11. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the data import method of any of claims 1 to 5 when the program is executed.
12. A computer-readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the data import method according to any of claims 1 to 5.
13. A computer program product comprising computer programs/instructions which, when executed by a processor, implement the steps of the data import method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311008366.9A CN116720490A (en) | 2023-08-11 | 2023-08-11 | Data importing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311008366.9A CN116720490A (en) | 2023-08-11 | 2023-08-11 | Data importing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116720490A true CN116720490A (en) | 2023-09-08 |
Family
ID=87866535
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311008366.9A Pending CN116720490A (en) | 2023-08-11 | 2023-08-11 | Data importing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116720490A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101001160A (en) * | 2006-12-30 | 2007-07-18 | 华为技术有限公司 | Cooling method and coder |
| CN101097572A (en) * | 2006-06-30 | 2008-01-02 | 西门子（中国）有限公司 | Tree structures list display process having multiple line content node and device thereof |
| CN102096711A (en) * | 2011-01-24 | 2011-06-15 | 四川长虹电器股份有限公司 | Method for constructing tree structural directory in database |
| WO2011146452A1 (en) * | 2010-05-18 | 2011-11-24 | Google Inc. | Data storage and processing service |
| US20190340168A1 (en) * | 2018-05-07 | 2019-11-07 | Microsoft Technology Licensing, Llc | Merging conflict resolution for multi-master distributed databases |
| CN111400387A (en) * | 2020-03-18 | 2020-07-10 | 浩云科技股份有限公司 | Conversion method and device for import and export data, terminal equipment and storage medium |
| CN115617888A (en) * | 2022-09-26 | 2023-01-17 | 中国建设银行股份有限公司 | Data import method, device, equipment, storage medium and product |
| CN115641092A (en) * | 2022-11-08 | 2023-01-24 | 启昇耀康信息科技(上海)有限公司 | Method and system for realizing automatic generation of logic check by importing data check plan |
-
2023
- 2023-08-11 CN CN202311008366.9A patent/CN116720490A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101097572A (en) * | 2006-06-30 | 2008-01-02 | 西门子（中国）有限公司 | Tree structures list display process having multiple line content node and device thereof |
| CN101001160A (en) * | 2006-12-30 | 2007-07-18 | 华为技术有限公司 | Cooling method and coder |
| WO2011146452A1 (en) * | 2010-05-18 | 2011-11-24 | Google Inc. | Data storage and processing service |
| US20120016901A1 (en) * | 2010-05-18 | 2012-01-19 | Google Inc. | Data Storage and Processing Service |
| CN102096711A (en) * | 2011-01-24 | 2011-06-15 | 四川长虹电器股份有限公司 | Method for constructing tree structural directory in database |
| US20190340168A1 (en) * | 2018-05-07 | 2019-11-07 | Microsoft Technology Licensing, Llc | Merging conflict resolution for multi-master distributed databases |
| CN111400387A (en) * | 2020-03-18 | 2020-07-10 | 浩云科技股份有限公司 | Conversion method and device for import and export data, terminal equipment and storage medium |
| CN115617888A (en) * | 2022-09-26 | 2023-01-17 | 中国建设银行股份有限公司 | Data import method, device, equipment, storage medium and product |
| CN115641092A (en) * | 2022-11-08 | 2023-01-24 | 启昇耀康信息科技(上海)有限公司 | Method and system for realizing automatic generation of logic check by importing data check plan |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111031058A (en) | Websocket-based distributed server cluster interaction method and device | |
| CN111679790B (en) | Remote software development storage space allocation method and device | |
| CN116720490A (en) | Data importing method and device | |
| CN111338905A (en) | Application node data processing method and device | |
| CN114285657B (en) | Firewall security policy change verification method and device | |
| CN115562898A (en) | Distributed payment system exception handling method and device | |
| CN115495519A (en) | Report data processing method and device | |
| CN113515447B (en) | Automatic testing method and device for system | |
| CN115205009A (en) | Account opening business processing method and device based on virtual technology | |
| CN114723976A (en) | Subgraph pattern matching method and device for computational graph | |
| CN112965952B (en) | Data asset processing method and device | |
| CN113342811A (en) | HBase table data processing method and device | |
| CN113342501B (en) | System fault processing method and device | |
| CN114637587A (en) | Task batch processing method and device under cluster architecture deployment | |
| CN111736772B (en) | Storage space data processing method and device of distributed file system | |
| CN113094270B (en) | Project automatic verification method and device | |
| CN112766698B (en) | Application service pressure determining method and device | |
| CN114860832A (en) | Credit card integral data processing method and device | |
| CN111949355B (en) | Column menu shielding method and device | |
| CN117974280A (en) | Method and device for establishing bank financial transaction risk feature library | |
| CN118012404A (en) | Rendering engine data communication bridging method and device | |
| CN112766827A (en) | Automatic processing method and device for asset inventory data | |
| CN114880229A (en) | Batch file testing method and device | |
| CN117435402A (en) | Method and device for scheduling tape drives with backup strategy | |
| CN114968257A (en) | HTML code generation method and device |
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 |