CN113297179A - Method and device for processing supervision submission data - Google Patents

Method and device for processing supervision submission data Download PDF

Info

Publication number
CN113297179A
CN113297179A CN202110605650.9A CN202110605650A CN113297179A CN 113297179 A CN113297179 A CN 113297179A CN 202110605650 A CN202110605650 A CN 202110605650A CN 113297179 A CN113297179 A CN 113297179A
Authority
CN
China
Prior art keywords
data
index
indexes
reporting system
supervision
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110605650.9A
Other languages
Chinese (zh)
Inventor
李鹏
张东凯
周琳琳
廖清碧
马管宇
尹航
高鑫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN202110605650.9A priority Critical patent/CN113297179A/en
Publication of CN113297179A publication Critical patent/CN113297179A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/217Database tuning
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/283Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Software Systems (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Testing And Monitoring For Control Systems (AREA)

Abstract

The invention discloses a method and a device for processing supervision submission data, which relate to the technical field of big data, wherein the method comprises the following steps: acquiring reporting system indexes and detailed data of the reporting system indexes from each supervision reporting system; determining the reporting system indexes belonging to the same supervision system index according to an index fusion rule, and dividing the reporting system indexes belonging to the same supervision system index into the same class; respectively fusing the detail data of each type of reporting system index as the detail data of the supervision system index; and uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system. The invention processes the index data reported by the reporting system according to the unified index fusion rule by configuring the index fusion rule, realizes the standardization of the data of the uploading supervision system, has small maintenance workload of the index fusion rule, and is beneficial to the subsequent modification and expansion of the index dimension.

Description

Method and device for processing supervision submission data
Technical Field
The invention relates to the technical field of big data, in particular to a method and a device for processing supervision submission data.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
With the development of economy and the continuous emergence of financial innovation, the supervision of the banking financial institutions by the supervision institutions such as the national people's banks, the bank insurance supervision and management committee, the national foreign exchange administration and the like is continuously enhanced, and meanwhile, the change frequency of the supervision content gradually shows an increasing trend. These are reflected in the regulatory statistics and exhibit the following characteristics: the statistical report forms (or messages) are various; secondly, the statistical system changes a lot and is fatigued to deal with; thirdly, the requirements of the supervision authorities on the data quality are continuously improved; fourthly, the cost investment is increased year by year.
With the regulatory authorities having made regulatory update requirements on various delivery works in sequence, the change of the regulatory authorities in the financial institution supervision direction can be obviously sensed by the overall planning trend, and the supervision trend from statistical index monitoring to theme type service data delivery and then to detail level service data delivery is undoubtedly higher requirements on the financial institution in the data quality level.
The current traditional supervision reports are divided into three types:
1. each sub-project is independently built with a subsystem, and the unified standardization is not achieved;
2. a unified supervision and submission platform is provided, data standardization is not achieved, and each sub-project has independent data processing;
3. there is a unified supervision reporting platform, and there is also a traditional intermediate supervision market built according to the business body.
Along with the huge change of the supervision rules and the supervision framework, the supervision mechanism not only strengthens the supervision in the aspects of resource management risk, compliance, safety and the like, but also gradually eliminates the traditional supervision reporting system without unified standards, and the traditional middle supervision market also gradually exposes redundancy because the supervision rules are continuously upgraded, so that the implementation and maintenance workload is greatly invested, the dimensionality of subsequent supervision indexes is comprehensively expanded, and the expansion is not facilitated.
Disclosure of Invention
The embodiment of the invention provides a processing method for supervising and submitting data, which is characterized in that index fusion rules are configured, and the index data submitted by a submission system is processed according to the unified index fusion rules, so that the standardization of uploading supervision system data is realized, meanwhile, the maintenance workload of the index fusion rules is small, and the subsequent modification and expansion of index dimensions are facilitated, and the method comprises the following steps:
acquiring reporting system indexes and detailed data of the reporting system indexes from each supervision reporting system;
determining the submission system indexes belonging to the same supervision system index according to an index fusion rule, and dividing the submission system indexes belonging to the same supervision system index into the same class;
respectively fusing the detail data of each type of reporting system index as the detail data of the supervision system index;
and uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
In an implementation manner of the embodiment of the present invention, before the detail data of each type of reporting system index is fused as the detail data of the monitoring system index, the method further includes:
checking detailed data of the reporting system index;
the detail data of each kind of reporting system index is fused respectively and is used as the detail data of the supervision system index, and the method comprises the following steps:
and if the detail data of the reporting system indexes pass the verification, respectively fusing the detail data of each type of reporting system indexes to serve as the detail data of the supervision system indexes.
In an implementation manner of the embodiment of the present invention, the verifying the detail data of the submission system index includes:
checking whether the data format of the detail data of the reporting system index meets the preset format requirement or not;
checking whether the detail data of the reporting system index has a preset business logic relationship;
and carrying out integrity check and consistency check on the detailed data of the reporting system index.
In an implementation manner of the embodiment of the present invention, the index fusion rule is to fuse attributes and reporting system indexes with the same definition, where the attributes of the reporting system indexes include a basic attribute, a service attribute, a technical attribute, a supervision attribute, and an index category attribute.
In an implementation manner of the embodiment of the present invention, after the detail data of each type of reporting system index is respectively fused as the detail data of the monitoring system index, the method further includes:
and dividing the detail data of the indexes of the supervision system according to the preset dimension to obtain the specified dimension data.
In an implementation manner of the embodiment of the present invention, after obtaining the specified dimension data, the method further includes:
storing the data of different dimensions in different data tables.
In one implementation manner of the embodiment of the present invention, after storing the data with different dimensions in different data tables, the method further includes:
receiving different data tables and corresponding setting information of access authority;
and setting the access authority of different data tables according to the setting information.
In one implementation manner of the embodiment of the present invention, after storing the data with different dimensions in different data tables, the method further includes:
and displaying the data with different dimensions in the data table in a tree menu list form.
In an implementation manner of the embodiment of the present invention, the method further includes:
and functions of adding, deleting, modifying, importing and exporting indexes of the supervisory system are provided.
The embodiment of the invention also provides a processing method for supervising and submitting data, which processes the index data submitted by a submitting system according to a uniform index fusion rule by configuring the index fusion rule, realizes the standardization of uploading supervising system data, has small maintenance workload of the index fusion rule, and is beneficial to the subsequent modification and expansion of index dimensionality, and the device comprises:
the acquisition module is used for acquiring the reporting system indexes and detail data of the reporting system indexes from each supervision reporting system;
the determining module is used for determining the reporting system indexes belonging to the same monitoring system index according to the index fusion rule and dividing the reporting system indexes belonging to the same monitoring system index into the same class;
the fusion module is used for fusing the detail data of each type of reporting system index respectively to serve as the detail data of the supervision system index;
and the data uploading module is used for uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
In an implementation manner of the embodiment of the present invention, the apparatus further includes:
the verification module is used for verifying the detail data of the reporting system index;
a fusion module to:
and if the detail data of the reporting system indexes pass the verification, respectively fusing the detail data of each type of reporting system indexes to serve as the detail data of the supervision system indexes.
In an implementation manner of the embodiment of the present invention, the verification module is configured to:
checking whether the data format of the detail data of the reporting system index meets the preset format requirement or not;
checking whether the detail data of the reporting system index has a preset business logic relationship;
and carrying out integrity check and consistency check on the detailed data of the reporting system index.
In an implementation manner of the embodiment of the present invention, the index fusion rule is to fuse attributes and reporting system indexes with the same definition, where the attributes of the reporting system indexes include a basic attribute, a service attribute, a technical attribute, a supervision attribute, and an index category attribute.
In an implementation manner of the embodiment of the present invention, the apparatus further includes:
and the dimension division module is used for dividing detailed data of the indexes of the monitoring system according to the preset dimension to obtain specified dimension data.
In an implementation manner of the embodiment of the present invention, the apparatus further includes:
and the storage module is used for storing the data with different dimensions in different data tables.
In an implementation manner of the embodiment of the present invention, the apparatus further includes:
the receiving module is used for receiving different data tables and corresponding setting information of access authority;
and the permission setting module is used for setting the access permission of different data tables according to the setting information.
In an implementation manner of the embodiment of the present invention, the apparatus further includes:
and the display module is used for displaying different dimensional data in the data table in a tree menu list form.
In an implementation manner of the embodiment of the present invention, the apparatus further includes:
and the processing module is used for providing functions of adding, deleting, modifying, importing and exporting the indexes of the monitoring system.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor realizes the processing method of the supervision and report data when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing the above-mentioned method for processing supervision submission data is stored in the computer-readable storage medium.
In the embodiment of the invention, the index fusion rule is configured, the index data reported by the reporting system is processed according to the unified index fusion rule, the standardization of the reported supervisory system data is realized, the quality of the data reported to the supervisory system is improved, meanwhile, the maintenance workload of the index fusion rule is small, the subsequent modification and expansion of the index dimension are facilitated, and a foundation is laid for the fusion and the unification of the data supervisory standards of all supervisory institutions. In addition, through unified index integration mechanism, the financial science and technology personnel who can also reduce each supervision and submission system process the detail data of submission system index for the work load of supervision system index detail data, have promoted bank data analyst's work efficiency, have reduced the work degree of difficulty.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
FIG. 1 is a system architecture diagram of a processing device for supervising submission data in an embodiment of the present invention;
FIG. 2 is an application architecture diagram of a processing device for supervising submission data according to an embodiment of the present invention;
FIG. 3 is a flowchart of a method for handling supervision advisory data according to an embodiment of the present invention;
FIG. 4 is a schematic diagram illustrating a processing apparatus for monitoring and managing posted data according to an embodiment of the present invention;
FIG. 5 is a schematic structural diagram of a computer device according to an embodiment of the present invention;
fig. 6 is a system architecture diagram of a computer device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention and not to limit the present invention.
In order to improve a system service index unified management mechanism and combine the condition of detail data of each existing supervision and delivery system, the embodiment of the invention carries out index integrated management, establishes a processing device of supervision and delivery data, forms a set of complete index management system, and is integrated with interfaces of each supervision and delivery system in a unified way to receive the detail data of each supervision and delivery system and carry out index fusion on the detail data of each supervision and delivery system, thereby carrying out multi-dimensional standardized index display and data penetration.
Fig. 1 is a diagram showing the overall architecture of the index management system.
Referring to fig. 1, the index management system includes a data source module, an index tag management module, an index fusion module, and a data service module. The data source module provides various reporting system indexes and detail data from various supervision reporting systems; the index label management module is used for realizing the functions of index management, label management, index check rule management, index parameter management, index problem knowledge management, automation script and the like; the index fusion module is used for providing functions of fusion index management, fusion index check rule library management, fusion index parameter library management, fusion index problem knowledge library management and the like; the data service module is used for realizing the services of monitoring index panoramic views, data quality performance assessment, query services, analysis services and the like.
Fig. 2 is a schematic diagram of an application architecture of a processing apparatus for monitoring and managing report data according to an embodiment of the present invention.
Referring to fig. 2, the device collects and processes data meeting the supervision requirement from an upstream business system, performs data quality check, and provides prepositive capability of file conversion and data loading and unloading. The upstream business system comprises a personal loan system, a public loan system, a personal deposit system and the like.
The checking rules set in the device comprise service checking and technical checking, wherein the service checking comprises correlation checking containing service logic relation among data, such as correlation checking and logic checking among tables; technical checks include checks on data formats, such as check on character length, character type, date format, and the like.
The prepositive capability of the device comprises integrity, consistency and other checks on data files provided by a source system, the data is loaded to an application interface layer after the checks are correct, and data conversion and processing are carried out according to the requirements of supervision specifications.
The supervision application realized by the device comprises the steps of establishing a supervision index library based on the supervision application, supporting various index capabilities, providing system support and the like.
The supervision index library comprises the following functions:
firstly, service interpretation: and (4) carrying out aperture analysis on the indexes according to the supervision definition and the actual service condition of the financial institution.
Secondly, data mapping: i.e. a fetch rule determined from the traffic interpretation.
Thirdly, supervision and definition: used for describing the definition of the index by the supervision department.
Fourthly, attributing indexes: and describing the business department to which the index belongs.
Fifthly, index weight: the degree of importance of the index is defined, for example: whether it can be empty or not, and whether it can be reported.
In the aspect of index capability, in the embodiment of the present invention, the supervision indexes of each supervision application are extracted and analyzed, and the clear indexes are defined as follows:
firstly, index splitting: and splitting the same supervision system index according to different supervision requirements of different regions to obtain the reporting system index.
Secondly, index merging: and defining the same indexes for merging in the same supervision submission task.
And thirdly, index fusion: in different supervision and delivery systems, defined indexes with the same attribute are combined into one index.
Fourthly, index difference analysis: and taking the indexes of the EAST submission tasks as a reference, and performing difference analysis on the indexes of the submission tasks and the same indexes.
Fifth, index label: and classifying the attributes of the indexes.
Sixthly, index problem file: and checking the index problems generated by the checking rules or the index problems provided by the checking of the supervision institution, and recording and filing the index problems of the two sources.
And seventh, index relation link: 5 Large attributes describing the index: basic attribute, service attribute, technical attribute, monitoring attribute and index category attribute.
Through the processing logic and the defined dimension of the index, the problem checked by matching with the checking rule can be quickly positioned, how the data problem is processed, which business department the data problem belongs to and which component the data problem belongs to can be quickly positioned, and the condition allows that the data can be continuously subjected to penetration analysis according to the upstream data, for example, the data source of the problem data of the public term deposit account is judged according to the data content, such as the data from a debit card component or a bankbook, such as the data from a cash management component or a company, and the like.
Based on the above system architecture and application structure, an embodiment of the present invention provides a method for processing supervision submission data, as shown in fig. 3, where the method includes steps 301 to 304:
step 301, obtaining the reporting system indexes and detailed data of the reporting system indexes from each supervision reporting system.
The supervision reporting System comprises supervision standardized Data (EAST and Analysis System Technology), a Financial Audit Data Analysis Platform (FADAP), a banking customer Risk statistical project (custorr Risk Statistics System, CRSS), a non-resident Financial account tax information reporting System (CRS), a nationwide centralized Bank account reporting System (BASS), a Bank account settlement supervision reporting System, a Bank Financial precision Data reporting System and the like.
And step 302, determining the reporting system indexes belonging to the same supervision system index according to the index fusion rule, and dividing the reporting system indexes belonging to the same supervision system index into the same class.
The index fusion rule is used for fusing reporting system indexes with the same attributes and definitions, wherein the attributes of the reporting system indexes comprise basic attributes, business attributes, technical attributes, supervision attributes and index category attributes.
And 303, fusing the detail data of each type of reporting system index respectively to serve as the detail data of the supervision system index.
Before the detail data of each type of reporting system indexes are fused and used as the detail data of the supervision system indexes, the detail data of the reporting system indexes can be verified in order to improve the accuracy of the data; and if the detail data of the reporting system indexes pass the verification, respectively fusing the detail data of each type of reporting system indexes to serve as the detail data of the monitoring system indexes.
Specifically, the verification of the detail data of the reporting system index includes the following three verification steps:
checking whether the data format of the detail data of the reporting system index meets the requirement of a preset format;
checking whether the detail data of the reporting system index has a preset business logic relationship;
and thirdly, carrying out integrity check and consistency check on the detailed data of the reported system indexes.
After the detail data of each type of reporting system indexes are respectively fused and used as the detail data of the monitoring system indexes, the detail data of the monitoring system indexes can be divided according to preset dimensionality to obtain specified dimensionality data. The preset dimensionality comprises a theme domain, a table name, a product, a region and a supervision mechanism.
In the embodiment of the present invention, after the detail data is divided according to the dimensions, data query can be performed according to the dimensions, for example, the detail data in the north China area is queried, and then all the detail data belonging to the north China dimensions can be obtained by north China through the keyword. Therefore, the user can conveniently search the data of a certain dimension without searching for many times through each keyword.
Meanwhile, the data of different dimensions in the data table can be displayed in a tree menu list mode according to various dimensions, such as a theme domain and a table name, and a navigation searching function is supported.
In the embodiment of the invention, after the specified dimension data is obtained, different dimension data can be stored in different data tables. Penetrating according to the name of the data table, and showing all the supervision system indexes under the data table, including: the system comprises a serial number, a system name to which the index belongs, a business theme, a region, a supervision organization, a table English civilization, a table Chinese name, an index field English name, an index field Chinese name, mapping rule description, rule remarks, a source system Chinese name, a source table Chinese name, a source field Chinese name, a belonging department, a business interpretation, a supervision requirement, a creator, a creation date, an updater, an update date and other data items.
After different dimensionality data are stored in different data tables, setting information of the different data tables and corresponding access authorities can be received; and setting the access authority of different data tables according to the setting information. The access authority can be different operation authorities for checking, inquiring, deleting, modifying and the like of the data table, and is convenient for service management personnel to flexibly distribute and manage the data table authority.
In addition, the processing device for supervising the reported data in the embodiment of the invention also supports the functions of flexible index query and management and the function of index field verification.
The flexible index query and management function supports: index data filtering query can be carried out according to multiple dimensions of supervision submission system names, service themes, data table names, index field Chinese names, products, areas, supervision organizations and the like; supporting index matching according to dimensions such as themes, index names and the like and manually screening indexes according to specific query conditions; and thirdly, functions of data addition, deletion, modification and index import and export are supported.
The index field checking function is a function of checking the Chinese name of the source system, the English name of the source system, the serial number of the source system, the English name of the source table, the Chinese name of the source table and the like from the table level and the field level. And when index data is newly added and modified on the front-end page or updated data is imported in an EXCEL table form, a verification mechanism needs to be formed with the original data, and verification result information is prompted on the page.
And step 304, uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
In the embodiment of the invention, the index fusion rule is configured, the index data reported by the reporting system is processed according to the unified index fusion rule, the standardization of the reported supervisory system data is realized, the quality of the data reported to the supervisory system is improved, meanwhile, the maintenance workload of the index fusion rule is small, the subsequent modification and expansion of the index dimension are facilitated, and a foundation is laid for the fusion and the unification of the data supervisory standards of all supervisory institutions. In addition, through unified index integration mechanism, the financial science and technology personnel who can also reduce each supervision and submission system process the detail data of submission system index for the work load of supervision system index detail data, have promoted bank data analyst's work efficiency, have reduced the work degree of difficulty.
The embodiment of the present invention further provides a processing apparatus for supervising submission data, as described in the following embodiments. Because the principle of the device for solving the problems is similar to the processing method of the supervision submission data, the implementation of the device can refer to the implementation of the processing method of the supervision submission data, and repeated parts are not described again.
As shown in fig. 4, the apparatus 400 includes an obtaining module 401, a determining module 402, a fusing module 403, and a data uploading module 404.
The acquiring module 401 is configured to acquire delivery system indexes and detailed data of the delivery system indexes from each supervisory delivery system;
a determining module 402, configured to determine, according to an index fusion rule, reporting system indexes belonging to the same monitoring system index, and divide the reporting system indexes belonging to the same monitoring system index into the same class;
a fusion module 403, configured to fuse detail data of each type of reporting system index respectively, as detail data of a monitoring system index;
a data uploading module 404, configured to upload the monitoring system index and the corresponding detail data to the monitoring system.
In one implementation manner of the embodiment of the present invention, the apparatus 400 further includes:
a verification module 405, configured to verify detail data of the submission system index;
a fusion module 403, configured to:
and if the detail data of the reporting system indexes pass the verification, respectively fusing the detail data of each type of reporting system indexes to serve as the detail data of the supervision system indexes.
In an implementation manner of the embodiment of the present invention, the checking module 405 is configured to:
checking whether the data format of the detail data of the reporting system index meets the preset format requirement or not;
checking whether the detail data of the reporting system index has a preset business logic relationship;
and carrying out integrity check and consistency check on the detailed data of the reporting system index.
In an implementation manner of the embodiment of the present invention, the index fusion rule is to fuse attributes and delivery system indexes with the same definition, where the attributes of the delivery system indexes include a basic attribute, a service attribute, a technical attribute, a supervision attribute, and an index category attribute.
In one implementation manner of the embodiment of the present invention, the apparatus 400 further includes:
and the dimension dividing module 406 is configured to divide detailed data of the monitoring system index according to a preset dimension to obtain specified dimension data.
In one implementation manner of the embodiment of the present invention, the apparatus 400 further includes:
the storage module 407 is configured to store the data with different dimensions in different data tables.
In one implementation manner of the embodiment of the present invention, the apparatus 400 further includes:
a receiving module 408, configured to receive setting information of different data tables and corresponding access permissions;
and the permission setting module 409 is used for setting access permissions of different data tables according to the setting information.
In one implementation manner of the embodiment of the present invention, the apparatus 400 further includes:
and the display module 410 is used for displaying the data with different dimensions in the data table in the form of a tree menu list.
In one implementation manner of the embodiment of the present invention, the apparatus 400 further includes:
and the processing module 411 is used for providing functions of adding, deleting, modifying, importing and exporting the indexes of the monitoring system.
In the embodiment of the invention, the index fusion rule is configured, the index data reported by the reporting system is processed according to the unified index fusion rule, the standardization of the reported supervisory system data is realized, the quality of the data reported to the supervisory system is improved, meanwhile, the maintenance workload of the index fusion rule is small, the subsequent modification and expansion of the index dimension are facilitated, and a foundation is laid for the fusion and the unification of the data supervisory standards of all supervisory institutions. In addition, through unified index integration mechanism, the financial science and technology personnel who can also reduce each supervision and submission system process the detail data of submission system index for the work load of supervision system index detail data, have promoted bank data analyst's work efficiency, have reduced the work degree of difficulty.
An embodiment of the present invention further provides a computer device, and fig. 5 is a schematic diagram of a computer device in an embodiment of the present invention, where the computer device is capable of implementing all steps in the method for processing supervision submission data in the foregoing embodiment, and the computer device specifically includes the following contents:
a processor (processor)501, a memory (memory)502, a communication Interface (Communications Interface) 503, and a communication bus 504;
the processor 501, the memory 502 and the communication interface 503 complete mutual communication through the communication bus 504; the communication interface 503 is used for implementing information transmission between related devices;
the processor 501 is configured to call a computer program in the memory 502, and when the processor executes the computer program, the processor implements the processing method of the supervision submission data in the above embodiments.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing the above-mentioned method for processing supervision submission data is stored in the computer-readable storage medium.
Fig. 6 is a schematic diagram of a system configuration of a computer device according to an embodiment of the present invention. As shown in fig. 6, the computer device 600 may include a processor 601 and a memory 602; a memory 602 is coupled to the processor 601. Notably, this FIG. 6 is exemplary; other types of structures may also be used in addition to or in place of the structure to implement telecommunications or other functions.
In one embodiment, the functions implemented by the processing method of the supervisory advisory data may be integrated into the processor 601. Wherein the processor 601 may be configured to control as follows: acquiring reporting system indexes and detailed data of the reporting system indexes from each supervision reporting system; determining the reporting system indexes belonging to the same monitoring system index according to an index fusion rule, and dividing the reporting system indexes belonging to the same monitoring system index into the same class; respectively fusing the detail data of each type of reporting system index as the detail data of the supervision system index; and uploading the indexes of the supervision system and the corresponding detailed data to the supervision system.
As can be seen from the above, the computer device provided in the embodiment of the present invention obtains the delivery system indicators and the detail data of the delivery system indicators from the respective supervisory delivery systems; determining the reporting system indexes belonging to the same supervision system index according to an index fusion rule, and dividing the reporting system indexes belonging to the same supervision system index into the same class; respectively fusing the detail data of each type of reporting system index as the detail data of the supervision system index; and uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
Through the computer equipment provided by the embodiment of the invention, the index data reported by the reporting system can be processed according to the unified index fusion rule by configuring the index fusion rule, so that the standardization of the data of the uploading supervision system is realized, and meanwhile, the maintenance workload of the index fusion rule is small, thereby being beneficial to the follow-up modification and expansion of the index dimension.
In another embodiment, the processing means for supervising the submission data may be configured separately from the processor 601, for example, the processing means for supervising the submission data may be configured as a chip connected to the processor 601, and the functions of the method for processing based on the supervision submission data may be implemented by the control of the processor.
As shown in fig. 6, the computer device 600 may further include: a communication module 603, an input unit 604, an audio processing unit 605, a display 606, and a power supply 603. It is noted that the computer device 600 does not necessarily include all of the components shown in FIG. 6; furthermore, the computer device 600 may also comprise components not shown in fig. 6, as can be seen from the prior art.
As shown in FIG. 6, the processor 601, which is sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, and the processor 601 receives input and controls the operation of the various components of the computer device 600.
The memory 602 may be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the processor 601 may execute the program stored in the memory 602 to realize information storage or processing, or the like.
An input unit 604 provides input to the processor 601. The input unit 604 is, for example, a key or a touch input device. The power supply 603 is used to provide power to the computer device 600. The display 606 displays display objects such as images and characters. The display may be, for example, an LCD display, but is not limited thereto.
The memory 602 may be a solid state memory such as Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 602 may also be some other type of device. Memory 602 includes buffer memory 6021 (sometimes referred to as a buffer). The memory 602 may include an application/function storage portion 6022 for storing application programs and function programs or a flow for executing the operation of the computer device 600 by the processor 601.
The memory 602 may also include a data store 6023 that stores data such as contacts, digital data, pictures, sounds, and/or any other data used by the computer device. The driver store 6024 of the memory 602 may include various drivers for the computer device for communication functions and/or for performing other functions of the computer device, such as messaging applications, address book applications, and the like.
The communication module 603 is a transmitter/receiver that transmits and receives signals via the antenna 608. A communication module (transmitter/receiver) 603 is coupled to the processor 601 to provide an input signal and receive an output signal, which may be the same as the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 603, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same computer device. The communication module (transmitter/receiver) 603 is also coupled to a speaker 609 and a microphone 610 via an audio processing unit 605 to provide an audio output via the speaker 609 and to receive an audio input from the microphone 610, thereby implementing the usual telecommunication functions. The audio processing unit 605 may include any suitable buffers, decoders, amplifiers and so forth. In addition, audio processing unit 605 is also coupled to processor 601 so that locally stored sound can be recorded by microphone 610 and played by speaker 609.
An embodiment of the present invention further provides a computer-readable storage medium for implementing all the steps in the method for processing supervision advisory data in the above-mentioned embodiment, where the computer-readable storage medium has stored thereon a computer program which, when executed by a processor, implements all the steps of the method for processing supervision advisory data in the above-mentioned embodiment, for example, the processor implements the following steps when executing the computer program: acquiring reporting system indexes and detailed data of the reporting system indexes from the monitoring reporting systems; determining the reporting system indexes belonging to the same supervision system index according to an index fusion rule, and dividing the reporting system indexes belonging to the same supervision system index into the same class; respectively fusing the detail data of each type of reporting system index as the detail data of the supervision system index; and uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
As can be seen from the above, the computer-readable storage medium provided in the embodiments of the present invention obtains delivery system indicators and detail data of the respective delivery system indicators from the respective supervisory delivery systems; determining the reporting system indexes belonging to the same supervision system index according to an index fusion rule, and dividing the reporting system indexes belonging to the same supervision system index into the same class; respectively fusing the detail data of each type of reporting system index as the detail data of the supervision system index; and uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
By the computer-readable storage medium provided by the embodiment of the invention, the index data reported by the reporting system can be processed according to the unified index fusion rule by configuring the index fusion rule, so that the standardization of the data of the uploading supervision system is realized, and meanwhile, the maintenance workload of the index fusion rule is small, thereby being beneficial to the subsequent modification and expansion of the index dimension.
Although the present invention provides method steps as described in the examples or flowcharts, more or fewer steps may be included based on routine or non-invasive labor. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When an actual apparatus or client product executes, it may execute sequentially or in parallel (e.g., in the context of parallel processors or multi-threaded processing) according to the embodiments or methods shown in the figures.
As will be appreciated by one skilled in the art, embodiments of the present description may be provided as a method, apparatus (system) or computer program product. Accordingly, embodiments of the present description may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, the system embodiments are substantially similar to the method embodiments, so that the description is simple, and relevant parts can be referred to part of the description of the method embodiments. In this document, relational terms such as first and second, and the like may be 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. Also, 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. The terms "upper", "lower", and the like, indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, are only for convenience in describing and simplifying the description, and do not indicate or imply that the referred devices or elements must have a specific orientation, be constructed and operated in a specific orientation, and thus, should not be construed as limiting the present invention. Unless expressly stated or limited otherwise, the terms "mounted," "connected," and "connected" are intended to be inclusive and mean, for example, that they may be fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood by those skilled in the art according to specific situations. It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict. The present invention is not limited to any single aspect, nor is it limited to any single embodiment, nor is it limited to any combination and/or permutation of these aspects and/or embodiments. Each aspect and/or embodiment of the invention may be used alone or in combination with one or more other aspects and/or other embodiments.
The above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the present invention, and they should be construed as being included in the following claims and description.

Claims (20)

1. A method of processing supervisory submission data, the method comprising:
acquiring reporting system indexes and detailed data of the reporting system indexes from each supervision reporting system;
determining the reporting system indexes belonging to the same supervision system index according to an index fusion rule, and dividing the reporting system indexes belonging to the same supervision system index into the same class;
respectively fusing the detail data of each type of reporting system index as the detail data of the supervision system index;
and uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
2. The method of claim 1, wherein prior to fusing the detail data for each type of reporting system indicator separately as detail data for regulatory system indicators, the method further comprises:
checking detailed data of the reporting system index;
the detail data of each kind of reporting system index is fused respectively and is used as the detail data of the supervision system index, and the method comprises the following steps:
and if the detail data of the reporting system indexes pass the verification, respectively fusing the detail data of each type of reporting system indexes to serve as the detail data of the supervision system indexes.
3. The method of claim 2, wherein verifying the detail data of the submission system indicator includes:
checking whether the data format of the detail data of the reporting system index meets the preset format requirement or not;
checking whether the detail data of the reporting system index has a preset business logic relationship;
and carrying out integrity check and consistency check on the detailed data of the reporting system index.
4. The method of claim 1, wherein the index fusion rule is to fuse attributes and delivery system indexes that are defined identically, wherein the attributes of the delivery system indexes include a base attribute, a business attribute, a technical attribute, a regulatory attribute, and an index category attribute.
5. The method of claim 1, wherein after fusing the detail data for each type of reporting system indicator separately as the detail data for the regulatory system indicator, the method further comprises:
and dividing the detail data of the indexes of the supervision system according to the preset dimension to obtain the specified dimension data.
6. The method of claim 5, wherein after obtaining the specified dimension data, the method further comprises:
storing the data of different dimensions in different data tables.
7. The method of claim 6, wherein after storing the different dimensional data in different data tables, the method further comprises:
receiving different data tables and corresponding setting information of access authority;
and setting the access authority of different data tables according to the setting information.
8. The method of claim 6, wherein after storing the different dimensional data in different data tables, the method further comprises:
and displaying the data with different dimensions in the data table in a tree menu list form.
9. The method according to any one of claims 1 to 8, further comprising:
and functions of adding, deleting, modifying, importing and exporting indexes of the supervisory system are provided.
10. A processing apparatus that governs delivery data, the apparatus comprising:
the acquisition module is used for acquiring the reporting system indexes and detailed data of the reporting system indexes from each supervision reporting system;
the determining module is used for determining the reporting system indexes belonging to the same monitoring system index according to the index fusion rule and dividing the reporting system indexes belonging to the same monitoring system index into the same class;
the fusion module is used for fusing the detail data of each type of reporting system index respectively to serve as the detail data of the supervision system index;
and the data uploading module is used for uploading the indexes of the monitoring system and the corresponding detail data to the monitoring system.
11. The apparatus of claim 10, further comprising:
the verification module is used for verifying the detail data of the reporting system index;
a fusion module to:
and if the detail data of the reporting system indexes pass the verification, respectively fusing the detail data of each type of reporting system indexes to serve as the detail data of the supervision system indexes.
12. The apparatus of claim 11, wherein the verification module is configured to:
checking whether the data format of the detail data of the reporting system index meets the preset format requirement or not;
checking whether the detail data of the reporting system index has a preset business logic relationship;
and carrying out integrity check and consistency check on the detailed data of the reporting system index.
13. The apparatus of claim 10, wherein the index fusion rule is to fuse attributes and identically defined delivery system indexes, wherein the attributes of a delivery system index include a base attribute, a business attribute, a technical attribute, a regulatory attribute, and an index category attribute.
14. The apparatus of claim 10, further comprising:
and the dimension division module is used for dividing detailed data of the indexes of the monitoring system according to the preset dimension to obtain the specified dimension data.
15. The apparatus of claim 14, further comprising:
and the storage module is used for storing the data with different dimensions in different data tables.
16. The apparatus of claim 15, further comprising:
the receiving module is used for receiving different data tables and corresponding setting information of access authority;
and the permission setting module is used for setting the access permission of different data tables according to the setting information.
17. The apparatus of claim 15, further comprising:
and the display module is used for displaying different dimensional data in the data table in a tree menu list form.
18. The apparatus of any one of claims 10 to 17, further comprising:
and the processing module is used for providing functions of adding, deleting, modifying, importing and exporting the indexes of the monitoring system.
19. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any of claims 1 to 9 when executing the computer program.
20. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 9.
CN202110605650.9A 2021-05-31 2021-05-31 Method and device for processing supervision submission data Pending CN113297179A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110605650.9A CN113297179A (en) 2021-05-31 2021-05-31 Method and device for processing supervision submission data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110605650.9A CN113297179A (en) 2021-05-31 2021-05-31 Method and device for processing supervision submission data

Publications (1)

Publication Number Publication Date
CN113297179A true CN113297179A (en) 2021-08-24

Family

ID=77326441

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110605650.9A Pending CN113297179A (en) 2021-05-31 2021-05-31 Method and device for processing supervision submission data

Country Status (1)

Country Link
CN (1) CN113297179A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113867684A (en) * 2021-12-03 2021-12-31 江苏金融租赁股份有限公司 Balancing difference eliminating submission method and equipment based on supervision submission scene
CN114666321A (en) * 2022-03-21 2022-06-24 中国建设银行股份有限公司 Supervision submission data processing method, device, equipment, medium and product

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113867684A (en) * 2021-12-03 2021-12-31 江苏金融租赁股份有限公司 Balancing difference eliminating submission method and equipment based on supervision submission scene
CN114666321A (en) * 2022-03-21 2022-06-24 中国建设银行股份有限公司 Supervision submission data processing method, device, equipment, medium and product
CN114666321B (en) * 2022-03-21 2024-04-26 中国建设银行股份有限公司 Supervision report data processing method, device, equipment, medium and product

Similar Documents

Publication Publication Date Title
CN111325626B (en) Account checking data pushing method and device
CN111951101B (en) Data checking method and device
US20210365421A1 (en) Data analysis method, computer device and storage medium
CN112882699B (en) Service processing method, device, equipment and medium based on flow configuration engine
US20120158807A1 (en) Matching data based on numeric difference
CN113297179A (en) Method and device for processing supervision submission data
CN110795478A (en) Data warehouse updating method and device applied to financial business and electronic equipment
CN110807016A (en) Data warehouse construction method and device applied to financial business and electronic equipment
US20070185856A1 (en) System and method for managing attestations
CN110879808A (en) Information processing method and device
CN112116274A (en) Automatic generation method and device of survey report
CN114936199B (en) Data processing method for system reconstruction, computer equipment and storage medium
AU2022214554B2 (en) Dynamic application builder for multidimensional database environments
CN111897849B (en) Data query method and device
CN114092226A (en) Method and device for recommending foreign exchange products of bank outlets
CN113191881A (en) Financial business supervision data processing method, device and system based on block chain
CN111161047A (en) Bank business data processing and inquiring method and device
CN111859041A (en) Data transmission method and device
CN114911877A (en) Data processing method and related device
CN111444212A (en) Unified accounting method and device based on accounting system and accounting system
CN111598539A (en) CICS online program service processing method and system based on service modeling
CN112686626A (en) Accounting processing method and device
CN116091220A (en) Cross-border transaction business data analysis method and device
CN115391438A (en) Method, device, equipment and storage medium for generating data warehouse configuration document
CN118096358A (en) Intelligent enterprise credit report generation method and device

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