CN114979120A - Data uploading method, device, equipment and storage medium - Google Patents
Data uploading method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN114979120A CN114979120A CN202210575850.9A CN202210575850A CN114979120A CN 114979120 A CN114979120 A CN 114979120A CN 202210575850 A CN202210575850 A CN 202210575850A CN 114979120 A CN114979120 A CN 114979120A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- template
- uploading
- fields
- 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.)
- Granted
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
-
- 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
- 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
Abstract
The invention relates to a data processing technology, and discloses a data uploading method, which comprises the following steps: the method comprises the steps of obtaining form data to be uploaded, extracting data fields of the form data, and identifying form types of the form data; matching the data field with a template field in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data field into a data filling frame corresponding to the template field of the data uploading template to obtain a data uploading file; according to the table type, inquiring a data storage table of the data uploading file from a preset database; and storing the data uploading file into the data storage table. The invention also provides a data uploading method, a data uploading device, data uploading equipment and a storage medium. The invention can improve the data uploading efficiency.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data uploading method and apparatus, an electronic device, and a computer-readable storage medium.
Background
Management of data often plays an important role in the development of enterprises, wherein the data can be sourced from various ways, such as manually entered data, imported data from a local data system, or downloaded data in a network, and the collected data is usually Excel data. The data analysis can extract effective information in the Excel data, and the effective information can be classified and stored in a database through data fields in the effective information and the categories of the data fields.
Currently, Excel data are generally uploaded manually, data fields are added to the analyzed data according to management requirements, and the Excel data are uploaded to different databases in a classified mode.
Disclosure of Invention
The invention provides a data uploading method, a data uploading device, data uploading equipment and a storage medium, and mainly aims to solve the problem of low data uploading efficiency.
In order to achieve the above object, the present invention provides a data uploading method, including:
the method comprises the steps of obtaining form data to be uploaded, extracting data fields of the form data, and identifying form types of the form data;
matching the data field with a template field in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data field into a data filling frame corresponding to the template field of the data uploading template to obtain a data uploading file;
according to the table type, inquiring a data storage table of the data uploading file from a preset database;
and storing the data uploading file into the data storage table.
Optionally, the matching the data field with a template field in a pre-constructed data upload template includes:
respectively identifying field structures of the data field and the template field, wherein the field structures comprise field lengths and field objects;
according to a field structure in the field structure, performing field length and field object matching on the data field and the model field to obtain a matching result;
and when the matching degree in the matching result reaches a preset matching degree threshold value, the data field is successfully matched with the template field in the pre-constructed data uploading template.
Optionally, the performing, according to a field structure in the field structure, field length and field object matching on the data field and the model field to obtain a matching result includes:
identifying the character lengths of the data field and the template field to obtain the length of the data field and the length of the template field;
carrying out field length comparison on the data field length and the template field length to obtain a length comparison result;
and performing field object matching on the data fields and the template fields with the same field length in the length matching result to obtain a matching result.
Optionally, the performing field object matching on the data field and the template field with the same field length in the length matching result to obtain a matching result includes:
respectively converting the field objects in the data field and the template field with the same field length into a data field vector and a template field vector by adopting a word vector conversion tool;
and calculating the similarity of the field vectors by adopting a pre-constructed similarity formula, and obtaining the matching result after the calculation is finished.
Optionally, the loading the data corresponding to the successfully matched data field into the data filling frame corresponding to the template field of the data upload template to obtain a data upload file includes:
extracting data under a data field corresponding to a template field in the successfully matched data uploading template;
loading the data into a data filling frame corresponding to the template data;
and summarizing the data in the data filling frame under each template field to generate a data uploading file.
Optionally, before matching the data field with a template field in a pre-constructed data upload template, the method includes:
configuring a configuration data field in the data uploading template by using SQL language;
constructing a data uploading rule in the data uploading template;
formulating a data format of the uploaded data in the data uploading template based on the regular expression;
and generating the data uploading template by using the configuration data field, the data uploading rule and the data format of the uploaded data.
Optionally, storing the data upload file in the data storage table includes:
receiving the data uploading file by utilizing the data storage table;
and loading the data uploading file into the data storage table according to the incidence relation between the data fields in the data uploading file and the data fields in the data storage table.
In order to solve the above problem, the present invention further provides a data uploading apparatus, including:
the data processing module is used for acquiring form data to be uploaded, extracting a data field of the form data and identifying a form type of the form data;
the data uploading file generating module is used for matching the data fields with template fields in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data fields into data filling frames corresponding to the template fields of the data uploading template to obtain data uploading files;
the data uploading module is used for inquiring a data storage table of the data uploading file from a preset database according to the table type; and storing the data uploading file into the data storage table.
In order to solve the above problem, the present invention also provides an electronic device, including:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the data upload method described above.
In order to solve the above problem, the present invention further provides a computer-readable storage medium, in which at least one computer program is stored, and the at least one computer program is executed by a processor in an electronic device to implement the data uploading method.
According to the embodiment of the invention, the accurate extraction of the data under the corresponding data field in the form data is completed according to the data field in the form data to be uploaded, so that the extraction accuracy of the form data can be improved. Therefore, the data uploading method, the data uploading device, the electronic equipment and the computer readable storage medium provided by the invention can solve the problem of low data uploading efficiency.
Drawings
Fig. 1 is a schematic flow chart of a data uploading method according to an embodiment of the present invention;
fig. 2 is a functional block diagram of a data uploading apparatus according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device for implementing the data uploading method according to an embodiment of the present invention.
The implementation, functional features and advantages of the present invention will be further described with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The embodiment of the application provides a data uploading method. The execution subject of the data uploading method includes, but is not limited to, at least one of electronic devices such as a server and a terminal that can be configured to execute the method provided by the embodiments of the present application. In other words, the data uploading method may be performed by software or hardware installed in the terminal device or the server device, and the software may be a block chain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like. The server may be an independent server, or may be a cloud server that provides basic cloud computing services such as a cloud service, a cloud database, cloud computing, a cloud function, cloud storage, a Network service, cloud communication, a middleware service, a domain name service, a security service, a Content Delivery Network (CDN), a big data and artificial intelligence platform, and the like.
Fig. 1 is a schematic flow chart of a data uploading method according to an embodiment of the present invention.
In this embodiment, the data uploading method includes:
s1, acquiring form data to be uploaded, identifying the form type of the form data, and extracting the data field of the form data;
in the embodiment of the present invention, the table data may be data that can be queried and indexed and needs to be stored in a database, and is generated based on different business scenarios, for example, in a business operation scenario, the table data to be uploaded may be data of information of a competitor, advantages and disadvantages of a product of an enterprise and a preference of a user, and in a commodity transaction scenario, the table data to be uploaded may be order data for completing a transaction.
In the embodiment of the present invention, the form category may be a category label for performing form data classification based on different scenarios, for example, the form category may be an order information category, a product detail category, and the like in a commodity transaction scenario.
In the embodiment of the present invention, the data field may be a specific field corresponding to data in table data, and for example, in order data, the data field may be "order setup time", "order product", and "order number".
In detail, the identifying the table category of the table data includes: extracting a subject field of the table data; and inquiring the category of the subject field in a preset subject category base table to obtain the table category of the table data.
In the embodiment of the present invention, the preset theme category base table may be a theme category table of table data constructed by using the theme fields of a large number of data tables.
Further, the form data usually has data fields and specific data information corresponding to the data fields, and the data fields can be used for accurately extracting the data corresponding to the data fields by extracting the data fields of the form data, so that the accuracy of data extraction is improved.
And S2, matching the data fields with template fields in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data fields into data filling frames corresponding to the template fields of the data uploading template to obtain the data uploading files.
In the embodiment of the present invention, the pre-constructed data upload template may be a template constructed by extracting important data information in the form data, for example, an order data upload template constructed by "order time", "order number", and "order product", and the important data information in the order data may be accurately acquired by using the order data upload template.
In detail, in the embodiment of the present invention, the data field is matched with a template field in a pre-constructed data upload template, and data corresponding to the data field that is successfully matched is loaded into a data filling frame corresponding to the template field of the data upload template to obtain a data upload file, so that standardization of the data upload file can be achieved, and data upload is completed.
As an embodiment of the present invention, the matching the data field with the template field in the pre-constructed data upload template includes:
respectively identifying field structures of the data field and the template field, wherein the field structures comprise field lengths and field objects;
according to a field structure in the field structure, performing field length and field object matching on the data field and the model field to obtain a matching result;
and when the matching degree in the matching result reaches a preset matching degree threshold value, the data field is successfully matched with the template field in the pre-constructed data uploading template.
In the embodiment of the present invention, the field object refers to specific meanings represented by the data field and each field in the template field, such as an object like "name", "score", or "math".
It should be understood that there will be some deviation between the two fields in performing the field matching, but the expression is consistent, i.e. in the embodiment of the present invention, the preset matching degree threshold may be set to 95%.
Further, the performing field length and field object matching on the data field and the model field according to the field structure in the field structure to obtain a matching result includes:
identifying the character lengths of the data field and the template field to obtain the length of the data field and the length of the template field;
carrying out field length comparison on the data field length and the template field length to obtain a length comparison result;
and performing field object matching on the data fields and the template fields with the same field length in the length matching result to obtain a matching result.
Further, the field object matching is performed on the data field and the template field with the same field length in the length matching result, and a word vector conversion tool can be adopted to respectively convert the data field and the field object in the template field with the same field length into a data field vector and a template field vector; and calculating the similarity of the field vectors by adopting a pre-constructed similarity formula, and obtaining the matching result after the calculation is finished.
In the embodiment of the invention, the pre-constructed Word vector conversion tool can be a Word-vector conversion tool based on a Word2vec model.
In the embodiment of the present invention, the similarity between the data field vector and the template field vector may be calculated by using the following similarity formula:
wherein x is the data field vector, y is the template field vector, θ is an included angle between the data field vector and the template field vector, and Sim (x, y) is the similarity between the data field vector and the template field vector.
Further, the embodiment of the invention extracts the data under the data field corresponding to the template field in the successfully matched data uploading template; loading the data into a data filling frame corresponding to the template data; and summarizing the data in the data filling frame under each template field to generate a data uploading file.
In another optional embodiment of the present invention, before matching the data field with a template field in a pre-constructed data upload template, the method includes: configuring configuration data fields in the data uploading template by using an SQL language; constructing a data uploading rule in the data uploading template; formulating a data format of the uploaded data in the data uploading template based on the regular expression; and generating the data uploading template by using the configuration data field, the data uploading rule and the data format of the uploaded data.
In the embodiment of the invention, the SQL language is a structured language, is a special purpose programming language, is a database query and programming language, and is used for accessing data and querying, updating and managing a database system.
In the embodiment of the present invention, the regular expression is generally used to retrieve and replace texts that conform to a certain pattern (rule), for example, the regular expression may be used to limit the format of uploaded data, for example, the uploaded data cannot be an empty set.
S3, inquiring a data storage table of the data uploading file from a preset database according to the table type;
in detail, according to the table type, the embodiment of the invention queries the data storage table of the data uploading file from a preset database, so that the accurate uploading of the data uploading file can be realized.
As an embodiment of the present invention, the querying a data storage table of the data upload file from a preset database according to the table type includes: indexing a target storage partition matched with the table type in a preset database by using the table type; and extracting a data storage table in the target storage partition.
In the embodiment of the present invention, the data storage table may be a storage format file configured by receiving different types of data upload files in a database, such as an order table data configuration order type storage format file, and a commodity detail table data configuration commodity detail request storage format file.
In the embodiment of the invention, the preset database can be mysql database, oracle database, hiveoracle database and the like
And S4, storing the data uploading file into the data storage table.
In detail, in the embodiment of the present invention, the data storage table is used to receive the data upload file; and loading the data uploading file into the data storage table according to the incidence relation between the data fields in the data uploading file and the data fields in the data storage table, and finishing the uploading of the table data.
It should be understood that the association relationship refers to a matching relationship between data fields in the data upload file and the same data fields in the data storage table, for example, the data fields in the data upload file are the same as the data fields in the data storage table, and since the data in the data upload file is standardized data obtained by performing data processing on table data, the data corresponding to the data fields in the data upload file is randomly arranged and is not consistent with the arrangement sequence of the data fields in the data storage table, so that the data upload file needs to be stored in the data storage table after matching the data fields in the data upload file and the data fields in the data storage table.
According to the embodiment of the invention, the accurate extraction of the data under the corresponding data field in the form data is completed according to the data field in the form data to be uploaded, so that the extraction accuracy of the form data can be improved. Therefore, the data uploading method provided by the invention can solve the problem of low data uploading efficiency.
Fig. 2 is a functional block diagram of a data uploading apparatus according to an embodiment of the present invention.
The data uploading device 100 of the present invention may be installed in an electronic device. According to the realized functions, the data uploading device 100 may include a data processing module 101, a data uploading file generating module 102, and a data uploading module 103. The module of the present invention, which may also be referred to as a unit, refers to a series of computer program segments that can be executed by a processor of an electronic device and that can perform a fixed function, and that are stored in a memory of the electronic device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
the data processing module 101 is configured to obtain form data to be uploaded, extract a data field of the form data, and identify a form category of the form data;
in the embodiment of the present invention, the table data may be data that can be queried and indexed and needs to be stored in a database, and is generated based on different business scenarios, for example, in a business operation scenario, the table data to be uploaded may be data of information of a competitor, advantages and disadvantages of a product of an enterprise and a preference of a user, and in a commodity transaction scenario, the table data to be uploaded may be order data for completing a transaction.
In the embodiment of the present invention, the form category may be a category label for performing form data classification based on different scenarios, for example, the form category may be an order information category, a product detail category, and the like in a commodity transaction scenario.
In the embodiment of the present invention, the data field may be a specific field corresponding to data in table data, and for example, in order data, the data field may be "order setup time", "order product", and "order number".
In detail, the identifying the table category of the table data includes: extracting a subject field of the table data; and inquiring the category of the subject field in a preset subject category base table to obtain the table category of the table data.
In the embodiment of the present invention, the preset theme category base table may be a theme category table of table data constructed by using the theme fields of a large number of data tables.
Further, the form data usually has data fields and specific data information corresponding to the data fields, and the embodiment of the invention can finish the accurate extraction of the data corresponding to the data fields by the data fields through extracting the data fields of the form data, thereby improving the accuracy of data extraction.
The data upload file generation module 102 is configured to match the data field with a template field in a pre-constructed data upload template, and load data corresponding to the successfully matched data field into a data filling frame corresponding to the template field of the data upload template to obtain a data upload file;
in the embodiment of the present invention, the pre-constructed data upload template may be a template constructed by extracting important data information in the form data, for example, an order data upload template constructed by "order time", "order number", and "order product", and the important data information in the order data may be accurately acquired by using the order data upload template.
In detail, in the embodiment of the present invention, the data field is matched with a template field in a pre-constructed data upload template, and data corresponding to the data field that is successfully matched is loaded into a data filling frame corresponding to the template field of the data upload template to obtain a data upload file, so that standardization of the data upload file can be achieved, and data upload is completed.
As an embodiment of the present invention, the matching the data field with the template field in the pre-constructed data upload template includes:
respectively identifying field structures of the data field and the template field, wherein the field structures comprise field lengths and field objects;
according to a field structure in the field structure, performing field length and field object matching on the data field and the model field to obtain a matching result;
and when the matching degree in the matching result reaches a preset matching degree threshold value, the data field is successfully matched with the template field in the pre-constructed data uploading template.
In the embodiment of the present invention, the field object refers to specific meanings of representations of each field in the data field and the template field, such as objects of "name", "score", or "math".
It should be understood that there will be some deviation between the two fields in performing the field matching, but the expression is consistent, i.e. in the embodiment of the present invention, the preset matching degree threshold may be set to 95%.
Further, the performing field length and field object matching on the data field and the model field according to the field structure in the field structure to obtain a matching result includes:
identifying the character lengths of the data field and the template field to obtain the length of the data field and the length of the template field;
carrying out field length comparison on the data field length and the template field length to obtain a length comparison result;
and performing field object matching on the data fields and the template fields with the same field length in the length matching result to obtain a matching result.
Further, the field object matching is performed on the data field and the template field with the same field length in the length matching result, and a word vector conversion tool can be adopted to respectively convert the data field and the field object in the template field with the same field length into a data field vector and a template field vector; and calculating the similarity of the field vectors by adopting a pre-constructed similarity formula, and obtaining the matching result after the calculation is finished.
In the embodiment of the invention, the pre-constructed Word vector conversion tool can be a Word-vector conversion tool based on a Word2vec model.
In the embodiment of the present invention, the similarity between the data field vector and the template field vector may be calculated by using the following similarity formula:
wherein x is the data field vector, y is the template field vector, θ is an included angle between the data field vector and the template field vector, and Sim (x, y) is the similarity between the data field vector and the template field vector.
Further, the embodiment of the invention extracts the data under the data field corresponding to the template field in the successfully matched data uploading template; loading the data into a data filling frame corresponding to the template data; and summarizing the data in the data filling frame under each template field to generate a data uploading file.
In another optional embodiment of the present invention, before matching the data field with a template field in a pre-constructed data upload template, the method includes: configuring a configuration data field in the data uploading template by using SQL language; constructing a data uploading rule in the data uploading template; formulating a data format of the uploaded data in the data uploading template based on the regular expression; and generating the data uploading template by using the configuration data field, the data uploading rule and the data format of the uploaded data.
In the embodiment of the invention, the SQL language is a structured language, is a special purpose programming language, is a database query and programming language, and is used for accessing data and querying, updating and managing a database system.
In the embodiment of the present invention, the regular expression is generally used to retrieve and replace texts that conform to a certain pattern (rule), for example, the regular expression may be used to limit the format of uploaded data, for example, the uploaded data cannot be an empty set.
The data uploading module 103 is configured to query a data storage table of the data uploading file from a preset database according to the table type; and storing the data uploading file into the data storage table.
In detail, according to the table type, the embodiment of the invention queries the data storage table of the data uploading file from a preset database, so that the accurate uploading of the data uploading file can be realized.
As an embodiment of the present invention, the querying a data storage table of the data upload file from a preset database according to the table type includes: indexing a target storage partition matched with the table type in a preset database by using the table type; and extracting a data storage table in the target storage partition.
In the embodiment of the present invention, the data storage table may be a storage format file configured by receiving different types of data upload files in a database, such as an order table data configuration order type storage format file, and a commodity detail table data configuration commodity detail request storage format file.
In the embodiment of the invention, the preset database can be mysql database, oracle database, hiveoracle database and the like
In detail, in the embodiment of the present invention, the data storage table is used to receive the data upload file; and loading the data uploading file into the data storage table according to the incidence relation between the data fields in the data uploading file and the data fields in the data storage table, and finishing the uploading of the table data.
It should be understood that the association relationship refers to a matching relationship between data fields in the data upload file and the same data fields in the data storage table, for example, the data fields in the data upload file are the same as the data fields in the data storage table, and since the data in the data upload file is standardized data obtained by performing data processing on table data, the data corresponding to the data fields in the data upload file is randomly arranged and is not consistent with the arrangement sequence of the data fields in the data storage table, so that the data upload file needs to be stored in the data storage table after matching the data fields in the data upload file and the data fields in the data storage table.
According to the embodiment of the invention, the accurate extraction of the data under the corresponding data field in the table data is completed according to the data field in the table data to be uploaded, so that the extraction accuracy of the table data can be improved, and furthermore, the scheme can utilize the data uploading rule and the data uploading format configured in the pre-constructed data uploading template, and can realize the automatic matching uploading of the data under the corresponding data field in the table data. Therefore, the data uploading method provided by the invention can solve the problem of low data uploading efficiency.
Fig. 3 is a schematic structural diagram of an electronic device for implementing a data uploading method according to an embodiment of the present invention.
The electronic device 1 may include a processor 10, a memory 11, a communication bus 12, and a communication interface 13, and may further include a computer program, such as a data upload program, stored in the memory 11 and executable on the processor 10.
In some embodiments, the processor 10 may be composed of an integrated circuit, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged with the same function or different functions, and includes one or more Central Processing Units (CPUs), a microprocessor, a digital Processing chip, a graphics processor, a combination of various control chips, and the like. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects various components of the electronic device by using various interfaces and lines, and executes various functions and processes data of the electronic device by running or executing programs or modules (for example, executing a data uploading program, etc.) stored in the memory 11 and calling data stored in the memory 11.
The memory 11 includes at least one type of readable storage medium including flash memory, removable hard disks, multimedia cards, card-type memory (e.g., SD or DX memory, etc.), magnetic memory, magnetic disks, optical disks, etc. The memory 11 may in some embodiments be an internal storage unit of the electronic device, for example a removable hard disk of the electronic device. The memory 11 may also be an external storage device of the electronic device in other embodiments, such as a plug-in mobile hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the electronic device. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic device. The memory 11 may be used not only to store application software installed in the electronic device and various types of data, such as codes of a data uploading program, but also to temporarily store data that has been output or will be output.
The communication bus 12 may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is arranged to enable connection communication between the memory 11 and at least one processor 10 or the like.
The communication interface 13 is used for communication between the electronic device and other devices, and includes a network interface and a user interface. Optionally, the network interface may include a wired interface and/or a wireless interface (e.g., WI-FI interface, bluetooth interface, etc.), which are typically used to establish a communication connection between the electronic device and other electronic devices. The user interface may be a Display (Display), an input unit, such as a Keyboard (Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable, among other things, for displaying information processed in the electronic device and for displaying a visualized user interface.
Fig. 3 shows only an electronic device with components, and it will be understood by those skilled in the art that the structure shown in fig. 3 does not constitute a limitation of the electronic device 1, and may comprise fewer or more components than those shown, or some components may be combined, or a different arrangement of components.
For example, although not shown, the electronic device may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so that functions of charge management, discharge management, power consumption management and the like are realized through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The electronic device may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
The data uploading program stored in the memory 11 of the electronic device 1 is a combination of instructions, and when running in the processor 10, can realize:
the method comprises the steps of obtaining form data to be uploaded, extracting data fields of the form data, and identifying form types of the form data;
matching the data field with a template field in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data field into a data filling frame corresponding to the template field of the data uploading template to obtain a data uploading file;
according to the table type, inquiring a data storage table of the data uploading file from a preset database;
and storing the data uploading file into the data storage table.
Specifically, the specific implementation method of the instruction by the processor 10 may refer to the description of the relevant steps in the embodiment corresponding to the drawings, which is not described herein again.
Further, the integrated modules/units of the electronic device 1, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. The computer readable storage medium may be volatile or non-volatile. For example, the computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM).
The present invention also provides a computer-readable storage medium, storing a computer program which, when executed by a processor of an electronic device, may implement:
the method comprises the steps of obtaining form data to be uploaded, extracting data fields of the form data, and identifying form types of the form data;
matching the data field with a template field in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data field into a data filling frame corresponding to the template field of the data uploading template to obtain a data uploading file;
according to the table type, inquiring a data storage table of the data uploading file from a preset database;
and storing the data uploading file into the data storage table.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof.
The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a string of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, which is used for verifying the validity (anti-counterfeiting) of the information and generating a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
The embodiment of the application can acquire and process related data based on an artificial intelligence technology. Among them, Artificial Intelligence (AI) is a theory, method, technique and application system that simulates, extends and expands human Intelligence using a digital computer or a machine controlled by a digital computer, senses the environment, acquires knowledge and uses the knowledge to obtain the best result.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the system claims may also be implemented by one unit or means in software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only intended to illustrate the technical solutions of the present invention and not to limit the same, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.
Claims (10)
1. A method for uploading data, the method comprising:
the method comprises the steps of obtaining form data to be uploaded, extracting data fields of the form data, and identifying form types of the form data;
matching the data fields with template fields in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data fields into data filling frames corresponding to the template fields of the data uploading template to obtain data uploading files;
according to the table type, inquiring a data storage table of the data uploading file from a preset database;
and storing the data uploading file into the data storage table.
2. The data upload method of claim 1 wherein matching the data fields with template fields in a pre-constructed data upload template comprises:
respectively identifying field structures of the data field and the template field, wherein the field structures comprise field lengths and field objects;
according to a field structure in the field structure, performing field length and field object matching on the data field and the model field to obtain a matching result;
and when the matching degree in the matching result reaches a preset matching degree threshold value, the data field is successfully matched with the template field in the pre-constructed data uploading template.
3. The data uploading method of claim 2, wherein said performing field length and field object matching on the data field and the model field according to the field structure in the field structure to obtain a matching result comprises:
identifying the character lengths of the data field and the template field to obtain the length of the data field and the length of the template field;
carrying out field length comparison on the data field length and the template field length to obtain a length comparison result;
and performing field object matching on the data fields and the template fields with the same field length in the length matching result to obtain a matching result.
4. The data uploading method of claim 3, wherein said performing field object matching on data fields and template fields with the same field length in said length matching result to obtain a matching result comprises:
respectively converting the field objects in the data field and the template field with the same field length into a data field vector and a template field vector by adopting a word vector conversion tool;
and calculating the similarity of the field vectors by adopting a pre-constructed similarity formula, and obtaining the matching result after the calculation is finished.
5. The data uploading method according to claim 1, wherein the loading the data corresponding to the successfully matched data field into the data filling frame corresponding to the template field of the data uploading template to obtain the data uploading file comprises:
extracting data under a data field corresponding to a template field in the successfully matched data uploading template;
loading the data into a data filling frame corresponding to the template data;
and summarizing the data in the data filling frame under each template field to generate a data uploading file.
6. The data upload method of claim 1, wherein prior to matching the data fields with template fields in a pre-built data upload template, comprising:
configuring a configuration data field in the data uploading template by using SQL language;
constructing a data uploading rule in the data uploading template;
formulating a data format of the uploaded data in the data uploading template based on a regular expression;
and generating the data uploading template by using the configuration data field, the data uploading rule and the data format of the uploaded data.
7. The data upload method of claim 1, wherein storing the data upload file into the data storage table comprises:
receiving the data uploading file by utilizing the data storage table;
and loading the data uploading file into the data storage table according to the incidence relation between the data fields in the data uploading file and the data fields in the data storage table.
8. An apparatus for uploading data, the apparatus comprising:
the data processing module is used for acquiring form data to be uploaded, extracting a data field of the form data and identifying a form type of the form data;
the data uploading file generating module is used for matching the data fields with template fields in a pre-constructed data uploading template, and loading the data corresponding to the successfully matched data fields into data filling frames corresponding to the template fields of the data uploading template to obtain data uploading files;
the data uploading module is used for inquiring a data storage table of the data uploading file from a preset database according to the table type; and storing the data uploading file into the data storage table.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform the data upload method of any of claims 1 to 7.
10. A computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the data uploading method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210575850.9A CN114979120B (en) | 2022-05-24 | 2022-05-24 | Data uploading method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210575850.9A CN114979120B (en) | 2022-05-24 | 2022-05-24 | Data uploading method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114979120A true CN114979120A (en) | 2022-08-30 |
| CN114979120B CN114979120B (en) | 2023-10-13 |
Family
ID=82954864
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210575850.9A Active CN114979120B (en) | 2022-05-24 | 2022-05-24 | Data uploading method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114979120B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116319718A (en) * | 2023-03-10 | 2023-06-23 | 北京振中电子技术有限公司 | Cloud data storage processing method, system, equipment and medium |
| CN116842223A (en) * | 2023-08-29 | 2023-10-03 | 天津鑫宝龙电梯集团有限公司 | Working condition data management method, device, equipment and medium |
| CN116912005A (en) * | 2023-07-17 | 2023-10-20 | 广东企企通科技有限公司 | Financing information tracking management method, device, equipment and medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109815276A (en) * | 2018-12-14 | 2019-05-28 | 中国平安财产保险股份有限公司 | Method, apparatus, computer equipment and the storage medium of declaration form extraction data |
| CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
| CN110569341A (en) * | 2019-07-25 | 2019-12-13 | 深圳壹账通智能科技有限公司 | method and device for configuring chat robot, computer equipment and storage medium |
| CN112565393A (en) * | 2020-12-01 | 2021-03-26 | 平安科技（深圳）有限公司 | File uploading method, file downloading method, file uploading device, file downloading device, computer equipment and storage medium |
| CN112965982A (en) * | 2021-03-16 | 2021-06-15 | 中国平安财产保险股份有限公司 | Table processing method, device, equipment and storage medium |
| CN114510912A (en) * | 2022-04-20 | 2022-05-17 | 佳瑛科技有限公司 | Method, system, and medium for classifying electronic forms based on a distributed system |
-
2022
- 2022-05-24 CN CN202210575850.9A patent/CN114979120B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109815276A (en) * | 2018-12-14 | 2019-05-28 | 中国平安财产保险股份有限公司 | Method, apparatus, computer equipment and the storage medium of declaration form extraction data |
| CN110569341A (en) * | 2019-07-25 | 2019-12-13 | 深圳壹账通智能科技有限公司 | method and device for configuring chat robot, computer equipment and storage medium |
| WO2021012382A1 (en) * | 2019-07-25 | 2021-01-28 | 深圳壹账通智能科技有限公司 | Method and apparatus for configuring chat robot, computer device and storage medium |
| CN110399420A (en) * | 2019-07-30 | 2019-11-01 | 广州吉信网络科技开发有限公司 | A kind of deriving method, electronic equipment and the medium of configurableization Excel format |
| CN112565393A (en) * | 2020-12-01 | 2021-03-26 | 平安科技（深圳）有限公司 | File uploading method, file downloading method, file uploading device, file downloading device, computer equipment and storage medium |
| CN112965982A (en) * | 2021-03-16 | 2021-06-15 | 中国平安财产保险股份有限公司 | Table processing method, device, equipment and storage medium |
| CN114510912A (en) * | 2022-04-20 | 2022-05-17 | 佳瑛科技有限公司 | Method, system, and medium for classifying electronic forms based on a distributed system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116319718A (en) * | 2023-03-10 | 2023-06-23 | 北京振中电子技术有限公司 | Cloud data storage processing method, system, equipment and medium |
| CN116319718B (en) * | 2023-03-10 | 2023-12-12 | 北京振中电子技术有限公司 | Cloud data storage processing method, system, equipment and medium |
| CN116912005A (en) * | 2023-07-17 | 2023-10-20 | 广东企企通科技有限公司 | Financing information tracking management method, device, equipment and medium |
| CN116842223A (en) * | 2023-08-29 | 2023-10-03 | 天津鑫宝龙电梯集团有限公司 | Working condition data management method, device, equipment and medium |
| CN116842223B (en) * | 2023-08-29 | 2023-11-10 | 天津鑫宝龙电梯集团有限公司 | Working condition data management method, device, equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114979120B (en) | 2023-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112052370A (en) | Message generation method and device, electronic equipment and computer readable storage medium | |
| CN114979120B (en) | Data uploading method, device, equipment and storage medium | |
| CN111428458A (en) | Universal report generation method and device and computer readable storage medium | |
| CN112418798A (en) | Information auditing method and device, electronic equipment and storage medium | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN112231417A (en) | Data classification method and device, electronic equipment and storage medium | |
| CN113961473A (en) | Data testing method and device, electronic equipment and computer readable storage medium | |
| CN112115152A (en) | Data increment updating and querying method and device, electronic equipment and storage medium | |
| CN112528616A (en) | Business form generation method and device, electronic equipment and computer storage medium | |
| CN114398346A (en) | Data migration method, device, equipment and storage medium | |
| CN114386509A (en) | Data fusion method and device, electronic equipment and storage medium | |
| CN114708461A (en) | Multi-modal learning model-based classification method, device, equipment and storage medium | |
| CN114491047A (en) | Multi-label text classification method and device, electronic equipment and storage medium | |
| CN113434542A (en) | Data relation identification method and device, electronic equipment and storage medium | |
| CN111538768A (en) | Data query method and device based on N-element model, electronic equipment and medium | |
| CN115496166A (en) | Multitasking method and device, electronic equipment and storage medium | |
| CN114840388A (en) | Data monitoring method and device, electronic equipment and storage medium | |
| CN115114297A (en) | Data lightweight storage and search method and device, electronic equipment and storage medium | |
| CN115220740A (en) | Database environment deployment method and device, electronic equipment and storage medium | |
| CN113743802A (en) | Work order intelligent matching method and device, electronic equipment and readable storage medium | |
| CN112506931A (en) | Data query method and device, electronic equipment and storage medium | |
| CN112631589A (en) | Application program home page layout configuration method and device, electronic equipment and storage medium | |
| CN113421009B (en) | Accessory approval method and device, electronic equipment and readable storage medium | |
| CN113868285A (en) | Data reading method and device, electronic equipment and storage medium | |
| CN113434414A (en) | Data testing method and device, electronic 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |