Data management apparatus and data management method

• US 10,534,766 B2
• Filed: 06/27/2014
• Issued: 01/14/2020
• Est. Priority Date: 07/19/2013
• Status: Active Grant

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Shimono, Akio, Miyoshi, Naoki, Fujishima, Kazutoshi, Otsuka, Akira
• Primary Examiner(s): Pham, Hung Q
• Application Number:
  US14/317,366
• Publication Number:
  US 20150026221A1
• Time in Patent Office: 2,027 Days
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity

Abstract

A data management apparatus manages a database that has a plurality of items each of which has item attribute data. The data management apparatus includes determining, when an update request to the database is accepted, whether an item that is designated in the update request is included in the items, adding, when the designated item is not included in the items, the designated item to the items, and setting a definition setting flag included in item attribute data of the designated item to a second state that is different from a first state to which a definition setting flag included in item attribute data of an item approved as an item of the database is set.

Claims

1. A non-transitory computer-readable recording medium storing therein a data management program that causes a computer to execute a process comprising:

determining, in response to a request to add or update data of an item to a database is accepted, whether a name of the item designated in the request is included in the schema, wherein the database stores data table and schema that defines names of a plurality of items of the data table and a definition setting flag for each of the plurality of items, wherein the data table includes data for each of the plurality of items, wherein a first state of the definition setting flag indicates that corresponding items associated with the definition setting flag in the first state are defined and approved as items of the database, wherein a second state of the definition setting flag indicates that corresponding items associated with the definition setting flag in the second state are not defined and not approved as items of the database;

adding, in response to determining that the name of the item designated in the request is not included in the schema, the data to the data table as a new item and the name of the item designated in the request to the schema, or updating, in response to determining that the name of the item designated in the request is included in the schema, an item in the data table corresponding to the name of the item designated in the request with the data designated in the request;

setting corresponding definition setting flag for the new item to the second state, wherein corresponding definition setting flag for the updated item that has been set to the first state is unchanged;

outputting, in response to a reference request to the schema of the database is accepted, items associated with definition setting flags in the first state, wherein the reference request is in a reference mode for referring to items having definition setting flags which are set to the first state, and outputting items associated with definition setting flags in the second state in addition to output items in the first state if the reference request is in extended reference mode; and

changing, in response to a change request to change a definition setting flag for an item is accepted, the first state, which has been set, to the second state for the item designated in the change request, or the second state, which has been set for the item designated in the change request, to the first state.

2. A data management apparatus comprising:

circuitry; and

a memory storing a database that stores data table and schema that defines names of a plurality of items of the data table and a definition setting flag for each of the plurality of items, wherein the data table includes data for each of the plurality of items, wherein a first state of the definition setting flag indicates that corresponding items associated with the definition setting flag in the first state are defined and approved as items of the database, wherein a second state of the definition setting flag indicates that corresponding items associated with the definition setting flag in the second state are not defined and not approved as items of the database, wherein the circuitry;

determines, in response to a request to add or update data of an item to the database is accepted, whether a name of the item designated in the request is included in the schema;

adds, in response to determining that the name of the item designated in the request is not included in the schema, the data to the data table as a new item and the name of the item designated in the request to the schema, or updating, in response to determining that the name of the item designated in the request is included in the schema, an item in the data table corresponding to the name of the item designated in the request with the data designated in the request;

sets corresponding definition setting flag for the new item to the second state, wherein corresponding definition setting flag for the updated item that has been set to the first state is unchanged;

outputs, in response to a reference request to the schema of the database is accepted, items associated with definition setting flags in the first state, wherein the reference request is in a reference mode for referring to items having definition setting flags which are set to the first state, and outputting items associated with definition setting flaps in the second state in addition to output items in the first state if the reference request is in extended reference mode; and

changes, in response to a change request to change a definition setting flag for an item is accepted, the first state, which has been set, to the second state for the item designated in the change request, or the second state, which has been set for the item designated in the change request, to the first state.

3. A data management method performed by a computer, the method comprising:

determining, in response to a request to add or update data of an item to a database is accepted, whether a name of the item designated in the request is included in the schema, wherein the database stores data table and schema that defines names of a plurality of items of the data table and a definition setting flag for each of the plurality of items, wherein the data table includes data for each of the plurality of items, wherein a first state of the definition setting flag indicates that corresponding items associated with the definition setting flag in the first state are defined and approved as items of the database, wherein a second state of the definition setting flag indicates that corresponding items associated with the definition setting flag in the second state are not defined and not approved as items of the database, using circuitry;

adding, in response to determining that the name of the item designated in the request is not included in the schema, the data to the data table as a new item and the name of the item designated in the request to the schema, or updating, in response to determining that the name of the item designated in the request is included in the schema, an item in the data table corresponding to the name of the item designated in the request with the data designated in the request, using the circuitry;

setting corresponding definition setting flag for the new item to the second state, wherein corresponding definition setting flag for the updated item that has been set to the first state is unchanged, using the circuitry;

outputting, in response to a reference request to the schema of the database is accepted, items associated with definition setting flags in the first state, wherein the reference request is in a reference mode for referring to items having definition setting flags which are set to the first state, and outputting items associated with definition setting flags in the second state in addition to output items in the first state if the reference request is in extended reference mode, using the circuitry; and

changing, in response to a change request to change a definition setting flag for an item is accepted, the first state, which has been set, to the second state for the item designated in the change request, or the second state, which has been set for the item designated in the change request, to the first state, using the circuitry.