JP2001167122A - Information display system, information display server and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To speedily and appropriately display latest information. SOLUTION: RDB 22 storing base information for generating information, a storage part 34 which stores information generated based on base information in accordance with plural parameters, an instruction reception part 42 inputting the parameter corresponding to displayed information, a selection part 36 extracting information corresponding to the inputted parameter from the storage part 34, a display control part 48 displaying extracted information on a display part 46, a table storage part 54 storing specified information specifying base information for generating extracted information, a data generation processing part 52 detecting that base information specified by specified information is updated, a data generation processing part 52 which newly generates information based on updated base information when base information is updated and a display control part 48 displaying newly generated information on the display part 46 are installed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information display system for displaying information corresponding to a predetermined parameter representing an information type, and an information presentation server for presenting information corresponding to a predetermined parameter representing an information type to a terminal. , And a recording medium.

[0002]

2. Description of the Related Art Hitherto, a database for operably managing various information has been known. As an example of a database, a relational database (RD) that defines a structure based on information relationships and treats a set of the relationships as a set
B: Relational Data Base) is known. To retrieve information from this database, use RDBMS
(Relational Data Base Management System) was required to execute a statement to retrieve necessary information.

In general, there is a demand for displaying a plurality of pieces of information in various sections. For example, in the distribution industry, it is desirable to obtain a cross-section such as monthly sales of each product in each store for a predetermined product, or to obtain a cross-section such as sales of each month for each product in each store. Is required. Therefore, it has been practiced to prepare a command sentence for obtaining a cross section in advance and obtain the cross section using the command sentence. However, in this case, there arises a problem that a user who is not familiar with the structure of the database can obtain only a section in which a command statement is prepared in advance.

On the other hand, OLAP (Online Analytical Processi ...
ng) Server is known. As a technology in the OLAP server, for example, Japanese Patent Application Laid-Open No. Hei 6-274873 discloses that a business model is constructed by associating or aggregating data of a database with each other and allowing a user to set an information axis based on the business model. A data extraction method for constructing an intermediate data structure by combining information axes in a multi-dimensional manner, allowing a user to select an information axis of the intermediate data structure, and displaying data corresponding to a data extraction item and a display information key. Is disclosed.

FIG. 1 is a diagram for explaining an outline of an information display system having an OLAP server according to a conventional example and displaying information. In the information display system, the data update processing unit 12 of the processing device 10 performs a data update process by a batch process or a real-time process, and issues an instruction to update the information in the RDB 22 of the database server RD.
Notify BMS24. The RDBMS 24 updates the corresponding information stored in the RDB 22 based on the instruction to update.

[0006] Thereafter, in the regular or daily batch processing, the tally processing unit 32 of the OLAP server 30 executes the RDB
The information is extracted from the RDB 22 by the MS 24, and based on the information, an information structure 35 including a plurality of parameters (information axes) is generated and stored in the storage unit 34. Then, when an instruction axis for specifying information to be displayed by the instruction receiving unit 42 of the terminal 40 is received, the instruction is transmitted to the OLA.
This is transmitted to the selection unit 36 of the P server 30. The selection unit 36
The information corresponding to the information axis received by the instruction receiving unit 42 is selected and extracted from the information structure 35 stored in the storage unit 34, and transmitted to the display control unit 44. The display controller 44 causes the display 46 to display the received information.

[0007]

In the conventional information display system described above, it may take, for example, one hour to several tens of hours to extract information from the RDB 22 and create the information structure 35. Therefore, this process is executed by a regular or daily batch process. For this reason, there is a problem that the totaling result of information that changes in real time (real time) cannot be displayed on the display unit 46 in real time. In order to maintain the latest state, it is conceivable to shorten the processing interval. However, in this case, the load on the OLAP server 30, the database server 20, and the like is increased. Problems such as deteriorating the performance of the system.

[0008] Therefore, an object of the present invention is to provide an information display system, an information presentation server, and a recording medium that can solve the above-mentioned problems. This object is achieved by a combination of features described in the independent claims. The dependent claims define further advantageous embodiments of the present invention.

[0009]

In order to achieve the above object, an information display system according to a first embodiment of the present invention is an information display system for displaying information corresponding to a predetermined parameter representing the type of information. A basic information storage unit that stores basic information for creating information; an information storage unit that stores information created based on the basic information in association with a plurality of parameters; An input unit for inputting parameters of the unit, an information extraction unit for extracting information corresponding to the input parameters from the information storage unit, a display control unit for displaying the extracted information on a display unit, and A specific information storage unit that stores specific information that specifies basic information to be created; an update detection unit that detects that basic information specified by the specific information has been updated; An update information creation processing unit that updates the extracted information based on the updated basic information, and an update display control unit that causes the display unit to display the updated information. .

[0010] Each of the plurality of terminals includes an input unit and a display unit, the specific information storage unit stores the specific information in association with the terminal, and the update display control unit stores the information. The updated information may be displayed on the display unit of the terminal associated with the specific information for specifying the basic information for creating the basic information. Further comprising an information creating unit for creating information that associates with a plurality of parameters based on the basic information,
The information storage unit may store information created based on the basic information in association with a plurality of parameters. The information creating unit may create information to be associated with a plurality of parameters based on the basic information by batch processing.

[0011] To achieve the above object, a second aspect of the present invention is provided.
The information presentation server according to the embodiment of the present invention is an information presentation server that presents information to a terminal that displays information corresponding to a predetermined parameter representing a type of information, and includes basic information for creating information to be displayed on the terminal. A specific information input unit for inputting specific information to be specified, a specific information storage unit for storing the specific information input by the specific information input unit, and, when the basic information specified by the specific information is updated, An update information creation processing unit that updates information based on the information and an update display control unit that causes the terminal to display the updated information. The specific information storage unit stores the specific information in association with the terminal, and the update display control unit updates the display unit of the terminal associated with the specific information that specifies the basic information for creating the information. Information may be displayed.

In order to achieve the above object, a third aspect of the present invention is provided.
The recording medium according to the embodiment is a recording medium that stores a program that causes a computer to present information to a terminal that displays information specified by a predetermined parameter representing the type of information, and stores information to be displayed on the terminal. A specific information input program for inputting specific information for specifying basic information for creating, a specific information storage program for storing specific information input by the specific information input program,
An update information creation processing program that updates information based on the basic information when the basic information specified by the specific information is updated, and an update display control program that displays the updated information on a terminal. And
Note that the above summary of the present invention does not list all of the necessary features of the present invention, and a sub-combination of these features may also be an invention.

[0013]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, the present invention will be described through embodiments of the present invention. Not all combinations of the features are necessarily essential to the solution of the invention. FIG. 2 is a configuration diagram of an information display system according to one embodiment of the present invention. The information display system includes a processing device 10 and a database server 20.
, An OLAP server 30, a terminal 40, and a presentation server 50 as an example of an information presentation server. In the present embodiment, the processing device 10, the database server 20, the OL
The AP server 30, the terminal 40, and the presentation server 50 are each configured by a single computer, for example.

The processing device 10 has a data update processing unit 12. The data update processing unit 12 performs a predetermined process to generate new basic information for updating basic information stored in the RDB 22 described later. In addition, the data update processing unit 12 transmits an instruction to update the basic information of the RDB 22 to the database server 20. The database server 20 includes an RDB 22 as an example of a basic information storage unit,
An RDBMS 24 and an update detection unit 26 are provided. RDB
Reference numeral 22 stores the basic information generated by the data update processing unit 12. The RDBMS 24 performs management processing on the RDB 22. For example, the RDBMS 24 is the RDB2
2 and the basic information is taken out. The update notification unit 26 sends the RD
When there is a request to update the basic information stored in B22, the RDBMS 24 instructs the RDBMS 24 to update the basic information of the RDB 22, and notifies the presentation server 50 of the request for updating the basic information.

The OLAP server 30 has a tallying unit 32 as an example of an information creating unit, a structure storage unit 34 as an example of an information recording unit, and a selecting unit 38 as an example of an information extracting unit. The aggregation processing unit 32 generates a plurality of pieces of information based on the basic information stored in the RDB 22, and creates an information structure 35 by associating the information with a plurality of parameters. The structure storage unit 34 stores the information structure 35 generated by the aggregation processing unit 34. The selection unit 38 is a terminal 4
When an instruction of a parameter to be displayed is received from 0, information associated with the parameter is selected from the information structure 35 and transmitted to the terminal 40, and at the same time, the information and basic information of the information are identified. The information is transmitted to the presentation server 50. In the present embodiment, identification information of the information in the information structure 35, for example, address information is used as the specific information. According to the address information, basic information can be specified in the presentation server 50 described later. In the present embodiment, the selection unit 38
Transmits the identification information of the terminal 40 that has transmitted the information to the presentation server 50. Further, when the change of the information to be displayed is received from the terminal 40, the selection unit 38 transmits to the presentation server 50 a notification that the information to be displayed is to be changed.

FIG. 3 shows an OLA according to an embodiment of the present invention.
It is a conceptual diagram explaining the information structure stored in the P server. FIG. 3 shows an example of an information structure in the distribution industry. As shown in FIG. 3, the information structure 35 has a store, a date, and a product as parameters, and information on sales is associated with these parameters.

When the information structure 35 is cut at a surface where the parameters of the product are fixed to any one of the products, as shown in FIG. 3A, the sales of the product by store and by date are obtained. Information can be obtained. The information structure 35
Is cut on a surface where the parameters of the store are fixed to one of the stores, as shown in FIG. 3B, information on sales by product and by date in the store can be obtained. Further, when the information structure 35 is cut along a plane in which the date parameter is fixed to one of the dates, FIG.
As shown in (1), it is possible to obtain information on sales by store and by product on the date.

The terminal 40 has an instruction receiving unit 42 as an example of an input unit, a display control unit 48 as an example of an update display control unit, and a display unit 46. In the present embodiment, at least a part of the functions of the instruction receiving unit 42 and the display control unit 48 is configured using a so-called browser function. The display unit 46 is, for example, a display device,
Display information. The instruction receiving unit 42 has, for example, a mouse device, a keyboard, and the like, receives an input of a parameter corresponding to information to be displayed among a plurality of parameters from a user, and notifies the OLAP server 30 of the input. Here, for example, when it is desired to obtain the cross section shown in FIG. 3A, it is desired to input the store and the date as the parameters to be displayed, and to display the values as one of the parameters of the product. Enter the product name of the product. The instruction receiving unit 46
Notifies the OLAP server 30 of the content to be switched, together with the parameters, when switching the information to be displayed.

The display controller 48 causes the display 46 to display the information transmitted from the selector 38. In addition, when receiving an update notification indicating that information described later has been updated from the presentation server 50, the display control unit 48 requests the corresponding information from the presentation server 50 and receives the information from the presentation server 50. Display on the display unit 46.

The presentation server 50 includes a table storage unit 54 as an example of a specific information storage unit, a table management unit 56 as an example of a specific information input unit, and a corresponding address storage unit 5.
8 and a data creation processing unit 52 as an example of an update detection unit and an update information creation processing unit. Table storage unit 5
4 stores a table in which information is associated with address information of the information. In the present embodiment, the table storage unit 54 stores information and address information in association with identification information of the terminal 40 that displays the information.

The table management section 56 stores the information and the address information notified from the selection section 38 in the table storage section 54 in association with each other. In the present embodiment, the table management unit 56 controls the selection unit 38 for the information and the address information.
Are stored in the table storage unit 54 in association with the identification information of the terminal 40 notified from the server 40. When the same address information and information are already stored in the table storage unit 54, the table management unit 56 further associates the identification information of the terminal 40 with the stored address information and information. Is also good. In this way, it is not necessary to have a plurality of pieces of the same address information and information to be displayed on different terminals 40, and the necessary data amount can be suppressed.

When receiving a notification from the OLAP server 30 that information to be displayed by the terminal 40 is to be changed, the table management unit 56 displays the information stored in the table storage unit 54 and its address. Delete information. Thereby, the terminal 40 is stored in the table storage unit 54.
Can be prevented from being stored and information that is not displayed in the.

The corresponding address storage unit 58 associates the address information with identification information of basic information used when creating the information of the address information, for example, address information in the RDB 22 (referred to as RDB address information). The corresponding address table is stored. Therefore, from the address information in the information structure 35, the basic information of the RDB 22 used for creating the information of the address information can be specified.

The data creation processing section 52 includes an update notifying section 26
When the notification that the basic information of the RDB 22 is updated is received from the corresponding address storage unit 58, the address information corresponding to the RDB address information of the updated basic information is detected, and the address information is stored in the table storage unit 54. It is detected whether or not it is stored. Next, when the data creation processing unit 52 detects that the address information is stored in the table storage unit 54, the data creation processing unit 52 newly creates the information based on the updated basic information and stores the information in the table storage unit 54. Update the appropriate information. In addition, when the information in the table storage unit 54 is updated, the data creation processing unit 52 updates the information displayed on the corresponding terminal 40 based on the identification information of the terminal 40 associated with the updated information. Notify that it has been updated.

FIG. 4 is a diagram illustrating a hardware configuration of the presentation server according to one embodiment of the present invention. The presentation server 50 includes a CPU (central processing unit) 60
RAM (random access memory) 61 and ROM (re
ad only memory) 62, a communication I / F (interface) 63, a display 64, an input device 66, a communication I / F (interface) 65, a hard disk 67, and a CD-ROM (compact disk ROM) drive 6.
8 is provided.

The CPU 60 has a RAM 61 and a ROM 62
Perform processing based on the program stored in the. Communication I
/ F63 mediates the transmission and reception of data with the database server 20. The display 64 displays various information. The communication I / F 65 mediates transmission and reception of data with the terminal 40. The input device 66 inputs various settings and the like. C
The D-ROM drive 68 reads data or a program from the CD-ROM 69 and passes it to the CPU 60. The hard disk 67 stores the data or program read by the CD-ROM drive 69 and reads the stored data or program to read the data or program.
Pass to 60.

In this embodiment, a specific information input program for inputting specific information for specifying basic information for creating information to be displayed on a terminal, and a specific information storage for storing specific information input by the specific information input program A program, a creation processing program for newly creating information based on the basic information when the basic information specified by the specific information is updated, and an update display control program for displaying the created information on a terminal. CD-RO
These programs are read from M69 and installed on the hard disk 67. Then, these programs are read from the hard disk 67 and
60, the data creation processing unit 52, the table storage unit 54, and the table management unit 56
And a corresponding address storage unit 58.

FIG. 5 is a sequence diagram illustrating the operation of the information display system according to one embodiment of the present invention. In the present information display system, the following batch processing is executed at predetermined time intervals. That is, the tally processing unit 32 of the OLAP server 30 requests the RDBMS 24 to transmit basic information necessary for processing (step S100). On the other hand, the RDBMS 24 stores the requested basic information in the R
The data is taken out from the DB 22 and transmitted to the tally processing unit 32 (Step S102). Next, the aggregation processing unit 32 generates information based on the received basic information, generates an information structure 35 by associating the information with a plurality of parameters, and stores the information structure 35.
4 is stored.

After the completion of the batch processing, when the parameter corresponding to the information to be displayed is received by the instruction receiving unit 42 of the terminal 40, the parameter is transmitted to the OLAP server 30 as an information transmission request (step S106). . In the OLAP server 30, the selection unit 38 extracts information corresponding to the transmitted parameter from the information structure 35 (Step S108), and transmits the result to the terminal 40 (Step S109). Thereby, the display control unit 48 of the terminal 40 causes the display unit 46 to display information (step S110). Therefore, information corresponding to various parameters can be promptly displayed on the terminal 40.

At the same time, the selection unit 38 transmits the extracted information, the address information of the information, and the identification information of the terminal 40 that transmitted the information (step S11).
2). The table management unit 56 of the presentation server 50 associates information, address information, and terminal identification information with each other,
The information is registered in the table storage unit 54 (step S114).

Thereafter, when the data update processing unit 12 of the processing device 10 generates new update information for updating the basic information of the RDB 22 (step S116), the data update processing unit 12 updates the basic information of the RDB 22 with the new update information. Notify the database server 20 of an instruction to update (step S
118). Next, the RDBMS 24 updates the corresponding basic information of the RDB 22 with new basic information (step S).
120). Further, the update notifying unit 26 notifies the presentation server 50 that there is an instruction to update the basic information (Step S122).

Next, the data creation processing section 52 of the presentation server 50 stores the information structure 35 corresponding to the RDB address information of the updated basic information from the corresponding address storage section 58.
Is detected, and whether or not the address information is stored in the table storage unit 54 is detected. Next, when the data creation processing unit 52 detects that the address information is stored in the table storage unit 54, the database creation processing unit 52 transmits the necessary basic information to the RDBM.
Request to S24 (step S124), RDBMS2
4 receives the basic information (step S126). Then, the data creation processing unit 52 creates new information based on the received basic information and updates the corresponding information in the table storage unit 54 (Step S128). Since the amount of processing for updating this information is small compared to the amount of processing performed by the tally processing unit 32 by batch processing, the load on the database server 20 is hardly imposed. For this reason, the processing using the RDB 22 by the processing device 10 is hardly affected.

Next, the terminal 40 in which the identification information is associated with the information updated by the data creation processing unit 52 is notified that the displayed information has been updated (step S).
130). In the terminal 40 that has received the notification that the information has been updated, the display control unit 48 requests transmission of the information (step S132). In response, the table management unit 56 of the presentation server 50 transmits the corresponding information to the terminal 40 (Step S134). Next, the information displayed on the display unit 40 is updated with new information based on the information received by the display control unit 48 of the terminal 40 (step S13).
6). As a result, information reflected on the basic information updated in real time on the terminal 40, for example, information such as the current value of sales on the day for a predetermined product at each store can be displayed.

The present invention is not limited to the above embodiment, and various modifications are possible. For example, in the above embodiment, the OLAP server 30 uses the presentation server 5 to specify information that specifies basic information for creating information to be displayed.
However, the terminal 40 may send the specific information to the presentation server 50. In the above embodiment, the database server 20 detects whether the basic information has been updated. However, the present invention is not limited to this. For example, when the basic information is updated in the processing device, You may make it notify the presentation server that information is updated.

In the above embodiment, the processing device 10
Although the database server 20, the OLAP server 30, the presentation server 50, and the terminal 40 are each configured by different computers, at least any two may be configured by the same computer. Further, in the above embodiment, the example of the distribution industry dealing with commodities and the like is shown, but for example, the present invention can be applied to information such as the trading volume of stocks in the same manner as described above. The present invention can be applied as long as information that changes with time is included.

In the above embodiment, the CD-ROM 69 is used as an example of a recording medium for storing a program. However, the present invention is not limited to this. For example, a floppy disk, an MD (Mini Disk), a DVD (Digital Vid
Other recording media such as eo Disc) and MO (Magneto-Optical) may be used.

Although the present invention has been described with reference to the embodiment, the technical scope of the present invention is not limited to the scope described in the above embodiment. It is apparent to those skilled in the art that various changes or improvements can be added to the above embodiment. It is apparent from the description of the appended claims that embodiments with such changes or improvements can be included in the technical scope of the present invention.

[0038]

As is apparent from the above description, according to the present invention, information can be displayed quickly and appropriately.

[Brief description of the drawings]

FIG. 1 is a diagram illustrating an outline of an information display system according to a conventional example.

FIG. 2 is a diagram illustrating a configuration of an information display system according to an embodiment of the present invention.

FIG. 3 is a conceptual diagram illustrating an information structure stored in an OLAP server according to an embodiment of the present invention.

FIG. 4 is a diagram illustrating a hardware configuration of an information presentation server according to an embodiment of the present invention.

FIG. 5 is a sequence diagram illustrating an operation of the information display system according to the embodiment of the present invention.

[Explanation of symbols]

REFERENCE SIGNS LIST 10 processing device 12 data update processing unit 20 database server 22 RDB 24 RDBMS 30 OLAP server 32 totalization processing unit 34 storage unit 36 selection unit 40 terminal 42 instruction reception unit 46 display unit 48 display control unit 50 real-time server 52 data creation processing unit 54 Table storage unit 56 Table management unit

Continued on the front page (72) Inventor Mina Horiuchi 3-14-20 Higashinakano, Nakano-ku, Tokyo Kokusai Electric Co., Ltd.F-term (reference) 5B075 NR02 PP02 PP03 PQ02 QT06 5B082 GA03 GA08 5E501 AC23 AC33 AC34 BA01 DA02 DA11 DA13

Claims (7)

[Claims] 1. An information display system for displaying information corresponding to a predetermined parameter representing a type of information, comprising: a basic information storage unit for storing basic information for creating the information; An information storage unit that stores the information created in association with a plurality of the parameters, an input unit that inputs some of the plurality of parameters, and stores the information corresponding to the input parameters. An information extraction unit that extracts from the information storage unit; a display control unit that causes the extracted information to be displayed on a display unit; and an identification that stores identification information that identifies the basic information for creating the extracted information. An information storage unit; an update detection unit that detects that the basic information specified by the specific information has been updated; and an update unit that has been updated when the basic information has been updated. An information display, comprising: an update information creation processing unit that updates the extracted information based on the basic information; and an update display control unit that displays the newly updated information on the display unit. system. 2. A terminal having a plurality of terminals, each of the plurality of terminals includes the input unit and the display unit, and the specific information storage unit stores the specific information in association with the terminal. The update display control unit causes the display unit of the terminal to display the updated information on the display unit associated with the identification information that identifies basic information for creating the information. Item 2. The information display system according to Item 1. 3. An information creating unit for creating information associated with a plurality of parameters based on the basic information, wherein the information storage unit converts the information created based on the basic information into a plurality of information. 3. The information display system according to claim 1, wherein the information is stored in association with a parameter. 4. The information display system according to claim 3, wherein said information creating section creates information associated with a plurality of said parameters based on said basic information by batch processing. 5. An information presentation server for presenting information to a terminal displaying information corresponding to a predetermined parameter representing a type of information, wherein basic information for creating the information to be displayed on the terminal is specified. A specific information input unit for inputting specific information to be specified, a specific information storage unit for storing specific information input by the specific information input unit, and when the basic information specified by the specific information is updated, An information presentation server, comprising: an update information creation processing unit that updates the information based on basic information; and an update display control unit that causes the terminal to display the updated information. 6. The specific information storage unit stores the specific information in association with the terminal, and the update display control unit associates the specific information with basic information for creating basic information for creating the information. The information presentation server according to claim 5, wherein the updated information is displayed on the display unit of the terminal that is being used. 7. A recording medium storing a program for causing a terminal, which displays information specified by a predetermined parameter representing a type of information, to present the information to a computer, wherein the information to be displayed on the terminal is stored. A specific information input program for inputting specific information specifying basic information to be created; a specific information storage program for storing specific information input by the specific information input program; and the basic information specified by the specific information A storage medium comprising: an update information creation processing program that updates the information based on the basic information when the information is updated; and an update display control program that causes the terminal to display the updated information. .