Information processing system

Abstract

[Problem] To provide an information processing system capable of immediately acquiring analysis information that contributes to traffic management using a multi-dimensional database. [Solution] An information processing system is provided with: a multi-dimensional database having at least a case dimension, a process dimension, and a personnel dimension in dimensions; a plan creation unit that creates a business plan including at least case information, process information, and personnel information for each dimension included in the database; and an actual performance management unit that inputs a job start time and a job completion time for the business plan, and the multi-dimensional database stores hierarchical structure data including at least the case information, the process information, the personnel information, the job start time, and the job completion time.

Description

Technical Field

[0001] The present invention relates to an information processing system capable of instantaneously obtaining analysis information, which is helpful for business management using a multidimensional database. Background Art

[0002] In the prior art, there are information processing systems for managing business plans and business performance. For example, in Patent Document 1, an invention regarding a production plan management system is described, which simplifies the input operation of production performance on the production site side, and the production performance management side and the production site side can share production performance in real time.

[0003] Prior Art Documents

[0004] Patent Documents

[0005] Patent Document 1: Japanese Patent No. 7148882 Summary of the Invention

[0006] In such a business plan management system, general information processing systems mainly adopt a design method using a one-dimensional database, which is used to ensure data matching and sequentiality by repeatedly performing the design of "combining a file set with a table structure and another file set with a table structure to create a new file set" when advancing the business in sequence. As a result, almost all the components required for the system are manually constructed.

[0007] However, in this design method, there are the following problems: it becomes inefficient as the scale and complexity of the system increase, and a large amount of human resources are invested to install it into a system. In addition, there is also the following problem: although it is a data structure suitable from the perspective of business implementation, from other perspectives (such as personnel evaluation and resource management concepts other than business implementation), it is necessary to reconstruct data suitable for other dimensions.

[0008] Regarding the latter problem, from the perspective of other dimensions, a means of making a program and data structure separately and then flexibly using them as inputs for other businesses is adopted, but there is a problem of time lag in this means. That is, it does not become a mechanism for the output speed of the analysis results required for business management in business plan management and the replacement frequency of the analysis results.

[0009] On the other hand, in order to solve the above problems, a design method using a multidimensional database instead of a one-dimensional database is considered. In a multidimensional database, data is represented in a "cube" structure, which has multiple dimensions, and each dimension represents a specific category and level. For example, data with different dimensions such as time, region, and product can be represented in an integrated view.

[0010] As a result, the necessity for reconstructing data and building it manually is significantly reduced. It is possible to instantaneously slice and dice (intercept and analyze) data according to different business requirements and analysis perspectives. Therefore, it is possible to quickly conduct data analysis from different perspectives such as business planning, personnel evaluation, and resource management.

[0011] However, in a multidimensional database, to create a system with a multidimensional database structure, the following structure is required: Based on predefined multidimensional business requirements (reports when advancing business in sequence, information forms required for human resource management, information forms required for cost management and control), design the smallest data unit of the multidimensional database, and attach additional data to this smallest data unit to meet the multidimensional business requirements. In this way, the designer of the multidimensional database needs to have both the ability to define multidimensional business requirements and the ability to build the system.

[0012] However, it is very difficult to learn these two aspects of capabilities (it is necessary to be proficient in various businesses and be able to build a system based on a design concept different from the past). Although there has been a design concept itself in the past, it has not yet reached the design definition.

[0013] The inventor of the present invention obtained the following insights in the design of the business management system: By creating containers such as a case dimension, a process dimension, and a personnel dimension, and inputting information such as "job start · job end", which is the smallest unit of data, into them so that it can be used in each container, a multidimensional database that can be easily utilized can be constructed.

[0014] (1) Based on the above insights, the information processing system of the present invention includes: a multidimensional database having at least a case dimension, a process dimension, and a personnel dimension in terms of dimensions; a plan-making unit that makes a business plan, and the business plan includes at least case information, process information, and personnel information of each dimension included in the database; and an actual performance management unit that inputs a job start time and a job completion time for the business plan, and the multidimensional database stores hierarchical structure data, and the hierarchical structure data includes at least the case information, the process information, the personnel information, the job start time, and the job completion time.

[0015] This information processing system makes flexible use of the multidimensional database and can easily make a business plan based on the case dimension, the process dimension, and the personnel dimension. In addition, it is possible to perform analysis for each dimension, which is beneficial to the efficiency improvement of project management, resource management, etc.

[0016] As a result, a more detailed and efficient plan is achieved.

[0017] (2) Further, in the information processing system, there is a product dimension. The planning department creates a business plan, which includes product information in addition to the case information, process information, and personnel information. The multi-dimensional database records hierarchical structure data, which includes product information in addition to at least the case information, process information, personnel information, operation start time, and operation completion time.

[0018] In this information processing system, in particular, the personnel dimension has a hierarchical structure in the order of operator information, operation start time, operation completion time, case information, and process information, enabling progress tracking at the individual level, centralized personnel management, etc.

[0019] (3) In the information processing system, the case dimension of the multi-dimensional database has a hierarchical structure in the order of case information, process information, operator information, operation start time, and operation completion time.

[0020] (4) In the information processing system, the case dimension of the multi-dimensional database has a hierarchical structure in the order of the case information, category information, process information, operator information, operation start time, and operation completion time.

[0021] (5) In the information processing system, the process dimension of the multi-dimensional database has a hierarchical structure in the order of the category information, process information, case information, operator information, operation start time, and operation completion time.

[0022] (6) In the information processing system, the product dimension of the multi-dimensional database has a hierarchical structure in the order of the product information, process information, case information, operator information, operation start time, and operation completion time.

[0023] According to the information processing system of the present invention, business plans and business achievements can be efficiently managed using a multi-dimensional database. Specifically, the following functions can be provided: the function of being able to view a report screen that completely eliminates the cumbersome operation reports and the results of operation reports on a weekly basis for each person; the function of being able to view the operation content of team members in one day; visualizing the progress of cases based on operation reports and the status of operation time spent, displaying the "degree of effort" after quantifying the countermeasures of the reporter himself / herself for the cases of operation report objects, and summarizing standard time, average planned time, planned vs. actual performance, etc. for each case and each product classification (category) in units of tasks.

[0024] That is, the present invention provides a new information processing system that can use such a multidimensional database to obtain business performance in real time and highly efficiently manage information required for improving business performance such as optimization of personnel allocation, improvement of processes, improvement of quotations, and personnel evaluation, thereby improving business performance. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] Figure 1 FIG. is a diagram showing the structure of an information processing system according to an embodiment of the present invention.

[0026] Figure 2 FIG. is a diagram showing the structure of a server according to an embodiment of the present invention.

[0027] Figure 3 FIG. is a functional block diagram of an information processing system according to an embodiment of the present invention.

[0028] Figure 4 FIG. is a schematic diagram of a multidimensional database according to the first embodiment of the present invention.

[0029] Figure 5 FIG. is a diagram showing the hierarchical structure of a multidimensional database according to the first embodiment of the present invention.

[0030] Figure 6 FIG. is a diagram showing the cooperation of information in a multidimensional database according to the first embodiment of the present invention.

[0031] Figure 7 FIG. is a "Job Instruction Management" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0032] Figure 8 FIG. is a "Job Instruction Details" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0033] Figure 9 FIG. is a "Job Instruction Details" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0034] Figure 10 FIG. is a "Job Instruction Sheet" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0035] Figure 11 FIG. is a "Job Record" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0036] Figure 12 FIG. is a new "Basic Information and Job Information" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0037] Figure 13It is the "Business Report Management" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0038] Figure 14 It is the "Business Report Management" screen displayed on the display unit of the information processing system according to the first embodiment of the present invention.

[0039] Figure 15 It is the "Everyone's Movements" screen displayed on the display unit of the information processing system according to the embodiment of the present invention.

[0040] Figure 16 It is a diagram showing the hierarchical structure of the multidimensional database according to the second embodiment of the present invention.

[0041] Figure 17 It is a diagram showing the collaboration of information in the multidimensional database according to the second embodiment of the present invention.

[0042] Figure 18 It is the "Job Instruction Management" screen displayed on the display unit of the information processing system according to the second embodiment of the present invention.

[0043] Figure 19 It is the "Job Instruction Details" screen displayed on the display unit of the information processing system according to the second embodiment of the present invention.

[0044] Figure 20 It is the "Job Instruction Sheet" screen displayed on the display unit of the information processing system according to the second embodiment of the present invention.

[0045] Figure 21 It is the "Job Record" screen displayed on the display unit of the information processing system according to the second embodiment of the present invention.

[0046] Figure 22 It is the new "Basic Information and Job Information" screen displayed on the display unit of the information processing system according to the second embodiment of the present invention.

[0047] (Description of Reference Numerals)

[0048] S: Information processing system; N: Network; DD: Pre-information database; DB: Multidimensional database; 1: Server; 2: Manager terminal; 3: Operator terminal; 19: Communication unit; 21: Registration acceptance unit; 22: Plan production unit; 23: Performance management unit; 24: Performance calculation unit; 25: Display control unit. Detailed Embodiments

[0049] <Device Structure of Information Processing System>

[0050] The information processing system S according to the embodiment of the present invention will be described with reference to the accompanying drawings.

[0051] The information processing system S is configured to include at least a server 1, a manager terminal 2, and an operator terminal 3. The server 1, the manager terminal 2, and the operator terminal 3 are interconnected via a network N such as the Internet.

[0052] The server 1 is a server that manages the operations of the manager terminal 2 and the operator terminal 3, and executes various processes for providing process management related to business and transaction operations.

[0053] The manager terminal 2 is an information processing device for manager operations for process management, and is composed of, for example, a PC (Personal Computer), a tablet computer, a smart phone, etc.

[0054] The operator terminal 3 is an information processing device operated by an operation supervisor at a business site or a work site, and is composed of, for example, a tablet computer, a smart phone, etc.

[0055] As Figure 2 shown, the server 1 includes a CPU 11 (Central Processing Unit), a ROM 12 (Read Only Memory), a RAM 13 (Random Access Memory), a bus 14, an input / output interface 15, an output unit 16, an input unit 17, a storage unit 18, a communication unit 19, and a drive D.

[0056] The CPU 11 executes various processes according to the program stored in the ROM 12 or the program loaded from the storage unit 18 into the RAM 13. Data and the like required for the CPU 11 to execute various processes are also appropriately stored in the RAM 13.

[0057] The CPU 11, the ROM 12, and the RAM 13 are interconnected via the bus 14. In addition, the input / output interface 15 is also connected to the bus 14. The output unit 16, the input unit 17, the storage unit 18, the communication unit 19, and the drive D are connected to the input / output interface 15.

[0058] The output unit 16 is composed of a display, a speaker, etc., and outputs various information as images and sounds. The input unit 17 is composed of a keyboard, a mouse, etc., and inputs various information. The storage unit 18 is composed of a hard disk, a DRAM 13 (Dynamic Random Access Memory), etc., and stores various data.

[0059] The communication unit 19 communicates with other devices (such as server 1, manager terminal 2, or operator terminal 3) via a network including the Internet. The storage unit 18 is a storage device such as a conventionally known HDD (Hard disc Drive) or SSD (Solid State Drive), and stores the digitized information. However, server 1 may also use the drive D on the cloud as the storage unit 18.

[0060] In addition, although not shown, in Figure 1 the information processing system S, the manager terminal 2 and the operator terminal 3 may also be PCs (Personal Computers), smartphones, or tablets having the Figure 2 hardware structure shown. When the manager terminal 2 and the operator terminal 3 are composed of smartphones or tablets, they have a touch panel as the output unit 16 and the input unit 17.

[0061] Next, the functional blocks for performing business assistance processing in the information processing system S will be described. Among them, the business assistance processing refers to a series of processes for realizing business assistance, and is composed of various sub-processes such as pre-registration information registration processing, business plan creation processing, and business performance registration processing. It realizes real-time unified management of information related to various businesses.

[0062] <Functions of the information processing system>

[0063] As Figure 3 shown, the information processing system S cooperates with the respective structures of server 1 to construct a business assistance system, which has a registration acceptance unit 21, a plan creation unit 22, a performance management unit 23, a performance calculation unit 24, a display control unit 25, a communication unit 19, a pre-information database DD, and a multi-dimensional database DB.

[0064] The registration acceptance unit 21 receives the pre-information required to use the business assistance system. The received pre-information is stored in the pre-information database DD and managed. The pre-information includes, for example, information related to "instruction number", "customer name", "case name", "main person in charge", "quantity", "scheduled completion date", "scheduled delivery date", "case summary", and "acceptance conditions" for each case, information related to "process" for the process, information related to "operator (person in charge)" for the personnel, and information related to "product" for the product. However, there is no particular limitation on what information is included in the pre-information.

[0065] Regarding advance information, specifically, "Instruction Number" represents an independent number that can identify a case, "Customer Name" represents the name of the customer (consignor) for each case, "Case Name" represents the name of each case, "Principal Person in Charge" represents the name of the person in charge of each case, "Quantity" represents information related to the finished products for each case, "Scheduled Completion Date" represents the scheduled completion date for each case, "Scheduled Delivery Date" represents the scheduled delivery date for each case, "Case Summary" represents the summary of each case, "Acceptance Conditions" represents the conditions for accepting a case, "Commodity" represents the name of the commodity involved in the business, "Process" represents the content of the process (business), and "Person in Charge" represents the name of the person in charge of executing the process (business).

[0066] The Planning and Production Department 22 creates a business plan, which includes a combination of one or more processes for executing the business. Specifically, based on the advance information, the Planning and Production Department 22 creates a business plan corresponding to the case according to the combination of one or more processes. The created business plan is stored in and managed by the advance information database DD.

[0067] <Multidimensional Database>

[0068] Next, the operation of the multidimensional database DB will be described. In order to analyze data from multiple perspectives, the multidimensional database DB organizes data in multiple "dimensions" and stores hierarchical structure data with a hierarchical structure for each dimension. In addition, in this embodiment, the first embodiment regarding a three-dimensional database and the second embodiment regarding a four-dimensional database are set, and the following description will be given.

[0069] <Three-Dimensional Database>

[0070] In the first embodiment, as Figure 4 shown, the multidimensional database DB has at least three dimensions: the case dimension, the process dimension, and the personnel dimension.

[0071] As the minimum data, date information, operator information, operation start time, operation completion time, case information, and process information are sent to the multidimensional database DB. As Figure 5 shown, the minimum data input to the multidimensional database DB is sent to each dimension in parallel, organized according to the hierarchical structure of each dimension, and stored as hierarchical structure data.

[0072] In the first embodiment, personnel hierarchical structure data is stored in the personnel dimension, case hierarchical structure data is stored in the case dimension, and process hierarchical structure data is stored in the process dimension.

[0073] As Figure 5As shown, in the personnel dimension, the multi-dimensional database DB of the first embodiment that has received the least amount of data generates and stores personnel hierarchical structure data in the order of date information, operator information, operation start time, operation completion time, case information, and process information. Additionally, in the case dimension, case hierarchical structure data is generated and stored in the order of date information, case information, process information, operator information, operation start time, and operation completion time. Furthermore, in the process dimension, process hierarchical structure data is generated and stored in the order of date information, process information, case information, operator information, operation start time, and operation completion time.

[0074] By organizing and storing the above-mentioned hierarchical data, the multi-dimensional database DB can, for example, easily track cases related to an operator and the operation time in the processes of that case through the personnel dimension. Thus, it is possible to clarify the analysis of the operator's business and how much time the operator spent on which cases and processes.

[0075] Also, for example, through the case dimension, regarding a specific case, it is possible to analyze which processes were carried out, who participated in the operation, and the time taken for the operation. Furthermore, through the process dimension, for example, it is possible to analyze which operator participated in a specific process in which case and what the operation time was.

[0076] As Figure 6 shown, the multi-dimensional database DB of the first embodiment collaborates with the pre-information database DD to attach information to and store the hierarchical structure data of each dimension. In addition to adding the operator information, personnel information, case information, process information, and date information, which are the minimum data, to each hierarchical structure data, information related to the operator, information related to the case, and information related to the process stored in the pre-information database DD are also added to construct the hierarchical structure data.

[0077] For example, regarding personnel information, it may include information related to the operator such as the name, age, gender, date of birth, etc. of the "operator (person in charge)". Regarding case information, it may include information related to the case such as the instruction number, customer name, case name, main person in charge, quantity, scheduled completion date, scheduled delivery date, case summary, case conditions, etc. Regarding process information, it may include information related to the process such as the operation category, etc.

[0078] <Operation of the Business Management System of the First Embodiment>

[0079] Next, regarding the operation of the business management system constructed by the information processing system S in the first embodiment, an explanation will be given based on the screen displayed on a display device (not shown) such as the monitor of the output unit 16.

[0080] In Figure 7The "Job Instruction Management" screen is shown. The "Job Instruction Management" screen can confirm the list of registered jobs. The "Job Instruction Management" screen has items for "Instruction Number", "Customer Name / Case Name", "Principal Responsible Person / Quantity", "Scheduled Completion Date / Scheduled Delivery Date", and "Status" for each job. Additionally, "Edit", "Instruction Book", and "Details" buttons are set for each job (Instruction Number / Case Name).

[0081] Through the "Create Job Instruction" screen described later, it is possible to input information related to the items of "Instruction Number", "Customer Name", "Case Name", "Principal Responsible Person", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" on the "Job Instruction Management" screen.

[0082] In Figure 8 the "Job Instruction Details" screen displayed when the "Details" button on the job management screen is clicked is shown. In the "Job Instruction Details" screen, a "Basic Information" column and a "Process Information" column are displayed.

[0083] In the "Basic Information" column, in addition to displaying "Instruction Number", "Customer Name", "Case Name", "Principal Responsible Person", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" shown on the "Job Instruction Management" screen, items such as "Case Summary" and "Acceptance Conditions" are also displayed, and the details of each job can be confirmed.

[0084] In the "Job Information" column, the item names of "Job Instructions" corresponding to each job and the "Total Operation Time" required (or previously required) for the job are displayed. In this embodiment, the item names of "Design" and "Initial Environment Construction" are displayed as the item names of "Job Instructions", and a button for indicating details (vertical "..." button) is set on the right side thereof. Additionally, a project showing "04:30" is displayed as the "Total Operation Time", that is, as the operation time of the job related to this screen, it shows that a time of 4 hours and 30 minutes is required.

[0085] By clicking on the item of "Job Instruction Details" displayed when the vertical "..." button at the right end of the item name of "Job Instruction" has the cursor placed on it Figure 9 is displayed. It is the "Job Instruction Details" screen. In the "Job Instruction Details" screen, items of "Job" (job name), "Responsible Person", "Preparation Time", "Operation Time per Page", and "Total Operation Time" are displayed, and a "× Close" button is set. In this embodiment, in the "Job Instruction Details" screen, the "Job" related to "Design" is displayed, and information on each item related to the design job is shown.

[0086] InFigure 10 FIG. 0 shows the "Job Instruction" screen displayed when the "Instruction Book" button on the job management screen is clicked. The "Job Instruction" screen enables confirmation of the details of job instructions. On the "Job Instruction" screen, in addition to the items of "Instruction Number", "Customer Name", "Case Name", "Case Summary", "Acceptance Conditions", "Principal Person in Charge", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date", [QR Code (registered trademark)] is also displayed. The job instruction can be printed by a printer that functions as the output unit 16. In addition, the [QR Code (registered trademark)] of the "Job Instruction" screen or the printed job instruction can be read by a smartphone or the like of the operator terminal 3.

[0087] In Figure 11 FIG. 1 shows the "Job Record" screen when the [QR Code (registered trademark)] of the "Job Instruction" screen is read. In the present embodiment, the screen of "Business Report" in step 3 of the "Job Record" is shown. In addition, the "Job Record" screen can also be displayed by clicking on the item of "Job Record" displayed when the vertical "..." button of the "Job" item on the "Job Instruction Details" screen is clicked. In this case, the display starts from step 1 of the "Job Record" screen.

[0088] When the [QR Code (registered trademark)] is read, the information related to the reporting object in step 1 and the process in step 2 of the "Job Record" is filled in the [QR Code (registered trademark)]. Therefore, there is no need to input the information related to the reporting object (job) in step 1 and the process in step 2, and there is no need to display the screens of step 1 and step 2 of the "Job Record", and the screen of "Business Report" in step 3 is displayed.

[0089] The "Business Report" screen of the "Job Record" enables confirmation of the past records of each job. The "Business Report" screen of the "Job Record" enables confirmation of the past records of each job, and at the same time, the job start time and job end time can be clocked in. In addition to the columns of "◆Reporting Object", "Reporting Process", and "◆Clock-in History", there are also a "Comment" column, buttons for "Start" and "End" (of the process), and a button for "[+] Add Comment".

[0090] "Reporting Object" displays the items of "Instruction Number", "Customer Name", and "Case Name" of the job instruction. When the button for "[+] Add Comment" is clicked, comments during the actual execution of the "Reporting Process" can be entered in the "Comment" column. In the "◆Clock-in History" column, during the display of the "Reporting Process", in addition to the "Person in Charge" and "Date" of the previously performed job, the "Start" time and "End" time of the job are also displayed.

[0091] When the "Start" button is clicked, the "start" time of the "◆ Punch History" of the job is stored. When the "End" button is clicked, the "end" time of the job is stored. In the "Person in Charge" column, the user of the operator terminal 3 that reads the QR code is stored. Regarding the "Date", the date when the QR code is read is stored. The "Date", "Person in Charge", "Start" time, and "End" time are sent to the multidimensional database DB as date information, operator information, job start time, and job completion time, respectively. In addition, the case information and process information are also sent to the multidimensional database DB at the same time.

[0092] In Figure 12 shows the "Basic Information and Process Information" screen related to a new job instruction displayed when the menu button (vertical "---" button, i.e., the so-called hamburger button) on the job management screen is clicked and "New" is clicked. In the "Basic Information and Process Information" screen related to the new job instruction, a "Basic Information" column and a "Process Information" column are displayed. In the "Basic Information and Process Information" screen related to the new job instruction, a new job instruction can be created.

[0093] In the "Basic Information" column, in addition to displaying the "Instruction Number", "Customer Name", "Case Name", "Principal Person in Charge", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" displayed on the "Job Instruction Management" screen, input items for "Case Summary" and "Acceptance Conditions" are also displayed. For each item, confirmation can be made by inputting information through the input unit 17 using the registration acceptance unit 21. In the "Job Information" column, the job information registered in the main information (not shown) can be selected and input.

[0094] Figure 13 and Figure 14 shows the "Business Report Management" screen. In the "Business Report Management" screen, the registered "business" can be corrected. Figure 13 shows the screen for opening the "(1) Object of Correction" tab of the "Business Report Management". In the screen for opening the "(1) Object of Correction" tab, columns for "User ID", "Name", "Affiliation", "Permissions", and "Separation" regarding each business correction object are set. The information of each correction object is stored in the main information (not shown) in the database.

[0095] Figure 14 shows the screen for opening the "(2) Correction Report Time" tab of the "Business Report Management". In the screen for opening the "(2) Correction Report Time" tab, in addition to setting the correction object ( Figure 14In addition to the items of "Instruction Number", "Case Name", "Process Name", "Report Date", "Start Time", "End Time", and "Correction" in "Takeo Oshima" (in [here]), buttons for "Correction" and "Deletion" are also provided.

[0096] When the "Correction" button is clicked, the "Start Time" or "End Time" of each process can be corrected. Additionally, when correction is made, a check mark is displayed in the "Correction" item as a record thereof.

[0097] Figure 15 Displays the "Everyone's Movements" screen. In the "Everyone's Movements" screen, the daily schedules (past and future) of each operator are shown. In the multidimensional database DB, through the hierarchical structure data storage of each dimension, data analysis and processing can be performed easily and quickly, and thus, displays such as "Everyone's Movements" can be made in real time.

[0098] <Operation of the Business Management System of the Second Embodiment>

[0099] In the second embodiment, the multidimensional database DB has four dimensions (not shown), namely, at least a case dimension, a process dimension, a personnel dimension, and a product dimension.

[0100] As the minimum data, in addition to date information, operator information, operation start time, operation completion time, case information, and process information, product information is also sent to the multidimensional database DB. The minimum data input to the multidimensional database DB is sent to each dimension in parallel, sorted according to the hierarchical structure of each dimension, and stored as hierarchical structure data.

[0101] In the second embodiment, personnel hierarchical structure data is stored in the personnel dimension, case hierarchical structure data is stored in the case dimension, and process hierarchical structure data is stored in the process dimension.

[0102] As Figure 16 shown, in the personnel dimension, the multidimensional database DB of the second embodiment that has received the minimum data generates and stores personnel hierarchical structure data in the order of date information, operator information, operation start time, operation completion time, case information, process information, and product information. Additionally, in the case dimension, case hierarchical structure data in the order of date information, case information, product information, process information, operator information, operation start time, and operation completion time is generated and stored. Furthermore, in the process dimension, process hierarchical structure data in the order of date information, process information, product information, case information, operator information, operation start time, and operation completion time is generated and stored.

[0103] Furthermore, the multi-dimensional database DB of the second embodiment generates and stores process hierarchical structure data in the order of product information, process information, case information, operator information, date information, operation start time, and operation completion time in the product dimension.

[0104] By using the above hierarchical organization to sort and store data, the multi-dimensional database DB can, for example, easily track cases related to an operator and the operation time in the processes of the case through the personnel dimension. Thus, it is possible to clarify the analysis of the operator's business and how much time the operator spent on which case and process.

[0105] In addition, for example, through the case dimension, for a specific case, it is possible to analyze which processes were carried out, who participated in the operation, and the time taken for the operation. Furthermore, through the process dimension, for example, it is possible to analyze which operator participated in a specific process in which case and what the operation time was.

[0106] In addition, for example, it is possible to analyze which operator participated in a specific product in which process in which case and what the operation time was.

[0107] As Figure 17 shown, the multi-dimensional database DB of the second embodiment collaborates with the pre-information database DD to attach information to and store the hierarchical structure data of each dimension. In addition to adding the operator information, personnel information, case information, process information, and date information, which are the minimum data, to each hierarchical structure data, information related to the operator, case, process, and product stored in the pre-information database DD is also added to construct the hierarchical structure data.

[0108] For example, regarding personnel information, it may include information related to the operator such as the name, age, gender, date of birth, etc. of the "operator (person in charge)". Regarding case information, it may include information related to the case such as the instruction number, customer name, case name, main person in charge, quantity, scheduled completion date, scheduled delivery date, case summary, case conditions, etc. Regarding process information, it may include information related to the process such as the operation category. Information related to the product may include information related to the structure of the product.

[0109] Next, regarding the operation of the business management system constructed by the information processing system S in the second embodiment, an explanation will be given based on the screen displayed on a display device (not shown) such as the monitor of the output unit 16.

[0110] In Figure 18The "Job Instruction Management" screen is shown. The "Job Instruction Management" screen can confirm the list of each registered job. The "Job Instruction Management" screen has items of "Instruction Number / Product", "Customer Name / Case Name", "Principal Person in Charge / Quantity", "Scheduled Completion Date / Scheduled Delivery Date", and "Status" for each job. In addition, buttons of "Edit", "Instruction Sheet", and "Details" are set for each job.

[0111] Through the "Create Job Instruction" screen described later, it is possible to input information related to the items of "Instruction Number", "Customer Name", "Product", "Case Name", "Case Summary", "Acceptance Conditions", "Principal Person in Charge", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" of the "Job Instruction Management" screen.

[0112] In Figure 19 the "Job Instruction Details" screen displayed when the "Details" button on the job management screen is clicked is shown. In the "Job Instruction Details" screen, a "Basic Information" column and a "Process Information" column are displayed.

[0113] In the "Basic Information" column, in addition to displaying "Instruction Number", "Product", "Customer Name", "Case Name", "Principal Person in Charge", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" shown on the "Job Instruction Management" screen, items such as "Case Summary" and "Acceptance Conditions" are also displayed, and the details of each job can be confirmed.

[0114] In the "Job Information" column, the item names of "Job Instruction" corresponding to each job and the "Total Job Time (required or past required)" for the job are displayed. In this embodiment, as the item names of "Job Instruction", items of "Design" and "Initial Environment Construction" are displayed, and a button for indicating details (vertical "..." button) is set on the right side thereof. In addition, as the "Total Job Time", an item of "04:30" is displayed, that is, as the job time of the job related to this screen, a time of 4 hours and 30 minutes is displayed.

[0115] In Figure 20Fig. shows the "Job Instruction" screen displayed when the "Instruction Book" button on the job management screen is clicked. The "Job Instruction" screen enables confirmation of the details of job instructions. On the "Job Instruction" screen, in addition to the items of "Instruction Number", "Customer Name", "Product", "Case Name", "Case Summary", "Acceptance Conditions", "Principal Responsible Person", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date", [QR Code (registered trademark)] is also displayed. The job instruction can be printed by a printer that functions as the output unit 16. In addition, the [QR Code (registered trademark)] of the "Job Instruction" screen or the printed job instruction can be read by a smartphone or the like of the operator terminal 3.

[0116] In Figure 21 Fig. shows the "Job Record" screen when the [QR Code (registered trademark)] of the "Job Instruction" screen is read. In this embodiment, the screen of "Process" in Step 3 of the "Job Record" is shown. In addition, the "Job Record" screen can also be displayed by clicking on the item of "Job Record" that appears when the vertical "..." button of the "Job" item in the "Job Instruction Details" screen is clicked. In this case, the display starts from Step 1 of the "Job Record" screen.

[0117] When the [QR Code (registered trademark)] is read, information related to the reporting object (job) in Step 1 and the process in Step 2 of the "Job Record" is filled in the [QR Code (registered trademark)]. Therefore, there is no need to input information related to the reporting object (job) in Step 1 and the process in Step 2, and there is no need to display the screens of Step 1 and Step 2 of the "Job Record", and instead, the screen of "Business Report" in Step 3 is displayed.

[0118] The "Business Report" screen of the "Job Record" enables confirmation of the past records of each job. The "Business Report" screen of the "Job Record" enables confirmation of the past records of each job, and at the same time, it is possible to clock in the job start time and job end time. In addition to the columns of "◆Reporting Object", "Reporting Process", and "◆Clock-in History", there are also a "Comment" column, buttons for "Start" and "End" (of the process), and a button for "[+] Add Comment".

[0119] "Reporting Object" displays the items of "Instruction Number", "Customer Name", "Product", and "Case Name" of the job instruction. When the button for "[+] Add Comment" is clicked, comments on the actual performance of the "Reporting Process" can be entered in the "Comment" column. In the "◆Clock-in History" column, in the "Reporting Process", in addition to displaying the "Responsible Person" and "Date" of the previously performed job, the "Start" time and "End" time of this job are also displayed.

[0120] When the "Start" button is clicked, the "start" time of the "◆ Check-in History" of the job is stored. When the "End" button is clicked, the "end" time of the job is stored. In the "Responsible Person" column, the user of the operator terminal 3 that reads the QR code is stored. In the "Date", the date when the QR code is read is stored. The "Date", "Responsible Person", "Start" time, and "End" time are sent to the multi-dimensional database DB as date information, operator information, job start time, and job completion time, respectively. In addition, the case information and process information are also sent to the multi-dimensional database DB at the same time.

[0121] In Figure 22 shows the "Basic Information and Process Information" screen related to the new job instruction displayed when the menu button (vertical "---" button, i.e., the so-called hamburger button) on the job management screen is clicked and "New" is clicked. On the "Basic Information and Process Information" screen related to the new job instruction, a "Basic Information" column and a "Process Information" column are displayed. On the "Basic Information and Process Information" screen related to the new job instruction, a new job instruction can be created.

[0122] In the "Basic Information" column, in addition to displaying the "Instruction Number", "Product", "Customer Name", "Case Name", "Main Responsible Person", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" displayed on the "Job Instruction Management" screen, input items such as "Case Summary" and "Acceptance Conditions" are also displayed. In each item, information can be input and confirmed by using the registration acceptance unit 21 via the input unit 17. In the "Job Information" column, the job information registered in the main information (not shown) can be selected and input.

[0123] The first embodiment is three-dimensional in terms of the personnel dimension, case dimension, and process dimension. In contrast, in the second embodiment, it is four-dimensional with the addition of the product dimension. Thus, analysis from the product dimension can be performed, and the viewpoints of analysis can be increased.

[0124] In the present embodiment, the form of the multi-dimensional database being a three-dimensional database with three dimensions and a four-dimensional database with four dimensions has been described. However, the multi-dimensional database can also be a five-dimensional or higher database with five or more dimensions.

[0125] The information processing system for constructing the business management system of the present embodiment has been described above. However, the information processing system is not limited to the above embodiment and can adopt other structures within the scope of achieving the invention purpose.

[0126] Industrial Applicability

[0127] The present invention can be used in an information processing system for business assistance and the like.

Claims

1. An information processing system, comprising: a multidimensional database, which has at least a case dimension, a process dimension, and a personnel dimension; A plan making department makes a business plan, the business plan including at least case information, process information, and personnel information of each dimension contained in the database; and The performance management department inputs the operation start time and the operation completion time for the business plan. The multidimensional database stores hierarchical structure data, which at least includes the case information, the process information, the personnel information, the operation start time, and the operation completion time.

2. The information processing system according to claim 1, wherein: It also has a commodity dimension. The planning department prepares a business plan, which includes product information in addition to the case information, process information, and personnel information. The multidimensional database records hierarchical structure data, which includes at least the case information, the process information, the personnel information, the operation start time, and the operation completion time, as well as commodity information.

3. The information processing system according to claim 1, wherein: The personnel dimension of the multidimensional database has a hierarchical structure in the order of operator information, work start time, work completion time, matter information, category information, and process information.

4. The information processing system according to claim 1, wherein: The case dimension of the multidimensional database has a hierarchical structure in the order of the case information, the category information, the process information, the operator information, the operation start time, and the operation completion time.

5. The information processing system according to claim 1, wherein: The process dimension of the multidimensional database has a hierarchical structure in the order of category information, the process information, the case information, operator information, the work start time, and the work completion time.

6. The information processing system according to claim 2, wherein: The product dimension of the multidimensional database has a hierarchical structure in the order of the product information, the process information, the matter information, the operator information, the operation start time, and the operation completion time.

Images