JPH1031603A - Information processing system, client-server system and database access method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the independency against a work application and also to secure the versatility and transportability of the system by exchanging the data access information based on a rule between an analysis part which selects the optimum one of plural data access parts and a work application part. SOLUTION: When the operation of a client-server system is disclosed, a work application part 11 generates a DB(database) access request. This access request executes a syntactic analysis at an interface part 13 based on a description rule. An analysis part 12 selects a DB access part 15 out of a syntax definition information file 14 based on a relevant database ID and transmits a DB access request. Then the part 15 accesses a relevant database part 21 to acquire the access result. This access result is sent to the part 11 via the parts 12 and 13, and it's judged whether an access request is required again or the access is finished.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to the independence of a business application from a system configuration, and particularly to the versatility of a business application.

[0002]

2. Description of the Related Art Conventionally, an information processing system has been developed as follows. That is, after determining the tool to be used, the computer model, and the system form of the database software, development is performed under the characteristics and restrictions of the tool. As a tool to be used, for example, AP
There are construction tools and middleware. As is well known, middleware is software that is located between an application and an operating system (OS) and that ensures data and process consistency across multiple networks and environments. The computer models include, for example, general-purpose machines, UNIX machines, and PCs. Furthermore, database software includes, for example, ORACL.
E and informmix. As you know, ORAC
LE is a general term for a system (RDBMS) for managing a relational database of Oracle and an application development tool.

As a result, as shown in FIG. 4A, in the conventional information processing system, a business application is directly constructed on a tool. Therefore, the business application has a configuration that largely depends on the system form, and a new system must be developed each time a new tool is applied. As a result, there is a major problem in versatility and portability of business applications.

Further, as prior art related to the present invention,
For example, Japanese Unexamined Patent Application Publication No. 5-257773 (hereinafter referred to as Prior Art 1) discloses a storage format in which an original data owner can control the generation of a replica by another user and further efficiently execute each access request. There is provided a distributed database replica processing method that can use any one of the original data and the replica having. In the prior art 1, the replica generation authority management unit is provided with the authority to generate the replica from the owner of the original data in the user identification name table and holds the identification name of the user. The replica generation unit generates a replica according to the specified storage format. The format table holds the storage format of the original data and the replica. Also,
The processing procedure generation unit generates a processing procedure based on the storage format of the replica. The access target determination unit
A storage format optimal for executing each access request is selected, and the request is executed using one of the original data and the replica having the storage format.

Further, Japanese Patent Application Laid-Open No. 5-225308 (hereinafter referred to as Prior Art 2) discloses an "electronic filing apparatus" in which a database having different resolutions can be accessed to prevent deterioration of image data. ing. In Prior Art 2, in a search process, when a search keyword is sent from a terminal to a control device, data requested to be searched is extracted from a host computer. Since the data is coded, the control device adds a conversion parameter, transmits the data to the compression / decompression means, decodes the data, and returns the image data. Next, the control device adds a conversion parameter in order to create image data suitable for the resolution of the request source terminal, and transmits the data to the density conversion means. The density conversion means compares the resolution of the requesting terminal in the conversion parameters with the resolution at the time of image data creation, selects an optimum conversion rate, enlarges or reduces the image data, and returns the image data to the control device. When the control device transmits the received image data to the requesting terminal, the terminal terminates the search processing such as displaying it on a screen or printing it on a printer.

[0006] Japanese Patent Application Laid-Open No. 5-153730 (hereinafter referred to as Prior Art 3) discloses that when there are a plurality of power systems,
A "power system training simulator" is disclosed, which is capable of automatically selecting a database for a simulator for each training object without being connected by a human system.
In Prior Art 3, when there is an access request from the simulation means to the training system database, the database switching means determines which training system database is based on the training system information in the training system information section set by the training system setting unit. Recognizing whether the target is a simulation target, the target training system database is extracted from the training system database group, and the contents are passed to the system simulation means.

Japanese Patent Application Laid-Open No. 4-195466 (hereinafter referred to as prior art 4) discloses a "CAD system" in which an arbitrary database can be accessed by replacing a database access driver and a CAD database body as necessary. A "database system" is disclosed. In the prior art 4, the command analysis unit checks the validity of the input command, data, and the like, and the command processing unit performs a process corresponding to each command. Next, data such as a processing result is stored in a memory in a data storage unit,
The display is displayed on the display device by the display control unit. Further, the database access interface unit performs access control on the CAD database in a standard database language, and the access process distribution processing unit selects a plurality of CAD databases to be connected to the own system. Then, the connection of the database access driver to be connected is performed. As a result, a CAD system can be constructed in a form independent of the attributes and types of the database.

Japanese Patent Application Laid-Open No. 3-94374 (hereinafter referred to as Prior Art 5) discloses a system which analyzes an input Japanese sentence, selects an access target system, and selects a database corresponding to the selected access target database processing apparatus. A "database operation device" is disclosed in which a user does not need to specify a database name by translating data input to a command. In Prior Art 5, the database operation device includes a Japanese language analysis unit, a database determination unit, a database command generation unit, and a database command generation rule table. Then, the input Japanese sentence is analyzed, a database processing device is automatically selected, and further translated into a database operation command of a corresponding database language of the database processing device. This eliminates the need for the user to specify which database to operate.

Japanese Unexamined Patent Application Publication No. 3-5884 (hereinafter referred to as Prior Art 6) discloses a technique that allows a user to automatically generate and determine a database access path simply by specifying an item name to be searched in the database. A "structured database automatic path generation method" has been disclosed which enables a user to search for a target item even if the user does not sufficiently understand the structure of the database. In the structured database automatic path generation method disclosed in Prior Art 6, a designated item name information input unit connected to an auxiliary storage device having a search item file, and an owner connected to an auxiliary storage device having an owner / member management file It has a member information input unit, an owner / member information storage unit, an entry record selection unit, an access generation unit, a path generation information storage unit, an unnecessary record deletion unit, a multiple path selection unit, and a generation path output unit. Then, a record name is searched from the owner / member management file using the first four digits of the item name registered by the user, and an access path is automatically generated based on the owner and member information. This allows the user to search for the desired information without any awareness of the structure of the database.

Japanese Patent Application Laid-Open No. Sho 62-130422 (hereinafter referred to as "
In the prior art 7, the data is prepared in advance on both the magnetic disk and the optical disk, and the access is speeded up by automatically selecting an optimum image data storage medium in a data management book for managing image data at the time of access. A "data storage medium management processing method" is disclosed. In Prior Art 7, a data processing device that executes predetermined instructions by a CPU to process data includes an application processing unit that performs a process requested by a user using image data, an image data access unit, a database management unit, And a magnetic disk and an optical disk. The processing of the access medium selection unit is performed by the access unit in response to an access request from the application processing unit, and the processing of the optical disk update unit is performed by the optical disk storage processing unit of the management unit. In this way, image data that is frequently referred to is also temporarily stored on the optical disc,
When necessary, data will be temporarily loaded on the magnetic disk for efficient use and high-speed access.

[0011]

The problem of the above-mentioned conventional technique is that when a business application developed once is introduced into a new tool or a different system form, part or all of the business application needs to be remodeled. It is to become. The reason is that the configuration of the business application depends on the tool to be used and the system form.

Therefore, an object of the present invention is to reduce the dependence of tools on tools, computer models, database software, and the like that use a business application to be developed, increase the independence of the business application, and secure versatility and portability. Is to do.

Another object of the present invention is to improve the reusability and productivity of application resources when a new tool is applied.

The prior art 1 only discloses a technical idea of managing a replica of a database by a plurality of computers, and is completely different from the present invention, which is a technical idea of increasing the independence of business applications. Further, Prior Art 2 discloses a technical idea of merely accessing a single database from a plurality of terminals having different resolutions and attempting to access a plurality of database units constructed by different database software. It is completely different from the present invention. Prior Art 3 only discloses a technique for automatically selecting a simulator database for each training object, and does not assume a case where the database is constructed with different database software. In other words, in Prior Art 3, it is considered that the simulator database used is constructed with the same database software.

Prior art 4 is based on C stored in another system.
CAD that can use AD database arbitrarily
Discloses a database system. However,
In Prior Art 4, there is no description as to whether a plurality of CAD databases are constructed by the same database software or different database software. In Prior Art 4, a plurality of CAD databases are stored in the same standard database language (SQL language).
It is assumed that it is built using Anyway, the prior art 4 is considered to be completely different from the present invention, which is a technical idea of automatically selecting and accessing a database unit suitable for a business application. Prior Art 5 discloses a technical idea of accessing a plurality of database systems having different command systems, but does not describe what kind of database software is used to construct the plurality of database systems. Absent. Therefore, like the prior art 4, the prior art 5 is considered to be completely different from the present invention which is a technical idea of automatically selecting and accessing a database unit suitable for a business application.

The prior art 6 discloses a technical idea that enables a user to execute a search for a target item even when a user does not sufficiently grasp the structure of the structured database when accessing one structured database. This is completely different from the present invention which is a technical idea of accessing a plurality of database units constructed by different database software. The prior art 7 is a technical concept that automatically selects and accesses a database unit suitable for a business application only by disclosing a technology for automatically selecting and accessing a plurality of storage media having different access speeds. It is completely different from the invention.

[0017]

According to the present invention, there are provided a business application unit for performing business processing and a plurality of database units for storing business data, each of which is constructed by different database software. In the information processing system, the configuration information definition file that defines the configuration information of the database unit to be accessed, and a plurality of database access units that have a processing structure depending on various tools and access the corresponding database units, An analysis unit that analyzes database access information generated in the business application unit with reference to the configuration information definition file and selects an optimal one database access unit from a plurality of database access units; a business application unit and an analysis unit A database according to the rules The information processing system is obtained, characterized in that it comprises an interface unit for exchanging access information.

The above information processing system is a client / server system in which a business application unit, a configuration information definition file, a plurality of database access units, an analysis unit, and an interface unit are provided in a client, and a plurality of database units are provided in a server. It may be.

Further, according to the present invention, there is provided a method for accessing a plurality of database units constructed by different database software, wherein the business application unit generates a database access request; In response to the step, the interface unit performs syntax analysis according to the description rule, and the analysis unit refers to the configuration definition information file, selects a database access unit according to the corresponding database ID, and performs database access to the selected database access unit. Transmitting a request, the selected database access unit accesses the corresponding database unit according to the database access request, and obtains an access result from the database unit; and Analyzing unit, and sending to the business application unit via the interface unit, a database access method comprising obtained.

In the above database access method,
The business application unit may include a step of determining whether to make an access request again or to end based on the received access result information.

[0021]

In the interface section, the description rules of messages (database access information) between the business application section and the analysis section are unified. For this reason, the business application section has a structure in which only the interface section is considered. Information required for database access is stored in the configuration definition information file as definition information. For this reason, the analysis unit can select the optimum database access unit based on the definition information. A plurality of configuration information can be registered and deleted in the configuration definition information file. Therefore, it is possible to set a plurality of arbitrary database access units.

[0022]

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

FIG. 1 shows a client / server system to which a database access method according to an embodiment of the present invention is applied. The illustrated client / server system has a plurality of clients (only one client is shown in the drawing) 10 and a server 20 connected to the client 10.

The server 20 has a plurality of database units 21 for storing business data. Multiple database units 2
1 is constructed by different database software. The client 10 includes a business application unit 11 that performs business processing, an analysis unit 12 that analyzes a database access request (hereinafter abbreviated as a DB access request) generated by the business application unit 11, a business application unit 11, and an analysis unit 12. An interface unit 13 that is responsible for exchanging messages with the server, a configuration definition information file 14 that defines information for analyzing the message, and a plurality of database access units (hereinafter abbreviated as DB access units) 15 that access the database unit 21. It has. As shown, the plurality of DB access units 15
Access unit A, DB access unit B, DB access unit C,
….

When exchanging messages with the interface unit 13, the business application unit 11 describes DB access information in accordance with a predetermined description rule. The interface unit 13 exchanges messages between the business application unit 11 and the analysis unit 12 (DB access request, D
B access result information) function and a description rule checking function. The analysis unit 12 includes an interface unit 13
The most appropriate DB access unit 15 from the configuration information file 14 based on the DB access information (request) from
The DB access unit 15 transmits the DB access information to the selected DB access unit 15, and transmits the DB access result received from the DB access unit 15 to the interface unit 13.

The DB access request received from the interface unit 13 includes a database ID, a search item,
A search formula is described, and a DB access unit corresponding to the database ID on the configuration constant information file 14 can be selected.

Each of the DB access units 15 has a configuration depending on middleware and database software, and a DB access unit A, a DB access unit B, and a DB access unit C are defined according to each configuration. It can be used by defining it in the information file 14.

The plurality of database units 21 store business data constructed by different database software, respectively, and data processing can be performed by the DB access unit 15.

Next, the operation of the client / server system shown in FIG. 1 will be described with reference to FIG. 2 in addition to FIG.

When the operation of the client / server system is disclosed (step S0), the business application unit 11 generates a DB access request (step S1).
The generated DB access request is analyzed in the interface unit 13 according to the description rule (step S2). Subsequently, the analysis unit 12 selects the DB access unit 15 from the configuration information file 14 according to the corresponding database ID (step S3), and transmits a DB access request to the selected DB access unit 15.

The DB access unit 15 accesses the corresponding database unit 21 in response to the DB access request (step S4), and obtains an access result (step S4).
5). The access result obtained by the DB access unit 15 is as follows:
It is transmitted to the business application unit 11 via the analysis unit 12 and the interface unit 13 (steps S6, S
7, S8). The business application unit 11 makes an access request again based on the received result information (Step S
It is determined whether 1) or end (step S9).

[0032]

Next, an embodiment of the present invention will be described with reference to FIG. In this embodiment, the business application 1
1 assumes two business systems, facility reservation A and facility reservation B. The facility reservation A and the facility reservation B are the same application, but the target database unit 21 is different. The database unit 21 has a database unit A and a database unit B corresponding to the facility reservation A and the facility reservation B, respectively, and is constructed by different database software. In the illustrated example, the database unit A is constructed by database software called informmix, and the database unit B is an OR.
It is constructed by database software called ACLE.

The DB access unit 15 is also a database unit A
And DB to correspond to database part B
There is an access unit A and a DB access unit B, each corresponding to a different tool. In the illustrated example, the tool of the DB access unit A is (SegueLink, ifor
mix), and the tool of the DB access unit B is (SQL)
* NET, ORACLE).

The configuration definition information file 14 stores a correspondence between a database ID and a DB access unit. In the case of the illustrated example, the configuration definition information file 14 indicates that the database ID indicating “facility reservation A” corresponds to the DB access unit A, and the database ID indicating “facility reservation B” corresponds to the DB access unit B. Has defined.

The interface unit 13 and the analysis unit 12 have the functions described above, and can be shared and used by the business applications of the facility reservation A and the facility reservation B.

Next, the operation in the case where a DB access request has occurred in facility reservation A will be described. The DB access request generated in the facility reservation A is sent to the analysis unit 12 via the interface unit 13. The analysis unit 12 determines the database ID (facility reservation A), D
Based on the definition of B access part (DB access A), D
Select B access unit A. The DB access unit A accesses the database unit A, and the corresponding access result is returned to the facility reservation A via the analysis unit 12 and the interface unit 13 for processing.

The operation when a DB access request is issued in facility reservation B is the same, and the description of the operation will be omitted.

That is, in the present invention, as shown in FIG. 4B, an intermediate layer 30 composed of the analysis unit 12, the interface unit 13, and the configuration definition information file 14 is constructed between the tool and the business application. ing.

The present invention is not limited to the above-described embodiment, and various changes and modifications can be made without departing from the spirit of the present invention.

[0040]

As described above, according to the present invention, since the intermediate layer having a general-purpose interface is constructed between the tool and the business application, the dependence on the tool is reduced and the independence of the business application unit is increased. be able to. Thereby, versatility and portability can be secured.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a client / server system to which a database access method according to an embodiment of the present invention is applied.

FIG. 2 is a flowchart illustrating an operation of the client / server system shown in FIG. 1;

FIG. 3 is a block diagram showing a configuration of a client / server system according to one embodiment of the present invention.

FIG. 4 is a diagram showing a system configuration (a) according to a conventional technique and a system configuration (b) according to the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 Client 11 Business application part 12 Analysis part 13 Interface part 14 Configuration definition information file 15 DB access part 20 Server 21 Database part

Claims (4)

[Claims] 1. An information processing system comprising: a business application unit for performing business processing; and a plurality of database units for storing business data, wherein the plurality of database units are access targets in an information processing system constructed by different database software. Configuration information definition file that defines the configuration information of the database unit to be used, a plurality of database access units that have processing structures dependent on various tools and access the corresponding database units, and database access that occurs in the business application unit An analysis unit that analyzes information with reference to the configuration information definition file and selects an optimal one database access unit from the plurality of database access units; and , A database The information processing system characterized by comprising an interface unit for exchanging processes information. 2. The information processing system according to claim 1, wherein the business application unit, the configuration information definition file, the plurality of database access units, the analysis unit, and the interface unit are provided in a client. A client / server system in which a database unit is provided in a server. 3. A method for accessing a plurality of database units each constructed by different database software, wherein a business application unit generates a database access request, and an interface in response to the database access request. A step of performing a syntax analysis in accordance with a description rule by the section, and the analysis section refers to the configuration definition information file and selects a database access section according to a corresponding database ID;
Transmitting the database access request to the selected database access unit; and accessing the corresponding database unit according to the database access request, and obtaining an access result from the database unit. Transmitting the acquired access result to the business application unit via the analysis unit and the interface unit. 4. The database access method according to claim 3, further comprising the step of the business application unit determining, based on the received access result information, whether to make an access request again or to end the access request.