JPH06243002A - Data base processing method using file - Google Patents

Abstract

PURPOSE:To provide a data base processing method which uses a file and by which the data use of data bases becomes facile without generating a complicated data base access program. CONSTITUTION:The data base processing method by which access is executed for the bases 11 and 12 and a data processing is executed by using data obtained from the data bases 11 and 12 is provided with a first process 13 where the data bases 11 and 12 are retrieved 13 and a retrieved result is outputted to the file 14 and a second process 15 where the file to which the retrieved result is outputted, is fetched and the data processing is executed.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database processing method using a file, and more particularly to a database processing method using a file that allows easy use of database data without creating a complicated database access program. It is a thing.

[0002]

2. Description of the Related Art Conventionally, as the demand for a database management system has become more complicated and sophisticated, and as the database system has become networked, the burden of developing programs for a system that uses a database has become heavier. Development of mitigation methods is desired.

In a database system which is widely used in recent years, the SQL language (database language SQ
L: JIS X3005-1990) has been widely used. In response to this, in a general-purpose database system, the SQL language (database language S
QL: JIS X3005-1990), the system is constructed so that the database management system executes a process of reading the SQL language to search the database and a process of displaying the search result.

Recently, in order to easily and arbitrarily access a database existing in another workstation on the network, a server function for realizing a database search function and an obtained search result are displayed. A system in which a database system is constructed so that each processing system is executed by a separate process has also been developed, separately from the client function to perform.

[0005]

However, in the processing system of the database system as described above, the processing system is divided into a server process and a client process, but the server process and the client process are different from each other. Communication between networks (communication between networks) is performed using the network communication protocol that is individually defined for each database management system. A client function processing system will be created using the provided application interface for database access (including communication protocol).

However, different databases such as imformix and ORACLE have different application interfaces for accessing the respective databases through the network. Therefore, in order to create an inquiry system for different databases, the processing of the client function is performed each time. In order to create a system program, the database access part had to be recreated. Further, in order to create a program for the processing system of the client function, if these database access parts are not completed, there is a problem that it is not possible to debug even if other parts are created.

For this, for example, Japanese Unexamined Patent Publication No. 1-177.
Proposal of configuring the system to return only the database search result to the data requesting side and input only the result data for processing, as in the proposal of “inter-computer database access method” described in Japanese Patent No. 634 publication. There is. According to this, since it is not necessary to create a complicated database access part, there is no problem in debugging when creating a program of a client function processing system. However, even in such a system, a unique communication path (connection) is required for communication between the server process and the client process, and special processing is required for the server / client processing at the own site. There is a problem that must be done.

The present invention has been made in order to solve the above problems, and an object of the present invention is to create a file that allows easy use of database data without creating a complicated database access program. It is to provide a database processing method used.

[0009]

In order to achieve the above object, a database processing method using a file of the present invention is to access a database and perform data processing using data obtained from a database. A method for processing a database, comprising: a first process for searching a database and outputting a search result to a file; and a second process for fetching a file in which the search result is output and performing data processing. It is characterized by

[0010]

In the database processing method using a file of the present invention, a file in a network environment, for example, is used for communication between the database server process and the client process. That is, the first process, which is the server process, searches the database and outputs the search result to a file. The second process, which is the client process, takes in the file in which the search result is output and processes the data. By performing the processing of the first process and the second process as described above, and performing the data communication between them through the file of the network environment, the access processing to the database is performed, and the data obtained using the database is used. The processing can be easily performed.

As described above, in a so-called network environment, files can be shared between networks on the operating system, and it is not necessary to consider a complicated communication path or the like through the files. Therefore, each process of the server process and the client process can be executed by other workstations in the network environment. Moreover, it is not necessary to consider any communication path when each process is executed on the network.

For this reason, for example, in regard to the database inquiry processing in the application program, the database search processing and the search result analysis processing are executed as separate processes, and further, the communication between the processes is performed in a network environment not dependent on the database. By using this file, it is possible to easily create a processing system for making inquiries to various types of databases by simply creating new database search processing processes for different types of databases. it can.

Further, since the database search process and the process of using the search result can be designed and manufactured independently of each other, the processing system of the database system can be created in a short time. Further, even if the database search processing system is not created, a search result processing system similar to the result obtained by the database search is created in advance as a separate file to create a search result processing system. In addition, it is possible to easily debug the created processing system.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be specifically described below with reference to the drawings. FIG. 1 is a block diagram illustrating the flow of processing in a system that implements the database processing method using files of the present invention in one aspect. In FIG. 1, 11 is a first database (informix), 12 is a second database (ORACLE), 13 is a database search process, 14 is a search result file, and 15 is a search result processing process. Further, 16 is a printing device, 17
Is a display device. In the basic configuration of the database processing system here, as shown in FIG. 1, the processing system includes a database search process 13 and a search result processing process 1.
5, and a search result file 14 of, for example, a network environment, which does not depend on a database for performing communication between these two processes.

In the database processing method here, the database search process 13 searches the first database 11, for example, and outputs the search result to the search result file 14. Alternatively, the database search process 13 performs, for example, a search on the second database 12, and similarly outputs the search result to the search result file 14. Search result file 14 with the search results output
Next, the data is loaded into the search result processing process 15 and data processing using the search result file 14 is performed. The result of this data processing is printed by the printing device 16 and displayed by the display device 17. As a result, it becomes possible to access the same database as the database system and perform data processing using the data obtained from the database.

FIG. 2 is a block diagram for explaining the configuration of the database inquiry system according to the embodiment of the present invention. In FIG. 2, 20 is a network (LAN), 2
1 is the first database (ORACLE), 22 is the first
Database server, 23 is a first database search process, 24 is a second database (informix), 2
5 is a second database server, and 26 is a second database search process. Further, 27 is a first workstation and 28 is a second workstation.
29 is a third workstation. Reference numeral 31 is a keyboard, 32 is a search processing process, 33 is a search result file, 34 is a search result processing process, 35 is a display terminal device, and 36 is a printing device.

Next, the operation of the database inquiry system shown in FIG. 2 will be described. For example, in the third workstation 29, the end user activates the search processing process 32 by operating the keyboard 31, whereby the database inquiry system capable of inquiring the database is activated.
When making an inquiry to the database, the search processing process 32 uses the SQL command input by the user from the keyboard 31 or the SQL command string internally configured as an argument to search the first database search process 23 or the second database search process. 26 is activated.
In the activated first database search process 23 or second database search process 26, the SQL command passed using the respective database access interface is sent to the first database server 22 and the second database server 25. Send each.

For example, in the first database server 22, a search process is performed on each database 21 by the passed SQL command, the result of the search process is obtained, and then the result is obtained by the first database search process 23. Is output to the search result file 33 as file data. In this case, the search result processing process 34 reads the file data of the search result file 33 obtained from the database search process 23, displays the result on the display terminal device 35, or performs some processing on the search result. , Connected printing device 36
Data will be printed due to the above.

FIG. 3 is a diagram showing an example of a search result file obtained by the database search process. The database inquiry system shown in FIG.
In this embodiment, the data of the ix database or the ORACLE database is used. In this case, for example,
When the search result is directly converted into a tabular file, the search result of the database can be obtained as the file data of the text file 40 in the same format as shown in FIG. ) Only system, the processing system of the database processing system is easy by creating the database search process (23, 26) for each database with almost no modification to the search result processing process. It is possible to construct a database processing system that can be created in the database and can use data in various databases.

In this case, again, the search result file is
For example, as shown in FIG. 3, in the case of the text file 40, a text editor similar to the above can be used to prepare a text file similar to the search result to easily debug the search result processing process. .

Further, even when the database system is operated on another network, this embodiment is performed in a network environment in which file transmission / reception between networks and program starting means provided by PC-NFS or the like are provided. The database processing system can be realized by simply using the configuration including two processes of the database search process and the search result processing process in the network environment as in the example configuration.

According to the database processing system composed of two processes of the database search process and the search result processing process as in this embodiment, for example,
By using a network environment, let other high-performance workstations and host computers perform a database search process for relational databases, and the search result processing process should run on a low-cost computer such as a personal computer (personal computer). Then, it is also possible to construct a database processing system.

Further, the files exchanged between the database search process and the search result processing process are
By using a text file as shown in FIG. 3 consisting of ASCII characters or EUC character strings that can be edited with a normal text editor, it becomes easy to easily create search result data for testing.

[0024]

As described above, according to the database processing method using a file of the present invention, the database inquiry process is executed as a separate process of the database search process and the search result analysis process. Moreover, by using a file that does not depend on the database as an exchange between processes, it is possible to easily create a processing system for making inquiries to various types of databases simply by creating a new database search processing process. it can. As a result, it is possible to construct a database processing system that enables easy use of database data without creating a complicated program.

[Brief description of drawings]

FIG. 1 is a block diagram illustrating a processing flow in a system that implements a database processing method using a file of the present invention in one aspect;

FIG. 2 is a block diagram illustrating a configuration of a database inquiry system according to an embodiment of the present invention,

FIG. 3 is a diagram showing an example of a search result file obtained by a database search process.

[Explanation of symbols]

11 ... 1st database (informix), 12 ... 2nd database (ORACLE), 13 ... Database search process, 14 ... Search result file, 15 ... Search result processing process, 16 ... Printing device, 17 ... Display device, 20 ... network (LAN), 21 ... first database (ORACE), 22 ... first database server, 23 ... first database search process, 24
... second database (informix), 25 ... second database server, 26 ... second database search process, 27 ... first workstation, 28 ... second workstation, 29 ... third workstation,
31 ... Keyboard, 32 ... Search processing process, 33 ... Search result file, 34 ... Search result processing process, 35 ...
Display terminal device, 36 ... Printing device, 40 ... Text file.

Claims (1)

[Claims] 1. Accessing a database,
A database processing method for performing data processing using data obtained from a database, comprising a first process of searching a database and outputting a search result to a file, and a file to which the search result is output. A database processing method using a file, comprising: a second process for capturing and processing data.