WO2012086096A1 - データベース、データ管理サーバ、およびデータ管理プログラム - Google Patents
データベース、データ管理サーバ、およびデータ管理プログラム Download PDFInfo
- Publication number
- WO2012086096A1 WO2012086096A1 PCT/JP2011/002351 JP2011002351W WO2012086096A1 WO 2012086096 A1 WO2012086096 A1 WO 2012086096A1 JP 2011002351 W JP2011002351 W JP 2011002351W WO 2012086096 A1 WO2012086096 A1 WO 2012086096A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data
- process flow
- status
- business
- progress
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
Definitions
- the present invention relates to a database that can be used in an ERP system, a data management server including the database, and a data management program installed in the data management server.
- ERP Enterprise Resource Planning
- Such a system includes, for example, an integrated business system that manages information on management resources and communicates information in a predetermined first data format.
- a data conversion device connected to a plurality of information devices that communicate information in a second data format different from the data format, and accepts input of information in the first data format output from the integrated business system.
- the “input process” means a process of inputting various data acquired (or determined) by an ERP system administrator or the like in each business process to each table.
- FIG. 10 is an explanatory diagram for explaining an example of a table configuration in a conventional ERP system.
- a business flow composed of a plurality of business processes indicates “inventory sales”
- the table for storing the data related to the process flow of “inventory sales” is, for example, as shown in FIG. 10A to FIG. , An acceptance table, and a sales table.
- the table to be updated is different for each input process. Therefore, the correspondence between a plurality of business processes belonging to the same process flow is an identifier for each business process (process data) (in FIG. 10, the order number and the order details in the shipping instruction table, and the issue table). The shipping instruction number and the shipping instruction details, etc.) are given.
- the shipping instruction for specifying the process data as the process data related to the business process “shipment instruction” The order number “A00001” and the order received together with the number, the shipping instruction detail number, the type indicating the type of the business process, and the data indicating the contents of the business process (for example, the order recipient, quantity, amount, shipping instruction date, shipping text, etc.) Register the item number “0010” in the shipping instruction table.
- the same data for example, orders, quantity, amount, etc.
- An object of the present invention is to solve the above-described problems and reduce the processing load required for data update and search in an ERP system.
- the database of the present invention includes a process flow table in which process flow data including various data related to a process flow including a plurality of business processes is registered.
- the process flow data includes status data, common data, process specific data, and the like.
- the status data is data indicating the progress of each of a plurality of business processes included in the process flow
- the common data is data common to business processes included in the same process flow.
- the process-specific data is data specific to each business process included in the same process flow, and the status data is updated when the process-specific data is updated. To do.
- the above configuration makes it possible to reduce the processing load required for data update and search in the ERP system.
- a process flow data management server that manages process flow data generated for each process flow
- the process flow data management server receives a part or all of the process flow data in response to a request from a client terminal. You may be set as the structure containing the process flow data provision means provided to a client terminal.
- Progress status determining means for determining whether the progress status determination condition is satisfied, and progress status notification for notifying the client terminal of the progress status according to the progress status determination condition determined to be satisfied by the progress status determination means May be included.
- the progress providing condition data may include a completion condition for determining whether the process flow is completed.
- the data management server of the present invention is a data management server that provides various data to a client terminal, and stores process flow data that stores process flow data including various data relating to a process flow including a plurality of business processes.
- Each progress The common data is data common to business processes included in the same process flow
- the process specific data is data specific to each business process included in the same process flow.
- the process flow data updating means updates the status data in accordance with an update status of the process specific data.
- the data management program of the present invention is a data management program for controlling the operation of the data management server so as to provide various data to the client terminal
- the data management server includes a plurality of business processes.
- Process flow data update processing for updating process flow data stored in process flow data storage means for storing process flow data including various data related to the process flow according to the progress of the process flow, and a request from the client terminal
- the process flow data providing process for providing a part or all of the process flow data to the client terminal is executed, and the process flow data includes status data, common data, and process specific data.
- the status data is data indicating the progress of each of a plurality of business processes included in the process flow
- the common data is data common to business processes included in the same process flow, and is specific to the process
- the data is data unique to each business process included in the same process flow, and in order to cause the process flow data update process to execute a process of updating the status data according to the update status of the process specific data belongs to.
- FIG. 1 is a block diagram showing a configuration example of an integrated core business system 500 according to an embodiment of the present invention.
- the integrated core business system 500 includes a core business server 200, a data warehouse server (DWH server) 300, a client 10, and a client 20.
- DWH server data warehouse server
- Each element constituting the integrated core business system 500 is connected by a communication network.
- the core business server 200 and the DWH server 300 are connected by a dedicated line 51.
- the client 10 is connected to the DWH server 300 via a LAN (Local Area Network) 52.
- the client 20 is connected to the DWH server 300 via the Internet 53.
- the core business server 200 is a server managed by an administrator of the integrated core business system 500, for example, and has various functions for managing process data that is data indicating information in various business processes such as form information related to various businesses. Have.
- the core business server 200 in this example is configured by a general information processing apparatus including an OS (Operating System) and a relational database (relational DB).
- OS Operating System
- relational database relational database
- a book is a field in which items relating to cash and goods are entered
- a slip is data that is the basis for creating a book and is evidence of business transactions.
- the core business server 200 may handle, for example, process data indicating only slip information used for creating various slips.
- the core business server 200 in this example includes a business application program DB 210, a process flow DB 220, and various types of data necessary for realizing a function as a general core business server (for example, And other DBs 230 that store data used by various programs stored in the business application program DB 210.
- the other DB 230 is a part not particularly related to the present invention, and a detailed description thereof will be omitted.
- the business application program DB 210 is a storage medium that stores programs used for various businesses. Programs stored in the business application program DB 210 include a sales business management program, a purchasing business management program, a production management program, a financial accounting management program, and a management accounting management program.
- the process flow DB 220 is a storage medium that stores process flow data including various process data (or form data) collected and organized by various information processing using various programs stored in the business application program DB 210. is there.
- process flow data including various data related to a process flow including a plurality of business processes is stored in the process flow table PT in the process flow DB 220.
- the core business server 200 centrally manages process flow data generated for each process flow using one process flow table PT.
- the core business server 200 manages the process flow data in a plurality of tables, for example, for each type to be described later, or for each piece of common data to be described later (for example, an order receiving party). It is good also as a structure.
- FIG. 2 is an explanatory diagram illustrating an example of a storage state of process flow data in the process flow DB 220.
- the process flow data in this example includes a main key part, a reference key part, a type part, a status part, a common data part, and a process specific data part.
- Each item corresponding to each part of the process flow data indicates the type of process data constituting the process flow data.
- data relating to each business process constituting the process flow is allocated and stored in each part constituting the process flow data.
- process data related to one process flow (for example, a series of process flows from order receipt to delivery from a certain company) is stored in the same entry (that is, the same row in the process table PT) in the process flow table PT.
- process data related to one process flow (for example, a series of process flows from order receipt to delivery from a certain company) is stored in the same entry (that is, the same row in the process table PT) in the process flow table PT.
- the “primary key part” is a part in which primary key data, which is data for uniquely identifying the process flow data, is stored in the process flow data.
- the main key part is composed of a process flow number and a process flow detail number. That is, in this example, a combination of a process flow number and a process flow detail number becomes an identifier (ID) of each process flow data.
- the main key part is updated when the process flow data is registered for the first time.
- “when first registering process flow data” means that when an entry (data row) is added to the process flow data, for example, process data belonging to a certain process flow and corresponding other processes It shall mean the time when unregistered process data is registered.
- the “update” here includes addition of data.
- the “process flow number” is an identifier for specifying one process flow data (that is, one column in the process flow table PT shown in FIG. 2).
- the process flow number is assigned to each process data having the same predetermined item.
- the same number is assigned to the process flow number of the process flow number that has the same type and the order-receiving party in the process flow data.
- the “process flow detail number” is an identifier for identifying specific process flow data from among the process flow data assigned with the same process flow number. That is, for example, the process flow table PT shown in FIG. 2 indicates that the business process “order received” in the process flow type “inventory sales” has received orders for the amounts “1200” and “2600” from the order recipient “T001”.
- the process flow data including the process data to be shown can be uniquely identified by the combination of the process flow number “000001” and the process flow detail number “0010” or “0020”, respectively.
- the “reference key part” is data for specifying other process flow data (or other process data) related to the process flow, such as the original transaction for sales returns, among the process flow data. This is the part where key data is stored.
- the reference key part is composed of a reference number and a reference specification number. The reference key part is updated when the process flow data is registered for the first time.
- the process number and process flow detail number of other process flows related to the process flow are stored in the reference number and the reference detail number, respectively.
- the reference key portion contains data indicating the same value as the primary key portion of the same entry (that is, the reference number is a process)
- a flow number is stored, and a process flow item number is stored in the reference item number.
- the reference key part indicates other process data related to the process flow, the reference key part is further provided with data for specifying the type of the process data.
- the “type part” is a part in which type data that is a type of process flow, such as inventory sales and sample shipment, is stored in the process flow data.
- the type part is updated when the process flow data is registered for the first time.
- the type of process flow is not limited to inventory sales or sample shipment.
- the “status part” stores status data that is data indicating the progress of the process flow (that is, data indicating the progress of each of a plurality of business processes included in the process flow) among the process flow data.
- the status data indicates the progress of each business process by setting “0” for the unfinished business process and “1” for the completed business process for the business process required by the process flow. Show. That is, for example, as shown in FIG. 2, the process flow of “inventory sales”, and the business processes included in the process flow are “order receipt”, “shipment”, “issue”, “issue inspection”, and “sales”. In this case, it is assumed that process specific data (for example, order date) related to the business process “order received” is registered. In this case, in the status data, the portion corresponding to “sales” is “1”, and the other portions remain in the initial state (ie, the state in which “0” is set).
- the status part in this example is updated for each business process.
- the status part is updated when process-specific data to be described later is input, specifically, when it is determined that each business process is completed because a predetermined status change condition is satisfied.
- the status change condition is not particularly limited, in this example, “all process specific data corresponding to one business process is input” is stored in the predetermined storage area of the core business server 200 as the status change condition. It is assumed that
- a part of the items (column items) constituting the table stores unnecessary process data in a specific process flow.
- a part for storing unnecessary process data is empty data, and “0” is stored in status data corresponding to the empty data.
- the “common data part” is data that does not depend on the business process such as the order receiving party and the shipping destination among the process flow data (that is, common data between business processes included in the same process flow). This is the part where data is stored. The common data part is updated when the process flow data is registered for the first time.
- process specific data part is a text that indicates precautions such as the order date and data registered in each business process in the process flow data (for example, “delivery deadline” and “breaker”) Data), etc., is a part in which process-specific data that is data unique to each business process included in the same process flow is stored.
- the process specific data part is updated for each business process. Therefore, in this example, it can be said that the process flow data based on the business process is “process-specific data” and the data not based on the business process is “common data”.
- order received means a state in which an order is received from a customer and a contract with the customer is concluded.
- shipment instruction means a state in which an instruction to ship a product is given to a warehouse company or a logistics person.
- shipment means a state in which goods are shipped from the warehouse and movement is started.
- Inspection means a state in which the inspection of the customer is completed and the ownership of the product is transferred to the customer.
- the core business server 200 receives various data stored in the process flow DB 220 and the other DB 230 in accordance with a predetermined extraction condition as a CSV. (Comma Separated Values) has a function of converting to a format and transmitting to the DWH server 300.
- the core business server 200 transfers a data file in CSV format by FTP (File Transfer Protocol) to the DWH server 300.
- the DWH server 300 is a server managed by a system administrator of this system, for example, and has various functions for realizing a data warehouse.
- the “data warehouse” refers to a system that analyzes the relationship between items from business data such as form data accumulated in time series (in this example, process flow data).
- the DWH server 300 has a function of registering various data in a predetermined storage area by converting a CSV file transferred from the core business server 200 into a predetermined data format.
- the DWH server 300 may be configured to extract data corresponding to each storage area from the CSV format state without converting the data format.
- Clients 10 and 20 are information processing apparatuses (client terminals) including a CPU (Central Processing Unit), ROM, RAM, and a display unit.
- clients 10 and 20 have various applications such as a Web browser and spreadsheet software that can be used to handle form data.
- the clients 10 and 20 for example, in response to an operation input by the user, a query (search item, search item, data flow in this example) for obtaining necessary form data (process flow data) from the DWH server 300.
- search item search item, search item, data flow in this example
- necessary form data process flow data
- the client 10 has a function of communicating with the DWH server 300 via the LAN and outputting the data acquired from the DWH server 300 to the display unit using predetermined spreadsheet software.
- the client 20 has a function of communicating with the DWH server 300 via the Internet and outputting data acquired from the DWH server 300 to a display unit using a Web browser.
- the clients 10 and 20 have a function of outputting a form having a predetermined form to a display unit included in the client 10 or 20 based on the process flow data stored in the process flow DB 220 of the core business server 200. .
- the configuration of the integrated core business system 500 is not limited to this.
- the clients 10 and 20 and the core business server 200 may directly transmit and receive data without using the DWH server 300.
- the clients 10 and 20 may be configured to be directly accessible to the process flow DB 220B.
- FIG. 3 is a flowchart showing an example of database update processing executed by the core business server 200.
- the core business server 200 executes a process for updating the process flow DB 220.
- the core business server 200 determines whether or not new process flow data (new process flow data) has been acquired (step S101). If it is determined that new process flow data has not been acquired (N in step S101), the core business server 200 moves to the process in step S103 described later.
- step S101 the core business server 200 registers the acquired process flow data in the process flow table PT (step S102).
- the core business server 200 determines whether or not the process data corresponding to the registered process flow data (that is, data relating to the business process constituting the process flow) has been acquired (step S103). If it is determined that the process data corresponding to the registered process flow data has not been acquired (N in step S103), the core business server 200 refers to the other DB 230 and sets a storage area corresponding to the acquired data. In particular, the acquired data is registered (step S104), and the process proceeds to step S101.
- the process data corresponding to the registered process flow data that is, data relating to the business process constituting the process flow
- the core business server 200 registers the process data in the corresponding item of the process flow table PT (step S105).
- process data acquired by the core business server 200 is registered process data is determined based on the process flow data including a combination of the process flow number and the process flow detail number of the acquired data. This is done by determining whether it is stored in the PT. For this reason, in this example, the data (that is, the process flow number) that constitutes the primary key part in the data acquired by the core business server (data input by the business executor or data created by the business application program). And the process flow item number).
- the core business server 200 determines whether or not a predetermined status change condition regarding the process flow data is satisfied by the registration of the process data (step S106). If it is determined that the predetermined status change condition is not satisfied in response to the process data being registered (N in step S106), the core business server 200 moves to step S101.
- step S106 determines that the predetermined status change condition is satisfied in response to the registration of the process data.
- the core business server 200 determines that the process flow data is based on the satisfied status change condition.
- the included status data is updated (step S107), and the process proceeds to step S101.
- the database update process in this example is terminated by, for example, a termination operation by the administrator of the core business server 200.
- the database update process may be a process executed in real time or a batch process executed every specific unit time.
- a process having a part of real time property such as performing a real time process only for a specified period may be used.
- FIG. 4 is a flowchart illustrating an example of a form output process executed by the core business server 200, the DWH server 300, and the client 10.
- the core business server 200 displays process forms on the display screen of the client 10 by providing process flow data (part or all of the process flow data) to the client 10 via the DWH server 300.
- the process for performing is performed. Since the client 10 and the client 20 are different only in the type of communication network, in this example, the case where the client 10 is used will be described as an example.
- the DWH server 300 in this example only performs assistance (for example, client authentication) for communication between the core business server 200 and the client 10, description of the operation of the DWH server 300 will be omitted below. .
- the client 10 transmits a search key input screen request to the core business server 200 in response to, for example, an operation input by the user A of the client 10 (step S301).
- the core business server 200 transmits a search key input screen corresponding to the received search key input screen request (step S201).
- the client 10 displays the search key input screen on the display screen of the display unit included in the client 10 (step S302).
- FIG. 5 is an explanatory diagram showing an example of a search key input screen.
- the search key input screen accepts a search item display area 11 in which items set in the process flow table PT are selectably displayed in a pull-down format, and a search key input by the user A.
- a search key input area 12 for receiving a request to switch the display screen output to the display unit to another display screen
- a search button 14 for receiving a search request for process flow data by a search item and a search key.
- the client 10 When the client 10 accepts selection of a search item by the cursor P that can be operated by a mouse operation, for example, the client 10 puts the selected search item into a temporary selection state.
- the client 10 determines that the selection of the search item in the temporary selection state (main selection) has been received (step S303), and the selected search item and search key input
- the search key input in the area 12 is transmitted to the basic business server 200 (step S304).
- the core business server 200 Upon receiving the search item and the search key, the core business server 200 adds the item indicated by the received search item (that is, the column item in the process flow table PT) among the process flow data registered in the process flow table PT.
- the process flow data in which the same character string as the received search key (or including the received search key) is registered is searched (step S202). If the search key is empty data at this time, the core business server 200 has process data in the received search item (that is, data other than empty data is stored in the received search item). It may be configured to search all data, or may be configured to transmit a search error notification to the client 10.
- the core business server 200 transmits the retrieved process flow data to the client 10 (step S203), and the process here is terminated.
- the client 10 displays a form display screen on the display screen of the display unit included in the client 10 based on the received process flow data (step S305).
- FIG. 6 is an explanatory diagram showing an example of a form display screen.
- the form display screen includes a form display area 21 for displaying a form based on the process flow data, a form status display area 22, a back button 23, and a change button 24.
- the client 10 changes the scale of the form displayed in the form display area 21 in accordance with, for example, an operation of a keyboard or the like provided in the client 10.
- part or all of the process flow data is displayed in the form display area 21 in a predetermined display form.
- information for displaying part or all of the process flow data in a predetermined display form is created by the core business server 200, and for example, at the timing of step S203 in the form output process, the client 10 Shall be sent to
- the client 10 may be configured to display a part or all of the received process flow data in the form display area 21 in a predetermined display format based on information stored in a storage device included in the client 10.
- the form status display area 22 is an area for displaying the type (or status, hereinafter referred to as status) of the form displayed in the form display area 21.
- status As the status of the form, various forms such as an order slip, a delivery slip, an inspection slip, and an invoice can be considered.
- the return button 23 is a button for accepting a request to return the display screen to the search key input screen.
- the change button 24 is a button for accepting a request to change the display contents of the form display area 21.
- the display content changing process in the form display area 21 will be described.
- the client 10 determines whether or not the form status change request by the user A has been received (step S306).
- the client 10 first accepts selection of the form status display area 22 by the user A. For example, when the selection of the form status display area 22 by the cursor P that can be operated by the mouse operation is received, the client 10 displays a list of form status names indicating the forms of the forms that can be displayed, for example, in a pull-down format. To do.
- the core business server 200 determines the state of form data (form form data) and process flow data (that is, the input state of each column item of the process flow table PT) stored in a predetermined storage area in advance. ) To identify a form status name indicating the form of the form that can be displayed. That is, for example, when the type of process flow data transmitted to the client 10 is “inventory sales” and only process data related to the business process “order received” is registered in the process specific data section, the core business server 200 Specify only "order receipt” as the status name. If process data related to the business process “issue” is registered in addition to the process data related to the business process “order received”, the core business server 200 sets “order receipt slip” and “issue slip” as the form status names. Identify.
- FIG. 7 is an explanatory diagram for explaining the transition of the form status based on the state of the process flow data.
- images 101 to 104 are in the form of forms (specifically slips) that can be displayed in the form display area 21 based on the process flow data.
- the images 101 to 104 are explanatory diagrams for explaining the transition of the form status, and do not show a specific description example for playing a role as various forms.
- an image 104 will be described as an example.
- an area 111 is a form status name
- an area 112 is a process flow type
- an area 113 is a business process name of process data included in the process flow data. It is assumed that it is an area to be shown (in this example, a character string display area).
- a form status name corresponding to the type of process data included in the process flow data is displayed in the area 111.
- the form status name (that is, the process The types of forms that can be displayed based on flow data will increase. This is not "whether or not there is the next type of form", but "the form status increases according to the state of the process flow data (that is, the types of forms that can be displayed increase)" means.
- step S305 the form status name corresponding to the business process “order received” positioned higher than the business process “issue” by the client 10 in the process flow indicated by the received process flow data. It is assumed that the form corresponding to “order slip” is displayed in the form display area 21 (see FIG. 6).
- step S306 If it is determined in the document status change request acceptance determination process (step S306) that the form status change request by the user A has not been accepted (N in step S306), the client 10 proceeds to the process of step S308 described later.
- the client 10 displays a form corresponding to the received change request in the form display area 21 (step S307).
- the client 10 receives the selection of the form status name “issue slip” corresponding to the business process “issue” by the user A, and displays the form (issue slip) corresponding to the business process “issue” in the form display area. 21 is displayed.
- the client 10 displays the form status name “delivery slip” in the form status display area 22.
- step S308 determines whether or not to end the form output process. If it is determined that the form output process is not terminated (N in step S308), the client 10 proceeds to the process in step S306.
- the client 10 ends the process here.
- the database (for example, the process flow DB 220) includes a process including various data related to a process flow including a plurality of business processes (for example, a process flow of type “stock sales”).
- the process-specific data is the same process Data specific to each business process included in the row (for example, order date and order text), and status data is updated in response to the process specific data being updated (for example, process specific data is added) Accordingly, the corresponding status data is changed from “0” to “1”), so that it is possible to reduce the processing load required for data update and search in the ERP system
- FIG. 8 is an explanatory diagram for explaining the usefulness of the database update process executed by the basic business server 200 described above.
- FIG. 8A is a table showing a comparison result of the data update amount when the first process data is input.
- the type of process data to be input first that is, the type of business process
- “conventional” means a database having a table for each business process, as shown in FIG.
- “difference in data amount” does not indicate an exact numerical value, but a case where data stored in a conventional table is updated and a new type process flow table (that is, a process flow table PT, see FIG. 2).
- the case where the amount of data handled by the new type increases is + ( Plus)
- the case where the amount of data handled by the new type is smaller is ⁇ (minus)
- the case where the amount of data handled by the new type and the conventional type can be regarded as the same is “0”.
- the new type handles more data as much as the status part needs to be updated.
- the data amount of the status portion is small, it can be said that there is substantially no difference in the amount of I / O data (input data and output data) between the conventional type and the new type.
- FIG. 8B is a table showing a comparison result of the data update amount when the process data after the second process is input. That is, for example, the main key part, the reference key part, the type part, the status part, the common data part, and a part of the process specific data part (for example, process specific data “reception date”, “ “Order received text”) is a table showing a comparison result of the data update amount when the process data is input according to the business process included in the process flow already input in the process flow data table PT.
- “conventional type” defines other process data (for example, business process “shipment” corresponding to the process data (order data) registered in the order table, for example, in order to define the correspondence with the input process data.
- the main key part, reference key part, type part, common data part, and process specific data part in this example are supported as the shipping instruction data.
- the new type updates only the status part and the process specific data part as compared with the conventional type that requires all parts other than the status part. Therefore, the amount of I / O data is reduced.
- the new type has a smaller amount of I / O data than the conventional type, which is advantageous in terms of system performance.
- the database I / O can be reduced, it is possible to realize a reduction in the amount of writing, a reduction in the capacity of the entire database, and a reduction in the processing load required for the data search process. .
- the reduction of the processing load required for the search process one factor is that the process (process data) does not extend over a plurality of tables.
- the new type has the advantage that the input order of the process data can be made somewhat random. That is, for example, in the case of the type “inventory sales”, in the case of the conventional type, the order of the process flow is limited to the order of orders, shipping instructions, delivery, delivery inspection, and sales, and the order cannot be changed.
- the relationship between business processes is expressed by assigning the primary key of the previous business process to the data of the subsequent business process (for example, in the shipping instruction table). “Order number” and “Order details” (see FIG. 10).
- the new type table structure the data of related business processes is stored in the same entry (that is, the same column of the same table).
- the order of business processes can be flexibly rearranged. That is, for example, when the actual business order is “order received after shipping instruction”, the process data input order can be made to conform to the actual business order. Therefore, it is advantageous over the conventional type in progress management (in other words, in internal control). Specifically, the current business order in the wholesale industry is “order received after shipping instruction”.
- the load required to inquire about the progress of the process flow can be reduced. That is, when confirming how far the process flow has progressed, in the conventional table structure, it is necessary to confirm the registration status of all the tables from the start slip table to the final slip table. For example, when the type “inventory sales” is taken as an example, it is necessary to confirm five tables of orders, shipping instructions, delivery, delivery inspection and billing. On the other hand, since the new table structure has the progress status of the process flow as a “status part”, the progress can be confirmed only by querying one table and one entry. This is advantageous when using or developing a progress inquiry screen.
- the database (for example, the process flow DB 220) is provided in the process flow data management server (for example, the core business server 200) that manages the process flow data generated for each process flow. Since the data management server is configured to provide part or all of the process flow data to the client terminal in response to a request from the client terminal (for example, the clients 10 and 20), It is possible to construct a system in which the processing load required for providing the process flow data indicating the form information necessary for creation is reduced as compared with the conventional system.
- the progress determination in which the database (for example, the process flow DB 220) registers progress determination condition data that is data indicating the determination condition of the progress of the process flow.
- the process flow data management server (for example, the core business server 200) includes a condition table, and status data (for example, data stored in the status part of the process flow table PT, see FIG. 2) based on the progress determination condition. It is good also as a structure which judges whether progress condition determination conditions are satisfy
- FIG. 9 is an explanatory diagram illustrating an example of a storage state of the progress determination condition data stored in the progress determination condition table.
- the progress determination condition data in this example includes a process flow type and a progress determination condition according to the process flow type.
- the process flow type includes sample shipment, service sales, name change (sales), name change (shipment), sales return (with original transaction reference), sales return (original transaction reference) None), sales amount adjustment (plus), sales amount adjustment (minus), etc.
- the “progress status determination condition” indicates a criterion for determining the progress status of the process flow.
- a business process for example, order, shipping instruction, delivery, etc.
- the core business server 200 determines that the process flow data entry is in the “completed” state. A determination is made (that is, it is determined that the process flow indicated by the process flow data has been completed), and a process (notification process) for notifying that effect to a predetermined client (for example, the clients 10 and 20) is performed.
- This configuration makes it possible to construct a system that can determine the status of business execution.
- start timing of the progress status determination process or the notification process may be when there is a request from the client terminal, or may be a preset timing.
- the progress status determination condition data is configured to include a completion condition for determining whether the process flow has been completed.
- a system can be constructed.
- the progress status determination condition data is not limited to data for determining that the process flow is in the “completed” state, and includes, for example, data for determining that the process flow is in the “50% complete” state. It is good also as a structure.
- the progress status determination condition data may be configured to indicate the type of process data that should be input before a predetermined time elapses from the input of the first process data.
- PT process flow table 10 client 20 client 51 leased line 52 LAN 53 Internet 200 Core Business Server 210 Business Application Program DB 220 Process Flow DB 230 Other DB 300 DWH server 500 Integrated mission-critical system
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
(Comma Separated Values)形式に変換してDWHサーバ300に送信する機能を有する。なお、本例においては、基幹業務サーバ200は、FTP(File Transfer Protocol)によりCSV形式にしたデータファイルをDWHサーバ300に転送する。
10 クライアント
20 クライアント
51 専用回線
52 LAN
53 インターネット
200 基幹業務サーバ
210 業務アプリケーションプログラムDB
220 プロセスフローDB
230 その他DB
300 DWHサーバ
500 統合基幹業務システム
Claims (6)
- 複数の業務プロセスを含むプロセスフローに関する各種データを含むプロセスフローデータが登録されるプロセスフローテーブルを備え、
前記プロセスフローデータは、ステータスデータと、共通データと、プロセス固有データとを含むデータであり、
前記ステータスデータは、前記プロセスフローに含まれる複数の業務プロセスそれぞれの進捗状況を示すデータであり、
前記共通データは、同一のプロセスフローに含まれる業務プロセス間で共通するデータであり、
前記プロセス固有データは、同一のプロセスフローに含まれる各業務プロセスに固有のデータであり、
前記ステータスデータは、前記プロセス固有データが更新されたことに応じて更新される
ことを特徴とするデータベース。 - 前記プロセスフロー毎に発生するプロセスフローデータを管理するプロセスフローデータ管理サーバに備えられ、
該プロセスフローデータ管理サーバは、クライアント端末からの要求に応じて、前記プロセスフローデータの一部又は全部を当該クライアント端末に提供するプロセスフローデータ提供手段を含む
請求項1記載のデータベース。 - 前記プロセスフローの進捗状況の判定条件を示すデータである進捗状況判定条件データが登録された進捗状況判定条件テーブルを備え、
前記プロセスフローデータ管理サーバは、
前記進捗状況判定条件に基づいて前記ステータスデータが前記進捗状況判定条件を満たしているか判定する進捗状況判定手段と、
該進捗状況判定手段により満たしていると判定された進捗状況判定条件に応じた進捗状況を前記クライアント端末に報知する進捗状況報知手段とを含む
請求項2記載のデータベース。 - 前記進捗状況判定条件データは、前記プロセスフローが完了したか判定するための完了条件を含む
請求項3記載のデータベース。 - クライアント端末に対して各種データを提供するデータ管理サーバであって、
複数の業務プロセスを含むプロセスフローに関する各種データを含むプロセスフローデータを記憶するプロセスフローデータ記憶手段と、
前記プロセスフローの進捗状況に応じて当該プロセスフローデータを更新するプロセスフローデータ更新手段と、
前記クライアント端末からの要求に応じて、前記プロセスフローデータの一部又は全部を当該クライアント端末に提供するプロセスフローデータ提供手段とを含み、
前記プロセスフローデータは、ステータスデータと、共通データと、プロセス固有データとを含むデータであり、
前記ステータスデータは、前記プロセスフローに含まれる複数の業務プロセスそれぞれの進捗状況を示すデータであり、
前記共通データは、同一のプロセスフローに含まれる業務プロセス間で共通するデータであり、
前記プロセス固有データは、同一のプロセスフローに含まれる各業務プロセスに固有のデータであり、
前記プロセスフローデータ更新手段は、前記プロセス固有データの更新状況に応じて前記ステータスデータを更新する
ことを特徴とするデータ管理サーバ。 - クライアント端末に対して各種データを提供するようにデータ管理サーバに動作制御させるためのデータ管理プログラムであって、
前記データ管理サーバに、
複数の業務プロセスを含むプロセスフローの進捗状況に応じて前記プロセスフローに関する各種データを含むプロセスフローデータを記憶するプロセスフローデータ記憶手段に記憶されたプロセスフローデータを更新するプロセスフローデータ更新処理と、
前記クライアント端末からの要求に応じて、前記プロセスフローデータの一部又は全部を当該クライアント端末に提供するプロセスフローデータ提供処理とを実行させ、
前記プロセスフローデータは、ステータスデータと、共通データと、プロセス固有データとを含むデータであり、
前記ステータスデータは、前記プロセスフローに含まれる複数の業務プロセスそれぞれの進捗状況を示すデータであり、
前記共通データは、同一のプロセスフローに含まれる業務プロセス間で共通するデータであり、
前記プロセス固有データは、同一のプロセスフローに含まれる各業務プロセスに固有のデータであり、
前記プロセスフローデータ更新処理にて、前記プロセス固有データの更新状況に応じて前記ステータスデータを更新する処理を
実行させるためのデータ管理プログラム。
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
EP11851116.1A EP2527995A4 (en) | 2010-12-21 | 2011-04-22 | DATABASE, DATA MANAGEMENT SERVER, AND DATA MANAGEMENT PROGRAM |
US13/574,395 US20130006922A1 (en) | 2010-12-21 | 2011-04-22 | Database, data management server, and data managing program product |
JP2012529058A JP5451885B2 (ja) | 2010-12-21 | 2011-04-22 | データベース、データ管理サーバ、およびデータ管理プログラム |
CN201180023092XA CN102893279A (zh) | 2010-12-21 | 2011-04-22 | 数据库,数据管理服务器,及数据管理程序 |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2010-284506 | 2010-12-21 | ||
JP2010284506 | 2010-12-21 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2012086096A1 true WO2012086096A1 (ja) | 2012-06-28 |
Family
ID=46313392
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/JP2011/002351 WO2012086096A1 (ja) | 2010-12-21 | 2011-04-22 | データベース、データ管理サーバ、およびデータ管理プログラム |
Country Status (5)
Country | Link |
---|---|
US (1) | US20130006922A1 (ja) |
EP (1) | EP2527995A4 (ja) |
JP (1) | JP5451885B2 (ja) |
CN (1) | CN102893279A (ja) |
WO (1) | WO2012086096A1 (ja) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20170117241A1 (en) * | 2015-10-22 | 2017-04-27 | Suss Microtec Photonic Systems Inc. | Maskless selective retention of a cap upon a conductor from a nonconductive capping layer |
CN105843961B (zh) * | 2016-04-18 | 2018-12-14 | 中邮建技术有限公司 | 一种流程与后台数据分离的信息化系统数据库架构方法 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH10214113A (ja) * | 1996-05-15 | 1998-08-11 | Hitachi Ltd | 掲示板型データベースを用いた業務処理システム及びその処理方法 |
JP2001005680A (ja) * | 1999-06-25 | 2001-01-12 | Oki Electric Ind Co Ltd | ワークフロー管理システム、コードジェネレータおよびワークフロー処理のプロセス変更方法 |
JP2009099070A (ja) | 2007-10-18 | 2009-05-07 | Sunallomer Ltd | データ変換装置及びデータ変換方法 |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0807896A3 (en) * | 1996-05-15 | 2000-08-30 | Hitachi, Ltd. | Business processing system employing a notice board business system database and method of processing the same |
CN1392502A (zh) * | 2002-07-01 | 2003-01-22 | 鞍山市生产力促进中心 | 企业信息化自助平台 |
EP2124176A4 (en) * | 2007-03-15 | 2012-01-25 | Fujitsu Ltd | TASK ANALYSIS PROGRAM AND TASK ANALYZER |
-
2011
- 2011-04-22 US US13/574,395 patent/US20130006922A1/en not_active Abandoned
- 2011-04-22 WO PCT/JP2011/002351 patent/WO2012086096A1/ja active Application Filing
- 2011-04-22 EP EP11851116.1A patent/EP2527995A4/en not_active Withdrawn
- 2011-04-22 JP JP2012529058A patent/JP5451885B2/ja not_active Expired - Fee Related
- 2011-04-22 CN CN201180023092XA patent/CN102893279A/zh active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH10214113A (ja) * | 1996-05-15 | 1998-08-11 | Hitachi Ltd | 掲示板型データベースを用いた業務処理システム及びその処理方法 |
JP2001005680A (ja) * | 1999-06-25 | 2001-01-12 | Oki Electric Ind Co Ltd | ワークフロー管理システム、コードジェネレータおよびワークフロー処理のプロセス変更方法 |
JP2009099070A (ja) | 2007-10-18 | 2009-05-07 | Sunallomer Ltd | データ変換装置及びデータ変換方法 |
Also Published As
Publication number | Publication date |
---|---|
EP2527995A1 (en) | 2012-11-28 |
EP2527995A4 (en) | 2013-10-02 |
US20130006922A1 (en) | 2013-01-03 |
JP5451885B2 (ja) | 2014-03-26 |
JPWO2012086096A1 (ja) | 2014-05-22 |
CN102893279A (zh) | 2013-01-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP5386639B2 (ja) | データベース、データ管理サーバ、およびデータ管理プログラム | |
WO2013114440A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
JP5502251B1 (ja) | 帳票データ管理サーバ、および帳票データ管理プログラム | |
US20150081365A1 (en) | Mobile terminal management server and mobile terminal management program | |
WO2013114442A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
JP5237460B2 (ja) | データベース、管理サーバ、および管理プログラム | |
WO2011132421A1 (ja) | データベース、業務内容データ管理サーバ、および業務内容データ管理プログラム | |
WO2015198365A1 (ja) | 連携サーバ、連携プログラム、およびecシステム | |
JP5451885B2 (ja) | データベース、データ管理サーバ、およびデータ管理プログラム | |
WO2013114441A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
WO2013114439A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
WO2013114438A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
WO2015198364A1 (ja) | 連携サーバ、連携プログラム、およびecシステム | |
JP5597769B2 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
EP3007118A1 (en) | Cooperation server, non-transitory computer-readable storage medium storing cooperation program, and EC system | |
US20160148129A1 (en) | Report data management device, non-transitory computer-readable storage medium storing report data management program, and report data management method | |
WO2015198362A1 (ja) | 連携サーバ、連携プログラム、およびecシステム | |
WO2015198363A1 (ja) | 連携サーバ、連携プログラム、およびecシステム | |
JP2007114953A (ja) | 情報システム、アクション送信装置およびアクション送信プログラム | |
JPWO2013114439A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
JPWO2013114438A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
JPWO2013114440A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム | |
JPWO2013114441A1 (ja) | 携帯端末管理サーバ、および携帯端末管理プログラム |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
WWE | Wipo information: entry into national phase |
Ref document number: 201180023092.X Country of ref document: CN |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2012529058 Country of ref document: JP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 6166/DELNP/2012 Country of ref document: IN |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 11851116 Country of ref document: EP Kind code of ref document: A1 |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2011851116 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 13574395 Country of ref document: US |
|
NENP | Non-entry into the national phase |
Ref country code: DE |