CN116662351A - Bank data acquisition method and system - Google Patents
Bank data acquisition method and system Download PDFInfo
- Publication number
- CN116662351A CN116662351A CN202310957222.1A CN202310957222A CN116662351A CN 116662351 A CN116662351 A CN 116662351A CN 202310957222 A CN202310957222 A CN 202310957222A CN 116662351 A CN116662351 A CN 116662351A
- Authority
- CN
- China
- Prior art keywords
- data
- bank
- business
- service
- storage
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000013500 data storage Methods 0.000 claims abstract description 75
- 238000013523 data management Methods 0.000 claims abstract description 18
- 238000013480 data collection Methods 0.000 claims abstract description 12
- 238000012550 audit Methods 0.000 claims description 22
- 238000012795 verification Methods 0.000 claims description 18
- 238000010586 diagram Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims 2
- 238000012545 processing Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Human Resources & Organizations (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Economics (AREA)
- Marketing (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a bank data acquisition method and system, comprising the following steps: if the data storage mode of the first bank is data centralized storage type, collecting first service data from a data management system of the first bank, checking the first service data according to the checking relation of the first bank, and taking the first service data as first storage data when the checking is successful; and if the data storage mode of the second bank is data scattered storage mode, collecting second business data of each data storage system of the second bank and storing the second business data in each intermediate table, checking the second business data of each intermediate table according to the checking relation of each intermediate table, importing the second business data of each intermediate table into a business database after the checking is passed, checking the second business data in the business database according to the checking relation of the second bank, and taking the second business data in the business database as second storage data after the checking is passed. The method can collect the bank data based on different data storage modes, and improves the efficiency of bank data collection.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a bank data acquisition method and a bank data acquisition system.
Background
In the current general case, banks are generally classified into set up headquarters, provincial branches, municipal branches and branches. Each branch or branch can adopt a self-established data storage mode to store the bank data. Generally, when bank data is collected, each bank point gathers the bank data of the present bank and then uploads the bank data to a bank data management system. Because the bank data volume is large and the operation of each bank is not uniform, the bank data acquisition mode is long in time consumption and low in efficiency.
Disclosure of Invention
The invention aims to overcome the defects of the prior art, provides a bank data acquisition method and a bank data acquisition system, can automatically identify a data storage mode of a bank, acquire and store bank data by adopting a data acquisition mode corresponding to the data storage mode based on different data storage modes, does not need to participate manually, shortens the time of bank data acquisition, and improves the efficiency of bank data acquisition.
In order to solve at least one of the above technical problems, an embodiment of the present invention provides a method for collecting bank data, including:
identifying a data storage mode of each bank of the plurality of banks;
if the data storage mode of the first bank is data centralized storage type, collecting first service data from a data management system of the first bank, reading first service information of the first bank, determining a first audit relation according to the first service information, checking the first service data according to the first audit relation, if the check is successful, taking the first service data as first storage data, if the check is unsuccessful, prompting the service data which are failed to check in the first service data to perform manual check, receiving the service data which are modified manually, and taking the service data which are successful to check in the service data which are modified manually as first storage data;
if the data storage mode of the second bank is data scattered storage mode, a plurality of data storage systems of the second bank are identified, second business data of each data storage system are collected and stored in each intermediate table, second business information of each data storage system is read, second auditing relations of each intermediate table are determined according to each second business information, the second business data of each intermediate table are verified according to each second auditing relation, after verification of the second business data of each intermediate table is confirmed to pass, the second business data of each intermediate table are imported into a business database, third business information of the second bank is read, third auditing relation of the business database is determined according to the third business information, the second business data in the business database is verified according to the third auditing relations, and after verification is passed, the second business data in the business database are used as second storage data.
Preferably, after the step of verifying the second service data of each intermediate table according to each second audit relation, the method further includes:
if the second service data of any intermediate table fails to check, prompting the service data which fails to check in the second service data of any intermediate table to perform manual check, and receiving the modified data of the service data which fails to check in the second service data manually so as to enable the second service data of any intermediate table to pass the check.
Preferably, after the step of verifying the second service data in the service database according to the third audit relation, the method further includes:
if the verification of the second service data in the service database fails, prompting the service data which fails to be verified in the second service data in the service database to conduct manual verification, and receiving the modified data of the service data which fails to be verified in the second service data in the service database manually so as to enable the verification of the second service data in the service database to pass.
Preferably, after the second service data of each intermediate table is imported into the service database, the method further includes:
after confirming that the second service data in each intermediate table is imported into the service database, deleting each intermediate table.
Preferably, the first business data comprises data in a liability statement of a first bank and/or the second business data comprises data in a liability statement of a second bank.
Preferably, the first service data further includes data in a profit-and-loss table of the first bank, and/or the second service data further includes data in a profit-and-loss table of the second bank.
Preferably, the method further comprises:
identifying a version of a banking system of the first bank and a version of a banking system of the second bank;
if the version of the bank system of the first bank is the same as the version of the bank system of the second bank, merging the first storage data and the second storage data into the same data table for storage according to a set storage format;
if the version of the bank system of the first bank is different from the version of the bank system of the second bank, the first storage data and the second storage data are respectively stored in different data tables according to a set storage format, the low-version bank in the version of the bank system of the first bank and the low-version bank in the version of the bank system of the second bank is determined, and the low-version bank is subjected to version upgrading prompt to prompt upgrading of the bank system corresponding to the low-version bank.
Preferably, the method further comprises:
reading the data magnitude of the first bank and the data magnitude of the second bank in a set historical time period;
determining the data acquisition frequency of the first bank according to the data magnitude of the first bank, and determining the data acquisition frequency of the second bank according to the data magnitude of the second bank;
if the data magnitude of the first bank is larger than that of the second bank, the data acquisition frequency of the first bank is larger than that of the second bank;
the collecting the first business data from the data management system of the first bank comprises the following steps: collecting first business data from a data management system of a first bank according to the data collection frequency of the first bank;
the collecting the second service data of each data storage system comprises the following steps: and collecting second business data of each data storage system according to the data collection frequency of the second bank.
Preferably, the first service information is determined based on a service flow chart of the first bank, the second service information of each data storage system is determined based on service flow information recorded in a data table of each data storage system, and the third service information is determined based on a service flow chart of the second bank.
In addition, the embodiment of the invention also provides a bank data acquisition system, which comprises: the system comprises a memory, a processor and an application program stored on the memory and capable of running on the processor, wherein the processor realizes the steps of the method of any embodiment when executing the application program.
In the method and the system for acquiring the bank data, if the data storage mode of the bank is data centralized storage, service data are directly acquired from the data management system of the bank and are checked based on the corresponding audit relation, and the data are used as first storage data when the check passes. If the data storage mode of the bank is data scattered storage mode, collecting service data from each data storage system of the bank to corresponding intermediate tables, checking based on corresponding audit relations of each data storage system, importing the service data of all intermediate tables into a service database when the check is passed, checking all service data again based on corresponding audit relations, and serving as second storage data when the check is passed. Therefore, the data storage modes of the bank can be automatically identified, the bank data are collected and stored by adopting the corresponding data collection modes based on different data storage modes, manual participation is not needed, the time for collecting the bank data is shortened, and the efficiency for collecting the bank data is improved.
Drawings
FIG. 1 is an application environment diagram of a bank data collection method in an embodiment of the invention;
FIG. 2 is a schematic flow chart of a bank data collection method according to an embodiment of the invention;
fig. 3 is a schematic structural diagram of a bank data acquisition system according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The bank data acquisition method provided by the invention is applied to an application environment shown in figure 1. As shown in fig. 1, the bank data acquisition system is used for executing a bank data acquisition method of the present invention. Specifically, as shown in fig. 1, a terminal system of the first bank and a data management system of the first bank are configured in the first bank. The terminal system of the first bank is used for providing business operation of the first bank and generating a plurality of first business data. The data management system of the first bank is used for storing a plurality of first business data generated by the terminal system of the first bank. The bank data acquisition system acquires a plurality of first business data from the data management system and takes the first business data as first storage data after the first business data passes verification. The first stored data is stored in an internal data storage area of the bank data acquisition system.
As shown in fig. 1, the second bank is provided with a terminal system of the second bank and a plurality of data storage systems of the second bank. The terminal system of the second bank is used for providing business operation of the second bank and generating a plurality of second business data. The plurality of data storage systems of the second bank are used for respectively storing a plurality of second business data according to the set data storage requirements. For example, fig. 1 shows a data storage system 1, a data storage system 2, and a data storage system n, n being a natural number greater than 2.
The bank data acquisition system provided by the invention is provided with a business database and a plurality of intermediate tables. For example, as shown in fig. 1, fig. 1 shows intermediate table 1, intermediate table 2, and intermediate table n, where n is a natural number greater than 2. In fig. 1, "…" indicates that a part not shown is omitted when the number is plural more than 2. Specifically, when the bank data acquisition system acquires second business data of the second bank, the second business data are respectively acquired from each data storage system of the second bank, and each second business data are stored in each intermediate table. For example, as shown in fig. 1, each data storage system of the second bank includes a data storage system 1, a data storage system 2, and a data storage system n, and each intermediate table is an intermediate table 1, an intermediate table 2, and an intermediate table n. And further, reading second service information of each data storage system, determining a second checking relation of each intermediate table according to each second service information, checking the second service data of each intermediate table according to each second checking relation, and importing the second service data of each intermediate table into a service database after checking that the second service data of each intermediate table passes. And further, reading third business information of the second bank, determining a third auditing relation of the business database according to the third business information, checking second business data in the business database according to the third auditing relation, and taking the second business data in the business database as second storage data after the second business data pass the checking. The second stored data is stored in an internal data storage area of the bank data acquisition system.
The bank data acquisition method provided by the invention is applied to a bank data acquisition system shown in figure 1. As shown in fig. 2, the method for acquiring bank data of the present invention comprises the following steps:
s201, identifying a data storage mode of each bank in the plurality of banks.
Specifically, the plurality of banks may include a plurality of branches of the same commercial bank, or may be a plurality of commercial banks. The data storage modes of the banks can be the same or different due to different internal management modes. The data storage mode may include a data-concentrated storage type and a data-dispersed storage type. The data set storage type is used for indicating that the data in the bank is stored in only one data storage area, and the data scattered storage type is used for indicating that the data in the bank is stored in a plurality of data storage areas. Referring to fig. 1, the bank data acquisition system identifies a data storage mode of each bank among a plurality of banks, and performs bank data acquisition based on the data storage mode of each bank.
S202, if the data storage mode of the first bank is data centralized storage, first business data are collected from a data management system of the first bank, first business information of the first bank is read, a first audit relation is determined according to the first business information, the first business data are checked according to the first audit relation, if the check is successful, the first business data are used as first storage data, if the check is failed, the business data which fail to check in the first business data are prompted to be manually checked, the manually modified business data are received, and the business data which succeed in checking in the first business data are used as first storage data.
Specifically, as shown in connection with fig. 1, when the data management system of the first bank is used to store the first business data of the first bank. The first service information refers to service reference information of the first bank processing banking data. The first audit relation is determined based on the first business information, the relation between the businesses of the first bank can be determined through the first audit relation, and then the relation between the first business data is determined, so that the first business data can be checked according to the first audit relation, and if the check is successful, the first business data are confirmed. At this time, the first service data may be stored as first storage data. If the verification fails, prompting the service data which fails to be verified in the first service data to perform manual verification. After the manual check, manual check modification is performed, and the service data after manual modification is input. And taking the service data successfully verified in the manually modified service data and the first service data as first storage data.
And S203, if the data storage mode of the second bank is data scattered storage, identifying a plurality of data storage systems of the second bank, collecting second business data of each data storage system, storing each second business data in each intermediate table, reading second business information of each data storage system, determining a second auditing relation of each intermediate table according to each second business information, checking the second business data of each intermediate table according to each second auditing relation, after checking that the second business data of each intermediate table passes, importing the second business data of each intermediate table into a business database, reading third business information of the second bank, determining a third auditing relation of the business database according to the third business information, checking the second business data in the business database according to the third auditing relation, and taking the second business data in the business database as second storage data after checking.
In one example, after the step of verifying the second service data of each intermediate table according to each second audit relation, the method further includes: if the second service data of any intermediate table fails to check, prompting the service data which fails to check in the second service data of any intermediate table to perform manual check, and receiving the modified data of the service data which fails to check in the second service data manually so as to enable the second service data of any intermediate table to pass the check.
Preferably, after the step of verifying the second service data in the service database according to the third audit relation, the method further includes: if the verification of the second service data in the service database fails, prompting the service data which fails to be verified in the second service data in the service database to conduct manual verification, and receiving the modified data of the service data which fails to be verified in the second service data in the service database manually so as to enable the verification of the second service data in the service database to pass.
Preferably, after the second service data of each intermediate table is imported into the service database, the method further includes: after confirming that the second service data in each intermediate table is imported into the service database, deleting each intermediate table.
Specifically, referring to fig. 1, after identifying a plurality of data storage systems of the second bank, setting a plurality of intermediate tables, where each intermediate table is used to store second service data of each data storage system, determining each second audit relation based on second service information of each data storage system, and verifying the second service data of each intermediate table according to each second audit relation. After the verification is passed, the verification is concentrated and stored in the service database, a third auditing relation of the service database is determined based on third service information of the second bank, and all second service data in the service database are verified again by using the third auditing relation. Therefore, the accuracy of the second service data can be ensured to be obtained and then stored.
And deleting each intermediate table after confirming that the second service data in each intermediate table is imported into the service database. Therefore, the resources can be released, and the occupation of the resources is reduced.
In one example, the first business data includes data in a liability statement of a first bank and/or the second business data includes data in a liability statement of a second bank.
In one example, the first business data further includes data in a profit-and-loss table of the first bank and/or the second business data further includes data in a profit-and-loss table of the second bank.
In one example, after step S203, further includes: identifying a version of a banking system of the first bank and a version of a banking system of the second bank; if the version of the bank system of the first bank is the same as the version of the bank system of the second bank, merging the first storage data and the second storage data into the same data table for storage according to a set storage format; if the version of the bank system of the first bank is different from the version of the bank system of the second bank, the first storage data and the second storage data are respectively stored in different data tables according to a set storage format, the low-version bank in the version of the bank system of the first bank and the low-version bank in the version of the bank system of the second bank is determined, and the low-version bank is subjected to version upgrading prompt to prompt upgrading of the bank system corresponding to the low-version bank.
Specifically, when the first stored data and the second stored data are stored, the version of the banking system of the first bank and the version of the banking system of the second bank are determined first. When the two versions are the same, the first storage data and the second storage data are combined into the same data table for storage. When the two versions are different, the first storage data and the second storage data are respectively stored in different data tables, and prompt the banks with low versions to prompt version upgrade so as to upgrade the bank systems corresponding to the banks with low versions, thereby effectively managing the bank systems of each bank.
Preferably, before the step of collecting the first service data from the data management system of the first bank and before the step of collecting the second service data of each data storage system, the method further comprises: reading the data magnitude of the first bank and the data magnitude of the second bank in a set historical time period; determining the data acquisition frequency of the first bank according to the data magnitude of the first bank, and determining the data acquisition frequency of the second bank according to the data magnitude of the second bank; if the data magnitude of the first bank is larger than that of the second bank, the data acquisition frequency of the first bank is larger than that of the second bank; the collecting the first business data from the data management system of the first bank comprises the following steps: collecting first business data from a data management system of a first bank according to the data collection frequency of the first bank; the collecting the second service data of each data storage system comprises the following steps: and collecting second business data of each data storage system according to the data collection frequency of the second bank.
Specifically, the data acquisition frequency of the first bank and the data acquisition frequency of the second bank are respectively determined based on the data magnitude of the first bank and the data magnitude of the second bank in the same time period. If the data magnitude of the first bank is larger than that of the second bank, the data acquisition frequency of the first bank is larger than that of the second bank. And conversely, the data acquisition frequency of the first bank is smaller than or equal to the data acquisition frequency of the second bank. Different data orders determine different data acquisition frequencies, and the larger the data acquisition frequency determined by the large data orders, so that the resource occupation pressure caused by simultaneously acquiring the bank data of a plurality of banks at the same time can be avoided while the bank data acquisition efficiency is provided.
In one example, the first business information is determined based on a business flow chart of the first bank, the second business information of each data storage system is determined based on business flow information recorded in a data table of each data storage system, and the third business information is determined based on a business flow chart of the second bank.
Specifically, in order to facilitate management of banking data for each bank, each bank manages specific business information using a business flow chart. Thus, the first business information may be determined through a business flow diagram of the first bank. And determining second business information based on the business process information recorded in the data table of each data storage system. Third business information is determined based on the business flow diagram of the second bank. Furthermore, the auditing relation corresponding to each business data can be determined.
In the bank data acquisition method, if the data storage mode of the bank is data centralized storage, service data are directly acquired from the data management system of the bank and are checked based on the corresponding checking relation, and the data are used as the first storage data when the check passes. If the data storage mode of the bank is data scattered storage mode, collecting service data from each data storage system of the bank to corresponding intermediate tables, checking based on corresponding audit relations of each data storage system, importing the service data of all intermediate tables into a service database when the check is passed, checking all service data again based on corresponding audit relations, and serving as second storage data when the check is passed. Therefore, the data storage modes of the bank can be automatically identified, the bank data are collected and stored by adopting the corresponding data collection modes based on different data storage modes, manual participation is not needed, the time for collecting the bank data is shortened, and the efficiency for collecting the bank data is improved.
The invention also provides a bank data acquisition system, as shown in figure 3. The bank data acquisition system comprises a processor 302, a memory 303, an input unit 304, a display unit 305 and the like. It will be appreciated by those skilled in the art that the device architecture shown in fig. 3 does not constitute a limitation of all devices, and may include more or fewer components than shown, or may combine certain components. The memory 303 may be used to store an application 301 and various functional modules, and the processor 302 runs the application 301 stored in the memory 303, thereby performing various functional applications of the device and data processing. The memory may be internal memory or external memory, or include both internal memory and external memory. The internal memory may include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), flash memory, or random access memory. The external memory may include a hard disk, floppy disk, ZIP disk, U-disk, tape, etc. The disclosed memory includes, but is not limited to, these types of memory. The memory disclosed herein is by way of example only and not by way of limitation.
The input unit 304 is used for receiving input of a signal and receiving keywords input by a user. The input unit 304 may include a touch panel and other input devices. The touch panel may collect touch operations on or near the user (e.g., the user's operation on or near the touch panel using any suitable object or accessory such as a finger, stylus, etc.), and drive the corresponding connection device according to a preset program; other input devices may include, but are not limited to, one or more of a physical keyboard, function keys (e.g., play control keys, switch keys, etc.), a trackball, mouse, joystick, etc. The display unit 305 may be used to display information input by a user or information provided to the user and various menus of the terminal device. The display unit 305 may take the form of a liquid crystal display, an organic light emitting diode, or the like. The processor 302 is a control center of the terminal device, connects various parts of the entire device using various interfaces and lines, performs various functions and processes data by running or executing software programs and/or modules stored in the memory 303, and invoking data stored in the memory.
As one embodiment, the computer device includes: the system comprises one or more processors 302, a memory 303, one or more application programs 301, wherein the one or more application programs 301 are stored in the memory 303 and configured to be executed by the one or more processors 302, and the one or more application programs 301 are configured to perform a bank data collection method in any of the above embodiments.
In addition, the above description has been made in detail on a method and a system for acquiring bank data provided by the embodiment of the present invention, and specific examples should be adopted herein to illustrate the principles and implementation modes of the present invention, and the description of the above embodiments is only for helping to understand the method and core ideas of the present invention; meanwhile, as those skilled in the art will have variations in the specific embodiments and application scope in accordance with the ideas of the present invention, the present description should not be construed as limiting the present invention in view of the above.
Claims (10)
1. A method for collecting bank data, the method comprising:
identifying a data storage mode of each bank of the plurality of banks;
if the data storage mode of the first bank is data centralized storage type, collecting first service data from a data management system of the first bank, reading first service information of the first bank, determining a first audit relation according to the first service information, checking the first service data according to the first audit relation, if the check is successful, taking the first service data as first storage data, if the check is unsuccessful, prompting the service data which are failed to check in the first service data to perform manual check, receiving the service data which are modified manually, and taking the service data which are successful to check in the service data which are modified manually as first storage data;
if the data storage mode of the second bank is data scattered storage mode, a plurality of data storage systems of the second bank are identified, second business data of each data storage system are collected and stored in each intermediate table, second business information of each data storage system is read, second auditing relations of each intermediate table are determined according to each second business information, the second business data of each intermediate table are verified according to each second auditing relation, after verification of the second business data of each intermediate table is confirmed to pass, the second business data of each intermediate table are imported into a business database, third business information of the second bank is read, third auditing relation of the business database is determined according to the third business information, the second business data in the business database is verified according to the third auditing relations, and after verification is passed, the second business data in the business database are used as second storage data.
2. The method of claim 1, wherein after the step of verifying the second service data of each intermediate table according to each second audit relation, further comprising:
if the second service data of any intermediate table fails to check, prompting the service data which fails to check in the second service data of any intermediate table to perform manual check, and receiving the modified data of the service data which fails to check in the second service data manually so as to enable the second service data of any intermediate table to pass the check.
3. The method of claim 1, wherein after the step of verifying the second service data in the service database according to the third audit relationship, further comprising:
if the verification of the second service data in the service database fails, prompting the service data which fails to be verified in the second service data in the service database to conduct manual verification, and receiving the modified data of the service data which fails to be verified in the second service data in the service database manually so as to enable the verification of the second service data in the service database to pass.
4. The method of claim 1, wherein after the importing the second service data of each intermediate table into the service database, further comprising:
after confirming that the second service data in each intermediate table is imported into the service database, deleting each intermediate table.
5. The method of claim 1, wherein the first business data comprises data in a liability statement of a first bank and/or the second business data comprises data in a liability statement of a second bank.
6. The method of claim 5, wherein the first business data further comprises data in a profit-and-loss table of a first bank and/or the second business data further comprises data in a profit-and-loss table of a second bank.
7. The method according to claim 1, wherein the method further comprises:
identifying a version of a banking system of the first bank and a version of a banking system of the second bank;
if the version of the bank system of the first bank is the same as the version of the bank system of the second bank, merging the first storage data and the second storage data into the same data table for storage according to a set storage format;
if the version of the bank system of the first bank is different from the version of the bank system of the second bank, the first storage data and the second storage data are respectively stored in different data tables according to a set storage format, the low-version bank in the version of the bank system of the first bank and the low-version bank in the version of the bank system of the second bank is determined, and the low-version bank is subjected to version upgrading prompt to prompt upgrading of the bank system corresponding to the low-version bank.
8. The method of claim 7, wherein the method further comprises:
reading the data magnitude of the first bank and the data magnitude of the second bank in a set historical time period;
determining the data acquisition frequency of the first bank according to the data magnitude of the first bank, and determining the data acquisition frequency of the second bank according to the data magnitude of the second bank;
if the data magnitude of the first bank is larger than that of the second bank, the data acquisition frequency of the first bank is larger than that of the second bank;
the collecting the first business data from the data management system of the first bank comprises the following steps: collecting first business data from a data management system of a first bank according to the data collection frequency of the first bank;
the collecting the second service data of each data storage system comprises the following steps: and collecting second business data of each data storage system according to the data collection frequency of the second bank.
9. The method of claim 1, wherein the first business information is determined based on a business flow diagram of the first bank, the second business information for each data storage system is determined based on business flow information recorded in a data table for each data storage system, and the third business information is determined based on a business flow diagram of the second bank.
10. A bank data acquisition system comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any one of claims 1 to 9 when the computer program is executed by the processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310957222.1A CN116662351B (en) | 2023-08-01 | 2023-08-01 | Bank data acquisition method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310957222.1A CN116662351B (en) | 2023-08-01 | 2023-08-01 | Bank data acquisition method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116662351A true CN116662351A (en) | 2023-08-29 |
| CN116662351B CN116662351B (en) | 2023-10-03 |
Family
ID=87722855
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310957222.1A Active CN116662351B (en) | 2023-08-01 | 2023-08-01 | Bank data acquisition method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116662351B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117436419A (en) * | 2023-12-12 | 2024-01-23 | 佳瑛科技有限公司 | Control method and device for automatically updating goods registration report data |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20100010408A (en) * | 2008-07-22 | 2010-02-01 | 주식회사 우리은행 | Integrating management system for supporting for service of bank and method of the same |
| US20140074673A1 (en) * | 2012-09-12 | 2014-03-13 | First Data Corporation | System and method for maintaining employment eligibility and bank customer information |
| CN112508346A (en) * | 2020-11-17 | 2021-03-16 | 四川新网银行股份有限公司 | Method for realizing indexed business data auditing |
| CN114461620A (en) * | 2022-01-11 | 2022-05-10 | 新天绿色能源股份有限公司 | Distributed energy data fusion and application method based on multi-source isomerism |
| CN115630621A (en) * | 2022-11-07 | 2023-01-20 | 厦门天健财智科技有限公司 | PDF financial data report form-based data acquisition and processing method and system |
| CN115952224A (en) * | 2022-12-28 | 2023-04-11 | 浪潮数字粮储科技有限公司 | Heterogeneous report integration method, equipment and medium |
| CN116151204A (en) * | 2021-11-17 | 2023-05-23 | 贺玲 | Data checksum analysis system and implementation method |
| CN116521092A (en) * | 2023-06-30 | 2023-08-01 | 昆山工业大数据创新中心有限公司 | Industrial equipment data storage method and device |
-
2023
- 2023-08-01 CN CN202310957222.1A patent/CN116662351B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20100010408A (en) * | 2008-07-22 | 2010-02-01 | 주식회사 우리은행 | Integrating management system for supporting for service of bank and method of the same |
| US20140074673A1 (en) * | 2012-09-12 | 2014-03-13 | First Data Corporation | System and method for maintaining employment eligibility and bank customer information |
| CN112508346A (en) * | 2020-11-17 | 2021-03-16 | 四川新网银行股份有限公司 | Method for realizing indexed business data auditing |
| CN116151204A (en) * | 2021-11-17 | 2023-05-23 | 贺玲 | Data checksum analysis system and implementation method |
| CN114461620A (en) * | 2022-01-11 | 2022-05-10 | 新天绿色能源股份有限公司 | Distributed energy data fusion and application method based on multi-source isomerism |
| CN115630621A (en) * | 2022-11-07 | 2023-01-20 | 厦门天健财智科技有限公司 | PDF financial data report form-based data acquisition and processing method and system |
| CN115952224A (en) * | 2022-12-28 | 2023-04-11 | 浪潮数字粮储科技有限公司 | Heterogeneous report integration method, equipment and medium |
| CN116521092A (en) * | 2023-06-30 | 2023-08-01 | 昆山工业大数据创新中心有限公司 | Industrial equipment data storage method and device |
Non-Patent Citations (2)
| Title |
|---|
| 中国工商银行江苏省分行课题组;岳小勇;: "商业银行授信审批的大数据应用模式研究", 金融纵横, no. 09 * |
| 赵广慧;陈革;: "数据仓库在银行管理中的应用", 互联网周刊, no. 22 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117436419A (en) * | 2023-12-12 | 2024-01-23 | 佳瑛科技有限公司 | Control method and device for automatically updating goods registration report data |
| CN117436419B (en) * | 2023-12-12 | 2024-02-23 | 佳瑛科技有限公司 | Control method and device for automatically updating goods registration report data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116662351B (en) | 2023-10-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8151248B1 (en) | Method and system for software defect management | |
| CN110489699B (en) | Asynchronous data acquisition method and system | |
| US9183528B2 (en) | Generating a compliance data model for IT control | |
| CN107729376B (en) | Insurance data auditing method and device, computer equipment and storage medium | |
| US7827273B2 (en) | Machine cluster topology representation for automated testing | |
| CN116662351B (en) | Bank data acquisition method and system | |
| CN113515297B (en) | Version updating method and device, electronic equipment and storage medium | |
| CN111309586A (en) | Command testing method, device and storage medium thereof | |
| CN112671878B (en) | Block chain information subscription method, device, server and storage medium | |
| CN111752916A (en) | Data acquisition method and device, computer readable storage medium and electronic equipment | |
| CN113886259A (en) | Non-flow popup automatic processing method and system for bank counter system and electronic device | |
| CN111694724A (en) | Testing method and device of distributed table system, electronic equipment and storage medium | |
| CN111262727B (en) | Service capacity expansion method, device, equipment and storage medium | |
| CN105868191B (en) | Data processing method and device | |
| CN113535575A (en) | Benchmark testing method and device for basic environment of software and hardware product | |
| CN115437903A (en) | Interface test method, device, apparatus, storage medium, and program | |
| US8321844B2 (en) | Providing registration of a communication | |
| CN109658940A (en) | Update the method and system of speech recognition resources | |
| CN117149820B (en) | Borrowing operation detection method, device, equipment and storage medium | |
| CN114327377B (en) | Method and device for generating demand tracking matrix, computer equipment and storage medium | |
| CN112286804B (en) | System debugging method, device, equipment and medium | |
| CN109165208A (en) | It is a kind of for loading data into the method and system in database | |
| CN113190463B (en) | Code testing method, node and system | |
| CN116451976B (en) | Automatic production-based production flow configuration method and related equipment | |
| CN114692382B (en) | Management method and device for nuclear power simulation model development data and computer equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |