JP2000285060A - Data transfer method, computer readable recording medium and data transfer device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the data transfer rate by reproducing a data characteristic table and a retrieval data table from the transfer data sent to a memory area of a client device and reading the prescribed data out of both reproduced tables respectively. SOLUTION: A server 3 having a data base 2 is connected to plural client devices 4 via a network 5. The devices 4 transmit the retrieval commands to the server 3 via a digital communication circuit 10 and the network 5. The server 3 retrieves its data base in response to those received retrieval commands and transfers these retrieval results to the devices 4 via the circuit 10 and the network 5. Then a data characteristic table and a retrieval data table are reproduced from the transferred data in the memory area of every device 4 and the prescribed data are read out of both tables respectively.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] The present invention relates to a data transfer method. More specifically, the present invention relates to a data transfer method for connecting a client machine and a database server via a network, performing data search based on a search command from the client machine, and transferring the searched data from the database server to the client machine.

[0002]

2. Description of the Related Art A database server configured to perform a search using a network is provided with a large-capacity storage device in a computer equipped with a high-speed CPU, a network operation system and application software dedicated to the database server. And is provided. A client machine is connected to the database server via a network, a search request is made from the client machine via the network, and a search is performed in the database server. Then, the search result data is transferred to the client machine via the network.

In order to widely utilize a database, a database server is connected to a large number of client machines via a wide area network such as the Internet or an in-house LAN. The client machine and the database server are connected to the Internet using a high-speed digital communication line or a dedicated communication line in addition to a telephone line. TCP / IP is used as a global standard as a communication protocol for exchanging information.

[0004] The types of data searched in a database vary widely, and the characteristics of the searched data are not constant. The information retrieved from the database takes a table format in which data is arranged vertically and horizontally. This table consists of a number of rows with a similar structure. Each row is a unit of information and is the minimum unit of database search results. Each line above consists of items,
This item is the minimum unit of information handled by the database.

[0005] In order to transfer the search result on the server side to the client machine, the transfer operation is repeated for each of the above items or for each line. Therefore, in the case of search data composed of a large number of rows, a huge amount of time is required for the transfer procedure.

When data is transferred via a general-purpose network such as the Internet, the line is shared with other users. For this reason, if the number of line users is large, the transfer time becomes long. In addition, if the bandwidth of the communication line is narrow, the transfer time becomes longer, and the database cannot be used effectively. For this reason, even when data can be searched at high speed on an in-house LAN, the search speed often drops significantly through a network using a public line such as the Internet.

For example, in the invention described in Japanese Patent Application Laid-Open No. Hei 8-286889, only the difference between the data files to be transferred is transferred, and the client machine restores the data file from the difference data and the previously transferred data. There is a transfer method to do. Also, in the invention described in Japanese Patent Application Laid-Open No. Hei 9 198,285, a function in which access processing from a client machine to a database on a server and transfer processing of data other than a database are executed independently of an application to be developed are executed. And the same language and the same interface.

[0008]

The data extracted from the database is diversified. In addition, the characteristics of the search data, the size of the search data table, and the like change with each search. For this reason, a data transfer method in which a fixed data table format is stored in the client machine and only the difference between the data tables is transferred is not versatile. Also, all data retrieved based on the retrieval command must be finally transferred to the client side. Therefore, the data transfer method described in the first publication cannot increase the transfer speed.

Further, in the invention described in the second publication, the transfer efficiency is improved by rationalizing the use form of the database, and the data transfer method, the form of the transferred data, etc. It remains the same.
Therefore, the data transfer speed itself does not improve, and the transfer speed is greatly reduced depending on the state of the communication line.

It is an object of the present invention to increase the transfer rate of data searched in a database in a conventional communication environment. It is another object of the present invention to shorten the response time in using a database and increase the efficiency of using the database.

[0011]

According to the invention described in claim 1 of the present application, a client machine and a server storing a database are connected via a communication line, and based on a search command from the client machine, The present invention relates to a data transfer method for transferring data retrieved from a database from the server to the client machine. The data transfer method according to the present invention includes a data table generating step of generating a data characteristic table and a search data table storing characteristics of searched data in a memory area provided on the server side, and the data characteristic table and the search data table. A transfer data generating step of serializing and concatenating the items constituting the transfer data to form transfer data; a control information adding step of adding control information according to characteristics of the transfer data to the head of the transfer data; A data transfer step of transferring the transfer data generated in the transfer data generation step to the client machine; and a data table for reproducing a data characteristic table and a search data table from the transferred transfer data in a memory area provided on the client machine side. The reproduction process, the reproduced data characteristic table and the retrieved data And a data reading step of reading predetermined data from the data table.

The present invention converts data to be transferred into a form that can simplify the transfer procedure of a communication line. Further, the transfer speed can be increased by compressing and transferring the converted data.

In the present invention, the search result is temporarily stored in the memory area on the database server side. In recent years, the performance of computers and peripheral devices constituting a server has been remarkably improved, and a large memory area can be easily secured.
In addition, the data transfer speed within the server or between the server and peripheral devices is significantly higher than the data transfer speed via a communication line. Therefore, even if the search data is temporarily stored in the memory area on the server side, there is almost no effect on the search speed. The memory area on the server side includes not only the memory area in the server but also the memory area in the peripheral device.

The search data table is a table composed of actual data searched from a database based on a search command. The data characteristic table is a table for storing data describing characteristics of the retrieved data. The data characteristic table includes, for example, items that describe each item name, data type, arguments, and the like corresponding to the search data.

The method of generating the search data table and the data characteristic table is not particularly limited, and can be performed by a method similar to a method of storing ordinary search data in a storage device such as a memory.

The serialization of the data in the transfer data generation step is performed by converting each item constituting the data characteristic table and the retrieval data table into a continuous data string. For example,
In the case of a table consisting of three lines, this is performed by making the characters and the like in the data items constituting each line continuous, and making the items of the lower line continuous at the rear end of the upper line. No symbol identifying the line is inserted between each successive line. Along with the serialization of each table, a data string obtained by serializing the data characteristic table and a data string obtained by serializing the search data table are connected. It is not necessary to particularly insert identification information between a data string obtained by serializing the data characteristic table and a data string obtained by serializing the search data table. However, identification information can be inserted according to the characteristics of the search data.

Through the transfer data generation step, a large number of data constituting the table is converted into one columnar data. When all items in the search data table are text data, the transfer data has a structure in which texts are arranged in a line. Further, even when information other than text data such as image data is included in a part of the items constituting the search data table, the items of the image data are arranged in a line by treating the items in the same manner as one text data. Can be.

Next, a control information adding step of adding control information according to the characteristics of the transfer data to the head of the transfer data is performed. The size of the search data table is
The configuration of items and the like differ for each search. Therefore, unless these pieces of information are transmitted to the client machine, the table cannot be reproduced from the one-line transfer data. For this reason, control information relating to the characteristics of the transfer data is added to the head of the transfer data. The control information includes the size of transfer data, the presence and method of data compression, the size of decompressed data, and the like. In addition, when trouble occurs in the search operation, control information for a case where there is no search result can be added. By adding these pieces of control information, it is possible to quickly secure a memory area at the transfer destination, and to perform data transfer smoothly.

The transfer data and control information are based on TCP / IP
The data is output to a communication line via a transmission means employing a protocol or the like, and is transferred to a client machine. Since the transfer data can be transferred as one set of columnar data in a single procedure, the time required for transfer can be significantly reduced as compared with the conventional data transfer method. The client machine receives the transfer data via a receiving unit. Then, in the memory area on the client machine side,
A data table reproduction process for reproducing the data characteristic table and the search data table from the transfer data is performed. The memory area on the client device side also includes a memory area in a peripheral device.

Desired search data is read from the data characteristic table and the search data table reproduced by the client machine. In the above-described client machine, even if the transferred data is once stored in the memory area,
There is almost no effect on the search speed for the same reason as in the above server.

According to the data transfer method of the present invention,
Database search can be performed without changing the conventional search method, communication means, and the like. Because of this, search methods,
There is no need to change the configuration of the device. Also, the person operating the client machine can perform a search operation exactly the same as the conventional database search.

According to a second aspect of the present invention, there is provided a data compression process in which the server side compresses serialized transfer data, and includes information on the compression method in the control information. A data decompression step of decompressing the received data to generate transfer data.

Since the transfer data is a row of data, it can be easily compressed using a known compression method. As a result, the amount of transferred data itself can be reduced, and the transfer time can be further reduced.

According to a third aspect of the present invention, there is provided a compression judging step for judging whether or not to compress the transfer data in accordance with the data characteristics of the transfer data, and If it is determined, the data compression process includes compressing the transfer data and causing the control information to include information on the compression method.

Depending on the search result, it may not be necessary to compress the data. Also, depending on the characteristics of the data,
The time required for compression may be long. In such a case, the response time is shorter if the data is transferred without being compressed. Also, according to the characteristics of the data, the amount of data, etc.,
The best compression method should be applied. In the present invention, the characteristics of the transfer data are analyzed, and the presence or absence of compression, the compression method, and the like are selected. The presence / absence of the compression and the compression method are characteristics of the transfer data itself, and are transferred to the client machine while being included in the above-described control information.

The invention described in claim 4 of the present application is applied when each item of the retrieval data table and each item of the data characteristic table are text data. The text data may be any text data that can be recognized and transferred on a computer as text information, that is, character / code information. The text data includes not only characters such as alphabets and kanji, but also numbers, symbols, commas, and the like. Further, the present invention can be applied to text data in various languages.

In the present invention, the elements constituting each item of the search data table are serialized as they are regardless of their meaning and type, converted into a text data string, and transferred. For example, even if a number in an item represents an amount, a date, or the like, it is recognized as a character string and serialized as it is. Since the data characteristic table is also composed of text, the transfer data is one data in which the text is integrated in a row, and is transferred by one transfer procedure.
As a result, the transfer time can be significantly reduced.

In the invention described in claim 5 of the present application, the search data table extracted from the database contains data items other than text data. The database can store not only the text information described above but also image and audio information. The present invention is an application of the present invention to a database including data other than text data. In the present invention, since a compression method can be selected according to transfer data, a search data table including images and the like can be transferred efficiently.

According to a sixth aspect of the present invention, in a client machine, a search command data generation step of serializing a search command, a search command data transfer step of transferring the search command data to a server, And a search command reproducing process for converting the search command data into a search command for operating a database.

Even when the retrieval command of the database is short, if the retrieval command is transferred while identifying each line, the number of transmission procedures increases and the transmission time increases. According to the present invention, a search command such as a search command is serialized and transferred in the same manner as the transfer of a search data table. The serialization means is serialized in the same manner as the serialization of the search data table according to any one of claims 1 to 5, and if necessary, control information is added, compressed, and transferred.

According to a seventh aspect of the present invention, a micro server receiving a search command from a plurality of client machines and a main server storing a database are connected via a communication line, and the search command is transmitted to the micro server. A database search method for transferring data retrieved from the database to the client machine via the microserver, while transferring the retrieved data from the database to the client machine via the microserver. A data characteristic table describing the characteristics of the search data table is generated and stored in the memory area, and the items constituting the search data table and the data characteristic table are serialized and combined to generate transfer data. Control information according to the characteristics of the While transferring to the server, the micro server stores the data characteristic table and the search data table reproduced from the transfer data in a memory area, reads predetermined data from the data characteristic table and the search data table, and issues the search command. It is transferred to the client machine that issued the message.

That is, a search command requested from a plurality of client machines is transmitted to a main server (database server) via a micro server, and a search result is transferred to each client machine via the micro server. . By sharing one microserver by a plurality of client machines, the system adoption cost can be reduced. Each client machine can perform a database search in exactly the same procedure as before. Although high-speed data communication can be performed between a plurality of client devices connected via a LAN, it is effective when the transfer speed decreases when each client device is connected to a database server located at a remote place via a communication line. is there.

In the invention described in claim 8, the micro server generates search command data in which a search command from the client machine is serialized and transfers the search command data to the main server, while the main server transfers the search command data to the main server. The above-described search command data is converted into a search command for performing a search, and a database search is performed.

According to a ninth aspect of the present invention, there is provided a data transfer method in a database in which a plurality of servers storing a database are connected via a communication line and data is transferred between the servers. The server generates an extracted search data table and a data characteristic table describing the characteristics of the search data table and stores them in a memory area. The search data table and the data characteristic table are serialized and combined to transfer data. Is generated and transferred to another server by adding control information according to the characteristics of the transfer data. On the other server, the data characteristic table and the search data table are reproduced from the transfer data and the memory area is reproduced. From the data characteristic table and the search data table. It reads the data in which are configured to perform predetermined processing.

That is, the data transfer method according to the present invention is applied to data transfer between a plurality of database servers. A plurality of database servers are connected via a network such as the Internet, and a database in a distributed processing mode for decentralizing processing by these database servers is constructed. In data transfer between database servers, various processes such as data sharing and data updating are frequently performed in addition to ordinary database search. Therefore, the amount of transfer data also increases.
Therefore, by employing the data transfer processing system according to the present invention, the data transfer efficiency can be greatly increased.

The invention described in claims 10 to 14 of the present application relates to a computer-readable recording medium recording a transfer data processing program that can be installed in a server and a client machine of a conventional database search system. The data transfer method according to the present invention can be easily executed by installing a transfer program in a server and a client machine in a conventional database search system or a microserver as described in claim 7.

The computer readable recording medium includes a recording medium dedicated to a client machine, a recording medium dedicated to a database server, and a recording medium applicable to both a client machine and a database server. It is. Also,
It is also possible to record programs that can be applied to various means and various devices included in the present invention, and select and install them.

The invention described in claim 10 of the present application is applied to a client device connected via a communication line and a server storing a database, and retrieves from the database based on a command from the client device. Computer-readable recording medium recording a program for transferring the data to the client machine,
Search data table generating means for generating a search data table extracted by a search in a memory area; data characteristic table generating means for generating a data property table describing data characteristics of the search data table in a memory area; Transfer data generating means for serializing and linking the items of the table and the data characteristic table to generate transfer data; and control information addition for adding control information corresponding to the transfer data to the head of the transfer data Means, data table reproducing means for reproducing a search data table and a data characteristic table from transfer data and control information transferred to the client machine, and search data reading for reading search data from the reproduced search data table and data characteristic table Means for transferring data processing including Characterized that you have recorded ram.

The invention described in claim 11 of the present application is characterized in that a transfer data processing program including data transfer means for outputting the transfer data and control information to a communication line and transferring the control data to a client machine is recorded. Is what you do. This corresponds to a case where data transfer is performed via a unique communication means that is not provided as a standard in a server or the like.

The invention described in claims 15 to 17 of the present application relates to a data transfer device including a pair of independent microservers for transferring data.

By providing the micro server on each of the client machine and the database server, the data transfer method of the present invention can be carried out without increasing the load on the client machine and the database server. In addition, a plurality of client machines can be connected to one micro server on the client machine side, and a plurality of database servers can be connected to the micro server on the database server side.

The communication line between the micro server, the communication line between the micro server and the database server, and the communication line between the client machine and the client server micro server are not particularly limited. For example, while data transfer between the microservers is performed via a wide area network such as the Internet, data transfer between the client-side microserver and each client device can be performed via a LAN. The effect can be expected even if all the devices are connected via the Internet. For example, there is no problem in data transfer in a domestic network, but the effect can be expected when the bandwidth of a communication line for transferring data to another country is small.

According to a fifteenth aspect of the present invention, an arithmetic unit, a storage device, and a data input / output device capable of inputting / outputting data to / from the database server and the network are provided in the database side micro server. In the storage device, a search command generation program for converting search command data input from the client side microserver into a search command for operating a database, and a search data table obtained by database search are generated in the storage device. A search data table generation program, a data characteristic table generation program for generating a data characteristic table describing data characteristics of the search data table in the storage device, and serializing items of the search data table and the data characteristic table. A transfer data generation program for linking and generating transfer data, a control information addition program for adding control information according to the transfer data, a data exchange program for exchanging data with the database server, And a data transfer receiving program capable of exchanging information with the client side microserver via the network.

On the other hand, the client-side microserver includes an arithmetic unit, a storage device, and an input / output device capable of inputting and outputting data to and from the client machine and the network, similarly to the base server described above. It is composed. In the storage device, a search command data generation program for serializing a search command given from the client machine to generate the search command data, and a transfer data and control information received from the server-side microserver, to perform a search. A data table reproducing program for reproducing the data table and the data characteristic table in the storage device, and a search data reading program for reading search data from the reproduced search data table and data characteristic table are stored.

According to the invention described in claim 16 of the present application, the data compression program and the data compression / decompression processing program including the data decompression program which is compressed by the compression program include the database side micro server and the client side micro server. It is stored on the server.

According to a seventeenth aspect of the present invention, the data compression / decompression processing program includes one or more data compression programs and a compression program selected from the compression programs according to the characteristics of data to be transferred. Data analysis means for determining whether to apply the program or not to apply the compression program.

The type and configuration of the database according to the present invention are not particularly limited, and the present invention can be applied to various databases from which data can be extracted based on a search command of a clean-up machine. In addition, the present invention is not limited by the function of executing the access processing of the database on the server and the language used to perform the processing, and can be applied to a database server employing various functions and languages.

[0048]

DESCRIPTION OF THE PREFERRED EMBODIMENTS In the present embodiment, a data transfer method according to the present invention is incorporated as middleware in a conventional database system. Middleware is generally software for effectively using the functions of basic software or for supporting software development. In the present embodiment, the search processing means of the database itself employs a conventional search processing means based on the SQL language. The database system connects a server storing a database to a plurality of client machines via a digital communication line and the Internet, and employs a data reception / transfer processing means based on the TCP / IP protocol.

FIG. 1 shows the device configuration of the database search system. The database search system 1 according to the present embodiment is configured by connecting a server 3 having a database 2 and a plurality of client machines 4 via a network 5. The Internet is adopted as the network 5, and the connection to the network employs a digital dedicated line 10.

In the present embodiment, a search command from the client machine 4 is transmitted to the server 3 via the digital dedicated line 10 and the Internet 5, and the server 3 performs a database search based on the search command and returns the search result. The data is transferred to the client device 4 via the digital communication line 10 and the Internet 5.

As shown in FIG. 2, the server 3 and the client machine 4 are provided with data processing units 6 and 11, respectively. The server-side data processing unit 6 includes a search processing unit 7 for performing a search based on a search command, and transfers the data extracted by the search processing unit 7 to the client machine 4 via the network 5 and a client machine. A data reception / transfer processing means 8 for receiving a search command or the like transferred from the server, and provided between the search processing means 7 and the data reception / transfer processing means 8 for converting search data or received data into a predetermined format. And a search data processing unit 9 to be transferred to the data reception transfer processing unit 8 or the search processing unit 7.

The search processing means 7 has a function of extracting data satisfying a predetermined condition from the database 2 based on a search command transmitted from a client machine. Based search processing means.

The data reception / transfer processing means 8 converts the search data converted by the search data processing means 9 into T
Based on the CP / IP protocol, the data is transferred to the client machine 4 via the digital line 10 and the Internet 5, and the search command information from the client machine is received and sent to the search data processing means 9 or the search processing means 7. It has a delivery function.

On the other hand, the data processing unit 11 on the client machine side transmits the search command data input from the input device 13 to the data reception and transfer processing unit 12 having the same function as the data reception and transfer processing unit 8 on the server side. Search data processing means for processing and delivering the data to the data reception / transfer processing means 12, generating output data based on a search command from the search data received by the data reception / transfer means 12, and outputting the output data to an output device 14 such as a display. 15 is provided.

FIG. 3 shows the configuration of the search data processing means 9 on the server side. The server-side search data processing means 9
It comprises a plurality of data processing means that can be classified into a data transfer side and a data reception side. The data transfer side includes a search data table generation unit 16, a data characteristic table generation unit 17, a transfer data generation unit 18, a transfer data analysis unit 19, a control information addition unit 20, and a data compression unit 21. On the data receiving side, search command reproducing means 22,
It includes a data decompressing unit 23, a data table reproducing unit 24, and a search data reading unit 25.

FIG. 4 shows the structure of the search data processing means on the client machine side. The client machine-side data processing means 15 is also composed of data processing means that can be classified into a data transfer side and a data reception side, similarly to the server side. On the data transfer side, search command data generating means 26,
Data compression means 27, search data table generation means 2
8, a data characteristic table generating means 29, a transfer data generating means 30, a transfer data analyzing means 31, and a control information adding means 32 are included. The data receiving side includes a data table reproducing unit 33, a data decompressing unit 34, and a search data reading unit 35.

In the present embodiment, the configuration is such that updated data can be transferred from the client machine 4 to the server 3 in order to update the database. Among the processing means on the client machine side, the search data table creating means 28, the data characteristic table creating means 29, the transfer data creating means 30, the transfer data analyzing means 31, and the control information adding means 32 are transmitted from the client machine 4 to the server 3. Used to transfer data to

On the other hand, as shown in FIG. 3, a server is provided with a data table reproducing means 24 and a retrieval data reading means 25 in order to receive and process data transferred from the client machine. .

Each unit in the retrieval data processing units 9 and 15 will be described in order according to a data transfer procedure. Fifth
FIG. 6 and FIG. 6 show the transfer procedure of the retrieved data. In these figures, the search process (S10
The procedure after 1) is shown. The search process S101 is performed in a process similar to the conventional process.

The result searched by the search processing means 7 is passed to the search data processing means 9, and a data characteristic table is generated by the data characteristic table generating means 17 and stored in the memory area (S102). The search data table is generated by the table generation means 16 and stored in the memory area (S10).
3). There is no problem if the generation of the data characteristic table and the generation of the search data are performed simultaneously or sequentially.

FIGS. 7 and 8 show examples of the data characteristic table and the retrieval data table. The data characteristic table 36 includes items in which the data characteristics of each item of the search data table 37 are described. In the example shown in FIG. 7, each item is composed of a character string that makes it possible to understand the meaning of the data contents and characteristics so that the contents can be easily understood. However, actually, the data amount is reduced by using a code or the like. be able to. For example, notnull is set to 0
And the data characteristic table 36 by replacing null with 1
Can be configured.

Next, the transfer data generating means 18
The respective items of the data characteristic table 36 and the search data table 37 are serialized and connected to generate transfer data (S104). FIG. 9 shows a case where the transfer data 38 is generated from each of the data tables shown in FIGS. 7 and 8. As shown in this figure, one text data string is configured by linking the items of each row of the data characteristic table 36 and the retrieval data table 37 in a line.
In FIG. 9, four lines of data are used to represent the data on paper, but in the server, the data is continuous in a line. Further, the data of the embodiment includes text data of alphabets, kanji, and numbers, but the language constituting the text data is not limited, and other types of text data may be included. Good.

The characteristics of the transfer data 38 are analyzed by the transfer data analysis means 19, and the necessity of compression, the amount of data, the amount of decompression when compressed, and the like are determined, and control information 39 is obtained (S105). .

Thereafter, when it is determined that compression is necessary, the data compression means 21 compresses the transfer data 38 to reduce the data amount (S
107). Then, as shown in FIG. 10, the control information 39 is added to the head of the compressed transfer data 40 by the control information adding means 20 (S108). In the present embodiment, the control information includes a data amount 41, a compression method 4
2. A data amount 43 after decompression and a return value 44 indicating a case where the search is not successful are added.

The data to which the control information 39 has been added is delivered to the data reception / transfer means 8 (S109), and the TCP /
According to the procedure of the IP protocol, the text data string is transferred to the client machine 4 as one text data string (S11).
0). Since the transfer data 9 is composed of one character string, it can be transferred to the client device 4 in one transfer procedure. For this reason, the transfer time can be significantly reduced.

FIG. 6 shows a procedure for processing received data on the client side. The data transferred from the server 3 is received by the data reception / transfer processing means 12 of the client machine 4 (S201). The control information of the received data is read to determine the presence or absence of a compression operation (S202). If the data is compressed, the data decompression means 34 reproduces the columnar data 38 shown in FIG. 9 (S203). .

Next, the data table reproducing means 33 separates and generates the data characteristic table 36 and the retrieval data table 37 shown in FIG. 7 and FIG. It is stored (S204). As a result, the same data as the search result in the server is formed in the client machine.

Then, using the search data reading means 35, the data characteristic table 36 in the client machine 4 is read.
Then, it becomes possible to output desired data from the search data table 37 to an output device such as a display or a printer (S205).

In the present embodiment, a search command transferred from the client machine is also transferred to the server 3 as serialized search data. Therefore, the fourth
As shown in the figure, a search command data generation unit 26 and a data compression unit 27 are provided on the client machine side, and a search command command or the like is transferred to the server 3 as compressed serialized data to perform a search. ing. On the other hand, the search data processing means 9 on the server side is provided with a data decompression means 23 for decompressing the compressed search command data and a search command reproducing means 22 for reproducing the search command from the serialized data string. . The search command reproduced by the search command reproducing means 22 is transferred to the search processing means 7 to execute a database search.

Further, it is configured so that the data in the database 2 can be updated by transferring the data in the table format from the client machine side. That is, as shown in FIG.
The search data table generating means 2 is the same as the server side.
8, a data characteristic table generating means 29, a transfer data generating means 30, a transfer data analyzing means 31, and a control information adding means 32, while the data processing means 9 on the server side includes a data table reproducing means 24 and a search data reading means 25. Is included.

With the above configuration, the update data transfer time when updating data in the database from the client machine side can be greatly reduced.

FIG. 11 shows a second embodiment of the present invention. This figure shows a device configuration when a plurality of servers 3a to 3d having databases 2a to 2d are connected via a communication line 10 and the Internet 5 and data is transferred between these servers.

The data processing means of each of the servers 3a to 3d includes the data processing means including the respective means shown in FIGS. 3 and 4 as in the above-described embodiment. It is configured to exchange data with serialized data.

FIGS. 12 and 13 show a third embodiment of the present invention. In this embodiment, microservers 45 and 4 are provided between the database server 3 and the network 5 and between each client machine 4 and the network 5.
6 for transferring data via the microservers 45 and 46.

The microservers 45 and 46 are provided with an arithmetic unit, a storage device, and a data input / output device capable of inputting / outputting data to / from the database server 3 and the network 5 as in a general server. . Also,
As shown in FIG. 13, the microservers 45 and 46 are provided with the search data processing units 9 and 15 and the data reception and transfer units 8 and 12 described in the first embodiment.

The search data processing means 9 and the data reception / transfer processing means 8 process data in the same manner as the procedure shown in FIG. Further, the search data processing means 1
5 and the data reception / transfer processing means 12 processes data in the same manner as the procedure shown in FIG.

In the present embodiment, the data transfer method according to the present invention can be executed without any change in hardware and software in the conventional system. For this reason, the load on the database server 3 and the client machine 4 does not increase. Further, there is no possibility that inconvenience due to insufficient memory of the database server 3 and the client machine 4 will occur.

FIG. 14 shows a fourth embodiment of the present invention. In this embodiment, a micro server 45 is provided between the database server 3 and the network 5, and a plurality of client devices 4 are connected to one micro server 47 via a network 55, and this micro server 47 is connected to the network 5. Connected to The network 5 is a wide area network such as the Internet, and the network 55 is a network in a limited area such as a LAN. The micro server 45 has functions similar to those of FIG. The micro server 47 has the same functions as those of the micro server 46 shown in FIG. 13, and has a function capable of supporting a plurality of client machines.
Data transfer is performed between the microservers 45 and 47 in the same manner as in the above-described embodiment.

In this embodiment, the data transfer method according to the present invention can be applied to a plurality of client machines 4 by employing a pair of microservers 45 and 47. For this reason, adoption costs can be reduced. Also,
There is no need to change the hardware and software of the database server 3 and the client machine 4. In particular, a high effect can be expected when the data transfer speed of the wide area network 5 such as the Internet is low.

As described above, in the data transfer method according to the present invention, after the data obtained by the database search is once stored in the memory area as the data characteristic table and the search data table, the items of these data tables are serially stored. Thus, one columnar transfer data can be generated, and this transfer data can be transferred by one transfer procedure. Therefore, the transfer time can be significantly reduced.

Further, by compressing the columnar data, the data amount of the transfer data itself can be reduced, and the time required for data transfer can be further reduced. As a result, even when a communication line with a narrow bandwidth is used, or when the line is congested, the response time of the database search can be significantly reduced.

Further, the database search can be performed without changing the conventional search method, communication means, and the like.
For this reason, the database search can be performed by exactly the same operation as the conventional database search.

The present invention is not limited to the above embodiment. In the embodiment, the communication means using the TCP / IP protocol is employed as the data reception / transfer processing means 8, but a communication means employing another protocol may be employed.

In the embodiment, the present invention is applied to the search data processing means 9 provided as middleware between the data reception / transfer processing means 8 and the search processing means 7. 8 or a program integrated with the search processing means 7. Further, the present invention can be applied as a comprehensive database search program integrated with the attached search processing means 7 and the data reception / transfer processing means 8 in the database server 3.

In the embodiment, data is transferred via the communication line 10 and the Internet 5 which is a wide area network. However, the present invention is also applied to a database server / client system connected via an in-house LAN or the like. be able to.

In the embodiment, the transfer method according to the present invention is applied to the transfer of the search data table composed of only text data. However, the transfer method is constituted by data items having other forms of data characteristics such as images and sounds. The present invention can also be applied to the search data table transfer processing performed.

Further, in the embodiment, the search command is transferred to the server in the same manner as the transfer of the search data table. However, the search command is transferred to the server in the same transfer method as the conventional database, and the search operation is performed. You can also.

The type and concept of the database are not particularly limited, and include all those having a function of extracting data from the stored area. Further, the present invention is not limited to only extracted data, and can be applied to a case where all data is transferred to another computer or the like.

[Brief description of the drawings]

FIG. 1 is a diagram showing an embodiment of FIG. 1 of the present invention,
FIG. 1 is a diagram illustrating a device configuration of a database search system.

FIG. 2 is a block diagram of a data processing unit provided on the server side and the client machine side in FIG. 1;

FIG. 3 is a block diagram of search data processing means on the server side in FIG. 2;

FIG. 4 is a block diagram of search data processing means on the client device side in FIG. 2;

FIG. 5 is a flowchart illustrating a procedure of data processing on the server side.

FIG. 6 is a flowchart illustrating a procedure of data processing on the client device side.

FIG. 7 is a diagram illustrating an example of a data characteristic table.

FIG. 8 is a diagram illustrating an example of a search data table.

FIG. 9 is a diagram showing a form of transfer data.

FIG. 10 is a diagram illustrating a form of data obtained by adding control information to compressed transfer data.

FIG. 11 is a diagram illustrating a second embodiment of the present invention, and is a diagram illustrating a device configuration when data is transferred between a plurality of servers including a database.

FIG. 12 is a diagram illustrating a device configuration according to a third embodiment of the present invention.

FIG. 13 is a block diagram showing functions of the embodiment shown in FIG.

FIG. 14 is a diagram illustrating a device configuration according to a fourth embodiment of the present invention.

[Explanation of symbols]

 S102 Data table generation step S103 Data table generation step S104 Transfer data generation step S108 Control data addition step S110 Data transfer step S203 Data table reproduction step S204 Data read step

Claims (17)

[Claims] 1. A client machine and a server storing a database are connected via a communication line, and data searched from the database based on a search command from the client machine is transferred from the server to the client machine. A data table generating step of generating, in a memory area provided on the server side, a search data table composed of searched data and a data characteristic table storing characteristics of the searched data. A transfer data generation step of serializing and concatenating each item constituting the data characteristic table and the search data table to form transfer data; and at the beginning of the transfer data, control information according to the characteristics of the transfer data. A control information adding step to be added, and a transfer information generated in the transfer data generating step. A data transfer process for transferring data to the client machine; a data table playback process for playing back a data characteristic table and a search data table from the transferred data in a memory area provided on the client machine side; A data reading step of reading predetermined data from the characteristic table and the search data table. 2. A data compression step of compressing serialized transfer data on the server side and including information on the compression method in the control information, and decompressing received data on the client machine side. 2. The data transfer method according to claim 1, further comprising a data decompression step of performing the transfer data generation. 3. A compression judging step for judging whether or not to compress the transfer data according to the data characteristics of the transfer data, and compressing the transfer data when it is judged in the compression judging step to compress. 3. The data transfer method according to claim 1, further comprising a data compression step of causing the control information to include information on the compression method. 4. The data transfer method according to claim 1, wherein each item of the data table extracted from the database and each item of the data characteristic table are text data. 5. The data transfer method according to claim 1, wherein data items other than text data are included in the items of the search data table extracted from the database. 6. A search command data generating step of serializing a search command in a client machine, a search command data transfer step of transferring the search command data to a server, and operating a database of the search command data in the server. The data transfer method according to any one of claims 1 to 4, further comprising a search command reproducing step of converting the search command into a search command to be performed. 7. A micro server receiving a search command from a plurality of client machines and a main server storing a database are connected via a communication line, and the search command is transferred to the main server via the micro server. A database search method for transferring data searched from the database to the client machine via the microserver, wherein the main server side extracts an extracted search data table and data describing characteristics of the search data table. Generate a characteristic table, store it in the memory area, serialize and combine the items constituting the search data table and data characteristic table to generate transfer data, and add control information according to the characteristics of the transfer data And transfer it to the micro server. In the cross server, the data characteristic table and the search data table reproduced from the transfer data are stored in a memory area, predetermined data is read from the data characteristic table and the search data table, and transferred to the client machine that issued the search command. , Database search method. 8. The micro server generates search command data obtained by serializing a search command from the client machine and transfers the search command data to the main server, while the main server searches the transferred search command data. The database search method according to claim 7, wherein the database search is performed by converting the search command into a search command for performing a search. 9. A data transfer method in a database in which a plurality of servers storing a database are connected via a communication line and data is transferred between the servers, wherein a search data table extracted and A data characteristic table that describes the characteristics of the search data table is generated and stored in a memory area. The search data table and the data characteristic table are serialized and combined to generate transfer data. The control information is added to the control information and transferred to another server, while the other server reproduces the data characteristic table and the search data table from the transfer data and stores them in the memory area. Reads predetermined data from the search data table and performs predetermined processing. Configuration the data transfer method as. 10. The present invention is applied to a client device connected via a communication line and a server storing a database, and transfers data retrieved from the database based on a command from the client device to the client device. A computer-readable recording medium on which a program is recorded, a search data table generating means for generating a search data table extracted by a search in a memory area, and a data characteristic table describing data characteristics of the search data table in a memory. A data characteristic table generating means for generating an area, serialized and linked items of the search data table and the data characteristic table, and a transfer data generating means for generating transfer data; Control information according to the transfer data is added. Control information adding means, data table reproducing means for reproducing a search data table and a data characteristic table from the transfer data and control information transferred to the client machine side, and search data from the reproduced search data table and data characteristic table. A computer-readable recording medium characterized by recording a transfer data processing program including: a retrieval data reading means for reading; 11. The transfer data processing program according to claim 10, wherein a transfer data processing program including data transfer means for outputting the transfer data and control information to a communication line and transferring the transfer data and control information to a client machine is recorded. Computer readable recording medium. 12. A means for compressing serialized transfer data,
12. The computer-readable recording medium according to claim 10, wherein a transfer data processing program including a transfer data decompression means compressed by the compression means is recorded. 13. A data analysis for applying one or more data compression means and applying a compression means selected from the compression means according to the data characteristics of the transfer data, or determining not to apply the compression means. 13. The computer-readable recording medium according to claim 10, wherein a transfer data processing program including the following is recorded. 14. Search command data generating means for serializing a search command transferred from a client machine to generate search command data; search command reproducing means for converting the search command data into a search command for operating a database; 14. The computer-readable recording medium according to claim 10, wherein a transfer data processing program including the following is recorded. 15. A database side micro server connected to a database server storing a database,
A data transfer device comprising a client-side microserver connected to a client machine, and configured to exchange data between the database server and the client machine via a network and these microservers. The database-side microserver includes an arithmetic unit, a storage device, and a data input / output device capable of inputting and outputting data to and from the database server and the network, and a search command input from the client-side microserver. A search command generation program for converting data into a search command for operating a database; a search data table generation program for generating a search data table obtained by database search in the storage device; A data characteristic table generation program for generating a data characteristic table describing characteristics in the storage device; and a transfer data generation program for serializing and connecting items of the search data table and the data characteristic table to generate transfer data And a control information addition program for adding control information according to the transfer data, a data exchange program for exchanging data with the database server, and the client side micro server via the network. While a data transfer receiving program capable of exchanging information is stored, the client-side microserver includes a computing device, a storage device, and an input / output device capable of inputting and outputting data to and from the client machine and the network. With the above Klein Ann A search command data generating program for serializing a search command given from the server to generate the search command data, and a search data table and a data characteristic table from the transfer data and the control information received from the server-side microserver. A data transfer device which stores a data table reproduction program to be reproduced and a search data read program for reading search data from the reproduced search data table and data characteristic table. 16. A data compression / decompression processing program including a data compression program and a data decompression program for data compressed by the compression program are stored in the database-side microserver and the client-side microserver. A data transfer device according to claim 1. 17. The data compression / decompression processing program includes one or more data compression programs and a compression program selected from the compression programs according to characteristics of data to be transferred, or a compression program 17. The data transfer device according to claim 16, further comprising: a data analysis unit that determines not to apply.