JPH01226025A - Data base access system - Google Patents

Abstract

PURPOSE:To effectively utilize a data base (DB) under a DB processor connected to a network describing skimmer definition and a skimmer retrieving condition of the DB belonging to the other machine by using a DB access language inherent in a self-machine. CONSTITUTION:The skimmer definition and skimmer retrieving condition of a DB 32 belonging to another machine to be retrieved Are inputted from an input device 22 to the self-machine 20. A retrieving information describing part 24 describes the skimmer definition and skimmer retrieving condition of the DB 32 by using the DB access language inherent in the self-machine 20 from the inputted information and stores the described contents in a retrieving information storing part 25. A retrieving information analyzing part 26 analysis skimmer information stored in the storing part 25, forms DB access information for retrieving the DB 32 belonging to the other machine 21 and stores the formed information in a DB access information storing part 27. The data retrieving information stored in the storing part 27 is sent from a communication part 28 of the self-machine 20 to a communication part 28 in the self-machine 20 to a communication part 29 in the other machine 21 connected to a network and stored in a DB access information storing part 30.

Description

DETAILED DESCRIPTION OF THE INVENTION [Object of the Invention] (Field of Industrial Application) The present invention relates to a database access method for a database processing device connected to a network.

(Prior Art) Conventionally, in order to use a database (hereinafter referred to as DB), a user has to use a high-level language for DB access (hereinafter referred to as DB access language) for the DB and the management system surrounding it. This is done by providing a DB processing formula or conditions for data retrieval. in this case,
Since the DBB management device has a control program and DB access means unique to the DBB management device, the DB access language that can be used by the DBB management device is also unique.

For example, in the B processing device 1 as shown in FIG. This schema information is written in the search information storage section 4 by the description section 3 in the B access language, which is unique to the DB processing device 1. and,
The content stored in the search information storage unit 4 is analyzed by the search information analysis unit 5, and from this the content is used to search the DB8.
B access information is generated and stored in the DB access information storage unit 6.
is stored in Then, based on this DB access information, the DB access section 7 searches the DBS and obtains the desired information.

The information obtained in this way is stored in the search data storage section 9, and further displayed on the display device 10 via the search information description section 3 to be conveyed to the user.

(Problem to be Solved by the Invention) In order to effectively utilize the 088 below B processing 8 and 1, the DB processing device 1 is connected to the network, and the DB 8
There is a way to share. However, since the DB processing device 1 is limited by its unique control program and DB access means, even if it knows the schema information and record configuration information of the DB under another i type, it cannot access the DB unique to its own model. It was not possible to search the DB under other models using the language.

The present invention has been made in view of the above-mentioned points, and an object of the present invention is to provide a B access method that makes it possible to use DBs connected to a network under models with different DB access languages.

[Structure of the Invention] (Means for Solving the Problems) The present invention includes a first database processing device and a first database processing device.
There is a second database processing device network-connected to the database processing v device of A second database processing device generates search information for searching the database, sends the generated search information to the second database processing device to search the database, and uses the search data obtained thereby to search the database. The data is configured to be transmitted to one database processing device.

(Operation) Generates information for searching DBs of other models connected to the network from the schema definition of DBs of other models written in the B access language and schema search conditions that are unique to the own model. Search the DB in other models using the information.

(Example) Hereinafter, one embodiment of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a DB access method according to an embodiment of the present invention.

In the same figure, 2'0 is the DB where the schema definition of the DB to be searched and the schema search conditions are input by the user.
21 is a DB processing device (hereinafter referred to as a different model) that is network-connected to the own model 20 and performs a DB search process according to DB access information. 22 is an input device for inputting information for instructing a DB search, schema definitions of DBs under other models, schema search conditions, etc., and 23 is a display device for displaying search information and the like. Reference numeral 24 denotes a search information description section that describes the schema definition of the DB, which is search information, and the search conditions of the schema, in accordance with the data input from the input device 22, using a B access language specific to the own type 20. Reference numeral 25 denotes a search information storage unit that stores the search information written by the search information description unit 24. 26 is a search information analysis unit that analyzes the content of the search information and generates DB access information for searching the DB. 27 is the search information analysis section 2
This is a DB access information storage unit that stores DB access information from 6.

28 is a communication unit that transmits the contents of the DB access information storage unit to other models. 29 is a communication unit in the other model 21, which receives DB access information with the communication unit 28,
and transmits search information. 30 is a DB access information storage unit that stores DB access information received by the communication unit 29. 31 is a DB access unit that searches data from the DB 32 based on the DB access information stored in the DB access information storage unit 30. 33 is a search data storage unit that stores data searched by the DB access unit and outputs this data to the communication unit 29.

The operation of the DB access method configured in this way will be explained.

Here, based on the search information input from the own machine 20, [)B32] under the other model 21 connected to the network
Let us search for data.

First, in the self-mode type 20, the schema definition of the DB 32 under the other model 21 to be searched and the schema search conditions are input from the input device 22. The search information description unit 24 describes the schema definition of the DB 32 and the schema search conditions from the input information using the B access language specific to the own machine 20, and stores the schema definition and schema search conditions in the search information storage unit 25. Then, the search information analysis unit 26 analyzes the schema information stored in the search information storage unit 25, generates DB access information for searching the DB 32 under the other model 21, and stores it in the DB access information storage unit 27. do. The information for data retrieval stored in the DB access information storage section 27 is transmitted from the communication section 28 of the self-machine fI 20 to the communication section 29 of the other model 21 connected to the network, and then stored in the DB access information storage section 30. Stored. The contents stored here are the schema definition of the DB 32 described in the search information description section 24 and the schema search conditions, so the DB access section 31 searches and retrieves data from the DB 32 based on this contents. The data is stored in the search data storage section 33.

This search data is transmitted to the own machine 20 via the communication section 29 of the other model 21, and further output to the display device 23 via the search information description section 24.

Like Kono, write the schema definition of the other model 21 and the schema search conditions using the access language specific to the own machine 20, and analyze this information to generate DB access information for searching the DB 32. This makes it possible to use the DB 32 by transmitting this information to another model 21 connected to the network with a different DB access language.

[Effects of the Invention] As described above, according to the present invention, a DB access language unique to a DB processing device is used to define schema definitions and schema search conditions of DBs directly under the processing of other DBs connected to the network. , analyze this information to generate B access information specific to other models, and send this generated information to other models to perform DB search processing.
It becomes possible to search for a DB under another line type without changing the DB access language for the type, and it becomes possible to effectively use the DB under a network-connected DBB management device.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing the structure of a database access method according to an embodiment of the present invention, and FIG. 2 is a block diagram showing the structure of a conventional database access method. 20, 21... Database processing device, 22... Input device, 23... Display device, 24... Search information description section, 25... Search information storage section, 26... Search information analysis section , 27.30... Database access information storage unit, 28.29... Communication unit, 31... Database access unit, 32... Database, 33... Search data storage unit.

Claims (1)

[Claims] First and second database processing devices connected to a network, a database searched by the second database processing device, and the second database processing device based on the search information of the database written by the first database processing device. generating means for generating search information for searching the database by the database processing device;
a first transmitting means for transmitting the search information generated by the generating means to a second database processing device;
a search means for searching the database based on the search information transmitted by the transmission means; and a second transmission means for transmitting the information retrieved from the database by the search means to the first database processing device. A database access method characterized by: