CN116775955A - Data tag solidifying method, device, computer equipment and storage medium - Google Patents

Data tag solidifying method, device, computer equipment and storage medium Download PDF

Info

Publication number
CN116775955A
CN116775955A CN202310623161.5A CN202310623161A CN116775955A CN 116775955 A CN116775955 A CN 116775955A CN 202310623161 A CN202310623161 A CN 202310623161A CN 116775955 A CN116775955 A CN 116775955A
Authority
CN
China
Prior art keywords
data
tag
curing
label
target
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
CN202310623161.5A
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.)
Industrial and Commercial Bank of China Ltd ICBC
ICBC Technology Co Ltd
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
ICBC Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Industrial and Commercial Bank of China Ltd ICBC, ICBC Technology Co Ltd filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CN202310623161.5A priority Critical patent/CN116775955A/en
Publication of CN116775955A publication Critical patent/CN116775955A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to a data tag solidifying method, a device, computer equipment and a storage medium, which are applied to the field of big data, wherein the method comprises the following steps: receiving a data query instruction; the data query instruction carries a query condition; responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified; creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured; and responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information. The method can improve the curing efficiency of the data tag.

Description

Data tag solidifying method, device, computer equipment and storage medium
Technical Field
The present application relates to the field of big data technology, and in particular, to a data tag curing method, apparatus, computer device, storage medium, and computer program product.
Background
The data tag management comprises the steps of realizing the development of the data tag, managing tag grouping and realizing the capability of gradually decomposing a technical capability-driven business scene into business tags and atomic indexes.
The existing calculation and solidification of the data label at present is to classify the application information according to the user when submitting the application information, determine the data type indicated by the preset solidification content of each preset solidification link, solidify the sub-data with the same determined data type in the preset solidification links of the preset product, and classify and solidify at the application stage. When the method is used for curing operation, the fields which are required to be input by a user are too many and complicated, and the efficiency is low.
Disclosure of Invention
Based on this, it is necessary to provide a data tag curing method, apparatus, computer device, computer readable storage medium and computer program product for solving the technical problem of low efficiency of the above curing method.
In a first aspect, the present application provides a method of curing a data tag. The method comprises the following steps:
receiving a data query instruction; the data query instruction carries a query condition;
responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
And responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
In one embodiment, the creating a data tag for the data to be cured includes:
responding to a data tag creation instruction, and displaying a data tag page; the data tag page comprises a tag information input entry;
and receiving the tag information input by the tag information input inlet to obtain the data tag.
In one embodiment, the tag curing configuration information includes curing table information;
the response to the curing confirmation instruction cures the data to be cured under the created data label according to the label curing configuration information, and the response to the curing confirmation instruction comprises the following steps:
responding to the curing confirmation instruction, and creating a curing table corresponding to the curing table information;
storing the data to be solidified into the solidification table;
and solidifying the solidifying table storing the data to be solidified to the created data label.
In one embodiment, the curing table storing the data to be cured under the created data label includes:
Generating a label solidification task;
and responding to an execution instruction for the label curing task, and curing the curing table stored with the data to be cured under the created data label.
In one embodiment, the method further comprises:
generating a scheduling task corresponding to the label curing task in a task scheduling platform;
executing the tag solidification task when an execution instruction aiming at the scheduling task is received;
the task scheduling platform comprises scheduling tasks corresponding to a plurality of tag solidification tasks, and the scheduling tasks are executed asynchronously.
In one embodiment, the method further comprises:
displaying a tag screening page; the label screening page comprises a plurality of candidate labels and a plurality of candidate operators, wherein the candidate labels are data labels obtained by historical solidification;
obtaining a combined label based on the combined operation aiming at the target label in the plurality of candidate labels and aiming at the target operator in the plurality of candidate operators;
and carrying out logic operation on the target label in the combined label according to the target operator to obtain the solidification data corresponding to the combined label.
In one embodiment, the target tag includes at least two candidate tags, and the selecting process of the target tag includes:
responding to a selection operation for a first target tag in the plurality of candidate tags, and acquiring a first query field corresponding to the first target tag; the first query field is an optional field of the solidification data corresponding to the first target label;
when receiving a selection operation for a second target tag in the plurality of candidate tags, acquiring a second query field corresponding to the second target tag; the second query field is an optional field of the solidification data corresponding to the second target label;
and determining the first target label and the second target label as combinable target labels under the condition that the first query field is completely matched with the second query field.
In one embodiment, after the curing the data to be cured under the created data tag based on the tag curing configuration information in response to a curing confirmation instruction, the method further includes:
updating a pre-constructed data tag information table according to the solidified data tag and corresponding solidified data; the data label information table stores data labels created in the past and corresponding solidification data;
And performing logic operation on the target label in the combined label according to the target operator to obtain the solidification data corresponding to the combined label, and further comprising:
and updating the data tag information table according to the combination tag and the solidification data corresponding to the combination tag.
In a second aspect, the application further provides a data tag curing device. The device comprises:
the receiving module is used for receiving the data query instruction; the data query instruction carries a query condition;
the query module is used for responding to the data query instruction, determining associated data corresponding to the query condition from at least one financial database and taking the associated data as data to be solidified;
the creation module is used for creating a data tag aiming at the data to be solidified and receiving tag solidification configuration information input aiming at the data to be solidified;
and the curing module is used for responding to the curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
In one embodiment, the creating module is further configured to respond to a data tag creating instruction, and display a data tag page; the data tag page comprises a tag information input entry; and receiving the tag information input by the tag information input inlet to obtain the data tag.
In one embodiment, the tag curing configuration information includes curing table information; the curing module is also used for responding to the curing confirmation instruction and creating a curing table corresponding to the curing table information; storing the data to be solidified into a solidification table; curing the curing table storing the data to be cured under the created data label.
In one embodiment, the curing module is further configured to generate a label curing task; and in response to an execution instruction for the tag curing task, curing the curing table storing the data to be cured under the created data tag.
In one embodiment, the solidification module is further configured to generate a scheduling task corresponding to the tag solidification task in the task scheduling platform; executing a tag solidification task when an execution instruction for a scheduling task is received; the task scheduling platform comprises scheduling tasks corresponding to a plurality of tag solidification tasks, and each scheduling task is executed asynchronously.
In one embodiment, the device further comprises a label combination module, which is used for displaying a label screening page; the label screening page comprises a plurality of candidate labels and a plurality of candidate operators, wherein the candidate labels are data labels obtained by history solidification; obtaining a combined label based on the combined operation aiming at the target label in the plurality of candidate labels and aiming at the target operator in the plurality of candidate operators; and carrying out logic operation on the target label in the combined label according to the target operator to obtain the solidification data corresponding to the combined label.
In one embodiment, the target tag includes at least two candidate tags, and the tag combination module is further configured to obtain a first query field corresponding to a first target tag in the plurality of candidate tags in response to a selection operation for the first target tag; the first query field is an optional field of the solidification data corresponding to the first target label; when receiving a selection operation for a second target tag in the plurality of candidate tags, acquiring a second query field corresponding to the second target tag; the second query field is an optional field of the solidification data corresponding to the second target label; in the case that the first query field and the second query field are perfectly matched, the first target tag and the second target tag are determined to be combinable target tags.
In one embodiment, the device further comprises an updating module, configured to update a pre-constructed data tag information table according to the cured data tag and the corresponding cured data; the data label information table stores data labels created in the past and corresponding solidification data;
and the updating module is also used for updating the data tag information table according to the combined tag and the solidification data corresponding to the combined tag.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor which when executing the computer program performs the steps of:
receiving a data query instruction; the data query instruction carries a query condition;
responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
and responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
receiving a data query instruction; the data query instruction carries a query condition;
responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
Creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
and responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of:
receiving a data query instruction; the data query instruction carries a query condition;
responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
and responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
The data tag solidifying method, the device, the computer equipment, the storage medium and the computer program product, after receiving the data query instruction, determine the associated data corresponding to the query condition from at least one financial database based on the query condition carried by the data query instruction, and serve as the data to be solidified; further creating a data tag for the data to be cured, receiving tag curing configuration information input for the data to be cured, and finally curing the data to be cured under the created data tag based on the tag curing configuration information in response to the curing confirmation instruction. According to the method, the user can quickly obtain the data to be solidified through the data query instruction by using the graphical interface, the creation of the data tag and the execution of solidification can be conveniently carried out, and the solidification efficiency can be improved.
Drawings
FIG. 1 is a flow chart of a method of curing a data tag in one embodiment;
FIG. 2 is a schematic diagram of a data query page in one embodiment;
FIG. 3 is a schematic diagram of a data tag page in one embodiment;
FIG. 4 is a flow chart of a data tag assembly step in one embodiment;
FIG. 5 is a schematic diagram of a tag screening page in one embodiment;
FIG. 6 is a flow chart of a method of curing a data tag in another embodiment;
FIG. 7 is a schematic diagram of a data tag screening process in another embodiment;
FIG. 8 is a block diagram of a data tag curing apparatus in one embodiment;
fig. 9 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the application described herein may be implemented in sequences other than those illustrated or otherwise described herein. It should be further noted that, the user information (including but not limited to user equipment information, user personal information, etc.) and the data (including but not limited to data for analysis, stored data, presented data, etc.) related to the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data need to comply with the related laws and regulations and standards of the related country and region.
In one embodiment, as shown in fig. 1, a data tag curing method is provided, where the method is applied to a terminal to illustrate the method, it is understood that the method may also be applied to a server, and may also be applied to a system including the terminal and the server, and implemented through interaction between the terminal and the server. The terminal can be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things equipment and portable wearable equipment, and the internet of things equipment can be smart speakers, smart televisions, smart air conditioners, smart vehicle-mounted equipment and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server may be implemented as a stand-alone server or as a server cluster composed of a plurality of servers. In this embodiment, the method includes the steps of:
step S110, receiving a data query instruction; the data query instruction carries a query condition.
The data query instruction may be an SQL instruction (Structured Query Language ), among others.
The query condition may carry at least one of the identifier of the database table to be queried and the identifier of any field in the database table to be queried, that is, the data obtained based on the query condition may be the data in a complete database table or the data of some fields in a database table.
In a specific implementation, referring to fig. 2, which is a schematic diagram of a data query page in a tag development process shown in an embodiment, as shown in fig. 2, a user may input a data query statement "SELECT FROM user_info" in an area 201 shown in fig. 2, and generate a data query instruction by performing an operation on the data query statement, so that a terminal queries corresponding data based on the data query instruction.
Step S120, responding to the data query instruction, and determining the associated data corresponding to the query condition from at least one financial database as the data to be solidified.
In a specific implementation, there may be multiple databases related to the query condition carried by the data query instruction, so the terminal may determine, based on the data query instruction, association data corresponding to the query condition from at least one financial database, and use all the queried association data as the data to be solidified. Referring to area 202 in fig. 2, an example of queried data to be cured.
Step S130, creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured.
The tag curing configuration information indicates configuration information when curing the data to be cured, for example, referring to a data tag page shown in fig. 3, the tag curing configuration information may include whether curing is enabled, a table name of tag curing, whether full data curing is performed, and the like.
In the specific implementation, when creating a data tag for data to be solidified, a user can firstly display a data tag page through a trigger terminal, and then input attribute information of the data tag in the data tag page, so that the terminal can create a corresponding data tag based on tag attribute information input by the user; after creating the data tag, the user may further input the tag curing table name and the tag curing table name, whether to perform the tag curing configuration information such as full data curing, and save these operations, so that the terminal stores the created data tag and tag curing configuration information.
In step S140, in response to the curing confirmation instruction, the data to be cured is cured under the created data tag based on the tag curing configuration information.
In the specific implementation, after the creation of the data tag, the inquiry of the data to be cured and the determination of the tag curing configuration information are completed, if the terminal receives the curing confirmation instruction for the data to be cured, the data to be cured can be cured under the created data tag based on the tag curing configuration information, so that the data to be cured can be correspondingly adjusted and taken out when the data tag is subsequently called, and the curing binding between the data to be cured and the data tag is realized.
According to the method, the data to be solidified is solidified from the data source under the corresponding data label according to the set label solidification configuration information, so that the data in different financial databases can be integrated under the same data label, and subsequent data analysis is facilitated.
In the data tag curing method, after a data query instruction is received, based on query conditions carried by the data query instruction, associated data corresponding to the query conditions are determined from at least one financial database and used as data to be cured; further creating a data tag for the data to be cured, receiving tag curing configuration information input for the data to be cured, and finally curing the data to be cured under the created data tag based on the tag curing configuration information in response to the curing confirmation instruction. According to the method, the user can quickly obtain the data to be solidified through the data query instruction by using the graphical interface, the creation of the data tag and the execution of solidification can be conveniently carried out, and the solidification efficiency can be improved.
In an exemplary embodiment, in the step S230, creating a data tag for the data to be cured includes:
step S231, responding to a data tag creation instruction, and displaying a data tag page; the data tag page comprises a tag information input entry;
Step S232, receiving the label information input by the label information input entrance to obtain the data label.
In a specific implementation, after the data query page shown in fig. 2 completes data query, a user may click a "next" button to generate a data tag creation instruction, the terminal responds to the data tag creation instruction to display the data tag page shown in fig. 3, and as shown in fig. 3, a tag basic information area in the data tag page includes tag information input entries corresponding to a plurality of tag attributes such as a tag name, a resource directory to which the tag belongs, a tag description, and the like, and the user may input corresponding tag information for each tag information input entry, and the terminal obtains a data tag based on the tag information input for each tag information input entry.
Further, in an embodiment, different tag information input entries may correspond to different information conditions, for example, for a tag name input entry, information conditions such as that a tag name does not exceed 5 words and cannot be composed of pure characters may be set, after receiving tag information input for the tag information input entry, the terminal may further detect whether the input tag information matches with the information condition corresponding to the tag information input entry, and when the input tag information does not match, display input error prompt information to prompt a user to modify.
In this embodiment, the user creates the data tag based on the imaging interface, so that the operation is convenient, and the curing efficiency of the data tag can be improved.
In an exemplary embodiment, the tag curing configuration information includes curing table information; in response to the curing confirmation instruction in step S240, the curing of the data to be cured under the created data label according to the label curing configuration information specifically includes:
step S241, a curing table corresponding to the curing table information is created in response to the curing confirmation instruction;
step S242, storing the data to be cured into a curing table;
step S243, curing the curing table storing the data to be cured under the created data label.
The curing table information may include a table name of the label curing, a table chinese name of the label curing, and the like.
In a specific implementation, because the data to be cured obtained by inquiry may come from a plurality of database tables, when the terminal receives the curing confirmation instruction, a corresponding curing table is created according to the curing table information in the tag curing configuration information, the data to be cured is further transferred to the curing table, and when curing is performed, the curing table storing the data to be cured is cured under the created data tag.
In this embodiment, by creating a curing table, storing the data to be cured in the curing table, and then curing the curing table after storing the data, when the curing data corresponding to the data tag is subsequently called, all the curing data can be quickly called, so that the problem that the data calling efficiency is low due to too dispersed different curing data is avoided.
In an exemplary embodiment, in the step S243, the curing table is cured under the created data label, which specifically includes: generating a label solidification task; and in response to an execution instruction for the tag curing task, curing the curing table storing the data to be cured under the created data tag.
In a specific implementation, when data solidification is performed, a label solidification task can be generated, and when an execution instruction for the label solidification task is received, solidification is performed in response to the execution instruction, namely, a solidification table storing data to be solidified is solidified under the created data label.
Further, in an exemplary embodiment, the method further comprises: generating a scheduling task corresponding to the label curing task in a task scheduling platform; and executing the tag solidification task when receiving an execution instruction for the scheduling task.
The task scheduling platform comprises scheduling tasks corresponding to a plurality of tag solidification tasks, and each scheduling task is executed asynchronously.
In the specific implementation, after the label solidification task is generated, a scheduling task corresponding to the label solidification task can be generated in the task scheduling platform, and the label solidification task is executed when an execution instruction aiming at the scheduling task is received. In addition, the task scheduling platform can comprise scheduling tasks corresponding to a plurality of tag curing tasks, and each scheduling task is executed asynchronously, that is, a plurality of tag curing tasks can be executed simultaneously, and the next tag curing task is executed after the execution of one tag curing task is completed.
According to the embodiment, when data solidification is carried out, the label solidification task and the corresponding scheduling task are generated, and each scheduling task is executed asynchronously, so that each label solidification task is not interfered with each other, and the label solidification efficiency and concurrency capacity can be improved.
In an exemplary embodiment, as shown in fig. 4, the method further includes:
step S410, a label screening page is displayed; the tag screening page comprises a plurality of candidate tags and a plurality of candidate operators; the candidate labels are data labels obtained by historical solidification;
Step S420, based on the combination operation of target labels in the plurality of candidate labels and target operators in the plurality of candidate operators, a combined label is obtained;
step S430, performing logic operation on the target label in the combined label according to the target operator to obtain the solidification data corresponding to the combined label.
The candidate label is a data label obtained based on the curing method provided by the embodiment.
Referring to fig. 5, a schematic diagram of a tag filtering page in an embodiment is shown in fig. 5, a data tag library area in the tag filtering page includes a plurality of candidate tags, an operator area includes a plurality of candidate operators, a user may select at least two target tags to be combined from the candidate tags by dragging or double clicking, and the like, and select a target operator for combining the at least two target tags from the candidate operators, and obtain a combined tag by the selected target operator and the selected target tag. Because the selected target label is the data label obtained after curing is completed, the target label in the combined label is subjected to logic operation according to the target operator, and the logic operation is actually performed on the curing data corresponding to the target label in the combined label. For example, the "&.
In this embodiment, by using the tag combination method provided by the tag screening page, the data tags that have been cured can be combined, so that data meeting a plurality of conditions can be screened out, and the efficiency of data screening is improved.
In an exemplary embodiment, the target tag includes at least two candidate tags, and the selecting process of the target tag includes: responding to the selected operation of a first target label in a plurality of candidate labels, and acquiring a first query field corresponding to the first target label; the query field is an optional field of the solidification data corresponding to the first target label; when receiving a selection operation for a second target tag in the plurality of candidate tags, acquiring a second query field corresponding to the second target tag; the second query field is an optional field of the solidification data corresponding to the second target label; in the case that the first query field and the second query field are perfectly matched, the first target tag and the second target tag are determined to be combinable target tags.
The query field indicates a field of the solidified data corresponding to the candidate tag, that is, a SELECT field.
In a specific implementation, fields of the cured data corresponding to the data tags obtained by curing may not be the same, and if two different data tags are combined, the fields of the cured data corresponding to the two data tags need to be the same, so after the first target tag and the second target tag are selected from the plurality of candidate tags, whether query fields corresponding to the two target tags are matched needs to be compared, and if the two target tags are matched, the first target tag and the second target tag can be determined to be combined. Otherwise, if the query fields corresponding to the two fields are not completely matched, that is, if any one of the two fields is not matched, the prompt information is displayed so as to prompt the user to reselect the target label. More specifically, the query field corresponding to the selected target tag may be queried from a pre-constructed data tag information table.
In this embodiment, by comparing the query fields corresponding to the two selected target tags, the combination is performed only when the query fields corresponding to the two target tags are completely matched, so as to ensure the logic correctness of the obtained combined tag, and avoid the problem that the selected target tag cannot perform logic operation.
In an exemplary embodiment, after curing the data to be cured under the created data tag based on the tag curing configuration information in response to the curing confirmation instruction at step S140, further includes: updating a pre-constructed data tag information table according to the solidified data tag and corresponding solidified data; the data label information table stores data labels created in the past and corresponding solidification data;
in the specific implementation, after one data tag is obtained through each curing, the cured data tag and corresponding curing data can be added to a pre-constructed data tag information table, and the created data tag and corresponding curing data are stored through the data tag information table, so that on one hand, when data call is carried out subsequently, the data can be called in a combined mode based on the data tag in the data tag information table, and on the other hand, candidate tags needing to be displayed in a data screening page can be determined conveniently according to the data tag information table.
Step S430, performing logic operation on the target label in the combined label according to the target operator to obtain the solidified data corresponding to the combined label, and further comprising: and updating the data tag information table according to the combined tag and the solidification data corresponding to the combined tag.
In order to further improve the richness of the data tag information table, when the combination tag and the corresponding curing data thereof are obtained through the screening combination of the tags, the combination tag and the corresponding curing data thereof can be added to the data tag information table.
In one embodiment, to facilitate understanding of embodiments of the application by those skilled in the art, a specific example will be described below in conjunction with the accompanying drawings.
Referring to fig. 6, a flow diagram of a data tag curing method is shown, comprising the steps of:
(1) And receiving input query SQL and executing the query SQL, and displaying an error SQL prompt when the query fails.
(2) And when the query is successful, displaying the query result.
(3) And receiving a triggering instruction aiming at the next step, displaying a data tag page, receiving input tag information, and storing the tag information to obtain a data tag.
(4) And receiving the input curing table information, and creating a corresponding curing table.
(5) And generating a tag curing task and a corresponding scheduling task when receiving the curing confirmation instruction.
(6) The tag curing tasks are executed asynchronously in the task scheduling platform.
(7) GTID_MODE (Global task recognition MODE) of MYSQL (a relational database management system) is closed, a distributed lock is closed, and a tag curing task is executed at an application layer through JDBC (Java DataBase Connectivity, java database connection, a Java interface for executing SQL sentences).
(8) After curing is completed, GTID_MODE is opened, and the lock is released.
(9) Updating the curing result to the data tag information table and updating the scheduling task information table.
Referring to fig. 7, a schematic diagram of a data tag screening process is shown, specifically including the following steps:
(1) Displaying a tag screening page; the tag screening page includes a plurality of candidate tags and a plurality of candidate operators.
(2) Determining a first target label selected by a user from the candidate labels, and querying a SELECT field of the label from a label information table.
(3) When the user SELECTs a tag other than the first target tag (denoted as a second target tag) from the candidate tags, the SELECT field of the second target tag is queried from the tag information table.
(4) Comparing whether the SELECT fields of the two labels are completely consistent, if not, displaying prompt information to prompt a user to reselect the label; if yes, the selected target label and the target operator are combined into a complete expression.
(5) And analyzing the node information, and converting the node information into a suffix expression for storage.
(6) And storing label screening node information, data label information and association relation information, and scheduling on-line tasks.
(7) And carrying out suffix expression operation by using a stack, calculating logic operation between two labels each time, and storing an operation result into a temporary table.
(8) After the traversal is finished, the final temporary table result is used as a label screening result, and screening results and the like are stored in a data label information table.
According to the data tag calculation and curing method, the data tag can be quickly created through SQL, the creation efficiency of the data tag can be improved, the convenience is higher through screening and combining of the data tag by the visual interaction page, the curing efficiency can be improved through SQL mode for curing the data tag on the data application layer, the curing and tag screening tasks are asynchronously performed by the task scheduling system, and the concurrency capability can be improved.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a data tag curing device for realizing the data tag curing method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in the embodiments of the data tag curing device or devices provided below may be referred to the limitation of the data tag curing method hereinabove, and will not be repeated here.
In one embodiment, as shown in fig. 8, there is provided a data tag curing apparatus comprising: a receiving module 810, a querying module 820, a creating module 830, and a curing module 840, wherein:
a receiving module 810, configured to receive a data query instruction; the data query instruction carries a query condition;
the query module 820 is configured to determine, in response to a data query instruction, association data corresponding to a query condition from at least one financial database, as data to be solidified;
a creating module 830, configured to create a data tag for data to be cured, and receive tag curing configuration information input for the data to be cured;
and a curing module 840 for curing the data to be cured under the created data tag based on the tag curing configuration information in response to the curing confirmation instruction.
In one embodiment, the creating module 830 is further configured to respond to a data tag creation instruction, and present a data tag page; the data tag page comprises a tag information input entry; and receiving the tag information input by the tag information input inlet to obtain the data tag.
In one embodiment, the tag curing configuration information includes curing table information; the curing module 840 is further configured to create a curing table corresponding to the curing table information in response to the curing confirmation instruction; storing the data to be solidified into a solidification table; curing the curing table storing the data to be cured under the created data label.
In one embodiment, the curing module 840 is further configured to generate a label curing task; and in response to an execution instruction for the tag curing task, curing the curing table storing the data to be cured under the created data tag.
In one embodiment, the solidification module 840 is further configured to generate a scheduling task corresponding to the tag solidification task in the task scheduling platform; executing a tag solidification task when an execution instruction for a scheduling task is received; the task scheduling platform comprises scheduling tasks corresponding to a plurality of tag solidification tasks, and each scheduling task is executed asynchronously.
In one embodiment, the device further comprises a label combination module, which is used for displaying a label screening page; the label screening page comprises a plurality of candidate labels and a plurality of candidate operators, wherein the candidate labels are data labels obtained by history solidification; obtaining a combined label based on the combined operation aiming at the target label in the plurality of candidate labels and aiming at the target operator in the plurality of candidate operators; and carrying out logic operation on the target label in the combined label according to the target operator to obtain the solidification data corresponding to the combined label.
In one embodiment, the target tag includes at least two candidate tags, and the tag combination module is further configured to obtain a first query field corresponding to a first target tag in the plurality of candidate tags in response to a selection operation for the first target tag; the query field is an optional field of the solidification data corresponding to the first target label; when receiving a selection operation for a second target tag in the plurality of candidate tags, acquiring a second query field corresponding to the second target tag; the second query field is an optional field of the solidification data corresponding to the second target label; in the case that the first query field and the second query field are perfectly matched, the first target tag and the second target tag are determined to be combinable target tags.
In one embodiment, the device further comprises an updating module, configured to update a pre-constructed data tag information table according to the cured data tag and the corresponding cured data; the data label information table stores data labels created in the past and corresponding solidification data;
and the updating module is also used for updating the data tag information table according to the combined tag and the solidification data corresponding to the combined tag.
The respective modules in the above-described data tag curing apparatus may be implemented in whole or in part by software, hardware, and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure thereof may be as shown in fig. 9. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a data tag curing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by persons skilled in the art that the architecture shown in fig. 9 is merely a block diagram of some of the architecture relevant to the present inventive arrangements and is not limiting as to the computer device to which the present inventive arrangements are applicable, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:
receiving a data query instruction; the data query instruction carries a query condition;
responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
and responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
In an embodiment, there is also provided a computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
receiving a data query instruction; the data query instruction carries a query condition;
responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
and responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, carries out the steps of the method embodiments described above.
In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of:
receiving a data query instruction; the data query instruction carries a query condition;
Responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
and responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
In an embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the steps of the method embodiments described above.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the embodiments provided herein may include at least one of a relational database and a non-relational database. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processor referred to in the embodiments provided in the present application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic unit, a data processing logic unit based on quantum computing, or the like, but is not limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples illustrate only a few embodiments of the application and are described in detail herein without thereby limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of the application should be assessed as that of the appended claims.

Claims (12)

1. A method of curing a data tag, the method comprising:
receiving a data query instruction; the data query instruction carries a query condition;
responding to the data query instruction, and determining associated data corresponding to the query condition from at least one financial database as data to be solidified;
creating a data tag for the data to be cured, and receiving tag curing configuration information input for the data to be cured;
And responding to a curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
2. The method of claim 1, wherein the creating a data tag for the data to be cured comprises:
responding to a data tag creation instruction, and displaying a data tag page; the data tag page comprises a tag information input entry;
and receiving the tag information input by the tag information input inlet to obtain the data tag.
3. The method of claim 1, wherein the tag curing configuration information includes curing table information;
the response to the curing confirmation instruction cures the data to be cured under the created data label according to the label curing configuration information, and the response to the curing confirmation instruction comprises the following steps:
responding to the curing confirmation instruction, and creating a curing table corresponding to the curing table information;
storing the data to be solidified into the solidification table;
and solidifying the solidifying table storing the data to be solidified to the created data label.
4. A method according to claim 3, wherein said curing the curing table storing the data to be cured under the created data label comprises:
Generating a label solidification task;
and responding to an execution instruction for the label curing task, and curing the curing table stored with the data to be cured under the created data label.
5. The method according to claim 4, wherein the method further comprises:
generating a scheduling task corresponding to the label curing task in a task scheduling platform;
executing the tag solidification task when an execution instruction aiming at the scheduling task is received;
the task scheduling platform comprises scheduling tasks corresponding to a plurality of tag solidification tasks, and the scheduling tasks are executed asynchronously.
6. The method according to any one of claims 1-5, further comprising:
displaying a tag screening page; the label screening page comprises a plurality of candidate labels and a plurality of candidate operators, wherein the candidate labels are data labels obtained by historical solidification;
obtaining a combined label based on the combined operation aiming at the target label in the plurality of candidate labels and aiming at the target operator in the plurality of candidate operators;
and carrying out logic operation on the target label in the combined label according to the target operator to obtain the solidification data corresponding to the combined label.
7. The method of claim 6, wherein the target tag comprises at least two candidate tags, and wherein the process of selecting the target tag comprises:
responding to a selection operation for a first target tag in the plurality of candidate tags, and acquiring a first query field corresponding to the first target tag; the first query field is an optional field of the solidification data corresponding to the first target label;
when receiving a selection operation for a second target tag in the plurality of candidate tags, acquiring a second query field corresponding to the second target tag; the second query field is an optional field of the solidification data corresponding to the second target label;
and determining the first target label and the second target label as combinable target labels under the condition that the first query field is completely matched with the second query field.
8. The method of claim 6, wherein the curing the data to be cured under the created data tag based on the tag curing configuration information in response to a curing confirmation instruction further comprises:
updating a pre-constructed data tag information table according to the solidified data tag and corresponding solidified data; the data label information table stores data labels created in the past and corresponding solidification data;
And performing logic operation on the target label in the combined label according to the target operator to obtain the solidification data corresponding to the combined label, and further comprising:
and updating the data tag information table according to the combination tag and the solidification data corresponding to the combination tag.
9. A data tag curing apparatus, the apparatus comprising:
the receiving module is used for receiving the data query instruction; the data query instruction carries a query condition;
the query module is used for responding to the data query instruction, determining associated data corresponding to the query condition from at least one financial database and taking the associated data as data to be solidified;
the creation module is used for creating a data tag aiming at the data to be solidified and receiving tag solidification configuration information input aiming at the data to be solidified;
and the curing module is used for responding to the curing confirmation instruction, and curing the data to be cured under the created data label based on the label curing configuration information.
10. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the data tag curing method of any of claims 1 to 8 when the computer program is executed.
11. A computer readable storage medium having stored thereon a computer program, characterized in that the computer program when executed by a processor implements the steps of the data tag curing method of any of claims 1 to 8.
12. A computer program product comprising a computer program, characterized in that the computer program, when executed by a processor, implements the steps of the data tag curing method of any of claims 1 to 8.
CN202310623161.5A 2023-05-30 2023-05-30 Data tag solidifying method, device, computer equipment and storage medium Pending CN116775955A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310623161.5A CN116775955A (en) 2023-05-30 2023-05-30 Data tag solidifying method, device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310623161.5A CN116775955A (en) 2023-05-30 2023-05-30 Data tag solidifying method, device, computer equipment and storage medium

Publications (1)

Publication Number Publication Date
CN116775955A true CN116775955A (en) 2023-09-19

Family

ID=87988768

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310623161.5A Pending CN116775955A (en) 2023-05-30 2023-05-30 Data tag solidifying method, device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN116775955A (en)

Similar Documents

Publication Publication Date Title
CN109997126B (en) Event driven extraction, transformation, and loading (ETL) processing
US9146955B2 (en) In-memory, columnar database multidimensional analytical view integration
CN111061475B (en) Software code generating method, device, computer equipment and storage medium
CN109710220B (en) Relational database query method, relational database query device, relational database query equipment and storage medium
CN114115844A (en) Page generation method and device, computer equipment and storage medium
US8296725B2 (en) Framework for variation oriented analysis for service-oriented architecture
CN117390011A (en) Report data processing method, device, computer equipment and storage medium
CN115544050A (en) Operation log recording method, device, equipment and storage medium
CN116775955A (en) Data tag solidifying method, device, computer equipment and storage medium
CN114356945A (en) Data processing method, data processing device, computer equipment and storage medium
CN111143328A (en) Agile business intelligent data construction method, system, equipment and storage medium
CN113918996B (en) Distributed data processing method, device, computer equipment and storage medium
CN117112654B (en) City data display method, device, computer equipment and storage medium
CN114547066A (en) Nuclear power business data standardization method and device and computer equipment
CN118132656A (en) Knowledge graph construction method, knowledge graph construction device, computer equipment and storage medium
CN116594628A (en) Data tracing method and device and computer equipment
CN116719892A (en) Data display method, device, computer equipment and storage medium
CN117435589A (en) Data transfer method, device, computer equipment and storage medium
CN114385630A (en) Blood relationship combing method, apparatus, device, storage medium, and program product
CN116128616A (en) Method and device for calculating data processing of resource risk trial calculation and computer equipment
CN116756022A (en) Data preparation method, device, computer equipment and storage medium
CN117909550A (en) Query method, query device, computer equipment and storage medium
CN117827895A (en) Index data processing method and device and computer equipment
CN117667985A (en) Data positioning method, device, computer equipment and storage medium
CN117453957A (en) Resource processing method, device, computer 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