JP2002351714A - Apparatus and method for generating web page having multi-dimensional table, web page generation program, recording medium - Google Patents

Abstract

(57) [Summary] PROBLEM TO BE SOLVED: To easily generate a web page of a two-dimensional table in which changes are reflected without the need to modify and recompile a program when the need for changing extraction conditions arises. To SOLUTION: Apart from a web page generation program including an extraction processing execution unit 11, a sort unit 12, a page generation unit 14, etc., a plurality of extraction conditions are output as table information, stored in a condition table storage unit 5, and stored in a condition table storage unit 5. By causing the page generation program to generate a web page including a two-dimensional table using the extraction condition table information, even when the need for changing the extraction conditions arises, without altering and recompiling the program, By simply changing the extracted extraction condition table information, a two-dimensional table web page reflecting the changed contents can be easily generated.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus and a method for generating a web page having a multidimensional table, a web page generation program, and a recording medium.
The present invention is suitable for use in a system having a function of generating a web page such as a form including a two-dimensional table including axes.

[0002]

2. Description of the Related Art At present, web systems in which a server and a client are connected on a network such as the Internet or an intranet and a client accesses the server to receive a desired service are often used. Many web systems of this type provide a form page in which necessary information is arranged and displayed in a two-dimensional table including an X axis and a Y axis.

For example, in a personnel system for managing personnel in a company, information extraction processing is executed under a desired extraction condition on a database storing personal information of employees, and the result is displayed on a matrix of a two-dimensional table. Often it is arranged and displayed. FIG.
4 shows an example of a screen displayed on a dimension table.

In the example shown in FIG. 6, information extraction processing is performed using the qualifications and affiliations of employees as extraction conditions, and the number of employees meeting the conditions is displayed on a matrix. The numbers in parentheses indicate the number of women. For example, there are 2 employees (0 women) who belong to the “Tokyo Sales Headquarters” and have a qualification of “executive”, and 1 employee (0 women has the qualification “Director”).
Person).

[0005]

As a method for generating a web page including such a two-dimensional table,
Conventionally, a method of embedding extraction conditions in a source code of a generated program and hard coding the data has been generally used. That is, in the example of FIG. 6, the extraction condition of the X-axis is “qualification” and the extraction condition of the Y-axis is “affiliation”, and some of the qualifications include “officers”, “directors”, “advisors”. It was hard-coded that there were condition items and that there were condition items such as "Tokyo Sales Headquarters" and "Tokyo Sales Headquarters Open Sales Department".

However, in this case, when it becomes necessary to change the extraction conditions, it is necessary to perform coding for changing the extraction conditions in the source code of the program and recompile. For example, when an organization is revised, such as creating a new qualification, it is necessary to add the contents of the extraction conditions (condition items) accordingly. To do so, it is necessary to modify and recompile the program was there. Usually, a program of a form page for generating a two-dimensional table on the web is very complicated. For this reason, there is a problem that the amount of work for changing the extraction condition is enormous.

Also, due to such a huge amount of work,
It takes a very long time from when it becomes necessary to change the extraction conditions to when a web page on which the change is reflected is actually created. For this reason, there is a problem that it is not possible to respond in real time to a factor of change of the extraction condition such as organizational revision.

Further, since extraction conditions are fixed by hard coding, only a two-dimensional table predetermined by the program can be generated. Therefore, when a request to display a web page of a new two-dimensional table having a different combination of extraction conditions is issued, it is necessary to modify and recompile the program, which requires a great deal of maintenance. There was a problem.

The present invention has been made in order to solve such a problem, and when it becomes necessary to change the extraction conditions, the changed contents are reflected without modifying and recompiling the program. An object of the present invention is to make it possible to easily generate a web page of a two-dimensional table.

[0010]

A web page generating apparatus having a multi-dimensional table according to the present invention executes a process of extracting information on a database according to a plurality of extraction conditions, and uses the extraction result to perform multi-dimensional processing. An apparatus for generating a web page having a multi-dimensional table for generating a web page including a table, comprising: a condition table storage unit configured to store the plurality of extraction conditions as table information; and a plurality of storage units stored in the condition table storage unit. Extraction process executing means for executing the process of extracting the information by using the table information of the designated extraction condition, and the multi-dimensional Page generating means for generating a web page including a table.

[0011] In another aspect of the present invention, there is provided an extraction result storing means for storing the information extracted by the extracting processing means in an arrangement order of the multidimensional table, wherein the page generating means comprises: A web page including the multidimensional table is generated by using information stored in the result storage unit.

In another aspect of the present invention, the information extracted by the extraction processing executing means is a total number of data meeting the specified extraction condition.

In another aspect of the present invention, the information extracted by the extraction processing executing means is stored in the extraction result storing means in association with the first identification information, and the page generating means is provided with Using the first identification information as an argument, necessary information is extracted from the extraction result storage means, and a web page including the multidimensional table is generated.

In another aspect of the present invention, the table information of the plurality of extraction conditions is stored in the condition table storage unit in association with the second identification information, and the extraction process execution unit is configured to execute It is characterized in that table information of extraction conditions is extracted from the condition table storage means based on the second identification information, and a process of extracting the information is executed.

In another aspect of the present invention, the information extraction processing is executed by the extraction processing executing means in advance, and the extracted information is stored in the extraction result storing means. When given, the page generation means generates a web page including the multi-dimensional table using information stored in the extraction result storage means.

In another aspect of the present invention, when the request for providing a web page is given, the extraction processing execution means executes information extraction processing, and the page generation means uses the extracted information to execute the information extraction processing. A web page including the multidimensional table is generated.

In another aspect of the present invention, the extraction processing execution means detects that a change has been made to the table information stored in the condition table storage means, and automatically performs the information extraction processing. The extracted information is stored in the extraction result storage means.

According to another aspect of the present invention, there is provided a table information changing means for automatically changing table information stored in the condition table storing means in response to a change in the contents of the database. .

According to another aspect of the present invention, the request for providing a web page is provided together with the second extraction request indicating desired extraction conditions.
Wherein the extraction processing executing means executes the information extraction processing by using the table information of the extraction condition represented by the given second identification information. And

In another aspect of the present invention, information is stored in a database using a condition table storage means for storing a plurality of extraction conditions as table information and a plurality of table information stored in the condition table storage means. A Web page generation program describing a processing procedure for generating a Web page including a multidimensional table using the extracted information by performing extraction processing, and control means for controlling execution of the Web page generation program. It is characterized by having.

Further, the method of generating a web page having a multidimensional table according to the present invention executes a process of extracting information according to a plurality of extraction conditions on a database,
A method of generating a web page having a multi-dimensional table for generating a web page including a multi-dimensional table using the extraction result, wherein a plurality of extraction conditions are stored as table information from condition table storage means. An extraction processing execution step of extracting table information of specified extraction conditions, executing information extraction processing, sorting the extracted information in the arrangement order of the multidimensional table, and storing the sorted information in an extraction result storage means, and storing the extraction result Generating a web page including the multi-dimensional table using the information stored in the means.

According to another aspect of the present invention, there is provided a multi-dimensional table for executing a process of extracting information on a database in accordance with a plurality of extraction conditions and generating a web page including the multi-dimensional table by using the extraction result. A method of generating a web page, comprising: a condition table storage unit that stores the plurality of extraction conditions as table information;
Extracting the table information of the specified extraction condition, executing the information extraction processing, sorting the extracted information in the arrangement order of the multidimensional table, and storing the extracted information in the extraction result storage means; A page generation step of generating a web page including the multidimensional table using information already stored in the extraction result storage means when a provision request is given.

According to another aspect of the present invention, there is provided a multi-dimensional table for executing a process of extracting information according to a plurality of extraction conditions on a database and generating a web page including the multi-dimensional table using the extraction result. A method of generating a web page, wherein, when a request to provide the web page is given, from a condition table storage unit storing the plurality of extraction conditions as table information,
An extraction processing execution step of extracting table information of designated extraction conditions and executing information extraction processing, and a page generation step of generating a web page including the multidimensional table using the extracted information It is characterized by.

In another aspect of the present invention, in the extracting step, the extracted information is stored in the extraction result storage means in association with the first identification information. The above-mentioned first
Required information is extracted from the extraction result storage means using the identification information of the above as an argument, and a web page including the multidimensional table is generated.

In another aspect of the present invention, the table information of the plurality of extraction conditions is stored in the condition table storage means in association with the second identification information. It is characterized in that table information of extraction conditions is extracted from the condition table storage means based on the second identification information, and a process of extracting the information is executed.

In another aspect of the present invention, the extracting step includes detecting that a change has been made to the table information stored in the condition table storage means.
The information extraction process is automatically executed, and the extracted information is stored in the extraction result storage means.

In another aspect of the present invention, a table which detects that the contents of the database has been changed and automatically changes table information stored in the condition table storage means in accordance with the changed contents. It has an information change step.

In another aspect of the present invention, the request for providing a web page is provided together with the second extraction indicating desired extraction conditions.
In the extracting process executing step, the extracting process of the information is performed using the table information of the extracting condition represented by the obtained second identifying information. Features.

According to another aspect of the present invention, there is provided a Web server which performs a process of extracting information according to a plurality of extraction conditions on a database, and describes a processing procedure for generating a Web page including a multidimensional table using the extracted information. Separately from the page generation program, on a system including a condition table storage unit that stores the plurality of extraction conditions as table information, the web page generation program uses the table information stored in the condition table storage unit, A web page including the multidimensional table is generated.

Further, the web page generation program of the present invention retrieves table information of a designated extraction condition from a condition table storage means storing a plurality of extraction conditions as table information, and according to the retrieved plurality of extraction conditions. An extraction processing execution unit that extracts information on a database, and a computer that functions as a page generation unit that generates a web page including the multidimensional table by using the information extracted by the extraction processing execution unit. is there.

According to another aspect of the present invention, there is provided means for extracting table information of a designated extraction condition from condition table storage means for storing a plurality of extraction conditions as table information, and according to the extracted plurality of extraction conditions. This is for causing a computer to execute a process of extracting information on a database, sort the extracted information in the arrangement order of the multidimensional table included in the web page, and store it in an extraction result storage unit. is there.

According to another aspect of the present invention, table information of a specified extraction condition is extracted from a condition table storage unit storing a plurality of extraction conditions as table information, and is stored in a database in accordance with the extracted extraction conditions. An extraction process executing unit that executes a process of extracting information, sorts the extracted information in the arrangement order of the multidimensional table included in the web page, and stores the information in the extraction result storage unit, and stores the extracted information in the extraction result storage unit It is for causing a computer to function as a page generating means for generating a web page including the multidimensional table using the information thus obtained.

Further, a computer-readable recording medium of the present invention is a program for causing a computer to function as each means according to any one of claims 21 to 23, or any one of claims 12 to 20. A program for causing a computer to execute the processing procedure of the method for generating a web page having a multidimensional table according to claim 1 is recorded.

[0034]

(First Embodiment) A first embodiment of the present invention will be described below with reference to the drawings. FIG.
FIG. 1 is a diagram illustrating a configuration example of an entire network system to which a web page generation device having a multidimensional table according to an embodiment is applied.

In this embodiment, the network system comprises a web server 1 and a database server (hereinafter referred to as D).
B server) 2, client terminal 3, and personal information DB
4 and a condition table storage unit 5. The servers 1 and 2 and the client terminal 3 are communicably connected to each other via a network 6 such as the Internet or an intranet.

In response to a request from the client terminal 3, the web server 1 provides information such as HTML (Hyper Text Markup Language) to the requesting client terminal 3. Specifically, in cooperation with the DB server 2, a process of extracting information according to a plurality of extraction conditions is executed on the personal information DB 4, and a web page including a multidimensional table is generated using the extraction result. To provide.

More specifically, a process of extracting information on the personal information DB 4 is executed in accordance with two designated extraction conditions, and a two-dimensional table is generated and provided using the extracted information. The information provided here is, for example, a two-dimensional table in which the total number of data matching the two specified extraction conditions is represented in a matrix as shown in FIG. Hereinafter, such a two-dimensional table is referred to as a “cross tabulation table”.

The DB server 2 registers personal information on each employee in the company in the personal information DB 4,
A process for extracting and providing necessary personal information from the server 4 is performed.
When providing the client terminal 3 with the HTML screen of the cross tabulation table displayed in a matrix, the web server 1 makes an inquiry to the DB server 2 and acquires necessary information.

The client terminal 3 is a so-called personal computer used by a user such as an employee in a company. On the client terminal 3, a web browser program operates, and the web server 1 and the DB server 2
It is possible to register personal information in the personal information DB 4 and to obtain desired information from the personal information DB 4 through.

That is, the web browser of the client terminal 3 transmits the URL (Uniform Resource) designated by the user.
Locator), the web server 1 having the URL
To provide HTML information. The web server 1 that has received the provision request makes an inquiry to the DB server 2 and obtains necessary information corresponding to the request. Then, a matrix-displayed web page is constructed using the acquired information, and is returned to the web browser as HTML source code.

The web browser analyzes the HTML source code received from the web server 1, and displays text information and the like included in the source code on a screen. By such an exchange between the web server 1 and the web browser of the client terminal 3, the client terminal 3
Will display a web page including a two-dimensional table.

The personal information DB 4 is a flat database that stores personal information on each employee in the company. FIG. 3 shows a personal master table which is an example of the personal information DB4. In the example of FIG. 3, "employee number", "name (kanji)", "name (kana)"
"Affiliation name", "qualification name", etc. are included. The information of the plurality of items is stored in the personal information DB 4 as personal information for each employee in the company.

The condition table storage unit 5 stores a plurality of extraction conditions used for generating a two-dimensional table as table information. FIG. 4 is a diagram illustrating an example of the extraction condition table. FIG. 4A is table information representing extraction conditions corresponding to the X axis of the cross tabulation table shown in FIG. 6, and FIG. 4B is corresponding to the Y axis of the cross tabulation table shown in FIG. This is table information representing extraction conditions.

As shown in FIG. 4A, in the X-axis extraction condition table, items such as "qualification name" and "output key"
"Conditions" exist. In the item of qualification name, a plurality of qualification names ("officer", "director", "advisor", "manager", "general occupation", "clerical occupation", and "contract") displayed on the X-axis of the cross tabulation table are described. In the item of the output key, the arrangement order displayed on the X axis of the cross tabulation table is described. In the condition item, a condition for extracting information from the personal information DB 4 is described.

As shown in FIG. 4B, the Y-axis extraction condition table includes "affiliation name", "output key", and "condition" as items. The affiliation name field contains multiple affiliation names displayed on the Y-axis of the cross tabulation table ("Tokyo Sales Headquarters", "Tokyo Sales Headquarters Open Sales Department", "Tokyo Sales Headquarters Planning Sales Department" ... "Osaka Accounting Headquarters Accounting Department ") Is described. In the item of the output key, the arrangement order displayed on the Y axis of the cross tabulation table is described. In the condition item, a condition for extracting information from the personal information DB 4 is described.

The extraction condition table shown in FIG. 4 is an example showing table information used when generating the cross tabulation table shown in FIG. 6, and is used for generating other two-dimensional tables. Is prepared separately. That is, the condition table storage unit 5 stores a plurality of table information including two extraction condition tables shown in FIG. 4 and other extraction condition tables not shown.

Each of the plurality of extraction condition tables has unique identification information (corresponding to the second identification information of the present invention).
Is given. Here, in order to make the explanation easy to understand, the identification information indicating the extraction condition table of the X axis is represented by X
, Xn, and the identification information indicating the Y-axis extraction condition table is Y1, Y2,..., Yn. The number of extraction condition tables for the X-axis and the Y-axis may not be the same. If the system requires only the cross tabulation table shown in FIG. 6, only the two extraction condition tables (X1 and Y1) shown in FIGS. 4A and 4B need to be provided.

Next, the functional configuration of the web page generation device provided in the web server 1 and the DB server 2 configured as described above will be described. FIG. 2 is a diagram illustrating a functional configuration example of a web page generation device having a multidimensional table according to the first embodiment. As shown in FIG. 2, the web page generation device of the present embodiment includes an extraction process execution unit 11
, Sorting unit 12, cross table information storage unit 13
, A page generation unit 14, and a request reception unit 15.

[0049] The extraction processing execution unit 11 selects one of a plurality of extraction condition tables stored in the condition table storage unit 5.
A process for extracting necessary information from the personal information DB 4 is executed using the table information of the designated extraction condition. In the present embodiment, the designated extraction condition is an extraction condition in which the second identification information is fixed in advance by the source code of the program as the extraction condition necessary for generating the two-dimensional table (the second extraction information is a fixed extraction condition). 2 is fixed and the content of the extraction condition is not fixed).

The extraction processing execution unit 11 actually executes a program recorded on a recording medium such as a hard disk,
The functions are realized by being executed by a microcomputer including a CPU, a ROM, a RAM, and the like. The microcomputer corresponds to the control means of the present invention.

The program of the extraction processing execution unit 11 is represented by the following equation (1). Extraction program (X-axis extraction condition, Y-axis extraction condition, KEY number) (1) This expression (1) is obtained according to the X-axis extraction condition and the Y-axis extraction condition stored in the condition table storage unit 5. Means extracting information from the personal information DB 4 and storing the extraction result in association with the KEY number. KE
The Y number corresponds to the first identification information of the present invention.

For example, the program used to generate the cross tabulation table in FIG. 6 is an extraction program 1 (X
1, Y1, KEY1). In addition to this, when a two-dimensional table is generated, an extraction program for that purpose is separately included, and these are extraction program 2 (X2, Y2, KEY2), extraction program 3 (X3, Y3, KEY3) ... extraction program n (Xn, Yn, KEYn) and so on. In this case, the web page generation program includes n extraction programs.

The sorting section 12 sorts the information extracted by the extraction processing executing section 11 in the arrangement order of the two-dimensional table based on the output keys included in the extraction condition table, and stores the result in the cross table information storage section. 13 is stored. At this time, the sorted cross table information is stored in the cross table information storage unit 13 together with the corresponding KEY number. The cross table information storage unit 13 corresponds to an extraction result storage unit of the present invention.

FIG. 5 is a diagram showing an example of cross table information in which the information extracted by the extraction program 1 is sorted in the arrangement order of the cross tabulation table shown in FIG. The cross tabulation table shown in FIG. 6 is a two-dimensional table for tabulating the number of people by affiliation and by qualification. The cross table information shown in FIG. 5 for generating the information includes the output order of information (X-axis number and Y-axis number based on the output key) and the value of extracted information satisfying the X-axis condition and the Y-axis condition ( And the number of cases including men and women, and the number of cases only for women). The combination of the X-axis number and the Y-axis number indicates an array on a two-dimensional table.

The page generation unit 14 generates a web page including a two-dimensional table using the information stored in the cross table information storage unit 13. At this time, the page generation unit 14 extracts necessary information from the cross table information storage unit 13 using the KEY number given from the request reception unit 15 as an argument, and generates a web page including a two-dimensional table. When the cross table information shown in FIG. 5 is used, a web page as shown in FIG. 6 is generated.

The request receiving unit 15 receives a request for providing a web page including a two-dimensional table from the client terminal 3 via the network 6. In this provision request, a K indicating which two-dimensional table is desired to be provided.
EY number is included. The request receiving unit 15 receives the received KE
The Y number is supplied to the page generator 14. Page generation unit 1
4 extracts necessary information from the cross table information storage unit 13 using the received KEY number as an argument and generates a web page including a two-dimensional table.

In the configuration of the web page generation apparatus as shown in FIG. 2, for example, the extraction processing execution unit 11, the sorting unit 12, and the cross table information storage unit 13 are stored in the DB of FIG.
The page generation unit 14 and the request receiving unit 15 are included in the server 2 and are included in the web server 1 of FIG.

In this embodiment, in the DB server 2,
As preparation for page generation, information extraction processing is executed by the extraction processing execution unit 11 and the extracted information is sorted by the sorting unit 1.
2 and stored in the cross table information storage unit 13. In this preliminary preparation, all of the n extraction programs 1 to n are executed, and the results are all stored in the cross table information storage unit 13 together with the KEY numbers.

Thereafter, when a request for providing a web page is given from the client terminal 3 to the request receiving unit 15 of the web server 1 via the network 6, the page generation unit 14 makes an inquiry to the DB server 2 and The required cross table information is acquired from the cross table information storage unit 13 based on the KEY number given together with the request for providing. Then, a web page including a two-dimensional table is generated using the acquired cross table information.

As described above, the cross table information necessary for generating the two-dimensional table is prepared in advance and stored in the cross table information storage unit 13. Indicates that the extraction results are sorted and arranged in the order of the two-dimensional table. Therefore, the page generation unit 14
Can simply assemble an XY array of a two-dimensional table simply by reading data from the cross table information storage unit 13 in accordance with the order of the array, and can provide a web page in real time in response to a request to provide.

FIG. 7 is a flowchart showing the operation of the apparatus for generating a web page having a multidimensional table according to the present embodiment. Here, the operation is shown separately for the web server 1, the DB server 2, and the client terminal 3.

In FIG. 7, the extraction processing execution section 11 of the DB server 2 executes the X processing stored in the condition table storage section 5.
A plurality of extraction programs 1 to n are executed with reference to the extraction condition table of the axis and the Y axis and the personal master data stored in the personal information DB4, and a summary of information satisfying the extraction conditions indicated by the extraction condition table Data is extracted (step S1).

Next, the sorting section 12 sorts the summary data extracted in step S1 so that the summary data can be output in the XY arrangement order of the two-dimensional table (step S2), and converts the obtained cross table information into a KEY number. The corresponding information is stored in the cross table information storage unit 13 (step S3). With the above, preparations for generating a web page are completed.

On the other hand, the user at the client terminal 3 accesses the web server 1 by inputting the URL of the web server 1 on the web browser and requests acquisition of a web page including a desired two-dimensional table (step S).
4). The web server 1 receiving this request inquires of the DB server 2 about the KEY number included in the request (step S5).

In response to this inquiry, the DB server 2
The cross table information stored corresponding to the KEY number is extracted from the cross table information storage unit 13,
The information is supplied to the page generation unit 14 of the web server 1 (Step S6). The page generation unit 14 generates a web page including the two-dimensional table using the acquired cross table information, and returns it to the web browser of the client terminal 3 (step S7). The web browser displays a web page including the two-dimensional table acquired from the web server 1 on a screen (Step S8).

As described in detail above, in the apparatus for generating a web page having a multi-dimensional table according to the present embodiment, apart from a web page generating program describing a processing procedure for generating a web page including a two-dimensional table,
A plurality of extraction conditions are taken out and stored in the condition table storage unit 5 as an extraction condition table. Then, the web page generation program performs information extraction processing using the extraction condition table stored in the condition table storage unit 5,
Thereby, a web page including a two-dimensional table is generated.

Accordingly, when it is necessary to change the extraction conditions, for example, when an organization is revised such as creating a new qualification, no change is made to the source code of the web page generation program. Instead, it is possible to respond only by changing the contents of the extraction condition table.

For example, when it is desired to add a new qualification of “manager”, the condition data of “manager” may be added to the X-axis extraction condition table of FIG. With this configuration, the web page generation program including the extraction processing execution unit 11, the sorting unit 12, the page generation unit 14, and the like,
The X-axis extraction condition table and the Y-axis extraction condition table to which the condition item of “manager” has been added are read, and the above processing is executed to generate a cross tabulation table reflecting the contents of the organization revision.

That is, according to the present embodiment, the data of the extraction condition table stored in the condition table storage unit 5 can be reflected in the two-dimensional table only by maintaining the data. There is no need to compile at all. Therefore, the amount of work required for maintenance can be significantly reduced. Also, when it becomes necessary to change the extraction conditions,
The time until the web page on which the change is actually reflected can be greatly reduced, and the factor of the extraction condition change can be responded in real time.

In the above embodiment, the second identification information for identifying the extraction condition table is given to the extraction condition table, but the second identification information is not always necessary. In the present embodiment, it is sufficient that there is at least a KEY number that is the first identification information.

Further, in the above embodiment, the extraction processing execution unit 11, the sorting unit 12, and the cross table information storage unit 1
3 is provided in the DB server 2 and the page generating unit 14 and the request receiving unit 15 are provided in the web server 1, but the present invention is not limited to this. For example, the page generation unit 14 may be included in the DB server 2. Alternatively, the DB server 2 may include only the extraction processing execution unit 11 and the web server 1 may include the rest. In addition, web server 1
One server may have the functional configuration of each of the blocks 11 to 15 without being separated into the database server 2 and the DB server 2.

In the above embodiment, the extracted information values and the output order (2
In addition to this, the title (title) to be displayed on the XY axes is stored.
For example, information other than the extraction result itself may be stored. In this case, the page generation unit 14 generates a web page by taking in other information such as a title together with the cross table information.

(Second Embodiment) Next, a second embodiment of the present invention will be described. In a second embodiment,
The configuration of the entire network system to which a web page generation device having a multidimensional table is applied is the same as that in FIG.

FIG. 8 is a diagram showing an example of a functional configuration of a web page generation device having a multidimensional table according to the second embodiment. Note that in FIG. 8, components denoted by the same reference numerals as those illustrated in FIG. 2 have the same functions, and thus redundant description will be omitted here.

As shown in FIG. 8, the web page generation device of the present embodiment includes an extraction processing execution unit 21 instead of the extraction processing execution unit 11 shown in FIG. Further, in addition to the extraction processing execution unit 21, the sorting unit 12, the cross table information storage unit 13, the page generation unit 14, and the request reception unit 15, an identification table storage unit 22 is included.

FIG. 9 is a diagram showing an example of the identification table. This identification table includes second identification information for identifying the X-axis and Y-axis extraction condition tables, and a first identification for identifying a two-dimensional table generated based on information extracted based on the extraction conditions of these extraction condition tables. Identification information (KE
(Y number).

KEY1 to KEYn indicate the same correspondence as described in the first embodiment.
The identification number (second identification information) of the extraction condition table for the EY number (first identification information) is fixed in advance. For example, the X-axis and Y-axis extraction condition tables for the two-dimensional table of KEY1 are fixed to X1 and Y1. On the other hand, KEYi is newly provided in the second embodiment, and an X-axis extraction condition table Xj and a Y-axis extraction condition table Yk can be arbitrarily designated from the client terminal 3.

The extraction processing execution unit 21, like the extraction processing execution unit 11 shown in FIG. 2, stores table information of a specified extraction condition among a plurality of extraction condition tables stored in the condition table storage unit 5. Then, a process for extracting necessary information from the personal information DB 4 is executed. However, in the present embodiment, the designated extraction condition refers to an extraction condition designated based on the identification table stored in the identification table storage unit 22. KEY1 to KEYn are the first
Although the second identification information is a fixed extraction condition as in the case of the third embodiment, it is possible to specify the X-axis and Y-axis second identification information in any combination for KEYi.

In the first embodiment, the extraction processing execution section 11 performs the extraction program 1 (X1, Y1, KEY1) extraction program 2 (X2, Y2, KEY2)... The extraction program n (Xn, Yn, KEYn). And had multiple extraction programs. On the other hand, the extraction process execution unit 21 of the present embodiment includes only one extraction program represented by Expression (2). Extraction program (X-axis extraction condition, Y-axis extraction condition, KEY number) ... (2)

When the information extraction process is actually performed, the X-axis extraction condition table and the Y-axis extraction condition table corresponding to the KEY number given by the request receiving unit 15 are referred to by referring to the identification table in the identification table storage unit 22. Get the identification number of Then, the extraction condition table corresponding to the identification number is read from the condition table storage unit 5, and is applied to the extraction program of Expression (2) to perform information extraction processing.

That is, when the request receiving unit 15 receives a request for providing a web page including a two-dimensional table from the client terminal 3 via the network 6, the request receiving unit 15 extracts the KEY number included in the request. Execution unit 2
Feed to 1. The extraction processing execution unit 21 receives the KE
The identification table is referred to by using the Y number as an argument, a plurality of extraction condition tables associated with the identification table are extracted from the condition table storage unit 5, and a process of extracting information is executed.

When an arbitrary combination of the X-axis extraction condition table and the Y-axis extraction condition table is designated by using KEYi, the KEY number (KEY
In addition to Yi), the identification number (Xj, Yk) of the specified extraction condition table is also included and transmitted from the client terminal 3 to the web server 1.

The request receiving unit 15 extracts the received KEY number and the identification number of the extraction condition table from the extraction processing execution unit 2.
Feed to 1. The extraction processing execution unit 21 receives the KE
A process of storing the Y number and the condition table identification number in a portion corresponding to KEYi, taking out the KEYi as an argument, extracting an extraction condition table associated therewith from the condition table storage unit 5, and extracting information. Execute

In this example, when KEYi is used, the KEY number and the condition table identification number received by the extraction processing execution unit 21 are temporarily stored in the identification table storage unit 22, and then linked to the KEY number. Although the attached extraction condition table is taken out from the condition table storage unit 5, the process of storing it in the identification table storage unit 22 is not always necessary.

That is, in the identification table, KEYi
Is not necessarily required. In this case, the extraction processing execution unit 21 extracts the extraction condition table from the condition table storage unit 5 based on the specified condition table identification number transmitted from the request reception unit 15 and sends the extracted information to the sorting unit 12 based on the extraction condition table. Supply. The sorting unit 12 stores the cross table information of the sorting result in the cross table information storage unit 13 in association with the KEY number KEYi. In such a case, the web page provision request only needs to include the specified condition table identification number, and does not necessarily need to include the KEY number KEYi.

In the configuration of the web page generation apparatus as shown in FIG. 8, for example, the extraction processing execution unit 21, the sorting unit 12, the cross table information storage unit 13, and the identification table storage unit 22 are included in the DB server 2 of FIG. The page generating unit 14 and the request receiving unit 15 correspond to the web server 1 shown in FIG.
include.

In this embodiment, the DB server 2 does not perform the preparation process for page generation. That is,
When a request for providing a web page is given from the client terminal 3 to the request receiving unit 15 of the web server 1 via the network 6, the request receiving unit 15 makes an inquiry to the DB server 2. In response, the extraction process execution unit 21
Extracts the X-axis and Y-axis extraction condition tables specified based on the KEY number given from the request receiving unit 15 from the condition table storage unit 5 and executes information extraction processing on the personal information DB 4.

Then, the extracted information is sorted by the sorting section 12 and stored in the cross table information storage section 13. Therefore, the cross table information storage unit 13 stores
Only the cross table information necessary to generate the two-dimensional table requested to be provided is stored. The page generation unit 14 generates a web page including a two-dimensional table using the cross table information stored in the cross table information storage unit 13.

FIG. 10 is a flowchart showing the operation of the apparatus for generating a web page having a multidimensional table according to the second embodiment. In FIG. 10, the user at the client terminal 3 accesses the web server 1 by inputting the URL of the web server 1 on a web browser,
Request acquisition of a web page including a desired two-dimensional table (step S11). Upon receiving this request, the request receiving unit 15 of the web server 1 transmits the K included in the request.
Inquiry of the EY number to the DB server 2 (step S1)
2).

In response to this inquiry, the extraction processing execution unit 21 of the DB server 2 refers to the identification table storage unit 22 and refers to the X-axis and Y-axis linked to the given KEY number.
The axis extraction condition table is extracted from the condition table storage unit 5. Then, the extraction program is executed with reference to the extracted X-axis and Y-axis extraction condition tables and the personal master data stored in the personal information DB 4, and information of the information satisfying the extraction conditions indicated by the extraction condition table is obtained. The summary data is extracted (step S13).

Next, the sorting section 12 sorts the summary data extracted in step S13 so that the summary data can be output in the XY arrangement order of the two-dimensional table (step S14), and converts the obtained cross table information into a KEY number. The corresponding information is stored in the cross table information storage unit 13 (step S15). Further, the DB server 2 supplies the cross table information stored in the cross table information storage unit 13 to the page generation unit 14 of the web server 1 (Step S16).

The page generation unit 14 generates a web page including a two-dimensional table using the acquired cross table information, and returns it to the web browser of the client terminal 3 (step S17). The web browser displays a web page including the two-dimensional table acquired from the web server 1 on a screen (Step S18).

As described in detail above, in the web page generation apparatus having a multidimensional table according to the second embodiment, apart from the web page generation program, a plurality of extraction conditions are taken out and set as the extraction condition table. It is stored in the table storage unit 5. Then, the web page generation program performs an information extraction process using the extraction condition table stored in the condition table storage unit 5, thereby generating a web page including a two-dimensional table.

Thus, when it is necessary to change the contents of the extraction conditions, for example, when the organization is revised such as creating a new qualification, no change is made to the source code of the web page generation program. This can be dealt with simply by changing the contents of the extraction condition table without adding.

Further, in the second embodiment, even when the user wants to obtain a two-dimensional table other than the two-dimensional table prepared in advance by the source code of the web page generation program, the user can select an arbitrary extraction condition table. An arbitrary two-dimensional table can be obtained by requesting provision of a web page by designating the combination of. In this case, it is possible to deal with the source code of the web page generation program without making any changes.

That is, according to the present embodiment, the data of the extraction condition table in the condition table storage unit 5 can be reflected in the two-dimensional table only by maintaining the data.
There is no need to modify or recompile the web page generation program at all. Therefore, the amount of work required for maintenance can be significantly reduced. Also,
The time from when it becomes necessary to change the extraction conditions to the time when a web page reflecting the change is created can be significantly reduced, and the factors of the extraction conditions can be responded in real time. .

In the above-described embodiment, the DB server 2 includes the extraction processing execution unit 21, the sorting unit 12, the cross table information storage unit 13, and the identification table storage unit 22, and the request reception unit 15 and the page generation unit 14 Server 1
However, the present invention is not limited to this. For example,
The page generation unit 14 may also be included in the DB server 2. Alternatively, the DB server 2 may include only the extraction process execution unit 21 and the identification table storage unit 22, and the web server 1 may include the rest. Further, the function configuration of each block may be provided by one server without being separated into the web server 1 and the DB server 2.

In the above embodiment, the values of the extracted information and the output order (2
In addition to this, the title (title) to be displayed on the XY axes is stored.
For example, information other than the extraction result itself may be stored. In this case, the page generation unit 14 generates a web page by taking in other information such as a title together with the cross table information.

Further, in the above embodiment, only one extraction program of the extraction processing execution unit 21 is prepared, and
Although the extraction condition table specified by the number is applied and executed, the present invention is not limited to this. For example, a plurality of extraction programs are prepared as in the first embodiment,
The extraction program specified by the KEY number may be selectively executed.

Further, in the first embodiment, the extraction processing execution unit 11 has a plurality of extraction programs, and executes all of them at the preparation stage. However, as in the second embodiment, Prepare only one extraction program,
A plurality of combinations of extraction condition tables may be sequentially applied to this and executed.

(Third Embodiment) Next, a third embodiment of the present invention will be described. In a third embodiment,
The configuration of the entire network system to which a web page generation device having a multidimensional table is applied is the same as that in FIG.

FIG. 11 is a diagram showing an example of a functional configuration of a web page generation device having a multidimensional table according to the third embodiment. Note that in FIG. 11, components denoted by the same reference numerals as those illustrated in FIG. 2 have the same functions, and thus redundant description will be omitted.

As shown in FIG. 11, the web page generating apparatus according to the present embodiment includes the extraction process execution unit 11 shown in FIG.
In addition to the sorting unit 12, the cross table information storage unit 13, the page generation unit 14, and the request reception unit 15, the change monitoring unit 3
Contains one. The change monitoring unit 31 monitors whether or not the contents of the extraction condition table stored in the condition table storage unit 5 have been changed.

The extraction execution unit 11 monitors the change monitoring unit 31 to respond to a change in the extraction condition table in the condition table storage unit 5, for example, in response to an organizational revision such as creation of a new qualification. When it is detected that the contents of the extraction condition table have been changed, information extraction processing is automatically executed, and the extracted information is sorted by the sorting unit 12 and stored in the cross table information storage unit 13.

As described above, when the contents of the extraction condition table stored in the condition table storage unit 5 are rewritten by the user, the generation processing can be performed even if the user does not explicitly issue a generation instruction of the cross table information. It is automatically executed, and cross table information corresponding to the change of the extraction condition table is stored in the cross table information storage unit 13. As a result, it is possible to reduce the load of the operation of generating the cross table information performed by the user as a preparation for generating the web page.

Conventionally, the extraction conditions are also hard-coded in the web page generation program. Therefore, changing the extraction conditions means changing the web page generation program itself, and the program could not be executed without recompiling. However, in the present embodiment, since the extraction conditions are outside the web page generation program, even if the extraction conditions are changed, the program itself does not need to be changed and can be executed without recompilation. .
Therefore, it is possible to execute the automatic generation of the cross table information with the change of the extraction condition as a trigger.

As shown by the dotted line in FIG. 11, a change monitoring unit 32 and a condition table changing unit 33 may be further provided. The change monitoring unit 32 monitors whether a predetermined change has been made to the contents of the personal master data stored in the personal information DB 4. For example, when there is an organizational revision such as creation of a new qualification or affiliation, the master data in the personal information DB 4 is usually changed accordingly. The change monitoring unit 32 monitors such changes of the personal master data.

The condition table changing unit 33 is provided with the change monitoring unit 3
When the monitoring of step 2 detects that a change affecting the extraction condition table has been made to the personal master data, the contents of the extraction condition table stored in the condition table storage unit 5 are automatically updated accordingly. Change. For example, when a new qualification is added on the personal master data, a change is made so that the added qualification is reflected in the extraction condition table. At this time, the output key is given, for example, the number following the number already given in ascending order.

As described above, when a change is made to the extraction condition table in the condition table storage unit 5, the change is detected by the change monitoring unit 31. In response to this, the extraction processing execution unit 11 automatically executes the information extraction processing, and the extracted information is sorted by the sorting unit 12 and stored in the cross table information storage unit 13.

In this case, when the contents of the personal master data stored in the personal information DB 4 are rewritten by the user, the user does not need to explicitly rewrite the extraction condition table in the condition table storage unit 5 to perform the extraction. Rewriting of the condition table and generation processing of the cross table information are automatically executed. That is, the cross table information corresponding to the change of the personal master data is automatically generated and stored in the cross table information storage unit 13. As a result, it is possible to significantly reduce the load involved in the operation of generating the cross table information performed by the user as a preparation for generating the web page.

The web page generating apparatus having the multi-dimensional table according to the first to third embodiments described above includes:
Computer CPU or MPU, RAM, ROM
And the like, and can be realized by operating a program stored in a RAM or a ROM. Therefore, the present invention can be realized by recording a program that causes a computer to perform the above function on a recording medium such as a CD-ROM and reading the program into the computer.

As a recording medium for recording the above program, a floppy (registered trademark) disk, a hard disk, a magnetic tape, an optical disk, a magneto-optical disk, a DVD, a nonvolatile memory card, and the like can be used in addition to the CD-ROM.

The functions of the above-described embodiments are implemented when the computer executes the supplied program, and the program is executed by an OS (operating system) or other application software running on the computer. When the functions of the above-described embodiment are realized in cooperation with the computer, or when all or a part of the processing of the supplied program is performed by a function expansion board or a function expansion unit of a computer, the functions of the above-described embodiment are realized Such a program is also included in the embodiment of the present invention.

The above embodiments are used in a network environment, and all or some of the programs of the web server 1, the DB server 2, and the client terminal 3 may be downloaded via the Internet or the like. good. Further, all or a part of this program may be executed by another computer.

In the first to third embodiments described above, personal master data in a company is described as an example of the flat database, but the present invention is not limited to this. In addition, as an example of the two-dimensional table, a cross tabulation table for each affiliation and each qualification has been described.

For example, as the flat database, sales detailed data having items such as a store code, a product code, and a sales amount may be used. In this case, for example, a total sales list for each store and each product can be generated as a two-dimensional cross total table. In addition, a two-dimensional table such as a cross maximum value, a cross minimum value, and a cross average value can be generated.

In the above-described embodiment, an example has been described in which a two-dimensional table is generated using two extraction condition tables. However, a three-dimensional or more cross table is generated using three or more extraction condition tables. You may do it.
In this case, displaying a three-dimensional table or more on a two-dimensional screen is problematic. For example, a two-dimensional table is displayed for the time being, and a three-dimensional table is displayed in response to clicking a predetermined place with a mouse. This can be realized by displaying information of dimensions or more in a pop-up display or in another window.

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

[0119]

As described above, according to the present invention, a plurality of extraction conditions are stored outside the table as table information separately from the web page generation program, and the web page generation program uses the extraction condition table information to perform multi-dimensional use. Because the web page including the table is generated, even when the extraction conditions need to be changed, without changing or recompiling the program, just changing the extracted extraction condition table information, It is possible to easily generate a web page of a multi-dimensional table reflecting the changed content. Therefore, the amount of work required for maintenance can be remarkably reduced, and it is possible to respond in real time to the cause of the change of the extraction condition.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration example of an entire network system to which a web page generation device having a multidimensional table according to an embodiment is applied.

FIG. 2 is a diagram illustrating an example of a functional configuration of a web page generation device having a multidimensional table according to the first embodiment.

FIG. 3 is a diagram showing a personal master table which is an example of a personal information DB.

FIG. 4 is a diagram showing an example of an extraction condition table;

FIG. 5 is a diagram illustrating an example of cross table information in which information extracted by an extraction program is sorted in the arrangement order of a cross tabulation table.

FIG. 6 is a diagram illustrating an example of a screen displaying a two-dimensional table.

FIG. 7 is a flowchart illustrating an operation of the web page generation device having a multidimensional table according to the first embodiment.

FIG. 8 is a diagram illustrating a functional configuration example of a web page generation device having a multidimensional table according to a second embodiment.

FIG. 9 is a diagram illustrating an example of an identification table.

FIG. 10 is a flowchart illustrating an operation of a web page generation device having a multidimensional table according to the second embodiment.

FIG. 11 is a diagram illustrating an example of a functional configuration of a web page generation device having a multidimensional table according to a third embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Web server 2 DB server 3 Client terminal 4 Personal information DB 5 Condition table storage part 6 Network 11 Extraction processing execution part 12 Sorting part 13 Cross table information storage part 14 Page generation part 15 Request reception part 21 Extraction processing execution part 22 Identification table Storage unit 31 Change monitoring unit 32 Change monitoring unit 33 Condition table changing unit

Claims (25)

[Claims] 1. A web page generation apparatus having a multi-dimensional table for executing a process of extracting information according to a plurality of extraction conditions on a database and generating a web page including the multi-dimensional table using the extraction result. A condition table storage means for storing the plurality of extraction conditions as table information; and a plurality of table information stored in the condition table storage means, using table information of a designated extraction condition, Extraction processing execution means for executing processing for extracting information, and using the information extracted by the extraction processing execution means,
A web page generation device having a multi-dimensional table, comprising: a page generation means for generating a web page including the multi-dimensional table. 2. An extraction result storage means for storing information extracted by the extraction processing execution means in the order of arrangement of the multidimensional table and storing the information, wherein the page generation means is stored in the extraction result storage means. The apparatus for generating a web page according to claim 1, further comprising: generating a web page including the multi-dimensional table using the generated information. 3. The multi-dimensional table according to claim 1, wherein the information extracted by the extraction processing execution means is the total number of data that matches the specified extraction condition. Web page generation device. 4. The method according to claim 1, wherein the information extracted by the extraction processing execution means is stored in the extraction result storage means in association with first identification information, and the page generation means specifies the specified first identification information. The apparatus for generating a web page having a multi-dimensional table according to claim 2, wherein necessary information is extracted from the extraction result storage means using information as an argument, and a web page including the multi-dimensional table is generated. 5. The method according to claim 1, wherein the table information of the plurality of extraction conditions is stored in the condition table storage unit in association with second identification information, and the extraction processing execution unit is configured to store the specified second identification information. The multi-dimensional table according to any one of claims 1 to 4, wherein table information of extraction conditions is extracted from the condition table storage unit based on the information, and a process of extracting the information is executed. Web page generation device. 6. An information extraction process executed by the extraction process execution means in advance, the extracted information is stored in the extraction result storage means, and when the web page provision request is given, The web page including the multi-dimensional table according to claim 4, wherein the page generating unit generates a web page including the multi-dimensional table using information stored in the extraction result storing unit. Generator. 7. When a request for providing the web page is given, information extraction processing is executed by the extraction processing execution means, and the page generation means includes the multidimensional table using the extracted information. The apparatus for generating a web page having a multidimensional table according to claim 5, wherein the apparatus generates a web page. 8. The extraction processing execution means detects that a change has been made to the table information stored in the condition table storage means, and automatically executes the information extraction processing to extract the extracted information. 7. The apparatus for generating a web page having a multidimensional table according to claim 6, wherein the web page is stored in the extraction result storage means. 9. The apparatus according to claim 8, further comprising table information changing means for automatically changing table information stored in said condition table storing means in response to a change in the contents of said database. An apparatus for generating a web page having a multidimensional table. 10. Along with the web page provision request,
The second identification information representing a desired extraction condition is provided, and the extraction processing execution means uses the table information of the extraction condition represented by the given second identification information to obtain the information. 8. An extraction process is performed.
An apparatus for generating a web page having a multidimensional table according to claim 1. 11. A condition table storage means for storing a plurality of extraction conditions as table information, and a process of extracting information on a database using a plurality of table information stored in the condition table storage means. Using the extracted information, a web page generation program describing a processing procedure for generating a web page including a multi-dimensional table, and control means for controlling execution of the web page generation program. For generating a web page having a multidimensional table. 12. A method for generating a web page having a multi-dimensional table for executing a process of extracting information on a database according to a plurality of extraction conditions and using the extraction result to generate a web page including the multi-dimensional table. Then, the table information of the designated extraction condition is taken out from the condition table storage means storing the plurality of extraction conditions as table information, the information is extracted, and the extracted information is stored in the multi-dimensional table. An extraction process execution step of sorting in the arrangement order and storing the result in the extraction result storage means; and a page generation step of generating a web page including the multidimensional table using the information stored in the extraction result storage means. A method for generating a web page having a multidimensional table, characterized by the following. 13. A method for generating a web page having a multi-dimensional table for executing a process of extracting information according to a plurality of extraction conditions on a database and generating a web page including the multi-dimensional table using the extraction result. Then, the table information of the designated extraction condition is taken out from the condition table storage means storing the plurality of extraction conditions as table information, the information is extracted, and the extracted information is stored in the multi-dimensional table. An extraction processing execution step of sorting in the arrangement order and storing the result in the extraction result storage means, and when the web page provision request is given, using information already stored in the extraction result storage means,
Generating a web page including the multi-dimensional table. A method for generating a web page having a multi-dimensional table. 14. A method for generating a web page having a multi-dimensional table for executing a process of extracting information according to a plurality of extraction conditions on a database and generating a web page including the multi-dimensional table using the extraction result. When the web page provision request is given, the table information of the designated extraction condition is extracted from the condition table storage means storing the plurality of extraction conditions as table information, and the information is extracted. And generating a web page including the multi-dimensional table using the extracted information. A method for generating a web page having a multi-dimensional table. 15. The extracting process execution step, wherein the extracted information is stored in the extraction result storage means in association with first identification information. In the page generating step, the designated first The Web page including the multi-dimensional table according to claim 12 or 13, wherein necessary information is extracted from the extraction result storage unit using the identification information as an argument, and a web page including the multi-dimensional table is generated. Generation method. 16. The table information of the plurality of extraction conditions is stored in the condition table storage means in association with second identification information, and in the extraction processing execution step, the designated second identification information is 15. The method for generating a web page having a multidimensional table according to claim 12, wherein table information of extraction conditions is extracted from the condition table storage means, and a process of extracting the information is executed. 17. The extracting process execution step detects that a change has been made to the table information stored in the condition table storage means, automatically executes the information extracting process, and extracts the extracted information. The method of generating a web page having a multi-dimensional table according to claim 13 or 15, wherein is stored in the extraction result storage means. 18. A table information changing step of detecting that the contents of the database has been changed, and automatically changing table information stored in the condition table storage means in accordance with the changed contents. The method for generating a web page having a multi-dimensional table according to claim 17, wherein: 19. A request for providing the web page,
The second identification information indicating a desired extraction condition is provided. In the extracting process execution step, the second obtained identification information is obtained.
The method for generating a web page having a multidimensional table according to claim 14 or 16, wherein the information extraction processing is executed using table information of extraction conditions represented by the identification information. 20. A process for extracting information according to a plurality of extraction conditions on a database, and using the extracted information, separately from a web page generation program describing a processing procedure for generating a web page including a multidimensional table. In a system including a condition table storage unit that stores the plurality of extraction conditions as table information, the web page generation program includes the multidimensional table using the table information stored in the condition table storage unit. A method for generating a web page having a multidimensional table, wherein the web page is generated. 21. Extraction processing for extracting table information of a designated extraction condition from a condition table storage unit storing a plurality of extraction conditions as table information, and extracting information on a database according to the extracted extraction conditions. A web page generation program for causing a computer to function as a page generation unit that generates a web page including the multidimensional table using information extracted by the execution unit and the extraction process execution unit. 22. A means for extracting table information of a designated extraction condition from condition table storage means for storing a plurality of extraction conditions as table information, and extracting information on a database in accordance with the extracted plurality of extraction conditions. A web page generation program for causing a computer to function as a unit that executes a process of performing the above processing, sorts the extracted information in the arrangement order of the multidimensional table included in the web page, and stores the information in the extraction result storage unit. 23. A process for extracting table information of a specified extraction condition from a condition table storage unit storing a plurality of extraction conditions as table information, and extracting information on a database according to the extracted extraction conditions. The extracted and executed information is sorted by the arrangement order of the multidimensional table included in the web page and stored in the extraction result storage means. The extraction processing execution means and the information stored in the extraction result storage means are used. A web page generation program for causing a computer to function as page generation means for generating a web page including the multidimensional table. 24. A computer-readable recording medium having recorded thereon a program for causing a computer to function as each of the means according to claim 21. 25. A computer readable program recorded with a program for causing a computer to execute a processing procedure of a method for generating a web page having a multidimensional table according to claim 12. Recording medium.