JP6670883B2 - Information processing apparatus, information processing system, information processing method and program - Google Patents

Description

  The present invention relates to an information processing device, an information processing system, an information processing method, and a program.

DWH (DATA WARHOUSE) has conventionally been used as a mechanism for collecting and analyzing various data existing inside and outside a company. The DWH is a mechanism that collects and accumulates data generated every day in a backbone system or the like in one place (CWH (CENTRAL AREHOUSE, hereinafter referred to as a backbone database)). The stored data is used for analysis by an information system application such as BI (Business Intelligence).
When performing data analysis by an information application, there are various needs such as data management in a format suitable for each application and management of access authority on a user basis. Therefore, data required for each application or each user is extracted, an individual Mart (hereinafter, an individual table) is constructed, and data analysis is performed with reference to the individual table.
Patent Literature 1 discloses a mechanism for automatically generating an individual table according to an instruction from a screen by a user with respect to the construction of an individual table.

JP-A-2002-366401

Conventionally, in data analysis using a core database and individual tables as in Patent Document 1, the data flow has been one-way (core application → core database → individual table → information application). Each user can freely construct an individual table and display data, but cannot write comments and the like in the individual table.
Therefore, an object of the present invention is to write a comment or the like in an individual table and allow the comment or the like written in the individual table to be referenced later together with the individual table.

Therefore, an information processing apparatus according to the present invention is an information processing apparatus used for data analysis using DATA WARE HOUSE (DWH). Adding means for adding a column in which additional data can be written to the individual table in response to a column addition instruction for an individual table that is a table from which specific data has been extracted; and the adding performed via the terminal device Writing means for writing additional data to the writable column in response to an additional data writing instruction for the writable column added by the means; and writing the additional data written by the writing means to data in the CWH. And the data in the individual table In association with the order of the identifiers includes a recording means for recording said CWH, said CWH is a data store for managing data in the key to identify a corresponding value, the value and, pairs Key Value Store (KVS) .

  According to the present invention, a comment or the like can be written in an individual table, and the comment or the like written in the individual table can be referred to later together with the individual table.

FIG. 1 is a diagram illustrating an example of a system configuration of the information processing system. FIG. 2 is a diagram illustrating an example of a hardware configuration of a database server or the like. FIG. 3 is a diagram illustrating an outline of processing of the information processing system. FIG. 4A is a flowchart illustrating an example of a write data recording process. FIG. 4B is a flowchart illustrating an example of a write data recording process. FIG. 5 is a diagram illustrating an example of recorded data in the core database. FIG. 6 is a diagram illustrating an example of the generated individual table and the like. FIG. 7 is a diagram illustrating an example of recorded data in the core database. FIG. 8 is a flowchart illustrating an example of the display processing of the individual table. FIG. 9 is a diagram illustrating an example of the displayed individual table and the like.

Hereinafter, embodiments of the present invention will be described with reference to the drawings. Hereinafter, the core database is a database that integrally manages data. CWH and the like are examples of a core database. The individual table is a table in which only specific data is extracted from the core database, and is used for external reference. Mart and the like are examples of individual tables. In the present embodiment, data in the core database and data in the individual table are associated based on the identifier. More specifically, the Value data corresponding to the Key including the same identifier in the backbone database corresponds to the data in the record having the same identifier in the individual table.
The information processing system according to the present embodiment adds a user-writable column to an individual table in order to aggregate the data analysis results of each user so that other users can easily use the data analysis results. Hereinafter, data such as a comment written to the added writable column is referred to as additional data.
When the user writes additional data in the added writable column, the information processing system records the written content in the core database in association with the identifier of the record in the individual table. I do. A record is data for one case, and is data for one row in a table.
However, when the core database is constructed by the RDB, the information processing system needs to change the table definition in order to add a new column to the core database. Therefore, the user has to take the trouble of the table definition changing process in order to record the writable columns.

Therefore, in the present embodiment, the information processing system generates an individual table including a writable column constructed by the Relational Data Base from a key database constructed by a Key Value Store (KVS), a Daifuku book model, or the like.
Then, the information processing system records the contents of the column of the individual table in which the additional data has been written by the user in association with the identifier of the record of the individual table in the core database. The information processing system can freely add new columns of information to the backbone database constructed with the KVS, Daifukusho model, and the like. The information processing system outputs a column recorded in the core database in response to a request from another user.
KVS is a data store that manages data in pairs of "keys" and "values", and can freely define columns without being bound by a fixed schema (table definition or the like). The Daifuku book model is a database model of a type that accumulates generated data as it is without summarizing it. There is no restriction on column definition, and columns can be freely defined.

FIG. 1 is a diagram illustrating an example of a system configuration of the information processing system.
The information processing system according to the present embodiment includes a database server 100, terminal devices 110 and 120, and the like. The database server 100 and the terminal devices 110 and 120 are mutually connected via a network 130.

The database server 100 includes an information processing device such as a computer. The database server 100 includes a backbone database, extracts data from the backbone database according to an instruction from the terminal device 110 or the like, and generates an individual table such as MART.
The terminal devices 110 and 120 include information applications. The information system application is an application used to instruct the core database to generate an individual table, refer to the generated individual table, and write in a writable column in the individual table. The terminal devices 110 and 120 instruct the database server 100 to generate a table, refer to the generated table, and update the contents of the generated table via the information application and the network 130. I do.

FIG. 2 is a diagram illustrating an example of a hardware configuration of the database server 100 and the like.
FIG. 2A illustrates an example of a hardware configuration of the database server 100. The database server 100 includes a CPU 101, a main storage device 102, an auxiliary storage device 103, a network interface 104, and the like. The CPU 101, the main storage device 102, the auxiliary storage device 103, and the network interface 104 are mutually connected via a system bus 105.

The CPU 101 is a central processing unit that controls the database server 100. The main storage device 102 functions as a work area for the CPU 101 and a temporary storage area for data. The auxiliary storage device 103 records data of the main database, individual tables, and the like, and also records various programs executed by the CPU 101 and the like. The network interface 104 is used for connection to an external device via the network 130.
When the CPU 101 executes a process based on the program recorded in the auxiliary storage device 103, a function of the database server 100 described later and a process of a flowchart described later are realized.

FIG. 2B illustrates an example of a hardware configuration of the terminal device 110. The terminal device 110 includes a CPU 111, a main storage device 112, an auxiliary storage device 113, a network interface 114, a display device 115, an input device 116, and the like. The CPU 111, the main storage device 112, the auxiliary storage device 113, the network interface 114, the display device 115, and the input device 116 are interconnected via a system bus 117.
The CPU 111 is a central processing unit that controls the terminal device 110. The main storage device 112 functions as a work area for the CPU 111 and a temporary storage area for data. The auxiliary storage device 113 stores various programs executed by the CPU 111 and the like.

The network interface 114 is used for connection with an external device via the network 130. The display device 115 is a display device such as a display that displays a screen or the like of an information application. The input device 116 is an input device such as a mouse and a keyboard used for input to the terminal device 110.
When the CPU 111 executes a process based on the program recorded in the auxiliary storage device 113, a function of the terminal device 110 described later and a process of a flowchart described later are realized.

The hardware configuration of the terminal device 120 is the same as the hardware configuration of the terminal device 110.
When the CPU of the terminal device 120 executes a process based on a program recorded in the auxiliary storage device of the terminal device 120, a function of the terminal device 120 described later and a process of a flowchart described later are realized.

FIG. 3 is a diagram illustrating an outline of processing of the information processing system. The core database in the database server 100 records master data, transaction data, and other data.
The terminal device 110 instructs the database server 100 via an internal information application to generate an individual table including a column composed of data extracted from the core database and a writable column. Further, the terminal device 110 can also instruct the database server 100 to add a writable column to an existing individual table via an internal information application.
The database server 100 generates an individual table including a column composed of data extracted from the core database and a writable column in response to an instruction from the terminal device 110, or generates an individual table for an existing individual table. Add a writable column.

The terminal device 110 writes additional data to a writable column of the individual table via the information application.
The database server 100 records the additional data written in the writable column of the generated individual table in the core database.
Hereinafter, details of the processing of the information processing system will be described.

4A and 4B are diagrams illustrating an example of a write data recording process. In the present embodiment, a process of an information processing system will be described by taking, as an example, a process in which a researcher at a research laboratory of a pharmaceutical company records evaluation data for a compound in a core database.
The processing of S401 to S409 is processing in the database server 100.
In step S401, the CPU 101 receives an operation instruction for an individual table from the terminal device 110. The processing in S401 corresponds to the processing in S411.

In S402, the CPU 101 determines whether an existing individual table exists. More specifically, the CPU 101 determines whether there is an individual table indicated by the individual table designation information included in the individual table operation instruction received in S401. If the CPU 101 determines that an existing individual table exists, the process proceeds to S403. If the CPU 101 determines that the existing individual table does not exist, the process proceeds to S404.
In step S403, the CPU 101 determines whether the operation instruction of the individual table received in step S401 includes an instruction to add or delete a data writable column. When the CPU 101 determines that the operation instruction of the individual table received in S401 includes an instruction to add or delete a column in which data can be written, the process proceeds to S405. If the CPU 101 determines that the operation instruction of the individual table received in S401 does not include an instruction to add or delete a column to which data can be written, the process proceeds to S408.
In S404, the CPU 101 determines whether or not the operation instruction of the individual table received in S401 is an instruction to generate an individual table including a writable column. If the CPU 101 determines that the operation instruction of the individual table received in S401 is an instruction to generate an individual table including a writable column, the process proceeds to S406. If the CPU 101 determines that the operation instruction of the individual table received in S401 is not an instruction to generate an individual table including a writable column, the process proceeds to S407.

The table in FIG. 5 is an example of data recorded in the core database. The data recorded in the core database is a collection of data of a combination of Key and Value. The example in FIG. 5 indicates that there are three pieces of data having a key related to the item of name.
The number described before the name in the value of the key is a number used for associating with other data, and is used as an identifier of a record in the individual table. The CPU 101 can make correspondence between items based on the numbers described at the beginning of the Key. For example, the CPU 101 treats items described as "1, ***" (*** is an arbitrary character string) in the Key as data associated with each other. The attached data is one line.

In S405, the CPU 101 regenerates the individual table based on the individual table operation instruction received in S401, which is an instruction to add or delete a writable column to an existing individual table. In the present embodiment, it is assumed that the operation instruction for the individual table received in S401 is an instruction to add a writable column to the existing individual table. The existing individual table is assumed to be the table shown in FIG. The CPU 101 once deletes the existing individual table, and generates a new individual table including columns of the existing individual table and columns to which data can be written.
More specifically, the CPU 101 adds to the individual table determined to exist in S402 based on the name information of the column to be added and the designation information of the number of columns to be added included in the operation instruction of the individual table received in S401. Determine the names and number of writable columns to be written.
In the present embodiment, it is assumed that the number specified by the specification information of the number of columns to be added included in the operation instruction of the individual table received in S401 is one. It is also assumed that the name specified by the name information of the column to be added included in the operation instruction of the individual table received in S401 is “A analysis result”.

Then, the CPU 101 performs the following processing after once deleting the specified existing individual table. That is, the CPU 101 newly determines the table definition of the individual table so as to include the columns (name, AUC, Cmax, Tmax) included in the existing individual table and the writable “A analysis result” column. Then, based on the determined table definition, the CPU 101 generates a new individual table constructed in the RDB using a database language such as sql.
The CPU 101 acquires column data included in the existing individual table from the core database. The CPU 101 may add only one writable column to the individual table, or may add two or more columns. Further, the CPU 101 may set the writable column added to the individual table so that it can be written only by a specific user. The regenerated individual table is the table shown in FIG. 6B, and “A analysis result” which is a writable column compared to the table shown in FIG. 6A is added.
As a method of adding a column to an individual table, there is a method of changing the table definition of an existing individual table. However, there is a problem that it takes time to change the table definition of the existing individual table. In the method of temporarily deleting an individual table and generating a new individual table according to the present embodiment, the CPU 101 can add a new column to the individual table without having to change the table definition of the existing individual table.

In S405, if the operation instruction of the individual table received in S401 is an instruction to delete a writable column in the existing individual table, the CPU 101 designates the individual table determined to be present in S402 by the deletion instruction. The specified column.
More specifically, based on the name information of the column to be deleted and the designation information of the number of columns to be added included in the operation instruction of the individual table received in S401, the CPU 101 Determine the name and number of writable columns to delete.

After once deleting the existing individual table, the CPU 101 performs the following processing. That is, the CPU 101 newly determines the table definition of the individual table so as to include columns other than the designated writable column among the columns included in the existing individual table. Then, based on the determined table definition, the CPU 101 generates a new individual table constructed in the RDB using a database language such as sql.
As a method of deleting a column from an individual table, there is a method of changing a table definition of an existing individual table. However, there is a problem that changing the table definition of an existing individual table takes time. In the method of temporarily deleting an individual table according to the present embodiment and generating a new individual table, the CPU 101 can delete an existing column from the individual table without having to change the table definition of the existing individual table.

In S406, the CPU 101 generates an individual table based on the individual table operation instruction received in S401. The individual table operation instruction received in S401 is an instruction to generate a table including a reference item and a writable column. The CPU 101 generates an individual table including a reference item designated by an operation instruction of the individual table and a column in which additional data can be written.
More specifically, the CPU 101 includes a column of reference items (name, AUC, Cmax, Tmax) designated by an operation instruction of the individual table and a column of “A analysis result” which is a writable column. Determine the table definition for the individual table. Then, based on the determined table definition, the CPU 101 generates an individual table constructed by the RDB using a database language such as sql.
The CPU 101 acquires the data of the reference item specified by the operation instruction of the individual table from the core database. The CPU 101 may add only one writable column to the individual table, or may add two or more columns. Further, the CPU 101 may set the writable column added to the individual table so that it can be written only by a specific user. The generated individual table is assumed to be the table shown in FIG.

In S407, the CPU 101 generates a normal individual table that does not include a writable column based on the operation instruction of the individual table received in S401.
In S408, the CPU 101 writes data in the writable column of the individual table generated in S405 or S406 based on the operation of the user A who is a researcher via the terminal device 110. The user A writes, via the terminal device 110, a comment on the analysis result of the substance indicated by the item “name” in the individual table in the “A analysis result” column corresponding to each substance. The individual table to which the comment is written by the user A is as shown in the table of FIG. The processing of S408 corresponds to the processing of S412.

In S409, the CPU 101 records the additional data written in the writable column of the individual table in S408 in association with the identifier of each record (row) of the individual table in the core database. The CPU 101 newly generates an item “A analysis result” in the core database, and records the additional data written in the column “A analysis result” in S406 in the generated item “A analysis result”. .
More specifically, the CPU 101 generates, in the core database, a row having a column corresponding to the column of “A analysis result” of the individual table and the identifier of the record of the individual table, and a Value corresponding to the key. . The CPU 101 sets a row having a column of “A analysis result” and a key corresponding to a record identifier of an individual table, such as “1, A analysis result”, “2, A analysis result”, “3, A analysis result”. Generate Then, the CPU 101 records the additional data written in the column of “A analysis result” in S408 in the corresponding Value of the row generated in the core database.

In the example of FIG. 6D, the CPU 101 performs the following write processing. That is, the CPU 101 converts the data “useful for ●●” corresponding to the identifier “1” among the additional data written in the column “A analysis result” into the “A analysis result” and the identifier “1” in the core database. Is written in the Value of “1, A analysis result”, which is the key corresponding to. When newly generating an item such as “A analysis result” in the core database, the CPU 101 assigns an ID (ID for a column in the individual table) to each generated item. By doing so, the CPU 10
1 is such that even if a plurality of items having the same name are generated in the core database, each item can be distinguished.
The core database is constructed not by RDB but by KVS, Daifukusho model, and the like. Therefore, the CPU 101 can freely record new items in the core database without performing a process such as rewriting the table definition.

  The table in FIG. 7 is a table showing the data recorded in the database during the period when the data was recorded in S407. The example of FIG. 7 shows a state where the additional data written in the writable column “A analysis result” of the individual table is recorded in a portion surrounded by a rectangle 701. In response to a recording instruction from the terminal device 110, the CPU 101 may record the additional data written in the writable column of the individual table in the core database. In addition, the CPU 101 may periodically record the additional data written in the writable column of the individual table in the core database (every fixed period such as one hour or one day).

The processes in S411 to S412 are processes in the terminal device 110.
In S411, the CPU 111 instructs the database server 100 to operate the individual table based on the operation performed by the user A via the information application. The information application has a function of designating items to be referred to in the core database and names and numbers of writable columns to be added to the database server 100 based on the operation of the user A.
More specifically, the CPU 111 extracts an item (such as a name) recorded from the key of the key database through an information application, and displays the extracted item on a user interface or the like. The CPU 111 specifies items to be referred to the database server 100 based on a user operation via a user interface or the like. Note that the CPU 111 can also specify an extraction condition relating to the value of the item to be referred to. For example, the CPU 111 can specify a condition such that the value of the item to be referred to is equal to or higher than the set threshold and equal to or lower than the set threshold. In that case, the CPU 101 extracts data that satisfies the specified conditions from the core database and generates an individual table.
The CPU 111 instructs the database server 100 via the information application to add a writable column to an existing individual table, generate an individual table including a specified item and a writable column, and the like. It can be carried out. The CPU 111 can also instruct the database server 100 to delete a writable column already added to the individual table via the information application. The instruction to add a writable column to the individual table is an example of a column addition instruction. The instruction to delete a writable column already added to the individual table is an example of a column deletion instruction. The CPU 111 can also instruct the database server 100 to generate a normal individual table that does not include a writable column via the information application.

In S412, the CPU 111 writes the additional data in the writable column of the individual table generated in S405 or S406 based on the operation of the user A through the information application. The CPU 111 can display the contents of the individual table generated in S405 or S406 on the display device 115 via the information application. The screen illustrated in FIG. 6C is an example of a screen displayed on the display device 115.
The CPU 111 can write a comment in the “A analysis result” column in FIG. 6C based on an operation performed by the user A via the input device 116 or the like. After writing the comment in the “A analysis result” column of FIG. 6C, the CPU 111 instructs the database server 100 to write the comment in the corresponding column of the individual table via the information application. I do. The instruction is an example of a write instruction.
Further, when instructing the database server 100 to write to the individual table, the CPU 111 can instruct the database server 100 to record the content instructed to write by the write instruction in the core database.

Subsequently, a user B different from the user A who wrote the comment in FIGS. 4A and 4B generates an individual table including the data recorded in the core database by the processing of FIGS. 4A and 4B and displays the information. The processing of the processing system will be described.
FIG. 8 is a diagram illustrating an example of an individual table display process.

The processing of S801 to S802 is processing in the database server 100.
In step S801, the CPU 101 receives an instruction to generate an individual table and an instruction to display the individual table from the terminal device 120. The processing of S801 corresponds to the processing of S811.

In step S802, the CPU 101 acquires the data to be referenced and the data recorded in the core database in step S409 from the core database in accordance with the generation instruction received in step S801, and generates an individual table. More specifically, the CPU 101 defines the table definition of the individual table so as to include, as a column, the reference item (in this embodiment, name, AUC, Cmax, and A analysis result) specified by the individual table generation instruction. decide. Then, based on the determined table definition, the CPU 101 generates an individual table constructed by the RDB using a database language such as sql.
The CPU 101 acquires the data of the reference item specified by the individual table generation instruction from the core database. More specifically, the CPU 101 extracts data to be stored in the individual table based on the item described in the key recorded in the core database, and extracts the extracted data based on the number described in the key. Are recorded in the individual table in association with each other. With the above processing, the individual table of FIG. 6E including the comment written by the user A is generated. Then, the CPU 101 outputs the generated individual table to the terminal device 120 according to the display instruction received in S801. The processing in S802 corresponds to the processing in S812.

  In the present embodiment, it is assumed that the column storing the additional data written by the user A in the individual table generated in S802 can be referred to by the user B, but cannot be written. When writing the additional data to the core database in S409, the CPU 101 records the ID of the user who wrote the data in association with the additional data to be written in the core database. Thereby, based on the recorded user ID, the CPU 101 can determine whether or not the user performing the process is a user who can update the additional data recorded in the core database. However, the column storing the additional data written by the user A in the individual table generated in S802 may be writable by the user B.

The processes in S811 to S812 are processes in the terminal device 120.
In step S811, the CPU of the terminal device 120 instructs the database server 100 to generate and display an individual table via the information application.
In S812, the CPU of the terminal device 120 displays the individual table output from the database server 100 in S802 on the display unit of the terminal device 120 via the information application.

Further, the CPU of the terminal device 120 can instruct the database server 100 to add a new writable column to the individual table generated in S802.
The process of the database server 100 receiving the instruction is the same as the process of FIG. 4A. The processing of the terminal device 120 at the time of writing the additional data is the same as the processing of S412 in FIG. 4B. The individual table generated by the database server 100 is the table shown in FIG. The screen of the individual table displayed on the display unit of the terminal device 120 is the screen of FIG. 9B. The CPU of the terminal device 120 writes the additional data in the “B analysis result” on the screen in FIG. 9B in response to the operation performed by the user B on the “B analysis result” on the screen in FIG. 9B.

As described above, by the processing of the present embodiment, the information processing system can write a comment or the like in the individual table, and can refer to the comment or the like written in the individual table together with the individual table later.
In the present embodiment, by constructing the core database using the KVS, Daifuku Book model, or the like, the additional data written in the writable columns added to the individual tables can be freely used without defining a table or the like in advance. Can be recorded. In the present embodiment, the information processing system uses an individual table constructed by the RDB, and freely adds a comment writing column later or records the written comment while maintaining the usability of the RDB. Or you can.

In addition, the user can generate an individual table in which items to be referred to are specified according to each research theme or the like, and can also refer to comments and the like of other users in the individual table. Further, the user can add a writable column to the individual table and write a comment or the like. Thus, the user can write a comment on his or her own analysis result in consideration of the analysis results and the like of other users.
As described above, the information processing system can centrally manage the information of the core database and the additional data written by the user in the core database. A conventional method of centrally managing the information in the core database and the additional data written by the user is to use an Excel sheet or the like. However, the analysis result is segmented into each sheet, and the data of each sheet is used as a key. There is a problem that it is difficult to consolidate in a database. On the other hand, in the present embodiment, the information processing system can easily aggregate the written additional data by recording the additional data written in the individual table in the core database.
This embodiment can be applied to a patent search system, a personnel evaluation system, and the like. In the patent search system, the information processing system generates an individual table for each user by selecting only necessary items from a large number of items, or by narrowing down by a technical field or the like. The user defines a comment column in the individual table and writes a survey memo. The information processing system reflects the contents written in the individual table in the core database, so that users other than the commenting user can refer to the survey memo.

100 database server, 101 CPU, 110 terminal device

Claims (9)

An information processing apparatus used for data analysis using DATA WAREHOUSE (DWH),
Additional data can be written to the individual table in response to a column addition instruction from a terminal device connected via a network to the individual table, which is a table in which specific data is extracted from CENTRAL WAREHOUSE (CWH) in the DWH. Additional means to add extra columns,
In response to an additional data write instruction for the writable column added by the adding unit performed via the terminal device, a writing unit that writes additional data to the writable column,
Recording means for recording, in the CWH, the additional data written by the writing means in association with an identifier for associating data in the CWH with data in the individual table;
Have a,
The CWH is a key value store (KVS) that is a data store that manages data in pairs of a key for identifying a corresponding value and a value.
Information processing device.   The adding unit deletes the individual table once in response to a column addition instruction for the individual table, and generates a new individual table including a column configuring the individual table and the writable column. The information processing apparatus according to claim 1, wherein the writable column is added to the individual table. Generating means for generating a second individual table including the additional data recorded in the CWH by the recording means in response to a generation instruction from a terminal device connected via a network;
The information processing apparatus according to claim 1, further comprising a display unit configured to display, on a display unit of the terminal device, the second individual table generated by the generation unit in response to a display instruction from the terminal device. . The adding means, in response to a column addition instruction for the second individual table generated by the generating means from the terminal device, to add a column in which additional data can be written to the second individual table,
4. The information processing apparatus according to claim 3, wherein the writing unit writes the additional data in the writable column of the second individual table in response to an additional data writing instruction from the terminal device. The recording unit records the additional data written by the writing unit in the CWH in association with the key of the KVS including the information indicating the writable column added by the adding unit and the identifier. The information processing apparatus according to claim 1, wherein: According to the column delete instruction for the individual tables from the terminal device, wherein the individual table, according to claim 1 to 5 any one, further comprising a deleting means for deleting the added the writable column was by said additional means An information processing apparatus according to claim 1. An information processing system including a terminal device and an information processing device used for data analysis using DATA AREHOUSE (DWH),
The terminal device,
Instruction means for instructing the information processing apparatus connected via a network to add a writable column to an individual table, which is a table in which specific data is extracted from the CENTRAL WAREHOUSE (CWH) in the DWH, is provided. And
The information processing device,
Additional means for adding a column in which additional data can be written to the individual table in accordance with an instruction from the instruction means,
In response to an additional data write instruction for the writable column added by the adding unit performed via the terminal device, a writing unit that writes additional data to the writable column,
Recording means for recording, in the CWH, the additional data written by the writing means in association with an identifier for associating data in the CWH with data in the individual table;
Have a,
The CWH is a key value store (KVS) that is a data store that manages data in pairs of a key for identifying a corresponding value and a value.
Information processing system. An information processing method executed by an information processing apparatus used for data analysis using DATA WAREHOUSE (DWH),
Additional data can be written to the individual table in response to a column addition instruction from a terminal device connected via a network to the individual table, which is a table in which specific data is extracted from CENTRAL WAREHOUSE (CWH) in the DWH. Additional steps to add additional columns,
In response to an additional data write instruction for the writable column added in the adding step performed through the terminal device, a writing step of writing additional data to the writable column,
A recording step of recording the additional data written in the writing step in association with an identifier for associating data in the CWH with data in the individual table, and recording the additional data in the CWH;
Only including,
The CWH is a key value store (KVS) that is a data store that manages data in pairs of a key for identifying a corresponding value and a value.
Information processing method. The computer as each unit of the information processing apparatus of claims 1 to 6 any one of claims, program for functioning.

Images