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

Abstract

PROBLEM TO BE SOLVED: To make it possible to write comments in an individual table, and refer to the comments written in the individual table later with the individual table.SOLUTION: An information processing apparatus comprises: addition means that adds a string that can write additional data in an individual table in response to a string addition instruction to the individual table from a terminal device connected via a network; writing means that writes the additional data in the string that can write the additional data added by the addition means in response to an additional data writing instruction from the terminal device; and recording means that records the additional data written by the writing means in a basic database in association with an identifier for associating data in the basic database with the data in the individual table.SELECTED DRAWING: Figure 3

Description

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

Conventionally, DWH (DATA WAREHOUSE) has been used as a mechanism for collecting and analyzing various data existing inside and outside a company. DWH is a mechanism for collecting and accumulating data that is born every day in a core system or the like in one place (CWH (CENTRAL WAREHOUSE, hereinafter referred to as a core database)). The accumulated data is used for analysis by an information system application such as BI (Business Intelligence).
When performing data analysis by an information system application, there are various needs such as data management in a format suitable for each application and management of access authority for each user. Therefore, data required for each application or each user is extracted, an individual Mart (hereinafter referred to as an individual table) is constructed, and data analysis is performed with reference to the individual table.
Patent Document 1 discloses a mechanism for automatically generating an individual table in response to an instruction from a screen by a user for the construction of the individual table.

JP 2002-366401 A

Conventionally, in the data analysis using the basic database and the individual table as in Patent Document 1, the data flow is unidirectional (basic system application → main database → individual table → information system application). Each user can freely construct an individual table and display data, but cannot write comments or the like in the individual table.
In view of the above, an object of the present invention is to write a comment or the like in an individual table and to refer to the comment or the like written in the individual table later together with the individual table.

  Therefore, the information processing apparatus of the present invention includes an adding unit that adds a column in which additional data can be written to the individual table in response to a column addition instruction for the individual table from a terminal device connected via a network, In response to an additional data write instruction from the terminal device, a writing unit that writes additional data to the writable column added by the adding unit, and the additional data written by the writing unit is converted into data in a basic database. And recording means for recording in the basic database in association with an identifier for associating the data with the data in the individual table.

  According to the present invention, comments and the like can be written in the individual table, and the comments and 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 an 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 showing an example of recorded data in the basic database. FIG. 6 is a diagram illustrating an example of the generated individual table and the like. FIG. 7 is a diagram showing an example of recorded data in the basic database. FIG. 8 is a flowchart illustrating an example of 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 backbone database is a database that integrates and manages data. CWH is an example of a core database. The individual table is a table obtained by extracting only specific data from the basic database, and is used for external reference. Mart is an example of an individual table. In the present embodiment, the data in the basic database and the data in the individual table are associated with each other based on the identifier. More specifically, the value data corresponding to the key including the same identifier in the basic 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 column that can be written by the user to the individual table in order to aggregate the data analysis results of each user so that other users can easily use it. In the following, data such as comments written for the added writable column is referred to as additional data.
Then, the information processing system, when the user writes additional data to the added writable column, records the written contents in the core database in association with the record identifier in the individual table I do. A record is one piece of data, and is one row of data in a table.
However, when the basic database is constructed by RDB, the information processing system needs to change the table definition to add a new column to the basic database. Therefore, the user must take the trouble of the table definition change process in order to record a writable column.

Therefore, in the present embodiment, the information processing system generates an individual table including a writable column constructed with a relational data base from a backbone database constructed with 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 is written by the user in association with the identifier of the record of the individual table in the basic database. The information processing system can freely add new column information to a backbone database constructed with KVS, Daifuku book model, or the like. The information processing system outputs the columns recorded in the basic database in response to a request from another user.
KVS is a data store that manages data in pairs of “key” and “value”, and columns can be freely defined without being bound by a fixed schema (table definition or the like). The Daifuku book model is a type of database model that accumulates generated data as it is without summarizing it, and it is possible to define columns freely without restrictions on column definitions.

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

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

FIG. 2 is a diagram illustrating an example of a hardware configuration of the database server 100 or the like.
FIG. 2A shows an example of the 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, main storage device 102, auxiliary storage device 103, and network interface 104 are connected to each other 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 basic database data, individual tables, and the like, and also records various programs executed by the CPU 101. The network interface 104 is used for connection with an external device via the network 130.
When the CPU 101 executes processing based on the program recorded in the auxiliary storage device 103, the function of the database server 100 described later and the processing of the flowchart described later are realized.

FIG. 2B shows an example of the 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 connected to each other 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 records various programs executed by the CPU 111.

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 for displaying a screen of an information system 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 processing based on the program recorded in the auxiliary storage device 113, the function of the terminal device 110 described later and the processing of the 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.
The CPU of the terminal device 120 executes processing based on the program recorded in the auxiliary storage device of the terminal device 120, thereby realizing the function of the terminal device 120 described later and the processing of the flowchart described later.

FIG. 3 is a diagram illustrating an outline of processing of the information processing system. The basic database in the database server 100 records master data, transaction data, and other data.
The terminal device 110 instructs the database server 100 to generate an individual table including columns composed of data extracted from the basic database and writable columns via an internal information system application. The terminal device 110 can also instruct the database server 100 to add a column that can be written to an existing individual table via an internal information system application.
In response to an instruction from the terminal device 110, the database server 100 generates an individual table including a column composed of data extracted from the basic database and a writable column, or 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 system application.
The database server 100 records the additional data written in the writable column of the generated individual table in the basic database.
Details of the processing of the information processing system will be described below.

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

In step 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 operation instruction for the individual table 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 no existing individual table exists, the CPU 101 proceeds to S404.
In step S <b> 403, the CPU 101 determines whether or not an instruction for adding a column in which data can be written or an instruction for deletion is included in the operation instruction for the individual table received in step S <b> 401. If 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 for the individual table received in S401 does not include an instruction to add or delete a column in which data can be written, the process proceeds to S408.
In step S <b> 404, the CPU 101 determines whether the individual table operation instruction received in step S <b> 401 is an instruction for generating an individual table including a writable column. If the CPU 101 determines that the operation instruction for the individual table received in S401 is an instruction to generate an individual table including a writable column, the CPU 101 proceeds to the process of S406. If the CPU 101 determines that the operation instruction for the individual table received in S401 is not an instruction for generating 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 basic database. The data recorded in the basic database is a collection of data of a combination of Key and Value. The example of FIG. 5 indicates that there are three pieces of data having a key related to the item “name”.
The number described before the name in the Key value is a number used for correspondence with other data, and is used as an identifier of a record in the individual table. The CPU 101 can take a correspondence between items based on the numbers described at the beginning of the key. For example, the CPU 101 treats items described as “1, ***” in the key (*** is an arbitrary character string) as associated data, and corresponds when generating an individual table. The attached data is set as one line.

In step S405, the CPU 101 regenerates the individual table based on the individual table operation instruction received in step S401, which is an instruction to add or delete a column that can be written to the 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. Assume that the existing individual table is the table of FIG. The CPU 101 once deletes the existing individual table, and generates a new individual table including the columns of the existing individual table and the columns into 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 added column and the designation information of the number of added columns included in the operation instruction of the individual table received in S401. Determine the name and number of writable columns to be performed.
In the present embodiment, it is assumed that the number designated by the designation information on the number of columns to be added included in the operation instruction of the individual table received in S401 is one. Further, it is 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 once deletes the specified existing individual table and then performs the following processing. 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, the CPU 101 generates a new individual table constructed by RDB using a database language such as sql based on the determined table definition.
The CPU 101 acquires column data included in the existing individual table from the basic database. The CPU 101 may add only one column that can be written to the individual table, or may add two or more columns. Further, the CPU 101 may set a writable column added to the individual table so that only a specific user can write it. The regenerated individual table is the table of FIG. 6B, and “A analysis result”, which is a writable column, is added as compared to the table of FIG. 6A.
As a method for adding a column to an individual table, there is a method of changing the table definition of an existing individual table, but there is a problem that it takes time to change the table definition of an existing individual table. In the method of once deleting an individual table according to the present embodiment and generating a new individual table, the CPU 101 can add a new column to the individual table without the need to change the table definition of the existing individual table.

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

The CPU 101 deletes the existing individual table and then 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, the CPU 101 generates a new individual table constructed by RDB using a database language such as sql based on the determined table definition.
As a method of deleting a column from an individual table, there is a method of changing the table definition of an existing individual table, but there is a problem that it takes time to change the table definition of an existing individual table. In the method of once 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 step S406, the CPU 101 generates an individual table based on the operation instruction for the individual table received in step S401. The individual table operation instruction received in S401 is a table generation instruction including a reference item and a writable column. The CPU 101 generates an individual table including a reference item specified by an operation instruction for 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” that is a writable column. Determine the table definition for the individual table. Then, the CPU 101 generates an individual table constructed by RDB using a database language such as sql based on the determined table definition.
The CPU 101 acquires the data of the reference item designated by the individual table operation instruction from the basic database. The CPU 101 may add only one column that can be written to the individual table, or may add two or more columns. Further, the CPU 101 may set a writable column added to the individual table so that only a specific user can write it. Assume that the generated individual table is the table of FIG.

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

In S409, the CPU 101 records the additional data written in the writable column of the individual table in S408 in the basic database in association with the identifier of each record (row) of the individual table. The CPU 101 newly generates an item “A analysis result” in the basic database, and records the additional data written in the column “A analysis result” in S406 in the generated “A analysis result” item. .
More specifically, the CPU 101 generates a row having a key corresponding to the “A analysis result” column of the individual table and a record identifier of the individual table and a value corresponding to the key in the basic database. . The CPU 101 has a column having “1, A analysis result”, “2, A analysis result”, “3, A analysis result” and the like corresponding to the “A analysis result” column and the identifier of the record of the individual table. Is generated. Then, the CPU 101 records the additional data written in the column “A analysis result” in step S <b> 408 in the value corresponding to the row generated in the basic database.

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

  The table in FIG. 7 is a table showing data recorded in the database for the period in which 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 the portion surrounded by the rectangle 701. The CPU 101 may record the additional data written in the writable column of the individual table in the basic database in accordance with a recording instruction from the terminal device 110. Further, the CPU 101 may record the additional data written in the writable column of the individual table in the basic database periodically (every fixed period such as one hour or one day).

The processing of S411 to S412 is processing in the terminal device 110.
In step S <b> 411, the CPU 111 instructs the database server 100 to operate the individual table based on an operation performed by the user A via the information system application. The information system application has a function of designating, in the database server 100, an item to be referred to in the basic database and the name and number of a writable column to be added based on the operation of the user A.
More specifically, the CPU 111 extracts items (name, etc.) recorded from the key of the basic database via the information system application, and displays the extracted items on a user interface or the like. The CPU 111 specifies an item 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 regarding the value of an item to be referred to. For example, the CPU 111 can specify a condition such as a value of an item to be referred to is greater than or equal to a set threshold value and less than or equal to a set threshold value. In this case, the CPU 101 extracts data satisfying the designated condition from the basic database and generates an individual table.
The CPU 111 instructs the database server 100 to add a writable column to an existing individual table, an instruction to generate an individual table including a specified item and a writable column, etc., via the information system application. It can be carried out. Further, the CPU 111 can instruct the database server 100 to delete a writable column that has already been added to the individual table via the information system 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 that has already been added to the individual table is an example of a column deletion instruction. Further, the CPU 111 can instruct the database server 100 to generate a normal individual table that does not include a writable column via the information system application.

In S <b> 412, the CPU 111 writes additional data in the writable column of the individual table generated in S <b> 405 or S <b> 406 based on an operation by the user A via the information system 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 system 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” field of FIG. 6C based on an operation by the user A via the input device 116 or the like. When the CPU 111 writes a comment in the “A analysis result” field in FIG. 6C, it instructs the database server 100 to write the comment in the corresponding field of the individual table via the information system application. I do. The instruction is an example of a write instruction.
Further, when the CPU 111 instructs the database server 100 to write to the individual table, the CPU 111 can instruct the database server 100 to record the contents instructed to write by the write instruction in the basic database.

Next, information when a separate table including the data recorded in the core database by the processing of FIGS. 4A and 4B is generated and displayed by the user B different from the user A who wrote the comments in FIGS. 4A and 4B. Processing of the processing system will be described.
FIG. 8 is a diagram illustrating an example of individual table display processing.

The processes in S801 to S802 are processes in the database server 100.
In step S <b> 801, the CPU 101 receives an individual table generation instruction and a display instruction from the terminal device 120. The process of S801 corresponds to the process of S811.

In S802, in response to the generation instruction received in S801, the CPU 101 acquires the data to be referred to and the data recorded in the basic database in S409 from the basic database, and generates an individual table. More specifically, the CPU 101 defines the table definition of the individual table so as to include the reference items (in the present embodiment, name, AUC, Cmax, and A analysis result) designated by the individual table generation instruction as columns. decide. Then, the CPU 101 generates an individual table constructed by RDB using a database language such as sql based on the determined table definition.
The CPU 101 acquires the data of the reference item designated by the individual table generation instruction from the basic database. More specifically, the CPU 101 extracts the data stored in the individual table based on the item described in the Key recorded in the basic database, and the extracted data based on the number described in the Key. Are associated and recorded in the individual table. 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 in accordance with the display instruction received in S801. The process of S802 corresponds to the process of S812.

  In this embodiment, the column storing 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 the additional data is written to the basic database in S409, the CPU 101 records the user ID written in association with the additional data to be written in the basic database. As a result, 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 based on the recorded user ID. 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 S811, the CPU of the terminal device 120 instructs the database server 100 to generate and display the individual table via the information system 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 processing of the database server 100 that has received the instruction is the same as the processing of FIG. 4A. The process of the terminal device 120 at the time of writing additional data is the same as the process 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 additional data in the “B analysis result” on the screen of FIG. 9B in response to an operation on the “B analysis result” on the screen of FIG. 9B by the user B.

As described above, according to the processing of the present embodiment, the information processing system can write comments and the like in the individual table, and can refer to the comments and the like written in the individual table later together with the individual table.
In this embodiment, by constructing the basic database with KVS, Daifuku book model, etc., it is possible to freely add the additional data written in the writable column added to the individual table without defining the table in advance. Can record. In this embodiment, the information processing system uses an individual table constructed by RDB, and while maintaining the ease of use of RDB, freely add a column for writing comments later, or record the written comment You can do it.

Further, the user can generate an individual table in which an item to be referred to is specified according to each research theme, and can refer to comments of other users in the individual table. Furthermore, the user can add a writable column to the individual table and write a comment or the like. Thereby, the user can write a comment about his / her analysis result in consideration of the analysis result of other users.
As described above, the information processing system can centrally manage the information in the basic database and the additional data written by the user in the basic database. A conventional method for 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, but the analysis result is subdivided into each sheet, and the data of each sheet is There is a problem that it is difficult to aggregate in a database. On the other hand, in this embodiment, the information processing system can easily collect the written additional data by recording the additional data written in the individual table in the basic database.
This embodiment can also be applied to a patent search system, a personnel evaluation system, and the like. In the patent search system, the information processing system selects only necessary items from a large number of items or narrows down in the technical field and generates an individual table for each user. The user defines a comment field in the individual table and writes a survey memo. The information processing system reflects the contents written in the individual table in the basic database so that the survey memo can be referred to from other than the commented user.

100 database server, 101 CPU, 110 terminal device

Therefore, the information processing apparatus of the present invention is an information processing apparatus used for data analysis using DATA WAREHOUSE (DWH), and is based on CENTRAL WAREHOUSE (CWH) in the DWH from a terminal apparatus connected via a network. In response to a column addition instruction for an individual table that is a table from which specific data is extracted, an adding unit that adds a column in which additional data can be written to the individual table; and the addition performed via the terminal device depending on the additional data write instruction to the writable string added by means before Symbol writing means for writing the additional data in a writable string, the additional data written by said writing means, in said CWH Associating data with data in the individual table In association with the order of the identifiers, having a recording means for recording the CWH.

Claims (10)

In accordance with a column addition instruction for the individual table from the terminal device connected via the network, an adding unit that adds a column in which additional data can be written to the individual table;
In response to an additional data write instruction from the terminal device, a writing unit that writes additional data to the writable column added by the adding unit;
Recording means for recording the additional data written by the writing means in the basic database in association with an identifier for associating the data in the basic database with the data in the individual table;
An information processing apparatus.   The adding unit temporarily deletes the individual table in response to a column addition instruction for the individual table, and generates a new individual table including the columns constituting the individual table and the writable columns. 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 basic database 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 the second individual table generated by the generation unit on a display unit of the terminal device in response to a display instruction from the terminal device. . The adding unit adds a column in which additional data can be written to the second individual table in response to a column addition instruction for the second individual table generated by the generating unit from the terminal device,
The information processing apparatus according to claim 3, wherein the writing unit writes additional data in the writable column of the second individual table in response to an additional data write instruction from the terminal device.   5. The recording unit according to claim 1, wherein the recording unit records the additional data written by the writing unit in the basic database in association with the writable column and the identifier added by the adding unit. 1. An information processing apparatus according to item 1.   6. The device according to claim 1, further comprising a deleting unit that deletes the writable column added by the adding unit from the individual table in response to a column deletion instruction for the individual table from the terminal device. The information processing apparatus described.   The deletion unit temporarily deletes the individual table, and generates a new individual table including columns other than the writable column added by the addition unit among the columns configuring the individual table. The information processing apparatus according to claim 6, wherein the writable column is deleted from the individual table. An information processing system including a terminal device and an information processing device,
The terminal device
An instruction means for instructing the information processing apparatus connected via the network to add a writable column to the individual table;
The information processing apparatus includes:
In accordance with an instruction from the instruction unit, an adding unit that adds a column in which additional data can be written to the individual table;
In response to an additional data write instruction from the terminal device, a writing unit that writes additional data to the writable column added by the adding unit;
Recording means for recording the additional data written by the writing means in the basic database in association with an identifier for associating the data in the basic database with the data in the individual table;
An information processing system. An information processing method executed by an information processing apparatus,
An addition step of adding a column in which additional data can be written to the individual table in response to a column addition instruction for the individual table from a terminal device connected via a network;
In response to an additional data write instruction from the terminal device, a write step of writing additional data to the writable column added in the addition step;
A recording step of recording the additional data written in the writing step in the basic database in association with an identifier for associating the data in the basic database with the data in the individual table;
An information processing method including: On the computer,
An addition step of adding a column in which additional data can be written to the individual table in response to a column addition instruction for the individual table from a terminal device connected via a network;
In response to an additional data write instruction from the terminal device, a write step of writing additional data to the writable column added in the addition step;
A recording step of recording the additional data written in the writing step in the basic database in association with an identifier for associating the data in the basic database with the data in the individual table;
A program for running

Images