JPH08305621A - Data base access sharing system - Google Patents

Abstract

PURPOSE: To provide a data base access sharing system which manages the transactions and the data operation state, i.e., the state of a cursor, etc., in a data base management system and enables plural application programs to share and have accesses to the state of a data base. CONSTITUTION: A server machine 20 is provided with a data base management system 21, and a memory of a client machine 10 is provided with the application programs 11 and 15, a server access program 12, a path management program 13 and a path management table 14. Then the programs 11 and 15 communicate with the program 12 and share the communication channel used for a data base management system 21. Thus the state of the system 21 can be shared by both programs 11 and 15.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database access sharing system in which a client accesses a database management system of a server in a so-called client / server type system.

[0002]

2. Description of the Related Art Conventionally, when using a database management system from an application program, the function of communicating with the database management system was directly incorporated in the application program. FIG. 7 shows a conventional method for accessing a database management system. The application program 11 and the application program 15 each access the database management system 21. Database management system 2
In No. 1, the access states from the application program 11 and the application program 15 are individually held. The state of access to the database management system 21 is held by the program logic of each application program.

[0003]

According to the conventional method, even if a plurality of application programs use the same database management system, the states of the database management system such as transactions are shared by the plurality of application programs. There is a problem that you can not.

The present invention has been made in view of the above,
Its purpose is to manage the state of transactions and data operations of the database management system (so-called cursor), and to provide a database access sharing method that allows multiple application programs to share and access the state of the database. To provide.

[0005]

To achieve the above object, the present invention according to claim 1 provides a database management system and a database management system in a system composed of a plurality of application programs for performing business processing. A server access program having a function for accessing, wherein the plurality of application programs communicate with the server access program and share a communication path to the database management system, thereby changing the status of the database management system. The point is to share.

The present invention according to claim 2 is, in a system including a plurality of application programs for performing business processing, a database management system, and a server access program having a function for accessing the database management system. The plurality of application programs communicate with the server access program and share a communication path to the database management system, thereby sharing the state of the database management system, and an application of the plurality of application programs. When the program accesses the database management system via one or more server access programs and another application program is started, the access path is between the application program and the server access program or between the application programs. Ah Using a path management table which holds the program name of the ends of the number and the path of the path, a plurality of application programs is summarized in that sharing the database management system.

[0007]

In the present invention according to claim 1, a plurality of application programs communicate with the server access program,
The state of the database management system is shared by sharing the communication path to the database management system.

According to the present invention of claim 2,
A plurality of application programs communicate with the server access program and share a communication path to the database management system, thereby sharing the state of the database management system, and an application program passes through one or more server access programs. Holds the number of the path that is the access route between the application program and the server access program, or the access path between the application programs, and the program names at both ends of the path when the database management system is accessed and other application programs are started. A plurality of application programs share a database management system using the path management table.

[0009]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a diagram showing the configuration of a database access sharing system according to an embodiment of the present invention. In the figure, the application programs 11 and 15 access the database management system 21 via the server access program 12. Access these
The database management system 21 holds the same state as the access request from the server access program 12. The server access program 12 manages the access status of the database management system 21.

Next, the operation of the embodiment shown in FIG. 1 will be described with reference to the system configuration diagrams shown in FIGS.

FIG. 2 is a diagram showing an initial state of the system configuration shown in FIG. As shown in FIG.
Has a database management system 21, and the memory on the client machine 10 is provided with only the application programs 11 and 15, the path management program 13, and the empty path management table 14 in the initial state.

Database access sharing from the initial state shown in FIG. 2 to the state where the application programs 11 and 15 can use the database management system 21 via the same server access program 12 as shown in FIGS. 3 to 6. The operation of the method will be described.

Step S1 The application program 11 requests the path management program 13 to connect to the database management system 21.

Step S2 The path management program 13 activates the server access program 12.

Step S3 The server access program 12 is the database management system 2 of the server machine 20.
Connect processing to 1.

Step S4 The path management program 13 generates a unique path number 001, and the path management table 14
Then, information necessary for the access number of the database management system such as the path number 001 and the server access program 12 and the application program 11 is added.

Step S5 Path management program 13
Returns the pass number 001 to the application program 11 (FIG. 3).

Step S6 The application program 11 acquires the server access program 12 corresponding to the path number 001 from the path management table 14 and accesses the database management system 21 via the server access program 12.

Step S7 The application program 11 requests the path management program 13 to duplicate the path with the path number 001.

Step S8 The path management program 13 generates a unique path number 002, and the path management table 14
Information on the server access program 12 and the application program 11 is acquired from the information on the given path number 001 and added to the path management table 14 together with the path number 002.

Step S9 The path management program 13 returns the duplicated path number 002 to the application program 11 (FIG. 4).

Step S10 The application program 11 notifies the application program 15 of the path number 002.

Step S11 The application program 15 requests the path management program 13 to transfer the path number 002.

Step S12 Path management program 13
Changes the application program 11 in the information of the path number 002 in the path management table 14 to the application program 15 and notifies the application program 15 of the completion of the request (FIG. 5).

Step S13 The application program 15 acquires the server access program 12 corresponding to the path number 002 from the path management table 14 and accesses the database management system 21 via the server access program 12.

Step S14 The application program 11 requests the path management program 13 to newly connect to the database management system 22.

Step S15 Path management program 13
Activates the server access program 16 in an external storage device (not shown) or the memory of the client machine 10.

Step S16 The server access program 16 performs a connection process to the database management system 22 of the server machine 20.

Step S17 Path management program 13
Generates a unique path number 003, and the path management table 1
4, pass number 003 and server access program 16,
Necessary information is added to the access path of the database management system such as the application program 11.

Step S18 Path management program 13
Returns the pass number 003 to the application program 11 (FIG. 6).

As described above, according to this embodiment,
Since the states of the database management system such as transactions and cursors can be shared between application programs, flexible application program configuration is possible. Further, when a plurality of application programs access the same database management system, the connection processing with the database management system only needs to be performed once, so that the time required for the connection can be shortened.

[0033]

As described above, according to the database access sharing method of the present invention, the states of transactions and data operations of the database management system are managed so that a plurality of application programs share the state of the database. Can be accessed.

[Brief description of drawings]

FIG. 1 is a diagram showing a configuration of a database access sharing system according to an embodiment of the present invention.

FIG. 2 is a system configuration diagram showing an initial state of the database access sharing system of FIG.

3 is a system configuration diagram showing a state in which an application program is connected to a database in the database access sharing system of FIG.

4 is a system configuration diagram showing a state in which an application program requests duplication of a path number 001 in the database access sharing system of FIG.

5 is a system configuration diagram showing a state in which an application program is assigned a pass number 002 in the database access sharing system of FIG.

FIG. 6 is a system configuration diagram showing a state in which an application program newly connects to a database in the database access sharing system of FIG.

FIG. 7 is a diagram showing an access method to a conventional database management system.

[Explanation of symbols]

 11, 15 Application program 12 Server access program 13 Path management program 14 Path management table 21 Database management system

 ─────────────────────────────────────────────────── ─── Continued Front Page (72) Inventor Hirohiko Kurokawa 1-1-6 Uchisaiwaicho, Chiyoda-ku, Tokyo Nihon Telegraph and Telephone Corporation

Claims (2)

[Claims] 1. A system comprising a plurality of application programs for performing business processing, comprising: a database management system; and a server access program having a function for accessing the database management system. A method of sharing a database access system, characterized in that the state of the database management system is shared by communicating with the server access program and sharing a communication path to the database management system. 2. A system including a plurality of application programs for performing business processing, comprising a database management system and a server access program having a function for accessing the database management system, wherein the plurality of application programs Communicate with the server access program and share a communication path to the database management system to share the state of the database management system, and one application program having the plurality of application programs is one or a plurality of server access programs. When the database management system is accessed via the server and another application program is started, the path number between the application program and the server access program or the access path between the application programs and both ends of the path. Using a path management table which holds the program name, database access sharing scheme in which a plurality of application programs, characterized in that sharing the database management system.