JP2002278969A - High capacity file managing database system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a high capacity file managing database system where file transfer/server retrieval technology which can be used at high speed by using an Internet line and its interface are realized. SOLUTION: In the database system, server processing procedures are collected and request processing calculation is shortened. A compression processing is automated before transfer and transfer is speeded up. Hierarchy files are previously generated for individual purpose and transfer corresponding to a request processing is made quick. On a client-side, repetitive transfer by the latest collation of a cache is avoided.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a file transfer / server search technique which can be used at high speed by using an Internet line, and a large-capacity file management database system such as a drawing database for an interface thereof.

[0002]

2. Description of the Related Art A large-capacity file management database is mainly used on a local area network (LAN) on a small-scale, part-site basis or on a large-scale, one-business-unit basis.

However, in recent years, with the improvement of the Internet technology, various systems that can be used on the Web are being developed. However, there are many interfaces that are difficult to use because of the restrictions on the network (the communication speed available on the line is low), the access speed is low.

[0004]

Normally, when a database (DB) system using the Internet line is constructed, it takes too much file transfer time as compared with a LAN (local area network) in an office, and the interface is practical. Useless cases occur.

That is, the speed of the Internet is about 80 to 1600 times lower than the speed of the LAN in the office. In a large-capacity database including drawings, CA
A drawing file such as a D file has a large capacity of, for example, 2 Mbytes to 10 Mbytes. Even if such a file exists in a server and is used at an interface of a client computer via the Internet, It takes a long time (several minutes to several tens of minutes) to transfer, which means that one drawing, one drawing is transferred slowly, making it impossible to refer to many drawings quickly. .

[0006] On the other hand, recent technological progress has been rapid, and the communication speed of Internet communication lines has been increasing recently, and large-capacity data has been gradually becoming available (broadband). It is thought that it can contribute to speeding up the database. However, the high-speed Internet access was limited to some convenient areas such as urban areas,
At present, it is necessary to configure a special communication line. For this reason, even if you try to use the above database at construction site offices such as mountainous areas,
Usually, the above-mentioned special high-speed line is not provided, and the existing telephone line, mobile telephone line, or PHS
There was no choice but to go through a line and use a large-capacity database such as drawings at a slow communication speed.

The present invention has been made in view of the above-mentioned problems of the prior art, and a file transfer / server search technique which can be used at higher speed by using an Internet line and a large-capacity file management which can realize an interface thereof. The purpose is to provide a database system.

[0008]

According to the first aspect of the present invention,
The server-side computer that has stored a large amount of data and the client-side computer are connected via an Internet communication line so that data can be transferred, and the data from the server-side computer can be searched, displayed, and transferred at high speed according to instructions from the client-side computer. Means for storing a program that collectively executes a plurality of procedural command groups in a collective instruction format in a server-side computer; and And a means for causing the server computer to execute a plurality of processing instructions based on the transmitted instruction format.

Generally, in a database system using a server computer, when a file name is displayed as a tree or a list, an inquiry to the database and the file system is made several tens of times. When an Internet communication line is used, if the number of data exchanges for this inquiry increases, the communication time increases. According to the first aspect of the present invention, in order to reduce the time of the exchange, a plurality of
Dozens of queries are sent to the server in the form of a batch command, and the server processes a plurality of processes in a batch. As a result, a large amount of search results can be obtained by one round trip communication. When the instructions of the client-side computer are not in a collective instruction format, a single SQL
Preferably, the instructions are sent to a server, which executes the SQL instructions.

According to a second aspect of the present invention, a server-side computer storing a large amount of data and a client-side computer are connected via an Internet communication line so as to be able to transfer data, and the server-side computer is instructed by a command from the client-side computer. A database system enabling high-speed retrieval, display, and transfer use of data from a client computer, means for storing a compression program in a server computer, means for storing a decompression program in a client computer, and a client computer Means for automatically compressing the file for which the transfer command has been sent from the server side computer and transferring the compressed file to the client side computer, and means for automatically decompressing the transferred compressed file on the client side computer. Have It is a large-capacity file management database system, wherein the door.

Although the communication speed of the Internet communication line is increasing, it is not so large at present, and it takes tens of minutes to transfer a large file such as a large amount of data such as CAD. To reduce the communication time, the server compresses the file before transfer, and decompresses and displays it after receiving it on the client. As a result, in a normal compression program, for example, a file compression ratio of 70
% To 10%, the transfer time can be reduced to 70% to 10% as compared with the case where the file is transferred without compression.
In this case, since the time for compressing and decompressing the file is very short compared to the transfer speed, this processing time does not affect the overall processing time. Further, since the compression program is resident in the memory of the server-side computer and is processed, even if a large amount of processing is performed, the loading processing time of the compression program becomes unnecessary. When a plurality of program transfer requests are received, a plurality of files are simultaneously compressed and decompressed on the client side.

According to a third aspect of the present invention, a server-side computer storing a large amount of data and a client-side computer are connected via an Internet communication line so as to be able to transfer data, and the server-side computer is instructed by a command from the client-side computer. Fast search and data
A database system enabling display / transfer use, wherein a server-side computer stores reference data whose data amount is reduced so that the file data can be referred to in correspondence with an original data file; and Search and retrieve data by command from client computer
2. The large-capacity file management database system according to claim 1, further comprising means for displaying the original data file from the server-side computer to the client-side computer according to the display contents of the reference data. .

Since it takes time to transfer a file, a file having a different file size is prepared on the server side for each display purpose on the client side. In other words, the display purpose on the client side is classified into a plurality of, for example, three elements, and each file is created in advance on the server side. It is preferable that the reference data is automatically created in an arbitrary format. Further, as an example, as for the reference data, if the data for reference is required to display the file for the client's display purpose, the original data file is thinned out so that the preview display can be performed at high speed. A preview data file of a file size and an image view data file capable of high-speed display at a level at which a client displays an image can be configured. Further, when the original data file is a CAD file, the DWF file in which the preview data file is thinned out from the original data file and the image in which the image view file is the original data can be determined. When the original data is a word processor file, the preview data file and the image view file can be PDF files obtained by thinning out the original data file.

According to a seventh aspect of the present invention, a server-side computer storing a large amount of data and a client-side computer are connected via an Internet communication line so as to be able to transfer data, and the server-side computer is instructed by a command from the client-side computer. A database system that enables high-speed search, display, and transfer of data, and means for storing a file in a cache memory of a client-side computer every time a server-side file is downloaded to a client-side computer. Means for sending a cache file date and a file transfer instruction to the server computer;
Means for comparing the date of the cache file with the date of the server file and displaying the cache file without downloading the file from the server if the cache file is the same date or newer It is a database system.

According to the seventh aspect of the present invention, the file once accessed is highly likely to be accessed in the near future, and the response of file display can be remarkably speeded up. Since reference to the server and registration / deletion to / from the cache disk are automatically performed, the worker has an excellent advantage that he / she does not need to be aware of the existence of the cache file disk and is easy to use.

[0016]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is an explanatory diagram of an overall conceptual model of a large-capacity file management database system such as a drawing applied to an embodiment of the present invention. FIG. 2 is an explanatory diagram of a system of a server-side computer and a client-side computer according to the first embodiment, FIG.
4A and 4B are time charts showing a comparison between a general communication procedure and the communication procedure of the first embodiment, and FIG. 5 is an explanatory diagram of a processing procedure on the server side.

FIG. 6 is an explanatory diagram of a system of a server-side computer and a client-side computer according to the second embodiment, FIG. 7 is an explanatory diagram of a communication procedure, and FIG.
7A and 7B are time charts showing a comparison between a general communication procedure and the communication procedure of the second embodiment.

FIG. 9 is an explanatory diagram of a server-side computer and a client-side computer according to the third embodiment. FIG. 10 is an explanatory diagram of an example of a server-side storage file due to a difference in original data. FIG. FIG. 12 is an explanatory diagram of a registration procedure, and FIG. 12 is an explanatory diagram of a processing procedure on the server side and the client side.

FIG. 13 is an explanatory diagram of a system for file cache collation according to the fourth embodiment, and FIG. 14 is a flowchart of file cache collation.

As shown in FIGS. 1 and 2, in the embodiment, a server-side computer 10 storing a large amount of data and a client-side computer 12 are connected via an Internet communication line 14 so as to be able to transfer data. This is a database system that enables high-speed search, display, and transfer of data of the server-side computer 10 according to a command from the computer 12.

In this database system, request processing calculations are shortened by batching server processing procedures (first embodiment). In addition, the compression process is automated before the transfer to speed up the transfer (second embodiment). In addition, a hierarchical file is created in advance for each purpose to speed up response to request processing (Embodiment 3). Further, the client side avoids repeated transfer by checking the latest cache (Embodiment 4).

Each embodiment will be described. In the first embodiment, the server-side computer 10 has a program (a plurality of proceduralized SQL (database language) in the embodiment) for executing a plurality of processing instructions in a collective instruction format.
A series of programs for continuously processing the instruction group) is stored in the memory.
A processing request unit 16 for transmitting the request (processing request) in the batched instruction format to the server-side computer 10, a request processing analyzing unit 18 for causing the server-side computer 10 to execute a plurality of processes based on the transmitted instruction format, Having.

FIG. 2 shows a processing system and FIG. 3 shows a processing flow. On the client side, a processing procedure is selected from display information of an interface such as a monitor screen of a computer (step 1), and the processing procedure is registered in advance in the server computer 10 as a processing procedure (a plurality of SQL processes are sequentially executed). It is determined whether or not it is (step 2).

As a result of the determination, if the contents of the processing procedure are registered (step 2; Yes), the client computer 12 executes a plurality of processings such as search request processing in one command form from the processing request unit 16 in one. The data is transferred (instruction of execution to the server; step 3).

In the server computer 10, the processing request data is analyzed by the request processing analysis unit 18 and the processing is sequentially executed (step 4). Then, the processing results are collectively transferred to the client computer (step 5), and the client computer 12 executes the processing based on the received results (step 6). On the other hand, if the process to be executed is not registered in the server (Step 2; No), a single SQL command is issued to the server (Step 7) and received in the server-side computer 10. A single SQL command is executed, and a processing result such as a search result is transferred to the client computer 12 (step 8). Then, the client computer 12
Receives the processing result (step 5), and executes the processing based on the received result (step 6).

Generally, in a database system using a server-side computer, when a file name is displayed as a tree or a list, as shown in FIG. 4A, dozens of queries to the database and file system are made. The process is performed, and the client receives and determines the result for each process, and after processing the result, issues an SQL command again to obtain the next information. End the final result from the server.

However, if the number of data exchanges for this inquiry increases when using the Internet communication line, the communication time becomes longer. Incidentally, the speed of the Internet is, for example, 8 times faster than the speed of the LAN in the office.
It is nearly 0-1600 times slower. In the first embodiment, in order to reduce the time of this exchange, as shown in FIG.
Dozens of queries are sent to the server in the form of a batch command, and the server processes a plurality of processes in a batch. As a result, a large amount of search results can be obtained by one round trip communication.

In general, in batch processing, it refers to a file that defines a process that moves independently according to the processing purpose so as to run continuously. On the other hand, in the present embodiment, the logic for sequentially processing logic according to the purpose at the program level is blocked and embedded in the program in the server. The result is also automatically returned to the designated client from within this program.

FIG. 5 is an explanatory diagram of the server process procedure. The display of the client computer is a tree view,
Alternatively, when a list is displayed, a folder or a file is selected in any of them, and processing such as acquisition of a file name in the server is performed.

In the second embodiment, as shown in FIGS. 1 and 6, an appropriate storage means such as a hard disk for storing a compression program in the server computer 10 and a compression processing unit 2 are provided.
0, a cache file for storing the decompression program in the client computer 12 and the decompression processing unit 28,
A file, such as a CPU, a memory, and a terminal adapter, for automatically compressing a file for which a transfer command has been received from the client-side computer by the server-side computer 10 and transferring the compressed file to the client-side computer 12 via the Internet communication line 14. A transmission processing unit 19 and a file reception processing unit 29 such as a CPU, a memory, and a terminal adapter for automatically decompressing the transferred compressed file on the client computer 12.
And

FIG. 7 is a flowchart of the pre-transfer compression processing.

The client computer issues a download instruction to the server computer (step 21). In the server, the download of the file specified by the resident compression software is started (step 22). After the compressed file is downloaded on the client side and completed (steps 23 and 24), decompression processing of the file is started (step 25) and the file is displayed after the decompression is completed (steps 26 and 27). ,
finish.

As described above, since the communication speed of the Internet communication line is much lower than that of a LAN or the like, the CAD
It takes a few minutes to tens of minutes to transfer a file such as a large file. In order to reduce the communication time, the file transmission processing section 19 performs file compression processing on the server side before transfer, and decompresses and displays the received data on the client side. As a result, the file compression ratio is 70% to 1%.
Since it is 0%, the transfer speed can be reduced by 70% to 10% as compared with the case where the file is transferred without compression, as shown by comparing before the improvement in FIG. 8A and after the improvement in FIG. it can.
Also, since the time for compressing and decompressing a file is very short compared to the transfer speed, this processing time does not affect the overall processing time. Further, since the compression program resides on the memory of the server and is processed, even if a large amount of processing is performed, the loading time of the compression program is not required. Also,
When a request to transfer a plurality of programs is received, a plurality of files are simultaneously compressed and decompressed on the client side.
Furthermore, instead of performing compression for each process on the server-side computer, a method of preparing a compressed file that has been compressed in advance may be used. By doing so, it is only necessary to transfer the compressed file when instructed, so that the time can be further reduced. If the date and time of the master (master file of raw data) and the compressed file are compared and transferred, consistency can be ensured.

Next, a third embodiment will be described.

In the third embodiment, as shown in FIGS. 1 and 9, this server-side computer stores reference data whose data amount is reduced so that the file data can be referred to in correspondence with the original data file. And a means for retrieving and displaying reference data in accordance with a command from the client computer, so that the original data file can be transferred from the server computer to the client computer based on the display contents of the reference data.

In the third embodiment, as shown in FIGS. 9 and 10, the files on the server-side computer 10 have various sizes, such as CAD files, scanning files, word profiles, and photo files.
Suppose you have a form. When transferring these files, it takes time to transfer the files, even though they are compressed, so a file with a different file size is prepared on the server for each display purpose on the client side. That is, the display purpose on the client side is classified into three types, and the server side prepares each file in advance. When real data (detailed data) is required, the raw data is displayed with the data creation software. When appropriate data for referring to a file is required, high-speed display data is displayed in a dedicated view wheel. When high-speed display at a level to display an image is required, small image data is displayed by an image viewer.

According to the flow of FIG.
The real file is registered in the server (step 31). Reference data (data for preview) is created by thinning out the actual data (step 32a), and image view data is created (data for image display) (step 32b).

When the client uses the server-side data, first, as shown in FIG. 12, a display file is selected from the server (step 4).
1). If the thumbnail display is instructed, the image display data is automatically displayed (step 41b,
41b). Then, a list of files by purpose having the same name is displayed (step 42). In the case of operating the actual data, the actual date is selected (step 43a), and when operating the reference data, the preview data is selected (step 43).
b) When the image view data is operated, the image display data is selected (thumbnail is automatically displayed) (step 43c). The display process is performed and the process ends (step 44).

In the third embodiment, generally, it takes time to transfer a file. Therefore, a file having a different file size is prepared on the server side for each display purpose on the client side. That is, the display purposes on the client side are classified into a plurality, for example, two types or three elements, and are managed in association with each other. The system creates each file in advance on the server side. As an example, as in the invention, the reference data is a preview data file of a file size thinned out so that a preview display of the original data file can be performed at a high speed if the client's display purpose requires data enough to refer to the file. And an image view data file capable of high-speed display at a level at which the client displays images. When the original data file is a CAD file, the preview data file is a DWF obtained by thinning out the original data file.
File and bitmap data (CFJ) for which the image view file can determine the image of the original data.
(JPG) file, and when the original data is a word processor file, the preview data file and the image view file can be converted to PDF files by thinning out the original data file. Also, in the case of scanning file data or a photo file, if the data is Tiff data (500 Kbytes), actual data is used as reference data, and the image view data is bit map data ( CFJ (JPG) file).

Embodiment 4 will be described.

In the database system according to the fourth embodiment, as shown in FIGS. 1 and 13, the client computer 12 stores the file in the cache memory of the client computer 12 every time the server file is downloaded. Means for sending the date of the cache file and the file transfer command from the client-side computer 12 to the server-side computer 10; and checking the date of the cache file with the date of the server file. A large-capacity file management database system having means for displaying a cache file without downloading a file.

According to this database system, a file to be displayed is selected (step 51), and all information on the file is obtained (step 52). It is determined whether or not the file is in the folder in which the relative path is set (step 53). The relative path indicates the position of a folder for caching files in the client and in the local LAN. When a sharing position in the LAN is designated, each client can share and use it.

If the result of the determination in step 53 is negative, it is determined whether or not a relative path exists on the client side (step 54). If a relative path exists,
It is determined whether or not a file having the same name exists in the relative path (step 55). Then, it is determined whether or not the date of the file in the relative path is new (step 56). If the date is new, the file of the relative path is read (step 57) and displayed.

On the other hand, if the result of the determination in step 53 is negative, the file on the server side is downloaded and the file is read (steps 58 and 59) and displayed.

If the result of step 54 is negative, a new relative path is created (step 60), and a file on the server side is downloaded (step 61).
The file is placed at the position of the relative path (step 62), and the file is read (step 63) and displayed.

When the result of the determination at the step 55 is negative, the process proceeds to the step 61 and thereafter, and the work such as downloading is performed.

If the result of the determination in step 56 is negative, the file is downloaded (step 64),
The same file name of the relative path is overwritten (step 65), and the file is read (step 66) and displayed.

According to the fourth embodiment, a file once accessed is highly likely to be accessed in the near future, and the response of file display can be remarkably speeded up. Since reference to the server and registration / deletion to / from the cache disk are automatically performed, the worker does not need to be aware of the existence of the cache file disk. In addition to using the cache file of the client computer, the cache file can be shared (shared cache file) in the LAN network as shown in FIG.

In the first to fourth embodiments described above, the transfer processing time can be reduced even when applied to a large-capacity file management database. However, if the transfer processing is performed in combination of two or more, the processing time is further reduced. Can be In particular,
By combining the second and third embodiments, the reference data and the image view data are transferred as they are without being compressed, and when the necessary actual data is retrieved, it is transferred as a compressed file and can be used on the client computer. In this case, since the compression processing is not performed every time the data is transferred, the compression processing time can be minimized and the overall processing time can be reduced.

[0051]

As described above, according to the present invention, it is possible to realize a file transfer / server search technique and an interface thereof which can be used at higher speed by using an Internet line in a large-capacity file management database.

[Brief description of the drawings]

FIG. 1 is an explanatory diagram of an overall conceptual model of a large-capacity file management database system such as a drawing applied to an embodiment of the present invention.

FIG. 2 is an explanatory diagram of a system of a server-side computer and a client-side computer according to the first embodiment;

FIG. 3 is an explanatory diagram of a communication procedure.

FIGS. 4A and 4B are general communication procedures and Embodiment 1.
6 is a time chart showing a comparison of the communication procedures.

FIG. 5 is an explanatory diagram of a processing procedure on the server side.

FIG. 6 is an explanatory diagram of a system of a server-side computer and a client-side computer according to a second embodiment;

FIG. 7 is an explanatory diagram of a communication procedure.

FIGS. 8A and 8B are general communication procedures and Embodiment 2.
6 is a time chart showing a comparison of the communication procedures.

FIG. 9 is an explanatory diagram of a system of a server-side computer and a client-side computer according to a third embodiment;

FIG. 10 is an explanatory diagram of an example of a server-side storage file due to a difference in original data.

FIG. 11 is an explanatory diagram of a server-side registration procedure.

FIG. 12 is an explanatory diagram of a processing procedure on the server side and the client side.

FIG. 13 is an explanatory diagram of a file cache collation system according to a fourth embodiment;

FIG. 14 is a flowchart of file cache collation.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 Server side computer 12 Client side computer 14 Internet communication line 16 Processing request part 18 Request processing analysis part 19 File transmission processing part 20 Storage means and compression processing part 28 Cache file and decompression processing part 29 File reception processing part

──────────────────────────────────────────────────続 き Continued on the front page (51) Int. Cl. ⁷ Identification symbol FI Theme coat ゛ (Reference) G06F 13/00 520 G06F 13/00 520B 15/00 310 15/00 310P (72) Inventor Yoshitaka Ishikawa Tokyo 6-15-1, Ginza, Chuo-ku Power Supply Development Co., Ltd. (72) Inventor Tomoji Nakai 6-15-1, Ginza, Chuo-ku, Tokyo Inside Power Supply Development Co., Ltd. (72) Inventor Hiroshi Matsui Minato-ku, Tokyo No. 14-14-1001 Mita Developed by CFC Software Co., Ltd. (72) Inventor Mitsukoshi Gumi No. 144-14-1001 Mita Minato-ku, Tokyo C.F. F term (for reference) within Sea Software Development 5B075 KK02 KK23 NR16 PQ48 5B082 GA01 GA08 HA02 HA05 5B085 BE08 BG07 CC03 CC16

Claims (7)

[Claims] 1. A server-side computer storing large-capacity data and a client-side computer are connected via an Internet communication line so as to be able to transfer data, and data of the server-side computer is searched at high speed by a command from the client-side computer. A database system which enables display / transfer use, wherein a server-side computer stores a program for processing and executing a plurality of procedural instruction groups collectively in an instruction format; and A large-capacity file management database system, comprising: means for transmitting the collective command format to the server-side computer; and means for causing the server-side computer to execute a plurality of processing commands based on the transmitted command format. 2. A server-side computer storing a large amount of data and a client-side computer are connected via an Internet communication line so as to be able to transfer data, and the data of the server-side computer is searched at high speed in accordance with a command from the client-side computer. A display / transfer-enabled database system for storing a compression program on a server computer, storing a decompression program on a client computer, and transmitting a file for which a transfer command has been received from the client computer. A large capacity comprising means for automatically compressing a compressed file on a server computer and transferring the compressed file to a client computer, and means for automatically decompressing the transferred compressed file on a client computer. Fa File management database system. 3. A server-side computer storing large-capacity data and a client-side computer are connected via an Internet communication line so as to be able to transfer data, and data of the server-side computer is searched at high speed by a command from the client-side computer. A database system that enables display / transfer use, and stores, on a server-side computer, reference data whose data amount is reduced so that the file data can be referred to in correspondence with the original data file; Means for retrieving and displaying data for use in response to a command from the client-side computer, wherein the original data file can be transferred from the server-side computer to the client-side computer based on the display contents of the reference data. Large-capacity file management described in 1. Over database system. 4. The large-capacity file management database according to claim 3, wherein reference data is automatically created in an arbitrary format. 5. The reference data, if the client needs to display data for the purpose of referring to the file for display purposes,
A preview data file with a file size thinned out so that the original data file can be previewed at high speed,
5. The large-capacity file management database according to claim 3, wherein an image view data file capable of high-speed display at a level at which a client displays images is displayed. 6. When the original data file is a CAD file, the preview data file is a DWF file obtained by thinning out the original data file, and the image view file is bitmap data from which an image of the original data can be determined. 6. The data processing apparatus according to claim 3, wherein when the original data is a word processor file, the preview data file and the image view file are PDF files obtained by thinning out the original data file. Large file management database. 7. A server-side computer storing large-capacity data and a client-side computer are connected via an Internet communication line so as to be able to transfer data, and data of the server-side computer is searched at high speed in accordance with a command from the client-side computer. A database system that enables display / transfer use, a means for storing a file in a cache memory of a client computer each time a server file is downloaded to a client computer, and the date and time of the cache file from the client computer. The method of sending the file transfer command to the server computer and the date of the cache file and the server file are compared. If the cache file is the same date or newer, download the file from the server. And a means for displaying a cache file.