Configuration method and device of structured parameter table, equipment, medium and product

Abstract

The application discloses a configuration method and device of a structured parameter table, equipment, a medium and a product. The method comprises the following steps: acquiring different business types of a plurality of banks; setting a plurality of parameter items corresponding to each business type, wherein the plurality of parameter items comprise a business number, a mapping major category, a mapping category, a source table English name, a source table Chinese name, a target table English name, a target table Chinese name, a data extraction serial number and a mapping instruction; grouping the different business types of the plurality of banks according to different measurement methods to obtain a business parameter table. According to the embodiment of the application, the complexity of the development script can be reduced, and the efficiency of integrating asset data of different business types can be improved.

Description

Technical Field

[0001] This application belongs to the field of computer science, and in particular relates to a method, apparatus, device, medium and product for configuring a structured parameter table. Background Technology

[0002] Currently, banks have a large amount of asset data and complex measurement methods. Retail credit includes risk-weighted asset measurement such as personal housing mortgage loans, online consumer loans, and other personal loans. Corporate credit includes risk-weighted asset measurement such as micro and small enterprises, corporate cards, and corporate loans. Furthermore, the calculation of risk-weighted asset measurement values ​​requires the integration of results from various risk measurement models of the bank, as well as information such as customers, debts, and collateral.

[0003] Existing methods for measuring and displaying bank asset data typically involve aggregating multiple asset data points using programming code and calculating and displaying risk parameters, measurement methods, and measurement rules based on a large number of development scripts.

[0004] Therefore, existing technologies often involve lengthy and complex development scripts, which makes it difficult for business personnel and frontline managers to control the development process and quality, thus reducing the efficiency of integrating asset data from different business types. Summary of the Invention

[0005] This application provides a method, apparatus, device, medium, and product for configuring structured parameter tables, which can reduce the complexity of development scripts and improve the efficiency of integrating asset data of different business types.

[0006] In a first aspect, embodiments of this application provide a method for configuring a structured parameter table, the method comprising:

[0007] Obtain different business types from multiple banks;

[0008] Set multiple parameters for each business type. These parameters include business number, mapping category, mapping subcategory, source table name (English), source table name (Chinese), target table name (English), target table name (Chinese), data retrieval sequence number, and mapping description.

[0009] The different business types of multiple banks are grouped according to different measurement methods to obtain a business parameter table. Each business type corresponds to multiple sub-business types, and multiple sub-business types correspond to the same measurement method.

[0010] Secondly, embodiments of this application provide a configuration apparatus for a structured parameter table, the apparatus comprising:

[0011] The acquisition module is used to acquire different business types from multiple banks.

[0012] The settings module is used to set multiple parameter items for each business type. These parameters include business number, mapping category, mapping subcategory, source table name (English), source table name (Chinese), target table name (English), target table name (Chinese), data retrieval sequence number, and mapping description.

[0013] The grouping module is used to group different business types of multiple banks according to different measurement methods to obtain a business parameter table. Each business type will correspond to multiple sub-business types, and multiple sub-business types will correspond to the same measurement method.

[0014] Thirdly, embodiments of this application provide an electronic device, which includes:

[0015] Processor and memory storing computer program instructions;

[0016] The steps of configuring a structured parameter table as described in any embodiment of the first aspect when the processor executes computer program instructions.

[0017] Fourthly, embodiments of this application provide a computer-readable storage medium storing computer program instructions, which, when executed by a processor, implement the steps of a configuration method for a structured parameter table as described in any embodiment of the first aspect.

[0018] Fifthly, embodiments of this application provide a computer program product in which instructions, when executed by a processor of an electronic device, cause the electronic device to perform the steps of the configuration method for a structured parameter table as described in any embodiment of the first aspect.

[0019] This application provides a method, apparatus, device, medium, and product for configuring a structured parameter table. By acquiring different business types from multiple banks and setting corresponding parameter items for each business type, the parameter information included in different business types can be quickly browsed. Multiple different business types are grouped according to different measurement methods. Each business type can include multiple sub-business types, and these sub-business types correspond to the same measurement method. Sub-business types under the same measurement method are then summarized, and each sub-business type is numbered, ensuring that each business type's sub-business types correspond to a single measurement method. These multiple sub-business types are arranged in a table to obtain a business parameter table. Therefore, configuring different business types in the form of a parameter table, compared to summarizing different business types using programming code, effectively reduces the complexity of development scripts, facilitates business personnel and grassroots managers in controlling the development process and quality, and improves the efficiency of integrating asset data from different business types. Attached Figure Description

[0020] To more clearly illustrate the technical solutions of the embodiments of this application, the accompanying drawings used in the embodiments of this application will be briefly introduced below. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0021] Figure 1 This is a flowchart illustrating a method for configuring a structured parameter table according to an embodiment of this application;

[0022] Figure 2 This is a flowchart illustrating another method for configuring a structured parameter table provided in an embodiment of this application;

[0023] Figure 3 This is a schematic diagram illustrating the principle structure of a method for configuring a structured parameter table provided in an embodiment of this application.

[0024] Figure 4 This is a schematic diagram of a structured parameter table configuration device provided in an embodiment of this application;

[0025] Figure 5 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application. Detailed Implementation

[0026] The features and exemplary embodiments of various aspects of this application will be described in detail below. To make the objectives, technical solutions, and advantages of this application clearer, the application will be further described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described herein are only intended to explain this application and not to limit it. For those skilled in the art, this application can be implemented without some of these specific details. The following description of the embodiments is merely to provide a better understanding of this application by illustrating examples.

[0027] It should be noted that, in this document, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising..." does not exclude the presence of additional identical elements in the process, method, article, or apparatus that includes said element.

[0028] The acquisition, storage, use, and processing of data in this application all comply with the relevant provisions of national laws and regulations.

[0029] As described in the background section, the inventors have found that the measurement of bank asset data covers all assets of the entire bank. Retail credit includes risk-weighted asset measurement of personal housing mortgage loans, other personal loans, credit cards, and online consumer loans; corporate credit includes risk-weighted asset measurement of micro and small enterprises, corporate loans, and corporate cards; and funds include risk-weighted asset measurement of interbank lending, domestic and foreign currency bond business, and repurchase business. The data involved is extensive and the measurement is complex. Furthermore, the calculation of risk-weighted asset values ​​requires the integration of results from various risk measurement models of the bank. Methods for measuring and displaying bank asset data typically require a large number of development scripts to calculate and display risk parameters, measurement methods, and measurement rules. However, the development scripts are long and logically complex, which is not conducive to business personnel and grassroots managers controlling the development process and quality, thus reducing the efficiency of integrating asset data of different business types.

[0030] To address the problems of the prior art, embodiments of this application provide a method, apparatus, device, medium, and product for configuring structured parameter tables. The configuration method for structured parameter tables provided in this application embodiment will be described first below.

[0031] Figure 1 This illustration shows a flowchart of a method for configuring a structured parameter table according to an embodiment of this application. Figure 1 As shown, the configuration method for this structured parameter table may specifically include the following steps:

[0032] S110, Obtain different business types from multiple banks;

[0033] S120. Set multiple parameter items for each business type. The multiple parameter items include business number, mapping category, mapping classification, source table English name, source table Chinese name, target table English name, target table Chinese name, data retrieval sequence number, and mapping description.

[0034] S130. Group the different business types of multiple banks according to different measurement methods to obtain a business parameter table. Each business type will correspond to multiple sub-business types, and the multiple sub-business types will correspond to the same measurement method.

[0035] Therefore, by acquiring different business types from multiple banks and setting corresponding parameter items for each business type, the parameter information included in different business types can be quickly viewed. Multiple different business types can be grouped according to different measurement methods. Each business type can include multiple sub-business types, and multiple sub-business types correspond to the same measurement method. Sub-business types under the same measurement method are then aggregated, and each sub-business type is numbered, ensuring that each business type's sub-business types correspond to one measurement method. These multiple sub-business types are arranged in a table to obtain a business parameter table. Therefore, configuring different business types in the form of a parameter table, compared to aggregating different business types using programming code, effectively reduces the complexity of development scripts, helps business personnel and grassroots managers control the development process and quality, and improves the efficiency of integrating asset data from different business types.

[0036] The specific implementation methods for each of the above steps are described below.

[0037] In some embodiments, in S110, the business types involved in the embodiments of this application are investment, company cards, domestic companies and overseas companies, etc.

[0038] As an example, multiple banks can integrate asset data for all different business types of the bank by acquiring data from different business types.

[0039] In some embodiments, in S120, the parameter items may include business number, mapping category, mapping classification, source table English name, source table Chinese name, target table English name, target table Chinese name, data retrieval sequence number, and mapping description. The mapping description may represent multiple different business types, while other parameter items are configured according to the actual existing information.

[0040] As an example, after obtaining multiple different business types, corresponding parameter items are set for each business type. Each business type includes parameter information, and the parameter information corresponding to each business type is integrated and summarized in a business parameter table.

[0041] In some embodiments, in S130, each service type corresponds to multiple sub-service types, and the multiple sub-service types correspond to the same metering method.

[0042] As an example, if business types include investment, corporate cards, domestic companies, and overseas companies, then sub-business types can include investment-lending, investment-asset management, investment-bonds, investment-reverse repurchase agreements, and investment-deposits with the central bank; corporate cards - on-balance sheet and corporate cards - off-balance sheet; domestic companies - on-balance sheet, domestic companies - off-balance sheet, and domestic companies - revocable loan commitments; overseas companies - on-balance sheet, overseas companies - off-balance sheet, and overseas companies - revocable loan commitments. By summarizing the sub-business types under the same measurement method and assigning a number to each sub-business type (e.g., domestic companies - on-balance sheet 10001, domestic companies - off-balance sheet 10002, and domestic companies - revocable loan commitments 10003), and numbering all sub-business types in this order, and arranging them in a table, a business parameter table can be obtained.

[0043] To further configure filtering conditions and the main table for different business types in the business parameter table, so as to better distinguish between different business types, such as... Figure 2 As shown, Figure 2 This is a flowchart illustrating another method for configuring a structured parameter table provided in an embodiment of this application. The method for configuring the structured parameter table may further include the following steps:

[0044] S210, Obtain different business types from multiple banks;

[0045] S220. Set multiple parameter items for each business type;

[0046] S230. Group the different business types of multiple banks according to different measurement methods to obtain a business parameter table;

[0047] S240. Determine the key parameters for each business type. The key parameters are the key information in the corresponding business type mapping description.

[0048] S250. Sort the different business types of multiple banks according to the grouping order to obtain the main parameter table. The main parameter table includes key parameters, business number, mapping category, mapping number, source table English name, source table Chinese name, source table alias, whether the source table is a physical table, and whether the target table is a physical table.

[0049] In some embodiments, in S240, the key parameters are key information in the corresponding business type mapping description, and the mapping description can represent multiple different business types.

[0050] As an example, if one of the mapping descriptions in the business parameter table above is "Domestic Company - Within the Table", then the key information could be "Domestic - China-Germany". Each business type has corresponding key parameters, and the key parameters for each business type can be determined based on the mapping descriptions in the business parameter table.

[0051] In some embodiments, in S250, based on the key parameters of each business type determined above, different business types are arranged in the order of the sub-business type serial numbers in the business parameter table to obtain a main parameter table. The main parameter table includes key parameters, and in addition to the key parameters, it also includes business number, mapping category, mapping number, English name of source table, Chinese name of source table, alias of source table, whether the source table is a physical table, and whether the target table is a physical table. Each row in the main parameter table represents a key parameter of a business type.

[0052] S210 to S230 are the same as S110 to S130 in the above embodiments, and will not be described in detail here for the sake of brevity.

[0053] To ensure that customer information corresponding to different business types can be matched, the following steps can be included after S250:

[0054] Step 1: Based on the key parameters of each business type, obtain multiple associated parameters for each business type. These associated parameters are multiple pieces of related information included in the corresponding business type, including customer identifier, customer name, and customer country.

[0055] Step 2: Sort the multiple associated parameters according to the grouping order of their corresponding business types to obtain the associated parameter table. The associated parameter table includes the business number, mapping number, English name of the associated table, alias of the associated table, whether the associated table is a physical table, associated keyword, associated sequence number, and associated parameter.

[0056] In the above, the associated parameters are multiple pieces of associated information included in the corresponding business type, such as customer identifier, customer name, and customer country.

[0057] As an example, each business type has multiple related parameters in addition to the key parameters. For example, the key parameter in the table for a domestic company is "domestic-China-Germany", and its related parameters could be "customer A-bank A-China", etc. By sorting the multiple related parameters according to the business type grouping order, we can obtain the related parameter table. The related parameter table includes the related parameters, as well as the business number, mapping number, English name of the related table, alias of the related table, whether the related table is a physical table, related keywords, and related sequence number.

[0058] To configure the field-level processing information for the associated parameters, the following steps are included after step 2:

[0059] Step 3: Obtain the field values ​​of multiple associated parameters for each business type;

[0060] Step 4: Sort the field values ​​according to the business number of each business type to obtain a field parameter table. The field parameter table includes the business number, the mapping number, the field sequence number, the target field name, the field value condition, whether it is a constant, and the field value description.

[0061] As an example, based on the multiple associated parameters obtained above, corresponding field values ​​are configured for the multiple associated parameters. Each business type will have corresponding field values ​​for its multiple associated parameters. By sorting the field values ​​according to the business number of each business type, a field parameter table can be obtained. The field parameter table includes business number, mapping number, field sequence number, target field name, field value condition, whether it is a constant, and field value description.

[0062] To further process the data information in the four parameter tables configured above, the configuration method for this structured parameter table may further include the following steps:

[0063] Step 5: Store the business parameter table, main parameter table, related parameter table, and field parameter table into the relational database;

[0064] Step 6: Send the parameter table from the relational database to the batch processing server, which is the server that processes the data information in the parameter table.

[0065] As an example, such as Figure 3 As shown, Figure 3 This is a schematic diagram illustrating the principle structure of a structured parameter table configuration method provided in this application embodiment. This application is divided into an application end and a backend processing end. The application end may include a client, an internal network, a P4 service bus, an application server, and an ORACLE relational database. The backend processing end includes a batch processing server and a Massively Parallel Processing (MPP) database. The business parameter table, master parameter table, related parameter table, and field parameter table are stored in the ORACLE relational database. The four parameter tables in the relational database are sent to the batch processing server through a pipeline mode. The batch processing server may include a 4G / 8G server and a Luban adjustment platform. The batch processing server loads the four parameter tables into the MPP database.

[0066] To visualize the data from the four parameter tables and generate processing statements, the following steps may be included after step 6:

[0067] Step 7: Obtain the processing script, which is the processing rules written according to the corresponding parameter table;

[0068] Step 8: Process the data in the parameter table according to the processing script to obtain the processing statement;

[0069] Step 9: Visualize the processing statements.

[0070] As an example, by configuring Perl scripts for the four parameter tables, connecting to the MPP database mentioned above, writing processing rules, and traversing the data in the four parameter tables, processing statements can be automatically generated and visualized, thus enabling the complex metering and processing process within the Risk Weighted Assets (RWA) system to be configured into a simple processing device.

[0071] Therefore, by acquiring different business types from multiple banks and setting corresponding parameter items for each business type, the parameter information included in different business types can be quickly viewed. Multiple different business types can be grouped according to different measurement methods. Each business type can include multiple sub-business types, and multiple sub-business types correspond to the same measurement method. Sub-business types under the same measurement method are then aggregated, and each sub-business type is numbered, ensuring that each business type's sub-business types correspond to one measurement method. These multiple sub-business types are arranged in a table to obtain a business parameter table. Therefore, configuring different business types in the form of a parameter table, compared to aggregating different business types using programming code, effectively reduces the complexity of development scripts, helps business personnel and grassroots managers control the development process and quality, and improves the efficiency of integrating asset data from different business types.

[0072] It should be noted that the application scenarios described in the above embodiments of this application are for the purpose of more clearly illustrating the technical solutions of the embodiments of this application, and do not constitute a limitation on the technical solutions provided by the embodiments of this application. As those skilled in the art will know, with the emergence of new application scenarios, the technical solutions provided by the embodiments of this application are also applicable to similar technical problems.

[0073] Based on the same inventive concept, this application also provides a configuration device for a structured parameter table. Specifically, in conjunction with... Figure 4 Please provide a detailed explanation.

[0074] Figure 4 This is a schematic diagram of a structured parameter table configuration device provided in an embodiment of this application.

[0075] like Figure 4 As shown, the configuration device 400 for the structured parameter table may include:

[0076] Module 401 is used to acquire different business types from multiple banks;

[0077] The setting module 402 is used to set multiple parameter items for each business type. The multiple parameter items include business number, mapping category, mapping classification, source table English name, source table Chinese name, target table English name, target table Chinese name, data retrieval sequence number, and mapping description.

[0078] Grouping module 403 is used to group different business types of multiple banks according to different measurement methods to obtain a business parameter table. Each business type corresponds to multiple sub-business types, and multiple sub-business types correspond to the same measurement method.

[0079] The configuration device 400 for the above-mentioned structured parameter table will be described in detail below:

[0080] In one embodiment of this application, the configuration device 400 for the structured parameter table further includes:

[0081] The determination module is used to determine the key parameters for each business type. The key parameters are the key information in the corresponding business type mapping description.

[0082] The first sorting module is used to sort different business types of multiple banks according to the grouping order to obtain the main parameter table. The main parameter table includes key parameters, business number, mapping category, mapping number, English name of source table, Chinese name of source table, alias of source table, whether the source table is a physical table, and whether the target table is a physical table.

[0083] In one embodiment of this application, the configuration device 400 for the structured parameter table further includes:

[0084] The acquisition module 401 is used to acquire multiple associated parameters for each business type based on the key parameters of each business type. The multiple associated parameters are multiple associated information included in the corresponding business type, including customer identifier, customer name and customer country.

[0085] The second sorting module is used to sort multiple associated parameters according to the grouping order of their corresponding business types to obtain an associated parameter table. The associated parameter table includes business number, mapping number, English name of associated table, alias of associated table, whether the associated table is a physical table, associated keyword, associated sequence number, and associated parameter.

[0086] In one embodiment of this application, the configuration device 400 for the structured parameter table further includes:

[0087] Module 401 is used to retrieve the field values ​​of multiple associated parameters for each business type;

[0088] The third sorting module is used to sort the field values ​​according to the business number of each business type to obtain the field parameter table. The field parameter table includes the business number, mapping number, field sequence number, target field name, field value condition, whether it is a constant, and field value description.

[0089] In one embodiment of this application, the configuration device 400 for the structured parameter table further includes:

[0090] The storage module is used to store the business parameter table, main parameter table, related parameter table, and field parameter table into the relational database;

[0091] The sending module is used to send parameter tables from the relational database to the batch processing server, which is a server that processes the data information in the parameter tables.

[0092] In one embodiment of this application, the configuration device 400 for the structured parameter table further includes:

[0093] The acquisition module 401 is used to acquire the processing script, which is the processing rules written in the corresponding parameter table;

[0094] The processing module is used to process the data information in the parameter table according to the processing script to obtain processing statements;

[0095] The display module is used to visually represent the processing statements.

[0096] Therefore, by acquiring different business types from multiple banks and setting corresponding parameter items for each business type, the parameter information included in different business types can be quickly viewed. Multiple different business types can be grouped according to different measurement methods. Each business type can include multiple sub-business types, and multiple sub-business types correspond to the same measurement method. Sub-business types under the same measurement method are then aggregated, and each sub-business type is numbered, ensuring that each business type's sub-business types correspond to one measurement method. These multiple sub-business types are arranged in a table to obtain a business parameter table. Therefore, configuring different business types in the form of a parameter table, compared to aggregating different business types using programming code, effectively reduces the complexity of development scripts, helps business personnel and grassroots managers control the development process and quality, and improves the efficiency of integrating asset data from different business types.

[0097] Figure 5 A schematic diagram of the structure of an electronic device provided in an embodiment of this application is shown.

[0098] The electronic device 500 may include a processor 501 and a memory 502 storing computer program instructions.

[0099] Specifically, the processor 501 may include a central processing unit (CPU), an application-specific integrated circuit (ASIC), or one or more integrated circuits that can be configured to implement the embodiments of this application.

[0100] Memory 502 may include mass storage for data or instructions. For example, and not limitingly, memory 502 may include a hard disk drive (HDD), floppy disk drive, flash memory, optical disk, magneto-optical disk, magnetic tape, or Universal Serial Bus (USB) drive, or a combination of two or more of these. Where appropriate, memory 502 may include removable or non-removable (or fixed) media. Where appropriate, memory 502 may be internal or external to the integrated gateway disaster recovery device. In a particular embodiment, memory 502 is non-volatile solid-state memory.

[0101] In a particular embodiment, memory 502 includes read-only memory (ROM). Where suitable, the ROM may be a mask-programmed ROM, a programmable ROM (PROM), an erasable PROM (EPROM), an electrically erasable PROM (EEPROM), an electrically rewritable ROM (EAROM), or flash memory, or a combination of two or more of these. Memory may include read-only memory (ROM), random access memory (RAM), disk storage media devices, optical storage media devices, flash memory devices, electrical, optical, or other physical / tangible memory storage devices. Thus, generally, memory includes one or more tangible (non-transitory) computer-readable storage media (e.g., memory devices) encoded with software including computer-executable instructions, and when the software is executed (e.g., by one or more processors), it is operable to perform the operations described with reference to the method according to one aspect of this disclosure.

[0102] The processor 501 reads and executes computer program instructions stored in the memory 502 to implement any of the structured parameter table configuration methods in the above embodiments.

[0103] In one example, the electronic device 500 may also include a communication interface 503 and a bus 510. For example, Figure 5 As shown, the processor 501, memory 502, and communication interface 503 are connected through bus 510 and complete communication with each other.

[0104] The communication interface 503 is mainly used to realize communication between various modules, devices, units and / or equipment in the embodiments of this application.

[0105] Bus 510 includes hardware, software, or both, that couples components of a structured parameter table configuration device together. For example, and not limitingly, the bus may include an Accelerated Graphics Port (AGP) or other graphics bus, an Enhanced Industry Standard Architecture (EISA) bus, a Front Side Bus (FSB), HyperTransport (HT) interconnect, an Industry Standard Architecture (ISA) bus, an Infinite Bandwidth Interconnect, a Low Pin Count (LPC) bus, a memory bus, a Microchannel Architecture (MCA) bus, a Peripheral Component Interconnect (PCI) bus, a PCI-Express (PCI-X) bus, a Serial Advanced Technology Attachment (SATA) bus, a Video Electronics Standards Association Local (VLB) bus, or other suitable buses, or combinations of two or more of these. Where appropriate, bus 510 may include one or more buses. Although specific buses are described and illustrated in embodiments of this application, this application contemplates any suitable bus or interconnect.

[0106] For example, the electronic device 500 can be a mobile phone, tablet computer, laptop computer, handheld computer, in-vehicle electronic device, ultra-mobile personal computer (UMPC), netbook, or personal digital assistant (PDA), etc.

[0107] The electronic device 500 can execute the configuration method of the structured parameter table in the embodiments of this application, thereby achieving the combination Figure 1 and Figure 4 The method and apparatus for configuring a structured parameter table are described.

[0108] Furthermore, in conjunction with the structured parameter table configuration method in the above embodiments, this application embodiment can provide a computer storage medium for implementation. This computer storage medium stores computer program instructions; when these computer program instructions are executed by a processor, they implement any of the structured parameter table configuration methods in the above embodiments.

[0109] It should be clarified that this application is not limited to the specific configurations and processes described above and shown in the figures. For the sake of brevity, detailed descriptions of known methods are omitted here. In the above embodiments, several specific steps are described and shown as examples. However, the method process of this application is not limited to the specific steps described and shown. Those skilled in the art can make various changes, modifications, and additions, or change the order of steps, after understanding the spirit of this application.

[0110] The functional blocks shown in the above-described structural diagram can be implemented as hardware, software, firmware, or a combination thereof. When implemented in hardware, they can be, for example, electronic circuits, application-specific integrated circuits (ASICs), appropriate firmware, plug-ins, function cards, etc. When implemented in software, the elements of this application are programs or code segments used to perform the required tasks. Programs or code segments can be stored on a machine-readable medium or transmitted over a transmission medium or communication link via data signals carried on a carrier wave. "Machine-readable medium" can include any medium capable of storing or transmitting information. Examples of machine-readable media include electronic circuits, semiconductor memory devices, ROM, flash memory, erasable ROM (EROM), floppy disks, CD-ROMs, optical disks, hard disks, fiber optic media, radio frequency (RF) links, etc. Code segments can be downloaded via computer networks such as the Internet, intranets, etc.

[0111] It should also be noted that the exemplary embodiments mentioned in this application describe methods or systems based on a series of steps or apparatus. However, this application is not limited to the order of the above steps; that is, the steps can be performed in the order mentioned in the embodiments, or in a different order, or several steps can be performed simultaneously.

[0112] The aspects of this disclosure have been described above with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this disclosure. It should be understood that each block in the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing apparatus to produce a machine such that these instructions, executable via the processor of the computer or other programmable data processing apparatus, enable the implementation of the functions / actions specified in one or more blocks of the flowchart illustrations and / or block diagrams. Such a processor can be, but is not limited to, a general-purpose processor, a special-purpose processor, a special application processor, or a field-programmable logic circuit. It is also understood that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can also be implemented by special-purpose hardware performing the specified functions or actions, or can be implemented by a combination of special-purpose hardware and computer instructions.

[0113] The above description is merely a specific implementation of this application. Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the systems, modules, and units described above can be referred to the corresponding processes in the foregoing method embodiments, and will not be repeated here. It should be understood that the protection scope of this application is not limited thereto. Any person skilled in the art can easily conceive of various equivalent modifications or substitutions within the technical scope disclosed in this application, and these modifications or substitutions should all be covered within the protection scope of this application.

Claims

1. A method for configuring a structured parameter table, characterized in that, The method includes: Obtain different business types from multiple banks; For each business type, set multiple corresponding parameter items, including business number, mapping category, mapping subcategory, source table English name, source table Chinese name, target table English name, target table Chinese name, data retrieval sequence number, and mapping description; The different business types of the multiple banks are grouped according to different measurement methods to obtain a business parameter table. Each business type corresponds to multiple sub-business types, and the multiple sub-business types correspond to the same measurement method. Based on the business parameter table, a main parameter table, an association parameter table, and a field parameter table are generated sequentially. The main parameter table is used to configure the data source and filtering conditions for different business types. The association parameter table is used to configure the association tables and relationships required to complete data processing. The field parameter table is used to configure field-level processing information. Obtain the processing script, which is a processing rule written corresponding to the business parameter table, the main parameter table, the associated parameter table and the field parameter table; According to the processing script, the data information in the business parameter table, the main parameter table, the associated parameter table, and the field parameter table are processed to obtain processing statements. The processing statements are used to implement the measurement processing process within the risk-weighted asset system.

2. The method according to claim 1, characterized in that, After grouping the different business types of the multiple banks according to different measurement methods to obtain a business parameter table, the method further includes: Determine the key parameters for each of the aforementioned business types, where the key parameters are the key information in the corresponding business type mapping description; The different business types of the multiple banks are sorted according to the grouping order to obtain the main parameter table. The main parameter table includes the key parameters, the business number, the mapping category, the mapping number, the English name of the source table, the Chinese name of the source table, the alias of the source table, whether the source table is a physical table, and whether the target table is a physical table.

3. The method according to claim 2, characterized in that, After sorting the different business types of the multiple banks according to the grouping order to obtain the master parameter table, the method further includes: Based on the key parameters of each business type, multiple associated parameters for each business type are obtained. The multiple associated parameters are multiple associated information included in the corresponding business type, including customer identifier, customer name, and customer country. The multiple associated parameters are sorted according to the grouping order of their corresponding business types to obtain an associated parameter table. The associated parameter table includes the business number, the mapping number, the English name of the associated table, the alias of the associated table, whether the associated table is a physical table, the associated keyword, the associated sequence number, and the associated parameters.

4. The method according to claim 3, characterized in that, After sorting the multiple associated parameters according to their corresponding business type grouping order to obtain the associated parameter table, the method further includes: Retrieve the field values ​​of multiple associated parameters for each of the aforementioned business types; The field values ​​are sorted according to the business number of each business type to obtain a field parameter table. The field parameter table includes the business number, the mapping number, the field sequence number, the target field name, the field value condition, whether it is a constant, and the field value description.

5. The method according to any one of claims 1-4, characterized in that, The method includes: Store the business parameter table, main parameter table, related parameter table, and field parameter table in a relational database; The parameter table in the relational database is sent to the batch processing server, which is a server that processes the data information in the parameter table.

6. The method according to claim 5, characterized in that, After obtaining the processing statement, the method further includes: The processing statements are then visualized.

7. A configuration device for a structured parameter table, characterized in that, The device includes: The acquisition module is used to acquire different business types from multiple banks. The settings module is used to set multiple parameter items for each business type. These multiple parameter items include business number, mapping category, mapping subcategory, source table English name, source table Chinese name, target table English name, target table Chinese name, data retrieval sequence number, and mapping description. The grouping module is used to group the different business types of the multiple banks according to different measurement methods to obtain a business parameter table. Each business type will correspond to multiple sub-business types, and the multiple sub-business types will correspond to the same measurement method. The acquisition module is further configured to generate a main parameter table, an association parameter table, and a field parameter table sequentially based on the business parameter table. The main parameter table is used to configure the data source and filtering conditions for different business types. The association parameter table is used to configure the association tables and relationships required to complete data processing. The field parameter table is used to configure field-level processing information. The acquisition module is also used to acquire a processing script, wherein the processing script is a processing rule written corresponding to the business parameter table, the main parameter table, the associated parameter table and the field parameter table; The processing module is used to process the data information in the business parameter table, the main parameter table, the associated parameter table and the field parameter table according to the processing script to obtain processing statements. The processing statements are used to implement the measurement processing process in the risk-weighted asset system.

8. An electronic device, characterized in that, The electronic device includes: Processor and memory storing computer program instructions; When the processor executes the computer program instructions, it implements the configuration method of the structured parameter table as described in any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer program instructions, which, when executed by a processor, implement the configuration method of the structured parameter table as described in any one of claims 1-6.

10. A computer program product, characterized in that, When the instructions in the computer program product are executed by the processor of the electronic device, the electronic device is able to perform the configuration method of the structured parameter table as described in any one of claims 1-6.

Images