JP3626630B2 - Structured data creation system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a structured data creation system for structuring and storing data to be held in a database.
[0002]
[Prior art]
Structured data creation systems are used to create test data in the development of enterprise information systems.
A conventional structured data creation system includes an input device for inputting data items, a data storage unit for storing created data, and a data check / creation for creating structured data by checking a plurality of input data item values. Means. The data checking / creating means checks a plurality of data items received from the input device according to a certain condition, and if normal, structures them and stores them in the data storage unit.
[0003]
As such a structured data creation system, for example, Japanese Patent Laid-Open No. 62-217339 is disclosed. This technology inputs data together with its structure at the time of occurrence, and creates and stores this input data in a record of a predetermined format according to the structure, thereby eliminating all data replacement processing and reducing processing time. This is a shortening. That is, newly generated data is reformatted into a predetermined format and stored in a database, thereby shortening the processing time required for data replacement. According to such a database management system, a data structure can be freely created.
[0004]
[Problems to be solved by the invention]
However, the above-mentioned prior art has a fixed data structure pattern in the program, and items other than the data items given from the input device are also stored in the storage device, so only a certain data structure pattern can be created. In addition, there is a problem that unnecessary data items are created and a large-capacity storage device is required.
In addition, since the check condition is fixed in the program, there is a problem that the data check condition cannot be freely changed.
Furthermore, the technology disclosed in Japanese Patent Application Laid-Open No. Sho 62-217339 allows a data structure such as type, attribute, and length to be freely created in a database management system. Cannot be created freely.
[0005]
The present invention has been made in view of such circumstances, and its purpose is to create a free data structure in a structured data creation system that checks a plurality of input data items and stores them as structured data. And the structure which can change the check conditions with respect to a data item flexibly is provided.
[0006]
[Means for Solving the Problems]
In order to solve the above problems, a structured data creation system according to the present invention is a structured data pattern creation system using a database including a database management system. It is characterized in that a pattern constituted by can be created freely. That is, by defining the data structure and the check conditions in advance, it is possible to reduce the capacity of the storage device because it has a check function for the input value and the data pattern is not fixed.
[0007]
That is, the structured data creation system according to claim 1 is the structured data creation system for structuring and storing the data to be held in the database, the input means for inputting data items, and the data input by the input means Data processing means for performing a predetermined data check according to a pre-defined data structure and check conditions based on the item based on the item and creating structured data, storage means for storing the created data, and structure Output means for displaying the digitized data, and the storage means includes a data structure storage unit for storing combination information of items in advance as a data structure, and a length, an attribute, and an initial value constituting the data A data item storage unit that stores each information and check conditions including the number of digits, attributes, and range in advance, and A data storage unit for storing the data, wherein the data processing unit searches the data structure storage unit using the data pattern name given from the input unit as a key, and the data When the matching data pattern name exists as a result of the search by the structure search means, the number of data items and the item name in the data pattern stored in the data structure storage unit are given from the input means. The number of items is checked to see if it matches the item name, and if a mismatch is detected, the data structure check means for displaying an error message on the output means and the data pattern name that matches in the data structure search means If it does not exist or if a matching data pattern name exists, the data structure check means If a match is detected, a key item name given from said input means, said data item storage unit acquires data check condition than, checks the data items set values based on the acquired data check condition If the condition is not satisfied, a data item check means for displaying an error message on the output means, and if the check condition is satisfied by the data item check means, the data type name given from the input means is In addition, when the structured data is registered in the data storage unit, and at the same time, the search by the data structure search unit fails, a combination of each item is set as a new data pattern in the data structure storage unit. And a data creation means for registration.
[0009]
The structured data creation system according to claim 2 is the structured data creation system according to claim 1 , wherein the data processing means is further configured to retrieve or create data according to a processing mode given from the input means. When the processing mode is determined to be data search by the processing mode determination means and the processing mode determination means, the data pattern name, the data item name, and the data item setting value given from the input means are used. And a data search unit for searching the data storage unit and displaying a list of data on the output unit.
[0010]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, some of the embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a configuration diagram of a structured data creation system according to the first embodiment of the present invention. Referring to FIG. 1, a structured data creation system according to a first embodiment includes an input device 1 such as a keyboard, a data processing device 2 that operates under program control, a storage device 3 that stores information, and a display device. And the like.
[0011]
The storage device 3 includes a data structure storage unit 31, a data item storage unit 32, and a data storage unit 33. The data structure storage unit 31 stores item combination information in advance as a data structure. The data item storage unit 32 stores in advance information (length, attribute, initial value, etc.) and check conditions (digits, attributes, range, etc.) of each item constituting the data. Furthermore, the data storage unit 33 stores the created data.
[0012]
The data processing device 2 includes a data structure search unit 21, a data structure check unit 22, a data item check unit 23, and a data creation unit 24. The data structure search means 21 searches the data structure storage unit 31 using the data pattern name given from the input device 1 as a key. The data structure check means 22 finds the number of data items and the item names in the data pattern stored in the data structure storage unit 31 when there is a matching data pattern name as a result of the search by the data structure search means 21. It is checked whether the number of data items and the item name given from the input device 1 match. At this time, if a mismatch is detected, an error message is displayed on the output device 4.
[0013]
The data item check unit 23 selects the item name given from the input device 1 when the data structure search unit 21 fails the search or when the data structure check unit 22 detects a match after the search is successful. The data check condition is acquired from the data item storage unit 32 using the key. Then, the data item setting value is checked with the acquired data check condition, and if the condition is not satisfied, an error message is displayed on the output device 4. The data creation unit 24 adds the data type name given from the input device 1 and registers the structured data in the data storage unit 33 when the check condition is satisfied by the data item check unit 23. At the same time, if the data structure search means 21 fails to search, the combination of each item is registered in the data structure storage unit 31 as a new data pattern.
[0014]
Next, the operation of the structured data creation system of the first embodiment in FIG. 1 will be described. That is, in the figure, the data storage unit 33 stores the created test data. At this time, one piece of data is composed of a combination of items stored in the data item storage unit 32. The data structure storage unit 31 stores combinations of data items for each data pattern. Further, the data item storage unit 32 stores check conditions (number of digits, attribute, range, etc.) for each item.
[0015]
The data structure search means 21 receives a data pattern name and a plurality of data item names / setting values from the input device 1 and checks whether the data pattern name is stored in the data structure storage unit 31. When the data pattern name is stored in the data structure storage unit 31, it is regarded as an existing data structure, and the data structure check unit 22 checks the data structure. At this time, if the data pattern name is not stored in the data structure storage unit 31, it is regarded as a new data structure and the data structure check is not performed. If it is a new data structure or an existing data structure and the data structure check is normal, the data item check means 23 checks the validity of the set value.
[0016]
If the check result is normal, the data creation unit 24 structures the data and registers it in the data storage unit 33. At this time, if the data structure is new, the data pattern name is added to the combination of the item names and registered in the data structure storage unit 31. As a result, it is possible to create a free combination of data patterns without increasing the storage capacity of the storage unit with unnecessary data items.
In addition, it is possible to flexibly cope with the change of the check specification simply by changing the check condition stored in the data item storage unit 32.
[0017]
Next, the operation of the structured data creation system according to the first embodiment will be described in detail using a flowchart. FIG. 2 is a flowchart showing an operation flow of the structured data creation system according to the first embodiment shown in FIG. FIG. 3 is a configuration diagram of specific data stored in the storage device in the processing of each step of the flowchart shown in FIG.
[0018]
In FIG. 2, the data pattern name and the data item name / setting value given from the input device 1 are supplied to the data structure search means 21 and the search is started (step A1, hereinafter, steps are omitted). Then, the data structure search means 21 checks whether or not a data pattern corresponding to the data pattern name is stored in the data structure storage unit 31 (A2). When the data pattern corresponding to the data structure storage unit 31 is stored (A2, YES), since the data pattern is an existing data structure, the data structure (combination of data item names) given from the input device 1 is the data It is checked whether or not it matches the data structure stored in the structure storage unit 31 (A3).
If the data structures do not match (A3, NO), an error message is displayed on the output device 4 (A4).
[0019]
Next, in step A2, when the data pattern is a new data pattern and cannot be searched because it is not stored in the data structure storage unit 31 (A2, NO), or in step A3, the input data structure is If the data structure matches the data structure stored in the data structure storage unit 31 (A3, YES), the data item storage unit 32 is searched using the data item name given from the input device 1 as a key to check the data A condition is acquired (A5). Then, based on the acquired data check condition, the data item set value is checked (A6).
[0020]
As a result of checking each data item (A7), if the condition is satisfied for all items (A8, YES), the data pattern name, the data item name 1, the data item setting value 1, or the data item Data structured in the order of name n and data item set value n is created and stored in the data storage unit 33 (A9).
Further, it is checked whether or not it is a new data pattern (A10). If it is a new data pattern (A10, YES), the data pattern name, data item name 1 to data item name of the new data pattern are checked. n is stored in the data structure storage unit 31 (A11). On the other hand, as a result of checking each item of the data item, if the condition is not satisfied, an error message is displayed on the output device 4 (A4).
[0021]
For example, as shown in the configuration diagram of the specific data stored in the storage device shown in FIG. 3, the data pattern name “fruit”, the data item name 1 “mandarin orange”, the data item setting value 1 “1”, the data item name 2 When the information “apple” and data item set value 2 “10” is given from the input device 1, the data structure storage unit 31 is searched using “fruit” as a key. Here, since “fruit” is not stored in the data structure storage unit 31, it is regarded as a new data pattern. Next, the check condition for “mandarin orange” is read from the data item storage unit 32 and the item set value is checked. As a result of checking, since the condition is satisfied, the check condition for “apple” is read from the data item storage unit 32 and checked.
As a result of checking, since the condition is satisfied, the data is structured and stored in the data storage unit 33. Further, in this case, since it is a new data pattern, the data pattern “fruit” is stored in the data structure storage unit 31.
[0022]
Next, a second embodiment of the present invention will be described in detail with reference to the drawings. FIG. 4 is a configuration diagram of the structured data creation system according to the second embodiment of this invention. Referring to FIG. 4, the data processing device 2 of the second embodiment includes a processing mode determination unit 25 and a data search unit 26 in addition to the configuration of the data processing device 2 of the first embodiment of FIG. Have been added.
[0023]
The processing mode determination unit 25 determines “search” or “creation” according to the processing mode given from the input device 1. Further, the data search unit 26 uses the data pattern name, the data item name, and the data item set value given from the input device 1 when the processing mode is determined to be “search” by the processing mode determination unit 25. 33 is searched, and a list of data is displayed on the output device 4.
[0024]
FIG. 5 is a flowchart showing an operation flow of the structured data creation system of the second embodiment shown in FIG. Therefore, the operation of the second embodiment will be described in detail with reference to the flowchart of FIG.
First, according to the processing mode given from the input device 1, the processing mode determination means 25 determines whether it is “search” or “creation” (B1). When the processing mode is “creation”, the processing operation from step A1 to step A11 in the flowchart of FIG.
[0025]
If the processing mode is “search” in step B1, the data search means 26 searches the data storage unit 33 using the data pattern name, data item name, and data item setting value given from the input device 1 as keys (B2). ). As a result of the search, if matching data is stored in the data storage unit 33, a list of data is displayed on the output device 4. On the other hand, if no matching data is stored, an error message is displayed on the output device 4.
[0026]
FIG. 6 is a configuration diagram of specific data stored in the storage device in the processing of each step of the flowchart shown in FIG. For example, as shown in the configuration diagram of data stored in the storage device as shown in FIG. 6, data pattern name “vegetable”, data item name 1 “cabbage”, and data item setting value 1 “50” are input. If it is given from the device 1, the data storage unit 33 is searched with the keys “vegetable” and “cabbage: 50”. Here, as a result of the search, the given data pattern name, data item name, and data item setting value are stored in the data storage unit 33, so that the matched data is displayed in a list on the output device 4.
In this embodiment, by making the created data searchable, it can be used as reference information for the next data creation.
[0027]
The embodiment described above is an example for explaining the present invention, and the present invention is not limited to the above-described embodiment, and various modifications can be made within the scope of the gist of the invention. For example, in the configuration of the second embodiment, the case of one data processing device 2 has been described, but the data processing device 2 (terminal): storage device 3 = N: 1 can be used simultaneously from N terminals. It can also be extended to configurations.
[0028]
【The invention's effect】
As described above, according to the structured data creation system of the present invention, the data structure is not stored in the program but stored in the storage device, and only the necessary data items are stored in the data storage unit. Data of free structure can be created just by storing. As a result, it is possible to flexibly cope with addition / change of data items without correcting the program. Furthermore, the capacity of the data storage unit can be reduced, and the search time can be shortened.
Furthermore, since the data check conditions are not fixed to the program but stored on the storage device, the data check conditions can be added / corrected flexibly according to the addition / correction of the data item.
[Brief description of the drawings]
FIG. 1 is a configuration diagram of a structured data creation system according to a first embodiment of the present invention.
FIG. 2 is a flowchart showing an operation flow of the structured data creation system according to the first embodiment shown in FIG. 1;
3 is a configuration diagram of specific data stored in a storage device in the processing of each step of the flowchart shown in FIG. 2. FIG.
FIG. 4 is a configuration diagram of a structured data creation system according to a second embodiment of this invention.
FIG. 5 is a flowchart showing an operation flow of the structured data creation system according to the second embodiment shown in FIG. 4;
6 is a configuration diagram of specific data stored in a storage device in the processing of each step of the flowchart shown in FIG. 5. FIG.
[Explanation of symbols]
DESCRIPTION OF SYMBOLS 1 ... Input device, 2 ... Data processing device, 3 ... Memory | storage device, 4 ... Output device, 21 ... Data structure search means, 22 ... Data structure check means, 23 ... Data item check means, 24 ... Data creation means, 25 ... Processing mode determination means, 26 ... Data search means, 31 ... Data structure storage section, 32 ... Data item storage section, 33 ... Data storage section

Claims (2)

In a structured data creation system for structuring and storing data to be held in a database,
An input means for inputting data items;
Data processing means for performing predetermined data check according to a predefined data structure and check conditions by program control based on the data items input by the input means, and creating structured data;
Storage means for storing the created data;
Output means for displaying structured data,
The storage means
As a data structure, a data structure storage unit that stores combination information of items in advance, each piece of information including length, attribute, and initial value constituting the data, and a check condition including the number of digits, attribute, and range A pre-stored data item storage unit;
A data storage unit storing the created data,
The data processing means includes
Data structure search means for searching the data structure storage unit using the data pattern name given from the input means as a key,
As a result of searching by the data structure search means, when there is a matching data pattern name, the number of data items and item names in the data pattern stored in the data structure storage unit are given from the input means. A data structure check unit that displays an error message on the output unit if a mismatch is detected,
If there is no matching data pattern name in the data structure search means, or if there is a matching data pattern name, and if a match is detected in the data structure check means, Using the item name given from the input means as a key, acquire the data check condition from the data item storage unit, check the data item setting value based on the acquired data check condition, and if the condition is not met, an error Data item checking means for displaying a message on the output means;
When the check condition is satisfied by the data item check means, the data type name given from the input means is added, and the structured data is registered in the data storage unit, and at the same time, the data structure search is performed. A structured data creation system comprising: a data creation means for registering each combination of items as a new data pattern in the data structure storage unit when the search fails in the means. 2. The structured data creation system according to claim 1 , wherein the data processing means further includes processing mode determination means for determining whether to search or create data according to a processing mode given from the input means, and the processing. When the mode determination unit determines that the processing mode is data search, the data storage unit is searched based on the data pattern name, data item name, and data item setting value given from the input unit, and a list of data is displayed. A structured data creation system comprising: data search means for displaying on the output means.

Images