JPH11232160A - Database management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To make automatically decidable the propriety for referring to each data at the time of dynamically changing information which is the calculation reference of significance and is registered by an information provider side, and a calculating method for the significance, recalculating the significance and requesting data reference. SOLUTION: When new data are registered on a database 3, a data managing part 2 makes a significance calculating part 5 calculate the significance of the data and stores it together with the data in the database 3 when the calculation reference value and calculation method of significance are changed. When there is a data reference request, the part 2 decides whether or not the data of a reference object is shown according to the conditions of the reference request data, outputs only data which is decided as data referrable as a result to a reference data storage region 4 and makes the data to be shown.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database management system, and more particularly to a method for determining the importance of information for each data in a database based on reference data included in the data, and for determining whether or not a user can refer to the data. And a database management system that determines the value based on the importance of information and the importance of the user.

[0002]

2. Description of the Related Art Generally, a database stores a large amount of data, so that efficient and high-speed processing can be performed. Is assigned to each data. When a database management system that manages such a database receives a data reference request,
Since it is difficult to determine whether the data content can be referred to or not based only on the above-described reference value, it has to be manually performed. For this reason, this type of database management system requires a large amount of work for determination when a large amount of data reference requests are made, and also considers data display methods that take confidentiality management into consideration. It was not done.

[0003] Conventionally, a database that handles a large amount of data assigns a reference value calculated according to a certain calculation criterion to each data in the database, and increases the efficiency of a data processing method based on the reference value. Was. As a prior art relating to a database management system that manages data by giving the reference value, for example, Japanese Patent Laid-Open Publication No.
A technique described in Japanese Patent Publication No. 82 is known. According to this conventional technique, an access coefficient of input data is calculated at predetermined time intervals, thereby changing a storage location of data associated with a rank of a data reference requesting user.

[0004]

The above-mentioned system according to the prior art merely gives a reference value of data at regular intervals and changes the data storage position according to the reference value. It does not take into account the data management method and data display method used, and also changes the calculation method of the reference value, dynamically changes the calculation reference by the information provider, and changes the access coefficient at any timing thereafter. It did not take into account the dynamic change of the reference value with the change. Furthermore, the prior art described above
When there is a large amount of data reference request, the cost of the information provider to determine whether to display each data to be referenced and the output method that takes into account the confidential management of information based on this availability determination are also considered. It was not considered.

[0005] For this reason, the above-mentioned prior art uses the re-assignment of the importance of the data in accordance with the change of the calculation standard and the calculation method of the importance, and the automatic determination of whether or not to display each data at the time of the data reference request. However, there is a problem that it is difficult to display the determination result information in consideration of confidentiality management.

SUMMARY OF THE INVENTION It is an object of the present invention to solve the above-mentioned problems of the prior art, and to dynamically change information registered by an information provider or a method of calculating importance, which is a reference for calculating importance, and arbitrary timing thereafter. To provide a database management system capable of re-calculating the importance of data, automatically determining whether or not each data can be referenced at the time of a data reference request, and outputting the determination result to an information reference side in consideration of confidentiality management. is there.

[0007]

According to the present invention, an object of the present invention is to provide a database management system which determines the importance of each data stored as a database based on a calculation reference and a calculation method registered in advance by an information provider. An importance calculating means for calculating, by adding the calculated importance as an attribute of data and storing it in a database together with data, and when registering new data in the database, This is achieved by calculating and assigning the importance of the data by the calculating means.

[0008] In addition, the object is to provide a method for determining the importance of all the data whose importance is to be changed in the database when the information provider changes the calculation standard of the importance of the data or changes the method of calculating the importance. It is achieved by recalculating and reassigning.

Further, the object is to determine, when a data reference request is made, whether or not each of the data requested to be referred can be referred to based on the input reference request data condition and the importance. Determination means for displaying only the data determined to be referenceable by the determination means, and for the data determined to be determinable by the determination means, furthermore, by the importance of the data, This is achieved by performing a non-display process on a part or all of the display.

According to the present invention, by providing the above-mentioned means, it becomes possible to automatically determine, assign, and change the importance of data registered in the database without requiring any human intervention. Can be reduced.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a database management system according to the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a block diagram showing a schematic configuration of a database management system according to an embodiment of the present invention. FIG. 2 is a diagram for explaining an importance calculation reference table storing data used for calculating the importance of data. 3 is a flowchart for explaining a method of calculating importance for newly registered data;
FIG. 4 is a flowchart for explaining a method of calculating importance and a method for calculating data importance when a calculation reference is changed. FIG. 5 is a flowchart for explaining a processing operation of the information providing side at the time of requesting information reference. 6 is a flowchart for explaining the processing operation on the information reference side at the time of the information reference request. FIG.
, 1 is a control unit, 2 is a data management unit, 3 is a database, 4 is a reference data storage area, 5 is an importance calculation unit,
Reference numeral 6 denotes a display unit, and 7 denotes an operation unit.

As shown in FIG. 1, a database management system according to an embodiment of the present invention controls a whole system, and controls each process required for data management under the control of the control unit 1. A data management unit 2 and a database 3 storing all of the data, its attribute information, and some calculation criteria serving as references when determining importance
And a reference data storage area 4 for storing data to be referenced
And an importance calculation unit 5 for calculating the importance of each data when registering new data or changing the calculation reference of the importance of data, and for visualizing information necessary for data management and displaying the information on the information reference side. And an operation unit 7 for inputting various information or instructions from the system user.

In the database management system shown in FIG. 1, when new data is input from the operation unit 7 by the system user, the data is transferred to the data management unit 2 via the control unit 1. The data management unit 2 calls the importance calculation unit 5 to calculate the importance of the data, and sets the calculated importance as attribute information of the data.
The data is registered in the database 3.

When the system user inputs an instruction for calculating the importance from the operation unit 7, the calculation criterion is transmitted to the database 3 via the control unit 1 and the data management unit 2.
Registered in. When a new importance calculation criterion is input, immediately after that, the data management unit 2 calls the importance calculation unit 5 and recalculates the importance of all data stored in the database 3. Then, the importance of each data is reset. Details of this processing will be described later.

When a data reference request is issued from an information reference requester and reference data conditions are input from the operation unit 7, the data management unit 2 outputs data to the reference data storage area 4 based on the importance of the data. It is determined whether or not to perform the non-display processing on some of the data even if the data is to be displayed. Output the requested data.

The importance of the data described above is an index serving as a standard for expressing the importance of the data, and includes a character string included in the data which the data providing user considers important,
Number of appearances of information such as images and sounds in data,
It can be calculated based on quantitative information such as the appearance density.

Next, a method of calculating importance in the importance calculation section 5 will be described with reference to the importance calculation reference table shown in FIG.

The importance of the data is represented by, for example, an integer value from 0 to 100, or an importance value based on the integer value in a rank format, for example, A (importance: 100 to 8).
1), B (importance: 80-61), C (importance: 60-)
41), D (importance: 40-21), E (importance: 20)
~ 0).

In order to calculate the importance of such data, the importance calculation reference table stores the importance calculation reference data and the corresponding index of the importance calculation reference data as shown in FIG. ing. As described above, the importance calculation reference data is information such as a character string existing in each data in the database. In the example shown in FIG. 2, “development project” and “budget estimate” are given as examples. Have been. Also, this importance calculation reference data is:
It may be given to the entire data in the database.
In the example shown in FIG. 2, "secret" is cited as an example.

The index of the importance calculation reference data is:
The weighting for the importance calculation reference data used to calculate the importance is represented by a numerical value or the like, and “*” is set for the above “secret”,
Numerical values “0.40” and “0.25” are set for “development project” and “budget estimation”, respectively. "*" For "secret" means that when calculating the importance,
This means that the data is unconditionally given the importance of 100 or rank A.

In addition, the importance of the document data including the character string data such as “development project” and “budget estimate” is calculated by using the index of the importance calculation reference data in the table. It is obtained from the formula of the method. That is, for example, this importance may be calculated by calculating the value of the index of the importance calculation reference data by the appearance density of the importance calculation reference data in the document data for all the importance calculation reference data, and obtaining the sum of the values. it can. However, since this value is not relative importance to all data in the database, the importance of all data stored in the database to the importance calculation data is obtained by the above-described formula, and the maximum importance is calculated. It is necessary to modify the degree of importance to be 100.

The importance calculation reference table in the format described above may be not only the example illustrated in FIG. 2 but also various formats, and may be in the database 3. It may be held anywhere within.

Next, a method of calculating and setting the importance for newly registered data will be described with reference to the flow shown in FIG.

(1) If a person on the information providing side inputs data to register data of a new business or the like using the operation unit 7, the data is transmitted to the data management unit via the control unit 1. 2 (step 300).

(2) The data management unit 2 has a database 3
The importance calculating section 5 calculates the importance of the data of the new business or the like input from the calculation standard of the importance in the table registered in (1) (step 301).

(3) The data management unit 2 executes step 301
Is set in the attribute information of the input data of the new business or the like (step 302).

(4) The data management unit 2 stores data of a new business or the like in which importance is set as attribute information in the database 3
(Step 303).

The above-described processing of calculating the importance can be performed at an arbitrary timing after new data registration.
This timing is, for example, immediately after the registration of new data, or during a time period when the load on the system after the registration of new data is small.

Next, a method of recalculating the importance of data when the calculation reference is changed will be described with reference to the flow shown in FIG. In this example, for example, the character string data "Internet business" is added to the importance calculation standard, and the importance of the data with respect to all data in the database when an index for the character string data is given is recalculated.

(1) Now, the user on the information providing side makes a request to add character string data "Internet business" to the importance calculation standard using the operation unit 7, and the index of the data is input. It shall be assumed. At this time, the result is reflected in the table in the database 3 via the control unit 1 and the data management unit 2 (step 400).

(2) The data management unit 2 has a database 3
The 1 data to be changed in importance and the attribute information thereof are extracted, and a new importance is calculated based on the changed calculation criterion using the calculation formula described with reference to FIG. 2 ( Steps 401 and 402).

(3) The newly calculated importance is set in the attribute information of the data, and the data and the attribute information are stored in the database 3 (steps 403 and 40).
4).

(4) It is checked whether or not the importance has been reset for all the data whose importance is to be changed in the database 3.
The process from 01 is repeated (step 405).

As described above, it is possible to recalculate and change the importance of the data in consideration of the character string data of "Internet business" without requiring any manpower. Further, the method of changing the importance can correspond to various changes in the method of calculating importance, such as changing the number of appearances of the importance calculation method to the appearance density, changing the index of the importance calculation reference data, and the like. .

The above-described process of recalculating the importance recalculation can be performed at an arbitrary timing after the change of the importance calculation standard and the calculation method. This timing is, for example, immediately after the change of the importance calculation criterion or the calculation method, or in a time period when the load on the system is small after the change of the importance calculation criterion or the calculation method, for example, at night batch time.

According to the embodiment of the present invention,
It is possible to easily deal with a change in the calculation standard without manual operation.

Next, the processing operation of the information providing side at the time of the information reference request will be described with reference to the flow shown in FIG.

(1) A user who wants to view information monitors that the user makes an information reference request from the operation unit 7, and when the request is made, obtains information on the data reference request side and data reference conditions. The information on the data reference requesting side is, for example, the section manager of the requester, the position of the chief, etc., the name of the participating project, and the like, and can be extracted by the personal identification number from the operation unit 7, the ID card or the like. The data reference condition is
For example, the field, date, and the like of the reference desired data are input using the keyboard or the like of the operation unit 7 (step 50).
0, 501).

(2) Based on the information on the data reference requesting side and the data reference conditions, it is determined whether or not it is necessary to recalculate the importance of the data reference requesting user. For this judgment, even for general employees, it is necessary to raise the importance assigned to the person to the section manager and manager class depending on the field of the participant's project and the data desired to be referred. Also, in some cases, it is necessary to reduce the degree of importance, so that the necessity is determined (step 5).
02).

(3) If it is determined in step 502 that the importance of the data reference requesting user needs to be recalculated, the predetermined importance of the data reference requesting user is acquired. The previously given importance is determined, for example, by the position of the user, and can be acquired together with the above-described identity confirmation information (step 503).

(4) The importance of the data reference requesting user is recalculated based on the pre-given importance of the data reference requesting user, the information of the data reference requesting side, and the data reference condition. The process of providing information to the reference request side is started (steps 504 and 505).

Next, the processing operation of the information reference side at the time of the information reference request will be described with reference to the flow shown in FIG.

(1) A user who wants to view the information monitors that the user makes an information reference request from the operation unit 7, and when the request is made, obtains information on the data reference request side and data reference conditions. The processing up to this point corresponds to step 50 in FIG.
0, 501 (steps 600, 601).

(2) The data management unit 2 acquires one of the data to be referred and its data attribute based on the data reference condition, and compares the data importance with the data reference requesting user. To determine whether reference is possible. For example, if the importance of the data reference requesting user is rank B and the importance of the data is rank A, this determination is made by comparing A and B to determine that A> B. Can be determined to be impossible.
If reference is possible in this determination, a determination criterion is further generated.
(Step 603).

(3) If it is determined in step 603 that reference is possible and a determination criterion is generated, the data management unit 2 again generates the importance of the data and the importance of the data reference side user in step 603. It is determined whether or not a non-display part (such as a mosaic) is added to part or all of the data based on the determination criteria (step 604).

(4) In step 604, a part of the data
Or, if it is determined to add a hidden part to all,
Non-display processing is performed on part or all of the data, and the data is stored in the reference data storage area 4. If it is determined that the non-display processing is not performed, the data is stored in the reference data storage area 4 as it is ( Steps 605 and 606).

(5) The processing from step 602 is repeated until the processing for all the data to be referred to is completed, and the data stored in the reference data storage area is displayed. In this display, for the data that cannot be referred to, it may be displayed that it exists, or it may be displayed that it does not exist as data (steps 607 and 608).

According to the above-described processing, whether or not to display the data requested at the time of the data reference request to the database is determined.
Further, even if the data is displayed, it is possible to automatically determine whether to add a non-display part to part or all of the data.

According to the above-described embodiment of the present invention, when registering new data in the database, or when it is desired to change the information used as the basis for calculating the importance registered by the information provider and the method of calculating the importance, Thereafter, the importance can be recalculated at an arbitrary timing, and the data can be assigned to each data without manual operation. Also, by limiting the information-providing persons who can change the importance calculation criterion, it becomes possible to perform data confidentiality management.

Further, according to the embodiment of the present invention, when a large amount of data reference request is issued, it is determined on the information providing side whether or not to display each data to be referred from the conditions of the reference request data. The determination can be made without relying on human hands. Then, as a result of this determination processing, for example, it is possible to prevent the display of data that the user does not want to show to outsiders, such as business data, and in some cases, the determination processing has determined that reference is impossible. It is also possible not to notify the information reference request side of information that data exists.

Further, according to the embodiment of the present invention, even if the data determined to be a reference target is provided with a part (a mosaic or the like) that cannot be displayed on a part or all of the data depending on the condition, the user can obtain the necessary data. Only the part can be shown.

The above-described embodiment of the present invention can also be applied to a case where a non-display data is made displayable or a task of displaying a non-display part of reference data is performed by paying a fee or the like. it can.

[0054]

As described above, according to the present invention, the information registered by the information providing side, which is the basis for calculating the importance of the data in the database, or the dynamic change of the method of calculating the importance, the arbitrary change thereafter. Importance recalculation by timing,
Automatic determination of whether or not each data can be referred to at the time of a data reference request, and output to the information reference side in consideration of confidentiality management of the determination result can be performed almost without human intervention.

[Brief description of the drawings]

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

FIG. 2 is a diagram illustrating an importance calculation reference table storing data used for calculating the importance of data.

FIG. 3 is a flowchart illustrating a method of calculating importance for newly registered data.

FIG. 4 is a flowchart illustrating a method of calculating importance and a method of calculating data importance when a calculation reference is changed.

FIG. 5 is a flowchart illustrating a processing operation on the information providing side at the time of an information reference request.

FIG. 6 is a flowchart illustrating a processing operation on the information reference side at the time of an information reference request.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Control part 2 Data management part 3 Database 4 Reference data storage area 5 Importance calculation part 6 Display part 7 Operation part

Claims (5)

[Claims] In a database management system, there is provided importance calculating means for calculating the importance of each data stored as a database based on a calculation criterion and a calculation method registered in advance by an information providing side. A database management system wherein a degree is given as an attribute of data and stored together with the data in a database. 2. The database management system according to claim 1, wherein when registering new data in the database, the importance calculating means calculates and assigns the importance of the data. 3. When the information provider changes the calculation standard of the importance of the data or changes the method of calculating the importance, the importance of all the data whose importance is to be changed in the database is recalculated, The database management system according to claim 1 or 2, wherein the database management system is reassigned. 4. When a data reference request is made, it is determined whether or not each data set as a reference request target can be referred to, based on the input reference request data condition and the importance. 4. The database management system according to claim 1, further comprising means for displaying only data determined to be referable by said determination means. 5. The data determined to be determinable by the determining means, further, according to the importance of the data.
5. The database management system according to claim 4, wherein a part or all of the data is subjected to a non-display processing and displayed.