CN115169316A - Data processing template generation method and device, electronic equipment and storage medium - Google Patents

Data processing template generation method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN115169316A
CN115169316A CN202210889340.9A CN202210889340A CN115169316A CN 115169316 A CN115169316 A CN 115169316A CN 202210889340 A CN202210889340 A CN 202210889340A CN 115169316 A CN115169316 A CN 115169316A
Authority
CN
China
Prior art keywords
data
template
target
field information
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210889340.9A
Other languages
Chinese (zh)
Inventor
赵晓雨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Agricultural Bank of China
Original Assignee
Agricultural Bank of China
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Agricultural Bank of China filed Critical Agricultural Bank of China
Priority to CN202210889340.9A priority Critical patent/CN115169316A/en
Publication of CN115169316A publication Critical patent/CN115169316A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Abstract

The invention discloses a data processing template generation method, a data processing template generation device, electronic equipment and a storage medium, wherein the method comprises the following steps: determining at least one template to be applied, corresponding template attributes and at least one target data source; extracting data field information from a target data source and determining at least one target field information from the data field information; configuring a data import rule for at least one target field information respectively; and determining a target data processing template matched with at least one target data source based on the template to be applied, the template attribute, the target field information and the data import rule. Based on the technical scheme, the corresponding data processing template can be created based on the selection of the user, and then the data can be processed in batches by calling the data processing template, so that the processing requirements of the user on batch data of different scenes are met.

Description

Data processing template generation method and device, electronic equipment and storage medium
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for generating a data processing template, an electronic device, and a storage medium.
Background
With the development of computer technology, more and more data needs to be processed and stored, and for convenience of data processing and storage, data is often stored in a table form.
However, because the form templates stored in different data are different, different data processing templates are inevitably adopted for processing different data, but the corresponding data processing templates are often manually established by a user during processing, so that the operation complexity is further improved, and the use experience of the user is reduced.
Disclosure of Invention
The invention provides a data processing template generation method, a data processing template generation device, electronic equipment and a storage medium, which realize the creation of a corresponding data processing template according to the selection of a user, further carry out batch processing on data by different templates and meet the processing requirements of the user on batch data of different scenes.
In a first aspect, the present invention provides a method for generating a data processing template, including:
determining at least one template to be applied, corresponding template attributes and at least one target data source, wherein the template attributes comprise an operation authority attribute, a system attribute, a template name attribute and a template number attribute;
extracting data field information from the target data source and determining at least one target field information from the data field information;
configuring a data import rule for the at least one target field information respectively;
and determining a target data processing template matched with the at least one target data source based on the template to be applied, the template attribute, the target field information and the data import rule, so as to complete data processing according to the target data processing template when receiving the data matched with the at least one target data source.
In a second aspect, an embodiment of the present invention further provides a data processing template generating apparatus, where the apparatus includes:
the system comprises a to-be-applied template determining module, a to-be-applied template determining module and at least one target data source, wherein the to-be-applied template determining module is used for determining at least one to-be-applied template, corresponding template attributes and at least one target data source, and the template attributes comprise an operation authority attribute, a system attribute, a template name attribute and a template number attribute;
a target field determination module for extracting data field information from the target data source and determining at least one target field information from the data field information;
the rule configuration module is used for configuring data import rules for the at least one target field information respectively;
and the template generating module is used for determining a target data processing template matched with the at least one target data source based on the template to be applied, the template attribute, the target field information and the data import rule.
In a third aspect, an embodiment of the present invention further provides an electronic device, where the device includes:
one or more processors;
storage means for storing one or more programs;
when executed by the one or more processors, the one or more programs cause the one or more processors to implement the method for generating a data processing template according to any one of the embodiments of the present invention.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data processing template generating method according to any one of the embodiments of the present invention.
According to the technical scheme, at least one template to be applied, corresponding template attributes and at least one target data source are determined, data field information is extracted from the target data source, at least one target field information is determined from the data field information, then data import rules can be configured for the at least one target field information respectively, and finally a target data processing template matched with the at least one target data source is determined based on the template to be applied, the template attributes, the target field information and the data import rules. Based on the technical scheme, the data are processed in batches through the data processing template, and the processing requirements of users on batch data of different scenes are met.
It should be understood that the statements in this section do not necessarily identify key or critical features of the embodiments of the present invention, nor do they necessarily limit the scope of the invention. Other features of the present invention will become apparent from the following description.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic flow chart of a data processing template generation method according to an embodiment of the present invention;
FIG. 2 is a flow chart of a method for generating a data processing template according to an embodiment of the present invention;
fig. 3 is a block diagram of a data processing template generating apparatus according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example one
Fig. 1 is a flowchart of a data processing template generation method according to an embodiment of the present invention, where this embodiment is applicable to a situation in which data in different data sources are batched by using a preset data template, and the method may be integrated in an electronic device, where the electronic device may be a PC end or a server end.
As shown in fig. 1, the method includes:
s110, determining at least one template to be applied, corresponding template attributes and at least one target data source.
The template attribute comprises an operation authority attribute, a system attribute, a template name attribute and a template number attribute. The template to be applied can be understood as a data processing template that needs to be configured. The template attribute may be attribute information corresponding to the template to be applied. The target data source can be understood as a database for storing data, and a user can store the data in different databases according to different types of the data when storing the data, for example, the databases of MySQL, oracle, sybase and the like. The operation authority attribute can be understood as the operation authority of the template on the data, for example, if the template needs to complete batch addition of data, the corresponding operation authority attribute should be set as batch addition, and correspondingly, if the template needs to complete batch modification of data, the corresponding operation authority attribute should be set as batch modification. The system attribute may be a system name to which the current template belongs, for example, if the current template is mainly responsible for batch addition of data of the system a, the system attribute of the template should be set as the system a. The template name attribute can be understood as a template name set by a user, and the user can customize the name of the template according to requirements. The template number attribute may be a number of the template, and the number information may be freely set by a user, or may be automatically generated according to a preset rule, for example, corresponding numbers are assigned according to a creation order of the template.
Specifically, the user may determine at least one template to be applied and corresponding template attributes according to requirements, and when selecting the corresponding template to be applied, the user may set the corresponding template attributes at the same time, or may automatically determine corresponding template attribute information based on the template to be applied selected by the user, and further, the user may select at least one target data source according to requirements. It should be noted that, a user may process data stored in different databases at the same time, so that the user may select at least one database as a target data source.
On the basis of the above technical solution, the determining at least one template to be applied, corresponding template attributes, and at least one target data source includes: when the trigger template selection control or the data source selection control is detected, displaying a corresponding template selection interface or data source selection interface for a target user, and determining the at least one template to be applied, the corresponding template attribute and the at least one target data source based on operation in the selection interface.
The template selection control can be a function control arranged on the interface, a user can determine at least one template to be applied by triggering the template selection control, and the corresponding data source selection control can be understood as a control for triggering the data source selection function. The template selection interface may be an interface for determining a template to be applied, and correspondingly, the data source selection interface may be a selection interface for determining a target data source. The target user may be understood as a user who needs to create a template.
Specifically, a user can send a template selection instruction by triggering a template selection control, and then pop up a corresponding template selection interface for the user based on the instruction, the user can determine at least one template to be applied from the template selection interface, after determining the template to be applied, the user can send a data source selection instruction by triggering a data source selection control, pop up a corresponding data source selection interface for the user according to the instruction, and determine at least one target data source according to the operation of the user on the selection interface. It should be noted that a plurality of data sources to be selected are displayed for a user in the data source display interface, and the user can select one or more data sources from the displayed data sources to be selected as target data sources according to requirements.
S120, extracting data field information from the target data source, and determining at least one target field information from the data field information.
Wherein the data field information may be an identifier describing a characteristic of a certain data item. The target field information may be user-determined field information.
Specifically, the field information of the data is extracted from the target data source, and the user can select the required field information from the field information as the target field information according to the requirement, for example, the user can select the field to be processed as the target field information, and further, only the information of the target field selected by the user is processed during data processing.
On the basis of the above technical solution, the extracting data field information from the target data source includes: matching in the at least one target data source based on a search term to determine a data form matching the search term; and/or when a trigger data form selection control is detected, displaying a data form selection interface for a target user, and determining the data form based on trigger operation in the data form selection interface; and extracting the data field information from the data form.
The search words are search words input by the target user. A data form may be understood as a data table stored in a data source. The dataform selection control can be a control for triggering a dataform selection function, and a user can issue corresponding instruction information by triggering the control. The data form selection interface may be a selection interface displayed to the user based on a user's triggering operation of the data form selection control, on which the user may determine the data form.
Specifically, a user can directly input a corresponding search word, and then match in a target data source based on the search word, obtain a corresponding data form according to a matching result, or pop up a corresponding data form selection interface for the user according to a triggering operation of the data form selection control by the user, and the user can select a required data form from the data form selection interface, and then select and provide data field information from the data form. It should be noted that when a user searches by using a search word, a plurality of search results matching the search word may appear, and therefore when a plurality of search results appear, a corresponding data form selection interface may be displayed for the user in a general manner, so that the user may select from the data form selection interface.
On the basis of the above technical solution, determining at least one target field information from the data field information includes: and determining field information corresponding to the trigger operation according to the trigger operation of the target user, and taking the field information as the target field information.
The trigger operation may be a click operation of the target user on any data field information.
Specifically, after the data field information is extracted from the data form, all the data field information can be displayed for the user on the interface, and the user can trigger any data field information, so that the corresponding target field information is determined based on the triggering operation of the user. Further, the user may select a plurality of pieces of data field information as the target field information, for example, all the extracted pieces of field information are displayed on the left side of the interface, when the user triggers any piece of data field information, the piece of field information corresponding to the trigger operation is displayed on the right side of the page, and then after the user finishes the selection, the piece of field information on the right side of the interface is used as the target field information.
On the basis of the above technical solution, after determining at least one target field information from the data field information, the method further includes: determining annotation information associated with the target field information to annotate the target field information based on the annotation information, wherein the annotation information comprises name information, remark information, and filling state information.
Wherein the annotation information may be an explanation and description of the field function. The name information may be understood as name information corresponding to the target field, and it should be noted that the field information is a field identifier for describing features of the data, and the name information may be set as information that is easy for a user to understand, for example, the name information of the name field is set as "name" for the user to understand. The remark information may be prompt information corresponding to the target field, and may be a filling rule prompting the user to fill data, such as a length threshold of the filling data. The filling state information may be understood as a filling state of data corresponding to the target field information, and is used to indicate whether the data is mandatory information.
Specifically, after the target field information is determined, in order to facilitate data import and data processing, a user may set corresponding comment information for the target field information, and may further prompt the user when processing the data according to the comment information.
S130, configuring a data import rule for the at least one target field information respectively.
The data import rule may be rule information for specifying a data import method, and for example, the data import rule includes: format rules, such as requiring that the field content needs to satisfy the IPV4 format; date rules, requiring that the field must satisfy certain date format rules; a regular expression, requiring that the field must satisfy a certain regular expression; a fixed default value, which is filled in by the field; conditional defaults, which are filled into the field after certain conditions are met. Fixed structured query language, dynamic structured query language, field association restrictions, and the like.
Specifically, the user may configure a corresponding data import rule for at least one target field information according to a requirement, and then process the data based on the set data import rule when processing the data based on the template.
On the basis of the above technical solution, the configuring a data import rule for the at least one piece of target field information respectively includes: and when the trigger data import rule setting control is detected, displaying a data import rule setting interface corresponding to the at least one piece of target field information for the target user, and configuring data import rules for the at least one piece of target field information respectively based on the data import rules selected by the target user in the data import rule setting interface.
The import rule setting control can be a control for triggering an import data rule configuration function by a user. Correspondingly, the data import rule setting interface may be an interface for configuring the data import rule, which is displayed for the user after the user triggers the data import rule setting control.
Specifically, a corresponding data import rule setting interface may be displayed for the user according to a triggering operation of the data import rule setting control by the user, and the user may select a required data import rule on the data import rule setting interface and set the required data import rule as the data import rule of the target field. It should be noted that, a user may configure a plurality of data import rules for one target field, and for a target field configured with a plurality of data import rules, all data import rules need to be satisfied simultaneously when performing data processing. Correspondingly, the user can configure corresponding data import rules for a plurality of target fields at the same time.
On the basis of the above technical solution, after configuring the data import rule for the at least one piece of target field information, the method further includes: and determining display rule information corresponding to the at least one target field information, so as to display data corresponding to the at least one target field information according to the display rule information.
Wherein the display rule information includes at least one of display status information and search status information. The display rule information may be rule information indicating a display manner of data corresponding to the target field. The display state information may be understood as information whether data corresponding to the target field is displayed. The search status information may be information indicating whether the data information corresponding to the target field is searchable.
Specifically, after configuring the import rule, the user may configure the display rule information corresponding to the target field according to the requirement, and then may control the display mode of the data corresponding to the target field based on the display rule information. For example, if the data corresponding to the a field is encrypted and not displayed and searching is not possible, the search status information corresponding to the a field may be adjusted to be not searchable by adjusting the display status information corresponding to the a field to be hidden.
S140, determining a target data processing template matched with the at least one target data source based on the template to be applied, the template attribute, the target field information and the data import rule.
Wherein the target data handling template may be a data handling template created based on information selected by a user.
Specifically, according to a template to be applied selected by a user, a corresponding template attribute, and a data import rule set by the user for target field information, a target data processing template matched with at least one target data source may be determined, and based on the target data processing template, when data corresponding to the target data source is received, the target data processing template may be called to perform batch processing on the data.
According to the technical scheme of the embodiment of the invention, at least one template to be applied, corresponding template attributes and at least one target data source are determined, data field information is extracted from the target data source, at least one target field information is determined from the data field information, data import rules can be configured for the at least one target field information respectively, and finally a target data processing template matched with the at least one target data source is determined based on the template to be applied, the template attributes, the target field information and the data import rules. Based on the technical scheme, the corresponding data processing template can be created based on the selection of the user, and then the data can be processed in batches by calling the data processing template, so that the processing requirements of the user on batch data of different scenes are met.
Example two
Fig. 2 is a flowchart of a data processing template generation method according to an embodiment of the present invention, and the embodiment further details an implementation flow of the data processing template generation method based on the above example, and a specific implementation manner of the embodiment may refer to the technical solution of the embodiment. The technical terms that are the same as or corresponding to the above embodiments are not repeated herein.
As shown in fig. 2, the method includes:
defining a batch data processing template: define template name, system to which the template belongs (optional), template type, template number (which may be automatically generated based on rules), etc.
Specifically, the template type may be a data processing type, such as batch addition, batch modification, or batch deletion of data, and it should be noted that, since deletion of data is usually an irreversible operation, deletion of data is usually performed through the state bit logic of batch modification data, that is, deletion at a non-physical level. And, the template number may be generated according to a preset method.
Specifying a data source: specifically, the data source can be selected from a list of previously configured data sources.
Specifying data forms or views: specifically, the user may select from the data source, or search according to a search term input by the user and then obtain a corresponding data form or view.
Selecting required fields and indicating a main key: specifically, after extracting corresponding field information from the data form, and indicating a corresponding primary key, it may be understood that the primary key may be understood as judgment condition information when performing data processing, for example, whether data meets an import condition may be judged according to a format or size of data corresponding to a field of the primary key, and data is imported after the import condition is met.
Filling and configuring fields in the template to display related information: specifically, the related information may be remark information set by the user, such as: the field alias can be used as a column name in an Excel template provided for the user, so that the user can understand the field alias conveniently, and the field remark can be used as an annotation in the Excel template provided for the user, so as to prompt the user about the requirements of field content filled by the user, whether the field is required to be filled, and the like.
Configuring a data import rule: specifically, based on the selected field, the data import rule of the field is selected and configured, it should be noted that, for the same field information, it may be supported to configure multiple rules based on the field, for example, the rules that may be related to the name field include: regular expressions, restrictions on fields, types of variables, etc. It is to be understood that the data import rules may include, but are not limited to: format rule, date rule: this field is required to satisfy a certain date format rule, a regular expression, of the declaration: this field is required to satisfy some regular expression rule, a fixed default value, of the declaration: the field may be filled by default with a fixed default value, or may be filled with a specified key, such as: [ USERID ], [ USERNAME ], [ USERONG ], etc., conditional default values: when a condition is satisfied (e.g., column data in the row equals 0), the field is filled by default with a value, the array: requiring that this field must satisfy a declared array-wide value, fixed SQL (structured query language): the SQL query result needs to be a list of values. This field is required to satisfy values within the range of SQL query results, and the SQL query conditions may refer to system-specific keywords such as: [ USERID ], [ USERNAME ], [ USERORG ], etc., dynamic SQL: the SQL query result needs to be a list of values. Requiring that the field must satisfy a value within the SQL query result range, the SQL query condition may refer to a certain column of data in the template, dynamically controlling the entry of data, field association restrictions: this field can only be filled with certain values when certain conditions are met. It should be noted that the user may also set other data import rules according to the requirement.
Configuring template import display rules; specifically, based on the selected field, configure: whether the A field is displayed in the Excel template or not can be adjusted by adjusting a state bit for the A field, the field controlled by a fixed or conditional default value does not need to be displayed, whether the A field can be searched in an import interface or not is configured, and the like.
Calling a template: specifically, after the template configuration is completed, in each system application, the service can be introduced and called by configuring the template number according to the actual scene.
According to the technical scheme of the embodiment of the invention, at least one template to be applied, corresponding template attributes and at least one target data source are determined, data field information is extracted from the target data source, at least one target field information is determined from the data field information, data import rules can be configured for the at least one target field information respectively, and finally a target data processing template matched with the at least one target data source is determined based on the template to be applied, the template attributes, the target field information and the data import rules. Based on the technical scheme, the corresponding data processing template can be created based on the selection of the user, and then the data can be processed in batches by calling the data processing template, so that the processing requirements of the user on batch data of different scenes are met.
EXAMPLE III
Fig. 3 is a data processing template generating apparatus according to an embodiment of the present invention. The device includes: a template to be applied determination module 310, a target field determination module 320, a rule configuration module 330, and a template generation module 340.
A template to be applied determining module 310, configured to determine at least one template to be applied, corresponding template attributes, and at least one target data source, where the template attributes include an operation authority attribute, a system attribute, a template name attribute, and a template number attribute;
a target field determination module 320 for extracting data field information from the target data source and determining at least one target field information from the data field information;
a rule configuration module 330, configured to configure a data import rule for the at least one target field information;
a template generating module 340, configured to determine, based on the template to be applied, the template attribute, the target field information, and the data import rule, a target data processing template that is matched with the at least one target data source.
On the basis of the above technical solution, the to-be-applied template determining module is specifically configured to: when the trigger template selection control or the data source selection control is detected, displaying a corresponding template selection interface or data source selection interface for a target user, and determining the at least one template to be applied, the corresponding template attribute and the at least one target data source based on operation in the selection interface.
On the basis of the above technical solution, the target field determining module further includes:
the matching unit is used for matching in the at least one target data source based on the search word so as to determine a data form matched with the search word; and/or when a trigger data form selection control is detected, displaying a data form selection interface for a target user, and determining the data form based on trigger operation in the data form selection interface;
and the field information extraction unit is used for extracting the data field information from the data form, wherein the search word is a search word input by a target user.
On the basis of the above technical solution, the target field determining module further includes:
and the target field information determining unit is used for determining field information corresponding to the trigger operation according to the trigger operation of the target user and taking the field information as the target field information.
On the basis of the above technical solution, the apparatus further includes:
and the comment information configuration module is used for determining at least one piece of target field information from the data field information, and then determining comment information related to the target field information so as to comment on the target field information based on the display related information, wherein the comment information comprises name information, remark information and filling state information.
On the basis of the above technical solution, the rule configuration module is specifically configured to: and when the trigger data import rule setting control is detected, displaying a data import rule setting interface corresponding to the at least one piece of target field information for the target user, and configuring data import rules for the at least one piece of target field information respectively based on the data import rules selected by the target user in the data import rule setting interface.
On the basis of the above technical solution, the rule configuration module further includes:
and the display rule configuration unit is used for determining display rule information corresponding to the at least one target field information after configuring data import rules for the at least one target field information respectively so as to display data corresponding to the at least one target field information according to the display rule information, wherein the display rule information comprises at least one of display state information and search state information.
According to the technical scheme of the embodiment of the invention, at least one template to be applied, corresponding template attributes and at least one target data source are determined, data field information is extracted from the target data source, at least one target field information is determined from the data field information, data import rules can be configured for the at least one target field information respectively, and finally a target data processing template matched with the at least one target data source is determined based on the template to be applied, the template attributes, the target field information and the data import rules. Based on the technical scheme, the corresponding data processing template can be created based on the selection of the user, and then the data can be processed in batches by calling the data processing template, so that the processing requirements of the user on batch data of different scenes are met.
The data processing template generation device provided by the embodiment of the invention can execute the data processing template generation method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
It should be noted that, the units and modules included in the apparatus are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the embodiment of the present invention.
Example four
FIG. 4 shows a schematic block diagram of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to the bus 14.
A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, or the like. The processor 11 performs the various methods and processes described above, such as the data processing template generation method.
In some embodiments, the data processing template generation method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the data processing template generation method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the data processing template generation method by any other suitable means (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
Computer programs for implementing the methods of the present invention can be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on a machine, as a stand-alone software package partly on a machine and partly on a remote machine or entirely on a remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired results of the technical solution of the present invention can be achieved.
The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (10)

1. A data processing template generation method is characterized by comprising the following steps:
determining at least one template to be applied, corresponding template attributes and at least one target data source, wherein the template attributes comprise an operation authority attribute, a system attribute, a template name attribute and a template number attribute;
extracting data field information from the target data source and determining at least one target field information from the data field information;
configuring a data import rule for the at least one target field information respectively;
and determining a target data processing template matched with the at least one target data source based on the template to be applied, the template attribute, the target field information and the data import rule.
2. The method of claim 1, wherein determining at least one template to be applied and corresponding template attributes, and at least one target data source comprises:
when the trigger template selection control or the data source selection control is detected, displaying a corresponding template selection interface or data source selection interface for a target user, and determining the at least one template to be applied, the corresponding template attribute and the at least one target data source based on operation in the selection interface.
3. The method of claim 1, wherein the extracting data field information from the target data source comprises:
matching in the at least one target data source based on a search term to determine a data form matching the search term; and/or the presence of a gas in the gas,
when the trigger data form selection control is detected, displaying a data form selection interface for a target user, and determining the data form based on trigger operation in the data form selection interface;
and extracting the data field information from the data form, wherein the search word is a search word input by a target user.
4. The method of claim 3, wherein determining at least one target field information from the data field information comprises:
and determining field information corresponding to the trigger operation according to the trigger operation of the target user, and taking the field information as the target field information.
5. The method of claim 1, wherein after determining at least one target field information from the data field information, further comprising:
determining annotation information associated with the target field information to annotate the target field information based on the presentation-related information, wherein the annotation information comprises name information, remark information, and filling state information.
6. The method according to claim 1, wherein the configuring the data import rule for the at least one target field information respectively comprises:
and when the trigger data import rule setting control is detected, displaying a data import rule setting interface corresponding to the at least one piece of target field information for the target user, and configuring data import rules for the at least one piece of target field information respectively based on the data import rules selected by the target user in the data import rule setting interface.
7. The method of claim 1, further comprising, after configuring the data import rules for the at least one target field information, respectively:
and determining display rule information corresponding to the at least one target field information to display data corresponding to the at least one target field information according to the display rule information, wherein the display rule information comprises at least one of display state information and search state information.
8. A data processing apparatus, comprising:
the system comprises a to-be-applied template determining module, a to-be-applied template determining module and at least one target data source, wherein the to-be-applied template determining module is used for determining at least one to-be-applied template, corresponding template attributes and at least one target data source, and the template attributes comprise an operation authority attribute, a system attribute, a template name attribute and a template number attribute;
a target field determination module for extracting data field information from the target data source and determining at least one target field information from the data field information;
the rule configuration module is used for configuring data import rules for the at least one target field information respectively;
and the template generating module is used for determining a target data processing template matched with the at least one target data source based on the template to be applied, the template attribute, the target field information and the data import rule.
9. An electronic device, characterized in that the electronic device comprises:
one or more processors; and
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 to enable the at least one processor to perform the data processing template generation method of any one of claims 1-7.
10. A computer-readable storage medium storing computer instructions for causing a processor to perform the data processing template generation method of any one of claims 1 to 7 when executed.
CN202210889340.9A 2022-07-27 2022-07-27 Data processing template generation method and device, electronic equipment and storage medium Pending CN115169316A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210889340.9A CN115169316A (en) 2022-07-27 2022-07-27 Data processing template generation method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210889340.9A CN115169316A (en) 2022-07-27 2022-07-27 Data processing template generation method and device, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN115169316A true CN115169316A (en) 2022-10-11

Family

ID=83496602

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210889340.9A Pending CN115169316A (en) 2022-07-27 2022-07-27 Data processing template generation method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN115169316A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117076542A (en) * 2023-08-29 2023-11-17 中国中金财富证券有限公司 Data processing method and related device

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117076542A (en) * 2023-08-29 2023-11-17 中国中金财富证券有限公司 Data processing method and related device

Similar Documents

Publication Publication Date Title
CN115169316A (en) Data processing template generation method and device, electronic equipment and storage medium
CN114428674A (en) Task scheduling method, device, equipment and storage medium
CN114880498B (en) Event information display method and device, equipment and medium
CN116185389A (en) Code generation method and device, electronic equipment and medium
CN115510247A (en) Method, device, equipment and storage medium for constructing electric carbon policy knowledge graph
CN115329150A (en) Method and device for generating search condition tree, electronic equipment and storage medium
CN115328917A (en) Query method, device, equipment and storage medium
CN114816578A (en) Method, device and equipment for generating program configuration file based on configuration table
CN115544010A (en) Mapping relation determining method and device, electronic equipment and storage medium
CN115080607A (en) Method, device, equipment and storage medium for optimizing structured query statement
CN114995875A (en) Page component configuration method and device, electronic equipment and storage medium
CN114756468A (en) Test data creating method, device, equipment and storage medium
CN114416772A (en) Data query method and device, electronic equipment and storage medium
CN114860753A (en) SQL statement generation method, device, equipment, medium and product
CN112527126B (en) Information acquisition method and device and electronic equipment
CN115981657A (en) Code generation method and device, electronic equipment and readable medium
CN117668908A (en) Data desensitizing method, device, electronic equipment and storage medium
CN115408395A (en) Data processing method and device, electronic equipment and storage medium
CN117743374A (en) Database text query method, device and equipment based on data examples
CN117494216A (en) Configuration method, device, equipment and medium of sensitive information
CN115292179A (en) Test data generation method and device, electronic equipment and storage medium
CN117520368A (en) Query statement determination method, device, equipment, medium and product
CN115202538A (en) Menu configuration method and device, electronic equipment and storage medium
CN115495528A (en) Distributed database statement execution method, device, equipment and storage medium
CN114780580A (en) SQL statement generation method, device, equipment, storage medium and product

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