JP6339932B2 - Data management apparatus, data management method, and data management program - Google Patents

Description

  The present invention relates to a technique for inputting and managing data.

  In general system development, examine the data model based on business specifications, proceed with the logical design of the database (table definition, etc.), proceed with the design of the screen specifications, and convert the data structure difference between them with the application program It is realized by doing. When the database configuration is changed, it is necessary to recreate an application program for data conversion, and the database configuration cannot be easily changed.

  In Patent Document 1, in order to easily configure a database, a user creates a template called a definition body, reads the definition body, and inputs a value to store data in the database.

  Also, an XML database that stores XML data in the same data structure is known.

JP 2004-192517 A

  When there is a request to input data in various formats, the conventional system development involves developing the system for each target format, and there is a problem that it takes a development cost and a development period.

  The present invention has been made in view of the above, and an object of the present invention is to provide a system in which data of various formats can be input without additional development.

The data management apparatus according to a first aspect of the present invention, a data definition storage means for store the data definition information that defines with the hierarchical structure of various modalities in a single column of the table, the desired from the data definition storage means the acquired data definition information, the data and screen configuration unit that receives an input of values constitutes a screen according to the hierarchical structure definition information, one column of data of the hierarchical structure enter a value in the data definition information table to have a data storage means for store and said screen configuration means, when receives an input value, characterized in that accepting additional new hierarchical structure for the hierarchical structure of the data.

In the data management apparatus, the screen configuration means includes a wherein acquire the data from the data storage unit, receives the additional changes and the new hierarchy of values constitutes a screen according to the hierarchical structure of the data To do.

In the data management apparatus, check definition information having a check target item in which the keys of the hierarchical structure of the data definition information are specified side by side and a determination method for determining whether or not a value of the item is correctly input is stored It has check definition storage means, and check means for checking the data with reference to the check definition information when storing the data.

Data management method according to a second aspect of the present invention is a data management method executed by a computer, data definition storage that store the data definition information defined in one column of the table using a hierarchical structure of various modalities Obtaining the desired data definition information from the means; constructing a screen according to the hierarchical structure of the data definition information; receiving a value input; and table of hierarchical data in which a value is input to the data definition information And storing a new hierarchical structure to the hierarchical structure of the data when an input of a value is accepted .

According to a third aspect of the present invention, there is provided a data management program for operating a computer as each means of the data management apparatus.

  ADVANTAGE OF THE INVENTION According to this invention, the system which can input the data of various styles without additional development can be provided.

It is a functional block diagram which shows the structure of the data management system in this Embodiment. It is a figure which shows the example of the data used by this Embodiment. It is a figure which shows the example of the screen comprised according to the hierarchical structure of the data of FIG. It is a figure which shows the example of the screen when creating a data format definition. It is a figure which shows the example of a check definition. It is a figure which shows the example of the data stored in a database. It is a flowchart which shows the flow of a process when registering data in the data management system in this Embodiment. It is a figure which shows the example which added the item of "construction information" to the data of FIG.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

  FIG. 1 is a functional block diagram showing the configuration of the data management system in the present embodiment. The data management system shown in FIG. 1 includes a client terminal 1, a server 3, and a database 5. The client terminal 1 connects to the server 3 and accesses the database 5 via the server 3. Although only one client terminal 1 is shown in FIG. 1, a plurality of client terminals 1 may be connected to the server 3.

  This data management system is a system that performs input / output and content check of data input according to a data format definition that defines items included in data, and creation of a data format definition. The client terminal 1 acquires the data format definition stored in the database 5 via the server 3, configures a screen according to the hierarchical structure of the data format definition, accepts data input, and inputs the input data via the server 3. And stored in the database 5. In addition, the client terminal 1 creates a data format definition reflecting an operation of adding or changing elements constituting the screen, and stores the created data format definition in the database 5 via the server 3. Hereinafter, each device will be described.

  The client terminal 1 includes a data registration unit 11, a screen drawing unit 12, and a data format registration unit 13.

  The data registration unit 11 acquires the data format definition from the database 5 via the server 3, displays a screen corresponding to the data format definition on the screen drawing unit 12, and is input according to the data format definition by the screen drawing unit 12. Data is stored in the database 5 via the server 3. In addition, for data that has already been input, the data registration unit 11 acquires the data from the database 5 via the server 3 and causes the screen drawing unit 12 to display the data. And stored in the database 5.

  The screen drawing unit 12 creates and displays a screen for inputting data according to the hierarchical structure of the data format definition. The data format definition is a template in which items included in the data are defined using a hierarchical structure, and the data is obtained by inputting a value into the data format definition.

  FIG. 2 shows an example of data used in this embodiment. In the present embodiment, the data format definition and data are described by a JSON format associative array. The part enclosed in curly braces (“{”, “}”) is an associative array, and the left side of the colon of each element in the associative array is the key, and the right side is the value corresponding to the key. An associative array can be taken as the value, and the associative array is data one layer below the corresponding key. In the example of FIG. 2, there is an element having “contractor information” and “application information” as keys below one layer of “common information”. “Contractor information” has elements having “contractor name” and “contractor address” as keys. The “contractor name” is set to a value “XXXXX”. In the data format definition, the key and hierarchy structure are defined, but the item has no value. For example, the data format definition that is the basis of the data in FIG. 2 does not include the value of “contractor name” or the value of “contractor address”. A default value may be entered in the value of the data format definition.

  The screen drawing unit 12 creates a screen with tabs in the first layer, blocks in the second layer, and items in the third layer according to the hierarchical structure of the data. Hereinafter, a specific example will be described. FIG. 3 is an example of a screen configured according to the data hierarchical structure of FIG. The screen drawing unit 12 displays the first layer (“common information”, “individual information”) on the tabs 100 and 200, the second layer (“contractor information”, “application information”) on the blocks 110, 120, and the third layer. The screen shown in FIG. 3 is configured with the items 111, 112, and 121 (“contractor name”, “contractor address”, “application date”). The screen drawing unit 12 receives input of data of values corresponding to the items 111, 112, 121 in the right column of the items 111, 112, 121. When the registration button 500 at the lower right of the screen is operated (clicked), the data registration unit 11 transmits the data whose value is input to the data format definition to the server 3 in the JSON format and registers it in the database 5.

  In the screen of FIG. 3, the data in the tab 200 (“individual information”) in the first hierarchy is not displayed. However, by operating (clicking) the tab 200, the data in the “common information” is replaced. The data in “Individual information” is displayed on the screen.

  Since the screen drawing unit 12 configures the screen according to the data hierarchical structure, even if the contents and structure of the data are different, the same rule with the first layer as a tab, the second layer as a block, and the third layer as an item is used. The screen can be configured generically. Rules for configuring the screen can be determined and applied to the fourth and higher layers. The screen drawing unit 12 can be realized by, for example, JavaScript (registered trademark) installed in a Web browser.

  The data format registration unit 13 registers a new data format definition created by the screen drawing unit 12 in the database 5 via the server 3. The screen drawing unit 12 accepts operations for adding and changing tabs, blocks, and items, and the data format registering unit 13 creates a data format definition reflecting the change of the screen displayed by the screen drawing unit 12.

  FIG. 4 shows an example of a screen when creating a data format definition. When creating the data format definition, the screen drawing unit 12 configures the screen according to the hierarchical structure of the created data format definition. A new tab is added by operating the tab addition button 300 in FIG. Similarly, a new block is added by operating the block addition button 130, and a new item is added by operating the item addition buttons 113 and 122. When a tab is added, a new first layer is added to the data format definition. When a block is added, a new second layer is added within the corresponding first layer of the data format definition. When an item is added, a new third layer is added within the corresponding second layer of the data format definition. Changing the tab, block, or item string will change the corresponding key in the data format definition. By operating a delete button on the keyboard of the client terminal 1, tabs, blocks, and items are deleted. When the registration button 500 in FIG. 4 is operated, a data format definition reflecting the screen structure displayed by the screen drawing unit 12 is created by the data format registration unit 13 and registered in the database 5 via the server 3. The When inputting data, a button for changing the screen configuration may be displayed as shown in FIG. 4 so that the value input and the hierarchical structure of the data can be changed simultaneously.

  The server 3 includes a data format access unit 31, a data access unit 32, and a data check unit 33. The server 3 of the present embodiment is a device that only performs data format definition and data input / output. The server 3 does not operate according to the information in the data and registers the data received from the client terminal 1 in the database 5 without converting it. Even when the data format definition or data is acquired from the database 5, the data format is transmitted to the client terminal 1 without being converted. However, when registering the data transmitted from the client terminal 1 in the database 5, it is checked whether or not the value in the data is in accordance with a predetermined rule (for example, the number of characters and check of usable characters).

  The data format access unit 31 acquires the data format definition from the database 5 in response to a request from the client terminal 1 and transmits it to the client terminal 1. When the data format definition is received from the client terminal 1, the data format definition is registered in the database 5.

  The data access unit 32 registers the data received from the client terminal 1 in the database 5. Before registering the data in the database 5, the data check unit 33 is checked whether or not a value is correctly input to the data.

  The data check unit 33 refers to the check definition stored in the database 5 and determines whether or not a value is correctly input to the data. If the value is not correctly input, the client terminal 1 is notified accordingly.

  FIG. 5 shows an example of the check definition. The check definition includes items to be checked, check method, and message. As a check method, there are a method for determining whether or not a regular expression is matched and a method for determining whether or not a logical expression is established. The data check unit 33 searches whether or not the check target item in the check definition exists in the data, and determines whether or not the value of the searched item is correctly input by a specified method. Since the check target items of the check definition are described according to the hierarchical structure of the data format definition, the check target items can be expressed intuitively. For example, in the example of FIG. 5, “contractor name” of “contractor information” of “common item” is an item to be checked. When the value is not correctly input, the corresponding message in the check definition is notified to the client terminal 1.

  The database 5 stores data format definitions, check definitions, and data. The data format definition and data are stored in the JSON format data structure described above. By storing the data format definition and the data in the same data structure, it is not necessary to perform data conversion in the server 3. The client terminal 1 can also configure the screen according to the data format definition and the hierarchical structure of data without converting the received data format definition and data. Since the database 5 stores the data in the data structure as it is, it is not necessary to change the configuration of the database 5 even if the data format definition is added, for example, by storing various data format definitions of several hundred types or more.

  FIG. 6 shows an example of data stored in the database 5. In the example shown in FIG. 6, a general DBMS that stores data using a table is used as the database 5, and the data is accommodated in one column of the table as it is. Data is stored in the same table regardless of the original data format definition. That is, data input based on various formats is stored in the table shown in FIG. When a search using some items as keys is assumed, the search key is defined as a separate column. In the example of FIG. 6, the data ID and the service name are search columns. Alternatively, a DBMS having a search function for the column contents may be used.

  Note that the units included in the client terminal 1 and the server 3 may be configured by a computer including an arithmetic processing device, a storage device, and the like, and the processing of each unit may be executed by a program. This program is stored in a storage device included in the client terminal 1 and the server 3, and can be recorded on a recording medium such as a magnetic disk, an optical disk, or a semiconductor memory, or provided through a network.

  Next, the operation of the data management system in the present embodiment will be described.

  FIG. 7 is a flowchart showing the flow of processing when registering data in the data management system according to the present embodiment.

  When the user designates a data format to be registered by operating the client terminal 1, the data registration unit 11 acquires a data format definition corresponding to the format (step S11). The user connects the client terminal 1 to the server 3, performs login processing, etc., and then selects a format of data to be registered by selecting from a list or inputting a format number or the like. When the data format definition to be acquired is determined, the data registration unit 11 of the client terminal 1 requests the server 3 to acquire the data format definition, and the server 3 acquires the corresponding data format definition from the database 5. It transmits to the client terminal 1.

  The screen drawing unit 12 configures and displays a screen according to the hierarchical structure of the data format definition (step S12). The screen rendering unit 12 configures a screen according to the received hierarchical structure of the data format definition, with the first layer being a tab, the second layer being a block, and the third layer being an item in the block.

  The user operates the client terminal 1 and inputs a value for each item in the screen (step S13). When the value input is completed, the data registration unit 11 transmits the data with the value input to the server 3.

  When the server 3 receives the data, the data check unit 33 checks the data (step S14). The data check unit 33 checks the value of the received data with reference to the check definition stored in the database 5.

  If the data has no problem in form, the data access unit 32 registers the data in the database 5 (step S15). The data access unit 32 stores the data structure of the received data in one column of the table of the database 5 as it is. If necessary, search data is extracted from the data and stored in a separate column as a search key.

  Next, the change of the data hierarchical structure will be described.

  Since the screen drawing unit 12 configures the display screen according to a rule in which data is determined only in accordance with the data hierarchical structure, it is not necessary to develop the screen drawing unit 12 even if the data hierarchical structure changes. Even after the data is registered in the database 5, the data may be read from the database 5 and the data structure of the data may be changed and stored in the database 5. For example, after the person in charge of receiving data registers the data in the database 5, the person in charge of construction acquires and references the data from the database 5, and adds information related to the construction to the data and stores it in the database 5. At this time, a new hierarchical structure for inputting information related to construction may be added. FIG. 8 shows an example in which an item of “construction information” is added to the data of FIG. When the screen drawing unit 12 configures a screen for displaying the data in FIG. 8, a screen is formed by adding a “construction information” tab to the screen shown in FIG. Even if the data structure of the data is changed, there is no need to change the client terminal 1 and the server 3.

  As described above, according to the present embodiment, various data format definitions are stored in the database 5, the client terminal 1 obtains a desired data format definition from the database 5, and the hierarchical structure of the data format definition A screen display function corresponding to an individual format by creating and displaying a screen according to the above, accepting data input, and storing the data whose values are entered in the data format definition in the database 5 in its hierarchical structure, It is possible to input data in various formats without developing a database configuration corresponding to each format.

DESCRIPTION OF SYMBOLS 1 ... Client terminal 11 ... Data registration part 12 ... Screen drawing part 13 ... Data format registration part 3 ... Server 31 ... Data format access part 32 ... Data access part 33 ... Data check part 5 ... Database

Claims (7)

A data definition storage means for store the data definition information that defines with the hierarchical structure of various modalities in a single column of the table,
Screen configuration means for acquiring the desired data definition information from the data definition storage means, configuring a screen according to the hierarchical structure of the data definition information, and receiving input of values;
Anda data storage means for store the data of the input hierarchical values to one column of the table in the data definition information,
The screen configuration means, when accepting input of a value, accepts addition of a new hierarchical structure to the hierarchical structure of the data. The screen configuration unit, the acquiring the data from the data storage means, according to claim 1, wherein the accepting additional changes and the new hierarchy to constitute a screen according to the hierarchical structure of the data values data management device. The data management apparatus according to claim 1, wherein the screen configuration unit arranges an element for adding a new item to each hierarchy of the hierarchical structure on a screen configured according to the hierarchical structure. . The hierarchical structure uses an associative array in which a key and a value are paired, and the hierarchical structure is expressed by taking an associative array for the value. The data definition information includes a key and a hierarchical structure, but contains a value. 4. The data management apparatus according to claim 1, wherein the data is a value to which a value corresponding to a key of the data definition information is input. Check definition storage means storing check definition information having a check target item in which the keys of the hierarchical structure of the data definition information are specified side by side and a determination method for determining whether the value of the item is correctly input;
Checking means for checking the data with reference to the check definition information when storing the data;
The data management apparatus according to claim 4, further comprising: A data management method executed by a computer,
Acquiring desired the data definition information from the data definition storage means for store the data definition information that defines one of the columns in the table by using the hierarchical structure of various styles,
A step of accepting the input of values constitutes a screen according to the hierarchical structure of the data definition information,
Storing data in a hierarchical structure in which a value is input to the data definition information in one column of the table,
A data management method characterized by accepting addition of a new hierarchical structure to the hierarchical structure of data when accepting input of a value .   A data management program for causing a computer to operate as each means of the data management apparatus according to claim 1.

Images