CN116644067A - Method and related device for determining change content of data warehouse supervision message - Google Patents
Method and related device for determining change content of data warehouse supervision message Download PDFInfo
- Publication number
- CN116644067A CN116644067A CN202310622644.3A CN202310622644A CN116644067A CN 116644067 A CN116644067 A CN 116644067A CN 202310622644 A CN202310622644 A CN 202310622644A CN 116644067 A CN116644067 A CN 116644067A
- Authority
- CN
- China
- Prior art keywords
- change
- source system
- data
- supervision message
- content
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000008859 change Effects 0.000 title claims abstract description 214
- 238000000034 method Methods 0.000 title claims abstract description 70
- 238000012545 processing Methods 0.000 claims abstract description 61
- 230000008569 process Effects 0.000 claims abstract description 22
- 239000008280 blood Substances 0.000 claims abstract description 15
- 210000004369 blood Anatomy 0.000 claims abstract description 15
- 238000013507 mapping Methods 0.000 claims description 25
- 238000007726 management method Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 230000001419 dependent effect Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000012550 audit Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000003139 buffering effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013506 data mapping Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 238000007781 pre-processing Methods 0.000 description 1
- 230000000750 progressive 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L49/00—Packet switching elements
- H04L49/10—Packet switching elements characterised by the switching fabric construction
- H04L49/111—Switch interfaces, e.g. port details
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L49/00—Packet switching elements
- H04L49/15—Interconnection of switching modules
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a method and a related device for determining the change content of a data warehouse supervision message, which can be applied to the field of big data or the field of finance. The method comprises the steps of firstly obtaining change information of a source system table, and then determining the change content of an interface table based on the change information of the source system table and the data blood relationship from the source system table to the interface table. In this way, the influence of the change information of the source system table on the interface table of the data processing result can be determined. And finally, determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document for guiding the generation of the supervision message based on the interface table. Therefore, the influence of the structural change of the source system table on the supervision messages can be rapidly determined, and workers can conveniently and timely adjust the data processing process of the data warehouse or the generation process of the supervision messages based on the change content of the supervision messages.
Description
Technical Field
The application relates to the field of big data, in particular to a method and a related device for determining the change content of a data warehouse supervision message.
Background
The data warehouse is used for sorting massive big data to generate a data table so as to facilitate downstream system call. The data warehouse can acquire the data table of the source system, and sequentially processes the data through the included layers to finally obtain the data table which can be called by other application programs. And the data warehouse generates a supervision message according to the data table which can be called by the downstream system. The data warehouse sends the supervision messages to the downstream system so that the downstream system can determine the processing condition of the data based on the supervision messages.
When the structure of the data table of the source system is changed, the accuracy of the generated supervision messages can be affected, and even the supervision messages cannot be normally generated. Currently, it is difficult for a worker to quickly determine the impact of a structural change in the data table of the source system on the supervision messages.
Disclosure of Invention
In view of the above, the present application provides a method and related apparatus for determining the change content of a supervision message in a data warehouse, which can quickly determine the influence of the structural change of a data table of a source system on the supervision message.
In order to solve the problems, the technical scheme provided by the application is as follows:
in a first aspect, the present application provides a method for determining change content of a supervision message of a data warehouse, where the data warehouse is configured to process a source system table into an interface table through a plurality of included levels, where the source system table is a data table provided by a source system, and the interface table is a data table provided by the data warehouse to a downstream system, and the method includes:
acquiring change information of a source system table;
determining interface table change content based on the change information of the source system table and the data blood relationship from the source system table to the interface table;
and determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document, wherein the restoration caliber document is used for indicating the generation of the supervision message based on the interface table.
In one possible implementation manner, the restoration caliber document includes a correspondence between the interface table and the supervision message and a correspondence between a field included in the interface table and a field of the supervision message, and determining, according to the content of the interface table change and the restoration caliber document, a change content of the supervision message includes:
determining a target supervision message corresponding to the interface table change content according to the interface table to which the interface table change content belongs and the restoration caliber document;
and determining a change field included in a target supervision message corresponding to the field of the interface table according to the field of the interface table related to the change content of the interface table and the restoration caliber document.
In one possible implementation, the method further includes:
and processing the change content of the supervision message.
In one possible implementation manner, the change information of the source system table is a table offline or a field offline, and the processing the change content of the supervision packet includes:
and displaying the offline reminding information of the change content of the supervision message.
In one possible implementation manner, the change information of the source system table is a table change or a field change, and the processing the change content of the supervision packet includes:
and changing configuration files of layers corresponding to the data blood-edge relation from the source system table to the interface table, wherein the configuration files are used for generating a data table of the layers included in the data blood-edge relation from the source system table to the interface table.
In one possible implementation manner, the change information of the source system table is a code value change, and the processing the change content of the supervision packet includes:
and changing the mapping relation between the code value included in the code value mapping table and the target content, or changing the mapping relation between the code value included in the restoration caliber document and the target content.
In one possible implementation, the method further includes:
and displaying a processing result of processing the changed content of the supervision message.
In a second aspect, the present application provides a device for determining content of a change in a supervision message of a data warehouse, where the data warehouse is configured to process a source system table into an interface table through a plurality of layers, where the source system table is a data table provided by a source system, and the interface table is a data table provided by the data warehouse to a downstream system, and the device includes:
the acquisition unit is used for acquiring the change information of the source system table;
a first determining unit, configured to determine an interface table change content based on change information of the source system table and a data blood-edge relationship from the source system table to the interface table;
and the second determining unit is used for determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document, wherein the restoration caliber document is used for indicating the generation of the supervision message based on the interface table.
In a possible implementation manner, the restoration caliber document includes a correspondence between the interface table and the supervision message and a correspondence between a field included in the interface table and a field of the supervision message, and the second determining unit is specifically configured to determine, according to the interface table to which the interface table change content belongs and the restoration caliber document, a target supervision message corresponding to the interface table change content; and determining a change field included in a target supervision message corresponding to the field of the interface table according to the field of the interface table related to the change content of the interface table and the restoration caliber document.
In one possible implementation, the apparatus further includes:
and the processing unit is used for processing the change content of the supervision message.
In one possible implementation manner, the change information of the source system table is a table offline or a field offline, and the processing unit is specifically configured to display offline reminder information of the change content of the supervision packet.
In a possible implementation manner, the change information of the source system table is table change or field change, and the processing unit is specifically configured to change configuration files of each layer corresponding to the data blood edge relationship from the source system table to the interface table, where the configuration files are used to generate a data table of a layer included in the data blood edge relationship from the source system table to the interface table.
In one possible implementation manner, the change information of the source system table is code value change, and the processing unit is specifically configured to change a mapping relationship between a code value included in a code value mapping table and target content, or a mapping relationship between a code value included in the restored caliber document and target content.
In one possible implementation, the apparatus further includes:
and the display unit is used for displaying the processing result of the change content of the supervision message.
In a third aspect, the present application provides a device for determining changed content of a data warehouse supervision packet, including: a processor, memory, system bus;
the processor and the memory are connected through the system bus;
the memory is configured to store one or more programs, the one or more programs comprising instructions, which when executed by the processor, cause the processor to perform the method of any of the embodiments of the first aspect described above.
In a fourth aspect, the present application provides a computer readable storage medium having instructions stored therein, which when run on a terminal device, cause the terminal device to perform the method according to any of the embodiments of the first aspect.
From this, the application has the following beneficial effects:
the method and the related device for determining the change content of the data warehouse supervision message firstly acquire the change information of the source system table, and then determine the change content of the interface table based on the change information of the source system table and the data blood-edge relationship from the source system table to the interface table. In this way, the influence of the change information of the source system table on the interface table of the data processing result can be determined. And finally, determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document for guiding the generation of the supervision message based on the interface table. Therefore, the influence of the structural change of the source system table on the supervision messages can be rapidly determined, and workers can conveniently and timely adjust the data processing process of the data warehouse or the generation process of the supervision messages based on the change content of the supervision messages.
Drawings
FIG. 1 is a schematic diagram of a TMCEA layer data warehouse according to an embodiment of the present application;
fig. 2 is a flow chart of a method for determining change content of a supervision packet of a data warehouse according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of a device for determining a change content of a supervision packet in a data warehouse according to an embodiment of the present application.
Detailed Description
In order to facilitate understanding and explanation of the technical solutions provided by the embodiments of the present application, the following description will first explain the background art of the present application.
First, a description is given of the data warehouse.
A data warehouse, which may also be referred to as a data warehouse system, may be referred to simply as a bin. A data warehouse is a strategic collection that provides all types of data support for all levels of decision-making processes for an enterprise.
PDM, physical data model documents (Physical Data Model, PDM), provide the basic elements required for the initial design of the data warehouse, and relationships between related elements. The PDM belongs to the configuration file of the data warehouse.
SDM, data source map document (Source Data Mapping, SDM), provide the source of data and specific data processing means that the PDM document includes. Each layer of the data warehouse has a corresponding SDM. SDM belongs to the configuration file of the data warehouse.
TMCEA layer, a data warehouse layered architecture. Referring to FIG. 1, a schematic diagram of a TMCEA layer data warehouse is provided in an embodiment of the present application. As shown in fig. 1, the data warehouse includes a technology buffer layer (T layer), an integration model layer (M layer), a commonality processing layer (C layer), an application computing layer (E layer), and an application interface layer (a layer). The data warehouse is built in layers in this order. The data of the source system is processed from the T layer, sequentially passes through the M layer and the C layer until the A layer. In addition to the T layer, the data may be cross-layer dependent and co-layer dependent, that is, may be capable of subsequent data processing according to data obtained by cross-layer processing or data obtained by co-layer processing.
The function of each layer is described below.
The layer a is used for providing personalized data service for each application scene, and as shown in fig. 1, the layer a can provide various application services including fixed report forms, management driving cabins, large and small screens and line signs.
The E layer is used for the general derivative calculation of each business data, and as shown in fig. 1, the E layer is used for providing common calculation in the aspects of operation analysis, financial management, risk management, operation management, supervision audit and the like.
The layer C is used for data preprocessing and common information processing, as shown in fig. 1, and is used for providing common details of various services such as clients, channels, finance, risks, public, deposit services, loan services, credit cards, investment financing, cash management, bill services, trade financing, payment settlement, guarantee commitment, agency services, administration services, capital investment, and hosting services.
The M layer is used for data hosting and standard normalization, and as shown in fig. 1, the M layer is used for providing various topic data such as participants, contracts, products, events, resource items, business directions, regions, classifications, conditions, and the like.
The T layer is used for collecting and warehousing the source system and the external data, and as shown in fig. 1, the T layer is used for collecting and buffering data from a service system, a management system, the external data and other systems and entering the data warehouse system.
The workflow configuration and the data warehouse processing are performed according to the sequence of the workflow configuration, and an arbitrary hierarchy model workflow can only start to run when the front workflow is processed.
When the structure of the data table of the source system of the data warehouse changes, the data processing of each layer of the data warehouse may be affected, so that the data table generated by the data warehouse and provided for the downstream system is affected, and finally, the supervision message generated based on the data table provided for the downstream system is affected. The extent and scope of influence of changes in the structure of the data table of the source system on the supervision messages is not fixed. Changes in the structure of the data table of the source system may cause inaccuracy of some fields of the supervision message, and may also cause failure to generate the supervision message. Under the condition that the influence of the change on the supervision messages occurs in the structure of the data table of the source system, workers are difficult to quickly process the data processing process of the data warehouse, and normal generation of the supervision messages is resumed.
Based on the above, the embodiment of the application provides a method and a related device for determining the change content of a data warehouse supervision message, which are used for firstly acquiring the change information of a source system table and then determining the change content of an interface table based on the change information of the source system table and the data blood relationship from the source system table to the interface table. In this way, the influence of the change information of the source system table on the interface table of the data processing result can be determined. And finally, determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document for guiding the generation of the supervision message based on the interface table. Therefore, the influence of the structural change of the source system table on the supervision messages can be rapidly determined, and workers can conveniently and timely adjust the data processing process of the data warehouse or the generation process of the supervision messages based on the change content of the supervision messages.
In order to facilitate understanding of the technical solution provided by the embodiments of the present application, a method for determining the change content of the data warehouse supervision message and a related device provided by the embodiments of the present application are described below with reference to the accompanying drawings.
Firstly, it should be noted that the method for determining the change content of the data warehouse supervision message provided by the embodiment of the application can be applied to a data warehouse management system or other systems for managing a data warehouse.
The method and the related device for determining the change content of the data warehouse supervision message can be used in the big data field or the financial field. The foregoing is merely an example, and the application fields of the method for determining the change content of the data warehouse supervision message and the related device provided by the present application are not limited.
Referring to fig. 2, the flow chart of a method for determining the change content of a supervision message of a data warehouse according to an embodiment of the present application is shown. As shown in fig. 2, a method for determining change content of a data warehouse supervision packet according to an embodiment of the present application includes S201 to S203.
S201: and acquiring change information of the source system table.
The source system table is a data table provided by the source system. The data warehouse processes data included in the source system table. The change information of the source system table is information of the change content of the source system table. The change information of the source system table includes the table change type and the changed contents. The table change type is, for example, one or more of table down, field down, table change, field change, and code value change.
The embodiment of the application is not limited to a specific implementation mode for acquiring the change information of the source system table. As one example, change information of the source system table is entered by a worker. As another example, the source system tables before and after the change are acquired, and the change information of the source system tables is acquired by comparing the source system tables before and after the change.
S202: and determining the change content of the interface table based on the change information of the source system table and the data blood relationship from the source system table to the interface table.
The interface table is a data table provided by the data warehouse to the downstream system, and is a result obtained after the data are processed. It should be noted that the embodiment of the present application is not limited to the layer generating the interface table, and is specifically determined based on the requirement of data processing. Taking the structure of the data warehouse shown in fig. 1 as an example, the interface table can be a data table generated by a C layer, an E layer, an a layer, and an M layer.
The data blood relationship from the source system table to the interface table is the relationship between data in the data processing process from the source system table to the interface table. In one possible implementation, the data lineage relationships of the source system table to the interface table can be determined based on a profile of each layer in the data warehouse. For example, SDM of each layer defines the source of the data and the manner of processing. According to the SDM of each layer, the processing mode of the data in the layer can be determined, and the processed data can be obtained. Based on the data blood relationship from the source system table to the interface table, the data processing process of the data of the source system table through the data warehouse can be determined, and the data related to the data of the source system table can be determined.
Based on the data blood relationship from the source system table to the interface table, the data related to the change information of the source system table can be determined, and the change content of the interface table can be determined. The interface table change content is the content of the change in the interface table related to the change information of the source system table. The interface table change content includes, for example, one or more of a data value change, a field change, a data offline, a field offline, an interface table offline, and a code value change.
S203: and determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document.
The restoration caliber document is used for guiding generation of the supervision message based on the interface table. The desirors of the downstream system provide the original caliber. The original caliber is processed by data by using a source system table. But as the data of each layer is processed, the names of the data tables and the fields of the data tables change. The data warehouse needs to guide the demander of the downstream system to re-write the path based on the name of the interface table obtained after the data processing and the fields of the interface table. The document used for guidance is a restored caliber document. After the change content of the interface table is determined, the change content of the supervision message corresponding to the change content of the interface table can be determined according to the restoration caliber document. For example, the interface table change content is interface table offline. According to the restoration caliber document, the supervision message which needs to be offline, namely the change content of the supervision message, can be determined.
In one possible implementation, the restoration aperture document includes a correspondence between the interface table and the supervision message and a correspondence between fields included in the interface table and fields of the supervision message. The embodiment of the application provides a concrete implementation mode for determining the change content of a supervision message according to the change content of the interface table and the restoration caliber document, which comprises the following two steps:
a1: and determining a target supervision message corresponding to the interface table change content according to the interface table to which the interface table change content belongs and the restoration caliber document.
The restoration caliber document comprises the corresponding relation between the interface table and the supervision message. The method comprises the steps of firstly determining a target supervision message of which the content needs to be changed based on an interface table of which the content is changed according to the interface table and the corresponding relation between the interface table and the supervision message.
A2: and determining a change field included in a target supervision message corresponding to the field of the interface table according to the field of the interface table related to the change content of the interface table and the restoration caliber document.
After the target supervision message is determined, determining the change field included in the target supervision message according to the field of the interface table related to the change content of the interface table and the corresponding relation between the field included in the interface table and the field of the supervision message.
Based on the above-mentioned related contents of S201-S203, the change content of the supervision message corresponding to the change content of the source system table can be determined more accurately by using the data blood relationship from the source system table to the interface table and the restoration caliber document. Therefore, the staff can conveniently adjust the supervision messages based on the accurate change content of the supervision messages, and the influence of the change of the source system table on data processing is reduced.
In one possible implementation manner, after the change content of the supervision message is determined, the change content of the supervision message can be automatically processed, so that the efficiency of processing the change content of the supervision message is improved.
The following provides a specific implementation manner of processing the changing content of the supervision message corresponding to the changing information of three different source system tables.
First kind: the change information of the source system table is table offline or field offline.
The off-line table refers to the source system table deletion and is no longer used. The field offline refers to the deletion of the field included in the source system table and is not used any more. Correspondingly, the change content of the supervision message needs to be processed offline.
The embodiment of the application provides a concrete implementation mode for processing the change content of the supervision message, which comprises the following steps:
and displaying the offline reminding information of the change content of the supervision message.
The offline of the changed content of the supervision message needs to be processed by a worker, and the offline of the changed content of the supervision message may involve re-determining the caliber document and guiding the generation mode of the new supervision message. The offline reminding information is used for indicating the change content of the supervision message which needs to be subjected to offline processing. After checking the offline reminding information, a worker can process the change content of the supervision message which needs offline processing.
Second kind: the change information of the source system table is a table change or a field change.
Table modification refers to the need for modification of the contents of the source system table, such as the name of the table and the type of table. A field change refers to a field of the source system table that needs to be changed. The change content of the supervision message corresponding to the table change or the field change can be automatically adjusted.
The embodiment of the application provides a concrete implementation mode for processing the change content of the supervision message, which comprises the following steps:
and changing configuration files of layers corresponding to the data blood relationship from the source system table to the interface table.
The configuration file is used for generating a data table from the source system table to a layer included in the data blood relationship of the interface table. And changing configuration files of each layer, so as to adjust the processing process of each layer of data and further modify the changing content of the supervision message. Specifically, taking field name modification as an example, the field names in the configuration files of the layers of data processing involving the field are modified. Taking the data warehouse shown in fig. 1 as an example, the configuration file is SDM.
Third kind: the change information of the source system table is code value change.
The code value is a numerical value for representing the target content. For example, a code value of "1" indicates "northern area". The code value "2" indicates "southern area". A code value change refers to a change in the target content represented by the code value.
The embodiment of the application provides a concrete implementation mode for processing the change content of the supervision message, which comprises the following steps:
and changing a code value mapping table or a mapping relation between the code value included in the restoration caliber document and the target content.
The code value mapping table is used for storing the mapping relation between the standard code value and the target content. Under the condition that the standard code value needs to be changed, the mapping relation between the code value included in the code value mapping table and the target content is changed. Specifically, for example, when the code value is changed to the numerical value of the code value, the numerical value of the code value in the mapping relationship between the code value included in the code value mapping table and the target content is changed.
The restored caliber document also comprises a mapping relation between the code value and the target content. And restoring the mapping relation between the code value and the target content included in the caliber document, and guiding the conversion between the code value and the target content when the supervision message is generated. Under the condition that the nonstandard code value needs to be changed, the mapping relation between the code value included in the restored caliber document and the target content is adjusted, so that the code value and the target content are converted based on the adjusted mapping relation.
In some possible implementations, after the change content of the supervision message is processed, a processing result is also generated. The processing result comprises the changing content of the processed supervision message. For example, the processing results include one or more of fields of the modified supervision message, SDM, code value mapping table, and restored caliber document.
And displaying the processing result of the processing of the change content of the supervision message so that the staff can know the processing condition.
Based on the method for determining the change content of the data warehouse supervision message provided by the embodiment of the method, the embodiment of the application also provides a device for determining the change content of the data warehouse supervision message, and the device for determining the change content of the data warehouse supervision message is described below with reference to the accompanying drawings.
Referring to fig. 3, the diagram is a schematic structural diagram of a device for determining a change content of a supervision packet of a data warehouse according to an embodiment of the present application. As shown in fig. 3, the device for determining the change content of the data warehouse supervision message includes:
an obtaining unit 301, configured to obtain change information of a source system table;
a first determining unit 302, configured to determine an interface table change content based on change information of the source system table and a data blood-edge relationship from the source system table to the interface table;
and a second determining unit 303, configured to determine the change content of the supervision message according to the change content of the interface table and a restoration caliber document, where the restoration caliber document is used to instruct to generate the supervision message based on the interface table.
In a possible implementation manner, the restoration caliber document includes a correspondence between the interface table and the supervision message and a correspondence between a field included in the interface table and a field of the supervision message, and the second determining unit 303 is specifically configured to determine, according to the interface table to which the interface table change content belongs and the restoration caliber document, a target supervision message corresponding to the interface table change content; and determining a change field included in a target supervision message corresponding to the field of the interface table according to the field of the interface table related to the change content of the interface table and the restoration caliber document.
In one possible implementation, the apparatus further includes:
and the processing unit is used for processing the change content of the supervision message.
In one possible implementation manner, the change information of the source system table is a table offline or a field offline, and the processing unit is specifically configured to display offline reminder information of the change content of the supervision packet.
In a possible implementation manner, the change information of the source system table is table change or field change, and the processing unit is specifically configured to change configuration files of each layer corresponding to the data blood edge relationship from the source system table to the interface table, where the configuration files are used to generate a data table of a layer included in the data blood edge relationship from the source system table to the interface table.
In one possible implementation manner, the change information of the source system table is code value change, and the processing unit is specifically configured to change a mapping relationship between a code value included in a code value mapping table and target content, or a mapping relationship between a code value included in the restored caliber document and target content.
In one possible implementation, the apparatus further includes:
and the display unit is used for displaying the processing result of the change content of the supervision message.
Based on the method for determining the change content of the data warehouse supervision message provided by the embodiment of the method, the application provides a device for determining the change content of the data warehouse supervision message, which comprises the following steps: a processor, memory, system bus;
the processor and the memory are connected through the system bus;
the memory is configured to store one or more programs, the one or more programs comprising instructions, which when executed by the processor, cause the processor to perform the method for determining changed content of a data warehouse supervision message as described in any one of the embodiments above.
Based on the method for determining the change content of the data warehouse supervision message provided by the embodiment of the method, the application provides a computer readable storage medium, wherein the computer readable storage medium stores instructions, and when the instructions run on a terminal device, the terminal device is caused to execute the method for determining the change content of the data warehouse supervision message described in any embodiment.
It should be noted that, in the present description, each embodiment is described in a progressive manner, and each embodiment is mainly described in a different manner from other embodiments, and identical and similar parts between the embodiments are all enough to refer to each other. For the system or device disclosed in the embodiments, since it corresponds to the method disclosed in the embodiments, the description is relatively simple, and the relevant points refer to the description of the method section.
It should be understood that in the present application, "at least one (item)" means one or more, and "a plurality" means two or more. "and/or" for describing the association relationship of the association object, the representation may have three relationships, for example, "a and/or B" may represent: only a, only B and both a and B are present, wherein a, B may be singular or plural. The character "/" generally indicates that the context-dependent object is an "or" relationship. "at least one of" or the like means any combination of these items, including any combination of single item(s) or plural items(s). For example, at least one (one) of a, b or c may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
It is further noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. The software modules may be disposed in Random Access Memory (RAM), memory, read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A method for determining the contents of a change in a supervision message in a data warehouse, wherein the data warehouse is configured to process a source system table into an interface table through a plurality of levels, the source system table being a data table provided by a source system, and the interface table being a data table provided by the data warehouse to a downstream system, the method comprising:
acquiring change information of the source system table;
determining interface table change content based on the change information of the source system table and the data blood relationship from the source system table to the interface table;
and determining the change content of the supervision message according to the change content of the interface table and a restoration caliber document, wherein the restoration caliber document is used for indicating the generation of the supervision message based on the interface table.
2. The method according to claim 1, wherein the restoration caliber document includes a correspondence between the interface table and the supervision message and a correspondence between a field included in the interface table and a field of the supervision message, and the determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document includes:
determining a target supervision message corresponding to the interface table change content according to the interface table to which the interface table change content belongs and the restoration caliber document;
and determining a change field included in a target supervision message corresponding to the field of the interface table according to the field of the interface table related to the change content of the interface table and the restoration caliber document.
3. The method according to claim 1, wherein the method further comprises:
and processing the change content of the supervision message.
4. The method of claim 3, wherein the change information of the source system table is a table offline or a field offline, and the processing the change content of the supervision packet includes:
and displaying the offline reminding information of the change content of the supervision message.
5. The method of claim 3, wherein the change information of the source system table is a table change or a field change, and the processing the change content of the supervision packet includes:
and changing configuration files of layers corresponding to the data blood-edge relation from the source system table to the interface table, wherein the configuration files are used for generating a data table of the layers included in the data blood-edge relation from the source system table to the interface table.
6. The method of claim 3, wherein the change information of the source system table is a code value change, and the processing the change content of the supervision message includes:
and changing the mapping relation between the code value included in the code value mapping table and the target content, or changing the mapping relation between the code value included in the restoration caliber document and the target content.
7. A method according to claim 3, characterized in that the method further comprises:
and displaying a processing result of processing the changed content of the supervision message.
8. A device for determining the contents of a change in a supervision message in a data warehouse, wherein the data warehouse is configured to process a source system table into an interface table through a plurality of layers, the source system table being a data table provided by a source system, and the interface table being a data table provided by the data warehouse to a downstream system, the device comprising:
the acquisition unit is used for acquiring the change information of the source system table;
a first determining unit, configured to determine an interface table change content based on change information of the source system table and a data blood-edge relationship from the source system table to the interface table;
and the second determining unit is used for determining the change content of the supervision message according to the change content of the interface table and the restoration caliber document, wherein the restoration caliber document is used for indicating the generation of the supervision message based on the interface table.
9. A device for determining the content of a change in a data warehouse supervision message, comprising: a processor, memory, system bus;
the processor and the memory are connected through the system bus;
the memory is for storing one or more programs, the one or more programs comprising instructions, which when executed by the processor, cause the processor to perform the method of any of claims 1-7.
10. A computer readable storage medium, characterized in that the computer readable storage medium has stored therein instructions, which when run on a terminal device, cause the terminal device to perform the method of any of claims 1-7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310622644.3A CN116644067A (en) | 2023-05-29 | 2023-05-29 | Method and related device for determining change content of data warehouse supervision message |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310622644.3A CN116644067A (en) | 2023-05-29 | 2023-05-29 | Method and related device for determining change content of data warehouse supervision message |
Publications (1)
Publication Number | Publication Date |
---|---|
CN116644067A true CN116644067A (en) | 2023-08-25 |
Family
ID=87639476
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202310622644.3A Pending CN116644067A (en) | 2023-05-29 | 2023-05-29 | Method and related device for determining change content of data warehouse supervision message |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN116644067A (en) |
-
2023
- 2023-05-29 CN CN202310622644.3A patent/CN116644067A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111309759A (en) | Enterprise scientific and technological project intelligent matching platform | |
US20200242615A1 (en) | First party fraud detection | |
CN108038776A (en) | A kind of data processing method and data processing terminal | |
CN112581283A (en) | Method and device for analyzing and alarming business bank employee transaction behaviors | |
CN101452556A (en) | Customer information processing system and method | |
US20130013475A1 (en) | Issue Resolution | |
CN111813829A (en) | Data resolution method, device, electronic equipment and storage medium | |
CN114140221A (en) | Fraud risk early warning method, device and equipment | |
CN116483822B (en) | Service data early warning method, device, computer equipment and storage medium | |
CN111552733B (en) | Operation dynamic analysis system and method based on big data | |
CN111476657A (en) | Information pushing method, device and system | |
US20030126052A1 (en) | Method and apparatus for establishing real estate investments | |
CN117036062A (en) | Accounting resource calculation method and device | |
CN108694547B (en) | Account abnormity identification method, device, equipment and storage medium | |
CN111652716A (en) | Method and device for determining label of account number | |
CN116644067A (en) | Method and related device for determining change content of data warehouse supervision message | |
CN114971637A (en) | Risk early warning method, device, equipment and medium | |
CN112308639B (en) | Aging prediction method and device for target event | |
CN112966024A (en) | Financial wind control data analysis system based on big data | |
CN112766892A (en) | Method and device for combining fund ratio of RPA and AI and electronic equipment | |
CN114240610B (en) | Automatic fund collection method, device, computer equipment and storage medium | |
CN111967960B (en) | Batch adjustment method and device for account data | |
CN118379080A (en) | Key guest group tracking method and device, storage medium and processor | |
CN113139862A (en) | Cash management system | |
CN116862681A (en) | Data fusing detection method, device, equipment and 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 |