The present invention relates to a work history management apparatus and management method thereof for registering work history information and referencing work history information provided with access control.
A technology for controlling access to data is described in Japanese Patent Application Laid-Open Publication No. 2003-36207. The technology described in Japanese Patent Application Laid-Open Publication No. 2003-36207 maintains multiple pieces of data and stores the right to access each of the multiple pieces of data for accessing users. When a request to access data occurs, the access right is used to determine whether or not an accessing user is permitted to access the requested data.
It is characteristic of sharing the work history information that the information is so diversified and so increased in quantity as to cover targets of the information, work types, work places, workers, and work dates. The access control over the information is also diversified and complicated. Let us consider an example of sharing the shipping work history. Various access controls may be necessary for the shipping work history that may be referenced from: a company that undertakes the shipping work; a company as a destination of the shipping work with or without limitation on a specified reference time period; and an industry group under a certain condition such as permission to reference only the work history about recalled products. Japanese Patent Application Laid-Open Publication No. 2003-36207 provides access control by assigning the right to access each one of data. However, there are some problems. When the access control described in Japanese Patent Application Laid-Open Publication No. 2003-36207 is used for sharing the work history, various situations need to be considered, making it difficult for users to individually set the access right. The access control is unavailable when setting the access right is based on unknown information such as the reference time or conditions of goods to be processed.
It is therefore an object of the present invention to provide a work history management apparatus and management method of the same capable of facilitating setup of the right to reference or access diversified work histories and searching for the work histories.
A work history management apparatus according to an embodiment of the invention includes: a work history classification section that classifies a work history in accordance with a content of the work history and assigns a classification identifier; a work history registration section that associates the classification identifier with the work history and stores the work history in a storage device; and a work history reference section that responds to a work history reference request from a user, references a reference condition associating a user capable of referencing the work history with the classification identifier, and searches for the work history stored in the storage device so as to be able to be referenced by the user and correspond to the classification identifier.
According to a preferred aspect of the invention, a content of the work history contains a work subject, a work date, a work place, a work object, and a work content.
Another aspect of the invention provides a work history management apparatus including: a storage device for storing a reference condition that associates a work history with a classification identifier corresponding to a user capable of referencing the work history and a content of the work history; an input device for accepting a work history reference request from a user; a central processing unit that assigns the classification identifier to the work history in accordance with a content of the work history, stores the work history in the storage device in association with the classification identifier assigned to the work history, references a reference condition stored in the storage device in response to the work history reference request, and searches for the work history stored in the storage device so as to be able to be referenced by the user and correspond to the classification identifier; and an output device for outputting the searched-for work history.
Still another aspect of the invention provides a work history management method. According to the method, a central processing unit is connected with a storage device for storing a reference condition that associates a work history with a classification identifier corresponding to a user capable of referencing the work history and a content of the work history, an input device for accepting a work history reference request from a user, and an output device. The central processing unit assigns the classification identifier to the work history in accordance with a content of the work history, stores the work history in the storage device in association with the classification identifier assigned to the work history, references a reference condition stored in the storage device in response to the work history reference request, searches for the work history stored in the storage device so as to be able to be referenced by the user and correspond to the classification identifier, and outputs the searched-for work history to the output device. The invention may be capable of facilitating configuration of the right to reference or access varied work histories and searching for work histories.
These and other features, objects and advantages of the present invention will become more apparent from the following description when taken in conjunction with the accompanying drawings.
Embodiments of the present invention will be described in further detail with reference to the accompanying drawings.
The storage device 105 includes processing sections such as a work history registration section 4, a work history classification section 5, a work history reference section 7, and a reference condition addition section 8 for a work history table 1 such as a database table, a master table 2, a state table 3, and a program. The storage device 105 also stores work history classification definition 6 and reference condition definition 9 for a file or a database table that contains setup information.
The work history table 1 provides a database for tables that contain work histories. The following describes a work history with reference to an example of the work history table 1 as shown in
For example, the first line in
The work history records a work in terms of who (worker 15 that may or may not be a person as a subject of the work), when (work date 11), where (work place 12), what (object ID 13 as a work object not limited to a tangible entity), and how (work content 14 or a work name indicative of work content). The destination 16 is included on the premise that a work object is often moved (transported) after completion of the work content 14. This aims at recording the work history in association with the work prior to the move (transportation) without recording the move (transportation) as an independent work. It is possible to decrease the capacity of the work history table 1 and reduce the amount of information because the move (transportation) is not recorded as an independent work. Users may easily reference the work history.
The master table 2 provides a database of tables and the like that maintain information about workers and objects associated with the work history.
The state table 3 provides a database of tables and the like that maintain states of objects in the work history. State examples include a repairing or recalling state. The state table 3 maintains the most recent repairing or recalling state corresponding to each of products.
The work history classification definition 6 is equivalent to a file or a table that maintains conditions for classifying the work history according to the contents of the work history.
The second line defines addition of the classification “shipment to shop X from warehouse 1” to the work history containing “warehouse 1” as the work place, “shipment” as the work content, and “shop X” as the shipment destination. The fourth line defines addition (assignment) of the classification “shipment to shop X from warehouse 2 for maker A” to the work history containing “warehouse 2” as the work place, “shipment” as the work content, “shop X” as the shipment destination, and “maker A” as a manufacturer of a product (object) targeted for the work.
The reference condition definition 9 is equivalent to a file or a table that maintains reference conditions such as work history classifications referable for each of users or user groups.
The first line indicates that the work history assigned the classification “shipment to shop X from warehouse 1” is referable for a user whose user identifier is “shop X”. The third line indicates that the work history assigned the classification “shipment to shop X from warehouse 2 for maker A” is referable for a user whose user identifier is “shop X” or “maker A”.
The fifth line indicates that the work history assigned the classification “shipment to shop X from warehouse 4” is referable for a user having the user identifier “shop X” only within 12 hours from the work date. The sixth line indicates that a user having the user identifier “industry group Z” can reference the work history that is assigned the classification “shipment to shop X from warehouse 1” and is associated with an object “recalled and not returned” at the time of the reference.
According to the definitions on the first and sixth lines, the work history assigned the classification “shipment to shop X from warehouse 1” is basically referable for only the user having the user identifier “shop X”. When the object targeted for the work is “recalled and not returned” at the time of the reference, the work history is referable from not only “shop X” but also “industry group Z” that monitors recalls.
According to the example table in
The work history classification section 5 is a processing program that adds the classification to each of work histories that are input from the input device 102 or are received by the communication device 104. The classification is added in accordance with classification conditions defined in the work history classification definition 6. The work history registration section 4 is a processing program that uses the work history table 1 to register a work history supplied with a work classification identifier by the work history classification section 5. The reference condition addition section 8 is a processing program that adds a reference condition to a work history reference request that is supplied from the input device 102 or is received by the communication device 104. The reference condition is added in accordance with the user identifier supplied or received along with the work history reference request and the reference condition definition 9. The work history reference section 7 acquires a work history from the work history table 1 in accordance with the work history reference request supplied with the reference condition by the reference condition addition section 8. The work history reference section 7 outputs the work history to the output device 103 or the communication device 104.
The following describes processes of the work history management apparatus 100 in the order of a registration process and a reference process. The registration process for work histories will be described first. To register a work history, the work history classification section 5 adds the classification to the work history. The work history registration section 4 registers the work history to the work history table 1. A flow chart in
The following first describes an example of classifying a work history that is assigned “10:00 on March 10” as the work date, “warehouse 1” as the work place, “TV1” as the object, “sorting” as the work content, and “worker 1” as the worker. The process receives the work history (Step 901). The process searches the work history classification definition 6 shown in
The process determines “sorting at warehouse 1” as the classification to be added to the received work history. The work history registration section 4 registers the work history content to the columns from the work date 11 to the destination 16 as seen from the first line of the work history table 1 in
The process similar to that performed on the first line is performed for work histories on the second, third, sixth, and seventh lines with reference to the columns from the work date 11 to the destination 16 in
The following describes an example of classifying a work history that is assigned “11:00 on March 10” as the work date, “warehouse 2” as the work place, “TV3” as the object, “shipment” as the work content, “worker 2” as the worker, and “shop X” as the destination. The process receives the work history (Step 901). The process searches the work history classification definition 6 shown in
As the master object-ID maker-name condition 65, “maker A” and “maker B” are defined for the classifications “shipment to shop X from warehouse 2 for maker A” on the fourth line and “shipment to shop X from warehouse 2 for maker B” on the fourth line, respectively. The master object-ID maker-name condition 65 requires to reference the master. The process determines provision of the master condition (Step 903) and proceeds to Step 904. In accordance with the master object-ID maker-name condition 65, the process references the master table concerning objects in
As seen from the master object-ID maker-name condition 65 for the fourth and fifth lines of the work history classification definition 6 in
The process similar to the above is performed to classify a work history that is assigned “11:00 on March 10” as the work date, “warehouse 2” as the work place, “TV4” as the object, “shipment” as the work content, “worker 2” as the worker, and “shop X” as the destination. The maker name is identified as “maker B” because “TV4” corresponds to the fourth line of the master table in
The reference process for work histories will then be described. To reference a work history, the reference condition addition section 8 supplies a work history reference request with a reference condition concerning referable work histories. The work history reference section 7 performs the work history reference request supplied with the reference condition to limit referable work histories for acquiring a targeted work history. A flow chart in
The following describes an example where a user having the user identifier “shop X” issues a work history reference request at “15:00 on March 11” for “acquiring all work histories”. The process receives the issued work history reference request (Step 1001). The process acquires reference conditions containing the user identifier “shop X” (Step 1002). The process acquires classifications containing “shop X” as the targeted user identifier 92 from the reference condition definition 9 in
The process then supplies the received work history reference request with the acquired classifications as a condition and searches the work history table 1 (Step 1003). Specifically, the work history reference request aims to “acquire all work histories”. The condition is to match any of the classifications “shipment to shop X from warehouse 1”, “shipment to shop X from warehouse 2 for maker A”, “shipment to shop X from warehouse 2 for maker B”, and “shipment to shop X from warehouse 4”. The process acquires the work histories on the second, fourth, fifth, sixth, and seventh lines matching the condition from the work history table 1 in
The following describes another example of the work history reference request that specifies the user having the user identifier “shop X”. In addition to the above-mentioned example, the condition may specify the user having the user identifier “shop X” combined with the work place “warehouse 1”. The condition specifies the work place “warehouse 1” and any of the classifications “shipment to shop X from warehouse 1”, “shipment to shop X from warehouse 2 for maker A”, “shipment to shop X from warehouse 2 for maker B”, and “shipment to shop X from warehouse 4”. The condition matches only the second line of the work history table 1 in
The process then applies the filtering condition 95 for the acquired reference conditions to the acquired work histories (Step 1004). Of the acquired reference conditions, the filtering condition contains the time condition 93 “within 12 hours of work date” for the classification “shipment to shop X from warehouse 4” on the fifth line of the reference condition definition 9 in
As mentioned above, the user having the user identifier “shop X” issues the work history reference request for “acquiring all work histories” at “15:00 on March 11”. As a response, the process returns the work histories on the second, fourth, fifth, and seventh lines of the work history table 1 in
In this example, the time condition 93 in
The following describes an example where the user having the user identifier “maker A” issues a work history reference request for “acquiring all work histories”. The process receives the issued work history reference request (Step 1001). The process acquires a reference condition that corresponds to the user identifier “maker A” (Step 1002). From the reference condition definition 9 in
The process supplies the received work history reference request with the acquired classification as a condition to search the work history table 1 (Step 1003). Specifically, the work history reference request aims to “acquire all work histories”. The process uses the classification “shipment to shop X from warehouse 2 for maker A” as the condition and acquires the work history on the fourth line matching the condition from the work history table 1 in
The following describes an example where the user having the user identifier “industry group Z” issues a work history reference request for “acquiring all work histories”. The process receives the issued work history reference request (Step 1001). The process acquires a reference condition that corresponds to the user identifier “industry group Z” (Step 1002). From the reference condition definition 9 in
The process supplies the received work history reference request with the acquired classification as a condition to search the work history table 1 (Step 1003). Specifically, the work history reference request aims to “acquire all work histories”. The process uses the classification “shipment to shop X from warehouse 1” or “shipment to shop X from warehouse 4” as the condition and acquires the work history on the second, sixth, and seventh lines matching the condition from the work history table 1 in
The process applies the filtering condition 95 out of the acquired reference conditions to the acquired work histories (Step 1004). The acquired reference conditions contain “recalled and not returned” as the state condition 94 belonging to the filtering condition. Namely, the state condition 94 defines that the targeted object is “recalled and not returned” at the reference time. The process acquires current states of the object IDs “TV1”, “TV6”, and “TV7” in the acquired work histories from the state table in
The user having the user identifier “industry group Z” issues the work history reference request for “acquiring all work histories”. As a response, the process returns the past work histories concerning the objects that are currently recalled and not returned (Step 1005). Namely, the work histories contain “shipment” of “TV1” from “warehouse 1” to “shop X” conducted by “worker 1” at “11:00 on March 10” and “shipment” of “TV6” from “warehouse 4” to “shop X” conducted by “worker 4” at “12:00 on March 10”.
In this example, the state condition 94 in
It may be understood from the above-mentioned embodiment of the work history management apparatus that the work history management apparatus is useful for situations requiring users or a user group to reference a work history. For example, the work history management apparatus is useful for product distribution systems, traceability systems, and manufacturing systems that use work histories.
As mentioned above, the work history records “who”, “when”, “where”, “what”, and “how”. The above-mentioned work history management apparatus may be also used for intangible objects such as data and programs. In this case, the element “who” represents a user or a program that performs operations. The element “when” is equivalent to the time to update or reference data or a program. The element “where” may represent a storage device or a folder as well as a computer or a terminal used for a work. The element “what” represents data or a program. The element “how” represents update or reference. Based on these associations, the work history management apparatus may be used for such works as data update and program development.
The embodiment defines a reference condition for associating the classification corresponding to the work history content with a user or a user group that references the work history. When the user issues a work history reference request, the reference condition can be accordingly used to easily search the work history.
The embodiment provides the reference condition that associates the classification with the user. Setting of the reference condition eliminates the need for setting the reference right (access right) for each of varied work histories. The number of reference condition settings becomes smaller than that of reference right settings for each of work histories. This shortens the time required to determine availability of the reference.
The embodiment classifies a work history at the stage of registering the work history. The embodiment can reference the work history faster than a technology of classifying the work history at the stage of referencing the work history.
The embodiment further provides a filtering condition for filtering. Availability of the reference can be determined in consideration for the state of an object targeted for the work or the limitation on the time to reference the work history.
While we have shown and described several embodiments in accordance with our invention, it should be understood that disclosed embodiments are susceptible of changes and modifications without departing from the scope of the invention. Therefore, we do not intend to be bound by the details shown and described herein but intend to cover all such changes and modifications within the ambit of the appended claims.
Number | Date | Country | Kind |
---|---|---|---|
2008-214279 | Aug 2008 | JP | national |