JPH1139201A - Data base processing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable a processing program for affairs to make data processing requests for a plurality of data bases without using the data processing requesting procedures of the data bases and, at the same time, to easily make the preparation, addition, change, etc., of the program. SOLUTION: DB(data base) access modules 3 (13) which output the data processing requesting information of data bases 5 (15) to DB processing programs 4 (14) are provided respectively correspondingly to the data bases 5 (15) and a DB access management program 2 which selects the DB access module 3 (or 13) corresponding to one of the data bases to be processed from the data processing requesting information of the data bases inputted from a processing program 1 for affairs and outputs the processing requesting information to the selected module is provided. Therefore, the processing program 1 for affairs can make data processing requests for the data bases 5 (15).

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for various data processing of a plurality of databases from a business processing program for performing various business processes such as personnel management and accounting processing management.

[0002]

2. Description of the Related Art Conventionally, application programs (hereinafter referred to as "business processing programs") for performing various business processes such as human resource management and accounting processing management perform processes such as data reference, addition, update, and deletion to a database. At this time, the business processing program makes a processing request to a database processing application program (hereinafter, referred to as a “DB processing program”) prepared exclusively for a database. ("Oracle" format, "DB
2 "format), the content and format of the data, and the DB processing program, etc., and a single processing request method of the business processing program is used for the plurality of databases.
The above-mentioned various processing requests cannot be made, and a plurality of processing request methods corresponding to each database are incorporated as a plurality of procedures in the business processing program, and the data processing request procedure is sequentially selected for each database. While having to do it.

Therefore, when performing processing such as reference, addition, update, and deletion of data in a plurality of databases, a plurality of processing request procedures corresponding to each database are used, and at the same time, these business processing programs are created. In such a case, it is necessary to incorporate the plurality of processing request procedures and the procedure for selecting them into all the business processing programs in the business processing program. There was a problem that a great deal of labor was required.

[0004] In addition, when a database group in an existing system is added or changed, and a system corresponding to the addition or change is rebuilt, a business processing program related to the added or changed database is added to the database. It is necessary to add and modify the processing request procedure in response to additions and changes, and it is necessary to perform a huge amount of correction work, and also to check the impact on parts of the existing system that do not need to be added or changed Also occurred.

Further, for example, in a client-server system, when a business processing program provided in a client computer requests data processing of a plurality of databases provided in a server computer by communication means, each data processing request Is performed while sequentially performing communication in each procedure. However, when a failure such as interruption of the communication occurs, there is also a problem that the requested processing is not completely executed and data consistency of each database is lost. As a result, a separate program for restoring the consistency was required for the system.

[0006]

SUMMARY OF THE INVENTION According to the present invention, it is not necessary to incorporate a data processing request procedure for a plurality of databases into each business processing program, and the business processing program requires complicated procedures. Can make data processing requests for multiple databases, and can easily create, add, and modify business processing programs.
It is an object of the present invention to provide a database processing method capable of easily reconfiguring a system without affecting the entire existing system even when a database is added or changed.

[0007]

In order to solve the above problems, a database processing method according to the present invention is characterized in that a business processing program refers to each data of a plurality of databases.
In a database processing method in which various processing request information such as addition, update, and deletion is output, and the database processing program dedicated to the database executes the various processing, various processing request information of database data is provided to the DB processing program. Is provided for each database, and a DB access module corresponding to the database to be processed is selected from various types of processing request information of database data input from the business processing program, and Providing a DB access management program for outputting the processing request information, wherein the business processing program outputs data processing request information of a database to the DB processing program via the DB access management program and the DB access module. Features To have. According to this feature, it is not necessary to incorporate a data processing request procedure for a plurality of databases in each business processing program, and the business processing program can make a data processing request for a plurality of databases without unnecessary load. A business processing program can be easily created, added, changed, etc., and even if a database is added or changed, the system can be easily reconfigured.

[0008] In a database processing method according to the present invention, a server computer having at least one server function and at least one client computer are connected by communication means, and the server computer and the client computer communicate with each other. A client / server that executes various requested processes in the server computer based on various processing requests such as data reference / addition / update / deletion from a client computer and returns the processing results to the client computer. In the system, the business processing program is provided in the client computer, and the database, the DB processing program, the DB access module, and the DB access management program are stored in the server computer. Provided, using the means of communication between the two computers, the work processing program is the DB access management program, it is desirable that is adapted to transmit the data processing request information in the database. With this configuration, when performing data processing of a plurality of databases in the client-server system, the data processing request information of the plurality of databases is transmitted from the business processing program on the client computer side to the DB access management program on the server computer side. Since the request can be executed by transmitting at one time, when a failure such as communication interruption occurs in communication between the client computer and the server computer, the requested processing is not completely executed, and The problem of inconsistency of data in the database is solved.

Further, the database processing method according to the present invention is characterized in that when the DB access management program selects a DB access module, each database and each DB
It is desirable to use an association file storing the association of the access modules. In this way, even if an addition or change occurs to the database group of the existing system, it is not necessary to modify the DB access management program, and it can be dealt with by modifying the association file.

The database processing method according to the present invention is characterized in that, when a new database is constructed by changing the format of an existing database, when the DB access module for the new database is created, It is preferable that the new DB access module is created by converting the processing function of the new DB access module into the new database format processing function. In this way, even if the format of the predetermined database is changed, the work of changing the DB access module can be minimized. In addition, when constructing a database in a new format,
Creation of a new access module is minimized.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiments of the present invention will be described below with reference to the drawings.

First, a first embodiment of the personal data reference / search processing will be described with reference to FIG.

A business processing program 1 for referring to and searching for personal data of employees, customers, monitors, etc., requests the DB access management program 2 to start using the employee database 5 at the request of the user. I do. The request is made by sending information including (1) a database number and (2) a type of processing (in this case, use start). (S1) The DB access management program 2 selects the DB access module 3 corresponding to the employee database 5 from the (1) database number obtained from the business processing program 1, and assigns (1) the database number and (2) to the module. ) Send the type of process (ie, start use here). (S
2) The DB access module 3 is a processing request method corresponding to the format of the employee database 5, the content and format of the data, and the processing function of the DB processing program 4 dedicated to the database, and according to the type of processing received. Request processing (that is, start using the database here) (S
3) The DB processing program 4 is an employee database 5
Execute the activation of.

Subsequently, the user requests the retrieval of the employee A data by inputting the name of the employee A in the input field of the monitor screen 6. The business processing program 1 performs access to the employee database 5 in the above-described procedure (S1, 2, 3) in the data search processing. At this time, the DB access management program 2 performs the above-described (1) In addition to the data of (2), (3) the number of the employee A is received from the business processing program 1 and sent to the DB access module 3.
The DB access module 3 is a DB processing program 4
To the received (2) processing (that is, data retrieval in this case) according to the type of processing received, and (3) the number of the employee A is sent. Perform a data search for.

The searched data is returned from the DB processing program 4 to the business processing program 1 through the DB access module 3 and the DB access management program 2 (S4 to S6). It is displayed on the monitor screen 6 and the user refers to it.

Next, the data of the employee B is searched for the data of the customer B who is in charge of the employee A from the data of the employee A, using the DB access management program 2 in the same manner as described above. First, the DB access module 13 corresponding to the customer database 15 is selected, and the DB access module 13 determines the format of the customer database 15, the content and format of the data, and the D dedicated to the database.
In the processing request method corresponding to the processing function of the processing program B, the processing according to the type of the received processing (that is, the start of database use and the data search in this case) is performed by D
B processing program 14 and the customer database 1
5 and a data search is performed.

At this time, the formats of the employee database 5 and the customer database 15, the contents and formats of the data, and the differences between the DB processing programs (processing functions) are all different in the DB access management program 2, the DB access module 3, Therefore, the data processing request to each personal database of the business processing program can be performed by the above-described simple method regardless of the type.

Next, a second embodiment will be described with reference to FIG.

Following the first embodiment, a business processing program 11 for performing a product delivery processing business and adding / updating data of a database relating to the product inventory, customers, employees in charge, etc., according to a request from a person in charge In order to specify the delivery of the product to the customer in the transportation department, the delivery department and the number of the delivered product, the customer, the delivery location, the delivery date and time, etc. are notified to the transportation department, Is added to the product database 25, the amount of delivery to the customer is added to the customer database 15, and the sales performance of the person in charge is added to the employee database 5. The procedure in the above processing is as follows.

First, the user who performs the product delivery process inputs the number of the product D, the number of the products, and the customer E who is the delivery destination in the input fields of the monitor screen 6 by the business processing program 11.
Name or number, delivery place, delivery date / time, person in charge C
Enter your name or number.

The business processing program 11 sends, to the computer 7 in the transportation department, the goods D as the goods to be delivered and the number of the goods, the customer E as the delivery destination, the delivery place, the delivery date / time in accordance with the input contents. (1) the number of the product database 25, a command to start using the database, a product search command, and a command to update the product stock quantity subtraction, a product D number, the number of products D delivered,
(2) Customer database 15 number, customer search command and customer delivery record additional command, customer E number, product D
(3) Employee database 5
And information including an employee search instruction and an employee sales result additional instruction, a person in charge C, a name of a customer E who is a seller, a sales amount of a product D, and a delivery date. To the DB access management program 2.

The DB access management program 2 first selects a DB access module 23 corresponding to the product database 25 from the received information (1),
For the access module, a database use start command, a product search command, a product stock quantity subtraction update command,
Information consisting of the number of product D and the number of products D delivered (1-
Send 2).

Subsequently, similarly, the DB access management program 2 selects the DB access module 13 corresponding to the customer database 10 from the received information of (2), and outputs a customer search command and a customer delivery record additional command, The information (2-2) including the number of E, the delivery amount of the product D, and the delivery date is sent, and the DB access module 3 corresponding to the employee database 5 is selected from the information of (3), and an employee search instruction is sent. And an instruction to add an employee sales record and information (3-2) including the number of the person in charge C, the name of the customer E who is the seller, the sales amount of the product D, and the delivery date.

When the DB access module 23 receives the information (1-2), the DB access module 23
Product database 25 for B processing program 24
After requesting the start of use of the product database by the processing request method corresponding to the format and the content and format of the data and the processing function of the DB processing program 24 dedicated to the database, the information of the number of the product D and the number of delivered items are passed. Product D
A request is made to search for data and to subtract and update the stock quantity of the product D. Then, after starting to use the product database 25, the DB processing program 24 searches the product D data in the product database 25, and updates the stock quantity of the product D by subtracting the delivery quantity from the existing stock quantity in the data. I do.

Similarly, D which receives the information (2-2)
The B access module 13 sends the customer E number,
The information on the delivery amount and delivery date is passed, and a request is made to search for customer E data and to add customer delivery results. Then, the data processing program 14 searches the data of the customer E in the customer database 15 and adds the delivery result data of the customer E including the delivery date and the delivery amount in the data. Also,
The DB access module 3 having received the information (3-2) passes the number of the person in charge C, the amount of sales and payment, and the date of delivery to the data processing program 4 dedicated to the employee database 5, and A request is made to search for person C data and to add employee sales results. Then, the data processing program 4 searches the employee C data in the employee database 5 and adds the sales result data of the employee C including the delivery date, the sales amount, and the name of the customer E who is the seller in the data. .

As described above, the business processing program 11
Uses the DB access management program 2 and the DB access modules 3, 13 and 23 to execute the data processing for the employee database 5, customer database 15 and product database 25 in one simple procedure regardless of the type of database. Processing requests, such as addition and updating of a file.

FIG. 3 shows a third embodiment in which a series of procedures in the second embodiment is performed in a client-server system. A person in charge of business processing sends the request to the client computer 8. Of the server computer 18 using the business processing program 11
The program is transmitted to the B access management program 2, and thereafter, the processing is performed according to the above-described procedure.

In the conventional method, processing requests such as updating data to a plurality of databases are sequentially communicated from the client computer 8 to the server computer 18 by using a processing request method for each database. If communication between the client and the server is interrupted on the way, inconsistency may occur in the data of each database, and a program for correcting the inconsistency and restoring the consistency is required separately. However, according to this method, it is possible to simply transmit a processing request such as data update of a plurality of databases from the client computer 8 to the server computer 18, and thereafter, all processing requests can be processed in the server computer 18. There is no need to deal with inconsistencies in each database due to the above reasons.

The selection of a DB access module by the DB access management program may be performed with reference to an association file 30 storing association between each database and each DB access module as shown in FIG. desirable. FIG. 5 shows an example of the correspondence between each database number of the reference file 30 and each DB access module number.

Although the employee database 5 is a database of the "DB2" format, when the database is newly changed to the "Oracle" format, a DB processing program dedicated to the "Oracle" format is introduced and " It is necessary to newly create a DB access module corresponding to an employee database in the "Oracle" format.

According to the present invention, as shown in FIG. 5, the above-mentioned new creation is made possible by the following procedure.

First, "se" of "UNIX (registered trademark)"
Using the "d" command (pattern conversion), as the input file, a processing function file 40 of the DB access module 3 and a pattern file having a function of associating a processing function for "DB2" with a processing function for "Oracle" 41, the "Oracle" processing function file 42 is obtained. Next, by precompiling the "Oracle" processing function file 35, the C language source 43 of the "Oracle" DB access module is obtained, and the C language source 43 is compiled and linked, whereby the "Oracle" employee The “Oracle” DB access module 44 corresponding to the database is completed.

[0033]

According to the present invention, the following effects can be obtained.

(A) According to the first aspect of the present invention, there is no need to incorporate a data processing request procedure for a plurality of databases into each business processing program, and the business processing program can load a plurality of databases without an extra load. A data processing request can be made, and a business processing program can be easily created, added, changed, and the like. Even if a database is added or changed, the system can be easily reconfigured.

(B) According to the second aspect of the present invention, when data processing of a plurality of databases is performed in a client-server system, the business processing program on the client computer is changed to the DB access management program on the server computer. Since the request can be executed by transmitting the data processing request information of a plurality of databases at once, the request is issued when a failure such as a communication interruption occurs in the communication between the client computer and the server computer. The problem that the processing is not completely executed and the data of each database is inconsistent is solved.

(C) According to the third aspect of the present invention, even when a database group of an existing system is added or changed, there is no need to modify the DB access management program, and the associated file is modified. Can respond.

(D) According to the invention described in claim 4,
Even if the format of the predetermined database is changed, the work of changing the DB access module can be minimized. Also, when constructing a database in a new format,
The work of newly creating the B access module is minimized.

[0038]

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a flow of a first embodiment.

FIG. 2 is a block diagram showing a flow of a second embodiment.

FIG. 3 is a block diagram illustrating a flow of a third embodiment.

FIG. 4 is a block diagram showing a flow in which a DB access management program refers to an association file.

FIG. 5 shows each database number and each DB of an association file
FIG. 4 is a diagram showing association of access modules.

FIG. 6 is a diagram showing a procedure for creating an “Oracle” DB access module from a “DB2” DB access module;

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 Business processing program 2 DB access management program 3 DB access module 4 DB processing program 5 Employee database 6 Monitor screen 7 Transportation department computer 8 Client computer 11 Business processing program 13 DB access module 14 DB processing program 15 Customer database 18 server computer 23 DB access module 24 DB processing program 25 product database 30 reference file 40 DB access module 3 processing function file 41 conversion pattern file 42 "Oracle" processing function file 43 "Oracle" DB access module C language source 44 "Oracle" DB Access Module

Claims (4)

[Claims] A business processing program outputs various processing request information such as reference / addition / update / deletion of data of a plurality of databases, and a database processing program dedicated to the database executes the various processing. In the processing method, a DB access module for outputting various processing request information of database data to a DB processing program is provided for each database,
A DB access module corresponding to a database to be processed is selected from various types of processing request information of database data input from a business processing program, and a DB access management program for outputting the processing request information to the module is provided. A database processing method, wherein a processing program outputs data processing request information of a database to a DB processing program via the DB access management program and the DB access module. 2. A server computer having at least one server function and at least one client computer are connected by communication means, and between the server computer and the client computer, reference / addition of data from the client computer.・ Based on various processing requests such as update / deletion, the server computer executes the requested various processing,
In the client-server system for returning the processing result to the client computer, the business processing program is provided in the client computer, and the database, the DB processing program, the DB access module, and the DB access management program are stored in the server computer. Provided in the
2. The database processing method according to claim 1, wherein the business processing program transmits data processing request information of the database to the DB access management program by using communication means between the two computers. . 3. The system according to claim 1, wherein the DB access management program uses an association file storing association between each database and each DB access module when selecting the DB access module. 2. The processing method of the database according to 2. 4. When a new database is constructed by changing the format of an existing database, a processing function of the DB access module for the existing database is executed when the DB access module for the new database is created. 4. The database processing method according to claim 1, wherein the new DB access module is created by converting to a new database format processing function.