JP2023004019A - Data reference system, data reference device, data reference method, and data reference program - Google Patents

Abstract

A system and method for processing multiple requests simultaneously. A data reference system according to an embodiment, comprising a data reference device and a database device, wherein the data reference device, when receiving a first reference request packet, sends a causing the database device to transmit a first reference request based on the first reference request packet, receiving a first reference response that is a result of responding to the first reference request, and When a second reference request packet is received before a response is received, a second reference request is transmitted to the database device based on the second reference request packet, and a result of responding to the second reference request a first communication control unit configured to receive a second reference response from the [Selection diagram] Fig. 1

Description

TECHNICAL FIELD Embodiments of the present invention relate to a data reference system, a data reference device, a data reference method, and a data reference program.

In a client-server system, it is desired to refer to data on a database in a short time. For example, in an ETC system for toll roads, when the central server calculates tolls, it is necessary to refer to the tolls from the database on the central server side within a certain period of time and transmit the toll information to the client tollgate device.

JP 2020-087337 A

If multiple reference requests are sent to the database server, it takes time to reference the data. This is because when many clients request to refer to multiple tables stored in the database server, it is necessary to wait for a response to the first data reference before requesting the next data. In this case, the time required for data reference increases, and requests from a large number of clients cannot be processed. Therefore, there is a demand for a technique that can process requests from a large number of clients.

Also, in a general RDB (Relational Data Base), multiple tables can be linked and referenced, but if the amount of data in the linked tables is large, the linking process will take time, and it will take time to refer to the data. . In addition, a statement called a query to request the database becomes complicated. Therefore, it is also required to be able to refer to data with a simple query.

A data reference system according to an embodiment includes a data reference device and a database device connected to the data reference device, wherein the data reference device receives a first reference request packet, performs a first communication cause a unit to transmit a first reference request to the database device based on the first reference request packet, receive a first reference response as a result of responding to the first reference request, and causes the database device to transmit a second reference request based on the second reference request packet, and responds to the second reference request a first communication control unit configured to receive a second reference response as a result of the processing, wherein the database device includes a first table and a second table corresponding to the first reference request and the second reference response, respectively; a request processing unit that refers to a table and outputs the first reference response and the second reference response; and a second communication unit that transmits the first reference response and the second reference response to the data. and a second communication control unit that causes the reference device to transmit.

FIG. 1 is a diagram showing an example of a schematic configuration of a data reference system according to an embodiment. FIG. 2 is a block diagram showing a configuration example of the database device according to the embodiment. FIG. 3 is a block diagram showing a configuration example of the data reference device according to the embodiment. FIG. 4 is a block diagram illustrating a configuration example of a client device according to the embodiment; FIG. 5 is a sequence diagram showing an example of a processing procedure of the data reference system shown in FIG. 1; FIG. 6 is a diagram showing an example of outputting an output value Z from an input value X via an intermediate value Y. FIG. FIG. 7 is a diagram showing an example of outputting an output value Z from an input value X via an intermediate value Y in a toll road toll collection system. FIG. 8 is a diagram showing an example of a table in which card IDs and entrance IDs are paired. FIG. 9 is a diagram showing an example of a table in which an entrance ID-exit ID and a toll are combined. FIG. 10 shows in more detail steps ST110A to ST117 in the sequence diagram shown in FIG. FIG. 11 is a diagram illustrating an example of a schematic configuration of a data reference system according to the embodiment; FIG. 12 is a block diagram showing an example of the hardware configuration of the roadside device. FIG. 13 is a diagram showing an example of the configuration of a roadside packet. FIG. 14 is a diagram showing an example of the configuration of a roadside response packet. 15 is a sequence diagram showing an example of a processing procedure of the data reference system shown in FIG. 1; FIG. FIG. 16 is a diagram showing an example of the data structure of each packet. FIG. 17 is a diagram showing an example of the table stored in the data storage section 13 by the process of step ST301. FIG. 18 is a diagram showing an example of the basic charge table referred to in step ST315B. FIG. 19 is a diagram showing an example of the adjustment fee table referred to in step ST315C.

A data reference system, a data reference device, a data reference method, and a data reference program will be described in detail below with reference to the drawings. It should be noted that, in the following embodiments, the same numbered parts are assumed to perform the same operation, and redundant description will be omitted.

[First Embodiment]
(Constitution)
FIG. 1 is a diagram showing an example of a schematic configuration of a data reference system according to an embodiment.
The data reference system includes a database device 10, a data reference device 20, a client device 40A, a client device 40B, . Here, M is any integer greater than or equal to 1. The data reference system is a client-server type ETC system, a station ticket gate system, a factory control and monitoring system, or the like. Further, in the following description, the client device 40A, the client device 40B, .

The data reference device 20 is connected to the client device 40 via the network 31 . Also, the data reference device 20 is connected to the database device 10 . Here, the database device 10 may be directly connected by wire or wirelessly, or may be connected via the network 31 . Also, the data reference device 20 and the database device 10 may be arranged in the same device. By placing the data reference device 20 and the client device 40 physically close to each other and transmitting and receiving data in this manner, it is possible to directly access the database device 10 multiple times from the client devices 40 located in a wide area. Data can be sent and received at high speed.

Here, the network 31 is typically a communication network including the Internet. The network 31 is typically a communication network including a WAN (wide area network). Network 31 may be a communication network including a private network such as an intranet. The network 31 may be a communication network including a LAN (local area network). The network 31 may be a wireless line, a wired line, or a mixture of wireless and wired lines. Also, the network 31 may be a communication network including a dedicated line or a public mobile telephone network.

The database device 10 is a device such as a server that stores a database. Alternatively, the database device 10 may be a virtual server. For example, the database device 10 may be a relational database management system such as PostgreSQL or MySQL, or a NoSQL database system such as Redis (Remote Dictionary Sever) or Mongodb. Also, the database device 10 and the data reference device 20 cooperate to function as a server in a client-server model.

The database device 10 includes a connection reception unit 11 , a request processing unit 12 and a data storage unit 13 .

The connection reception unit 11 receives connection of the data reference device 20 . The request processing unit 12 processes requests sent from the data reference device 20 . Further, the data storage unit 13 stores data referred to when the request processing unit 12 performs various processes.

The data reference device 20 includes a first connection unit 21A, a second connection unit 21B, . , Nth request transmission unit 22N, first response reception unit 23A, second response reception unit 23B, . . . , Nth response reception unit 23N, request reception unit 24, and response transmission unit 25 , and a connection reception unit 26 . Here, N is any integer equal to or greater than 2.

The first connection portion 21A, the second connection portion 21B, . Similarly, when there is no need to distinguish between the first request transmission unit 22A, the second request transmission unit 22B, . , the second response receiver 23B, .

The connection unit 21 is used when connecting to the database device 10 . The request transmission unit 22 is used when transmitting a reference request or the like to the database device 10 . The response receiving unit 23 is used when receiving a reference response including information on the processing result requested from the database device 10 . The request reception unit 24 is used when receiving a request from the client device 40 and transmitting the request to the first request transmission unit 22A or the like. The response transmission unit 25 is used when receiving a reference response from the response reception unit 23 and transmitting the reference response to the client device 40 . The connection accepting unit 26 is used when accepting a connection with the client device 40 .

The client device 40 includes a connection section 41 , a data reference request section 42 and a data response reception section 43 .

The connection unit 41 connects to the data reference device 20 via the network 31 . The data reference request unit 42 transmits to the data reference device 20 a processing request to be transmitted to the database device 10 . The data response receiving section 43 receives the processing response transmitted from the data reference device 20 .

In the following description, a processing request transmitted from the client device 40 to the data reference device 20 is referred to as a reference request packet, and a processing response including the result of processing the request packet transmitted from the data reference device 20 to the client device 40 is referred to as a reference request packet. is called a response packet.

FIG. 2 is a block diagram showing a configuration example of the database device 10 according to the embodiment.
The database device 10 has a processor 101 such as a CPU (Central Processing Unit) or an MPU (Micro Processing Unit). A storage unit 102 , a communication unit 103 and an input/output IF 104 are connected to the processor 101 via a bus 105 .

The storage unit 102 includes storage media such as EPROM (Erasable Programmable Read Only Memory), HDD (Hard Disk Drive), SSD (Solid Sate Drive), and other non-volatile memories that can be written and read at any time, and ROM (Read Only Memory) or other non-volatile memory can be used in combination. The storage unit 102 stores programs necessary for the processor 101 to execute various processes.

Further, the storage unit 102 uses, as a storage medium, a combination of a non-volatile memory such as an HDD and a memory card that can be written and read at any time, and a volatile memory such as a random access memory (RAM). include. For example, the data storage unit 13 is part of the storage unit 102 . Therefore, the storage unit 102 stores data and the like that the processor 101 refers to.

The communication unit 103 is a communication interface including one or more wired or wireless communication modules. For example, the communication unit 103 includes a communication module for wired or wireless connection with the management server 30 . The communication unit 103 may be a general communication interface as long as it can communicate with the data reference device 20 or the like under the control of the communication control unit 1011 of the processor 101 and transmit and receive various information.

An input unit and a display unit are connected to the input/output interface 104 (indicated as an input/output IF in FIG. 2).

The input unit is, for example, a device that receives voice data such as a microphone, or a device that recognizes character data input by an administrator who manages the database device 10 using an input detection sheet that employs an electrostatic method or a pressure method. be.

The display unit is, for example, a display device using liquid crystal, organic EL (Electro Luminescence), etc., and displays voice, characters, images, etc. according to the signal output from the processor 101 .

The processor 101 also includes a request processing unit 12 and a communication control unit 1011 .
The communication control unit 1011 transmits and receives various information to and from the data reference device 20 through the communication unit 103 .

FIG. 3 is a block diagram showing a configuration example of the data reference device 20 according to the embodiment.
As shown in FIG. 3, the data reference device 20 has a processor 201 such as a CPU or MPU. A storage unit 202 , a communication unit 203 and an input/output interface 204 are connected to the processor 201 via a bus 205 .

The storage unit 202 can use, as a storage medium, a combination of a non-volatile memory such as an EPROM, HDD, SSD, etc., which can be written and read at any time, and a non-volatile memory such as a ROM. The storage unit 202 stores programs necessary for the processor 201 to execute various processes.

Further, the storage unit 202 includes, as a storage medium, a storage that uses a combination of a non-volatile memory such as an HDD and a memory card that can be written and read at any time, and a volatile memory such as a RAM. The storage unit 202 stores a face database, fare information, various information read from the medium, information on the installed station, and the like.

The communication unit 203 is a communication interface including one or more wired or wireless communication modules. For example, the communication unit 203 includes a communication module for wired or wireless connection with the database device 10 and the client device 40 . Under the control of the communication control unit 2011, the communication unit 203 may be a general communication interface as long as it can communicate with the database device 10, the client device 40, and the like, and transmit and receive various types of information.

Also, the connection unit 21 , the request transmission unit 22 , the response reception unit 23 , the request reception unit 24 , the response transmission unit 25 , and the connection reception unit 26 may be included in the communication unit 203 .

An input unit and a display unit are connected to the input/output interface 204 (indicated as an input/output IF in FIG. 3).

The input unit is, for example, a device that receives voice data such as a microphone, or a device that recognizes character data input by an administrator who manages the data reference device 20 by an input detection sheet that employs an electrostatic method or a pressure method. is.

The display unit is a display device using liquid crystal, organic EL, or the like, for example, and displays voice, characters, images, and the like according to the signal output from the processor 201 .

The processor 201 has a communication control section 2011 .
The communication control unit 2011 transmits and receives various information to and from the database device 10 and the client device 40 through the communication unit 203 .

FIG. 4 is a block diagram showing a configuration example of the client device 40 according to the embodiment.
As shown in FIG. 4, the client device 40 has a processor 401 such as a CPU or MPU. A storage unit 402 , a communication unit 403 and an input/output interface 404 are connected to the processor 401 via a bus 405 .

The storage unit 402 can use, as a storage medium, a combination of a non-volatile memory such as an EPROM, HDD, SSD, etc., which can be written and read at any time, and a non-volatile memory such as a ROM. The storage unit 402 stores programs necessary for the processor 401 to execute various processes.

Further, the storage unit 402 includes, as a storage medium, a storage that uses a combination of a non-volatile memory such as an HDD and a memory card that can be written and read at any time, and a volatile memory such as a RAM. The storage unit 402 stores a face database, fare information, various information read from the medium, information on the installed station, and the like.

The communication unit 403 is a communication interface including one or more wired or wireless communication modules. For example, the communication unit 403 includes a communication module that connects with the data reference device 20 by wire or wirelessly. The communication unit 403 may be a general communication interface as long as it can communicate with the data reference device 20 or the like under the control of the communication control unit 4011 and transmit and receive various information.

Also, the connection unit 41 , the data reference request unit 42 , and the data response reception unit 43 may be included in the communication unit 403 .

An input unit and a display unit are connected to the input/output interface 404 (indicated as an input/output IF in FIG. 4).

The input unit is, for example, a device that receives voice data such as a microphone, or a device that recognizes character data input by an administrator who manages the client device 40 using an input detection sheet that employs an electrostatic method or a pressure method. be.

The display unit is a display device using liquid crystal, organic EL, or the like, for example, and displays sounds, characters, images, and the like according to signals output from the processor 401 .

The processor 401 has a communication control section 4011 .
The communication control unit 4011 transmits and receives various information to and from the data reference device 20 through the communication unit 403 .

(motion)
FIG. 5 is a sequence diagram showing an example of a processing procedure of the data reference system shown in FIG. 1; By the processors 101, 201, and 401 of the database device 10, the data reference device 20, and the client device 40 reading and executing the programs stored in the storage units 102, 202, and 402, respectively, This sequence of operations is implemented.

The communication control unit 2011 of the data reference device 20 transmits a connection request packet to the database device 10 using the connection unit 21 (step ST101). The communication control unit 2011 uses the connection unit 21 to transmit a packet including a connection request to the database device 10 in order to establish connection with the database device 10 . Here, when there are a plurality of connection units 21, for example, N as shown in FIG. A connection request packet is transmitted from each of the units 21N.

The communication control unit 1011 of the database device 10 accepts connection (step ST102). Communication control unit 1011 receives a connection request through connection reception unit 11 . Then, in response to the request, reception for connection with each connection unit 21 is performed. The reception of connection may be, for example, connection reception by TCP/IP, or connection reception independently implemented by UDP/IP or the like.

Communication control section 1011 transmits a connection response to data reference device 20 (step ST103). The communication control unit 1011 determines to establish a connection with the data reference device 20 based on the connection acceptance. Then, the communication control unit 1011 transmits a connection response indicating establishment of connection to the data reference device 20 through the connection reception unit 11 . Here, when receiving connection requests from a plurality of connection units 21 , a connection response is transmitted to each connection unit 21 .

Communication control section 2011 establishes a connection with database device 10 (step ST104). The communication control section 2011 receives the connection response through each connection section 21 . Then, the communication control unit 2011 establishes a connection with the database device 10 for each connection unit 21 based on each connection response.

Next, the communication control unit 4011 of the client device 40A transmits a connection request packet to the data reference device 20 (step ST105A). The communication control unit 4011 uses the connection unit 41 to transmit a packet including a connection request to the data reference device 20 in order to establish connection with the data reference device 20 .

Communication control section 2011 of data reference device 20 accepts connection (step ST106A). Communication control unit 2011 receives a connection request through connection reception unit 26 . Then, in response to the request, reception for connection with the connection unit 41 is performed. The reception of connection may be, for example, connection reception by TCP/IP, or connection reception independently implemented by UDP/IP or the like.

Communication control section 2011 transmits a connection response to client device 40A (step ST107A). The communication control unit 2011 determines to establish a connection with the client device 40A based on the connection acceptance. Then, the communication control unit 2011 transmits a connection response indicating establishment of connection to the client device 40A through the connection reception unit 26. FIG.

Communication control section 4011 establishes a connection with data reference device 20 (step ST108A). Communication control unit 4011 receives the connection response through connection unit 41 . Then, the communication control unit 4011 establishes a connection with the data reference device 20 to the connection unit 41 based on the connection response.

After the connection is established, the communication control section 2011 transmits connection information to the request receiving section 24 and the response transmitting section 25 . The connection information may be, for example, a socket descriptor managed by the operating system of the data reference device 20, a set of the IP address and port number of the client device 40A, or the like.

Steps ST105B to ST108B for establishing a connection between the client device 40B and the data reference device 20 are the same as steps ST105A to ST108 for establishing a connection between the client device 40A and the data reference device 20. omitted. Also, although FIG. 5 shows only the connections between the client device 40A and the client device 40B, the number of client devices 40 connected to the data reference device 20 may be arbitrary. That is, only the client device 40A may establish connection with the data reference device 20, or M client devices 40 may establish connection.

Further, the establishment of the connection between the data reference device 20 and the database device 10 (steps ST101 to ST104) and the establishment of the connection between the client device 40 and the data reference device 20 (steps ST105 to ST108) may be reversed. good. That is, the order of establishing these two connections does not matter.

Next, communication control section 4011 of client device 40A outputs a first reference request packet (step ST109A). Here, the first reference request packet is information to be processed by the data reference device 20 and the database device 10 . For example, the database device 10 refers to the table stored in the data storage unit 13 based on the information included in the first reference request packet.

Communication control section 4011 transmits the output first reference request packet to data reference device 20 (step ST110A). The communication control unit 4011 transmits the output first reference request packet to the data reference device 20 through the communication unit 403 . The first reference request packet may contain only the information to be referred to first, the information to be referred to first, the information to be referred to second, etc., which should be referred to by an arbitrary number of database devices 10. May contain information. In the example of FIG. 5, only information to be referred to first, or information to be referred to first and information to be referred second are included.

Communication control section 2011 of data reference device 20 transmits a first reference request to database device 10 (step ST111A). The communication controller 2011 receives the first reference request packet through the request receiver 24 . Then, the communication control unit 2011 transmits the first reference request including the information necessary for the first reference in the database device 10 out of the first reference request packet through the first request transmission unit 22A.

The request processing unit 12 of the database device 10 performs reference processing (step ST112A). The communication control unit 1011 receives the first reference request through the communication unit 103 and outputs the received first reference request to the request processing unit 12 . The request processing unit 12 refers to the data stored in the data storage unit 13 according to the first reference request and outputs a first reference response. For example, the request processing unit 12 acquires from the data storage unit 13 the table corresponding to the information included in the first reference request. The acquired table is a table from which one reference response can be acquired from the information. That is, the request processing unit 12 outputs the first reference response to the communication control unit 1011 based on the first reference request.

Communication control section 1011 transmits the first reference response to data reference device 20 (step ST113A). The communication control unit 1011 transmits the output first reference response to the data reference device 20 through the communication unit 103 .

Communication control section 2011 transmits a third reference request to database device 10 (step ST114A). Communication control section 2011 receives the third reference response through response receiving section 23 . Then, the communication control unit 2011 transmits a third reference request including the second reference information and the first reference response in the reference request packet to the database device 10 through the request transmission unit 22 .

The request processing unit 12 of the database device 10 performs reference processing (step ST115A). The communication control unit 1011 receives the third reference request through the communication unit 103 and outputs the received third reference request to the request processing unit 12 . The request processing unit 12 refers to the data stored in the data storage unit 13 according to the third reference request and outputs a third reference response. For example, the request processing unit 12 acquires from the data storage unit 13 the table corresponding to the information included in the third reference request. The acquired table is a table from which one reference response can be acquired from the information. That is, the request processing unit 12 outputs the third reference response to the communication control unit 1011 based on the third reference request.

Communication control section 1011 transmits the third reference response to data reference device 20 (step ST116A). The communication control unit 1011 transmits the output third reference response to the data reference device 20 through the communication unit 103 .

Communication control section 2011 transmits the third reference response as a response packet to client device 40A (step ST117A). Communication control section 2011 receives the third reference response through response receiving section 23 . Then, the communication control unit 2011 transmits the third reference response as a response packet to the client device 40 through the response transmission unit 25 .

Further, steps ST105B to ST117B are the same as steps ST105A to ST117A, respectively, so description thereof will be omitted.

Here, as shown in FIG. 5, when the second reference request packet is received after the first reference request is transmitted to the database device 10 and before the first reference response is received, the communication control unit 2011 uses the request transmitting unit 22 to transmit the second reference request to the database based on the second reference request packet. That is, the second reference request can be sent to the database device 10 without waiting for the reception of the first reference response. As a result, it becomes possible to process a plurality of requests simultaneously, so that the throughput, which is the number of requests processed per arbitrary unit time, can be increased.

FIG. 6 is a diagram showing an example of outputting an output value Z from an input value X via an intermediate value Y. FIG. FIG. 6 is a diagram generally showing the processing from step ST111A to step ST116A.

As shown in FIG. 6 , the communication control unit 4011 of the client device 40 transmits an input X, which is a request packet, to the data reference device 20 . Then, the communication control unit 2011 of the data reference device 20 transmits to the database device 10 a first reference request including information (input value X in the example of FIG. 6) necessary for the first reference process in the request packet. do. The request processing unit 12 refers to a table in which the input value X and the intermediate value Y1 are combined, and outputs the intermediate value Y1. Then, the communication control unit 1011 transmits the first reference response including the intermediate value Y1 to the data reference device 20. FIG. The communication control unit 2011 transmits to the database device 10 a third reference request including the intermediate value Y1. The request processing unit 12 refers to a table in which the intermediate value Y1 and the intermediate value Y2 are paired and outputs the intermediate value Y2. Then, the communication control unit 1011 transmits a third reference response including the intermediate value Y2 to the data reference device 20. FIG. In this way, reference request, reference processing, and reference response are repeated multiple times, for example, N times. Here, N is any integer value of 2 or more. Then, the communication control unit 1011 transmits the intermediate value YN repeated N times, that is, the Nth reference response including the output value Z to the data reference device 20 . The communication control unit 2011 then transmits a response packet including the output value Z to the client device 40 .

FIG. 7 is a diagram showing an example of outputting an output value Z from an input value X via an intermediate value Y in a toll road toll collection system.
As shown in FIG. 7A, the reference request packet includes a card ID and an exit ID, which is an identifier of the roadside device installed at the exit toll gate. The card ID is, for example, the card ID of the ETC card inserted into the onboard equipment of the vehicle. For example, the information can be acquired by a roadside device (client device 40) placed at an entrance tollgate or the like, communicating with the vehicle-mounted device. The communication control unit 4011, as shown in FIG. 7B, transmits to the database device 10 a first reference request including the card ID required for the first reference process in the reference request packet received from the client device 40. do. The request processing unit 12 outputs a first reference response including the entrance ID by referring to a table in which card IDs and entrance IDs are paired, as shown in FIG. 7(c). Here, the entrance ID is obtained from the roadside device (client device 40) installed at the toll booth where the vehicle enters the toll road, and is stored in the storage unit 102 of the database device 10 in advance. do.

FIG. 8 is a diagram showing an example of a table in which card IDs and entrance IDs are paired.
As shown in FIG. 8, for example, when the card ID is 000001, the vehicle with the card ID 000001 inserted into the on-vehicle device enters the toll road through the toll gate with the entrance ID 1001. FIG.

As shown in FIG. 7(d), the communication control unit 2011 generates a third reference request (entrance ID−exit ID) by combining the entrance ID included in the first reference response and the exit ID included in the request packet. Send to the database device 10 . As shown in FIG. 7(e), the request processing unit 12 refers to the table in which the entrance ID-exit ID and the toll are combined, and outputs the third reference response.

FIG. 9 is a diagram showing an example of a table in which an entrance ID-exit ID and a toll are combined.

As shown in FIG. 9, for example, when the entrance ID-exit ID indicating the route is 1001-1002, the toll is 500 yen.

Then, the communication control unit 2011 transmits a response packet including the toll to the client device 40, as shown in FIG. 7(f).

FIG. 10 shows in more detail steps ST110A to ST117 in the sequence diagram shown in FIG.

Communication control section 2011 receives the first reference request packet (step ST201A). The communication control unit 2011 receives request packets through the request reception unit 24 of the data reference device 20 . Here, for example, the first reference request packet includes card ID and exit ID as shown in FIG.

Communication control section 2011 transfers the first reference request packet to first request transmission section 22A (step ST202A).

Communication control section 2011 transmits the first reference request to database device 10 (step ST203A). The communication control unit 2011 transmits the first reference request including the card ID included in the first reference request packet to the database device 10 through the first request transmission unit 22A.

Communication control section 2011 transfers the next request data from first request transmission section 22A to second request transmission section 22B (step ST204A). The communication control unit 2011 transfers the next request data including the exit ID included in the request packet to the second request transmission unit 22B as data used by the second request transmission unit 22B.

The request processing unit 12 performs reference processing (step ST205A). Communication control section 1011 receives the first reference request through communication section 103 . The communication control unit 1011 then outputs the received first reference request to the request processing unit 12 . The request processing unit 12 performs reference processing using the first reference request and the table stored in the data storage unit 13 . For example, the request processing unit 12 acquires an exit ID corresponding to the card ID by referring to a table in which card IDs and exit IDs are paired. The request processing unit 12 then outputs a first reference response including the entrance ID.

Communication control section 1011 transmits the first reference response to first response receiving section 23A through communication section 103 (step ST206).

Communication control section 2011 transfers next request data using first response receiving section 23A (step ST207A). The communication control unit 2011 transfers next request data including the first reference response (entrance ID) to the second request transmission unit 22B as data used by the second request transmission unit 22B.

Communication control section 2011 transmits a third reference request to database device 10 (step ST208A). The communication control unit 2011 transmits a third reference request including the exit ID received from the first request transmission unit 22A and the entrance ID received from the first response reception unit 23A to the database device through the second request transmission unit 22B. Send to 10.

The request processing unit 12 performs reference processing (step ST209A). Communication control section 1011 receives the third reference request through communication section 103 . The communication control unit 1011 then outputs the received third reference request to the request processing unit 12 . The request processing unit 12 performs reference processing using the third reference request and the table stored in the data storage unit 13 . For example, the request processing unit 12 acquires the toll from the entrance toll gate corresponding to the entrance ID to the exit toll gate corresponding to the exit ID by referring to a table in which the entrance ID, the exit ID, and the toll are combined. do. The request processing unit 12 then outputs a second reference response including the toll.

Communication control section 1011 transmits the third reference response to second response receiving section 23B through communication section 103 (step ST210A).

Communication control section 2011 transfers the response data to response transmission section 25 (step ST211A). The communication control unit 2011 receives the third reference response through the second response reception unit 23B. Then, the communication control unit 2011 transmits response data including the reference response (toll) to the response transmission unit 25 through the second response reception unit 23B.

Communication control section 2011 transmits the response packet to client device 40 through response transmission section 25 (step ST2012A). The communication control unit 2011 receives response data through the response transmission unit 25 . The communication control unit 2011 then transmits a response packet including response data to the client device 40 through the response transmission unit 25 .

Since steps ST201B to ST212B are the same operations as steps ST201A to ST212A, description thereof will be omitted.

Here, upon receiving the reference request, the database device 10 starts reference processing and transmits a response packet to the data reference device 20 . The processing is a method of processing in order of received data like FIFO (First-In First-Out) or queue.

Also, as shown in FIG. 10, when the second reference request packet is received after the first reference request is transmitted to the database device 10 and before the first reference response is received, the communication control unit 2011 , the request transmitting unit 22 is used to transmit the second reference request to the database based on the second reference request packet. That is, the second reference request can be sent to the database device 10 without waiting for the reception of the first reference response. As a result, it becomes possible to process a plurality of requests simultaneously, so that the throughput, which is the number of requests processed per arbitrary unit time, can be increased.

Further, the communication control unit 2011 includes a plurality of CPUs, transmits the first reference request to the database device 10 using a first CPU among the plurality of CPUs through the communication unit 203, and It is also possible to send the second reference request to the database device 10 using a second CPU among the CPUs. In other words, sending reference requests and receiving reference responses can be performed in parallel by causing each process to be performed by one of the plurality of CPUs.

(Action and effect of the first embodiment)
According to the embodiments described above, the data reference device 20 is arranged between the client device 40 and the database device 10 in the data reference system. After transmitting the first reference request to the database device 10, if the second reference request packet is received before receiving the first reference response, the communication control unit 2011 uses the request transmission unit 22 to and transmits a second reference request to the database based on the second reference request packet. As a result, it becomes possible to process a plurality of requests simultaneously, so that the throughput, which is the number of requests processed per arbitrary unit time, can be increased.

[Second embodiment]
(Constitution)
FIG. 11 is a diagram illustrating an example of a schematic configuration of a data reference system according to the embodiment;
The difference from the first embodiment is that the data reference device 20 includes a registration connection unit 27 and a registration transmission unit 28, and the client device 40 includes an entrance toll gate device 81, a route device 82, and an exit toll gate device. The point is that it is 83. In the following description, the entrance tollgate device 81, the route device 82, and the exit tollgate device 83 are collectively referred to as the roadside device 80. FIG.

The registration connection unit 27 and the registration transmission unit 28 are included in the communication unit 203 . The registration connection unit 27 makes a connection for registering data in the database device 10 . The registration transmission unit 28 also transmits a packet for registering data in the database device 10 .

The entrance toll gate device 81 includes a host communication section 84 , a control section 85 and a vehicle communication section 86 . The route device 82 and the exit toll gate device 83 are also equipped with a host communication unit 84 and the like like the entrance toll gate device 81, but they are omitted in FIG.

FIG. 12 is a block diagram showing an example of the hardware configuration of the roadside device 80. As shown in FIG.
The roadside device 80 has a processor 801 such as a CPU or MPU. A storage unit 802 , a communication unit 803 , an input/output IF 804 , a vehicle detection unit 805 , a camera 806 and a gate 807 are connected to the processor 801 via a bus 808 . The processor 801 also includes a control section 85 and a communication control section 8011 .

The storage unit 802 can use, as a storage medium, a combination of a non-volatile memory such as an EPROM, HDD, SSD, etc., which can be written and read at any time, and a non-volatile memory such as a ROM. The storage unit 802 stores programs necessary for the processor 801 to execute various processes.

Further, the storage unit 802 includes, as a storage medium, for example, a storage that uses a combination of a non-volatile memory that can be written and read at any time, such as an HDD and a memory card, and a volatile memory such as a RAM (Random Access Memory). . The storage unit 802 can store data acquired and generated while the processor 801 executes the program and performs various processes.

The communication unit 803 includes an upper communication unit 84 and a vehicle communication unit 86 . Under the control of the communication control unit 8011, the communication unit 803 connects with each device and transmits and receives various information.

The host communication unit 84 is a communication interface for communicating with the data reference device 20 as a host device. For example, the upper communication unit 84 includes a communication module that wirelessly connects with the data reference device 20 through the network 31 . That is, the upper communication unit 84 may be a general communication unit as long as it can communicate with the data reference device 20 under the control of the communication control unit 8011 and transmit and receive various information.

The vehicle communication unit 86 is a communication interface that wirelessly communicates with a vehicle-mounted device. The vehicle communication unit 86 wirelessly communicates with a vehicle-mounted device mounted on a vehicle approaching the roadside device 80 (that is, a vehicle about to enter or exit a toll road). The vehicle communication unit 86 may acquire the contract information including the card ID, which is the card number of the ETC card inserted in the vehicle-mounted device, and the expiration date, by wirelessly communicating with the vehicle-mounted device. The vehicle communication unit 86 may, of course, acquire various types of information including an on-board device ID, vehicle type information indicating the type of vehicle, information on a license plate, and the like, through communication with the on-board device. That is, the vehicle communication unit 86 may be a general communication unit as long as it can communicate with the vehicle-mounted device under the control of the communication control unit 8011 and transmit and receive various information.

The input/output interface 804 includes a display unit, a speaker, and the like. Under the control of the control unit 85, the display unit can display the toll to the user driving the vehicle. Further, the speaker can guide the vehicle to a predetermined lane by voice under the control of the control unit 85, for example.

The vehicle detection unit 805 detects that a vehicle has approached the roadside device 80 . For example, the vehicle detection unit 805 emits laser light under the control of the control unit 85 and detects reflected light of the laser light reflected by an object such as a vehicle. Also, for example, the loop-type vehicle detection unit 805 includes a loop coil embedded in the road or the like before entering each lane of a possible toll booth. A vehicle detection unit 805 detects a vehicle based on a change in inductance when the vehicle passes over the loop coil under the control of the control unit 85 . Also, the vehicle detection unit 805 can automatically detect the behavior of the vehicle. For example, a radar detector measures vehicle speed using the Doppler effect when reflected by radar.

The camera 806 photographs the vehicle under the control of the control unit 85 and outputs the photographed image. Under the control of the control unit 85, the camera 806 may output captured images of the vehicle continuously captured.

Gate 807 controls the entry or exit of vehicles from the toll booth to the toll road. The gate 807 opens and closes a start control bar provided in the passage of the toll gate under the control of the control unit 85 . For example, the gate 807 closes the start control bar to physically block vehicle traffic when temporarily stopping the vehicle or disallowing vehicle traffic (entrance or exit). In addition, the gate 807 permits passage of the vehicle by opening the start control bar when permitting passage (entrance or exit) of the vehicle.

Also, when the roadside device 80 is the route device 82, the gate 807 does not have to be installed.

When the vehicle detection unit 805 detects the passage of the vehicle, the communication control unit 8011 of the entrance toll gate device 81 and the route device 82 uses the vehicle communication unit 86 to transmit and receive various information to and from the onboard equipment of the vehicle. Then, the communication control unit 8011 generates a roadside notification packet based on the obtained information, and transmits it to the data reference device 20 through the upper communication unit 84 .

When the vehicle detection unit 805 detects the passage of the vehicle, the communication control unit 8011 of the exit toll gate device 83 uses the vehicle communication unit 86 to transmit and receive various information to and from the on-board device of the vehicle. Then, the communication control unit 8011 generates a roadside notification packet based on the obtained information and transmits it to the data reference device 20 through the upper communication unit 84 . Furthermore, the communication control unit 8011 receives a roadside response packet from the data reference device 20 through the upper communication unit 84 . The control unit 85 displays the toll using the input/output interface 804 according to the content of the roadside response packet, and controls the gate 807 .

FIG. 13 is a diagram showing an example of the configuration of a roadside packet, and FIG. 14 is a diagram showing an example of the configuration of a roadside response packet.

A roadside packet comprises a card ID 90 , a roadside device ID 91 for identifying the roadside device, and a packet type 92 . The packet type 92 includes, for example, information for distinguishing that the vehicle has passed through the entrance toll gate device 81, the route device 82, and the exit toll gate device 83. FIG.

The roadside response packet includes a card ID 90 , a roadside device ID 91 for identifying the roadside device, a packet type 92 , and a toll 93 . In addition, the roadside packet may include various information such as time information and a graph of abnormality determination.

(motion)
15 is a sequence diagram showing an example of a processing procedure of the data reference system shown in FIG. 1; FIG. By the processors 101, 201, and 801 of the database device 10, the data reference device 20, and the roadside device 80 reading and executing the programs stored in the storage units 102, 202, and 802, respectively, This sequence of operations is implemented.

The controller 85 of the entrance tollgate device 81 detects the passage of the vehicle (step ST301). The control unit 85 uses the vehicle detection unit 805 to detect vehicles entering the entrance tollgate. Then, the communication control unit 8011 uses the vehicle communication unit 86 to communicate with the vehicle, and acquires the card ID and the like of the ETC card inserted in the vehicle-mounted device arranged in the vehicle.

Control section 85 outputs a roadside notification packet (step ST302). The control unit 85 outputs a roadside notification packet containing the acquired card ID, the entrance ID for identifying the entrance toll booth device 81, and the packet type. The packet type includes information indicating that the vehicle has passed through the entrance tollgate device 81 .

The communication control section 8011 transmits the roadside notification packet to the data reference device 20 through the upper communication section 84 (step ST303).

Communication control section 2011 transmits a registration request through communication section 203 (step ST304). The communication control unit 2011 receives the roadside notification packet through the communication unit 203 . Then, the processor 201 determines that the roadside notification packet is transmitted from the entrance tollgate device 81 based on the packet type included in the roadside notification packet. The processor 201 outputs a registration request including the card ID and entrance ID included in the roadside notification packet. The communication control unit 2011 then transmits the registration request to the database device 10 through the registration transmission unit 28 .

FIG. 16 is a diagram showing an example of the data structure of each packet.
FIG. 16(a) is a diagram showing an example of the data structure of a registration request. As shown in FIG. 16(a), the registration request includes the card ID and entrance ID. Also, the registration request is not limited to this data, and may of course include arbitrary data.

The request processing unit 12 performs registration processing (step ST305). Communication control section 1011 receives the registration request through communication section 103 . Then, the request processing unit 12 performs registration processing to store in the data storage unit 13 a table in which the card ID and the entrance ID included in the registration request are combined.

After that, the vehicle enters from the entrance toll gate, travels on the toll road, and passes through the route device 82. - 特許庁
The control unit 85 of the route device 82 detects passage of the vehicle (step ST306). The control unit 85 uses the vehicle detection unit 805 to detect vehicles passing through the routing device 82 . Then, the communication control unit 8011 uses the vehicle communication unit 86 to communicate with the vehicle, and acquires the card ID and the like of the ETC card inserted in the vehicle-mounted device arranged in the vehicle.

The control section 85 outputs a roadside notification packet (step ST307). The control unit 85 outputs a roadside notification packet containing the acquired card ID, the route ID for identifying the route device 82, and the packet type. The packet type includes information indicating that the vehicle has passed through routing device 82 .

The communication control section 8011 transmits the roadside notification packet to the data reference device 20 through the upper communication section 84 (step ST308).

Communication control section 2011 transmits a registration request through communication section 203 (step ST309). The communication control unit 2011 receives the roadside notification packet through the communication unit 203 . Then, the processor 201 determines that the roadside notification packet has been transmitted from the routing device 82 based on the packet type contained in the roadside notification packet. The processor 201 outputs a registration request including the card ID and route ID included in the roadside notification packet. The communication control unit 2011 then transmits the registration request to the database device 10 through the registration transmission unit 28 .

FIG. 16(b) is a diagram showing an example of the data structure of a registration request. As shown in FIG. 16(b), the registration request includes card ID and route ID. Also, the registration request is not limited to this data, and may of course include arbitrary data.

The request processing unit 12 performs registration processing (step ST310). Communication control section 1011 receives the registration request through communication section 103 . Then, the request processing unit 12 performs a registration process of storing, in the data storage unit 13, a table in which the route ID is newly added to the table in which the card ID and the entrance ID included in the registration request are paired.

FIG. 17 is a diagram showing an example of the table stored in the data storage section 13 by the process of step ST301. As shown in FIG. 17, the entrance ID and the route ID corresponding to the card ID are in a referable table.

It then attempts to pass through the exit toll booth to exit the toll road.
The exit tollgate device 83 control unit 85 detects the passage of the vehicle (step ST311). The control unit 85 uses the vehicle detection unit 805 to detect vehicles passing through the routing device 82 . Then, the communication control unit 8011 uses the vehicle communication unit 86 to communicate with the vehicle, and acquires the card ID and the like of the ETC card inserted in the vehicle-mounted device arranged in the vehicle.

The control unit 85 outputs a roadside notification packet (step ST312). The control unit 85 outputs a roadside notification packet including the acquired card ID, the exit ID for identifying the exit toll booth device 83, and the packet type. The packet type includes information indicating that the vehicle has passed the exit tollgate device 83 .

The communication control section 8011 transmits the roadside notification packet to the data reference device 20 through the upper communication section 84 (step ST313).

Communication control section 2011 transmits the first reference request through communication section 203 (step ST314A). The communication control unit 2011 receives the roadside notification packet through the communication unit 203 . Then, the processor 201 determines that the roadside notification packet is transmitted from the exit tollgate device 83 based on the packet type included in the roadside notification packet. The processor 201 outputs a first reference request including the card ID included in the roadside notification packet. The communication control unit 2011 then transmits the first reference request through the first request transmission unit 22A.

FIG. 16(c) is a diagram showing an example of the data structure of the first reference request. As shown in FIG. 16(c), the first reference request includes the card ID. Also, the first reference request is not limited to the card ID, and may of course include arbitrary data.

The request processing unit 12 of the database device 10 performs reference processing (step ST315A). The communication control unit 1011 receives the first reference request through the communication unit 103 and outputs the received first reference request to the request processing unit 12 . The request processing unit 12 refers to the data stored in the data storage unit 13 according to the card ID included in the first reference request and outputs a first reference response. For example, the request processing unit 12 acquires from the data storage unit 13 the table corresponding to the information included in the first reference request. The acquired table is, for example, a table associated with card IDs. The request processing unit 12 acquires the entrance ID and the route ID, which are information paired with the card ID, from the acquired table, and outputs a first reference response including the acquired information.

FIG. 16D is a diagram showing an example of the data structure of the first reference response. As shown in FIG. 16(d), the first reference response includes an entrance ID and a route ID.

Communication control section 1011 transmits the first reference response to data reference device 20 (step ST316A). The communication control unit 1011 transmits the output first reference response to the data reference device 20 through the communication unit 103 .

Communication control section 2011 transmits the second reference request to database device 10 (step ST314B). Communication control section 2011 receives the first reference response through response receiving section 23 . Then, the communication control unit 2011 transmits a second reference request including the exit ID included in the roadside notification packet and the entrance ID included in the first reference response to the database device 10 through the request transmission unit 22 .

FIG. 16E is a diagram showing an example of the data structure of the second reference request. As shown in FIG. 16(e), the second reference request includes an entrance ID and an exit ID. Also, the second reference request is not limited to these pieces of information, and may of course include arbitrary data.

The request processing unit 12 of the database device 10 performs reference processing (step ST315B). The communication control unit 1011 receives the second reference request through the communication unit 103 and outputs the received second reference request to the request processing unit 12 . The request processing unit 12 refers to the toll table paired with the entrance ID and the exit ID included in the second reference request, and outputs a second reference response including the toll. That is, the request processing unit 12 outputs the second reference response to the communication control unit 1011 based on the second reference request.

FIG. 18 is a diagram showing an example of the basic charge table referred to in step ST315B. As shown in FIG. 18, the request processing unit 12 can acquire the basic toll corresponding to the entrance ID and the exit ID.

Also, FIG. 16(f) is a diagram showing an example of the data structure of the second reference response. As shown in FIG. 16(f), the second reference response includes the basic toll. Also, the second reference response is not limited to the basic toll, and may of course include any data.

Communication control section 1011 transmits the second reference response to data reference device 20 (step ST316B). The communication control unit 1011 transmits the output second reference response to the data reference device 20 through the communication unit 103 .

Communication control section 2011 transmits a third reference request to database device 10 (step ST314C). Communication control section 2011 receives the second reference response through response receiving section 23 . Then, the communication control unit 2011 transmits a third reference request including the path ID included in the first reference response to the database device 10 through the request transmission unit 22 .

FIG. 16(g) is a diagram showing an example of the data structure of the second reference request. As shown in FIG. 16(g), the third reference request includes the route ID. Also, the third reference request is not limited to the route ID, and may of course include arbitrary data.

Request processing unit 12 of database device 10 performs reference processing (step ST315C). The communication control unit 1011 receives the second reference request through the communication unit 103 and outputs the received second reference request to the request processing unit 12 . The request processing unit 12 refers to the variable toll table paired with the route ID included in the third reference request, and outputs a third reference response including the adjusted toll. That is, the request processing unit 12 outputs the third reference response to the communication control unit 1011 based on the third reference request.

FIG. 19 is a diagram showing an example of the adjustment fee table referred to in step ST315C. As shown in FIG. 19, the request processing unit 12 can acquire the variable charge corresponding to the route ID. For example, when the route ID is 5001, it indicates that the toll is minus 100 yen.

Also, FIG. 16(h) is a diagram showing an example of the data structure of the third reference response. As shown in FIG. 16(h), the third reference response contains the adjusted toll. Also, the third reference response is not limited to the basic toll, and may of course include arbitrary data.

Communication control section 1011 transmits the third reference response to data reference device 20 (step ST316C). The communication control unit 1011 transmits the output second reference response to the data reference device 20 through the communication unit 103 .

Here, steps ST314C to ST316C may be repeated for the number of times the vehicle has passed through a plurality of routing devices 82 . Further, the basic charge table and the adjustment charge table may be set for each vehicle type, for each time period, or for each version of the vehicle-mounted device. The adjustment fee table may be set according to the weather, ongoing events, road construction and traffic closures, and the like.

Processor 201 calculates the toll (step ST317). The communication control unit 2011 receives the third reference response through the third response receiving unit 23C. Processor 201 then determines a billable toll based on the base toll and adjusted toll included in the second referral response and the third referral response.

Processor 201 transmits a roadside response packet (step ST318). The processor 201 outputs a roadside response packet containing the determined billed toll. The communication control unit 2011 then transmits the roadside response packet to the exit tollgate device 83 through the response transmission unit 25 .

The control unit 85 presents the billed toll (step ST319). The communication control unit 8011 receives the roadside response packet through the upper communication unit 84 . Then, the control unit 85 uses the display unit of the input/output interface 804 to display the billed toll.

Control unit 85 controls gate 807 (step ST320). The control unit 85 controls the gate 807 based on the roadside response packet. For example, when permitting the passage of vehicles, the start control bar of the gate 807 is opened to permit the passage of vehicles.

Here, in FIG. 15, for the sake of simplification, the roadside notification packets transmitted from the entrance toll gate device 81, the route device 82, and the exit toll gate device 83 are shown for only one vehicle. However, it goes without saying that there are a plurality of roadside notification packets corresponding to each vehicle. Therefore, in the second embodiment, as in the first embodiment, even if the data reference device 20 receives another reference request after transmitting the reference request to the database device 10 and before receiving the reference response, Of course, it is possible to send the other reference request to the database device 10 .

Further, the communication control unit 2011 includes a plurality of CPUs, transmits the first reference request to the database device 10 using a first CPU among the plurality of CPUs through the communication unit 203, and It is also possible to send the second reference request to the database device 10 using a second CPU among the CPUs. That is, by causing each process to be processed by one of the plurality of CPUs, transmission of reference requests and reception of reference responses can be performed in parallel.

(Action and effect of the second embodiment)
According to the embodiment described above, the data reference device 20 is arranged between the roadside device 80 and the database device 10 in the data reference system. After transmitting the first reference request to the database device 10, if the second reference request packet is received before receiving the first reference response, the communication control unit 2011 uses the request transmission unit 22 to and transmits a second reference request to the database based on the second reference request packet. As a result, it becomes possible to process a plurality of requests simultaneously, so that the throughput, which is the number of requests processed per arbitrary unit time, can be increased.

[Other embodiments]
In addition, this invention is not limited to the said embodiment. For example, in an embodiment,
Although the case where one reference request packet is received until the data reference device 20 receives the first reference response has been described, the number is not limited to one. Therefore, when receiving a plurality of reference request packets before receiving a reference response, the data reference device 20 may transmit a plurality of reference requests to the database device 10 .

While several embodiments of the invention have been described, these embodiments have been presented by way of example and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, replacements, and modifications can be made without departing from the scope of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the scope of the invention described in the claims and equivalents thereof.

DESCRIPTION OF SYMBOLS 10... Database apparatus 11... Connection reception part 12... Request processing part 13... Data storage part 101... Processor 102... Storage part 103... Communication part 104... Input/output interface 105... Bus 1011... Communication control part 20... Data reference device 21... Connection unit 22 Request transmission unit 23 Response reception unit 24 Request reception unit 25 Response transmission unit 26 Connection reception unit 27 Registration connection unit 28 Registration transmission unit 201 Processor 202 Storage unit 203 Communication unit 204 Input/output interface 205 Bus 210 Processor 2011 Communication control unit 30 Management server 31 Network 40 Client device 41 Connection unit 42 Data reference request unit 43 Data response reception unit 401 Processor 402 Storage unit 403 Communication unit 404 Input/output interface 405 Bus 4011 Communication control unit 80 Roadside device 81 Entrance tollgate device 82 Route device 83 Exit tollgate device 84 Host communication unit 85 Control unit 86 Vehicle communication unit 801... Processor 802... Storage unit 803... Communication unit 804... Input/output interface 805... Vehicle detection unit 806... Camera 807... Gate 808... Bus 8011... Communication control unit 90... Card ID
91 Roadside device ID
92...Packet type 93...Toll

Claims (13)

a data reference device;
a database device connected to the data reference device;
with
The data reference device is
causing the first communication unit to transmit a first reference request to the database device based on the first reference request packet when the first reference request packet is received, and responding to the first reference request; A first reference response that is a result is received, and if a second reference request packet is received before the first reference response is received, a second reference request is generated based on the second reference request packet. A first communication control unit that causes the database device to transmit and receives a second reference response as a result of responding to the second reference request,
The database device
A request processing unit that refers to a first table and a second table corresponding to the first reference request and the second reference response, respectively, and outputs the first reference response and the second reference response. When,
a second communication control unit that causes a second communication unit to transmit the first reference response and the second reference response to the data reference device;
A data reference system comprising: The first communication control unit causes the first communication unit to transmit a third reference request based on the first reference response to the database device,
the request processing unit refers to a third table corresponding to the third reference request and outputs a third reference response;
2. The data reference system according to claim 1, wherein said second communication control section causes said second communication section to transmit said third reference response to said data reference device. 3. The data referencing system of claim 2, wherein said third referral request is further based on said first referral request packet. 4. A data referencing system according to claim 2 or 3, wherein said first reference response is an intermediate value and said third reference response is an output value. The first reference request packet is received from an exit tollgate device on a toll road and includes a card ID of an ETC card inserted in a vehicle-mounted device and an ID of the exit tollgate device, and the first reference request is , the card ID, the first reference response includes the ID of the entrance toll booth device located at the entrance toll booth, the third reference request includes the ID of the exit toll booth device and the entrance toll 5. The data reference system according to any one of claims 2 to 4, wherein said third reference response includes an ID of a toll gate device, and said third reference response includes a toll from said entrance toll gate device to said exit toll gate device. The first communication control unit causes the first communication unit to transmit a fourth reference request based on the third reference response to the database device,
the request processing unit refers to a fourth table corresponding to the fourth reference request and outputs a fourth reference response;
3. The data reference system according to claim 2, wherein said second communication control section causes said second communication section to transmit said fourth reference response to said data reference device. The first reference request packet is received from an exit tollgate device on a toll road and includes a card ID of an ETC card inserted in a vehicle-mounted device and an ID of the exit tollgate device, and the first reference request is , the card ID is included, the first reference response includes the ID of the entrance tollgate device arranged at the entrance tollgate and the ID of the route device through which the on-vehicle device has passed, and the third reference request includes: the ID of the exit toll booth device and the ID of the entrance toll booth device, the third reference response comprising a basic toll from the entrance toll booth device to the exit toll booth device, and the fourth reference 7. The data referencing system of claim 6, wherein the request includes an ID of the routing device and the fourth referral response includes an adjusted toll. The first table is a table in which the first reference request and the first reference response are combined, and the second table is a table in which the second reference request and the second reference response are combined. 6. A data referencing system according to any one of claims 1 to 5, wherein is a paired table. 7. The data reference system according to claim 1, wherein said data reference device and said database device are directly connected. The first communication control unit comprises a plurality of CPUs, and causes the first communication unit to transmit the first reference request to the database device using a first CPU among the plurality of CPUs; 8. The data reference system according to any one of claims 1 to 7, wherein a second CPU among said plurality of CPUs is used to transmit said second reference request to said database device. When the first reference request packet is received, the first communication unit is caused to transmit the first reference request to the database device based on the first reference request packet, and the result of responding to the first reference request and if a second reference request packet is received before receiving the first reference response, a second reference request is sent to the database based on the second reference request packet A data reference device comprising a first communication control unit that causes the device to transmit and receive a second reference response as a result of responding to the second reference request. A data reference method performed by a data reference device,
transmitting a first reference request to a database device based on the first reference request packet when a first reference request packet is received;
receiving a first referral response resulting from responding to the first referral request;
transmitting a second reference request to the database device based on the second reference request packet when a second reference request packet is received before receiving the first reference response; receiving a second referral response resulting from responding to the referral request of
A data reference method comprising: 13. A data reference program causing a processor of said data reference device to execute the data reference method according to claim 12.

Images