JP2002358450A - Information providing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable a person in charge of sale to know when a quantity in stock reaches an ordered quantity without actively accessing a database in the case that the quantity in stock is less than the ordered quantity and to prevent back-order information from being left unprocessed for long time. SOLUTION: The person in charge of sale operates a terminal to send an order reception request to a Pull type system. The Pull type system obtains information on an article stock quantity, etc., and displays an inquiry for article stock quantity monitor request addition to a Push type system on the terminal if the article stock quantity is less than the order-reception quantity. The person in charge of sale inputs article stock monitor timing form the terminal and answers the inquiry. The Pull type system passes DB monitor information to the Push type system to make a request to monitor the article stock information. The Push type system monitors the article stock quantity in monitor timing complying with the request and gives notice to a delivery destination when distribution conditions are met.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information providing system. For example, in a system for processing a product order request, a terminal can register a product order from a terminal via a network, and the product has no stock. The present invention also relates to a technique for, for example, periodically checking a stock amount from a system side and notifying a person in charge of the result of the check, even when the system is in a circumstance.

[0002]

2. Description of the Related Art In a product inventory management operation, product inventory information is stored in a database, and a sales representative accesses the database based on an order request from a customer to check the inventory amount and register an order receipt. Inventory management systems are known. On the other hand, there is known a technology called a Push type system that periodically acquires information from a database and distributes the acquired information to a terminal via a network.

[0003]

In the conventional merchandise inventory management system, when an order is received from a customer and the stock of the corresponding merchandise is insufficient, the salesperson can confirm that the stock of the merchandise is received. In order to confirm whether the number of requests has been satisfied, it was necessary to actively access the database many times to check the arrival status of products. This was very cumbersome for the sales person. In addition, if the salesperson neglected to access and check the database, backorder information registered due to lack of stock sometimes remained without being processed forever.

The present invention has been made in view of the above-mentioned problems in the prior art, and when the stock amount does not satisfy the order request, the stock amount can be reduced even if the sales person does not actively access the database. It is an object of the present invention to provide an information providing system capable of not only knowing that the information has been satisfied, but also performing product inventory management that can prevent back order information from being left unprocessed forever.

[0005]

According to one aspect of the present invention, there is provided an information providing apparatus for receiving an information acquisition request from a terminal device via a network and providing information according to the information acquisition request. A system comprising: a first information providing unit; and a second information providing unit, wherein the first information providing unit receives an information acquisition request from the terminal device via the network. ,
Means for acquiring information corresponding to the received information acquisition request from the database, and means for transmitting the acquired information or information generated based on the acquired information to the terminal device via the network, A second information providing unit for holding information acquisition start information including an information acquisition start time, an information acquisition procedure, a provision destination of the acquired information, and a provision condition of the acquired information; When the time matches, start the information acquisition procedure to acquire predetermined information from the database,
Determine whether the obtained information satisfies the provision conditions,
Means for providing information to the providing destination when the condition is satisfied, a request for holding information acquisition start information to the second information providing means based on the information obtained by the first information providing means from the database. And a holding request unit for generating an information acquisition procedure based on the information acquisition request and making a request for holding the information acquisition activation information to the second information providing unit. I do.

According to a second aspect of the present invention, there is provided an information providing system for receiving an information acquisition request from a terminal device via a network and providing information in accordance with the information acquisition request. A second information providing unit, wherein the first information providing unit receives an information acquisition request from the terminal device via the network, and outputs information corresponding to the received information acquisition request from a database. Acquiring means, and means for transmitting the acquired information or information generated based on the acquired information to the terminal device via the network, wherein the second information providing means comprises an information acquisition procedure, Means for holding information acquisition start information including a provision destination of the acquired information and a provision condition of the acquired information; and Activating the acquisition procedure to acquire predetermined information from the database, determine whether the acquired information satisfies the provision condition, and, if so, provide information to the provision destination; and The first information providing means determines, based on the information acquired from the database, whether to make a request for holding the information acquisition activation information to the second information providing means, and performs an information acquisition procedure based on the information acquisition request. And holding request means for requesting the second information providing means to hold the information acquisition start information.

[0007] The invention according to claim 3 is the invention according to claim 1 or 2.
Wherein the second information providing means updates the database when providing the information to the providing destination.

According to a fourth aspect of the present invention, there is provided an information providing system for receiving an information processing request from a terminal device via a network and providing information relating to the information processing request.
A first information providing unit, and a second information providing unit, wherein the first information providing unit receives, via the network, an information processing request transmitted from the terminal device. Means for accessing a database and determining whether or not a process corresponding to the information processing request can be completed based on the access result; and, if the process can be completed, after completing the process, the terminal When information indicating that the processing is completed is transmitted to the apparatus, and when the processing cannot be completed, the information indicating that processing is completed, and whether or not the processing can be completed is monitored, and a state in which the processing can be completed is established. Inquiry about whether or not to notify when
Means for transmitting to the terminal device, and when the terminal device has instructed to perform monitoring and notification in response to the inquiry, generates monitoring information representing a monitoring request corresponding to the instruction, and generates the second information. Means for sending to the providing means, wherein the second information providing means stores the monitoring information sent from the first information providing means, and monitors the database based on the monitoring information. By doing
Means for monitoring whether or not the process corresponding to the information processing request can be completed, and when it is detected that the process has been completed by the monitoring, after completing the process, Means for transmitting information indicating that processing has been completed to the terminal device.

According to a fifth aspect of the present invention, there is provided an information providing system for receiving an information processing request from a terminal device via a network and providing information relating to the information processing request.
Means for receiving the information processing request transmitted from the terminal device via the network, and accessing a database, and determining whether or not processing according to the information processing request can be completed based on the access result Means to
If the processing can be completed, after the processing is completed, information indicating that the processing has been completed is transmitted to the terminal device. If the processing cannot be completed, information indicating that, and the processing is performed. Means for transmitting to the terminal device an inquiry as to whether or not to monitor whether or not the terminal device can be completed and to notify the terminal device when the status can be completed; and Means for generating and storing monitoring information indicating a monitoring request in accordance with the instruction when monitoring and notification are instructed; and monitoring the database based on the stored monitoring information to provide the information processing. Means for monitoring whether or not the process according to the request can be completed; and, when the monitoring detects that the process can be completed, after completing the process, Characterized by comprising a means for notifying the information indicating that processing to end device is completed.

The invention according to claim 6 is the invention according to claim 4 or 5.
In the information providing system according to the above, monitoring based on the monitoring information may be performed at a predetermined monitoring time timing or at a timing when the database is updated, in which the database can be accessed and processing according to the processing request can be completed. Or not.

According to a seventh aspect of the present invention, there is provided an information providing system for receiving an order request for a product from a terminal device via a network and providing information on a result of processing the order request. And a second information providing unit, wherein the first information providing unit receives the order request transmitted from the terminal device via the network, and indicates a stock status of the product. Means for accessing a database that holds and manages product inventory information and product order information indicating the order status of the product, and determines whether or not the inventory amount is equal to or greater than the order amount of the order request; and the inventory amount is equal to or greater than the order amount. In the case of, the order information related to the order request is registered in the database, the inventory amount of the database is reduced by the order amount, and the information indicating that the order processing is completed is Transmitting to the terminal device, when the inventory amount is not equal to or more than the order amount, a means of transmitting to the terminal device a notification of inventory shortage and a timing of monitoring the inventory amount, and the terminal device responds to the inquiry. Means for generating monitoring information indicating a monitoring request in accordance with the instruction and sending the information to the second information providing means, when the instruction to monitor the inventory amount and the timing of the monitoring are provided, An information providing unit configured to store the monitoring information sent from the first information providing unit, and read out an inventory amount of the database based on the monitoring information each time the monitoring timing comes; Means for monitoring whether or not the quantity is equal to or more than the order quantity, and means for transmitting information indicating that to the terminal device when the stock quantity is equal to or more than the order quantity. Do

[0012] The invention according to claim 8 is an information providing system for receiving an order request for a product from a terminal device via a network and providing information relating to a processing result of the order request. And a second information providing unit, wherein the first information providing unit receives the order request transmitted from the terminal device via the network, and indicates a stock status of the product. Means for accessing a database that holds and manages product inventory information and product order information indicating the order status of the product, and determines whether or not the inventory amount is equal to or greater than the order amount of the order request; and In the case of, the order information related to the order request is registered in the database, the inventory amount of the database is reduced by the order amount, and the information indicating that the order processing is completed is Transmitted to the end device, when the stock amount is less volume of orders or more, means for transmitting the inventory shortage report, the inquiry of whether or not to monitor inventory, to the terminal device,
Means for generating, when the terminal device has instructed to monitor the inventory amount in response to the inquiry, monitoring information indicating a monitoring request in accordance with the instruction, and transmitting the generated monitoring information to the second information providing means. The second information providing means includes means for storing the monitoring information sent from the first information providing means, and an inventory of the database each time the database is updated based on the monitoring information. Read the quantity,
Means for monitoring whether or not the stock amount is equal to or more than the order amount, and means for transmitting information indicating the fact to the terminal device when the stock amount is equal to or more than the order amount. And

[0013] The invention according to claim 9 is the invention according to claim 7 or 8.
In the information providing system described in (1), when the first information providing means detects that the stock amount is not more than the order quantity, the order information is stored in the database as back order information, and the second information providing means is provided. And detecting that the backorder information corresponding to the order information is deleted when it is detected that the stock amount has exceeded the order amount.

According to a tenth aspect of the present invention, there is provided an information providing system for receiving a lending request for an article from a terminal device via a network and providing the lending information of the article, comprising: a first information providing means; And the first information providing means receives a lending request transmitted from the terminal device via the network, and determines whether or not the article is being lent. Means for accessing a database that holds and manages the rental information indicating that the item related to the rental request is being lent, and information indicating that the item is not being lent, if the item is not being lent, to the terminal device. Means for transmitting to the terminal device an inquiry to the effect that the article is being rented and a timing for monitoring the lending status. When the terminal device has instructed the monitoring of the lending status and the timing of monitoring in response to the inquiry, the terminal device generates monitoring information indicating a monitoring request according to the instruction and sends the monitoring information to the second information providing unit. Sending means, wherein the second information providing means includes means for storing the monitoring information sent from the first information providing means, and based on the monitoring information, Means for reading out the lending status of the database and monitoring whether or not the article relating to the lending request is being lent, and, when the article is no longer being lent, transmitting information indicating the fact to the terminal device. And means for performing the operation.

[0015] An invention according to claim 11 is an information providing system for receiving a lending request for an article from a terminal device via a network and providing the lending information of the article, comprising: a first information providing means; And the first information providing means receives a lending request transmitted from the terminal device via the network, and determines whether or not the article is being lent. Means for accessing a database that holds and manages the rental information indicating that the item related to the rental request is being lent, and information indicating that the item is not being lent, if the item is not being lent, to the terminal device. If the article is being rented, means to that effect and an inquiry as to whether to monitor the lending status to the terminal device, Means for generating, when the terminal device instructs to monitor the lending status in response to the inquiry, a monitoring information indicating a monitoring request corresponding to the instruction, and transmitting the monitoring information to the second information providing means. The second information providing means includes means for storing the monitoring information sent from the first information providing means, and lending the database every time the database is updated based on the monitoring information. Means for reading the status and monitoring whether or not the article according to the lending request is being lent, and means for transmitting information indicating the fact to the terminal device when the article is no longer being lent. It is characterized by having.

A twelfth aspect of the present invention is an information providing system for receiving a facility use request from a terminal device via a network and providing the facility use information.
And a second information providing unit, wherein the first information providing unit sends a use request including a desired facility and a desired period transmitted from the terminal device to the network. Means for receiving, and means for accessing a database for holding and managing use reservation information of facilities, and for determining whether or not a use reservation overlapping the desired use period has already been made for the desired use facility, If there is no use reservation that overlaps the desired use period, information indicating that fact is transmitted to the terminal device, and if there is a use reservation that overlaps the desired use period, the fact and the use reservation status are monitored. Means for transmitting a timing inquiry to the terminal device, and the terminal device instructing the use inquiry status to be monitored and the monitoring timing in response to the inquiry. When, and means for sending to generate monitoring information representative of a monitoring request according to the instruction to the second information providing unit, the second information providing unit, wherein the first
Means for storing the monitoring information sent from the information providing means, and, based on the monitoring information, a use reservation status of the database is read out each time the monitoring timing comes, and Means for monitoring whether or not there is still a use reservation overlapping the period, and means for transmitting information indicating that to the terminal device when there is no use reservation overlapping the desired use period for the desired use facility. It is characterized by having.

According to a thirteenth aspect of the present invention, there is provided an information providing system for receiving a facility use request from a terminal device via a network and providing the facility use information.
And a second information providing unit, wherein the first information providing unit sends a use request including a desired facility and a desired period transmitted from the terminal device to the network. Means for receiving, and means for accessing a database for holding and managing use reservation information of facilities, and for determining whether or not a use reservation overlapping the desired use period has already been made for the desired use facility, If there is no use reservation that overlaps the desired use period, information indicating that fact is transmitted to the terminal device, and if there is a use reservation that overlaps the desired use period, the fact and the use reservation status are monitored. Means for transmitting an inquiry as to whether or not to the terminal device, and when the terminal device has instructed to monitor the use reservation status in response to the inquiry, monitoring according to the instruction To generate monitoring information representative of the determined and means for sending the second information providing unit, the second
Means for storing the monitoring information sent from the first information providing means, and reads the usage reservation status of the database each time the database is updated based on the monitoring information Means for monitoring whether there is still a use reservation overlapping the desired use period for the desired use facility, and when there is no use reservation overlapping the desired use period for the desired use facility,
Means for transmitting information indicating the fact to the terminal device.

[0018]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a diagram showing a system configuration of a commodity inventory management system according to an embodiment of the present invention. Via the network 104, the Pull type system 102, P
The ush type system 103 and the terminal 105 are mutually connected. Pull type system 102 and Pu
The database 101 is connected to the sh-type system 103. The pull-type system 102 is a system that acquires information such as the stock amount of merchandise from the database 101 based on an order request obtained from a terminal 105 operated by a sales representative 106 and displays the information on the terminal 105. The Push type system 103 periodically monitors the database 101, and stores information such as, for example, the stock amount of the product for which the order is currently being placed, on the terminal 105 held by the salesperson 106.
It is a system to deliver to. The terminal 105 is, for example, a mobile terminal or a personal computer operated by the sales representative 106.

Further, the Pull type system 102 determines whether or not the stock quantity is smaller than the order quantity, based on the order request from the sales person 106 and the information acquired from the database 101. The sales representative 106 inquires of the sales representative 106 whether or not to monitor the product inventory amount of the product. If the sales representative instructs the monitoring, the Push-type system 1
03 is requested to monitor the product inventory amount.

FIG. 2 is a diagram showing a detailed internal configuration of the database 101. The database 101 includes a product inventory information list 201 indicating the stock status of each product, an order information list 202 indicating information on the order received from the customer, and a customer out of the information stored in the order information list 202, which is provided to the customer due to lack of inventory. And information necessary for product management, such as a backorder information list 203 indicating order information indicating that the product delivery has been attempted.

The product inventory information list 201 includes a “product code” that is an identifier for uniquely specifying a product type, for example, a “product name” such as an ink ribbon, an office desk, and a chair, and a “product name” indicating the stock amount of the product. It is composed of information of "stock quantity". As the information on the product, information such as the color and size of the product may be added in addition to the above information to manage more detailed product information. Further, in order to avoid redundant holding of product information and inventory information in the database 101, it is also possible to normalize the information in the database 101 and manage it with a more optimal configuration.

The order information list 202 shows "order code" which is information for uniquely specifying each order, "customer code" which is information for specifying the customer of the order, and the date on which the order was received. It is composed of information such as "order date", "product code" which is information for specifying the order target product, and "quantity" indicating the number of orders. Order Information List 20
In addition to the information described above, for example, information for identifying a person who received the order or information such as the desired delivery date of the customer may be added to manage more detailed information on the order. .

The back order information list 203 includes an “order code” for specifying order information in which a back order has occurred, whether or not delivery to the customer has been completed, and when delivery has been completed, when delivery to the customer has been completed. It consists of information such as “resolution date” for determining whether or not it has been done. To the back order information list 203, in addition to the above-described information, for example, information such as the date and time of completion of the delivery can be added to manage more detailed information.

FIG. 3 shows an example of an order request screen 301 in which the sales person 106 inputs information on an order from the terminal 105 in order to make an order request to the pull type system 102. The order request screen 301 includes screen elements for inputting detailed information of an order request such as an order date 302, an order source customer code 303, a product code 304, a product name 305, and a quantity 306. The information input by the salesperson 106 is sent from the terminal 105 to the pull-type system 102 by pressing the send button 307. Items to be input on the order request screen 301 may be added or changed in accordance with information constituting the order information list 202. In order to enable easier input, for example, a function of searching for a product code based on a product name may be added.

FIG. 4 shows that the pull-type system 102 stores the database 1 based on an order request from the salesperson 106.
13 is an example of a screen displaying the result of acquiring the product stock amount from the terminal No. 01 on the terminal 105.

If the stock of the order target product is sufficient, P
The UL type system 102 displays an order acceptance completion screen 40.
1 is displayed on the terminal 105 possessed by the sales representative 106,
Notifies completion of order acceptance. At the same time, information on the ordered product is added to the order information list 202. Further, the stock amount of the corresponding product in the product stock information list 201 is reduced and updated for the order.

If the stock of the ordered product is insufficient,
Pull-type system 102 is used to notify inventory shortage / Push
A registration inquiry screen 402 is displayed on the terminal 105 possessed by the sales representative 106 to notify that the inventory of the order target product is currently insufficient. At the same time, the Pull type system 102 adds information on the ordered product to the order information list 202 and the back order information list 203.

An inventory shortage notification / Push registration inquiry screen 402 has an input area 403 for monitoring timing and a button 40 for selecting whether or not to perform regular monitoring.
4, 405. The monitoring timing is Pus
This is the timing at which the h-type system 103 accesses the database 101 and checks the stock amount of the corresponding product.
As the monitoring timing 403, in addition to the input of the time, for example, a time interval for monitoring may be input. Furthermore, more complicated control may be performed by inputting information such as a monitoring deadline (a deadline for how long monitoring will be performed).

FIG. 5 is a configuration diagram of the DB monitoring information 501 stored and executed in the Push type system 103.
The DB monitoring information 501 includes Pu and a product inventory monitoring request.
It is passed from the ll type system 102 to the Push type system 103. The DB monitoring information 501 includes a distribution destination 502 that stores the destination of the sales representative 106, a monitoring time 503 that stores time information for accessing the database 101 and executing acquisition of the product inventory amount, and a monitoring time 503 for acquiring the product inventory amount. DB
Distribution condition 50 for determining whether or not to distribute the execution result of access expression 504 and DB access expression 504 to distribution destination 502
5 and an order code 506 for specifying the corresponding order information.

FIG. 6 shows an example of the DB access formula 504. The DB access formula is a formula used to acquire the product stock amount. The formula shown in FIG.
3 shows an example of acquiring the commodity stock amount. DB access formula 5
04, for example, the ANSI standard (ANS X3.
135-1986 information system
ems-database language SQ
L) or the like may be applied.

FIG. 7 shows an example of the stock notification 701. The inventory notification 701 indicates that when the Push type system 103 executes the DB access expression 504 of the DB monitoring information 501 and the execution result satisfies the distribution condition 505, the sales person 106 specified by the distribution destination 502 from the Push type system 103.
Is transmitted to the terminal 105 and displayed.

FIG. 8 is a time chart showing an example of the processing flow in the system of FIG.

The sales representative 106 operates the terminal 105 to input an order request screen 301 (FIG. 3), and issues an order request to the pull-type system 102 via the network 104 (process 801).

The pull type system 102 adds the order information to the order information list 202 in the database 101 based on the order request from the sales person 106, and enters the order target product from the “stock amount” column of the product inventory information list 201. (Steps 802 and 803). The pull type system 102 sets the quantity 3
The value of 06 is compared with the stock amount of the order target product obtained in the processing 802 and 803. If the stock amount is less than the value entered in the quantity 306, the order code is added to the back order information list 203 of the database 101 (step 8).
04), a shortage notification / Push registration inquiry screen 402 on the terminal 105 operated by the sales representative 106 (FIG. 4)
Is displayed (process 805).

The sales person 106 notifies the stock shortage notification / Pu
By inputting the monitoring timing 403 on the sh registration inquiry screen 402 and selecting "Yes" on the button 404, a request is made to the pull type system 102 for monitoring the stock amount (process 806).

The pull type system 102 generates the DB monitoring information 501 (FIG. 5) in response to the inventory amount monitoring request. In other words, the terminal 105 of the salesperson 106 is set as the distribution destination 502, and the monitoring timing 40 input to the stock shortage notification / Push registration inquiry screen 402 in the processing 806.
3 is the monitoring time 503, and the access formula generated from the information input to the order request screen 301 is the DB access formula 50.
4, the value input to the quantity 306 of the order request screen 301 is set as the distribution condition 505, and the order information list 2
02, the data stored in the “order code” column of the order information added to the DB monitoring information 50
1 is generated. Further, the Pull type system 102
Push generated system monitoring information 501 to Push type system 10
3 and requests monitoring of the stock amount of the product (process 80).
7).

When the Push type system 103 receives a request for monitoring the stock amount of goods from the Pull type system 102,
Storing the DB monitoring information 501 in its own system (processing 80
8). The Push type system 103 executes the DB access formula 504 when the current time has passed the time stored in the monitoring time 503, and acquires the stock amount of the corresponding product from the product stock information list 201 of the database 101 (processing 80).
9, processing 810). The Push type system 103 compares the acquired inventory amount with the distribution condition 505, and when the inventory amount satisfies the distribution condition 505 (order amount), the database 1
01, and updates the “resolution date” column of the backorder information list 203 for the corresponding product. at the same time,
The “stock amount” column of the product stock information list 201 is updated by reducing it by the number of orders (process 811). Further, the Push type system 103 transmits a stock notification 701 to the terminal 105 of the salesperson 106 registered in the distribution destination 502 (process 812).

FIG. 9 is a detailed configuration diagram of the pull type system 102. The pull-type system 102 includes a DB access unit 901, an execution control unit 902, and a user interface 903. DB access unit 90
1 accesses the database 101, refers to the product inventory information list 201, updates the inventory amount, and receives the order information list 202
Information and backorder information list 203
The user performs operations such as reference, addition, and update of each information in the database 101, such as addition of information to the database 101. The execution control unit 902 uses the DB access unit 9 based on the order information from the salesperson 106 obtained via the user interface 903.
01, a display request to the user interface 903 based on the DB access result,
The monitoring information is registered in the sh-type system 103. The user interface 903 displays, on the terminal 105 of the salesperson 106, an order request screen 301, a stock notification 701, an order acceptance completion screen 401, and a stock shortage notification / Push registration inquiry screen 402. Further, it receives input information from the sales representative 106.

FIG. 10 is a detailed block diagram of the Push type system 103. Push-type system 103 includes scheduler registration unit 1001, scheduler 1002, DB
Access execution control unit 1003, DB access execution unit 10
04, and a mail distribution unit 1005. The scheduler registration unit 1001 registers the DB monitoring information 501 with the scheduler 1002. Scheduler 1
002 stores the DB monitoring information 501 and requests the DB access execution control unit 1003 to execute monitoring related to the DB monitoring information 501 based on the current time. The DB access execution control unit 1003 sets the D
Based on the B monitoring information 501, an execution request to the DB access execution unit 1004 and a mail distribution request to the mail distribution unit 1005 are made.

The DB access execution unit 1004 accesses the database 101 based on the DB access formula 504 of the DB monitoring information 501, and obtains information such as, for example, the stock amount of a product. The mail distribution unit 1005 stores the DB monitoring information 50
The mail is distributed to the terminal 105 possessed by the sales representative 106 based on the first distribution destination 502.

FIG. 11 is a detailed block diagram of the scheduler 1002. The scheduler 1002 includes a DB monitoring information list 1101 and a DB monitoring information execution control unit 110
2 In the DB monitoring information list 1101,
DB monitoring information 5 registered by the scheduler registration unit 1001
01 is stored. DB monitoring information execution control unit 1102
Monitors the time, obtains the DB monitoring information 501 to be started at the current time, and notifies the DB access execution control unit 1003 of the D
Issue a B access execution request.

FIG. 12 is a time chart shown in FIG.
10 is a detailed time chart focusing on the operation of each component of the pull-type system 102 shown in FIG. 9.

The sales person 106 operates the terminal 105 to input an order request screen 301 and issues an order request to the pull-type system 102 via the network 104. Order request is for Pull type system 10
2 of the user interface 903 (processing 12
01). The user interface 903 transfers the information input to the order request screen 301 to the execution control unit 902, and notifies the execution request from the sales representative 106 (Process 1).
202).

The execution control unit 902 includes the DB access unit 90
1 requests the registration of the order information and the acquisition of the stock amount of the order target product (process 1203). DB access unit 90
1 accesses the database 101, registers the order information in the order information list 202, and obtains the inventory amount of the order target product with reference to the product inventory information list 201 (process 1204, process 1205). Further, the DB access unit 901 executes the execution control unit 902 with the stock amount of the order target product.
(Processing 1206).

The execution control unit 902 calculates the order information quantity 30
The value of No. 6 is compared with the stock amount of the corresponding product in the product stock information list 201. When the stock amount is less than the value of the quantity 306, the request for adding back order information is made to the DB access unit 901 (step 1207). The DB access unit 901 adds back order information related to the order to the back order information list 203 of the database 101 (processing 1208).

The execution control unit 902 requests the user interface 903 to display the stock shortage notification / Push registration inquiry screen 402 (process 1209). The user interface 903 is the terminal 1 of the salesperson 106
05, Insufficient inventory notification / Push registration inquiry screen 4
02 is displayed (step 1210).

The salesperson 106 is notified of the stock shortage / Pu
Monitoring timing 403 of sh registration inquiry screen 402
Enter the monitoring time and press the button 404 to
h registration is requested (process 1211). The user interface 903 notifies the execution control unit 902 of the Push registration request (process 1212). Execution control unit 902
Generates the DB monitoring information 501 and makes a Push registration request to the Push type system 103 (processing 121).
3). At this time, the generated DB monitoring information 501 is also passed.

FIG. 13 is a time chart shown in FIG.
11 is a detailed time chart focusing on the operation of each configuration request of the Push type system 103 shown in FIG.

A push registration request from the pull type system 102 to the push type system 103 is received by the scheduler registration unit 1001 (process 1301). The scheduler registration unit 1001 stores the DB monitoring information 501 received together with the Push registration request in the scheduler 1002 (Step 1302). The scheduler 1002 compares the current time with the monitoring time 503 in the DB monitoring information 501. If the current time has reached the monitoring time 503, the DB monitoring information 501 is stored in the DB access execution control unit 1003.
To request execution of DB access (process 130
3). The DB access execution control unit 1003 passes the DB monitoring information 501 to the DB access execution unit 1004,
It requests access execution (process 1304).

The DB access execution unit 1004 uses the DB access formula 504 in the DB monitoring information 501 to acquire the stock quantity of ordered products from the product stock information list 201 of the database 101 (processing 1305, 1306), and The execution control unit 1003 is notified (step 1307).

The DB access execution control unit 1003
The distribution condition 505 in the monitoring information 501 is compared with the stock amount obtained in the process 1307, and when the distribution condition 505 is satisfied,
A DB update request is issued to the DB access execution unit 1004 (process 1308). Further, a distribution request of the stock notification 701 is made to the mail distribution unit 1005 (processing 131).
0). Upon receiving the DB update request, the DB access execution unit 1
004 accesses the database 101 and updates the “resolution date” column for the corresponding information in the backorder information list 203. At the same time, the corresponding “stock amount” column is updated by reducing the number of received orders (process 1309). Also, the mail distribution unit 1005 includes the DB access execution control unit 100
When the distribution request is received from the distribution destination 502 (processing 1310), the stock notification 701 is distributed to the terminal 105 stored in the distribution destination 502 (processing 1311).

As described above, in the processing 1213 of FIG. 12, the execution control unit 902 of the pull type system 102
Passes the DB monitoring information 501 to the sh type system 103 and
Make a ush registration request. At this time, the DB monitoring information 501
It is necessary to generate the inside DB access expression 504. FIG.
4 is a flowchart illustrating a flow of processing in which the execution control unit 902 generates a DB access expression 504 in the DB monitoring information 501 based on information input to the order request screen 301.

The execution control unit 902 acquires the product code value of the product to be ordered (step 1401). Next, the execution control unit 902 stores the character string “SE” in the DB access expression storage variable.
LECT stock quantity FROM merchandise stock "is stored (step 1402). Then, the character string" WHERE merchandise code = "is added to the DB access expression storage variable (step 1402).
3) Add a single quote character (Process 1)
404), add the product code value acquired in the process 1401 (process 1405), and further add a single quote character (process 1406). As described above, a DB access expression as shown in FIG. 6 is generated.

FIG. 15 is a flowchart showing the flow of the processing performed by the execution control unit 902 when the execution control unit 902 of the pull-type system 102 receives the product inventory amount as the access result in the processing 1206 of FIG. It is.

The execution control unit 902 receives the order request screen 301
Is compared with the value of the quantity 306 obtained from the database access unit 901 in step 1206 (step 150
1). When the value of the quantity 306 is equal to or less than the product stock amount, the execution control unit 902 requests the DB access unit 901 to perform processing,
The order quantity is reduced from the stock quantity of the corresponding product stored in the product stock information list 201 in the database 101 (process 1502). Subsequently, the execution control unit 902 requests the user interface 903 to display the order reception completion screen 401, and causes the terminal 105 to display the screen (processing 1).
503).

When the value of the quantity 306 is larger than the stock quantity, the execution control unit 902 issues a back order information addition request (process 1207) to the DB access unit 901 and adds information to the back order information list 203 in the database 101. (Process 1504). Subsequently, the execution control unit 902 issues a display request for the stock shortage notification / Push registration inquiry screen 402 (process 1209) to the user interface 903, and causes the terminal 105 to display the screen (process 1505).

FIG. 16 is a flowchart showing the flow of processing performed by the DB access execution control unit 1003 based on the product stock amount obtained in the processing 1307 of FIG.

The DB access execution control unit 1003 compares the product stock amount obtained in the processing 1307 with the requested order quantity stored in the distribution condition 505 (processing 1601). If the merchandise inventory is smaller than the requested order quantity, the process ends. If the product inventory is equal to or greater than the requested quantity, D
The B access execution control unit 1003 issues a DB update request (process 1308) to the DB access execution unit 1004, and returns the backorder information list 20 for the corresponding product.
Update of “Resolution date” column of No. 3 and product inventory information list 201
Is updated (step 1602).
The DB access execution control unit 1003
Distribution request for the stock notification 701 (processing 131
0), and the distribution of the inventory notification 701 to the terminal 105 of the sales representative 106 is performed (step 1603).

FIG. 17 shows the DB in the scheduler 1002.
The monitoring information execution control unit 1102 sets the DB according to the current time.
14 is a flowchart showing a flow of processing from obtaining monitoring information 501 to performing processing 1303 in FIG.

The DB monitoring information execution control unit 1102 acquires the current time (step 1701). The DB monitoring information execution control unit 1102 acquires the monitoring time 503 held by the DB monitoring information 501 stored in the DB monitoring information list 1101 (Step 1703). DB monitoring information execution control unit 11
In step 02, the current time is compared with the time stored in the monitoring time 503 to check whether or not the current time is after the time stored in the monitoring time 503 (processing 1704). If the current time is after the time stored in the monitoring time 503, the DB
The monitoring information execution control unit 1102 stores the DB monitoring information 50
1 is passed to the DB access execution control unit 1003 to request execution of the DB access (step 1705). The DB monitoring information execution control unit 1102 performs processing 1703, processing 1704,
And the processing 1705 are executed for all the DB monitoring information 501 stored in the DB monitoring information list 1101 (processing 1702, processing 1706).

In the above-described embodiment, as shown in FIG. 4, the monitoring timing is designated, and when the timing is reached, the database is accessed to monitor the information. Instead of specifying the monitoring timing, the database may be accessed to monitor information when the database is updated. Further, in the flowchart of FIG. 16, the monitoring result is reported when the stock amount exceeds the order amount. However, even if the stock amount does not exceed the order amount, the fact is reported. Good.

Further, in the above-described embodiment, an example in which the present invention is applied to the order receiving process of a product has been described. However, the present invention relates to a rental business of books and rental videos of a library and a reservation business of accommodation facilities and the like. It is also possible to apply to.

[0064]

As described above, according to the present invention,
Even if the user does not actively make inquiries repeatedly to the information acquisition request from the user's terminal device, predetermined information can be notified from the system side. Therefore,
For example, if applied to an order management system, if there is a shortage of inventory while there is an order request from a sales representative,
By registering DB monitoring information in the Push type system,
The sales person can be notified when the stock amount satisfies the order request without actively inquiring about the stock amount. Further, if the present invention is applied to a rental operation of books and rental videos of a library and a reservation operation of an accommodation facility, a user can receive a notification without repeatedly inquiring about the rental status or the reservation status from the user side.

[Brief description of the drawings]

FIG. 1 is a diagram showing a system configuration according to an embodiment of the present invention;

FIG. 2 is a diagram showing a detailed internal configuration of a database.

FIG. 3 is a diagram showing an example of an order request screen.

FIG. 4 is a diagram showing an example of a screen displaying a result of acquiring a product inventory amount on a terminal;

FIG. 5 is a configuration diagram of DB monitoring information;

FIG. 6 is a diagram showing an example of a DB access expression.

FIG. 7 is a diagram showing an example of a stock notification.

FIG. 8 is a time chart showing a processing flow in the embodiment of the present invention.

FIG. 9 shows the Pull type system in detail.

FIG. 10 shows a Push type system in detail.

FIG. 11 is a diagram showing a scheduler in detail.

FIG. 12 is a flow chart of processing according to the embodiment of the present invention;
Time chart diagram refined according to the configuration of the UL type system

FIG. 13 is a flow chart of a process according to the embodiment of the present invention;
Time chart diagram refined according to the configuration of the ush type system

FIG. 14 is a flowchart illustrating a flow of a process of generating a DB access expression.

FIG. 15 is a flowchart illustrating the flow of a process performed by an execution control unit when a product inventory amount is received;

FIG. 16 is a flowchart showing the flow of processing performed by a DB access execution control unit;

FIG. 17 shows a case where the scheduler sets D to the DB access execution control unit.
Flow chart showing the flow of processing until issuing a B access execution request

[Explanation of symbols]

101: database, 102: Pull type system,
103: Push type system, 104: Network,
Reference numeral 105: terminal, 106: sales representative, 201: product stock information list, 202: order information list, 203: back order information list, 301: order request screen, 302: order date, 303: customer code of order source, 304 ... Product code,
305: Product name, 306: Quantity, 401: Order acceptance completion screen, 402: Inventory notification / Push registration inquiry screen, 403: Monitoring timing, 501: DB monitoring information, 502: Delivery destination, 503: Monitoring time, 504: DB
Access formula, 505: delivery condition, 506: order code,
701: stock notification, 901: DB access unit, 902 ...
Execution control unit, 903: user interface, 1001
... Scheduler registration unit, 1002 ... Scheduler, 10
03 ... DB access execution control unit, 1004 ... DB access execution unit, 1005 ... mail distribution unit.

 ────────────────────────────────────────────────── ─── Continued on the front page (72) Inventor Hitoshi Fukuoka 2-16-10 Honcho, Aoba-ku, Sendai-shi, Miyagi Daido Life Building Hitachi Tohoku Software Co., Ltd. F term (reference) 5B075 KK07 KK35 ND20 PQ05 UU40

Claims (13)

[Claims] 1. An information providing system for receiving an information acquisition request from a terminal device via a network and providing information according to the information acquisition request, comprising: a first information providing unit; and a second information providing unit. The first information providing means includes: means for receiving an information acquisition request from the terminal device via the network; means for acquiring information corresponding to the received information acquisition request from a database; Means for transmitting the obtained information or information generated based on the obtained information to the terminal device via the network, wherein the second information providing means comprises: an information acquisition start time; an information acquisition procedure; Means for holding information acquisition start information including a provision destination of the acquired information, and a provision condition of the acquired information, wherein the information acquisition start time matches a current time. When the information acquisition procedure is started to acquire predetermined information from the database, it is determined whether the acquired information satisfies the provision condition, and if so, means for providing information to the provision destination is provided. Determining whether or not to make a request to hold the information acquisition activation information to the second information providing means based on the information obtained by the first information providing means from the database; An information providing system, further comprising: a holding request unit that generates an information obtaining procedure and requests the second information providing unit to hold the information obtaining start information. 2. An information providing system for receiving an information acquisition request from a terminal device via a network and providing information according to the information acquisition request, comprising: a first information providing unit; and a second information providing unit. The first information providing means includes: means for receiving an information acquisition request from the terminal device via the network; means for acquiring information corresponding to the received information acquisition request from a database; Means for transmitting the obtained information or the information generated based on the obtained information to the terminal device via the network, wherein the second information providing means comprises: an information obtaining procedure, a providing destination of the obtained information. And means for holding information acquisition start information including a provision condition of the acquired information; and activating the information acquisition procedure when the database is updated. Means for obtaining predetermined information from the database, determining whether or not the obtained information satisfies the provision condition, and, if so, providing information to the provision destination; and providing the first information provision The means determines, based on the information acquired from the database, whether to make a request to hold the information acquisition start information to the second information providing means, and generates an information acquisition procedure based on the information acquisition request, An information providing system, comprising: a holding request unit that requests the second information providing unit to hold the information acquisition start information. 3. The information providing system according to claim 1, wherein the second information providing means updates the database when providing the information to the providing destination. system. 4. An information providing system for receiving an information processing request from a terminal device via a network and providing information related to the information processing request, comprising: a first information providing unit; a second information providing unit; And the first information providing means, via the network, a means for receiving the information processing request transmitted from the terminal device, accessing a database, and based on the access result, the information Means for determining whether or not a process according to a process request can be completed; and, if the process can be completed, after completing the process, transmitting information indicating that the process has been completed to the terminal device, If the processing cannot be completed, information indicating that fact, and whether or not to monitor whether or not the processing can be completed and to notify when it can be completed, Means for transmitting the inquiry to the terminal device, and when the terminal device has instructed to perform monitoring and notification in response to the inquiry, generating monitoring information indicating a monitoring request according to the instruction. Means for sending to the second information providing means, wherein the second information providing means stores the monitoring information sent from the first information providing means, and Means for monitoring whether or not the processing according to the information processing request has been completed by monitoring the database; and when it has been detected that the monitoring has reached the state where the processing can be completed, Means for transmitting, after completing the processing, information indicating that the processing is completed to the terminal device. 5. An information providing system for receiving an information processing request from a terminal device via a network, and providing information related to the information processing request, wherein the information processing system transmits the information processing request transmitted from the terminal device to the network. Means for receiving, via a database, a means for determining whether or not a process corresponding to the information processing request can be completed based on the access result; and, if the process can be completed, the process After the completion, information indicating that the processing is completed is transmitted to the terminal device. If the processing cannot be completed, the information indicating that processing is completed and whether or not the processing can be completed is monitored. Means for transmitting to the terminal device an inquiry as to whether or not to notify the terminal device when it can be completed, and the terminal device monitors and monitors the inquiry. Means for generating and storing monitoring information representing a monitoring request according to the instruction when instructing to perform the notification; and monitoring the database based on the stored monitoring information, thereby providing a response to the information processing request. Means for monitoring whether or not the corresponding process can be completed; and, when the monitoring detects that the process can be completed, after completing the process, the terminal device performs processing. Means for notifying information indicating that the process has been completed. 6. The information providing system according to claim 4, wherein the monitoring based on the monitoring information accesses the database at a predetermined monitoring time or at a timing when the database is updated. An information providing system for monitoring whether or not a process according to a process request can be completed. 7. An information providing system for receiving an order request for a product from a terminal device via a network, and providing information relating to a processing result of the order request, comprising: first information providing means; Providing means for receiving, via the network, an order request transmitted from the terminal device, product inventory information indicating product inventory status, and product Means for accessing a database for holding and managing product order information indicating the order status, and determining whether or not the inventory amount is equal to or more than the order amount of the order request; and Register the order information related to the order request in the database, reduce the inventory amount of the database by the order amount, send information indicating that the order processing has been completed to the terminal device, When the inventory amount is not equal to or more than the order amount, a means for transmitting a notification of inventory shortage and an inquiry about a timing of monitoring the inventory amount to the terminal device, and the terminal device monitors the inventory amount in response to the inquiry. Means for generating monitoring information indicating a monitoring request in accordance with the instruction and sending the generated monitoring information to the second information providing means, wherein the second information providing means comprises: Means for storing the monitoring information sent from the first information providing means; and, based on the monitoring information, the stock amount of the database is read each time the monitoring timing comes, and the stock amount is equal to or more than the order quantity. An information providing system, comprising: means for monitoring whether or not the number has been changed; and means for transmitting information indicating the fact to the terminal device when the stock amount exceeds the order amount. 8. An information providing system for receiving an order request for a product from a terminal device via a network and providing information relating to a processing result of the order request, the information providing system comprising: first information providing means; Providing means for receiving, via the network, an order request transmitted from the terminal device, product inventory information indicating product inventory status, and product Means for accessing a database for holding and managing product order information indicating the order status, and determining whether or not the inventory amount is equal to or more than the order amount of the order request; and Register the order information related to the order request in the database, reduce the inventory amount of the database by the order amount, send information indicating that the order processing has been completed to the terminal device, When the inventory amount is not equal to or more than the order amount, a means for transmitting a shortage notification and an inquiry as to whether or not to monitor the inventory amount to the terminal device; and Means for generating monitoring information indicating a monitoring request according to the instruction and sending the generated monitoring information to the second information providing means, wherein the second information providing means comprises: Means for storing the monitoring information sent from the information providing means, and reading the stock amount of the database every time the database is updated based on the monitoring information, and the stock amount becomes equal to or more than the order amount. An information providing system, comprising: means for monitoring whether or not the stock quantity has been reached; and means for transmitting information indicating the fact to the terminal device when the stock quantity exceeds the order quantity. 9. The information providing system according to claim 7, wherein when the first information providing means detects that the stock amount is not more than the order amount, the order information is stored in the database as back order information. An information providing system, wherein the back order information corresponding to the received order information is deleted when the second information providing means detects that the stock amount is equal to or more than the received order amount. 10. An information providing system for accepting a lending request for an article from a terminal device via a network and providing lending information for the article, comprising: a first information providing unit and a second information providing unit. In addition to the above, the first information providing means includes means for receiving a lending request transmitted from the terminal device via the network, and lending information indicating whether or not the article is being lent. Means for accessing a database to be managed and determining whether or not the article relating to the lending request is being lent, and if the article is not being lent, transmitting information indicating that to the terminal device to the terminal device, If the terminal device is being lent, a means for transmitting to that effect and an inquiry about the timing of monitoring the lending status to the terminal device, Against serial inquiry, when that has been instructing the timing of that and monitoring to monitor the lending situation,
Means for generating monitoring information representing a monitoring request according to the instruction and sending the generated monitoring information to the second information providing means, wherein the second information providing means is sent from the first information providing means Means for storing the monitoring information, and means for reading out the lending status of the database each time the monitoring comes, based on the monitoring information, and monitoring whether or not the article according to the lending request is being lent. An information providing system, comprising: when the article is no longer being rented, means for transmitting information indicating the fact to the terminal device. 11. An information providing system for accepting an item lending request from a terminal device via a network and providing the item lending information, comprising: a first information providing unit and a second information providing unit. In addition to the above, the first information providing means includes means for receiving a lending request transmitted from the terminal device via the network, and lending information indicating whether or not the article is being lent. Means for accessing a database to be managed and determining whether or not the article relating to the lending request is being lent, and if the article is not being lent, transmitting information indicating that to the terminal device to the terminal device, If the terminal is being lent, a means for transmitting to that effect and an inquiry as to whether to monitor the lending status to the terminal device, Means for generating monitoring information indicating a monitoring request in accordance with the instruction and sending the monitoring information to the second information providing means, Information providing means for storing the monitoring information sent from the first information providing means; and reading out the lending status of the database each time the database is updated based on the monitoring information;
Means for monitoring whether or not the article related to the lending request is being lent, and means for transmitting information indicating the fact to the terminal device when the article is no longer being lent. Information providing system. 12. An information providing system for receiving a facility use request from a terminal device via a network and providing the facility use information, comprising: a first information providing unit and a second information providing unit. The first information providing means includes: a means for receiving, via the network, a use request including a desired facility and a desired period transmitted from the terminal device; and Means for accessing a database to be held / managed and determining whether or not a use reservation overlapping the desired use period has already been made for the desired use facility; and if there is no use reservation overlapping the desired use period,
Means for transmitting information indicating that to the terminal device, if there is a use reservation overlapping the desired use period, and to the terminal device an indication of the fact and the timing of monitoring the use reservation status, When the terminal device has instructed to monitor the use reservation status and the timing of monitoring in response to the inquiry,
Means for generating monitoring information representing a monitoring request according to the instruction and sending the generated monitoring information to the second information providing means, wherein the second information providing means is sent from the first information providing means Means for storing the monitoring information, and based on the monitoring information, read out the usage reservation status of the database every time the monitoring timing comes, and check whether there is still a usage reservation overlapping the desired use period for the desired facility. Means for monitoring whether or not there is no use reservation overlapping the desired use period for the desired use facility, and means for transmitting information indicating the fact to the terminal device. system. 13. An information providing system for receiving a facility use request from a terminal device via a network and providing the facility use information, comprising: a first information providing means and a second information providing means. The first information providing means includes: a means for receiving, via the network, a use request including a desired facility and a desired period transmitted from the terminal device; and Means for accessing a database to be held / managed and determining whether or not a use reservation overlapping the desired use period has already been made for the desired use facility; and if there is no use reservation overlapping the desired use period,
Transmits information indicating that to the terminal device, and if there is a use reservation overlapping the desired use period, transmits to the terminal device an indication to that effect and whether to monitor the use reservation status. Means, when the terminal device instructs to monitor the use reservation status in response to the inquiry, generates monitoring information indicating a monitoring request corresponding to the instruction and sends the monitoring information to the second information providing means Means for storing the monitoring information sent from the first information providing means, and each time the database is updated based on the monitoring information. Read the usage reservation status of the database,
Means for monitoring whether or not there is still a use reservation overlapping the desired use period for the desired use facility, and when the use reservation overlapping the desired use period for the desired use facility has disappeared, the terminal device is notified to that effect. Means for transmitting indicated information.