JP6218720B2 - Data processing system, server and data processing management program - Google Patents

Description

  The present invention relates to a data processing system, a server, and a data processing management program. In particular, in response to a request given from one terminal to a server, a processing result of data stored in another terminal or database is requested from the server. It is suitable for use in a system configured to be provided to other terminals.

  In recent years, a technique called “business intelligence (BI)”, which is intended to be utilized for management decision making by collecting, accumulating and analyzing in-house data accumulated from business systems and the like, has attracted attention. As software used in this business intelligence technology, so-called BI tools are being widely provided.

  As one form of the BI tool, software called a dashboard is provided. Dashboards have a main function to collect various data surrounding a company from internal systems and databases, and to calculate and calculate and display charts and graphs. The dashboard can connect to various data sources and dynamically visualize the aggregated result according to the request from the user.

  For example, a server with a dashboard function is provided on the Internet (cloud), and in response to a request given from an external terminal to the server, the server collects data collected from the internal terminal or database and processes it into a chart or graph. There is a known system (hereinafter referred to as a first conventional system) for displaying on a requesting external terminal.

  In-house terminals, servers, and external terminals can be connected to each other via the Internet, and the server processes data stored in the server database based on requests from the internal terminals or external terminals. A system (hereinafter referred to as a second conventional system) that transmits the processing result to an in-house terminal or an external terminal that is a request source is also known (see, for example, Patent Document 1).

JP 2004-5130 A

  The first conventional system is a type in which the server acquires data from another terminal and performs processing according to the request based on a request from the terminal. On the other hand, the second conventional system is a type in which a server performs processing according to a request from a terminal on data stored in the server. Both types have a mechanism for processing data according to a request in the server.

  The second conventional system is a general system represented by a client-server system, in which information resources such as a database are centrally managed by a server, and the information resources can be shared by a plurality of clients. . For example, a system in which data in each terminal is uploaded to a server database and the data in the database is shared is typical of the second conventional system.

  In this second conventional system, if data is stored in the server, requests can be sent from any terminal to the server, and desired data can be aggregated or processed into graphs or charts. . Conversely, however, local data in a terminal that has not been uploaded to the server cannot be processed by the server in response to a request from another terminal.

  On the other hand, the first conventional system is a form that has begun to be used in recent years, and it is possible to process data stored in one terminal at a server in response to a request from another terminal. . For example, as described above, in response to a request given to the server from an external terminal (for example, a smartphone, a tablet terminal, a laptop computer, etc.), the server acquires and processes data from the internal terminal, and the result is sent to the request source. It can be provided to an external terminal.

  However, in the first conventional system, when a data processing request is made to the server, it is necessary to transmit the data to the server from the terminal storing the data to be processed. Therefore, there is a problem that the data transmission takes time and the response becomes slow. In particular, when the amount of data to be transmitted increases, the time required for data transmission becomes longer, and the response is further delayed.

  The present invention has been made to solve such a problem, and in response to a request given from a terminal to a server, a processing result of data stored in another terminal or database is sent from the server to the request source. It is an object of the present invention to reduce the response time from when a request is issued until a data processing result is obtained.

In order to solve the above-described problems, in the present invention, when a server receives a request regarding data processing for data stored in a database from a terminal, the server separates the request together with an execution program for executing data processing. The data processing is transmitted to the other terminal and the data processing is executed, and the result of the data processing executed in the other terminal is received and provided to the requesting terminal. Here, the execution program transmitted from the server to another terminal is either the first type execution program or the second type execution program according to the type of the database. The first type of execution program is a program for acquiring data from a database and performing data processing. The second type of execution program is a program for causing a database to execute data processing and acquiring the processing result. It is.

  According to the present invention configured as described above, the original data necessary for executing the data processing according to the request from the terminal is not transmitted from another terminal to the server, but the original data is transmitted from another terminal. Is processed, and the result of the data processing is transmitted from another terminal to the server. For this reason, compared with the case where original data is transmitted, the amount of data to be transmitted can be reduced, and the time required for data transmission can be shortened. Thereby, the response time from when the terminal issues a request to the server until it obtains the data processing result can be shortened.

It is a figure which shows the example of whole structure of the data processing system by this embodiment. It is a block diagram which shows the function structural example of the server by this embodiment, and an in-house terminal. It is a flowchart which shows the operation example of the server by this embodiment. It is a flowchart which shows the operation example of the in-house terminal by this embodiment.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing an example of the overall configuration of the data processing system according to the present embodiment. As shown in FIG. 1, the data processing system of this embodiment includes a server 10, an in-house terminal 20, and an outside terminal 30. The server 10 is installed on the Internet (cloud). The in-house terminal 20 is installed on, for example, an in-house LAN that can be connected to the Internet. A database 27 is connected to the in-house terminal 20. The external terminal 30 is a terminal that can be connected to the Internet from outside the internal LAN.

  The data processing system of the present embodiment is a database of an in-house terminal 20 (corresponding to another terminal in claims) in response to a request given to the server 10 from an external terminal 30 (corresponding to a terminal in claims). The processing result of the data stored in 27 is provided from the server 10 to the requesting external terminal 30. Specifically, data processing (aggregation, processing, etc.) corresponding to the request is executed in the in-house terminal 20, and the result of the data processing is provided to the external terminal 30 via the server 10.

  FIG. 2 is a block diagram illustrating a functional configuration example of the server 10 and the in-house terminal 20 according to the present embodiment. As illustrated in FIG. 2, the server 10 according to the present embodiment includes a request reception unit 11, a request generation unit 12, a request transmission unit 13, an execution program transmission unit 14, a processing result reception unit 15, and a processing result as a functional configuration by software. A providing unit 16 is provided. In addition, the server 10 of the present embodiment includes an execution program storage unit 17 as a hardware configuration.

  Further, the in-house terminal 20 of the present embodiment includes a request reception unit 21, an execution program reception unit 22, a cache management unit 23, a data processing execution unit 24, and a processing result transmission unit 25 as a functional configuration by software. Further, the in-house terminal 20 of the present embodiment includes a cache memory 26 as a hardware configuration. Furthermore, a database 27 is connected to the in-house terminal 20. As shown in FIG. 1, this database 27 may be unique to one in-house terminal 20 or may be shared by a plurality of in-house terminals 20 through an in-house LAN.

  Each of the functional blocks 11 to 16 of the server 10 is actually configured by including a CPU, RAM, ROM, etc. of a computer, and a program stored in a recording medium such as RAM, ROM, hard disk, or semiconductor memory (Claims) This is realized by the operation of the data processing management program. This program may be a dashboard program, for example. Similarly, each of the functional blocks 21 to 25 of the in-house terminal 20 is actually configured by including a computer CPU, RAM, ROM, and the like, and is realized by operating a program stored in a recording medium. Note that all or part of the functional blocks 11 to 16 and 21 to 25 can be configured by hardware or a DSP (Digital Signal Processor).

  The request receiving unit 11 of the server 10 receives a request regarding data processing from the external terminal 30. This request specifies what data processing is performed for which data in which database 27 connected to which in-house terminal 20. For example, the server 10 is accessed from the external terminal 30 and a desired application screen provided by the dashboard program is opened. In this state, when the user operates the external terminal 30 to instruct to specify desired data in the database 27 on the application screen and perform desired data processing, the request representing the instruction content is displayed in the external terminal. 30 to the server 10. The request receiving unit 11 of the server 10 receives this request.

  Here, the types of applications that can be executed by the dashboard program and the contents of data processing executed on the applications are arbitrary, and the present invention is not particularly limited thereto. As an example, it is possible to perform various aggregation processes or various chart creation processes on the form data stored in the database 27 of the in-house terminal 20 by a form management application. In this case, the user of the external terminal 30 can specify desired form data as a processing target on the application screen opened by the dashboard program, and can instruct a desired totaling process or a desired chart creation process. It is. The request receiving unit 11 receives a request representing the instruction content.

  When the request generation unit 12 receives a request regarding data processing from the external terminal 30, the request generation unit 12 generates a request in which the request is changed into a format executable by the internal terminal 20. The contents of the request specify what data in which database 27 connected to which in-house terminal 20 is to be processed, and are the same as the contents of the request received from the external terminal 30. is there. The request transmission unit 13 transmits the request generated by the request generation unit 12 to any in-house terminal 20 to execute data processing.

  When the request transmission unit 13 transmits a request to the in-house terminal 20, the execution program transmission unit 14 transmits an execution program for executing the data processing specified by the request to the in-house terminal 20. The execution program to be transmitted here is stored in advance in the execution program storage unit 17. The execution program to be transmitted in the present embodiment is not of a type for processing data sent together with the execution program, but includes a communication protocol with the database 27, and executes data processing through exchange with the database 27. It is a program made in

  The constituent unit of the execution program is arbitrary. For example, the constituent unit of the execution program related to the tabulation process can be divided into the tabulation types to constitute the execution program. In this way, the size of each execution program can be made relatively small. Alternatively, in order to avoid an increase in the number of execution programs, it is possible to configure one execution program by combining a plurality of types of aggregation functions. The same applies to the execution program related to chart creation. For example, the execution program can be configured separately for each type of chart. Alternatively, it is also possible to configure one execution program by combining a plurality of types of chart creation functions.

  In the present embodiment, the execution program transmission unit 14 is configured to execute the first type execution program or the second type according to the type of the database 27 provided in the in-house terminal 20 specified by the request generated by the request generation unit 12. Are read from the execution program storage unit 17 and transmitted. The first type of execution program is a program for the data processing execution unit 24 of the in-house terminal 20 to acquire necessary data from the database 27 and perform data processing. On the other hand, in the second type execution program, the data processing execution unit 24 of the in-house terminal 20 issues an SQL command to the database 27 to cause the database 27 to execute data processing, and the data processing execution unit 24 sends the processing result to the database 27. It is a program for obtaining from.

  Depending on the type of the database 27, there are cases where the data processing execution unit 24 acquires data from the database 27 and processes the data faster, and data processing performed in the database 27 is faster. Therefore, in this embodiment, the type of the database 27 connected to the in-house terminal 20 is registered in the server 10 in advance. Then, when the execution program transmitting unit 14 transmits the execution program to the in-house terminal 20, the type of the database 27 is determined, and the execution program of either the first type or the second type is selected according to the type of the database 27. The program is read from the execution program storage unit 17 and transmitted.

  The request receiver 21 of the in-house terminal 20 receives the request transmitted by the request transmitter 13 of the server 10. The execution program reception unit 22 receives the execution program transmitted by the execution program transmission unit 14 of the server 10. When the execution program receiving unit 22 receives the execution program transmitted by the execution program transmitting unit 14, the cache management unit 23 stores the received execution program in the cache memory 26 and manages it.

  The execution program transmitting unit 14 inquires of the cache management unit 23 whether or not the execution program to be transmitted is stored in the cache memory 26 of the in-house terminal 20, and the execution program is stored in the cache memory 26. The execution program is transmitted to the in-house terminal 20 only when a response indicating that it is not received is returned from the cache management unit 23.

  When the request reception unit 21 receives the request transmitted by the request transmission unit 13 of the server 10, the data processing execution unit 24 transmits the execution program transmitted by the execution program transmission unit 14 and received by the execution program reception unit 22 (however, If the data is stored in the cache memory 26, the data processing according to the request is executed on the data stored in the database 27 in accordance with the execution program in the cache memory 26).

  The processing result transmission unit 25 of the in-house terminal 20 transmits the data processing result executed by the data processing execution unit 24 to the server 10. That is, in this embodiment, instead of reading the original data necessary for performing the data processing specified by the request from the database 27 and transmitting it to the server 10, the internal terminal 20 performs the data processing, and the processing result Is transmitted to the server 10. Generally, by summing up the original data, the data of the summation result is smaller in size than the original data. Further, by creating a chart from the original data, the size of the generated chart data is smaller than that of the original data.

  The processing result receiving unit 15 of the server 10 receives the result of data processing executed in the in-house terminal 20. The processing result providing unit 16 provides the data processing result received by the processing result receiving unit 15 to the requesting external terminal 30. The providing method in this case is arbitrary. As an example, it is preferable to provide a result of data processing through an application screen provided by the dashboard program of the server 10.

  FIG. 3 is a flowchart illustrating an operation example of the server 10 configured as described above according to the present embodiment. First, the request receiving unit 11 determines whether or not a request related to data processing has been received from the external terminal 30 (step S1). If the request has not been received, the determination process in step S1 is continued.

  On the other hand, when the request receiving unit 11 receives a request from the external terminal 30, the execution program transmitting unit 14 determines the type of the database 27 connected to the in-house terminal 20 identified as the terminal that performs data processing by the request. To do. Then, an execution program to be transmitted to the in-house terminal 20 is specified based on the content of the data processing specified by the request and the determined type of the database 27 (step S2).

  Next, the execution program transmission unit 14 inquires of the cache management unit 23 whether or not the execution program specified as described above is stored in the cache memory 26 of the in-house terminal 20 (step S3). Then, the execution program transmission unit 14 determines whether or not there is a response that the execution program is stored in the cache memory 26 (step S4).

  If it is determined that the execution program is stored in the cache memory 26, the execution program transmission unit 14 does not transmit the execution program to the in-house terminal 20. In this case, the request transmission unit 13 transmits only the request generated by the request generation unit 12 based on the request received by the request reception unit 11 to the in-house terminal 20 (step S5).

  On the other hand, when it is determined that the execution program is not stored in the cache memory 26, the request transmission unit 13 sends the request generated by the request generation unit 12 based on the request received by the request reception unit 11 to the in-house terminal 20. The execution program transmission unit 14 reads out the execution program specified in step S2 from the execution program storage unit 17 and transmits it to the in-house terminal 20 (step S6).

  After performing the processing of step S5 or step S6, the processing result receiving unit 15 receives the data processing result from the in-house terminal 20 (step S7). Then, the processing result providing unit 16 provides the data processing result received by the processing result receiving unit 15 to the requesting external terminal 30 (step S8). Thereby, the process of the flowchart shown in FIG. 3 is completed.

  FIG. 4 is a flowchart showing an operation example of the in-house terminal 20 according to the present embodiment configured as described above. First, the request receiving unit 21 determines whether a request is received from the server 10 (step S11). If the request has not been received, the determination process in step S11 is continued.

  On the other hand, when the request reception unit 21 receives a request from the server 10, the execution program reception unit 22 determines whether or not the execution program is received from the server 10 (step S12). Here, when the execution program is received, the data processing execution unit 24 performs data processing corresponding to the request received by the request reception unit 21 on the data stored in the database 27 according to the received execution program. (Step S13).

  On the other hand, when the execution program reception unit 22 has not received the execution program, the data processing execution unit 24 performs a request reception unit on the data stored in the database 27 according to the execution program stored in the cache memory 26. Data processing corresponding to the request received by 21 is executed (step S14). When a plurality of execution programs are stored in the cache memory 26, the data processing execution unit 24 reads the execution program that was inquired immediately before from the cache management unit 23 and executes it.

  After performing the processing of step S13 or step S14, the processing result transmission unit 25 transmits the result of the data processing executed by the data processing execution unit 24 to the server 10 (step S15). Thereby, the process of the flowchart shown in FIG. 4 is completed.

  As described above in detail, in the data processing system of the present embodiment, when the server 10 receives a request for data processing from the external terminal 30, the server 10 transmits the request to the internal terminal 20 to execute the data processing, and the internal terminal The result of the data processing executed at 20 is received and provided to the requesting external terminal 30.

  According to the data processing system of the present embodiment configured as described above, original data necessary for executing data processing in response to a request from the external terminal 30 is not transmitted from the internal terminal 20 to the server 10. Instead, data processing is performed on the original data in the in-house terminal 20, and the result of the data processing is transmitted from the in-house terminal 20 to the server 10. For this reason, compared with the case where original data is transmitted, the amount of data transmitted from the in-house terminal 20 to the server 10 can be reduced, and the time required for data transmission can be shortened. As a result, the response time from when the external terminal 30 issues a request to the server 10 until obtaining the data processing result can be shortened.

  Further, in the present embodiment, the in-house terminal 20 does not have an execution program used when data processing is performed in the in-house terminal 20, and is transmitted from the server 10 to the in-house terminal 20 every time there is a request. . As a result, even if there is a change in the contents of the tabulation process and chart creation process that can be provided due to, for example, a version upgrade of the dashboard program of the server 10, the version of the execution program in the in-house terminal 20 accordingly There is an advantage that there is no need to perform up.

  Note that when the execution program is transmitted from the server 10 to the in-house terminal 20 together with the request, a certain amount of transmission time is required. In order to shorten the transmission time, the execution program may be installed in the in-house terminal 20 in advance, and the execution program may not be transmitted. However, in this case, it is necessary to upgrade the execution program in the in-house terminal 20 in accordance with the upgrade of the dashboard program in the server 10.

  In the present embodiment, the execution program transmitted from the server 10 to the in-house terminal 20 is configured by a predetermined unit divided for each type of aggregation and each type of chart, for example. For this reason, even if the execution program is transmitted from the server 10 to the in-house terminal 20, the amount of data can be reduced as much as possible. When the execution program is already stored in the cache memory 26 of the in-house terminal 20, the execution program is not transmitted and the execution program in the cache memory 26 is used. As a result, the frequency of transmitting the execution program can be reduced. As described above, it is possible to reduce the data amount and the transmission frequency of the execution program transmitted from the in-house terminal 20 to the server 10 while avoiding the version upgrade of the execution program in the in-house terminal 20, and to shorten the time required for program transmission. Can do.

  In the above-described embodiment, the example in which the in-house terminal 20 executes the process according to the request on the data stored in the database 27 has been described, but the present invention is not limited to this. For example, the in-house terminal 20 may execute processing according to a request on data stored in an internal local storage medium, data stored in a file server of the in-house LAN, and the like.

  In the above embodiment, the aggregation process or the chart creation process is described as an example of the data process, but the present invention is not limited to this. For example, various analysis processes, graph creation processes, various calculation processes, and the like may be used.

  Moreover, although the said embodiment demonstrated the example which performs a data process in the internal terminal 20 according to the request from the external terminal 30, this invention is not limited to this. That is, the present invention can be applied to any system that performs data processing at another terminal in response to a request given from one terminal to the server 10.

  Moreover, although the said embodiment demonstrated the example which transmits the execution program of either the 1st type or the 2nd type from the server 10 to the company terminal 20 according to the classification of the database 27, this invention is not limited to this. . For example, in addition to the type of database 27, the type of execution program may be selected according to cardinality.

  Moreover, although the said embodiment demonstrated the example which performs all the data processing according to the request given to the server 10 from the external terminal 30 in the internal terminal 20, this invention is not limited to this. For example, primary processing is performed in the in-house terminal 20 and the result is transmitted to the server 10, secondary processing is performed in the server 10 on the result of the primary processing, and the result of the secondary processing is provided to the external terminal 30. It may be. In this way, since only the execution program relating to the primary process needs to be transmitted from the server 10 to the in-house terminal 20, the size of the program to be transmitted can be reduced and the transmission time can be shortened.

  In the above embodiment, the dashboard program is described as an example of the data processing management program installed in the server 10, but the present invention is not limited to this. In other words, in response to a request given to the server 10 from a certain terminal, if it is a program having a data processing management function for executing data processing in another terminal and transmitting the processing result to the requesting terminal, The present invention can be applied to both.

  In addition, each of the above-described embodiments is merely an example of actualization in carrying out the present invention, and the technical scope of the present invention should not be construed in a limited manner. That is, the present invention can be implemented in various forms without departing from the gist or the main features thereof.

DESCRIPTION OF SYMBOLS 10 Server 11 Request reception part 12 Request generation part 13 Request transmission part 14 Execution program transmission part 15 Process result reception part 16 Process result provision part 17 Execution program memory | storage part 20 In-house terminal (another terminal)
DESCRIPTION OF SYMBOLS 21 Request receiving part 22 Execution program receiving part 23 Cache management part 24 Data processing execution part 25 Processing result transmission part 26 Cache memory 27 Database 30 External terminal (terminal)

Claims (3)

On request given to the server from the terminal, the processing result of the data stored in the database a made data processing system to provide to the requesting terminal from the server,
The server
A request transmission unit configured to transmit the request to the other terminal and execute the data processing when receiving the request related to data processing from the terminal;
When the request transmission unit transmits the request to the another terminal, an execution program transmission unit that transmits an execution program for executing the data processing to the other terminal;
A processing result receiving unit for receiving a result of the data processing executed in the other terminal;
A processing result providing unit that provides the request source terminal with the result of the data processing received by the processing result receiving unit;
The other device is
Data that, when receiving the request transmitted by the request transmission unit, executes processing according to the request for the data stored in the database according to the execution program transmitted by the execution program transmission unit A process execution unit;
A processing result transmission unit that transmits the result of the data processing executed by the data processing execution unit to the server ;
The execution program transmission unit is configured to transmit either the first type execution program or the second type execution program according to the type of the database,
The execution program of the first type is a program for acquiring data from the database and performing the data processing,
The data processing system according to claim 2, wherein the execution program of the second type is a program for causing the database to execute the data processing and acquiring the processing result . On request given from the terminal, a server that is adapted to provide the processing result of the data stored in the database to the requesting terminal,
A request transmission unit configured to transmit the request to the other terminal and execute the data processing when receiving the request related to data processing from the terminal;
When the request transmission unit transmits the request to the another terminal, an execution program transmission unit that transmits an execution program for executing the data processing to the other terminal;
A processing result receiving unit for receiving a result of the data processing executed in the other terminal according to the execution program transmitted by the execution program transmitting unit ;
A processing result providing unit that provides the request source terminal with the result of the data processing received by the processing result receiving unit ;
The execution program transmission unit is configured to transmit either the first type execution program or the second type execution program according to the type of the database,
The execution program of the first type is a program for acquiring data from the database and performing the data processing,
The server according to claim 2, wherein the execution program of the second type is a program for causing the database to execute the data processing and acquiring the processing result . On request given from the terminal, a data processing management program which is executed in the made a server to provide a processing result of the data stored in the database to the requesting terminal,
A request transmission means for transmitting the request to the other terminal and executing the data processing when the request for data processing is received from the terminal;
An execution program transmission means for transmitting an execution program for executing the data processing to the other terminal when the request transmission means transmits the request to the other terminal;
The processing result receiving means for receiving the result of the data processing executed in the other terminal according to the execution program transmitted by the execution program transmitting means , and the result of the data processing received by the processing result receiving means The server computer functions as a processing result providing means for providing to the requesting terminal ,
The execution program transmission means is configured to transmit either the first type execution program or the second type execution program according to the type of the database,
The execution program of the first type is a program for acquiring data from the database and performing the data processing,
The computer program readable for data processing management, wherein the second type execution program is a program for causing the database to execute the data processing and acquiring the processing result .

Images