JPH07253985A - Data base access method and data base system - Google Patents

Abstract

PURPOSE:To properly rertrieve required data by preliminarily adding attribute information in a data base having a plex structure. CONSTITUTION:This access method is provided for the data base where files are connected in a plex structure, and the file where data as the retrieval object is stored is specified by a retrieval pattern related to connection relations to the other files (S11), and the file having a connection pattern corresponding to this retrieval pattern is retrieved from a data base 1 (S12), and data of this file is read out (S13).

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database access method and a database system in which files are connected to form a network structure.

[0002]

2. Description of the Related Art Conventionally, a database having a matrix structure shown in FIG. 24 and a database having a tree structure shown in FIG. 25 are known. Further, in recent years, a database having a network structure called hypertext or hypermedia has been widely adopted because it is convenient for searching in accordance with human association. FIG. 26 shows an example of a network structure database. In this database, the files indicated by squares have links (relationships) indicated by lines,
The upstream side of the line is the link source information, and the downstream side of the line is the link destination information. At the top of the square column of each file,
The data name of the data belonging to the file is stored.

When considering a database from the viewpoint of data retrieval, the database having the structure shown in FIGS. 24 and 25 has a feature that data retrieval can be performed very easily under arbitrary conditions. For example, assuming that the database in FIG. 24 shows data on the “student list of 6th year group A”, in order to retrieve the social scores of the 6th year group A students, the columns of society should be aggregated. Is enough. Further, even in the tree structure database shown in FIG. 25, if the path is clear, desired data can be easily searched.

[0004]

On the other hand, in the database having the network structure shown in FIG. 26, if a large amount of data is to be searched at one time because of the network structure, the search is scheduled.
It is necessary to add predetermined attribute data to each file (node). That is, in order to retrieve the social score of the students in the 6th year group A, the same "social score of the students in the 6th year group A" is assigned to the social score of all the students in the 6th year group A. Data must be added. Therefore,
When a large number of search conditions are planned, it is necessary to attach an extremely large amount of attribute data to each file, which causes a problem that the work is troublesome. Further, if the search condition is predicted and the attribute data is not added in advance, the search cannot be performed, so that it is impossible to set a new search condition and search for the predetermined data later. there were.

The present invention has been made as a solution to the problems of the conventional database having a network structure as described above, and its purpose is to add attribute data without adding attribute data.
An object of the present invention is to provide a database access method and a database system capable of retrieving data as needed. Another object of the present invention is to provide a database access method and a database system that can obtain necessary data by a simple designation method.

[0006]

In the database access method according to the invention described in claim 1 of the present application, in the database access method in which files are connected in a network structure, a file containing data to be searched is contained. Is specified by the search pattern related to the connection relationship with other files,
It is characterized in that a file having a connection pattern corresponding to this search pattern is searched from the database and the data of this file is read.

In the database access method according to the invention of claim 2 of the present application, in the database access method in which files are connected in a network structure, the file of the link destination specified by the link source name from the input means is When there is a search instruction, a search pattern is created based on the search instruction, which is a connection pattern of files from the file containing the link information of the link source name to the file of the link destination, and the search pattern is created. It is characterized in that the database is searched for a file corresponding to a link destination of a file group having a connection pattern corresponding to, and the data of this file is read out.

In the database access method according to the invention of claim 3 of the present application, in the database access method in which files are connected in a network structure, the predetermined data from the predetermined file from the input means has an arbitrary connection relationship. When there is a file search instruction specified by reaching a file having a name, a search pattern including a connection pattern of files from the predetermined file to a file having a predetermined data name is created based on the search instruction. Then, a file having a predetermined data name of a file group having a connection pattern corresponding to this search pattern is searched from the database, and the data of this file is read.

In the database access method according to the invention of claim 4 of the present application, there is a step of performing at least one of the processes of totaling, averaging, and sorting the read data.

In the database system according to the invention of claim 5 of the present application, a storage means for storing a database file in which the files are connected in a network structure, an input means for inputting data, and a data output. When the information for identifying the file accommodating the search target data by the connection relationship with other files is input from the output unit for performing the search, the search target data is changed to the information related to the connection relationship. Based on a search pattern consisting of a connection pattern between files based on the search pattern, search control means for searching and reading data of a file having a connection pattern corresponding to this search pattern from the database, and data read from the database. And an output control unit for giving the output to the output unit.

In the database system according to the invention of claim 6 of the present application, the output control means inputs from the input means information for specifying the file containing the data to be searched by the connection relation with other files. Then, a search pattern creating unit that creates a search pattern that specifies search target data with a connection pattern between files based on the information related to the connection relationship, and a connection that corresponds to the search pattern by searching the storage unit. A search unit that obtains a file group having a pattern from the database and detects a search target file from the file group, and a data reading unit that reads the data of the search target file searched by the search unit from the storage unit. It is characterized by doing.

The database system according to the invention of claim 7 of the present application is characterized in that it has a processing means for performing at least one of the processes of totaling, averaging, and sorting the read data.

In the database system according to the eighth aspect of the present application, the search control means is provided in the LAN server, and the input means and the output means are provided in the LAN client.

[0014]

According to the database access method of the first aspect of the present invention, the file containing the data to be searched is specified by the search pattern related to the connection relationship with other files. Even if no attribute data is added, the file accurately specifies the predetermined file in the database connected by the network structure. Then, a file having a connection pattern corresponding to this search pattern is searched from the database, and the data of this file is read out to search for necessary data.

According to the database access method of the second aspect of the present invention, the link information of the link source name can be obtained by the input means by the search instruction of the link destination file specified by the link source name. A search pattern is created which is a connection pattern of files from the accommodated file to the linked file. Then, a file having a connection pattern corresponding to this search pattern is searched from the database, and the data of this file is read out to search for necessary data.

According to the database access method of the invention of claim 3 of the present application, it is specified by arriving from a predetermined file from the input means to a file having a predetermined data name with an arbitrary connection relationship. In response to the file search instruction, a search pattern is created which is a connection pattern of files from the predetermined file to the file having the predetermined data name. Then, a file having a connection pattern corresponding to this search pattern is searched from the database, and the data of this file is read out to search for necessary data.

According to the database access method of the invention described in claim 4 of the present application, at least one of the processes of totaling, averaging, and sorting is performed on the read data, and the required form is obtained. You can get the data.

Further, according to the database system of the fifth and sixth aspects of the present application, the file containing the data to be searched is specified from the input means by the connection relation with other files. When the information is input, the search target data is specified by a search pattern consisting of a connection pattern between files based on the information related to the connection relationship, and the data of the file having the connection pattern corresponding to this search pattern is searched from the database. Then, the read operation is performed, and the read data is provided for output.

According to the database system of the invention of claim 7 of the present application, regarding the read data,
At least one of the processes of totaling, averaging, and sorting is performed, and data can be obtained in a desired form.

According to the database system of the invention of claim 8 of the present application, the file containing the data to be searched is provided from the client side to the server by providing connection relation information with other files. , It becomes possible to obtain the necessary data in the database at the client.

[0021]

Embodiments of the present invention will be described below with reference to the accompanying drawings. In each of the drawings, the same constituents are designated by the same reference numerals, and overlapping description will be omitted. In Figure 1,
The procedure of the database access method according to the embodiment of the present invention is shown. This database access method is executed in a computer system as shown in FIG. In this computer system, a main memory 11 is connected to a CPU 10, and interfaces 13 to 16 are further connected via a bus 12. Main memory 11
The control program used by the CPU 10 and various kinds of data are stored in, and a working area is further included therein. A display device 17 is connected to the interface 13, a keyboard input device 18 is connected to the interface 14, a printer device 19 is connected to the interface 15, and a network structure database is connected to the interface 16. The storage device 20 for an optical disk, a magnetic disk, or a magneto-optical disk storing these files is connected.

FIG. 10 shows an example of the essential structure of the database stored in the storage device 20. In this example, the file A stores the data having the data name “6th year group A student list”, and the file B stores the data having the data name “Taro Tanaka”.
The link information "Taro Tanaka" of the file A and the file B are linked. Such a relationship is the same between other files connected by the lines in the figure. The "general information" in each file stores the date of creation and the like.

Further, the storage device 20 stores a memory table of information relating to link relations of files relating to link information as shown in FIG. That is, when attention is paid to certain link information, the link source file name (J, K) and the link destination file name (M, P) are stored in association with each other. For example, the file name of the link source is file A and the file name of the link destination is file E corresponding to the link information “social score” of file B in FIG. The connection relation information regarding all such link information is stored in the form of a memory table.

Further, as shown in FIG. 5, the storage device 20 stores a memory table of information indicating an area in which each file name is stored corresponding to each file name. In other words, in this memory table, the start address and the length (length; length;
Byte) is stored. Therefore, for example, as for the data of the file A, it is stored in the memory table that it is sufficient to read 50 bytes from the address "10000".

The storage means 1 and the input means 2 of FIG. 1 showing the database access method according to the present invention correspond to the storage device 20 and the keyboard input device 18 of FIG. 2, respectively.
In the database access method according to the present invention, as shown in FIG. 1, in response to a search instruction from the input unit 2, a file containing the data to be searched is displayed in a search pattern related to the connection relationship with other files. A "search control" (S1) is executed in which a file having a connection pattern that corresponds to this search pattern is specified, is searched from the storage means 1 in which the database is stored, and the data of this file is read.

In the "search control" (S1), step S11 of creating a search pattern consisting of a file connection pattern based on a search instruction, and the database stores the corresponding file in the file group having the connection pattern corresponding to this search pattern. The step S12 of retrieving from the stored storage means 1 and the step S13 of reading the data of this file are performed. Thereafter, at least one of outputting and displaying the data read out in step 13 and printing out is performed (S
2). It should be noted that the search instruction from the input means 1 is specified by the search instruction of the file of the link destination specified by the link source name, and from the predetermined file to the file having the predetermined data name with an arbitrary connection relationship. If there is a search instruction for a file to be linked specified by the link source name from the input means 1, the file containing the link information of the link source name based on this search instruction. A search pattern including a file connection pattern from the file to the linked file is created in step S11 of the search pattern creation, and a predetermined data name from the predetermined file from the input means 1 with an arbitrary connection relationship. If there is a search instruction for a file specified by reaching the file having the file, the file having the predetermined data name from the predetermined file is based on this search instruction. Creating search pattern composed of the connection pattern of the file up to the yl is performed in step S11 in the search pattern creation.

In the system shown in FIG. 2, the above-mentioned database access method is executed by each means shown in FIG. That is, the storage means 1 in which the files of the database in which the files are connected by the network structure are stored, the input means 2 for inputting the data, the output means 5 for outputting the data, and the data to be searched are input from the input means 2. When the information that identifies the contained file by the connection relationship with other files is input, the search target data is specified by the search pattern that is the connection pattern between files based on the information related to the connection relationship, and this search is performed. A search control unit 3 for searching and reading data of a file having a connection pattern corresponding to the pattern from a database and an output control unit 4 for giving the read data to the output unit 5 and outputting the data.

When the search control means 3 receives, from the input means 2, the information specified by the connection relationship between the file containing the data to be searched and another file,
A search pattern creating unit 6 that creates a search pattern that specifies search target data with a connection pattern between files based on information related to the connection relationship, and a file that has a connection pattern that matches the search pattern by searching the storage unit 1. It is provided with a search unit 7 for obtaining a group from a database and detecting a search target file from this file group, and a data reading unit 8 for reading the data of the search target file searched by this search unit 7 from the storage unit 1.

The above-mentioned means are the same as those shown in FIG.
It is realized by the CPU 10 and the like by executing the program of the flowchart shown in FIG. 7, so the operation of the database system of the present invention will be described below with reference to the flowcharts shown in FIGS. 6 and 7 above
The program of the flowchart shown in is stored in the main memory 11.

A keyboard input device 18 by an operator
When a search instruction (search command) is input from the CPU
10 receives this via the interface 14 and the bus 12 (21), stores it in the working area, and analyzes the search command (22). For example, assume that a search command as shown in FIG. 8A is input. This search command connects to any file based on any link information of the file with the data name "6th year group A student list", and based on any link information of this arbitrary file, "Social test "Detect data in file having data name". So CPU
10 functions as the search pattern creation unit 6 of the search control means 3, and is one arbitrary file from the files with the data name “6th year group A student list”, which is a predetermined file, as shown in FIG. 8B. A search pattern consisting of a connection pattern of file groups up to a file having a data name "social test" which is a predetermined data name is created via.

Next, the CPU 10 detects whether or not there is a temporary route (23). Here, the temporary root is a root of a route from a predetermined file to a file having a predetermined data name with an arbitrary connection relationship, and FIG.
The designation such as corresponds to the case where there is a temporary route, and the temporary route in this case points to the file "(6th year group A student list)". Therefore, the CPU 10 searches all the data in the database for a file (data file) group having the search pattern created above (2
4) Search for a link corresponding to the path from the temporary route (25).

As a concrete example of this search, the data name “6th year group A student list” which is the predetermined file created above is used.
The file name "social test" which has a predetermined data name from one of the files of "file group up to the file" is searched according to the search pattern Extract the link information from the "List" file. Next, the data table shown in FIG. 4 is searched according to this link information to obtain the next file, and the link information is extracted from this file. Further, the data table shown in FIG. 4 is searched according to the extracted link information to obtain the next file,
This is done by checking if the data name of this file is a "social test".

Now, a search operation for a part of the beta base shown in FIG. 10 and a database as shown in FIG. 11 by simplifying a part of the beta base and adding a file to one part will be described. When the search pattern of FIG. 8 (b) is applied to the database of FIG. 11, the link information “A-kun”, “B-san”, and “C-kun” in the file with the data name “6th year group A student list” , "A", "B", "C"
In FIG. 11, there are three types of connection patterns of the file group leading to the file having the data name "social test" through the file having the data name "kun".
As a result of the search, the three files surrounded by the broken line in which the data of the “social test” of “A-kun”, “B-san”, and “C-kun” that are the search targets are stored are searched. Will be.

Next, the CPU 10 creates a list of the file group of the corresponding link destination (26). Here, FIG.
Returning to the database of FIG. 10 from the database according to the simplified example of FIG. 1, when the search command of FIG. 8 is input, as shown in FIG. , F, G will be listed. This listed file name E,
Information relating to the storage destination obtained by the CPU 10 from the memory table of FIG. 5 is added to F and G. So CP
Based on the information related to the storage destination of the list, U10 reads the corresponding data from the database and performs processing such as displaying on the screen of the display device 17 (printing out from the printer device 19) (30). An example of the data displayed on the screen 40 of the display device 17 in this manner is shown in FIG. Below the screen 40, a display area 41 for command input is secured.
The command (a) is displayed here under the control of the CPU 10.

In step 30 of FIG. 6 described above, the processing shown in the flowchart of FIG. 7 is executed so that duplicate reading does not occur by listing the same data. That is, the file names of the listed files are searched (31), and it is checked whether there is a file with the same file name (32). If there is a file with the same file name, one of the files with the same file name is left and the other files are deleted (33). In this way, after removing the duplication, it is searched from the working area search command whether or not the processing such as counting is specified in the command (34), and when the processing such as counting is specified in the command, the list is displayed. Based on this, the data in the file is read out and the corresponding tabulation processing is executed (35), while
When the processing such as tabulation is not specified in the command, the file data is read based on the list (36), the display data is obtained from the obtained data by the program in the main memory 11, and the data is displayed via the bus 12 and the interface 13. And sends it to the display device 17 for display (37). As a result, the display as shown in FIG. 15 is performed as described above.

Although duplicate reading does not occur in the database having the network structure as shown in FIG. 10, for example, as shown in FIG. 14, one arbitrary information from the link information "Ichiro Suzuki" of the file of "6th year group A student list" is selected. One from the route to the file G that has the data name "social test" which is the predetermined data name through the file D and the link information "excellent student" of the file of the "6th year group A student list" In a database that has two types of routes having a data name of “social test” that is a predetermined data name via the file D, the file G is duplicated and listed. In such a case, it can be seen that the above processing can be narrowed down to one file G.

In the above embodiment, the case where the search instruction (search command) having the temporary route is input has been described, but the search instruction (search command) having no temporary route may be input to perform the search. It is possible. In FIG. 9 (a),
An example of a search instruction (search command) without a temporary route is shown. This search command is "search for data in a file having an arbitrary data name using the link information" social test "of the file having an arbitrary data name as the link source." In response to this command, the CPU 10 executes the processing of steps 21 to 23 in FIG.
In No. 3, the process branches to “NO”, and for all data in the database, a file (data file) group having the search pattern created above is searched (27), the link information of the corresponding file is read, and the link source name is “ Search for files that are "social test" (28).

As a specific example of this search, a file group having "arbitrary data name and link information" social test "of file having arbitrary data name created in step 22" shown in FIG. ), A file whose link information is "social test" is obtained in the memory table shown in FIG. Next, FIG.
The file name of the link destination is obtained from the area of the memory table shown in.

The operation for a part of the beta base shown in FIG. 10 and a database as shown in FIG. 12 by simplifying a part of the beta base and adding a file to one part will be described. When the search pattern of FIG. 9 (b) is applied to the database of FIG. 12, “A-kun”, “B-san”, “C”
In the file with the data name "Kimi", "Akun",
There is link information "social test" in the file of "Mr. B", but "social test" in the file of "Mr. C"
Since there is no link information such as "Social score", there is no link information for "C-kun", so the file "C-kun" is excluded from the target. The two files surrounded by the broken line related to the link destination of "" are listed (29). Since the subsequent processing is as described above, the description is omitted.

FIG. 16 shows a display example in the display area 41 at the bottom of the screen 40 in response to the input of the command when processing such as totaling is specified in the search command. This search command is based on the arbitrary link information of the file with the data name "6th year group A student list".
Connect to an arbitrary file, and based on the arbitrary link information of this arbitrary file, detect the data of the file having the data name "social test" and add up. " In this system, in addition to tabulation, commands such as obtaining an average or sorting (sorting in ascending or descending order) are prepared.

FIG. 18 shows a method of accessing the database when the above-mentioned processing such as tabulation is designated in the search command. In this embodiment, with respect to the database access method of FIG. 1, a process (aggregation, etc.) is interposed between the read (S13) and the output (S2), and the read data is processed as a total, an average, and a sort. Of which
Step S14 of performing at least one process is performed.

FIG. 19 shows an example of the configuration of a database system corresponding to the fact that the above-mentioned processing such as totaling is designated in a search command. In this example, FIG.
In contrast to the embodiment described above, the data of the data reading unit 8 that reads the data of the file based on the list is received, and based on the designation of the search command including the processing such as totaling, the processing of totaling, averaging, and sorting of the read data Among them, the processing means 9 for performing at least one processing is provided.

The main memory 11 is provided with the program of the flow chart shown in FIG. 20 in order to execute the above-mentioned processing such as counting. In this example, step 2
6 and 29 are the same as those in the embodiment described with reference to FIG. When the files of the search results are listed in steps 26 and 29, the CPU 10 reads the data from the database based on the list, totalizes the data (51), and displays the display data by the program of the main memory 11 from the obtained data. It is sent to the display device 17 via the bus 12 and the interface 13 for display (52). Thereby, as described above, the display is performed as shown in FIG. This display is data to which the result of tabulation is added to FIG. The present embodiment corresponds to performing the operation in the portion surrounded by the broken line in the flowchart of FIG.

In the above embodiments, one computer system has all the means and executes all the processes, but in other embodiments, each means and corresponding processes are distributed. FIG. 21 shows a system configured by a LAN (local area network). That is, LAN interfaces 61-1 to 61-5 are connected to the LAN line 60, and client computers (clients) 62-1 to 62-4 are connected to the LAN interfaces 61-1 to 61-4. A server computer (server) 63 is connected to the LAN interface 61-5. Further, a storage device 64 corresponding to the storage device 20 (storage means 1) of FIG. 2 is connected to the server computer 63, and a network structure database is stored therein. In this database system, the search control means 3 of FIG. 3 or 19 is provided in the LAN server computer 63, and the input means 2 and output means 5 of FIG. 3 or 19 are LAN client computers 62-1 to 62-4. Is equipped with. FIG. 19
As for the processing means 9, the LAN server computer 63 or the LAN client computer 62
-1 to 62-4. Also in such a system, desired data can be appropriately searched from the database having the network structure at the installation locations of the client computers 62-1 to 62-4 in the same manner as described above.

Further, in each of the above-mentioned embodiments, an example in which one file is included in the file to be searched is shown, but in other embodiments, the file to be searched contains two or more data. There is. For example, as shown in the screen 40 of FIG. 22, the data name is “social test” file,
When three data of "1 semester 80, 2 semesters 80, 3 semesters 95" are included, when a command to retrieve the data of the "social test" is given,
All the above three data are read out and displayed on the display device 17 as shown in FIG.

In each of the above embodiments, the beta-based data is text, but in other embodiments, the beta-based data is image data. In this case, necessary data can be searched without adding attribute information to the image data database in advance, which is extremely convenient.

Further, in the database of FIG. 11, "A
When the data of the files as shown in FIG. 22 are linked to the files having the data names of “Kimi”, “Mr. B”, and “Mr. C”, respectively, the totaling processing instruction as shown in FIG. If you enter a search command that includes
The scores of the social test for the second semester of "Kimi", "Mr. B", and "Mr. C" are searched and displayed in total.

[0048]

As described above, according to the invention described in claim 1 of the present application, the file containing the data to be searched is specified by the search pattern related to the connection relation with other files. Even if no attribute data is added, the specified file of the database connected by the network structure is accurately specified and the required data is retrieved from the database, so add the attribute data in advance. It is extremely convenient because you can search for the necessary data even if you don't have to.

As described above, according to the invention of claim 2 of the present application, necessary data is retrieved from the database by instructing the retrieval of the file of the link destination specified by the link source name from the input means. It is extremely convenient because it is possible to search for necessary data when the link source is known.

As described above, according to the invention of claim 3 of the present application, a file is specified from the input means by designating a route from a predetermined file to a file having a predetermined data name with an arbitrary connection relationship. Since the database is searched and the necessary data is searched simply by giving the search instruction of, the necessary data can be searched even when the intermediate link is unknown, which is extremely convenient.

As described above, according to the invention of claim 4 of the present application, at least one of the processes of totaling, averaging, and sorting is performed on the read data, and the data is read in a desired form. Can be obtained, and necessary data can be obtained in a required form.

As described above, according to the fifth and sixth aspects of the present invention, the file containing the data to be searched is specified by the search pattern related to the connection relationship with other files. As a result, even if no attribute data is added, the file can be accurately identified as a predetermined file in the database connected by the network structure, and the necessary data can be retrieved from the database.
This is extremely convenient because it is possible to search for necessary data without adding attribute data in advance.

As described above, according to the invention of claim 7 of the present application, at least one of the processes of totaling, averaging, and sorting is performed on the read data, and the data is read in a desired form. Can be obtained, and necessary data can be obtained in a required form.

As described above, according to the invention of claim 8 of the present application, from the client side to the server,
It becomes possible to obtain the necessary data in the database at the client by giving the connection relation information of the file containing the data to be searched with other files, and in advance when sharing the database using LAN. It is extremely convenient because you can search for the necessary data without adding attribute data.

[Brief description of drawings]

FIG. 1 is a diagram showing processing steps of a database access method according to an embodiment of the present invention.

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

FIG. 3 is a functional block diagram of a database system according to an embodiment of the present invention.

FIG. 4 is a diagram showing a memory table in which link information and files used in the database system according to the embodiment of the present invention are associated with each other.

FIG. 5 is a diagram showing a memory table of storage addresses of files used in the database system according to the embodiment of the present invention.

FIG. 6 is a flowchart for explaining the operation of the database system according to the embodiment of the present invention.

FIG. 7 is a flowchart for explaining the operation of the database system according to the embodiment of the present invention.

FIG. 8 is a diagram for explaining an operation of creating a search pattern from a search instruction in the database system according to the embodiment of the present invention.

FIG. 9 is a diagram for explaining an operation of creating a search pattern from a search instruction in the database system according to the embodiment of the present invention.

FIG. 10 is a diagram showing a database having a network structure included in the database system according to the embodiment of the present invention.

FIG. 11 is a diagram showing a search operation in a database having a network structure included in the database system according to the embodiment of the present invention.

FIG. 12 is a diagram showing a search operation in a database having a network structure included in a database system according to another embodiment of the present invention.

FIG. 13 is a diagram showing a search operation in a database having a network structure included in the database system according to the embodiment of the present invention.

FIG. 14 is a diagram showing a database having a network structure included in a database system according to another embodiment of the present invention.

FIG. 15 is a diagram showing a display example of data obtained by a search operation in the database system according to the embodiment of the present invention.

FIG. 16 is a diagram showing a display example of a search instruction (command) with an aggregation process input in the search operation in the database system according to the embodiment of the present invention.

FIG. 17 is a diagram showing a display example of data obtained by a search operation corresponding to a search instruction (command) with an aggregation process input in the search operation in the database system according to the embodiment of the present invention.

FIG. 18 is a diagram showing processing steps of a database access method according to another embodiment of the present invention.

FIG. 19 is a functional block diagram of a database system according to another embodiment of the present invention.

FIG. 20 is a flowchart for explaining the operation of the database system according to another embodiment of the present invention.

FIG. 21 is a configuration diagram when the database system according to the embodiment of the present invention is configured by a LAN.

FIG. 22 is a diagram showing a display example of data obtained by a search operation in a database system according to another embodiment of the present invention.

FIG. 23 is a diagram showing a display example of a search instruction (command) with an aggregation process input in a search operation in a database system according to another embodiment of the present invention.

FIG. 24 is a diagram showing a database having a matrix structure.

FIG. 25 is a diagram showing a database having a tree structure.

FIG. 26 is a diagram showing a network structure database.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 storage means 2 input means 3 search control means 4 output control means 5 output means 6 search pattern creating section 7 search section 8 data reading section 9 (aggregation etc.) processing means 10 CPU 11 main memory 12 bus 13-16 interface 17 display device 18 keyboard input device 19 printer device 20 storage device 40 screen 41 display area 60 line 61-1 to 61-5 LAN interface 62-1 to 62-4 client computer 63 server computer 64 storage device

Claims (8)

[Claims] 1. In a method of accessing a database in which files are connected in a network structure, a file containing data to be searched is specified by a search pattern related to a connection relationship with another file, and the search pattern corresponds to this search pattern. A method of accessing a database, characterized in that a file having a connection pattern to be searched is searched from the database and data of the file is read. 2. In a method of accessing a database in which files are connected by a network structure, when there is a search instruction of a link destination file specified by a link source name from an input means, the link source name is based on this search instruction. Creates a search pattern consisting of a file connection pattern from the file containing the link information of the file to the link destination file, and corresponds to the link destination of the file group having the connection pattern corresponding to this search pattern. A method of accessing a database, which comprises retrieving a file from the database and reading the data of the file. 3. A method of accessing a database in which files are connected in a network structure, wherein a search for a file specified by a predetermined file from an input means to a file having a predetermined data name with an arbitrary connection relation When there is an instruction, a search pattern is created based on the search instruction, which is a connection pattern of files from the predetermined file to a file having a predetermined data name, and a search pattern in the file group having a connection pattern corresponding to the search pattern A method of accessing a database, characterized in that a file having a predetermined data name of is searched from the database and the data of the file is read. 4. The database according to claim 1, further comprising a step of performing at least one process of totaling, averaging, and sorting on the read data. Access method. 5. A storage means for storing a database file in which files are connected in a network structure, an input means for inputting data, an output means for outputting data, and a search target from the input means. When the information that identifies the file containing the data of the connection relationship with other files is input, the search target data is specified by the search pattern consisting of the connection pattern between the files based on the information related to the connection relationship. A search control means for searching and reading data of a file having a connection pattern corresponding to the search pattern from the database; and an output control means for giving the read data to the output means for output. Database system characterized by. 6. The output control means, when the information specifying the file containing the search target data by the connection relationship with another file is input from the input means, relates the search target data to the connection relationship. A search pattern creating unit that creates a search pattern specified by a connection pattern between files based on information, and a storage unit that is searched to obtain a file group having a connection pattern corresponding to the search pattern from the database. The database system according to claim 5, further comprising: a search unit that detects a search target file from the file group, and a data reading unit that reads the data of the search target file searched by the search unit from the storage unit. . 7. The read data is provided with a row processing means for at least one of the processes of totaling, averaging and sorting.
Database system described in. 8. The search control means is provided in a LAN server, and the input means and output means are provided in the LAN client, as claimed in any one of claims 5 to 7. Database system.