JPH02247773A - Business form data base system - Google Patents

Abstract

PURPOSE:To speed up the retrieval of a business form and to restrict a user to protect secrecy by processing a business form as a data base and executing the registration, deletion and utilization of the business form by respectively different programs. CONSTITUTION:A key part data base 1 is constituted of a retrieval key for retrieving a business form and holds the retrieval key for extracting business form data on the basis of the date of a necessary business form, a business form name and so on. A data part data base 2 is constituted of the contents data of the business form and holds business form data extracted by the retrieval key held in the base 1. A key part data base maintenance program 3 relates the business form date, the business form name, etc., to be keys at the time of using the retrieval key and the business form of the base 2 to each other when the base 2 is changed, added or deleted. A data part data base maintenance program 4 changes, adds, or deletes the data of the base 2 in which a new business form is generated or the contents are changed day by day.

Description

[Detailed Description of the Invention] (Industrial Application Field) The present invention relates to a form database system for managing and searching forms of financial institutions, etc., and particularly relates to a form data system for managing and searching using a database by a computer system. .

(Prior Art) Conventionally, when referring to documents, documents stored in archives, archives, etc. have been manually searched and utilized.

(Problems to be Solved by the Invention) The conventional method of searching and using forms described above relies on manual processing for all processes, so it takes a lot of time to search for the required forms, and it is difficult to ensure confidentiality. The disadvantage is that it requires human resources to manage the forms.

(Means for Solving the Problems) A form database system according to the present invention includes a database part made up of form data indicating the contents of a form, and a key part database made up of keys used when searching the form data. , a key section database maintenance program and a data section database maintenance program for creating and maintaining the data section and key section databases, and a search program for searching the Ii vote.

(Example) Next, the present invention will be explained with reference to the drawings.

FIG. 1 is an overall configuration diagram of a form database system according to the present invention.

The key database 1 is composed of search keys used when searching for forms, and holds search keys for extracting 11 form data based on the required form date, form name, etc. The data part database 2 is made up of data of the contents of forms, and holds form data extracted by the search keys held in the key part database 1.

The key part database maintenance program 3 performs the following operations when the data part database 2 is changed, added, or deleted.
This is a program that associates the search key of the data part database 2 with the date of the form, the form name, etc., which are keys when using the form. The data database maintenance program 4 is a program that changes, adds, or deletes data in the data database 2 that generates new forms or whose contents change daily. When this occurs, the maintenance program 3 is started and the keys are associated with each other.

The search program 5 serves as a key to search the form.
When a form date, form name, etc. are given, this program searches the key part database 1 based on these, obtains the search key of the data part database 2, and extracts form data using this.

Next, the present invention will be explained in detail with reference to FIG. 2, taking a daily transaction report in a financial institution as an example.

In this example, only two days' worth of information is retained in the form database.
Anything before that will be deleted.

First, in the state of April 3rd, the key part database 1 has the customer number 10001, the date of the form is April 1, 1987, the name of the form is daily report, and the information that the handling store is the Marunouchi branch is in the data part database 2. , indicates that the search key is in the area indicated by 0001. So, if you look at the area with the search key 0001 in the data department database 2, it will be 1.
It turns out that there was a deposit of 0,000 yen.

The same is true for customer number 10002, but for customer number 10003, it can be seen that on April 2, 1987, there was a withdrawal of 90,000 yen at the Aoshiro branch, and a deposit of 90,000 yen at the Shingumi branch. .

When attempting to search for a form in this April 3rd state, the user specifies the key items for the 11 forms he/she is looking for.For example, the customer number is 10001, the form date is April 1, 1987,
When the store name is specified as Marunouchi, the search program searches the key section database 1 based on the customer number, form date, and store name, and obtains the search key 0001. Next, the search program searches the data section database 1 using the search key 0001. 2
Search for the form data. Here, the form data for the search key 0001 is deposits of ioo and ooo yen, and the search program 5 returns this content to the user.

Also, if you specify only this customer number, I1 form date, and form name, for example, the customer number is 10003 and the form date is 8.
On April 2, 2007, when the document name is specified as daily report, the search program 5 searches the key part database 1. At this time, there are two search keys that satisfy the search conditions, 0003 and 0004, and it can be seen that the store name corresponding to 0003 is Blue and White, and the store name corresponding to 0004 is Shingumi. The search program first searches the data department database 2 using the search key 0003, and retrieves the withdrawal amount of 90,000 as the form data.
The 0th order search program 5 to obtain yen uses the search key as 000.
4 and search the data section database 2 again. In the data department database 2, search Ir-0004
The ledger data corresponding to is the deposit so, ooo yen, and the search program 5 combines the two ledger data and returns the information to the user: Seihaku branch withdrawal 90,000 yen, Shingumi branch deposit so, ooo yen. Next, a case will be described in which the conditions specified at the time of search are the same as customer No. 1 form date, form name, and store name.

Status as of April 3rd, customer No. 0110004, form date 8
When searching for form data on April 1, 2007, specifying that the form name is Daily Report and the store name is Major Times, the search program searches the key part database 1 using these search conditions. At this time,
The search keys that satisfy the search conditions are 0005 and 0006.
It is one. The search program 5 first searches the data department database 2 using the search key 0005 and obtains deposits of ioo and ooo yen as form data.Next, the search program 5 changes the search key to 0006 and searches the data department database 2 again. Search for. In the data department database 2, the form data corresponding to the search key 0006 is the withdrawal 1
00,000 yen, and the search program 5 combines the two form data and calculates the major branch branch deposit of 100,000 yen,
The information that the withdrawal amount is 100,000 yen is returned to the user.

The example of using a form database has been described above, and below, the operation and processing when updating the form database will be explained.

First, in the state of April 3rd, the form data of April 1st and April 2nd is held. When you start the data department database maintenance program 4 after completing operations such as deposits and withdrawals on April 3rd, this maintenance program 4 deletes the form data dated three days ago. , a search key for the data of the form date is obtained using the key section database maintenance program 3. This maintenance program 3 searches the key part database 1 and searches for documents whose document date is April 1, 1987.
The corresponding item is deleted and the search key is passed to the maintenance program 4.

The maintenance program 4 deletes the form data corresponding to the search key, and inquires of the key database maintenance program 3 whether there are any other search keys for form data to be deleted.

Maintenance program 3 deletes the corresponding item if there is another corresponding search key and passes the search key to maintenance program 4. Maintenance programs 3 and 4 repeat this operation until the document date is April 1, 1987. When there are no more items left, the deletion process ends.

In the example of FIG. 2, first, customer N of key part database 1
o, 10001, the item with the store name Marunouchi is deleted, and then the search key 0001 of the data department database 2 is deleted.
The form data corresponding to is deleted. Since the key part database 1 still contains data whose document date is April 1, 1987, processing continues, and the key part database 1
The items with customer number 10002 and store name Osaka are deleted, and the search key 0002 of data department database 2 is deleted.
The form data corresponding to is deleted. Similarly, customer No.
Store name 10004, major store name, key section database 1 item with search key 0005, data section database 2 form data customer number corresponding to search key 0005
, 10004, store name major times, search key 0006. If you delete the form data corresponding to the item/search key 0006 in the q-part database 1 one by one, the form date will become April 1, 1987. There will be no data left, so finish the deletion process.

When the deletion process is completed, the data section database 2 performs a process to reflect the data generated on April 3 in the data section database 2 and the key section database 1.

The first data to be processed is customer number 10001, form date April 3, 1987, store name Marunouchi, and 11 votes data is withdrawn:
Suppose it was 50,000 yen. When the data department database maintenance program 4 receives this data, it searches for the search key with the smallest value among the search keys that do not have form data in the data department database 2.
In this case, since the minimum key is 0001, the data department database maintenance program 4 uses the search key 0.
Withdrawal to the form data item corresponding to 001: 50.00
Write 0 yen and start the key database maintenance program 3. Maintenance program 3 is customer number 10001, document date April 3, 1987, document name,
Data such as daily report, store name Marunouchi, and search key 0001 are written into the key database 1. At this time, the key database 1 arranges data in ascending order of customer numbers, so the data for customer number 10001 is written in the key database 1. is written at the beginning of. The second data to be processed is customer number 10005, the document date is April 3, 1987, the store name is Nagoya, the document data is payment = 60,000 yen, the third data is customer number 0910004, the document date is April 3, 1987. , Store Name: Kobe, and Form Data: Deposit: 80,000 yen.The result of processing is shown in FIG. 2 as of April 4th.

(Effects of the Invention) As explained above, the present invention speeds up the search of documents by converting documents into a database and creating separate programs for registering, deleting, and using documents, and by limiting the number of users. This has the effect of providing protection.

Base, 3...Key part database maintenance program, 4...Data part database maintenance program, 5...Search program.

Claims (1)

[Claims] A database section configured by form data indicating the contents of a form, a key section database formed from keys used when searching the form data, and a key section database for creating and maintaining the data section and key section database. A form database system comprising a maintenance program, a data section database maintenance program, and a search program for searching the form.