JPH1139202A - Data base management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data base management system which can accept data in accordance with the inputting section and the application of the data even when data inputted from a plurality of sections are temporarily contradictory to each other and, at the same time, can provide appropriate data in accordance with the application. SOLUTION: A data storing means 13 stores basic design data inputted through a data inputting means 12 at every data inputting section and, at the same time, the data corrected and added to the basic design data through an input device 2 at every inputting section. A data compatibility managing means 5 monitors the compatibility between overlapping data stored in the data storing means 13 and fetches the optimum information in accordance with an input request from an operator.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a database management system for managing input of data into a database and retrieval of data.

[0002]

2. Description of the Related Art Generally, a database management system includes:
Data is recorded in units of records in a file on a disk called a database, and the recorded data is searched and retrieved. The contents of a record are defined by a database definition called a "schema". The following describes an example of a schema of a database of materials necessary for a certain product as shown below.

Line 1 Database Material arrangement Line 2 Attribute 1 Product name Character string Line 3 Attribute 2 Part number Character string Line 4 Attribute 3 Part name Character string Line 5 Attribute 4 Parts material Character string Line 6 Attribute 5 Part quantity Numerical value 7th line Attribute 6 Delivery date Date 8th line Attribute 7 Special specifications Character string Here, the first line indicates that the name of the database is "Material arrangement". The second to seventh lines define the contents of the ladder code, and indicate that this record is composed of seven attribute areas. Each line defines one attribute, and includes an attribute identification display, an attribute name, and an attribute data type. Attribute data types include character strings, numeric values, dates, and the like. Records of this type are represented by relational databases, but may be considered to be similar in other databases.

Now, a product designer designs a product,
If the necessary materials are identified, the designer compiles the necessary materials into a material database and registers the data to arrange the materials. In this case, it is possible to automatically register data from any design system used by the designer, to register additional parts for special additional parts, and to register information automatically registered. Necessary information may be added. In addition, when the structure, function, and configuration of a product are complicated as in today, product design is often performed not by a single person but by a plurality of persons and a plurality of organizations working together.

[0005]

However, if data from a plurality of departments having different functions is to be registered in a database during product design, inconsistencies may occur temporarily depending on the type of the data. . For example,
Inconsistencies may occur temporarily depending on whether the registered data has occurred in the basic design or the detailed design, and whether the registered data is intermediate data or final data of the progress of the design.

[0006] Even with the same data, depending on the purpose of use, it may be necessary to correct and use the data under the responsibility of each department. For example, it is conceivable that even if the number of parts is sufficient in terms of design, in consideration of the loss in actual production, the arrangement may be slightly increased in order to arrange the parts.

[0007] Most of the conventional database management systems impose a restriction that one item representing one semantic content in one record must be exactly one. Therefore, under such restrictions, operations such as inflating and registering the number of materials have been rejected as actually reducing the reliability of data.

[0008] In the actual execution of work, such a state occurs on a daily basis. Prohibiting such a state is the original purpose of introducing a database to share data and improve work efficiency. Instead, each department in charge has a different database, which leads to inefficiencies.

[0009] Therefore, an object of the present invention is to provide a method for receiving data according to the input department and application even if the data input from a plurality of departments is temporarily inconsistent, and for selecting appropriate data according to the application. An object of the present invention is to provide a database management system that can provide the database management system.

[0010]

According to a first aspect of the present invention, there is provided a database management system comprising: a data input unit for inputting basic design data from an external system for each data input department; and a basic design data for each data input department. A data storage means for storing and adding and modifying the basic design data for each data input department via an input device, and monitoring consistency between duplicate data stored in the data storage means. Data consistency management means for extracting optimal information in response to an input request from an operator.

[0011] In the database management system according to the first aspect of the present invention, the data storage means stores the basic design data input through the data input means for each data input section, and stores the basic design data for each data input section. The modified and added data is stored through the input device. Then, the data consistency management means monitors the consistency between the duplicated data stored in the data storage means and extracts the optimum information in response to an input request from the operator.

According to a second aspect of the present invention, in the database management system according to the first aspect, the data storage means includes an interface input area for storing basic design data input for each data input section by the data input means; A correction data area for storing the correction data corrected by the operator via the input device for the basic setting data for each data input department, and an operator for adding the basic setting data for each data input department via the input device. And an additional data area for storing the obtained additional data.

[0013] In the database management system according to the second aspect of the present invention, in addition to the operation of the first aspect, the basic design data for each data input section input by the data input means is stored in the interface input area of the data storage means. The correction data corrected by the operator via the input device is stored in a correction data area of the data storage unit, and the additional data added by the operator via the input device is stored in the additional data area of the data storage unit. Is done.

According to a third aspect of the present invention, in the database management system according to the second aspect of the present invention, the data consistency management means includes: basic design data stored in an interface input area of the data storage means; Management collation means for monitoring consistency between duplicated data based on key items for linking the correction data stored in the area and the additional data stored in the additional data area of the data storage means, and an input device provided by an operator. And updating means for storing the corrected data in the corrected data area of the data storage means and for storing the added data in the additional data area of the data storage means, respectively, when the data is corrected or added through the data storage means.

[0015] In the database management system according to the third aspect of the present invention, in addition to the operation of the second aspect of the present invention, the management collation means of the data consistency management means may further comprise a basic design data stored in an interface input area of the data storage means. Correction data stored in the correction data area of the data storage means,
The consistency between the duplicated data is monitored based on the key items linking the additional data stored in the additional data area of the data storage means. The updating means of the data consistency management means stores the corrected data in the corrected data area of the data storage means and stores the additional data when the operator corrects or adds data via the input device. Each is stored in the additional data area of the means.

According to a fourth aspect of the present invention, in the database management system according to the third aspect of the present invention, when the data consistency management means retrieves data from the data storage means, the data consistency management means is based on a search item specified by the input device. A search means is provided for searching the corresponding data and searching for basic design data, correction data, and additional data in accordance with a predetermined priority.

According to a fourth aspect of the present invention, in addition to the operation of the third aspect of the present invention, the retrieval means of the data consistency management means specifies an input device when data is retrieved from the data storage means. The corresponding data is searched based on the searched search item, and the basic design data, correction data, and additional data are searched according to a predetermined priority.

According to a fifth aspect of the present invention, in the database management system according to the third or fourth aspect,
The data consistency management means includes a deletion means for setting a deletion flag for setting data to be logically deleted in data sharing the key item.

In a database management system according to a fifth aspect of the present invention, in addition to the operation of the third or fourth aspect, the deletion means of the data consistency management means shares a key item with the data to be deleted. A deletion flag is set for the data to be logically deleted.

[0020]

Embodiments of the present invention will be described below. FIG. 1 is a configuration diagram of a database management system according to an embodiment of the present invention.

The database management system 1 is configured on a computer, and an input device 2 and an output device 3 as peripheral devices are connected to a data consistency management means 5 via a data input / output means 4. A keyboard 6 and a mouse 7 are connected as the input device 2, and the output device 3 is
The display 8, the disk 9, and the printer 10 are connected.

Further, the database management system 1 is connected to an external system 11 for interfacing from the outside. Basic design data for each data input section is input from the external system 11 via the data input means 12a to 12n, and stored in the data storage means 13a to 13n, respectively. On the other hand, in the data storage means 13a to 13n,
The modified data obtained by modifying the basic design data for each data input department by the operator via the input device 2 and the additional data added by the operator are stored.

The data consistency management means 5 monitors the consistency between duplicate data among the data stored in the data storage means 13a to 13n, and responds to an input request from the input device 2 by an operator. This is to extract the optimal information. The data consistency management means 5 is a management collation means 14 for collating data stored in the data storage means 13a to 13n and monitoring consistency between duplicated data.
Updating means 15 for storing correction data and additional data for the basic design data in the data storage means 13
A search unit 16 for searching data stored in the data storage unit; and a deletion unit 17 for setting the data stored in the data storage unit 13 to a deletion state.

FIG. 2 shows the structure of the data storage area of the data storage means 13.
Is the interface input area 18, the correction data area 1
9, an additional data area 20 is provided. The interface input area 18 is an area for storing basic design data from the external system 11. The correction data area 19 is
When the operator inputs correction data from the input device 2 to the basic design data from the external system 11, this area stores the correction data. Additional data area 20
Is an area for storing additional data added by the operator without belonging to any of these. The correction data area 1
9 and the additional data area 20 are updated by the updating means 15 when the operator corrects or adds data using the input device 2.

FIG. 3 is an explanatory diagram when the database “valve parts” is managed by the database management system 1 according to the embodiment of the present invention. FIG. 3A shows basic design data of the database “valve parts” stored in the interface input area 18 of the data storage means 13, and FIG. 3B shows the database “data stored in the correction data area 19 of the data storage means 13. FIG. 3C shows the additional data of the database “valve parts” stored in the additional data area 20 of the data storage means 13.

Here, the "valve number" field of each record of the basic design data, correction data, and additional data of the "valve part" of the database is a key item for linking the respective data.

Now, it is assumed that basic design data of the database "valve parts" is input from the external system 11 as basic design data. Data from the interface from the external system 11 is stored in the interface input area 18 in the data storage means 13 as shown in FIG.

FIG. 3A shows two records in the database. The valve number of record number 1 is F001, the bore is 300A, the model is GV, and the number is 1
It is. The valve number of record number 2 is F002, the bore is 300A, the model is GV, and the number is 1. In addition, the deletion flag puts the record in a deletion state,
When a flag is set by a deletion unit 17 described later, the record is deleted as data.

Next, with the progress of the design stage from the basic design stage to the subsequent detailed design stage, it is necessary to change the model of the valve number F001 from GV to PG representing a more detailed model, and to change the model of the valve number F002. If it is necessary to change the number from one to two, the operator converts this data to GV
The operation of updating from to PG and the operation of updating from one to two are performed.

According to the present invention, when the operator performs this operation, the updating means 15 of the data consistency management means 5 does not directly rewrite the basic design data of the interface input area 18 but FIG. As shown in (b), the model item of the correction data area 19 of the data storage means 13 is set to PG
And the operation of correcting the number item to 2 is performed. Then, the corrected model PG and the corrected number 2 are used as correction data as the correction data area 1 of the data storage unit 13.
9 is stored.

Further, when data is added for arranging these parts, the operator in charge of the arrangement adds an ordering party, a delivery date, and other special specifications. The items added at this time are information that cannot be obtained from the basic design data that is an interface input from the external system 11, and thus are separately stored in the additional data area 20 of the data storage unit 13. Also in this case, as shown in FIG. 3C, the updating unit 15 of the data consistency managing unit 5
The data to be added, the ordering party, special specifications, and delivery date are stored in the additional data area 20 of the data storage unit 13. Then, a form as shown in FIG. 4 is finally created from these three data.

In this series of operations, each correction result is appropriately written in an appropriate area without directly rewriting the original item, and a history of data input and correction is left.

Next, when the record on the database becomes unnecessary, the deletion unit 17 is activated from the input device 2 and
A deletion flag is set for the relevant record and all the records that share the key item with the relevant record, and the data is logically deleted so that the data is externally deleted.

That is, when a particular part becomes unnecessary during the design, it is necessary to delete the data from the database. Here, a deletion flag is added to the record stored in each of the three data areas. In this case, a logically deleted state is provided from the outside as if it had been deleted.

As described above, the record is stored rather than physically deleted. Thus, when the data is needed again in the future, the restoration process, that is, the deletion flag is cleared, and the data input in the past can be reused, and the efficiency of business can be improved. it can.

When data is to be extracted from the data storage means 13 for various purposes, the input device 2 uses the search means 16.
Start In this case, basic design data, correction data,
Since there is additional data or the like, appropriate data can be extracted according to a predetermined priority. That is, when a certain form is to be output, each item constituting the form should be extracted from the basic design data of the interface input area 18, the correction data by the operator, or the additional data. In this case, priorities are determined, and a search is performed so as to follow this rule when executing the processing.

That is, when the operator accesses the database from the input device 2 for the purpose of outputting a form,
The form is searched for data according to preset data search and adoption priorities, and the result is displayed on the display 8 as the output device 3 or printed on the printer 10.

When data items having the same meaning are input by a plurality of data input means 12, a temporary inconsistency arises. However, the management collating means 14 determines the contents of the mutual records by key items. To allow the operator to match. In other words, inconsistencies caused by differences in data items in the interface input area, the correction data area, and the additional data area in the data storage means 13 due to a temporary or difference in the purpose of use are managed by the management collation means 14 and are required. The inconsistency is displayed on the screen of the display 8 in response to, and calls attention to the operator. As a result, even data items that appear to be inconsistent at first glance can be handled in an integrated manner if their actual meanings are consistent.

The three types of data, the interface input area, the correction data area, and the additional data area, are always
Depending on the key item, the management matching means 14 determines the state of the record,
That is, existence, non-existence, deletion. Manages non-deletion, etc.

As described above, in the embodiment of the present invention,
If there are multiple sources of data with the same content for the target database, the input data is managed according to the input source, and even if the operator is unfamiliar with the database, the data required when necessary Can be searched, updated, and deleted very easily.

[0041]

As described above, according to the present invention, in the operation of a database operating on a computer,
Even in the case where the expression method is different for items having the same meaning between the respective departments and persons in charge, the data can be effectively used in a form utilizing the expression. Further, even if there is a temporary inconsistency in data due to the progress of the work, it is possible to accurately manage the data, and it is possible to perform history management without impairing the reliability of the data.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a database management system according to an embodiment of the present invention.

FIG. 2 is an explanatory diagram of a data storage unit according to the embodiment of the present invention.

FIG. 3 is an explanatory diagram when a database “valve part” is managed by the database management system according to the embodiment of the present invention;

FIG. 4 is an explanatory diagram of a form of a database “valve part” created by the database management system according to the embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Database management system 2 Input device 3 Output device 4 Data input / output means 5 Data consistency management means 6 Keyboard 7 Mouse 8 Display 9 Disk 10 Printer 11 External system 12 Data input means 13 Data storage means 14 Management collation means 15 Update means 16 Search means 17 Deletion means 18 Interface input area 19 Corrected data area 20 Additional data area

Claims (5)

[Claims] 1. A data input means for inputting basic design data from an external system for each data input section, storing said basic design data for each data input section, and providing a basic design data for each data input section. A data storage means for storing the data corrected and added via the input device, and a monitor for monitoring the consistency between the duplicated data stored in the data storage means and responding to an input request from an operator, A database management system including a data consistency management unit for extracting information. 2. The database management system according to claim 1, wherein said data storage means includes an interface input area for storing basic design data input for each data input department by said data input means, and said data input department. A correction data area for storing correction data corrected by the operator via the input device for each basic setting data, and an operator adding the basic setting data for each data input section to the basic setting data via the input device; And a supplementary data area for storing the supplementary data. 3. The database management system according to claim 2, wherein said data consistency management means stores the basic design data stored in an interface input area of said data storage means and a correction data area of said data storage means. Management data matching means for monitoring the consistency between duplicated data based on key items for linking the corrected data, the additional data stored in the additional data area of the data storage means, and the input device by an operator. And updating means for storing the corrected data in a corrected data area of the data storage means and for storing the additional data in an additional data area of the data storage means, respectively, when the data is corrected and added through the data storage means. A database management system characterized by the following. 4. The database management system according to claim 3, wherein said data consistency management means, when retrieving data from said data storage means, based on a search item specified by said input device. And a search means for searching for basic design data, correction data, and additional data in accordance with a predetermined priority order. 5. The database management system according to claim 3, wherein said data consistency management means sets a deletion flag for logically deleting the data sharing the key item. A database management system comprising deletion means.