JPH11184957A - Method and system for updating account number provided in database for shop transfer joint processing of financial job such as bank - Google Patents

Abstract

PROBLEM TO BE SOLVED: To attain improvement efficiency in account number updating by preparing input data and simultaneously updating the account information of a object record in a data base. SOLUTION: After an account number comparator file 1 is prepared, an object account extracting function 5 extracts a record having the account number of a dispatch shop existent in an account number data base 3 corresponding to the account number of the dispatch shop stored in the account number comparator file 1. As an account number updating input data file 2, a updated input data preparing function 6 prepares the contents of the account number of the dispatch shop stored in the account number comparator file 7, the contents of the account number of a reception shop and retrieval information describing the contents of a record storage position. Afterwards, a data updating function 7 simultaneously reads all the data in the account number input data file 2, the record is retrieved from the contents of the retrieval information describing the record storage position of the object accounts of respective data, and the account number of the dispatch shop is updated to the account number of the reception shop.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an account number renewal method at the time of transfer in a financial business such as a bank, and in particular, in a bank business, customer information generated when a new store is installed or a customer is moved to another store. The present invention relates to an account number renewal method in a customer transfer and merging process in a silver number business such as a transfer.

[0002]

2. Description of the Related Art The transfer of customer information in the transfer and merging process of banking business involves erasing the customer information on the store side and recreating the information on the store side. It is necessary to re-input and restore the customer information to be transferred copied from the store to the store from the store visit, and there have been problems in terms of occurrence of input errors, work efficiency, and the like.

To cope with this problem, for example, Japanese Patent Application Laid-Open
Japanese Patent No. 2282348 discloses a customer copy function for copying information of a certain customer to another, an account number basic registration function for registering an old account number and a new account number at the time of transfer in an account number conversion table, and the customer copy function. Account number conversion query function to search the account number conversion table based on the customer's related account number transferred in the above, account number registration function to register the third party's related account number in the account number conversion table, account number An account number renewal function for updating the relevant account number of the customer transferred by the customer copying function based on the conversion table, and a customer information file for storing customer information for managing customer information. An account number renewal method has been proposed.

[0004] As a conventional method of changing account numbers in the transfer and merging process of the banking business, a method of successively updating the contents of an account number change database when a transfer and merger process is received is generally used.

[0005]

However, in the above-mentioned conventional method, in order to sequentially update the account number renewal database, every time the update is performed, all the records of the account number renewal database are searched and the renewal is performed. It is necessary to search for a corresponding account number to be replaced, and there is a problem that the search time increases as the number of registered data in the account number renewal database increases and the processing efficiency decreases.

[0006] The method of successively updating the account number renewal database has a problem in processing efficiency, and may affect other processes.

[0007] Accordingly, the present invention has been made in view of the above problems, and has as its object to improve the processing efficiency of rewriting the account number in the account number database without successively updating the account number renewal database. To provide a washing method and system which avoids affecting other processes.

[0008]

In order to achieve the above object, the present invention provides a method for refining customer account information held in a database in a merging and receiving process of a bank store and a store. With reference to a comparison file holding the account information of the receiving store as a pair, extracting the account information of the replacement target and the search information of the record holding the account information from the database to create the replacement input data, The account information of the record to be replaced in the database is rewritten collectively.

Preferably, the present invention creates a comparison file by associating the account information of the store before the change of the store transfer merging process with the account information of the store after the change, and creates the comparison file. A record of the account information of the store that exists in the database that stores the account information is extracted from the account information of the store that is stored in the store, and the account of the store that is stored in the comparison file is extracted by the extracted record. Information, account information of the store, and search information of the record,
It is created as a replacement input data file, the data of the replacement input data file is read in batch, a record is searched from search information indicating the record storage position of the account information of the replacement target of each data, and the data is transferred to the database. Replace the store account number with the store account number.

[0010] The system (system) of the present invention is a comparison file creating means for storing the account information of the store before the change of the store transfer merging process and the account information of the store after the change in the comparison file, and Information for a customer to be exchanged for extracting a record of account information of a store existing in a database storing account information of a customer and search information indicating a storage location of a record from account information of the store stored in the comparison file. Extraction means, and from the extracted record, a change input that creates as a change input data file the store account information, the store account information, and the search information of the record stored in the comparison file. Data creation means and the data of the replacement input data file are read in batch, and the record information is retrieved from the search information indicating the record storage position of the account information for the replacement. Searching, and a wash exchange data rewriting means for rewriting to the account number of 受店 from the account number of Doten of the database.

[0011]

BEST MODE FOR CARRYING OUT THE INVENTION The present invention relates to an account information to be updated in consideration of the nature of a banking database, in which there is a plurality of pieces of information that need to be rewritten when one account number is replaced. Renewal account number input data that is stored and retained in association with the search position is created, and a plurality of pieces of information that needs to be rewritten when one account number is renewed are rewritten collectively. An embodiment of the present invention will be described below.

[0012] The embodiment of the present invention comprises (1) an account number comparison file for holding a pair of the account numbers of a store to be replaced and a store, and (2) a record of a record of the database holding the account number. It is characterized in that the contents of the account number are changed at once.

The account number held in the database in the store transfer merging process of the banking business is changed when the account number of the store at the store to which the store is merged is determined, and the account numbers of the store at the store and the store at the store are merged. At any time after the creation of the account number comparison file containing the contents of the account, the data of the record of the account number to be replaced at the store held in the database is used to calculate the replacement account using the account number comparison file. The number input data file can be extracted, and the extracted refill input data file is collectively input at a certain point in time, thereby rewriting the account number renewal target database.

In the preferred embodiment of the present invention, (a) the account information of the store before the change of the store transfer and merging process is stored in the comparison file in correspondence with the account information of the store after the change. A comparison file creating means, and (b) a record of the account information of the store existing in the database storing the account information of the customer and the search information indicating the storage location of the record based on the account information of the store stored in the comparison file. And (c) using the extracted record, the account information of the store, the account information of the store, and the search information of the record, based on the extracted record, (D) collectively read the data of the replacement input data file, and read the data of the replacement target account information of each data. From the search information indicating the code storing position, and searches the record, and a wash exchange data rewriting means for rewriting to the account number of 受店 from the account number of Doten of the database. The functions of the respective means (a) to (d) are preferably realized under control of a program executed by an information processing device such as a computer.

In the embodiment of the present invention, an account number comparison file (1 in FIG. 1) is used in a comparison file creation function (4 in FIG. 1).
Is created and the account number comparison file is used to extract the contents of the account number data of the visiting store from the account number renewal database (3 in FIG. 1) by the account extraction function for renewal (5 in FIG. 1). .

An account number replacement input data file (2 in FIG. 1) is created by a replacement input data creation function (6 in FIG. 1) based on the account number comparison file, and the created account number replacement input data file is created. At the same time, and the account numbers of the store to be transferred and merged in the account number change database are collectively changed to the account numbers of the receiving store.

[0017]

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram showing an embodiment of the present invention; FIG. 1 is a block diagram showing the configuration of one embodiment of the present invention.

Referring to FIG. 1, the account number comparison file 1 contains an account number before renewing the account number (account number at the store) and an account number after renewing the account number (account number at the receiving side). ) Are stored in pairs. In the store transfer merging process of the banking business, the account number before the store transfer merging is moved to the store transfer merging destination, thereby changing the account number.

The account number before the change in the store transfer merging process and the account number after the change are stored in the account number comparison file 1 by the comparison file creation function 4.

After the account number comparison file 1 has been created, the record of the account number of the shop existing in the account number renewal database 3 is subject to the renewal according to the account number of the shop stored in the account number comparison file 1. The account is extracted by the account extracting function 5.

Based on the extracted records, the refilling input data creation function 6 parses the contents of the account number of the store and the account number of the store stored in the account number comparison file 1
The search information describing the contents of the record storage position is created as the account number renewal input data file 2.

After the account number renewal input data file 2 is created, all data in the account number renewal input data file 2 is read in batch by the renewal data rewriting function 7 and the data of the account to be renewed for each data is read. The record is searched from the contents of the search information describing the record storage position, and the account number of the store is rewritten to the account number of the store.

FIG. 2 is a diagram for explaining the operation of one embodiment of the present invention. The process for converting the account number renewal database 31 before renewal to the account number renewal database 32 after renewal is performed. It is a figure which shows a transition typically.

From the account number of the store in the account number comparison file 1 created by the comparison file creation function 4, the account extraction function 5 for renewal sequentially reads the account number renewal database 31 before the renewal, and After reading a record whose account number matches the account number of the store in the comparison file 1, search information (record search information) describing the storage location of the record, and the store and store of the account number comparison file 1 Is saved in the storage area.

Based on the saved contents, the refilling input data creating function 6 forms a set of the search information of the record of the account number renewal database to be renewed, the account number of the visiting store, and the account number of the receiving store. An account number renewal input data file 2, which is a collection of the collected data, is created.

The account number renewal input data file 2 is read in a batch, and the renewal data rewriting function 7 retrieves all the corresponding data records of the account number renewal database 31 before the renewal, and retrieves the account number of the store. Is rewritten to the account number of the store, and the account number renewal database 32 after the renewal is created.

FIG. 3 is a diagram showing an example of the contents of the account number comparison file 1 in one embodiment of the present invention. In the account number comparison file, the contents of the account number of the store and the account number of the store determined in the transfer and merge process are written by the comparison file creation function 4. In the account number comparison file 1, the store account information (store number, subject number, account number), which is the contents of the store account number, and the store account information, which is the contents of the store account number, are paired. Have information.

FIG. 4 is a diagram showing an example of the contents of the account number change database 3 in one embodiment of the present invention. The account number renewal database is composed of a group of records in a tree structure of several layers. Referring to FIG. 4, this example is composed of three layers, and the record of each layer holds some account information holding the contents of the account number.
In FIG. 4, the record of each layer has two pieces of account information.

Each record has, as search information (storage position information), information indicating the hierarchical level and the number of the record. That is, the number of digits of the numerical value of the search information of the record of each layer has the position of the layer, and the number of the search information has the number that positions the position of the record of the first layer and the second layer from the left.

For example, referring to FIG. 4, search information "1"
22 ”is a record of the third layer because the number of digits is 3, the record of the first layer is a record of“ 1 ”, the record of the second layer under the record is a record of“ 2 ”, and the record of the subordinate is“ 3 ”. This means that the record in the hierarchy is the record of “2”.

The renewal target account extraction function 5 sequentially reads the account information renewal database 3 shown in FIG. 4 from the first layer, and stores the account information held by the read record in the account information shown in FIG. If the account information matches the store visit information in the number comparison file, the search information (storage location information) of the read record, an account information number indicating which account information of the account information held in the record, Save the account information and the account information of the receiving store.

FIG. 5 is a diagram showing an example of the contents of the account number renewal input data file 2 in one embodiment of the present invention. Referring to FIG. 5, the account number renewal input data file 2 includes search information of a record to be renewed in the account number renewal database, an account information number indicating which account number of the record to be renewed is to be changed, It has store account information and store account information.

The account number renewal input data file 2 prepares the renewal input data based on the search information, the account information number, the account information of the store visit, and the account information of the store saved by the renewal target account extraction function 5. Created by function 6.

According to the account number change input data file,
Update the record of each level of the account number change database. Updating is performed by the replacement data rewriting function 7. The method of updating is to search the record of the account number renewal database based on the search information of the account number renewal input data file shown in FIG. If the account information matches the account information at the store, this is rewritten to the account information at the store in the account number renewal input data file. And. This rewriting process is repeated until there is no more data in the account number change input data file.

Next, another embodiment of the present invention will be described with reference to the drawings. FIG. 6 is a diagram showing the configuration of the second embodiment of the present invention.

Referring to FIG. 6, a second embodiment of the present invention is different from the first embodiment shown in FIG. The difference between the first embodiment and the first embodiment resides in that an interval between the data creation functions 6 is added, and the account to be exchanged is limited by adding the exchange condition determination function 8.

FIG. 7 shows a second embodiment of the present invention.
It is a figure for explaining a mode that an extraction condition is set to each record of an account number renewal database. Referring to FIG. 7, the account number renewal database is composed of a group of records having a tree structure of several layers, similarly to the configuration shown in FIG. And, in the record of each hierarchy,
Whether the extraction condition is “target” or “non-target” is set.

In the renewal condition judging function 8, the data extracted by the renewal target account extracting function 5 is narrowed down to those whose extraction conditions are “target”, and the data is created by the renewal input data creating function 5. The search time can be reduced by reducing the number of data items in the account number refilling input data file.

[0039]

As described above, according to the present invention, the following effects can be obtained.

The first effect of the present invention is that the processing efficiency of account number renewal is improved.

The reason for this is that, in the present invention, correspondence with the account number of the store to the store generated in the store transfer and merging process is prepared, and the account number of the store can be easily converted to the account number of the store. This is because That is, according to the present invention, since the conversion from the account number of the store to the account number of the store can be easily performed, the time required for updating the record of the account number renewal database is reduced, and the processing time is increased.

A second effect of the present invention is that the account number of the data record of the account number renewal database can be renewed at once, and the database search time can be reduced. is there.

The reason for this is that, in the present invention, the account number change held in the account number change database is directly searched for only the record to be changed using the search information created by the change input data creation function. Because the database can be updated, physical access to the database can be minimized, and the total time required for searching the account number renewal database can be reduced.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration of an embodiment of the present invention.

FIG. 2 is a diagram for explaining the operation of one embodiment of the present invention.

FIG. 3 is a diagram showing an example of the contents of an account number comparison file according to an embodiment of the present invention.

FIG. 4 is a diagram showing an example of the contents of an account number renewal database in one embodiment of the present invention.

FIG. 5 is a diagram showing an example of the contents of an account number renewal input data file in one embodiment of the present invention.

FIG. 6 is a diagram showing a configuration of a second embodiment of the present invention.

FIG. 7 is a diagram showing an example of the contents of an account number renewal database according to the second embodiment of the present invention.

[Explanation of symbols]

 1 Account number comparison file 2 Account number refill input file 3 Account number refill database 4 Comparison file creation function 5 Recharge target account extraction function 6 Refill input data creation function 7 Rewrite data rewriting function 8 Refill condition judgment function

Claims (6)

[Claims] 1. A method for refining customer account information held in a database in a store transfer and merging process of a bank and other financial business stores, wherein the store and the account information of the store are paired. Referring to the file, extract the account information of the renewal target and the search information of the record holding the account information from the database to create the replenishment input data, and obtain the account information of the renewal target record in the database. A method for renewing account information, characterized by rewriting all at once. 2. A method for refining customer account information stored in a database in a store transfer and merge process of a bank and other financial businesses, wherein the account information of the store before the change of the store transfer process is changed. And creating a comparison file by associating the account information of the receiving store with the account information of the visiting store stored in the created comparison file. Extract a record having account information that matches the account information of the store, by the extracted record, the account information of the store to be stored in the comparison file, the account information of the store, and search information of the record, It is created as a replacement input data file, the data of the replacement input data file is read in batch, and the search information indicating the record storage position of the account information of the replacement target of each data is prepared. Retrieving a record from the report and rewriting the account number of the store going to the store to the account number of the store in the database. 3. A method for changing customer account information held in a database in a store transfer and merging process of a bank and other financial operations, wherein the account information of the store before the change of the store transfer and merging process is changed. File comparison means for storing the account information of the receiving store after the correspondence in the comparison file, and a search indicating the storage position of the customer's account information and the record based on the account information of the store stored in the comparison file. A renewal target account information extracting means for extracting a record of the account information of the store existing in the database storing information; and receiving the account information of the store stored in the comparison file from the extracted record. A replacement input data creating means for creating the store account information and the search information of the record as a replacement input data file; data of the replacement input data file In a batch, and retrieves the record from the search information indicating the record storage position of the account information for the renewal target of each data, and rewrites the renewal data for rewriting the account number of the store going to the store from the account number of the store in the database. Means, and a method for renewing account information, comprising: 4. The database according to claim 1, wherein the database includes records of a hierarchical structure, and the records of each layer include account information and positional information of the number of the layer and the number of the record as the search information. Item 3. The account information renewal method. 5. A system according to claim 1, further comprising information indicating whether each record in said database is to be extracted or not, and determining whether or not the record extracted by said renewal target account information extracting means is a record to be extracted. In the change input data creating means, only the record determined to be a record to be extracted is account information of a store that is stored in the comparison file, account information of a store, 5. The method according to claim 3, wherein the search information of the record is created as a change input data file. 6. A means for storing the account information of the store before the change of the store transfer merging process and the account information of the store after the change in the comparison file, and storing the information in the comparison file. Means for extracting a record having account information that matches the store, which is stored in a database storing the customer's account information and search information indicating the storage location of the record, based on the stored store information of the store, (c) Means for creating, as a replacement input data file, the account information of a store, the account information of a store, and the search information of the record stored in the comparison file from the extracted record; and The data of the replacement input data file is read in batch, and the record is searched from the search information indicating the record storage position of the replacement target account information of each data. Means for rewriting from the seat number to the account number of 受店, the (a) ~ a recording medium recording a program for causing each means a computer (d).