JP2002014863A - Method for operating data base system for task - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method for operating a data base system for a task capable of obtaining the latest information without any time shift as necessary without imposing any excessive load on a main computer. SOLUTION: The data base of inventory information whose information is frequently updated is set in a storage device 5 of a main frame 1, and a part or whole part of the data base is updated and preserved in a storage device 6 of a web server 2 every other day. At the time of operating an ordering task, a user performs access to the data base in the storage device 6 in order to reduce any load on the main frame 1 for performing a basic task such as the update of the data base. Also, as long as operating a selling task, the user is allowed to perform access to the data base in the storage device 5 in order to operates the accurate selling task by using the latest inventory information without any time shift.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an improvement in a method of operating a business database system, and more particularly, to a reduction in the load on a main computer that frequently updates a business database and an improvement for effectively using the latest database. .

[0002]

2. Description of the Related Art A business database system used in a company or the like has been changed from a system configuration using a main computer and an information terminal to a client / server system,
The use of intranets has changed. The WWW that can access various resources existing on the intranet by a unified operation is rapidly spreading, and an extranet for exchanging information between companies using the WWW via the Internet is also spreading. Under such circumstances, core tasks requiring high performance and high reliability, such as online processing of various data, are left on the main computer, and information tasks such as ordering or inventory management are transferred to the sub-computer. In many cases, a system form used from the WWW is used.

[0003]

When a business database system is operated by applying such a system form, information-related work such as ordering and inventory confirmation is performed independently of the main computer. Although the load on the computer is reduced, the latest database that has just been updated exists only on the main computer, and the database information output from the sub computer takes time until this database is downloaded to the sub computer. However, there is a problem that a temporary mismatch occurs.

[0004]

SUMMARY OF THE INVENTION It is therefore an object of the present invention to solve the above-mentioned drawbacks of the prior art and to provide the latest information without time lag without imposing an excessive load on a main computer for carrying out core business. It is an object of the present invention to provide a method of operating a business database system that can be obtained according to the requirements.

[0005]

According to the present invention, a main computer having a storage device and a sub-computer are connected so as to be able to transmit information, and a business database whose information is frequently updated by the main computer is stored in the main computer. A method of operating a business database system that is installed in an apparatus and updates and saves a part or all of a business database in a storage device of a sub-computer at predetermined intervals, in order to achieve the above object, ,
When the user performs a task that does not require the latest data, the subcomputer is accessed only when the user performs a task that requires the latest data while accessing the business database in the storage device of the subcomputer. And a business database in a storage device of the main computer is accessed via the main computer.

According to this configuration, the contents of the business database updated by the main computer are updated and stored in the storage device of the sub-computer at predetermined intervals, for example, at the end of each business day. You. Therefore,
When doing business that does not require the latest data, for example,
In ordering work, a delay of about one day in updating the database is not a problem, so the user accesses the sub-computer functioning independently of the main computer, and accesses the sub-computer storage device. Browse the database. As a result, access to the main computer that performs mission-critical tasks is regulated,
The load on the main computer is reduced. On the other hand, when performing operations that require the latest data, for example, when performing inventory management operations, a delay in updating the database of one day is an important problem. The main computer is accessed, and the business database in the storage device of the main computer, that is, the business database whose information is updated in real time, is referred to. As a result, it is possible to perform information-related operations such as inventory check using the latest information without time lag. In this way, by accessing the business database in the storage device of either the main computer or the sub-computer as needed, the load on the main computer can be reduced and the latest information without time lag can be obtained. Achieved with a balance.

Furthermore, while accessing the subcomputer, the contents of the business database in the storage device of the subcomputer are displayed on the monitor by default, and only when the display of the latest information is requested by the user's operation, the main computer is displayed. It is possible to configure so that the contents of the business database in the storage device are displayed on the monitor.

By applying such a configuration, it is possible to prevent a user who does not need the latest information from accessing the main computer more than necessary, and to prevent the main computer from being inadvertently accessing a storage device of the main computer. The load can be properly eliminated.

In addition, the business database is divided into a plurality of types corresponding to data types, a list of types is displayed on a monitor when accessing the subcomputer, and then the contents of the database corresponding to the type selected by the user's operation are displayed. Only the main computer or the sub-computer may be read from the storage device and displayed on the monitor.

According to such a configuration, the type of the database to be displayed is specified only to the type required by the user, so that unnecessary information is not read from the storage device of the main computer. Is appropriately reduced.

Further, an access code for determining whether or not access is allowed is set in the subcomputer, and the access code input by the user when accessing the subcomputer matches the access code set in the subcomputer. It is also possible to configure to allow access to each database only in such a case.

Since inadvertent access to the sub-computer and the main computer and reading of information are prohibited, the load on the computer is reduced and the confidentiality of information is effective.

When the main computer is constituted by a main frame for performing online processing of a business database, the sub computer is connected to the Internet as a web server, and the sub computer is accessed by a web terminal connected to the Internet. It is desirable to be able to do so.

By applying such a configuration, the resources of a single database can be used from various places, and the inconvenience of saving a database for each web terminal, and the time between web terminals, Problems such as information inconsistency are also resolved.

[0015]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a simplified block diagram showing hardware constituting a business database system according to an embodiment of the present invention.

This business-use database system is generally a mainframe 1 serving as a main computer.
And a web server 2 which is a subcomputer connected to the mainframe 1 so that information can be transmitted.

The main frame 1 has a large-capacity storage device 5.
Is connected to the web server 2, and a storage device 6 having a slightly smaller capacity is connected to the web server 2. Among them, the web server 2 is connected to the Internet 3 via a firewall, and a web terminal 4 constituted by a normal personal computer can be connected to the web server 2 via the Internet 3. .

The web server 2 is also connected to an in-house network, and can refer to a database in the storage device 6 from another personal computer or the like connected to the network. It is also possible to refer to the database in the storage device 5 using another in-house computer or the like as a terminal by using the information transfer function between the storage device 5 and the server.

Normally, the web server 2 is equipped with an OS such as UNIX (registered trademark), and the information is obtained by using a commercially available web browser as a user interface by a normal HTTP protocol or a CGI function in the UNIX shell. It is well known that input / output of data and transfer of data between computers are performed.

Here, as an example, the basic functions of the mainframe 1 and the web server 2 will be described assuming that the database relating to the inventory management system of the home appliance dealer is handled by the mainframe 1.

The mainframe 1 is connected online to information terminals installed in a large number of home electronics retail stores, and receives sales information from the information terminals of each home electrical store, and sequentially updates the inventory management information database. The database of the inventory management information is installed in the storage device 5, and this database is updated in real time by the internal processing of the mainframe 1 which receives the sales information from the information terminal of the home appliance store.

The mainframe 1 is also used for other business related to the sale of home electric appliances.
Various information other than inventory management information is stored therein. In general, this type of information processing is called a core business, and it is necessary to execute information processing in response to requests from a large number of information terminals and other business in parallel. Is required.

Among the business databases installed in the storage device 5, a database required for information-related business such as ordering and inventory confirmation, that is, a database portion related to inventory management information is a daily business. Each time the processing is completed, the data is updated and stored from the storage device 5 of the mainframe 1 to the storage device 6 of the web server 2.

Therefore, the database relating to the inventory management information is stored in the storage device 5 of the mainframe 1 and the web server 2
Of the mainframe 1, only the storage device 5 of the mainframe 1 holds the real-time inventory management information, and the inventory management information of the database of the storage device 6 is stored. May have a time delay of up to a full day.

A normal ordering operation can be performed if the outline of the inventory management information is grasped, so that it is sufficient to refer to the inventory management information database in the storage device 6. However, when a sales operation is performed, it is necessary to check the inventory status at that point in time, so the inventory management information in the storage device 5 must be referred to.

Next, taking as an example the case where the web server 2 is accessed using the web terminal 4 to refer to the storage device 6 or the database of the storage device 5, the mainframe will be described with reference to the flowcharts of FIGS. An outline of a substantial processing operation of the web server 2 and the web terminal 4 will be described.

Of course, the same operation can be performed by using another personal computer or the like connected to a company network instead of the web terminal 4.

First, when the user operating the web terminal 4 starts an application for displaying inventory information, for example, a commercially available web browser or the like, and connects to the Internet 3, the web terminal 4 executes the discrimination processing in step a1 in FIG. This operation is detected, a login screen as shown in FIG. 7 is displayed on the monitor of the web terminal 4 (step a2), and the system enters a standby state waiting for the user to operate the cancel key or input the login ID and password. Enter (step a3, step a4).

When the cancel key is operated here, the web terminal 4 resets the display of the login screen and releases the connection with the Internet 3 (step a).
15) Normal processing such as launching another application in response to a user request is performed. However, this point is the same as in the conventional case, and a description thereof will be omitted (step a16).

If the user inputs a login ID and a password as an access code while the web terminal 4 repeatedly executes the determination processing of steps a3 and a4, the web terminal 4 detects this operation in the determination processing of step a4. Then, the input login ID and password are transferred to the web server 2 via the Internet 3 (step a5), and the system enters a standby state of waiting for a response of login prohibition or login permission from the web server 2 (step a6, step a7). .

On the other hand, on the side of the web server 2 which is constantly connected to the Internet 3, as shown in FIGS. 4 and 5, steps b1, step b5, step b7, step b9, step b11, step b13, and step b15 are performed. The determination process is repeatedly executed, and the information of the login ID and the password transferred from the web terminal 4 is detected by the web server 2 by the determination process of step b1.

The web server 2 detecting the login ID and password information from the web terminal 4 in this way
Determines whether the login ID and the password are already registered in the web server 2, that is, whether the user who is currently trying to access the web server 2 has a valid access right. (Step b2), if there is a valid access right, a login permission signal is sent (Step b3), and if there is no valid access right, a login prohibition signal is sent (Step b2).
4) Transfer to the above-mentioned web terminal 4 via the Internet 3.

The IP address of the corresponding web terminal 4 is automatically assigned by the web server 2 at the time of the first access.
It is possible to always know the address of the web terminal 4 to be transferred.

The web terminal 4 which continues to wait by repeatedly executing the determination processing of step a6 and step a7
Receives a log-in permission signal or a log-in prohibition signal from the web server 2 by the discriminating process of either step a6 or step a7.

Here, if the login prohibition signal is detected, it means that this user does not have a legitimate access right or there is an input error of the login ID or the password. Again at step a3
Returning to the determination process, the user is allowed to perform a re-input operation of the login ID and the password. Of course, at this stage, it is also possible to operate the cancel key as shown in FIG. 7 and end the processing by exiting from the loop processing of step a3 and step a4 according to the user's intention.

On the other hand, when the login permission signal is detected in the determination processing of step a7, the web terminal 4 transfers the stock summary information request signal to the web server 2 via the Internet 3 (step a8). Enters a standby state waiting for the transfer of the stock summary information (step a).
9).

Step b1, step b5, step b
7, Step b9, Step b11, Step b13,
The web server 2 that has repeatedly executed the determination process of step b15 detects this inventory summary information request signal in the determination process of step b5, accesses the storage device 6 of the web server 2 and reads the inventory summary information, and The data is transferred to the web terminal 4 via the Internet 3 (step b6).

The web terminal 4 that has detected the stock summary information in the determination processing of step a9 displays the stock summary information transferred from the web server 2 on the monitor of the web terminal 4 (step a10), and checks the check box by the user. The process enters a standby state waiting for a selection operation or an operation of a return key or an operation of a detailed information request key (step a11, step a13, step a14).

FIG. 8 shows an example of the stock summary information displayed on the monitor of the web terminal 4. This inventory summary information has data types of TV, video, DVD player, refrigerator,
It shows a list of the total number of stocks for each type, divided into a plurality of groups such as microwave ovens, etc., as described above, the data related to the stock management information is stored in the mainframe 1 at the end of one business day. Is stored in the storage device 6 of the web server 2 from the storage device 5 of FIG.

Here, the user who refers to the monitor of the web terminal 4 selects one of the data types with a check box on the monitor, and obtains detailed information on the data of that type.

The check box selection operation performed by the user is detected by the web terminal 4 by the determination processing in step a11.
The selected types are additionally stored one after another (step a12). Although the example of FIG. 8 shows a case where only the detailed information related to the television is selected, a plurality of data types can be selected at the same time, as is clear from the processing of step a11 and step a12. . At this stage, by operating the return key as shown in FIG. 8, it is possible to cancel the request for the detailed information and return to the login screen as shown in FIG. 7 again (step a).
2) Further, by operating the cancel key as shown in FIG. 7, it is also possible to return to the normal processing from the login screen (step a3, step a15, step a16).

When the user who has completed the check box selection operation operates the detailed information request key as shown in FIG. 8, the web terminal 4 detects this operation in the determination processing of step a14, and (Step a17), and transfers the detailed inventory information request signal and the type of data to be requested to the web server 2 via the web server 2 (step a17). .

Step b1, Step b5, Step b
7, Step b9, Step b11, Step b13,
The web server 2 that has repeatedly executed the determination process of step b15 detects the inventory detailed information request signal and the type of data to be requested in the determination process of step b7,
The storage device 6 is accessed to read the data type requested from the web terminal 4 described above, that is, detailed inventory information related to the television, and transfer this data to the web terminal 4 via the Internet 3 (step b8).

In this way, only the detailed inventory information of the type required by the user, for example, the detailed inventory information related to the television is transferred, so that the load on the web server 2 is reduced.

Then, the web terminal 4 which has detected the detailed stock information in the determination processing of step a18 displays the detailed stock information transferred from the web server 2 on the monitor of the web terminal 4 as default stock information (step a1).
9), enter a standby state to wait for the user to operate the return key or the latest inventory information request key (step a20,
Step a21).

FIG. 9 shows an example of detailed inventory information displayed on the monitor of the web terminal 4. This detailed inventory information is a list showing only the data types selected on the screen of FIG. 8, for example, the number of home appliances in the category of television, and in this example, a flat-panel CRT television which is a type of television. Inventory information such as 25-inch, flat-panel CRT television 30, 30-inch flat-panel CRT television 35,... However, as described above, the database related to the inventory management information is stored from the storage device 5 of the mainframe 1 to the storage device 6 of the web server 2 at the end of one business day, and is therefore shown in FIG. Such detailed inventory information involves a time delay of up to a full day.

Here, if the user operating the web terminal 4 is a person in charge of ordering, a data delay of about one day does not pose a business problem. Therefore, the user in charge of the ordering operation refers to the detailed inventory information as shown in FIG. 9 and directly executes the operation related to the ordering. In this case, the user who has completed the work related to the order will operate the return key as shown in FIG.

The operation of the return key is detected by the discriminating process of step a20 in the web terminal 4, and the web terminal 4 which has detected this operation returns to the process of step a10 again and returns to FIG.
Is displayed to allow the user to request new detailed inventory information. That is, it is possible to refer to the detailed stock information of another data type other than the television, for example, the detailed stock information of a video, a DVD player, and the like. If it is not necessary, the user operates the return key as shown in FIG. 8 (step a1).
3) It is possible to go back to the login screen as shown in FIG. 7 (step a2), and further operate the cancel key as shown in FIG. 7 (step a3) to return to the normal processing.

On the other hand, if the user operating the web terminal 4 is a sales person in charge, the delay of one day's data is a serious problem in the business, and furthermore, as shown in FIG. It is necessary to read the latest database from the storage device 5 of the mainframe 1 by operating the latest inventory information request key and refer to it.

The operation of the stock latest information request key by the user is detected by the discriminating process of step a21 in the web terminal 4, and the web terminal 4 which has detected this operation sends a stock latest information request signal to the web server 2 via the Internet 3. After the transfer (step a22), the standby time measurement timer T is started to start measuring the elapsed time after the transfer of the latest inventory information request signal (step a23), and is displayed on the monitor of the web terminal 4 as shown in FIG. An alert message as shown is displayed to indicate to the user that a certain amount of time is required for data acquisition (step a24), and the standby time measuring timer T times out or the web server 2
Into a standby state waiting for the transfer of an error signal from the server or the transfer of the latest inventory information (step a25, step a2).
6, step a27).

In the process of step a22, the data set in the processes of step a11 and step a12, that is, the signal designating the type of data of the television or the like is also transferred together with the latest stock information request signal. Has become.

On the other hand, step b1, step b5, step b7, step b9, step b11, step b
The web server 2 that repeatedly executes the determination process of step 13 and step b15 detects the latest stock information request signal from the web terminal 4 and the type of data to be requested in the above-described determination process of step b9. The stock latest information request signal and the signal designating the data type are transferred to the frame 1 (step b10).

As shown in FIG. 6, steps c1,
The mainframe 1, which repeatedly executes the processing of step c2 or step c3, step c4, and step c7, determines the latest stock information request signal from the web server 2 and the type of the data to be requested in the determination processing of step c4. Is detected and whether or not sufficient capacity is left for transferring the latest inventory information, that is, the database update processing (step c2) based on the sales information from the information terminal of the sales shop connected online and the normal business It is determined whether or not the CPU, the RAM, and the like of the main frame 1 are overloaded by the processing (step c3) (step c5).

Then, if it is not overloaded,
The mainframe 1 accesses the storage device 5 and reads, from the latest database of the storage device 5, the latest inventory information of the type of data designated by the web terminal 4, for example, the latest inventory information relating to the television, and reads this data. Is transferred to the web server 2 (step c6). As a result, only the latest stock information of the type required by the user is transferred, so that the load on the mainframe 1 is reduced.
Further, since the database of the storage device 5 is updated each time sales information is received from the information terminal of the sales store connected online to the mainframe 1 by the processing of step c1 and step c2, the inventory is substantially real-time. Management is possible.

On the other hand, if the result of the determination in step c5 is true, that is, if the mainframe 1 is overloaded, an error signal is transferred to the web server 2 (step c7). .

Here, when the latest stock information is transferred from the mainframe 1, the web server 2 executes step b11.
Is detected in the determination processing of (a), and this information is transferred to the above-mentioned web terminal 4 via the Internet 3 (step b).
12). When an error signal is transferred from the mainframe 1, the web server 2 detects the error signal in the determination process of step b13, and transfers the error signal to the web terminal 4 via the Internet 3. (Step b14).

The web terminal 4 repeatedly executes the discriminating processes of steps a25, a26, and a27. When the latest stock information is transferred from the web server 2, it is detected by the discriminating process of step a27. Then, the latest inventory information transferred from the web server 2 is displayed on the monitor of the web terminal 4 (step a28), and the apparatus enters a standby state waiting for the operation of the return key by the user (step a3).
0).

FIG. 10 shows an example of the latest stock information displayed on the monitor of the web terminal 4. This inventory latest information is a list showing only the data type selected on the screen of FIG. 8, for example, only the current number of home appliances included in the category of television, in the same manner as the detailed inventory information described above. As shown in FIG. 10, it is displayed continuously right next to the detailed inventory information already displayed in the state of FIG. Since this latest inventory information is real-time data sent from the storage device 5 of the mainframe 1,
By referring to the latest stock information, a user who performs sales operations can execute accurate sales operations without errors.

As described above, the latest inventory information stored in the storage device 5 of the mainframe 1 is read out and directly displayed on the monitor of the web terminal 4 because the detailed inventory information as shown in FIG. Is limited when the user actively operates the stock latest information request key on the screen where is displayed.

Then, when the user who has completed the business related to sales operates the return key as shown in FIG.
The web terminal 4 detects this operation in the determination processing of step a30 and returns to the processing of step a19 again to display the screen of FIG. Here, when the user further operates the return key, this operation is detected in the determination processing of step a20, and the processing returns to the processing of step a10 again, and the stock summary information as shown in FIG. 8 is displayed. It is also possible to select another type of data again and display the detailed inventory information, or to display the latest inventory information.

If it is not necessary, the user operates the return key as shown in FIG. 8 (step a13), goes back to the login screen as shown in FIG. 7 (step a2), and further returns to FIG. By operating the cancel key as shown (step a3), it is possible to return to the normal processing.

If an error signal is transmitted from the web server 2 while the web terminal 4 repeatedly executes the determination processes of steps a25, a26, and a27, the web terminal 4 executes the determination process of step a26. This is detected on the monitor of the web terminal 4 in FIG.
Display an error message as shown in (b),
The user is notified that the information transfer may not be performed properly because the processing capacity of the mainframe 1 is overloaded (step a29).

In this case, if the return key as shown in FIG. 11 (b) is operated, this operation is detected in the discriminating process of step a30, and the inventory detailed information display screen of FIG. The return to the stock summary information display screen 8 and the log-in screen in FIG. 7 and the return to the normal processing are permitted.

Also, while the web terminal 4 repeatedly executes the determination processing of steps a25, a26, and a27, it is confirmed that the measurement time of the standby time measurement timer T has reached the set value in the determination processing of step a25. In this case, it means that the processing of the mainframe 1 may have stopped, and the web terminal 4 displays an error message as shown in FIG. Is displayed to notify the user of the abnormality (step a29). Also in this case, it is possible to return to the detailed inventory information display screen, the general inventory information display screen, or the login screen by operating the return key, and it is also allowed to return to the normal processing.

As described above, various processes are repeatedly executed by the mainframe 1 and the web server 2 to
When the work on the day is finished, the mainframe 1 detects the end of the work by, for example, setting a timer for the closing time (step c8), and at that time, updates the stock latest information of various data stored in the database of the storage device 5 at that time. It is read and transferred to the web server 2 (step c9).

Then, the web server 2 executes step b15
This is detected in the determination processing of (1), and the latest inventory information transferred from the mainframe 1 is updated and stored in the storage device 6 (step b16).

FIG. 12 is a sequence diagram simply showing the exchange of data and signals between the web terminal 4 and the web server 2 and the main frame 1 based on the flowcharts of FIGS. And
Steps used in the description of FIG. 2 to FIG. 6 are also shown for main processes except for error detection and the like.

As is apparent from FIG. 12, when an ordering operation that does not require the latest stock information is performed, the exchange of data and signals indicated by solid lines in the figure, that is, the web terminal 4 and the web server 2 communicate with each other. Only the exchange of data and signals during the operation is sufficient, and the inventory information stored in the storage device 6 of the web server 2 is stored in the web server 2 as shown in FIG. Terminal 4
Can be displayed as default information on other monitors.

On the other hand, in the case of performing a sales operation requiring the latest stock information, in addition to the exchange of data and signals shown by solid lines in FIG. 12, the exchange of data and signals shown by broken lines, that is, the web It becomes necessary to exchange data and signals between the server 2 and the mainframe 1 to display the latest stock information of the storage device 5 as shown in FIG. However, since the frequency at which such an operation is actually performed is not so high, the main frame (compared to the case where the database of the storage device 5 is always referred to via the main frame 1 regardless of the type of business to be performed) is 1 can be greatly reduced.

As described above, when a task that does not require the latest data is performed, the database in the storage device 6 of the web server 2 is accessed, but only when a task that requires the latest data is performed. And web server 2
In addition, since the database in the storage device 5 of the mainframe 1 is accessed via the mainframe 1, the load on the mainframe 1 associated with referencing the database is greatly reduced.

At this time, the selection of whether to extract the information of the storage device 6 or the information of the storage device 5 when referring to the database is not left to the user without condition, but the flow of processing is regulated by an algorithm on the system. And
First, the information of the database of the storage device 6 is displayed by default, and then the information of the database of the storage device 5 is displayed only when there is a special request from a user who performs a sales operation. It is possible to effectively suppress the occurrence of inadvertent access to the mainframe 1 and the storage device 5 caused by the self-determination.

Further, since the mainframe 1 updates the database based on the sales information from the information terminal of the sales shop connected online in real time by the processing of step c2, the web server 2 sends the latest inventory information. (In contrast to the case where the sales information from the information terminal of the store is temporarily stored and the database is updated in a batch process) even if the transfer request is issued. It is not necessary to perform an operation on the data of the mainframe 1 and the processing of the main frame 1 required to refer to the latest stock information in the storage device 5 is suppressed to the minimum necessary.

In addition to the access code for the first login, another access code for accessing the mainframe 1 and extracting the information of the database of the storage device 5 is set, so that a user other than the sales person in charge does not need to set the access code. Access to the main frame 1 in an easy manner may be prevented. In such a case, it may be configured to request the user to input an access code when the latest information request key is operated on the display screen of FIG. In addition, in order to reduce the load on the mainframe 1, the storage destination of the program and the access code used for determining whether access is permitted is the same as in the case of the determination program for login.
It is desirable to be installed in the web server 2.

[0074]

According to the method for operating a business database system according to the present invention, a business database whose information is frequently updated by a main computer is installed in a storage device of the main computer, and a part or all of the business database is provided. Is updated and stored in the storage device of the sub-computer at predetermined intervals, and when the user performs a job that does not require the latest data, while accessing the business database in the storage device of the sub-computer, The user accesses the business database in the storage device of the main computer via the sub computer and the main computer only when the user performs business that requires the latest data. Access to computers is regulated and main Load of the computer is reduced. In addition, when the user performs business that requires the latest data, the user can refer to the business database in the storage device of the main computer, so that the inventory can be checked using the latest information without time lag. Etc. can be carried out accurately.

Further, when accessing the sub-computer, the contents of the business database in the storage device of the sub-computer are displayed on the monitor by default. On the other hand, only when the latest information is requested by the user's operation, the main computer is displayed. Since the contents of the business database in the storage device are displayed on the monitor, inadvertent access to the storage device of the main computer is reliably prevented, and the load on the main computer can be appropriately reduced.

Further, the business database is divided into a plurality of types corresponding to the types of data, a list of types is displayed when accessing the subcomputer, and only the contents of the database corresponding to the type selected by the user's operation are displayed. Since the display is performed, it is possible to prevent a wasteful data transfer operation in the main computer and the sub-computer from occurring.

Further, an access code for determining whether access is permitted is set in the sub-computer, and the access code input by the user when accessing the sub-computer matches the access code set in the sub-computer. Since access to each database is permitted only in the case, unnecessary connection operation due to erroneous operation or mischief is eliminated, and the load on the computer is reduced, and it is also effective in keeping the information of the database confidential. .

In particular, when the main computer is constituted by a mainframe that performs online processing of a business database, the subcomputer is connected to the Internet as a web server, and the subcomputer is accessed by a web terminal connected to the Internet. This makes it possible to use the resources of a single database from various locations, eliminating the hassle of storing a database for each web terminal and the inconsistency of information between web terminals. You.

[Brief description of the drawings]

FIG. 1 is a simplified block diagram showing hardware constituting a business database system according to an embodiment of the present invention.

FIG. 2 is a flowchart showing an outline of a processing operation of the web terminal.

FIG. 3 is a continuation of the flowchart showing an outline of the processing operation of the web terminal.

FIG. 4 is a flowchart showing an outline of a processing operation of a web server.

FIG. 5 is a continuation of the flowchart showing an outline of the processing operation of the web server.

FIG. 6 is a flowchart showing an outline of a mainframe processing operation.

FIG. 7 is a diagram illustrating an example of a login screen displayed on a web terminal.

FIG. 8 is a diagram showing an example of stock summary information displayed on a web terminal.

FIG. 9 is a diagram showing an example of detailed inventory information displayed on a web terminal.

FIG. 10 is a diagram showing an example of stock latest information displayed on a web terminal.

11A is a diagram illustrating an example of a warning message displayed on a web terminal, and FIG. 11B is a diagram illustrating an example of an error message displayed on a web terminal.

FIG. 12 is a sequence diagram collectively showing exchange of data and signals performed between a web terminal, a web server, and a mainframe.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Mainframe (main computer) 2 Web server (subcomputer) 3 Internet 4 Web terminal (personal computer) 5 Storage device 6 Storage device

Claims (5)

[Claims] 1. A main computer provided with a storage device and a sub computer are connected so as to be able to transmit information, and a business database whose information is frequently updated by the main computer is installed in the storage device of the main computer. In the case where a part or all of the business database is updated and stored in the storage device of the sub-computer at predetermined intervals, the storage device of the sub-computer is used when the user performs a business that does not require the latest data. Accessing the business database in the main computer, and accessing the business database in the storage device of the main computer via the sub-computer and the main computer only when the user performs a business requiring the latest data Database system for business use Operation method. 2. When accessing the subcomputer, the contents of the business database in the storage device of the subcomputer are displayed on a monitor by default, and only when the latest information is requested by a user operation, 2. The method according to claim 1, wherein the contents of the business database in the storage device of the main computer are displayed on a monitor. 3. The business database is divided into a plurality of types corresponding to data types, a list of the types is displayed on a monitor when accessing the sub-computer, and the type corresponding to the type selected by a user operation is displayed. 3. The method according to claim 1, wherein only the contents of the database are read from a storage device of the main computer or the sub-computer and displayed on a monitor. 4. An access code for determining whether access is permitted is set in the sub-computer, and an access code input by a user when accessing the sub-computer and an access code set in the sub-computer are set. 4. The business database system operating method according to claim 1, wherein access to each of the databases is permitted only when they match. 5. The main computer is configured by a mainframe that performs online processing of a business database, while the subcomputer is connected to the Internet as a web server, and the subcomputer is accessed by a web terminal connected to the Internet. Claim 1, Claim 2, Claim 3 characterized by the above-mentioned.
Or a method for operating the business database system according to claim 4.