JP3670108B2 - Information management system and recording medium recording information management program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention provides an information management system and an information management program for centrally managing infrastructure facilities, which are key facilities such as on-premises communication facilities and power supply facilities, and asset facilities such as terminals, telephones, desks, etc. The present invention relates to a recorded recording medium.
[0002]
[Prior art]
As management of facilities on the premises of buildings, there are management related to infrastructure facilities, which are basic facilities such as buildings themselves, communication facilities, and power supply facilities, and management related to asset facilities such as terminals, telephones, and desks.
By the way, the management of these infrastructure facilities and the management of asset facilities are generally different from each other. For this reason, as shown in FIG. 8, information is separately constructed under different information management functions.
[0003]
[Problems to be solved by the invention]
However, despite the infrastructure and asset facilities being managed separately, the information on these facilities is closely related. For example, the number of lines used by the asset facility cannot exceed the number of communication lines provided by the infrastructure facility. Also, the infrastructure facility management function side may want to manage the terminal information connected to the outlet, which is the terminal side connection provided by the infrastructure facility. In this case, the terminal information is managed by the asset facility side. Despite this, information input is also required on the infrastructure equipment side. For this reason, not only double labor is required for input, but also double holding of the information itself occurs.
The present invention has been made in view of such circumstances, and records that record infrastructure management, infrastructure information necessary for asset management, information management system that can share asset information, and centralized management, and an information management program The purpose is to provide a medium.
[0004]
[Means for Solving the Problems]
  In order to achieve the above object, the invention described in claim 1 of the present invention comprises at least first information management means and second information management means, wherein the first information management means is first information. One or more information management functions are provided for managing the database, and the second information management means is an information management system provided with one or more information management functions for managing the second information database. The information management means includes external information reference means for referring to the information database managed by the other information management means, and the referenced information database stores information stored in the referenced information database.According to information management contents by the information management means to be referred toGroup information table for classificationAnd a management table associated with the group information table by connection information, the management table including a management item corresponding to the group information of the group information table, and in the information database referred to by the management item The external information reference means searches the group information table for a classification corresponding to the management content to be referred to, and sets the management content to be referred to based on the search result. A function that refers to the connection information in the group information table including the corresponding classification, searches the management table associated with the connection information, and refers to the information database associated with the management item included in the retrieved management table When,It is characterized by having.
[0006]
  Claims2The invention described in claim 11In the information management system according to claim 1, the group information table includes a flag indicating a link state with an information management function included in the information management unit to be referred to, and the external information reference unit includes a flag in the group information table. It is characterized by confirming whether it is linked to a predetermined information management function of the information management means to be referred to.
[0007]
  Claims3The invention described in claim 12In the invention described in the above, the referenced information database includes an authority table in which an access authority for each information in the referenced information database is set for the flag in the group information table, and the external information reference unit includes The access authority for the information of the information management function linked by the flag is confirmed by referring to the access authority in the authority table.
[0009]
  Next, the claim4The invention described in (1) is a computer-readable recording medium that records an information management program for managing information in an information database, and includes information having one or more information management functions for managing information in the information database A management means and an external information reference means for referring to an information database managed by another information management program;The referenced information database includes a group information table for classifying information stored in the referenced information database according to information management contents by the referring information management means, and a connection with the group information table A management table associated with information, and the management table includes management items corresponding to group information in the group information table, and is associated with information in the referenced information database by the management items. Further, the external information reference means searches the group information table for a classification corresponding to the management content to be referred to, and based on the search result, the classification corresponding to the management content to be referred to is found. Refers to the connection information in the included group information table, and the connection information is associated Searches the management table refers to the information database that is associated with the management item included in the retrieved management tableIt is characterized by that.
[0011]
  Claims5The invention described in claim 14In the recording medium recorded with the information management program according to claim 1, the external information reference means refers to a flag in the group information table indicating a link state with an information management function provided in the information management means of the information management program By doing so, it is characterized in that it is confirmed whether it is linked to a predetermined information management function of the information management means.
[0012]
  Claims6The invention described in claim 15An information database managed by the other information management program is recorded on the recording medium recorded with the information management program described in the above, with respect to the flag in the group information table, the information database managed by the other information management program Including an authority table in which access authority to information is set, and the external information reference means confirms access authority to the information of the information management function linked by the flag by referring to the access authority in the authority table It is characterized by that.
[0014]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, an information management system according to an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram of an information management system according to an embodiment of the present invention. In the figure, reference numeral 1 denotes an infrastructure information database, reference numeral 2 denotes an asset information database, reference numeral 3 denotes an infrastructure management unit that manages the infrastructure information database 1, and reference numeral 4 denotes an asset management unit that manages the asset information database 2. Yes.
The infrastructure information database 1 includes a plurality of infrastructure information 11 such as information on buildings and floors, information on wiring, and information on power. Examples of the table configuration of the infrastructure information 11 are shown in FIGS. 2 shows an example of a building / floor table structure, FIG. 3 shows an example of a wiring table structure, and FIG. 4 shows an example of an electric power table structure.
On the other hand, the asset information database includes a plurality of asset information 21 such as information on terminals such as computers, telephones, and fax machines, and information on desks and chairs. It is assumed that the asset information 21 also has a table structure suitable for representing the information, as in the example of the table structure shown in FIGS.
[0015]
  As shown in FIG. 1, the infrastructure management unit 3 includes a plurality of infrastructure management functions 31 for managing the infrastructure information database 1. Here, as the infrastructure management function 31, a search for a wiring route from a terminal or a terminal, a usage status of an outlet that is a connection unit of a terminal device, an update when a terminal connection is changed in a DF (Distribution Frame) that is a wiring panel Etc. In addition, there is a management function for checking the number of lines that can be provided, the total power to be provided, the allowable load on the floor, and the like as a management function for obtaining overall information instead of individual information management functions. Meanwhile, Asset Management Department4In addition, a plurality of asset management functions 41 for managing the asset information database 2 are included. Here, the asset management function 41 includes registration of newly purchased assets. Also, as a management function to obtain overall information rather than individual information management functions, it is necessary to check the total number of required lines, required total electricity, and total weight of floor assets. There are management functions. The infrastructure management unit 3 and the asset management unit 4 include an external information reference unit (not shown). The external information reference unit can refer to / update the asset information 21 in the asset information database 2 as well as register, update, and reference the infrastructure information 11 by the infrastructure management function 31. Similarly, the external information reference unit in the asset management unit 4 can refer to / update the infrastructure information 11 in the infrastructure information database 1 as well as register, update, and reference the asset information 21 by the asset management function 41. In the present embodiment, it is assumed that the infrastructure management unit 3 and the asset management unit 4 are in separate control devices, and the infrastructure information database 1 and the asset information database 2 are also under the control of the respective control devices. Assume that it is built in a storage device. The infrastructure management unit 3 and the asset management unit 4 can access the infrastructure information database 1 and the asset information database 2 under the management of other management units via a communication line.
[0016]
Next, the configuration of a table provided in the asset information database 2 so that the infrastructure management function 31 in the infrastructure management unit 3 can refer to the asset information 21 in the asset information database 2 will be described with reference to FIG. .
In FIG. 5, reference numeral 6 denotes a group information table, which is a table provided for managing a plurality of asset information 21 in the asset information database 2 with asset groups having the same property. The item “group information name” of the group information table 6 is a name representing an asset group having the same property. For example, when classifying with the property that can be easily managed from the infrastructure management function 31 in the infrastructure management unit 3, the “group information name” is set to “logarithm 2” in order to classify by the logarithm that is the number of cores of the cable necessary for the terminal to be used. ”Or“ log 4 ”, or the asset information 21 is classified as“ PBX ”,“ 10BASE-T ”,“ ISDN ”or the like for classification by communication method. Hereinafter, the asset group having the same property is referred to as “group information”.
The “group information ID” in the group information table 6 is an identification number of the “group information name” and is provided to facilitate processing by the infrastructure management unit 3 and the asset management unit 4.
In this way, by providing the group information table 6 for managing assets having the same properties in groups and performing classification based on the infrastructure, asset information in the asset information database 2 conforming to the infrastructure management function 31 is obtained. 21 classifications are possible. Further, by searching the group information table 6 first, the search efficiency is improved as compared with the case where all the asset information 21 is searched. In the group information table 6, new group information can be set as necessary even later.
[0017]
The group information table 6 is provided with a flag for indicating a link relationship with each management function. Then, the management function to be linked for each group information is set by “ON” and “OFF” of this flag. Since this flag represents a link relationship with the management function, at least one of the plurality of flags is set to “ON” indicating a link. For example, the group information is “PC”, and this “PC” is also connected to a communication wiring and a power outlet, and management as a leased article is also required, the item “wiring terminal flag” in the group information table 6 is used. "," Power terminal flag "and" Asset terminal flag "are set to" ON ".
As described above, by including the flag indicating the link with the management function in the group information table 6, when the external information reference unit in the infrastructure management unit 3 refers to the group information table 6, the predetermined service management function 31. It is possible to easily confirm whether there is a link, that is, group information to be searched.
In addition, when a new infrastructure management function 31 is generated, it is possible to cope by adding this flag.
[0018]
Next, in FIG. 5, reference numeral 7 denotes a management table, which is provided for collecting management items to be managed for each group information. This is because the information held in the asset information 21 under the group information differs depending on what group information is managed and how the flag linked to the management function is set. Take action.
The item “terminal ID” of the management table 7 is a terminal identification symbol. The item “group information ID” is provided to enable a link with the group information table 6. The item “management item ID (1)”, “management item ID (2)”,... Is the identification number of the item to be managed, and can be associated with the data table 8 in which the actual asset information 21 is stored. Done.
Here, in order to cope with the addition of a new infrastructure management function 31, this management item can also be added.
In FIG. 5, it is assumed that an ID, which is an identification number in each table item, is a serial number automatically given at the time of data registration.
[0019]
Next, specific examples of the group information table 6, the management table 7, and the data table 8 when referring to the asset information 21 in the asset information database 2 from the infrastructure management unit 3 via the external information reference unit will be shown. FIG. 6 shows a specific example of each table when the asset information database 2 refers to the details of the terminal connected to the outlet which is the terminal side connection part in the search of the wiring route which is one of the infrastructure management functions 31. It is shown. Below, the steps when referring to the asset information 21 in the asset information database 2 related to the infrastructure management function 31 by the external information reference unit in the infrastructure management unit 3 will be described in order.
First, the infrastructure management function 31 uses the infrastructure information database 1 to start searching for terminal numbers to be searched. Then, the number of the outlet connected to the terminal is known, and the terminal ID of the terminal connected to the outlet is known.
Next, the external information reference unit in the infrastructure management unit 3 uses this terminal ID to access the asset database 2 and searches the management table 7 having the terminal ID to be searched. One management item is set in the searched management table 7, and the data table 8 is searched based on the management item ID.
[0020]
The retrieved data table 8 has a plurality of items, and the item name of each item is referred to another table in which the item name is defined, so that “item 1” = “IP address”, “item 2” = “ It is understood that “user name”, “item 3” = “electric power load”, “item 4” = “model name”,..., And display the item name and contents of each item as necessary. And finish the process.
As described above, the asset information 21 related to the infrastructure management function 31 can be referred to by the reference function of the asset information database 2 by the external information reference unit.
[0021]
As another example, a case where the infrastructure management function 31 confirms whether or not the total amount of power supplied to the terminal on a predetermined floor is sufficient is shown below.
The infrastructure management function 31 for obtaining the total electric power searches the infrastructure information database 1 to obtain the total provided electric energy for a predetermined floor.
Subsequently, the external information reference unit in the infrastructure management unit 3 searches the group information table 6 in the asset information database 2 and determines whether the “power terminal flag” of the item is “ON”. It is confirmed whether there is a link relationship with the infrastructure management function 31 for obtaining the total power.
If the “power terminal flag” of the group information table 6 is “ON”, the management table 7 and the data table 8 are sequentially searched based on the group information ID of the group information table 6. Based on the search result, the total power load of a predetermined floor is obtained.
Thereby, even if the infrastructure manager and the asset manager are different, the infrastructure manager can appropriately check whether the total power supply amount is sufficient for the total power load.
In addition, as a similar example, there are a case where it is confirmed whether the number of supply lines supplied by the infrastructure management function 31 is sufficient, a case where the weight of the asset is within the allowable load of the floor, or the like.
As described above, the asset information 21 in the asset information database 2 is referenced from the infrastructure management function 31 in the infrastructure management unit 3 using the external information reference unit.
[0022]
(Second Embodiment)
  FIG. 7 shows that the infrastructure management function 31 in the infrastructure management unit 3 can refer to the asset information 21 in the asset information database 2.RuIt is a figure which shows the structure in 2nd Embodiment of the table provided in the asset information database 2 for it. In the figure, the same reference numerals are given to the portions corresponding to the respective portions in FIG. A feature of the present embodiment is that the data table 8a has an item ID for each item, and there is an authority table 9 associated with the item ID. This authority table 9 is an access authority in which the management function whose link state is indicated by the setting of each flag in the group information table 6 indicates that the items in the data table 8a cannot be referred to, can be referred to, and can be referred to / updated. Is provided with a flag 10 for managing.
[0023]
In FIG. 5, it is assumed that two management functions a and b are in a link relationship in one group information table 6. The management function a updates the item 1 of the data table 8 and the item 2 is only for reference. On the other hand, the management function b refers to the item 1 and performs the update process of the item 2. In this case, if the two management functions a and b try to update the data of the items in the data table 8 via the group information table 6 at the same time, the data is inconsistent due to the simultaneous update by the two management functions a and b. In order to prevent occurrence, for example, when the data of the items in the data table 8 is being updated by the management function a, the data table is set so that the management function b waits for the update processing by the management function a to end. 8 exclusive control is performed.
However, with the table configuration shown in FIG. 7, even if two management functions are linked to one group information table 6, the access authority for each item in the data table 8a is set for each management function. Therefore, when the items to be updated are different as described above, even if the management function a is updating the item 1, the management function b can update the item 2.
[0024]
This flag 10 corresponds to each flag in the group information table 6, and the access authority can be set for those in which the flag in the group information table 6 is “ON”. An example of the flag 10 is as follows. The number on the left is the setting value of the flag 10, and the right indicates its meaning.
0: When the correspondence flag of the group information table 6 is “OFF”
1: When the correspondence flag of the group information table 6 is “ON” and reference is not possible
2: When the correspondence flag of the group information table 6 is “ON” and can be referred to
3: When the correspondence flag of the group information table 6 is “ON” and reference / update is possible
The flag 10 can also be set by the information manager.
[0025]
As an information management system in the above two embodiments, the embodiment in the case of referring to the asset information 21 in the asset information database 2 from the infrastructure management function 31 in the infrastructure management unit 3 has been described. The same can be done when referring to the infrastructure information 11 in the infrastructure information database 1 from the asset management function 41 in the section 4. An example in which the asset management function 41 refers to the infrastructure information 11 is to refer to building / floor data in the infrastructure information 11 in order to manage the position of assets such as desks and terminals on a predetermined floor.
In addition, as the information management system in the above two embodiments, the infrastructure management unit 3 and the asset management unit 4 are in separate control devices, and the infrastructure information database 1 and the asset information database 2 are also controlled by the respective control systems. It is assumed that it is built in a storage device under the management of the device, but is not limited to this. For example, the infrastructure management unit 3 and the asset management unit 4 are in the same control device, and the infrastructure information database 1 and the asset information database 2 are also stand-alone types constructed in a storage device managed by the control device. There may be.
In addition, as the information management system in the above two embodiments, two management units, that is, the infrastructure management unit 3 and the asset management unit 4 each have a database to be managed, and other information can be obtained by using an external information reference unit. Although the case of referring to the database managed by is shown, it is not limited to this, and even if there are more management units, it is possible to refer to the database managed by other management units in the same way It is.
Further, as the information management system in the two embodiments described above, the information to be managed is the infrastructure information 11 and the asset information 21. However, the information management system is not limited to this. That is, the information is generally managed separately, but the information management system of the present invention may be applied when the information is closely related.
Further, information management may be performed by recording a program for realizing the infrastructure management unit 3 and the asset management unit 4 on a computer-readable recording medium, reading the recording medium into a computer, and executing the program. Good.
[0026]
【The invention's effect】
As described above, according to the information management system and the recording medium recording the information management program according to the present invention, the following effects can be obtained.
According to the first aspect of the invention, the external information reference means for referring to the information database managed by the other information management means is provided. As a result, the information database managed by other information management means can be referred to, and information managed separately can be shared and centrally managed.
[0027]
  Also,The external information reference means refers to the information database managed by the other information management function means by referring to the group information table in the referenced information database. This makes it possible to classify the information in the referenced information database according to the property of the information of the information management means to be referenced, and to improve the search efficiency.
The referenced information database includes a management table associated with information in the information database referenced by the management item, and the external information reference means refers to the management item in the management table to refer to the information in the information database. Refer to As a result, management items can be set in accordance with the information management function to be referred to, and information in the referenced information database can be referred to.
[0028]
  Claims2According to the invention described above, the external information reference means refers to the flag indicating the link state with the information management function in the group information table. Thereby, it is possible to easily confirm whether the group information table being referred to is linked to a predetermined information management function.
[0029]
  Claims3According to the invention described in the above, the external information reference means confirms the access right to the information of the information management function linked by the flag of the group information table by referring to the access right in the right table. As a result, even if a plurality of information management functions are linked to one group information table, they can be updated simultaneously if the update information of the information management functions is different.
[0031]
  Claims4According to the invention described in (4), the information management program including the external information reference means for referring to the information database managed by another information management program is recorded. This makes it possible to refer to an information database managed by another information management program, and to provide an information management program capable of sharing and centrally managing separately managed information.
[0032]
   Also,The external information reference means refers to the information database managed by the other information management function program by referring to the group information table. This makes it possible to classify the information in the referenced information database according to the property of the information of the information management means to be referenced, and to improve the search efficiency.
The external information reference means refers to the information in the information database managed by the other information management program by referring to the management item in the management table. As a result, management items can be set in accordance with the information management function to be referred to, and information in the referenced information database can be referred to.
[0033]
  Claims5According to the invention described above, the external information reference means confirms whether or not there is a link relationship with the predetermined information management function by referring to the flag in the group information table. Thereby, it is possible to easily confirm whether the group information table being referred to is linked to a predetermined information management function.
[0034]
  Claims6According to the invention described above, the external information reference means confirms the access right to the information management function information linked by the flag of the group information table by referring to the access right in the right table. As a result, even if a plurality of information management functions are linked to one group information table, they can be updated simultaneously if the update information of the information management functions is different.
[Brief description of the drawings]
FIG. 1 is a block diagram of an information management system according to an embodiment of the present invention.
FIG. 2 is a diagram illustrating an example of a building / floor table structure in infrastructure information;
FIG. 3 is a diagram illustrating an example of a wiring table structure in infrastructure information;
FIG. 4 is a diagram illustrating an example of a power table structure in infrastructure information.
FIG. 5 is a diagram showing an example of a table structure in an asset information database.
FIG. 6 is a diagram showing a specific example of a table structure in an asset information database.
FIG. 7 is a diagram illustrating an example of a table structure in an asset information database according to the second embodiment.
FIG. 8 is a block diagram of a conventional example of an information management system.
[Explanation of symbols]
1 Infrastructure information database
2 Asset information database
3 Infrastructure Management Department
4 Asset Management Department
6 Group information table
7 Management table
8, 8a Data table
9 Authorization table
11 Infrastructure information
21 Asset Information
31 Infrastructure management functions
41 Asset management function

Claims (6)

At least a first information management unit and a second information management unit, wherein the first information management unit includes one or more information management functions for managing a first information database, and the second information management unit In the information management system having one or more information management functions for managing the second information database,
At least one information management means includes external information reference means for referring to an information database managed by the other information management means,
The referenced information database is
A group information table for classifying information stored in the referenced information database according to the management contents of the information by the referring information management means, a management table associated with the group information table by connection information, Including
The management table is
Including a management item corresponding to the group information of the group information table, associated with the information in the referenced information database by this management item,
The external information reference means includes
The group information table is searched for the classification corresponding to the management content to be referred to, and the connection information of the group information table including the classification corresponding to the management content to be referred to is obtained based on the search result. A function of referring to and searching a management table associated with the connection information, and referring to an information database associated with a management item included in the searched management table;
An information management system comprising: The group information table is
A flag indicating a link state with an information management function included in the information management means to be referred to,
The external information reference means includes
2. The information management system according to claim 1 , wherein whether or not the information management unit is linked to a predetermined information management function of the referring information management unit is confirmed by referring to a flag in the group information table. The referenced information database is
For the flag in the group information table, including an authority table that sets the access authority for each information in the referenced information database,
The external information reference means includes
The information management system according to claim 2 , wherein an access right to the information of the information management function linked by the flag is confirmed by referring to an access right in the right table. A computer-readable recording medium storing an information management program for managing information in an information database,
Information management means having one or more information management functions for managing information in the information database;
External information reference means for referring to an information database managed by another information management program is executed,
The referenced information database is
A group information table for classifying information stored in the referenced information database according to the management contents of the information by the referring information management means, a management table associated with the group information table by connection information, Including
The management table is
Including a management item corresponding to the group information of the group information table, and is associated with the information in the referenced information database by this management item,
Further, the external information reference means includes
The group information table is searched for the classification corresponding to the management content to be referred to, and the connection information of the group information table including the classification corresponding to the management content to be referred to is obtained based on the search result. A recording medium on which an information management program is recorded, characterized in that a management table associated with the connection information is retrieved and an information database associated with a management item included in the retrieved management table is referenced . The external information reference means includes
By referring to the flag in the group information table indicating the link state with the information management function provided in the information management means of the information management program, it is confirmed whether it is linked with the predetermined information management function of the information management means A recording medium on which the information management program according to claim 4 is recorded. The information database managed by the other information management program is:
About the flag in the group information table, including an authority table in which access authority to information in the information database managed by the other information management program is set,
The external information reference means includes
6. The recording medium recording the information management program according to claim 5 , wherein an access right to the information of the information management function linked by the flag is confirmed by referring to an access right in the right table .

Images