JP2009271705A - Information providing system, information providing device, information providing method, and information providing program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an information providing system, an information providing device, an information providing method, and an information providing program for surely obtaining a processing result without interrupting processing due to the interruption of a network. <P>SOLUTION: An information providing device includes: a processing instruction receiving means for receiving a processing instruction for processing registration information registered in a database requested by a user from a terminal device 3 connected through a network; a back execution means for continuously performing registration information processing for executing processing based on the processing instruction regardless of the connecting state of the network of the terminal device 3 and the Web server 1; and an information providing means for providing the processing result processed by the back execution means based on the processing instruction to the user regardless of the connecting state of the network of the terminal device 3 and the Web server 1. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention generates an information to be presented to a user based on information registered in a database in response to a request from a terminal device via a network, and provides the information to the terminal device The present invention relates to a technical field such as an information providing apparatus, an information providing method, and an information providing program.

  With the recent diversification of electronic commerce, companies are processing data related to an enormous number of electronic commerce every day. These data include, for example, names, addresses, sales products, sales dates, sales quantities, monetary amounts, etc. as data related to customers, and these data are accumulated daily with corporate activities. Appropriately obtaining and managing these data contributes to sales promotion and further development of corporate activities.

  Patent Document 1 discloses a technique for performing daily processing for collecting business data quickly and accurately in business data processing using an electronic computer system.

  Normally, these data are stored and managed in a database as important company information, and are used according to the necessity of company activities. For example, when a new product is released, information on customers who have purchased products similar to the new product in the past is extracted from these data, and a DM (Direct Mail) is sent to this customer. Or encourage purchases. Therefore, it is an important factor in the development of corporate activities to efficiently aggregate and use these stored data.

Patent Document 2 discloses an invention that aggregates data obtained from an unspecified number of respondents and notifies the data desired by the subject as a data aggregation method.
JP 2002-014916 A JP 08-255149 A

  However, since the data related to electronic commerce is enormous, for example, when the terminal device searches the data from a database connected to a network, the processing on the database side cannot keep up with the amount of data, and these processing May take a long time. Therefore, the user who requests these data waits for a long time until the processing is completed, and the work time is wasted.

  During this time, the terminal device cannot perform other operations and enters a waiting state, that is, a state in which no input is made. In this way, if devices that are connected via a network continue to be in the state of no input without any signal transmission / reception, timeout processing is performed from the viewpoint of preventing congestion due to network line occupation. The line is cut off. As a result, the line is disconnected without completing the processing on the database side, and the terminal device cannot obtain the data processing result.

  Also, in recent years, from the viewpoint of preventing security problems, for example, social engineering, there has been a measure to automatically shut off the power of the terminal device when the terminal device has not been input for a certain period of time. Has been taken.

  Therefore, in order to obtain the processing result of a huge amount of data, the user spends wasted time and needs to perform some input work on the terminal device. As a result, the processing result of the data is obtained. Until then, there was a problem that it was not possible to leave the terminal device.

  The present invention has been made in view of the above points. An information providing system, an information providing apparatus, an information providing method, and an information providing method capable of reliably obtaining a processing result without being interrupted due to a network interruption or the like. The purpose is to provide information provision programs.

  In order to solve the above problem, the invention according to claim 1 is a processing command for processing registration information registered in a database, which is requested by a user from a terminal device connected via a network. Processing instruction receiving means for receiving the information, and back execution means for continuously performing registration information processing for executing processing based on the processing instructions regardless of the network connection state of the terminal device and the information providing device, Information providing means for providing the user with a processing result processed by the back execution means based on a processing command regardless of a network connection state between the terminal device and the information providing apparatus.

  According to this invention, when the information providing apparatus receives a processing command for processing the registration information registered in the database from the terminal device, the registration information for executing processing based on the processing command by the back execution means The processing is continuously performed regardless of the network connection state between the terminal device and the information providing device. The information providing apparatus can provide the processing result to the terminal apparatus regardless of the network connection state between the terminal apparatus and the information providing apparatus.

  Therefore, even when processing registration information having a large amount of data, it is not necessary to continue the session between the terminal device and the information providing device until the processing result is provided by the back execution means. The processing result can be obtained reliably without interruption of the processing due to the interruption of the network, and the terminal device can be used for other purposes until the processing result is obtained.

  According to a second aspect of the present invention, in the information providing apparatus according to the first aspect, the processing instruction includes a request instruction for a back execution process, and the processing instruction receiving means outputs a request instruction for the back execution process. When received, the back execution means continues the registered information processing even if the connection with the terminal device is cut off.

  According to the present invention, only when there is a request for back execution processing from the terminal device, the registration information processing is continued even if the connection with the terminal device is interrupted. When there is a high possibility that the process will be interrupted due to a network interruption or the like, or when an immediate logout request is made to make effective use of the terminal device, the user actively disconnects the session by operating the terminal device. By using this, the back execution process can be selected.

  According to a third aspect of the present invention, in the information providing device according to the second aspect, the back execution unit generates a link that allows access to a processing result, and the link, a user ID of the terminal device, and the processing The results are stored in association with each other, and when there is an access after the connection with the terminal device is interrupted, the user authentication is performed with the user ID, and then the data on the screen with the link attached is stored in the terminal device. It is characterized by transmitting.

  According to the present invention, since the terminal device is prompted to access the processing result at the next access after the session is disconnected, the user is alerted that the back execution processing has been performed by the session disconnection. Can do.

  According to a fourth aspect of the present invention, in the information providing apparatus according to the first aspect, the back of notifying the user that the processing by the back execution means is recommended according to the processing command input by the user. An execution recommendation notification unit is further provided.

  According to the present invention, it is possible to promptly notify the user that processing by the back execution means is desirable.

  The invention according to claim 5 is the information providing apparatus according to claim 4, further comprising a back execution time calculating means for calculating a time required for the processing by the back execution means, wherein the back execution recommendation notifying means is: Based on the calculated time required for the processing by the back execution means, the user is notified that it is determined whether or not to recommend the processing by the back execution means.

  According to the present invention, the user can be informed that processing by the back execution means is necessary.

  According to a sixth aspect of the present invention, in the information providing device according to any one of the first to fifth aspects, the processing instruction includes deadline information indicating a deadline designated by the user, When the processing command is received from the terminal device, the back execution means for each processing command is finished so that the processing by the back execution means is completed by the time limit based on the time limit information. Priority order determining means for determining the priority order of processing is further provided.

  According to the present invention, even when processing instructions are received from a plurality of terminal devices, the processing result can be obtained within a time limit according to the user's wish, and the terminal device is used for other purposes until the processing result is obtained. can do.

  According to a seventh aspect of the present invention, in the information providing apparatus according to the sixth aspect, when the processing by the back execution means is executed according to the priority of the processing determined by the priority order determination means, the processing is It further comprises date and time calculating means for calculating a completion date and time, and date and time notifying means for notifying the user of the calculated date and time.

  According to this invention, the user can know the date and time when the processing result is obtained, and knows the date and time when the back execution is completed even when the processing by the back execution means is not completed until the desired time limit. Can do.

  According to an eighth aspect of the present invention, in the information providing apparatus according to the seventh aspect, the date and time notifying unit notifies the user when the calculated date and time are not within the time limit corresponding thereto. It is characterized by that.

  According to this invention, the user can know the shortest date and time when the back item means is completed.

  The invention according to claim 9 is an information providing system comprising a terminal device and an information providing device to which the terminal device can be connected via a network, wherein the terminal device is a database requested by a user. Display means for displaying an input screen for inputting a processing instruction for processing registered information registered in the information processing apparatus, and transmission means for transmitting the processing instruction input through the input screen to the information providing apparatus. The information providing device includes: a processing command receiving unit that receives the processing command from a terminal device connected via the network; and a registration information processing that executes processing based on the processing command. And back execution means for continuously performing regardless of the network connection state of the information providing device, and processed by the back execution means based on the processing instruction The physical results, characterized by comprising, an information providing means for providing to the user regardless of the state of the connection network of the terminal device and the information providing apparatus.

  According to this invention, when the information providing apparatus receives a processing command for processing registration information registered in the database, for example, from the terminal device, the back execution means performs registration based on the processing command. Information processing is continuously performed regardless of the network connection state between the terminal device and the information providing device. The information providing apparatus can provide the processing result to the terminal apparatus regardless of the network connection state between the terminal apparatus and the information providing apparatus.

  Therefore, even when processing registration information having a large amount of data, it is not necessary to continue the session between the terminal device and the information providing device until the processing result is provided by the back execution means. The processing result can be obtained reliably without interruption of the processing due to the interruption of the network, and the terminal device can be used for other purposes until the processing result is obtained.

  According to a tenth aspect of the present invention, there is provided a processing command receiving step of receiving a processing command for processing registration information registered in a database, which is requested by a user, from a terminal device connected via a network. , A back execution step for continuously performing registration information processing for executing processing based on the processing command regardless of a network connection state of the terminal device and the information providing device, and the back execution step based on the processing command And an information providing step of providing the user with the processing result processed by step (a) regardless of a network connection state between the terminal device and the information providing device.

  According to the eleventh aspect of the present invention, a computer included in the information providing apparatus is a process for processing registration information registered in a database requested by a user from a terminal device connected via a network. A processing command receiving means for receiving a command, a back execution means for continuously performing registration information processing for executing processing based on the processing command regardless of a network connection state of the terminal device and the information providing device, and the processing The processing result processed by the back execution means based on a command is made to function as information providing means for providing to the user regardless of a network connection state between the terminal device and the information providing apparatus.

  According to the present invention, even when processing is performed on registration information having a large amount of data, it is necessary to continue the session between the terminal device and the information providing device until the processing result is provided by the back execution means. Therefore, the processing result can be obtained reliably without interruption of the processing due to network interruption or the like, and the terminal device can be used for other purposes until the processing result is obtained.

  Hereinafter, the best embodiment of the present invention will be described in detail with reference to the drawings. The embodiment described below is an embodiment when the present invention is applied to a data aggregation system.

[1. Data summary system configuration and function overview]
First, the configuration and functional overview of the data tabulation system S according to the present embodiment will be described with reference to FIGS. 1 and 2.

  FIG. 1 is a diagram illustrating an example of a schematic configuration of a data tabulation system S according to the present embodiment.

  As shown in FIG. 1, the data aggregation system S includes a Web server 1 as an example of an information providing device, a database server 2 including a database 2a, and a terminal device 3.

  The Web server 1 and the terminal device 3 can transmit and receive data to and from each other using, for example, TCP / IP (Transmission Control Protocol / Internet Protocol) as a communication protocol via the network NW. The network NW is constructed by, for example, the Internet, a dedicated communication line (for example, a CATV (Community Antenna Television) line), a mobile communication network (including a base station, etc.), a gateway, and the like. The Web server 1 and the database server 2 can transmit and receive data to and from each other via, for example, a LAN (Local Area Network).

  In the data tabulation system S having such a configuration, the Web server 1 is a server computer installed to provide data registered in the database 2a to the terminal device 3 through the network NW. More specifically, the Web server 1 first counts (processes) the registration information (data) registered in the database 2a in response to a request from the terminal device 3, that is, a processing command, or performs predetermined processing. The data conversion tool (eg, CSV (Comma Separated Value) format) is converted to a data format tool (such as CSV (Comma Separated Value) format) and functions as a data totaling tool that provides processing results to the terminal device 3. Yes. In order to function as such a data aggregation tool, the Web server 1 is installed with a Web server program (normal execution program) and a back execution processing program, which will be described later.

  The database server 2 is a server computer that manages the database 2a, and is realized by application of an RDBMS (relational database management system) such as MySQL. Specifically, the database server 2 performs processing such as new registration and update of registration information in the database 2a, information retrieval and output from the database 2a, in response to a request from the Web server 1 or a server computer (not shown). Is supposed to do.

  The database 2a includes, for example, data relating to various services such as Internet shopping, auctions, golf facility reservations, accommodation facility reservations, customer names, addresses, usage histories (for example, purchased products or services, purchase dates) , Purchase quantity, purchase price, etc.) regarding customer data, etc. are registered.

  The terminal device 3 is used by a user to access the Web server 1 and use a data totaling tool. For example, a personal computer, a PDA (Personal Digital Assistant) installed with a Web browser application, an e-mail application, or the like is used. ), STB (Set Top Box), mobile phone, and the like can be applied.

  Here, the outline functions of the Web server program and the back execution processing program among the programs installed in the Web server 1 will be described with reference to FIG. FIG. 2 is a block diagram illustrating a schematic example of a program configuration installed in the Web server 1 according to the present embodiment. In addition to the Web server program 1a and the back execution processing program 1b shown in FIG. 2, a session management program and the like are installed in the Web server 1, but illustration thereof is omitted.

  In FIG. 2, the Web server program 1a receives a processing command for processing registration information registered in the database 2a, which is requested by the user, from the terminal device 3 and executes the processing command. The processing result is displayed on the display screen, or the processing result is converted into a predetermined data format (for example, CSV format) and transmitted to the terminal device 3. On the other hand, the back execution processing program 1b continuously performs the aggregation conversion processing regardless of the connection state (session establishment state) between the terminal device 3 and the Web server 1 (hereinafter referred to as "back execution processing"). ) Program. Therefore, even if the terminal device 3 and the Web server 1 are not connected via the network NW, that is, even if the session between the terminal device 3 and the Web server 1 is disconnected after establishment, the total conversion process is performed. It has become.

  The user of the terminal device 3 can use the Web server program 1a and the back execution processing program 1b through the user interface. The user interface is realized, for example, by outputting (transmitting via the network NW) to the Web browser of the terminal device 3 as HTML data.

  Next, the outline of the back execution process will be described with reference to FIG.

  FIG. 3 is a sequence diagram illustrating an example of the outline of the back execution process.

  In FIG. 3, the user makes a login request (for example, including a user ID and a password) to the Web server 1 from the terminal device 3 (step S1). When receiving the login request, the Web server 1 performs an authentication process (step S2). When the authentication is permitted (for example, when the user ID and password included in the login request are registered), the terminal device 3 Is established via the network (step S3). That is, the session between the terminal device 3 and the Web server 1 is established.

  When the session is established, the Web server 1 transmits input screen data as a user interface to the terminal device 3 (step S4). Such an input screen is a user interface for inputting a processing command for processing registration information registered in the database 2a, and the processing command input by the user through this input screen is transmitted to the Web server 1. Become.

  As will be described in detail later, a button for executing the above-described back execution process is provided on the input screen, so that the user can request the back execution process. Yes.

  When the terminal device 3 makes a request for back execution processing together with the input processing command (step S5), the Web server 1 starts the back execution processing program 1b (step S6).

  As described above, the back execution processing program 1b is executed at the request of the user. Once the back execution processing program 1b is started, in other words, regardless of the connection state of the network NW between the terminal device 3 and the Web server 1. Even if the subsequent terminal device 3 and the Web server 1 are not connected via the network, the total conversion processing by the back execution processing program 1b is performed (steps S10 to S12), and a processing result is generated. Therefore, the user can make a logout request immediately after requesting the back execution process. Specifically, when a logout request is made from the terminal device 3 to the Web server 1 (Step S7), the Web server 1 performs logout processing and transmits a session end screen to the terminal device 3 (Step S8). Thereby, the connection between the terminal device 3 and the Web server 1 via the network NW is cut off, that is, the session between the terminal device 3 and the Web server 1 is cut off (step S9).

  On the other hand, when the back execution processing program 1b is activated, even if the session is blocked as described above, the Web server 1 also sends the received processing command if the back execution processing is requested. In addition, the back execution processing program 1b is continuously executed (step S10) (the back execution processing is thereby performed), and data converted into, for example, CSV format is generated (generated) for the processing result (step S11). . Then, the Web server 1 can access a screen for outputting the converted processing result as, for example, HTML data to the Web browser (for example, a URL (Uniform Resource Locator) of display data including the processing result). Is generated. Then, the link, the user ID, and the data file including the processing result are stored in association with each other so that the data file including the processing result can be accessed through the screen indicated by the link (Step S1). S12). Thereby, for example, when a link for downloading the data file is pasted on the screen, the associated desired file is provided to the terminal device 3.

  Thereafter, at the next access (login request), after user authentication is performed using the user ID, information related to the processing result, for example, the converted and saved data file can be accessed according to the user's request. The data of the screen on which the link is pasted is transmitted to the terminal device 3. Thereby, even if the session between the terminal device 3 and the Web server 1 is blocked due to blocking of the network NW or the like, the user can surely obtain a desired processing result by the aggregation conversion process (back execution process). .

  Alternatively, the Web server 1 transmits an e-mail in which the URL or the like specifying the link destination is described to the e-mail address of the user of the terminal device 3 after the processing is completed (send to a mail server (not shown)). If configured, the user can obtain the processing result quickly by receiving the e-mail with his / her mobile phone or the like and accessing the URL.

[2. Configuration and function of Web server]
Next, the configuration and function of the Web server 1 will be described with reference to FIG.

  FIG. 4 is a block diagram illustrating an example of a schematic configuration of the Web server 1 according to the present embodiment.

  As shown in FIG. 4, the Web server 1 includes an operation unit 11, a display unit 12 (for example, a liquid crystal display), a communication unit 13, a drive unit 14, a storage unit 15, and an input / output interface unit 16. And a system control unit 20. The system control unit 20 and the input / output interface unit 16 are connected via a system bus 21.

  The operation unit 11 is, for example, a keyboard, a mouse, and the like. The operation unit 11 receives an operation instruction from an operator or the like and outputs the instruction content to the system control unit 20 as an instruction signal. The display unit 12 is a liquid crystal display, for example, and displays information such as characters and images. The communication unit 13 is connected to the network NW or the like, and controls the communication state with the database server 2, the terminal device 3, and the like. For example, the drive unit 14 reads data from a disk DK such as a flexible disk, a CD (Compact Disc), a DVD (Digital Versatile Disc), and the like, and records data on the disk DK. The storage unit 15 is, for example, a hard disk drive or the like, and records various programs and data. The input / output interface unit 16 performs interface processing between the operation unit 11 to the storage unit 15 and the system control unit 20. The system control unit 20 includes a CPU (Central Processing Unit) 17, a ROM (Read Only Memory) 18, a RAM (Random Access Memory) 19, and the like.

  In addition to a predetermined operating system, the storage unit 15 stores the Web server program 1a and the back execution processing program 1b described above. These programs may be acquired from other server devices or the like via the network NW, for example, or may be recorded on a disk DK such as a CD-ROM and read via the drive unit 14. Anyway.

  Furthermore, a member information DB (Data Base) is constructed in the storage unit 15. In the member information DB, information on a user who has the authority to log in to the Web server 1 and use various programs (Web server program 1a, etc.), for example, user ID (identification data), password (Pass Word), e-mail address, etc. The user ID and password are used for the authentication process of the Web server 1 described above.

  In this embodiment, the system control unit 20 is a processing command receiving unit, a back execution unit, an information providing unit, a back execution recommendation notification unit, a back execution time calculation unit, a priority order determination unit, a date calculation unit, and a date notification in the present invention. An example of the means is configured.

  The system control unit 20 controls each unit of the Web server 1 by causing the CPU 17 to read and execute various programs (for example, the Web server program 1a and the like) stored in the ROM 18 and the storage unit 15, and each of the above-described units. It functions as a means.

  The function as each means will be described. The system control unit 20 as a processing command receiving means requests a processing command for processing registration information registered in the database 2a requested by the user, for example, the registration When there is a purchaser list of a product as information, an instruction and conditions for extracting a purchaser purchased within a certain period as the processing command are connected via the network NW (session establishment). It is received from the terminal device 3 (in the state). The processing command received in this way is stored in the RAM 19.

  Further, when the back execution process is requested from the terminal device 3 (with or after the processing instruction), the system control unit 20 as the back execution unit calls the back execution processing program 1b as described above, Execute. When the back execution processing program 1b is executed, the system control unit 20 performs the total conversion processing based on the processing command regardless of the connection state between the terminal device 3 and the network NW of the Web server 1. Yes.

  Specifically, the system control unit 20 retrieves and extracts the registered information registered in the database 2a as an example of aggregation based on the processing instruction input by the user, and converts the information into a predetermined data format. Perform the conversion process. For example, in the processing, registration information registered in the database 2a is extracted, data obtained by converting the extracted registration information into CSV format is created, and a link that can access the created data file is generated. The link and the data file including the processing result are stored in association with each other.

  In addition, the system control unit 20 as information providing means provides the user with the processing result of the total conversion process regardless of the connection state of the terminal device 3 and the network NW of the Web server 1. In other words, the processing result obtained by the aggregate conversion process (back execution process) that is continuously executed even after the session between the terminal device 3 and the Web server 1 is blocked due to the network NW being cut off, Provided.

  Specifically, for example, when the next session of the terminal device 3 is established, the system control unit 20 can access information on the processing result, for example, the stored data file itself or the stored data file. By transmitting the screen data with the link (URL) to the terminal device 3, the processing result is provided to the user. Alternatively, the system control unit 20 transmits an e-mail in which a link or the like that enables access to the stored data file or the like is transmitted to the e-mail address of the user of the terminal device 3, thereby obtaining the processing result. To the user.

  Further, if the system control unit 20 is configured to notify the user of the terminal device 3 that the back execution process is recommended in accordance with the processing command input by the user, the back execution recommendation notifying unit is more effective. Is. For example, the system control unit 20 determines whether or not to recommend the back execution process from the conditions included in the processing instruction, and recommends the back execution process to the user of the terminal device 3 when it is determined to recommend it. Notification (for example, notification by transmitting to the terminal device 3 holding the sensation). The determination as to whether or not to recommend the back execution process is based on, for example, the time required for the back execution process being calculated by the system control unit 20 as the back execution time calculating means, and based on the calculated time required for the back execution process. Done. For example, when the calculated time is equal to or greater than a certain threshold (for example, 20 minutes) (when the amount of data to be processed is long and takes a long time), it is determined to recommend the back execution process.

  Further, when the processing command includes time limit information indicating the time limit specified by the user (that is, when the time limit for completing the back execution process is specified by the user), the plurality of terminal devices 3 When it is necessary to perform the back execution process on the received processing instruction from the system controller 20, the system control unit 20 completes the back execution process by the time limit based on the time limit information as priority determination means. As described above, if the priority order of the back execution process for each processing instruction is determined and the back execution process is executed according to the priority order, a limited time can be used effectively, and thus more effective. Is. At this time, when the back execution process is executed according to the determined priority of the back execution process, the system control unit 20 calculates the date and time when the process is completed (scheduled completion date and time) as the date and time calculation means. It may be configured to notify the user of the scheduled completion date and time (for example, notification by transmitting to the terminal device 3 holding the sensation). For example, the system control unit 20 determines whether or not the calculated scheduled completion date and time is before the deadline designated by the user, and if it is before, the system control unit 20 determines that the deadline desired by the user is in time. If it is configured (if the calculated scheduled completion date / time is not within the time limit specified by the user), it is possible to improve convenience for the user by configuring the notification so that it is not in time. .

[3. Configuration and function of terminal device]
Next, the configuration and functions of the terminal device 3 will be described with reference to FIG.

  FIG. 5 is a block diagram illustrating an example of a schematic configuration of the terminal device 3 according to the present embodiment.

  As illustrated in FIG. 5, the terminal device 3 includes an operation unit 31, a display unit 32 (for example, a liquid crystal display), a communication unit 33, a drive unit 34, a storage unit 35, and an input / output interface unit 36. And a system control unit 40. The system control unit 40 and the input / output interface unit 36 are connected via a system bus 41.

  The operation unit 31 is, for example, a keyboard, a mouse, or the like, receives an operation instruction from an operator or the like, and outputs the instruction content to the system control unit 40 as an instruction signal. The display unit 32 is, for example, a liquid crystal display and displays information such as characters and images. The communication unit 33 is connected to the network NW or the like and controls the communication state with the Web server 1 and the database server 2 or the like. For example, the drive unit 34 reads data from a disk DK such as a flexible disk, a CD, or a DVD, and records data or the like on the disk DK. The storage unit 35 is, for example, a hard disk drive or the like, and records various programs and data. The input / output interface unit 36 performs interface processing between the operation unit 31 to the storage unit 35 and the system control unit 40. The system control unit 40 includes a CPU 37, a ROM 38, a RAM 39, and the like.

  In this embodiment, the system control unit 40 constitutes an example of a display unit and a transmission unit in the present invention.

  The system control unit 40 is configured such that the CPU 37 controls each unit of the various program terminal devices 3 stored in the ROM 38 or the storage unit 35 and functions as each unit described above. Specifically, the system control unit 40 accesses the Web server 1 through the communication unit 33 and the network NW, for example, by executing a Web browser program, and displays various screen data provided from the Web server 1 as a display unit 32 is displayed. As described above, the screen displayed in this way includes an input screen for inputting the processing command, and the system control unit 40 sends the processing command input by the user through the input screen to the Web server 1. It is supposed to send. Further, the system control unit 40 displays a screen including the processing result provided from the Web server 1 on the display unit 32.

  Here, an example of a screen displayed on the display unit 32 will be described with reference to FIGS.

  6 and 7 are diagrams illustrating examples of a data totaling tool screen as a user interface.

  The data tabulation tool screen 100a shown in FIGS. 6 and 7 is an example of the input screen described above, and there are tools and information for processing the registration information registered in the database 2a according to the user's request. For example, the name and authority display column 101 of the user who requested the login, the display switching display column 102, the campaign aggregation display column 103, the point grant amount extraction link 104, the search word display column 105, and the search word best 100 link. (106) and the back execution result file display field 107 are displayed.

  Here, the name and authority display column 101 of the user displays the name and authority of the user who made a login request to the Web server 1. In the Web server 1, ranks such as importance can be given to various functions that can be used (for example, types of information that can be aggregated). The user can use various functions within the permitted rank range. The authority indicates the rank that the user is permitted to use. The authority can be arbitrarily set by the administrator.

  Here, the manager is a person who comprehensively manages the data tabulation tool, can use all the functions of the tool, and can add or delete new functions.

  On the other hand, the user who uses the data totaling tool (in this embodiment, simply “user”) refers to a user who can use various functions of the data totaling tool managed by the administrator. The above-described back execution processing request can be requested.

  In addition to these, there are general users as those who are conceptualized. A general user refers to a customer who uses various services provided by the user, for example. Information about the user (for example, the user's address) and information about the service used by the user (for example, service usage history) Registered in the database 2a.

  The display switching display field 102 is used when switching the currently displayed screen to another screen. The campaign tabulation display column 103 and the search word display column 105 are an example showing categories in which data is tabulated from registration information registered in the database 2a. Information related to campaign tabulation and search words is registered in the database 2a.

  The point grant amount extraction link 104 and the search word best 100 link (106) are links for transitioning to a screen for inputting conditions for collecting data. The point grant amount extraction link 104 is obtained, for example, by registering an item requested by a user (a person who operates a certain service) on the administrator side. In this example, the user is requested to create a tool that aggregates the amount of money given campaign points (separated by a predetermined period), and the tool created by the administrator (as the reference destination, Tool created to refer to data and aggregate. The administrator prepares the items requested by the user who wants to calculate the totals (items that can be entered on the basis of the amount of money given the campaign points and the target period as conditions) in advance. It is possible to save the time and effort of receiving the request, etc., and even for the user who wants to perform the aggregation, it is possible to perform the aggregation by entering the condition (target period) by itself without telling the administrator of the condition every time. Can be efficient.

  The search word best 100 link (106) is a link for inputting a command for acquiring from the database 2a 100 search keywords used by general users for searching in the target service in descending order of the number of searches. As an example, the search word best 100 link (106) in Internet shopping, for example, counts the number of times searched on the Internet shopping site with reference to a DB for the Internet shopping site. The administrator prepares in advance the items requested by the user who wants to tabulate (in this case, the search word best 100 that refers to the DB for Internet shopping sites, specifies the target period and tabulates). , It is possible to save the time and effort of receiving the request of the condition etc. every time, and even for the user who wants to do the aggregation, it is possible to perform the aggregation by inputting the conditions themselves without telling the administrator every time. Can be efficient.

  In the back execution result file display field 107, a screen for displaying a processing result of the back execution processing, a link that can access a file, and the like are displayed. When there is no processing result by the back execution process, as shown in FIG. 6, a comment such as “No file” is displayed in the display field 108a. As shown in FIG. 7, the display field 108b displays a link to the data file containing the processing result. When a user requests processing of desired registration information from registration information registered in the database 2a, for example, a link such as a point grant amount extraction link 104 and a search word best 100 link (106) is connected to the operation unit 31, For example, the selection is made with a mouse or a keyboard.

  FIG. 8 is a diagram showing an example of a data totaling tool screen displayed when the search word best 100 link (106) shown in FIG. 6 is selected. FIG. 8 shows an example in which the user selects download in CSV format as the download format.

  The data tabulation tool screen 100c shown in FIG. 8 is also an example of the input screen described above, and displays actual input items for processing the registration information registered in the database 2a according to the user's request. For example, in the example of FIG. 8, the aggregation tool screen 100c includes a start date input field 110, an end date input field 111, a display number input field 112, a display button 113, a CSV format download format detailed setting field 114, a CSV download. A button 115, a back execution button 116, a time limit input field 117, and the like are displayed.

  The start date input field 110 and the end date input field 111 are items that are input in order to extract (process) information registered in a certain period from registered information registered in the database 2a. Using the terminal device 3, the user inputs the date and time for starting extraction (processing) in the start date input field 110 and the date and time indicating the end of the extraction (processing) target range in the end date input field 111. To do. The information specified in this way is included in the processing instruction and transmitted to the Web server 1. In this screen example, 2007-XX-X0 is specified in the start date input field 110 and 2007-XX-X9 is specified in the end date input field 111, so that the user can change from 2007-XX-X0 to 2007-. This indicates that registration information registered in the database 2a is requested during the period XX-X9.

  In the display number input column 112, for example, when displaying the processing result for the registration information requested by the user on the display unit 32, the number of cases to be displayed on one screen can be designated.

  The button 113 to be displayed is a button as an example of a GUI that can be selected by the user. When this button is selected, a registration process is executed and the result is displayed on the screen.

  In the CSV format download format detailed setting column 114, when the user designates CSV format download, details of the format, such as character code, delimiter, enclosing character, and line feed in data, can be set. .

  The CSV download button 115 is a button as an example of a GUI that can be selected by the user. When this button is selected, for example, a normal process for downloading a processing result in the format set in the CSV format download format detailed setting column 114 Is made to the Web server 1.

  The back execution button 116 is a button that is an example of a GUI that can be selected by the user. When this button is selected, for example, the totals of periods input in the start date input field 110, the end date input field 111, and the like are collected in the CSV format. A request for back execution processing for saving the processing result in the format set in the download format detailed setting field 114 is made to the Web server 1.

  In the time limit input field 117, the user can specify a time limit for obtaining the processing result of the back execution process. The deadline information indicating the deadline designated by the user is included in the designated information and transmitted to the Web server 1.

  FIG. 9 is a diagram showing an example of a data totaling tool screen displayed when the back execution button 116 shown in FIG. 8 is selected.

  In the data tabulation tool screen 100d shown in FIG. 9, a comment indicating that the back execution process is performed is displayed at the reference numeral 120. At this time, since the back execution process is performed, the user may disconnect the session with the Web server 1 by using the operation unit 31 of the terminal device 3 to close the data totaling tool screen 100d. become.

[4. Operation of data aggregation system]
Next, operation | movement of the data totaling system S is demonstrated using FIGS.

  FIG. 10 is a flowchart illustrating a processing example of the system control unit 20 in the Web server 1 according to the present embodiment.

  In FIG. 10, first, when a login request including information such as a user ID and a password transmitted from the terminal device 3 is received (step S20), the system control unit 20 performs an authentication process on the user who has made the login request. Is performed (step S21). As a result of the authentication process, when the authentication is permitted (for example, when the user ID and password included in the login request are registered), the system control unit 20 displays the above-described input screen (for example, in FIG. 8 described above). (Screen shown) is transmitted to the terminal device 3 (step S22).

  Then, the user inputs a processing command (for example, a start date and an end date to be searched, a provision time limit for the processing result, etc.) through the input screen, and for example, the back execution button 116 or CSV download shown in FIG. When the button 115 is designated by an operation with a mouse or the like, the processing instruction is transmitted to the Web server 1. When receiving the processing instruction (step S23), the system control unit 20 of the Web server 1 determines whether the back execution process is instructed in the processing instruction (step S24). When the reverse execution process is instructed (step S24: YES), the priority / expiration time determination process (step S25) is executed.

  FIG. 11 is a flowchart showing an example of priority / time limit determination processing (example of step S25 in FIG. 10) of the system control unit 20 in the Web server 1 according to the present embodiment.

  In the priority order / time limit determination process, as shown in FIG. 11, the system control unit 20 first checks whether there are a plurality of processing instructions scheduled for the back execution process (step S70). If there are no other processing commands for which the back execution process is scheduled (there is no plurality) (step S70: NO), it is sufficient to perform only the back execution process instructed by the user to step S26 in FIG. Processing shifts.

  On the other hand, when there are a plurality of processing instructions for which the back execution process is scheduled (step S70: YES), the system control unit 20 calculates the priority of the back execution process. That is, the system control unit 20 determines that the time limit for completing the back execution process is specified by the user in the plurality of processing instructions (for example, the date and time is input in the time limit input field 117 in FIG. Priority is given to the back execution process for each processing command so that the back execution process is completed by the time limit based on the time limit information indicating each time limit). The rank is calculated (step S71). In such calculation, the load on the Web server (CPU availability, etc.) is taken into account.

  Then, when the back execution process is performed based on the priority, it is determined whether the back execution process can be completed by the deadline (step S72). If it is determined that the back execution process is possible (step S72) (S72: YES), the process proceeds to step S26 of FIG.

  On the other hand, when it is determined that the back execution process is impossible (step S72: NO), the system control unit 20 indicates the scheduled completion date and time when the back execution process is performed based on the priority order. The completion date and time information is transmitted (notification of the scheduled completion date and time) to the terminal device 3 operated by the user (step S80). The terminal device 3 that has received the scheduled completion date and time information displays the scheduled completion date and time, for example, at an arbitrary location on the data tabulation tool screen 100c in FIG.

  When the user follows the scheduled completion date and time (for example, when the back execution button 116 in FIG. 8 is designated again with a mouse or the like), information to that effect is transmitted to the Web server 1 and the Web server 1 The system control unit 20 determines that the user follows the scheduled completion date and time (step S81: YES), and the process proceeds to step S26 in FIG. On the other hand, when the user does not follow the notified scheduled completion date and time (specifically, when a certain period of time elapses after the completion scheduled date and time is notified) (step S81: NO), the system control unit 20 returns to step S71, and again calculates the priority of the back execution process (step S71). In this case, for example, the back execution process corresponding to the user who does not follow the notified scheduled completion date / time is prioritized over the other back execution processes, and the new back execution process is performed in time for the deadline designated by the user. The priority is calculated, and the same processing as above is repeated. In addition, even if this process is repeated a predetermined number of times, if any user does not follow the scheduled completion date and time, for example, it is impossible for any user to complete the back execution process within the specified time limit. This is notified, and the process proceeds to step S26 in FIG.

  Returning to the description of the flowchart of FIG. 10, in step S26, the system control unit 20 starts the back execution processing program 1b (step S26), and starts the back execution processing. When the back execution process is thus started, the back execution process is continued even if the subsequent terminal device 3 and the Web server 1 are not connected via the network NW (FIG. 3: steps S10 to S12). For example, the system control unit 20 accesses the database server 2 and searches and extracts registration information within the period from the start date to the end date included in the processing instruction from the database 2a (step S27), and the extracted registration information Is converted into, for example, the CSV format, and a data file of the processing result is generated (step S28).

  Next, the system control unit 20 generates a link accessible to the generated processing result data file, and stores the link and the processing result data file in association with each other (step S29).

  Then, the system control unit 20 sends an e-mail in which information related to the processing result, for example, information indicating that the back execution process has been completed or a link for enabling access to the stored data file or the like is described, to the terminal device 3. Is transmitted to the user's e-mail address (step S30), and the process is terminated.

  On the other hand, if it is determined in step S24 that the reverse execution process is not instructed (step S24: NO), that is, if the reverse execution process is not requested by the user of the terminal device 3 that transmitted the processing instruction ( For example, when the CSV download button 115 shown in FIG. 8 is designated by an operation of a mouse or the like, the back execution recommendation process (step S40) is executed.

  FIG. 12 is a flowchart showing the recommended back execution process of the system control unit 20 in the Web server 1 according to the present embodiment.

  In the recommended process for back execution, as shown in FIG. 12, the system control unit 20 first determines whether the back execution process should be recommended (step S50). Specifically, when the condition included in the processing instruction, for example, the above-described total conversion process (normal execution process) within a certain period is requested, the certain period is equal to or greater than a certain threshold (for example, FIG. 8). If the period specified by the start date input field 111 and the end date input field 112 is 3 months or more), the registration information to be processed becomes enormous, and processing of the data may take time. Guessed. For this reason, since there is a possibility that the download may be interrupted due to a timeout, the back execution process should be recommended. In addition, the time required when the processing instruction is processed by the normal execution process is calculated, it is determined whether the download may be interrupted due to the timeout or the like, and it is determined whether the back execution process should be recommended. .

  When it is determined that the back execution process is not recommended (step S50: NO), the process proceeds to step S41 in FIG.

  On the other hand, when it is determined that the back execution process should be recommended (step S50: YES), back execution recommendation information indicating that the back execution process is recommended is transmitted to the terminal device 3 operated by the user (the back side). Notification of recommendation of execution processing) (step S51). The terminal device 3 that has received the back execution recommendation information displays a comment or the like that recommends the back execution process, for example, at an arbitrary location on the data tabulation tool screen 100c in FIG.

  Then, when the user receives the comment and selects (requests) the back execution process through the terminal device 3 (for example, when the back execution button 116 in FIG. Is transmitted to the Web server 1, and the system control unit 20 of the Web server 1 determines that the user has selected the back execution process (step S52: YES), and the process proceeds to step S26 in FIG. On the other hand, when the user does not select (request) the notified back execution process (specifically, when the timer operates and a certain time elapses after the back execution recommendation information is notified) ( Step S52: NO), the process proceeds to Step S41 in FIG.

  Returning to the description of the flowchart of FIG. 10, in step S41, the system control unit 20 starts the Web server program (normal execution program) 1a and starts normal execution processing. In this way, the normal execution process is started, and when the session between the terminal device 3 and the Web server 1 is interrupted thereafter, the normal execution process is ended.

  In the normal execution process, first, the system control unit 20 determines a process result output method designated by the user (step S42). The designation of the processing result output method is included in, for example, the received processing instruction. Then, when the processing result output method is “display” (for example, when the display button 113 shown in FIG. 8 is designated by the user), the process proceeds to step S43, and the processing result output method is “file output”. In some cases (for example, when the CSV download button 115 shown in FIG. 8 is designated by the user), the process proceeds to step S45.

  In step S43, the system control unit 20 accesses the database server 2, retrieves and extracts registration information within the period from the start date to the end date included in the processing instruction, and includes the extracted registration information. A page for displaying the processing result (for example, a data file related to a screen for outputting to a Web browser as HTML data) is generated. And the system control part 20 transmits the said page with respect to the terminal device 3 (browser) holding the session (step S44).

  On the other hand, in step S45, the system control unit 20 accesses the database server 2, searches and extracts from the database 2a registration information within the period from the start date to the end date included in the processing instruction, and extracts the extracted registration information. Is converted into, for example, the CSV format, and a data file of the processing result is generated. The system control unit 20 transmits the generated data file to the terminal device 3 (step S46). That is, the data file is downloaded to the terminal device 3.

  As described above, according to the present embodiment, when the Web server 1 receives a processing command for requesting processing such as search for registration information registered in the database 2a from the terminal device 3, the system control unit 20 Through the back execution process, the process for the registration information registered in the database 2a based on the process command is continuously performed regardless of the network connection state between the terminal device 3 and the Web server 1. Therefore, the Web server 1 can provide the processing result to the terminal device 3 regardless of the network connection state between the terminal device 3 and the Web server 1.

  Therefore, even when processing is performed on registration information having a large amount of data, it is not necessary to continue the session between the terminal device 3 and the Web server 1 until the processing result is provided by the back execution process. The processing result can be reliably obtained without interruption of the processing due to the interruption of the network or the like, and the terminal device 3 can be used for other purposes until the processing result is obtained.

  In addition, when there are a plurality of processing instructions for which the back execution process is scheduled, the system control unit 20 calculates the priority of the back execution process, so even when the processing instruction is received from a plurality of terminal devices 3. The processing result can be obtained at a time limit according to the user's request, and the terminal device 3 can be used for other purposes until the processing result is obtained.

  In the present embodiment, the total conversion process is performed as an example of the process executed by the Web server 1. However, the present invention is not limited to this, and any registration information process that processes registration information registered in the database 2a is applicable. be able to. Specifically, as the registered information processing, processing such as processing or correction of registered information can be applied in addition to the above-described total conversion processing.

It is a figure showing an example of the outline composition of data tabulation system S concerning this embodiment. It is a block diagram which shows the example of an outline | summary of the program structure installed in the Web server 1 which concerns on this embodiment. It is a sequence diagram which shows an example of the outline | summary of a back execution process. It is a block diagram which shows an example of schematic structure of the Web server 1 which concerns on this embodiment. It is a block diagram which shows an example of schematic structure of the terminal device 3 which concerns on this embodiment. It is a figure which shows the example of a data totalization tool screen as a user interface. It is a figure which shows the example of a data totalization tool screen as a user interface. It is a figure which shows the example of a data totaling tool screen displayed when the search word best 100 link (106) shown in FIG. 6 is selected. It is a figure which shows the example of a data totaling tool screen displayed when the back execution button 116 shown in FIG. 8 is selected. It is a flowchart which shows the process example of the system control part 20 in the Web server 1 which concerns on this embodiment. It is a flowchart which shows the example of a priority / time limit discrimination | determination process of the system control part 20 in the Web server 1 which concerns on this embodiment. It is a flowchart which shows the recommendation process of back execution of the system control part 20 in the Web server 1 which concerns on this embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Web server 2 Database server 2a Database 3 Terminal device 11, 31 Operation part 12, 32 Display part 13, 33 Communication part 14, 34 Drive part 15, 35 Storage part 16, 36 Input / output interface 17, 37 CPU
18, 38 ROM
19, 39 RAM
20, 40 System control part NW network S Data totaling system

Claims (11)

A processing command receiving means for receiving a processing command for processing registration information registered in a database, requested by a user, from a terminal device connected via a network;
Back execution means for continuously performing the registration information processing for executing the processing instruction regardless of the network connection state of the terminal device and the information providing device;
Information providing means for providing the user with the processing result processed by the back execution means based on the processing instruction regardless of the network connection state of the terminal device and the information providing apparatus;
An information providing apparatus comprising: In the information provision apparatus of Claim 1,
The processing command includes a request for back execution processing, and when the processing command receiving means receives a request command for back execution processing, the back execution means may be disconnected from the terminal device. Continue registration information processing,
An information providing apparatus characterized by that. In the information provision apparatus of Claim 2,
The back execution means generates a link that allows access to a processing result, stores the link, the user ID of the terminal device, and the processing result in association with each other, and after the connection with the terminal device is interrupted When there is access, after performing user authentication with the user ID, the screen data with the link attached is transmitted to the terminal device.
An information providing apparatus characterized by that. In the information provision apparatus of Claim 1,
The information providing apparatus further comprising a back execution recommendation notifying unit for notifying the user that the processing by the back execution unit is recommended according to the processing command input by the user. The information providing apparatus according to claim 4,
A back execution time calculating means for calculating a time required for the processing by the back execution means;
The back execution recommendation notifying unit determines whether or not to recommend the processing by the back execution unit based on the calculated time required for the processing by the back execution unit.
An information providing apparatus characterized by that. In the information provision apparatus as described in any one of Claims 1 thru | or 5,
The processing instruction includes time limit information indicating a time limit specified by the user,
When the processing instruction is received from a plurality of the terminal devices, by the back execution means for each processing instruction so that the processing by the back execution means is completed by the time limit based on the respective time limit information Priority order determining means for determining the priority order of the processing;
An information providing apparatus further comprising: In the information provision apparatus of Claim 6,
A date and time calculating means for calculating the date and time when the processing is completed when the processing by the back execution means is executed according to the priority of the processing determined by the priority order determining means;
A date and time notification means for notifying the user of the calculated date and time;
An information providing apparatus further comprising: In the information provision apparatus of Claim 7,
The date and time notifying means notifies the user when the calculated date and time is not within the time limit corresponding to the date and time.
A characteristic information providing apparatus. An information providing system comprising a terminal device and an information providing device to which the terminal device can be connected via a network,
The terminal device
Display means for displaying an input screen for inputting a processing instruction for processing registration information registered in a database, which is requested by a user;
A transmission means for transmitting a processing command input through the input screen to the information providing device;
With
The information providing apparatus includes:
A processing command receiving means for receiving the processing command from a terminal device connected via the network;
Back execution means for continuously performing registration information processing for executing processing based on the processing instruction regardless of a network connection state of the terminal device and the information providing device;
Information providing means for providing the user with the processing result processed by the back execution means based on the processing instruction regardless of the network connection state of the terminal device and the information providing apparatus;
An information providing system comprising: A processing command receiving step for receiving a processing command for processing registration information registered in a database, which is requested by a user, from a terminal device connected via a network;
A back execution step of continuously performing registration information processing for executing processing based on the processing instruction regardless of a network connection state of the terminal device and the information providing device;
An information providing step of providing the user with the processing result processed by the back execution step based on the processing instruction regardless of a network connection state of the terminal device and the information providing device;
An information providing method comprising: A computer included in the information providing device;
A processing command receiving means for receiving a processing command for processing registration information registered in a database, requested by a user, from a terminal device connected via a network;
Back execution means for continuously performing registration information processing for executing processing based on the processing instruction regardless of a network connection state of the terminal device and the information providing device;
Information providing means for providing the user with the processing result processed by the back execution means based on the processing command, regardless of the network connection state of the terminal device and the information providing apparatus;
An information processing program that functions as a computer program.

Images