CN114036174B - Data updating method, device, equipment and storage medium - Google Patents
Data updating method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN114036174B CN114036174B CN202111525945.1A CN202111525945A CN114036174B CN 114036174 B CN114036174 B CN 114036174B CN 202111525945 A CN202111525945 A CN 202111525945A CN 114036174 B CN114036174 B CN 114036174B
- Authority
- CN
- China
- Prior art keywords
- metadata
- data
- updated
- update
- updating
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 64
- 238000010586 diagram Methods 0.000 claims abstract description 66
- 230000008569 process Effects 0.000 claims abstract description 22
- 238000004140 cleaning Methods 0.000 claims description 10
- 238000004590 computer program Methods 0.000 claims description 9
- 238000010276 construction Methods 0.000 claims description 7
- 238000011144 upstream manufacturing Methods 0.000 claims description 7
- 230000005856 abnormality Effects 0.000 claims description 6
- 238000013473 artificial intelligence Methods 0.000 abstract description 6
- 238000005516 engineering process Methods 0.000 abstract description 5
- 238000004364 calculation method Methods 0.000 description 26
- 230000008859 change Effects 0.000 description 10
- 230000006870 function Effects 0.000 description 9
- 238000004891 communication Methods 0.000 description 8
- 238000009825 accumulation Methods 0.000 description 6
- 238000007726 management method Methods 0.000 description 5
- 230000002159 abnormal effect Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 4
- 238000006243 chemical reaction Methods 0.000 description 2
- 238000009792 diffusion process Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 239000012535 impurity Substances 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to artificial intelligence technology, and discloses a data updating method, which comprises the following steps: acquiring a metadata set, and constructing a data link diagram of the metadata set according to the association relation between metadata in the metadata set; when an update task request of a metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated; carrying out data backtracking on a metadata set in the data link diagram, and searching a metadata position of metadata to be updated in the data link diagram in the data backtracking process; and updating the metadata to be updated by using the updating rule according to the metadata position. In addition, the invention also relates to a block chain technology, and the updating rule can be stored in a node of the block chain. The invention also provides a data updating device, electronic equipment and a storage medium. The invention can improve the efficiency and accuracy of data updating.
Description
Technical Field
The present invention relates to the field of artificial intelligence technologies, and in particular, to a data updating method, apparatus, electronic device, and computer readable storage medium.
Background
At present, with the rise of big data age, the traditional data warehouse is changed into a large platform data warehouse, the data forms of different business systems stored in the data warehouse are various, and in the actual application and process of data, the data authenticity and timeliness in the data warehouse influence the application of the data, and the lowest source of the data needs to be accurately tracked, namely, the data backtracking is carried out, so that the real-time data updating is carried out.
However, there are limitations in the use and modification of historical data in the data warehouse during the backtracking process, and the maintained data warehouse is rarely updated, so that the data warehouse is inconsistent with the data in the data mart, the timeliness of data update is affected, and the efficiency and accuracy of data update are low.
Disclosure of Invention
The invention provides a data updating method, a data updating device and a computer readable storage medium, which mainly aim to improve the efficiency and the accuracy of data updating.
In order to achieve the above object, the present invention provides a data updating method, including:
Acquiring a metadata set, and constructing a data link diagram of the metadata set, which is stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform, according to the association relation between metadata in the metadata set;
when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated;
performing data backtracking on the metadata set in the data link diagram, and searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process;
and updating the metadata to be updated by utilizing the updating rule according to the metadata position.
Optionally, the constructing a data link diagram of the metadata set from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform according to an association relation between metadata in the metadata set includes:
Constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to the association relation between metadata in the metadata set;
And extracting a deep incidence relation of the metadata set through the first link, and constructing a data link diagram of the metadata set, which is stored from a data warehouse layer of the data warehouse platform to a data mart layer of the data warehouse platform, according to the deep incidence relation.
Optionally, the constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to an association relation between metadata in the metadata set includes:
Extracting a plurality of identifiers corresponding to a plurality of metadata in the metadata set, and generating a plurality of initial nodes of the identifiers;
and connecting a plurality of initial nodes according to the association relation, and generating a first link of the metadata set, wherein the first link is stored from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform.
Optionally, the performing data backtracking on the metadata set in the data link graph, and searching the metadata position of the metadata to be updated in the data link graph in the data backtracking process includes:
Traversing the data link diagram to obtain metadata corresponding to each node in the data link diagram and an upstream-downstream relationship between metadata in the metadata set;
splitting the metadata update task request into a plurality of subtasks, and storing the subtasks into a preset message middleware;
And executing a plurality of subtasks by using the message middleware, and searching metadata positions of metadata to be updated, which are related to the subtasks, in the data link diagram from upstream and downstream relations among metadata in the metadata set.
Optionally, after the updating the metadata to be updated using the updating rule, the method further includes:
Acquiring a current version of metadata to be updated and a target updated version of the metadata to be updated, and judging whether the current version is consistent with the target updated version or not by utilizing a preset optimistic lock;
if the current version is inconsistent with the target updated version, determining that the data update fails;
and if the current version is consistent with the target updated version, determining that the data update is successful.
Optionally, after the updating the metadata to be updated using the updating rule, the method further includes:
Creating a preset window, and identifying whether the update metadata is matched with a corresponding update task request or not from the preset window, wherein the update task request comprises a plurality of subtasks;
If the update metadata is matched with the corresponding update task request, maintaining an update state;
and if the update metadata is not matched with the corresponding update task request, retransmitting the subtasks with the abnormality in the update task request to a preset message middleware to trigger the data update to be carried out again.
Optionally, after the acquiring the metadata set, the method further includes:
and carrying out data cleaning processing on the metadata set by utilizing a preset data warehouse layer, wherein the data cleaning processing comprises the following steps: data outlier operations and data missing value padding operations.
In order to solve the above problems, the present invention also provides a data updating apparatus, the apparatus comprising:
The data link diagram construction module is used for acquiring a metadata set, and constructing a data link diagram of the metadata set, which is stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform, according to the association relation between metadata in the metadata set;
The updating rule acquisition module is used for acquiring metadata to be updated in the metadata set according to the updating task request when the updating task request of the metadata set is received, and acquiring the updating rule of the metadata to be updated;
the data backtracking module is used for carrying out data backtracking on the metadata set in the data link diagram, and searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process;
and the data updating module is used for updating the metadata to be updated by utilizing the updating rule according to the metadata position.
In order to solve the above-mentioned problems, the present invention also provides an electronic apparatus including:
at least one processor; and
A memory communicatively coupled to the at least one processor; wherein,
The memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data updating method described above.
In order to solve the above-described problems, the present invention also provides a computer-readable storage medium having stored therein at least one computer program that is executed by a processor in an electronic device to implement the above-described data updating method.
In the embodiment of the invention, firstly, a metadata set is obtained, a data link diagram of the metadata set from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform is constructed according to the association relation between metadata in the metadata set, the association relation between metadata in the metadata set can be displayed more clearly, and the consistency of the metadata set storage can be ensured from the original data layer of the preset data warehouse platform to the data mart layer of the data warehouse platform; secondly, when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated, wherein subsequent update of the metadata to be updated can be realized according to the update rule; and finally, carrying out data backtracking on the metadata set in the data link diagram, searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process, obtaining the upstream and downstream relation between the metadata in the metadata set through the data backtracking, determining the position of the metadata to be updated more accurately, updating the metadata to be updated according to the metadata position by utilizing the updating rule, updating the metadata to be updated more efficiently, timely and accurately, obtaining the updated metadata, and improving the data updating efficiency and accuracy. Therefore, the data updating method, the device, the electronic equipment and the computer readable storage medium can improve the efficiency and the accuracy of data updating.
Drawings
FIG. 1 is a flowchart illustrating a data update method according to an embodiment of the present invention;
FIG. 2 is a functional block diagram of a data updating apparatus according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device for implementing the data updating method according to an embodiment of the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
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 invention.
The embodiment of the application provides a data updating method. The execution subject of the data updating method includes, but is not limited to, at least one of a server, a terminal, and the like, which can be configured to execute the method provided by the embodiment of the application. In other words, the data update method may be performed by software or hardware installed in a terminal device or a server device, and the software may be a blockchain platform. The service end includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like. The server may be an independent server, or may be a cloud server that provides cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (ContentDelivery Network, CDN), and basic cloud computing services such as big data and artificial intelligence platforms.
Referring to fig. 1, a flow chart of a data updating method according to an embodiment of the invention is shown. In this embodiment, the data updating method includes:
s1, acquiring a metadata set, and constructing a data link diagram of the metadata set, which is stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform, according to an association relation between metadata in the metadata set.
In the embodiment of the invention, the metadata set refers to data describing information such as data attributes, data formats and the like, the types of the metadata set comprise business metadata (such as configuration and operation data of a datagram table and a data product) and technical metadata (such as input and output information during data synchronization), and the metadata set can be acquired from a database of a business system.
In an embodiment of the present invention, the preset data warehouse platform includes: the system comprises an original data layer, a data warehouse layer and a data mart layer, wherein the original data layer can extract a metadata set from a service system, and keep consistency with the service system in granularity, organization mode and the like of data, and the query of a report and detailed data originally generated by the service system can be carried out from a preset original data layer, so that the query pressure of the service system is reduced.
In the embodiment of the invention, the data original layer mainly collects metadata sets, stores the collected metadata sets into the data warehouse layer for data processing such as data cleaning, splitting, summarizing and converting of the metadata sets, obtains clean metadata sets, and stores the clean metadata sets into the data market layer for final data processing.
In detail, after the acquiring the metadata set, the method further includes:
and carrying out data cleaning processing on the metadata set by utilizing a preset data warehouse layer, wherein the data cleaning processing comprises the following steps: data outlier operations and data missing value padding operations.
In the embodiment of the invention, the metadata set in the original data layer can be cleaned by utilizing the data warehouse layer, the abnormal values in the metadata set are deleted and the missing values in the metadata set are filled, and the data warehouse layer can also perform data processing operations such as splitting, summarizing, converting and the like on the metadata set, so that clean and accurate metadata with impurities removed can be obtained.
And the data mart layer performs data calculation operations such as clustering, distribution, statistics, complex index calculation and the like on the metadata sets in the data warehouse layer, and realizes data processing conversion, data index calculation and data link diagram composed of summarized data results.
In the embodiment of the invention, the data link diagram refers to a diagram describing the association relationship between metadata in the metadata set. For example, a description is given of the case of a customer asset table in a banking system, whether or not the customer assets all include a deposit asset table and a customer non-deposit asset table, and an association relationship between customers.
In the embodiment of the invention, the data link graph can be used for constructing a data link graph describing the association relationship of metadata, which is formed by connecting the metadata set from an original data layer of a preset data warehouse platform to the data warehouse layer and then to a data mart layer of the data warehouse platform, according to the association relationship among metadata in the metadata set, and the data link graph comprises a plurality of nodes.
Preferably, the data link graph may be a directed acyclic graph (DIRECTED ACYCLIC GRAPH, DAG).
In detail, the constructing a data link diagram of the metadata set from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform according to the association relation between metadata in the metadata set includes:
Constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to the association relation between metadata in the metadata set;
And extracting a deep incidence relation of the metadata set through the first link, and constructing a data link diagram of the metadata set, which is stored from a data warehouse layer of the data warehouse platform to a data mart layer of the data warehouse platform, according to the deep incidence relation.
In an embodiment of the present invention, the association relationship of metadata in the metadata set refers to a hierarchical structure between metadata; the deep association relationship refers to hidden association information between metadata.
For example, there are an enterprise a and an enterprise B, where the association relationship enterprise of the enterprise a corresponds to the risk classification of the enterprise a, the asset holding of the enterprise a, and the associated securities of the enterprise a, and the association relationship of the enterprise B corresponds to the risk classification of the enterprise B, the asset holding of the enterprise B, and the associated securities of the enterprise B; and enterprise B is the subsidiary of enterprise A, then the deep association between enterprise A and enterprise B is the relationship between parent company and subsidiary.
Further, the constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to the association relation between metadata in the metadata set includes:
Extracting a plurality of identifiers corresponding to a plurality of metadata in the metadata set, and generating a plurality of initial nodes of the identifiers;
and connecting a plurality of initial nodes according to the association relation, and generating a first link of the metadata set, wherein the first link is stored from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform.
In an embodiment of the present invention, the association relationship refers to a hierarchical structure between metadata, each metadata in a metadata set is split into a plurality of fields, so as to obtain an identifier corresponding to each metadata corresponding field, and an initial node corresponding to each identifier, that is, one metadata corresponds to one identifier and one identifier corresponds to one initial node, and a plurality of initial nodes are connected through the association relationship, so as to obtain a first link including association information.
For example, in the investment field, the initial nodes of the first link may be four initial nodes of the opponent enterprise, risk classification, asset holding bin and associated securities, and the association relationship may be regarded as a hierarchy structure, and the hierarchy structure is formed by connecting the initial nodes from high to low for the opponent enterprise, risk classification, asset holding bin and associated securities, so as to generate the first link related to the association relationship of the opponent enterprise.
S2, when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated.
In the embodiment of the invention, the metadata to be updated refers to part of data with real-time variation in the metadata set caused by the update task request of the metadata set.
For example, the metadata set is related information of risk classification of opponent enterprises in the investment field, if there is a change in risk classification of one or more opponent enterprises due to market change in 1000 opponent enterprises of existing transactions, the opponent enterprises with the risk classification change need to be updated in time due to the change in the risk classification, and all risk classes and factors and calculation results of policy analysis calculation are immediately adjusted according to the opponent enterprises with the risk classification change, and the adjusted risk classes and calculation factors and calculation results of policy analysis are metadata to be updated.
In the embodiment of the present invention, the received data update task request may be an update task request instruction sent by a user.
In the embodiment of the present invention, the update rule refers to a rule constructed according to a preset update mode and a preset update logic, and the update of the data to be updated subsequently can be achieved through the preset update mode and the update logic.
In detail, the acquiring the updating rule of the metadata to be updated includes:
constructing an updating mode of the metadata to be updated and updating logic of the metadata to be updated;
And obtaining the update rule according to the update mode and the update logic.
Specifically, if the metadata to be updated is data in the database, a preset structured query language (Structured Query Language, SQL) may be used as an update mode of the metadata to be updated, and according to an update logic that establishes a new table first and then performs data filtering, a subsequent update operation of the data to be updated is implemented.
And S3, carrying out data backtracking on the metadata set in the data link diagram, and searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process.
In the embodiment of the invention, the update task request is a task for triggering data update, the task can be divided into a plurality of subtasks, for example, the update task request can be index calculation of interest rate and risk value of the fixed-receiving asset, and the subtasks can be daily gain rate, scale and interest rate type calculation tasks and risk summary calculation tasks of a plurality of assets.
In the embodiment of the invention, the task is split into a plurality of subtasks, so that the problem that the whole task is failed to update due to abnormal subtask update in the subsequent update process can be avoided, the plurality of subtasks can be executed in parallel, and the subsequent data update efficiency is improved.
In detail, the performing data backtracking on the metadata set in the data link graph, and searching the metadata position of the metadata to be updated in the data link graph in the data backtracking process includes:
Traversing the data link diagram to obtain metadata corresponding to each node in the data link diagram and an upstream-downstream relationship between metadata in the metadata set;
splitting the metadata update task request into a plurality of subtasks, and storing the subtasks into a preset message middleware;
And executing a plurality of subtasks by using the message middleware, and searching metadata positions of metadata to be updated, which are related to the subtasks, in the data link diagram from upstream and downstream relations among metadata in the metadata set.
In the embodiment of the invention, the update task request of the metadata is split into a plurality of subtasks, the subtasks are stored in the preset message middleware, the plurality of subtasks are asynchronously processed, and the task processing efficiency is improved.
Preferably, the message middleware may be kafka.
In another embodiment of the present invention, traversing the data link graph is to trace back data of the metadata set connection graph, so as to obtain metadata corresponding to each node in the graph and an upstream-downstream relationship between metadata in the metadata set.
In another embodiment of the present invention, data backtracking of the metadata set may be performed based on a date dimension of the metadata set, and a date range of data that affects between metadata in the metadata set may be more accurately determined.
For example, in the investment field, there are an investment data topic, a plurality of competing subjects and attribute sets corresponding to the topic, the investment subject is an energy electric box investment bid, the subjects participating in the investment are a plurality of competing enterprises, the attributes corresponding to the subjects are securities and asset holding bins, each subject has a date diffusion rule by determining date access, such as the accumulation of income of competing enterprises, the accumulation of selling, the accumulation attribute needs to be expanded to YTD (to date today), the date range of part of securities needs to be expanded to the specific buying date, the secondary buying date, the expiration date and the like, so that data backtracking is performed according to the date dimension, and the accuracy and efficiency of the data backtracking can be improved.
And S4, updating the metadata to be updated by using the updating rule according to the metadata position.
In this embodiment, after updating the metadata to be updated using the update rule, the update metadata may be directly obtained from the metadata location.
In the embodiment of the invention, the metadata to be updated can be accessed by a preset task scheduling platform aiming at different data layering of real-time variation, and the updating rule is utilized to update the metadata to be updated, so that the timeliness of data updating is ensured.
In the embodiment of the invention, after the metadata to be updated are updated by utilizing the updating rule, the metadata to be updated are subjected to regular feedback heartbeat, the updating progress is recorded, the updated metadata are identified again by adopting a preset optimistic lock, the updated metadata are transmitted to a judging pool of the optimistic lock, and if the updated metadata are overlapped, the overlapped updated metadata are modified or deleted, so that the accuracy of the updated metadata is ensured.
In an embodiment of the present invention, after the updating the metadata to be updated using the updating rule, the method further includes:
acquiring a current version of metadata to be updated and a target updated version of the updated metadata, and judging whether the current version is consistent with the target updated version or not by utilizing a preset optimistic lock;
if the current version is inconsistent with the target updated version, determining that the data update fails;
and if the current version is consistent with the target updated version, determining that the data update is successful.
In the embodiment of the invention, the current version of the metadata to be updated is the updated metadata obtained from the metadata position.
In an embodiment of the invention, an optimistic lock is adopted to judge whether the current version and the updated version of the metadata to be updated are consistent, thereby ensuring whether the data update is realized or not, and ensuring that the metadata to be updated with overlapping data do not appear repeatedly.
For example, the metadata to be updated is 100 elements of the current account balance, and the current version is 1; there are two data update tasks, a and B, the a task is to deduct 30 the current account balance, the B task is to deduct 40 the current account balance; when the task A is executed, the current version is 1, the account balance is updated to 70, the target updated version in the data returned after the task A is updated is 2, and the data is updated to 70; when the task B is executed, the read current version is 1 and the account balance is updated to 60, but the task B fails to update, and the version at the moment is changed to 2 as the task A completes the current version, and the version is not matched, so that the task B fails to update data, and the metadata to be updated is ensured not to have repeated problems when being updated.
In an embodiment of the present invention, after the data update is implemented, the method further includes:
Creating a preset window, and identifying whether the update metadata is matched with a corresponding update task request or not from the preset window, wherein the update task request comprises a plurality of subtasks;
If the update metadata is matched with the corresponding update task request, maintaining an update state;
and if the update metadata is not matched with the corresponding update task request, retransmitting the subtasks with the abnormality in the update task request to a preset message middleware to trigger the data update to be carried out again.
In another embodiment of the present invention, the update task request may be an index calculation of the interest rate risk value of the fixed asset, the subtask may be a daily gain rate, a scale, an interest rate type calculation task and a risk summary calculation task of a plurality of assets, and when an update abnormality occurs in a subtask, the subtask may be transmitted to the message middleware for updating again to achieve final data update.
In the embodiment of the invention, firstly, a metadata set is obtained, a data link diagram of the metadata set from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform is constructed according to the association relation between metadata in the metadata set, the association relation between metadata in the metadata set can be displayed more clearly, and the consistency of the metadata set storage can be ensured from the original data layer of the preset data warehouse platform to the data mart layer of the data warehouse platform; secondly, when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated, wherein subsequent update of the metadata to be updated can be realized according to the update rule; and finally, carrying out data backtracking on the metadata set in the data link diagram, searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process, obtaining the upstream and downstream relation between the metadata in the metadata set through the data backtracking, determining the position of the metadata to be updated more accurately, updating the metadata to be updated according to the metadata position by utilizing the updating rule, updating the metadata to be updated more efficiently, timely and accurately, obtaining the updated metadata, and improving the data updating efficiency and accuracy. Therefore, the data updating method provided by the invention can improve the efficiency and accuracy of data updating.
Fig. 2 is a functional block diagram of a data updating apparatus according to an embodiment of the present invention.
The data updating apparatus 100 of the present invention may be installed in an electronic device. The data updating apparatus 100 may include a data link map construction module 101, an update rule acquisition module 102, a data backtracking module 103, and a data updating module 104 according to the implemented functions. The module of the invention, which may also be referred to as a unit, refers to a series of computer program segments, which are stored in the memory of the electronic device, capable of being executed by the processor of the electronic device and of performing a fixed function.
In the present embodiment, the functions concerning the respective modules/units are as follows:
The data link diagram construction module 101 is configured to obtain a metadata set, and construct a data link diagram of the metadata set from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform according to an association relationship between metadata in the metadata set.
In the embodiment of the invention, the metadata set refers to data describing information such as data attributes, data formats and the like, the types of the metadata set comprise business metadata (such as configuration and operation data of a datagram table and a data product) and technical metadata (such as input and output information during data synchronization), and the metadata set can be acquired from a database of a business system.
In an embodiment of the present invention, the preset data warehouse platform includes: the system comprises an original data layer, a data warehouse layer and a data mart layer, wherein the original data layer can extract a metadata set from a service system, and keep consistency with the service system in granularity, organization mode and the like of data, and the query of a report and detailed data originally generated by the service system can be carried out from a preset original data layer, so that the query pressure of the service system is reduced.
In the embodiment of the invention, the data original layer mainly collects metadata sets, stores the collected metadata sets into the data warehouse layer for data processing such as data cleaning, splitting, summarizing and converting of the metadata sets, obtains clean metadata sets, and stores the clean metadata sets into the data market layer for final data processing.
The data link map construction module 101 may be configured to:
and carrying out data cleaning processing on the metadata set by utilizing a preset data warehouse layer, wherein the data cleaning processing comprises the following steps: data outlier operations and data missing value padding operations.
In the embodiment of the invention, the metadata set in the original data layer can be cleaned by utilizing the data warehouse layer, the abnormal values in the metadata set are deleted and the missing values in the metadata set are filled, and the data warehouse layer can also perform data processing operations such as splitting, summarizing, converting and the like on the metadata set, so that clean and accurate metadata with impurities removed can be obtained.
And the data mart layer performs data calculation operations such as clustering, distribution, statistics, complex index calculation and the like on the metadata sets in the data warehouse layer, and realizes data processing conversion, data index calculation and data link diagram composed of summarized data results.
In the embodiment of the invention, the data link diagram refers to a diagram describing the association relationship between metadata in the metadata set. For example, a description is given of the case of a customer asset table in a banking system, whether or not the customer assets all include a deposit asset table and a customer non-deposit asset table, and an association relationship between customers.
In the embodiment of the invention, the data link graph can be used for constructing a data link graph describing the association relationship of metadata, which is formed by connecting the metadata set from an original data layer of a preset data warehouse platform to the data warehouse layer and then to a data mart layer of the data warehouse platform, according to the association relationship among metadata in the metadata set, and the data link graph comprises a plurality of nodes.
Preferably, the data link graph may be a directed acyclic graph (DIRECTED ACYCLIC GRAPH, DAG).
In detail, the data link map construction module 101 constructs a data link map of the metadata set stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform according to an association relationship between metadata in the metadata set by performing the following operations, including:
Constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to the association relation between metadata in the metadata set;
And extracting a deep incidence relation of the metadata set through the first link, and constructing a data link diagram of the metadata set, which is stored from a data warehouse layer of the data warehouse platform to a data mart layer of the data warehouse platform, according to the deep incidence relation.
In an embodiment of the present invention, the association relationship of metadata in the metadata set refers to a hierarchical structure between metadata; the deep association relationship refers to hidden association information between metadata.
For example, there are an enterprise a and an enterprise B, where the association relationship enterprise of the enterprise a corresponds to the risk classification of the enterprise a, the asset holding of the enterprise a, and the associated securities of the enterprise a, and the association relationship of the enterprise B corresponds to the risk classification of the enterprise B, the asset holding of the enterprise B, and the associated securities of the enterprise B; and enterprise B is the subsidiary of enterprise A, then the deep association between enterprise A and enterprise B is the relationship between parent company and subsidiary.
Further, the constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to the association relation between metadata in the metadata set includes:
Extracting a plurality of identifiers corresponding to a plurality of metadata in the metadata set, and generating a plurality of initial nodes of the identifiers;
and connecting a plurality of initial nodes according to the association relation, and generating a first link of the metadata set, wherein the first link is stored from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform.
In an embodiment of the present invention, the association relationship refers to a hierarchical structure between metadata, each metadata in a metadata set is split into a plurality of fields, so as to obtain an identifier corresponding to each metadata corresponding field, and an initial node corresponding to each identifier, that is, one metadata corresponds to one identifier and one identifier corresponds to one initial node, and a plurality of initial nodes are connected through the association relationship, so as to obtain a first link including association information.
For example, in the investment field, the initial nodes of the first link may be four initial nodes of the opponent enterprise, risk classification, asset holding bin and associated securities, and the association relationship may be regarded as a hierarchy structure, and the hierarchy structure is formed by connecting the initial nodes from high to low for the opponent enterprise, risk classification, asset holding bin and associated securities, so as to generate the first link related to the association relationship of the opponent enterprise.
The update rule obtaining module 102 is configured to obtain metadata to be updated in the metadata set according to an update task request when the update task request of the metadata set is received, and obtain an update rule of the metadata to be updated.
In the embodiment of the invention, the metadata to be updated refers to part of data with real-time variation in the metadata set caused by the update task request of the metadata set.
For example, the metadata set is related information of risk classification of opponent enterprises in the investment field, if there is a change in risk classification of one or more opponent enterprises due to market change in 1000 opponent enterprises of existing transactions, the opponent enterprises with the risk classification change need to be updated in time due to the change in the risk classification, and all risk classes and factors and calculation results of policy analysis calculation are immediately adjusted according to the opponent enterprises with the risk classification change, and the adjusted risk classes and calculation factors and calculation results of policy analysis are metadata to be updated.
In the embodiment of the present invention, the received data update task request may be an update task request instruction sent by a user.
In the embodiment of the present invention, the update rule refers to a rule constructed according to a preset update mode and a preset update logic, and the update of the data to be updated subsequently can be achieved through the preset update mode and the update logic.
In detail, the update rule obtaining module 102 obtains the update rule of the metadata to be updated by performing the following operations, including:
constructing an updating mode of the metadata to be updated and updating logic of the metadata to be updated;
And obtaining the update rule according to the update mode and the update logic.
Specifically, if the metadata to be updated is data in the database, a preset structured query language (Structured Query Language, SQL) may be used as an update mode of the metadata to be updated, and according to an update logic that establishes a new table first and then performs data filtering, a subsequent update operation of the data to be updated is implemented.
The data backtracking module 103 is configured to perform data backtracking on the metadata set in the data link graph, and search the metadata position of the metadata to be updated in the data link graph in the data backtracking process.
In the embodiment of the invention, the update task request is a task for triggering data update, the task can be divided into a plurality of subtasks, for example, the update task request can be index calculation of interest rate and risk value of the fixed-receiving asset, and the subtasks can be daily gain rate, scale and interest rate type calculation tasks and risk summary calculation tasks of a plurality of assets.
In the embodiment of the invention, the task is split into a plurality of subtasks, so that the problem that the whole task is failed to update due to abnormal subtask update in the subsequent update process can be avoided, the plurality of subtasks can be executed in parallel, and the subsequent data update efficiency is improved.
In detail, the data backtracking module 103 performs data backtracking on the metadata set in the data link graph by performing the following operations, and searches the metadata position of the metadata to be updated in the data link graph during the data backtracking process, including:
Traversing the data link diagram to obtain metadata corresponding to each node in the data link diagram and an upstream-downstream relationship between metadata in the metadata set;
splitting the metadata update task request into a plurality of subtasks, and storing the subtasks into a preset message middleware;
And executing a plurality of subtasks by using the message middleware, and searching metadata positions of metadata to be updated, which are related to the subtasks, in the data link diagram from upstream and downstream relations among metadata in the metadata set.
In the embodiment of the invention, the update task request of the metadata is split into a plurality of subtasks, the subtasks are stored in the preset message middleware, the plurality of subtasks are asynchronously processed, and the task processing efficiency is improved.
Preferably, the message middleware may be kafka.
In another embodiment of the present invention, traversing the data link graph is to trace back data of the metadata set connection graph, so as to obtain metadata corresponding to each node in the graph and an upstream-downstream relationship between metadata in the metadata set.
In another embodiment of the present invention, data backtracking of the metadata set may be performed based on a date dimension of the metadata set, and a date range of data that affects between metadata in the metadata set may be more accurately determined.
For example, in the investment field, there are an investment data topic, a plurality of competing subjects and attribute sets corresponding to the topic, the investment subject is an energy electric box investment bid, the subjects participating in the investment are a plurality of competing enterprises, the attributes corresponding to the subjects are securities and asset holding bins, each subject has a date diffusion rule by determining date access, such as the accumulation of income of competing enterprises, the accumulation of selling, the accumulation attribute needs to be expanded to YTD (to date today), the date range of part of securities needs to be expanded to the specific buying date, the secondary buying date, the expiration date and the like, so that data backtracking is performed according to the date dimension, and the accuracy and efficiency of the data backtracking can be improved.
The data updating module 104 is configured to update the metadata to be updated according to the metadata location by using the update rule.
In this embodiment, after updating the metadata to be updated using the update rule, the update metadata may be directly obtained from the metadata location.
In the embodiment of the invention, the metadata to be updated can be accessed by a preset task scheduling platform aiming at different data layering of real-time variation, and the updating rule is utilized to update the metadata to be updated, so that the timeliness of data updating is ensured.
In the embodiment of the invention, after the metadata to be updated are updated by utilizing the updating rule, the metadata to be updated are subjected to regular feedback heartbeat, the updating progress is recorded, the updated metadata are identified again by adopting a preset optimistic lock, the updated metadata are transmitted to a judging pool of the optimistic lock, and if the updated metadata are overlapped, the overlapped updated metadata are modified or deleted, so that the accuracy of the updated metadata is ensured.
The data update module 104 may be configured to:
acquiring a current version of metadata to be updated and a target updated version of the updated metadata, and judging whether the current version is consistent with the target updated version or not by utilizing a preset optimistic lock;
if the current version is inconsistent with the target updated version, determining that the data update fails;
and if the current version is consistent with the target updated version, determining that the data update is successful.
In the embodiment of the invention, the current version of the metadata to be updated is the updated metadata obtained from the metadata position.
In an embodiment of the invention, an optimistic lock is adopted to judge whether the current version and the updated version of the metadata to be updated are consistent, thereby ensuring whether the data update is realized or not, and ensuring that the metadata to be updated with overlapping data do not appear repeatedly.
For example, the metadata to be updated is 100 elements of the current account balance, and the current version is 1; there are two data update tasks, a and B, the a task is to deduct 30 the current account balance, the B task is to deduct 40 the current account balance; when the task A is executed, the current version is 1, the account balance is updated to 70, the target updated version in the data returned after the task A is updated is 2, and the data is updated to 70; when the task B is executed, the read current version is 1 and the account balance is updated to 60, but the task B fails to update, and the version at the moment is changed to 2 as the task A completes the current version, and the version is not matched, so that the task B fails to update data, and the metadata to be updated is ensured not to have repeated problems when being updated.
The data update module 104 may be further configured to:
Creating a preset window, and identifying whether the update metadata is matched with a corresponding update task request or not from the preset window, wherein the update task request comprises a plurality of subtasks;
If the update metadata is matched with the corresponding update task request, maintaining an update state;
and if the update metadata is not matched with the corresponding update task request, retransmitting the subtasks with the abnormality in the update task request to a preset message middleware to trigger the data update to be carried out again.
In another embodiment of the present invention, the update task request may be an index calculation of the interest rate risk value of the fixed asset, the subtask may be a daily gain rate, a scale, an interest rate type calculation task and a risk summary calculation task of a plurality of assets, and when an update abnormality occurs in a subtask, the subtask may be transmitted to the message middleware for updating again to achieve final data update.
In the embodiment of the invention, firstly, a metadata set is obtained, a data link diagram of the metadata set from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform is constructed according to the association relation between metadata in the metadata set, the association relation between metadata in the metadata set can be displayed more clearly, and the consistency of the metadata set storage can be ensured from the original data layer of the preset data warehouse platform to the data mart layer of the data warehouse platform; secondly, when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated, wherein subsequent update of the metadata to be updated can be realized according to the update rule; and finally, carrying out data backtracking on the metadata set in the data link diagram, searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process, obtaining the upstream and downstream relation between the metadata in the metadata set through the data backtracking, determining the position of the metadata to be updated more accurately, updating the metadata to be updated according to the metadata position by utilizing the updating rule, updating the metadata to be updated more efficiently, timely and accurately, obtaining the updated metadata, and improving the data updating efficiency and accuracy. Therefore, the data updating device provided by the invention can improve the efficiency and the accuracy of data updating.
Fig. 3 is a schematic structural diagram of an electronic device for implementing a data updating method according to an embodiment of the present invention.
The electronic device 1 may comprise a processor 10, a memory 11, a communication bus 12 and a communication interface 13, and may further comprise a computer program, such as a data update program, stored in the memory 11 and executable on the processor 10.
The processor 10 may be formed by an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or may be formed by a plurality of integrated circuits packaged with the same function or different functions, including one or more central processing units (Central Processing unit, CPU), microprocessors, digital processing chips, graphics processors, and combinations of various control chips. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects various components of the entire electronic device using various interfaces and lines, and executes various functions of the electronic device and processes data by running or executing programs or modules (e.g., executing a data update program, etc.) stored in the memory 11, and calling data stored in the memory 11.
The memory 11 includes at least one type of readable storage medium including flash memory, a removable hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the electronic device, such as a mobile hard disk of the electronic device. The memory 11 may also be an external storage device of the electronic device in other embodiments, such as a plug-in mobile hard disk, a smart memory card (SMART MEDIA CARD, SMC), a Secure Digital (SD) card, a flash memory card (FLASH CARD) or the like, which are provided on the electronic device. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic device. The memory 11 may be used not only for storing application software installed in an electronic device and various types of data, such as codes of a data update program, but also for temporarily storing data that has been output or is to be output.
The communication bus 12 may be a peripheral component interconnect standard (PERIPHERAL COMPONENT INTERCONNECT, PCI) bus, or an extended industry standard architecture (extended industry standard architecture, EISA) bus, among others. The bus may be classified as an address bus, a data bus, a control bus, etc. The bus is arranged to enable a connection communication between the memory 11 and at least one processor 10 etc.
The communication interface 13 is used for communication between the electronic device and other devices, including a network interface and a user interface. Optionally, the network interface may include a wired interface and/or a wireless interface (e.g., WI-FI interface, bluetooth interface, etc.), typically used to establish a communication connection between the electronic device and other electronic devices. The user interface may be a Display (Display), an input unit such as a Keyboard (Keyboard), or alternatively a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch, or the like. The display may also be referred to as a display screen or display unit, as appropriate, for displaying information processed in the electronic device and for displaying a visual user interface.
Only an electronic device having components is shown, and it will be understood by those skilled in the art that the structures shown in the figures do not limit the electronic device, and may include fewer or more components than shown, or may combine certain components, or a different arrangement of components.
For example, although not shown, the electronic device may further include a power source (such as a battery) for supplying power to the respective components, and preferably, the power source may be logically connected to the at least one processor 10 through a power management device, so that functions of charge management, discharge management, power consumption management, and the like are implemented through the power management device. The power supply may also include one or more of any of a direct current or alternating current power supply, recharging device, power failure detection circuit, power converter or inverter, power status indicator, etc. The electronic device may further include various sensors, bluetooth modules, wi-Fi modules, etc., which are not described herein.
It should be understood that the embodiments described are for illustrative purposes only and are not limited to this configuration in the scope of the patent application.
The data update program stored in the memory 11 in the electronic device 1 is a combination of instructions that, when executed in the processor 10, may implement:
Acquiring a metadata set, and constructing a data link diagram of the metadata set, which is stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform, according to the association relation between metadata in the metadata set;
when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated;
performing data backtracking on the metadata set in the data link diagram, and searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process;
and updating the metadata to be updated by utilizing the updating rule according to the metadata position.
In particular, the specific implementation method of the above instructions by the processor 10 may refer to the description of the relevant steps in the corresponding embodiment of the drawings, which is not repeated herein.
Further, the modules/units integrated in the electronic device 1 may be stored in a computer readable storage medium if implemented in the form of software functional units and sold or used as separate products. The computer readable storage medium may be volatile or nonvolatile. For example, the computer readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM).
The present invention also provides a computer readable storage medium storing a computer program which, when executed by a processor of an electronic device, can implement:
Acquiring a metadata set, and constructing a data link diagram of the metadata set, which is stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform, according to the association relation between metadata in the metadata set;
when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated;
performing data backtracking on the metadata set in the data link diagram, and searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process;
and updating the metadata to be updated by utilizing the updating rule according to the metadata position.
In the several embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is merely a logical function division, and there may be other manners of division when actually implemented.
The modules described as separate components may or may not be physically separate, and components shown as modules may or may not be physical units, may be located in one place, or may be distributed over multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional module in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units can be realized in a form of hardware or a form of hardware and a form of software functional modules.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential characteristics thereof.
The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
The blockchain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, encryption algorithm and the like. The blockchain (Blockchain), essentially a de-centralized database, is a string of data blocks that are generated in association using cryptographic methods, each of which contains information from a batch of network transactions for verifying the validity (anti-counterfeit) of its information and generating the next block. The blockchain may include a blockchain underlying platform, a platform product services layer, an application services layer, and the like.
The embodiment of the application can acquire and process the related data based on the artificial intelligence technology. Wherein artificial intelligence (ARTIFICIAL INTELLIGENCE, AI) is the theory, method, technique, and application system that uses a digital computer or a digital computer-controlled machine to simulate, extend, and expand human intelligence, sense the environment, acquire knowledge, and use knowledge to obtain optimal results.
Furthermore, it is evident that the word "comprising" does not exclude other elements or steps, and that the singular does not exclude a plurality. A plurality of units or means recited in the system claims can also be implemented by means of software or hardware by means of one unit or means. The terms first, second, etc. are used to denote a name, but not any particular order.
Finally, it should be noted that the above-mentioned embodiments are merely for illustrating the technical solution of the present invention and not for limiting the same, and although the present invention has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications and equivalents may be made to the technical solution of the present invention without departing from the spirit and scope of the technical solution of the present invention.
Claims (7)
1. A method of data updating, the method comprising:
Acquiring a metadata set, and constructing a data link diagram of the metadata set, which is stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform, according to the association relation between metadata in the metadata set;
when an update task request of the metadata set is received, acquiring metadata to be updated in the metadata set according to the update task request, and acquiring an update rule of the metadata to be updated;
performing data backtracking on the metadata set in the data link diagram, and searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process;
updating the metadata to be updated by using the updating rule according to the metadata position;
The construction of the data link diagram of the metadata set from the original data layer of the preset data warehouse platform to the data mart layer of the data warehouse platform according to the association relation between metadata in the metadata set comprises the following steps: constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to the association relation between metadata in the metadata set; extracting a deep association relation of the metadata set through the first link, and constructing a data link diagram of the metadata set, which is stored from a data warehouse layer of the data warehouse platform to a data mart layer of the data warehouse platform, according to the deep association relation;
The constructing a first link of the metadata set from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform according to the association relation between metadata in the metadata set, includes: extracting a plurality of identifiers corresponding to a plurality of metadata in the metadata set, and generating a plurality of initial nodes of the identifiers; connecting a plurality of initial nodes according to the association relation, and generating a first link of the metadata set, wherein the first link is stored from an original data layer of a preset data warehouse platform to a data warehouse layer of the data warehouse platform;
And performing data backtracking on the metadata set in the data link graph, and searching the metadata position of the metadata to be updated in the data link graph in the data backtracking process, wherein the method comprises the following steps: traversing the data link diagram to obtain metadata corresponding to each node in the data link diagram and an upstream-downstream relationship between metadata in the metadata set; splitting the metadata update task request into a plurality of subtasks, and storing the subtasks into a preset message middleware; and executing a plurality of subtasks by using the message middleware, and searching metadata positions of metadata to be updated, which are related to the subtasks, in the data link diagram from upstream and downstream relations among metadata in the metadata set.
2. The data updating method according to claim 1, wherein after the updating of the metadata to be updated using the updating rule, the method further comprises:
Acquiring a current version of metadata to be updated and a target updated version of the metadata to be updated, and judging whether the current version is consistent with the target updated version or not by utilizing a preset optimistic lock;
if the current version is inconsistent with the target updated version, determining that the data update fails;
and if the current version is consistent with the target updated version, determining that the data update is successful.
3. The data updating method according to claim 1, wherein after the updating of the metadata to be updated using the updating rule, the method further comprises:
Creating a preset window, and identifying whether the update metadata is matched with a corresponding update task request or not from the preset window, wherein the update task request comprises a plurality of subtasks;
If the update metadata is matched with the corresponding update task request, maintaining an update state;
and if the update metadata is not matched with the corresponding update task request, retransmitting the subtasks with the abnormality in the update task request to a preset message middleware to trigger the data update to be carried out again.
4. The data updating method according to claim 1, wherein after the acquisition of the metadata set, the method further comprises:
and performing data cleaning processing on the metadata set by using a preset data warehouse layer, wherein the data cleaning processing comprises data outlier operation and data missing value filling operation.
5. A data updating apparatus for implementing the data updating method according to any one of claims 1 to 4, characterized in that the apparatus comprises:
The data link diagram construction module is used for acquiring a metadata set, and constructing a data link diagram of the metadata set, which is stored from an original data layer of a preset data warehouse platform to a data mart layer of the data warehouse platform, according to the association relation between metadata in the metadata set;
The updating rule acquisition module is used for acquiring metadata to be updated in the metadata set according to the updating task request when the updating task request of the metadata set is received, and acquiring the updating rule of the metadata to be updated;
the data backtracking module is used for carrying out data backtracking on the metadata set in the data link diagram, and searching the metadata position of the metadata to be updated in the data link diagram in the data backtracking process;
and the data updating module is used for updating the metadata to be updated by utilizing the updating rule according to the metadata position.
6. An electronic device, the electronic device comprising:
at least one processor; and
A memory communicatively coupled to the at least one processor; wherein,
The memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data updating method according to any one of claims 1 to 4.
7. A computer readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the data updating method according to any one of claims 1 to 4.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111525945.1A CN114036174B (en) | 2021-12-14 | 2021-12-14 | Data updating method, device, equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111525945.1A CN114036174B (en) | 2021-12-14 | 2021-12-14 | Data updating method, device, equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN114036174A CN114036174A (en) | 2022-02-11 |
CN114036174B true CN114036174B (en) | 2024-06-25 |
Family
ID=80140644
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111525945.1A Active CN114036174B (en) | 2021-12-14 | 2021-12-14 | Data updating method, device, equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114036174B (en) |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108089871A (en) * | 2017-12-04 | 2018-05-29 | 广州华旻信息科技有限公司 | Automatic updating method of software, device, equipment and storage medium |
CN109117152A (en) * | 2018-07-26 | 2019-01-01 | 新华三大数据技术有限公司 | Service creation system and method |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US10831831B2 (en) * | 2018-03-29 | 2020-11-10 | Oracle International Corporation | Hierarchical metadata model querying system |
CN109635011B (en) * | 2018-10-31 | 2022-05-03 | 北京辰森世纪科技股份有限公司 | Multi-level header report processing method, device and equipment based on service metadata |
CN111143113B (en) * | 2018-11-02 | 2023-07-07 | 伊姆西Ip控股有限责任公司 | Method, electronic device and computer program product for copying metadata |
CN112445875B (en) * | 2020-12-14 | 2024-03-01 | 招商局金融科技有限公司 | Data association and verification method and device, electronic equipment and storage medium |
-
2021
- 2021-12-14 CN CN202111525945.1A patent/CN114036174B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108089871A (en) * | 2017-12-04 | 2018-05-29 | 广州华旻信息科技有限公司 | Automatic updating method of software, device, equipment and storage medium |
CN109117152A (en) * | 2018-07-26 | 2019-01-01 | 新华三大数据技术有限公司 | Service creation system and method |
Also Published As
Publication number | Publication date |
---|---|
CN114036174A (en) | 2022-02-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20190340518A1 (en) | Systems and methods for enriching modeling tools and infrastructure with semantics | |
CN112445854B (en) | Multi-source service data real-time processing method, device, terminal and storage medium | |
CN107123047B (en) | Data acquisition system based on bond transaction and data acquisition method thereof | |
CN111339073A (en) | Real-time data processing method and device, electronic equipment and readable storage medium | |
CN113946690A (en) | Potential customer mining method and device, electronic equipment and storage medium | |
CN114840531B (en) | Data model reconstruction method, device, equipment and medium based on blood edge relation | |
CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
CN112699142A (en) | Cold and hot data processing method and device, electronic equipment and storage medium | |
CN117193975A (en) | Task scheduling method, device, equipment and storage medium | |
CN114612194A (en) | Product recommendation method and device, electronic equipment and storage medium | |
US8688499B1 (en) | System and method for generating business process models from mapped time sequenced operational and transaction data | |
CN114036174B (en) | Data updating method, device, equipment and storage medium | |
CN115759746A (en) | Configurable user early warning method and device, electronic equipment and storage medium | |
CN115062023A (en) | Wide table optimization method and device, electronic equipment and computer readable storage medium | |
CN115168509A (en) | Processing method and device of wind control data, storage medium and computer equipment | |
CN114490137A (en) | Service data real-time statistical method and device, electronic equipment and readable storage medium | |
US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model | |
CN114518993A (en) | System performance monitoring method, device, equipment and medium based on business characteristics | |
CN114510400A (en) | Task execution method and device, electronic equipment and storage medium | |
CN113657546A (en) | Information classification method and device, electronic equipment and readable storage medium | |
CN114912818B (en) | Asset index analysis method, device, equipment and storage medium | |
CN114819590B (en) | Policy intelligent recommendation method, device, equipment and storage medium | |
CN117216339B (en) | Digital twinning-based electronic sand table system construction method and device | |
CN117971606B (en) | Log management system and method based on elastic search | |
CN112561368B (en) | Visual performance calculation method and device for OA approval system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |