WO2015198362A1 - Coordination server, coordination program, and electronic commerce system - Google Patents
Coordination server, coordination program, and electronic commerce system Download PDFInfo
- Publication number
- WO2015198362A1 WO2015198362A1 PCT/JP2014/003362 JP2014003362W WO2015198362A1 WO 2015198362 A1 WO2015198362 A1 WO 2015198362A1 JP 2014003362 W JP2014003362 W JP 2014003362W WO 2015198362 A1 WO2015198362 A1 WO 2015198362A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data
- business
- linkage
- server
- cooperation
- Prior art date
Links
- 238000012545 processing Methods 0.000 claims abstract description 63
- 238000013500 data storage Methods 0.000 claims abstract description 40
- 238000000034 method Methods 0.000 claims description 266
- 238000007726 management method Methods 0.000 claims description 37
- 238000003860 storage Methods 0.000 description 30
- 238000010586 diagram Methods 0.000 description 16
- 238000012384 transportation and delivery Methods 0.000 description 11
- 238000004891 communication Methods 0.000 description 10
- 230000010365 information processing Effects 0.000 description 6
- 238000009826 distribution Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000013523 data management Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
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
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0613—Third-party assisted
- G06Q30/0619—Neutral agent
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Definitions
- the present invention relates to a linked server that links an EC site that sells products on the Internet with reference to a product data storage unit that stores product data, and a core business system that displays products on the EC site, and the linked server
- the present invention relates to a cooperation program for functioning EC and an EC system.
- information that includes distribution information for IT-related products with clients that support distribution and wholesale operations for distributing IT-related products from manufacturers to users on computers and communication networks, and that are arranged at each distribution stage from users to manufacturers.
- An EC system that exchanges information in real time via communication means is disclosed (see Patent Document 1).
- An object of the present invention is to solve the above-described problems and provide an EC system that can be easily constructed.
- the linkage server of the present invention is a linkage server that links an EC site that sells products on the Internet with reference to a product data storage unit that stores product data and a core business system that sells products on the EC site.
- a data storage unit for cooperation that stores data for cooperation configured based on the business data transmitted from the core business system including business data storage means for storing business data generated in business;
- Update content information receiving means for receiving, from the core business system, business data update content information indicating the update content of the business data when the business data is updated by the business system, and the received business data update content information
- First linkage data updating means for updating the linkage data based on the update data, and the linkage data is updated.
- a product data updating processing means for executing processing for updating the product data as updated contents of the operational data is reflected.
- the above configuration makes it possible to provide an EC system that can be easily constructed.
- second linkage data update means for updating the linkage data according to the content of the purchase request, and indicating that the purchase request has been accepted It may be configured to include purchase request information transmitting means for transmitting purchase request information to the basic business system.
- the core business system includes a business data DB as the business data storage means, and the business data stored in the business data DB is data composed of at least one table, and has a table with the same structure.
- the process data may be configured to be data in which process data indicating data relating to each business process constituting the process flow is collected in the same entry in the table.
- the basic business system includes at least two or more business data DBs, and further includes replica data receiving means for receiving replica data of each of the at least two business data DBs and data obtained by integrating the received replica data.
- it may be configured to include first cooperation DB update means for updating the cooperation DB as the cooperation data storage means.
- the first cooperation DB update means may be configured to update the cooperation DB so that data obtained by integrating the received plurality of replica data as it is is used as cooperation data.
- Second linkage data update means for updating a linkage DB as the linkage data storage means so that data including at least process data corresponding to display items displayed on the EC site is used as linkage data; It may be configured.
- the product data update processing unit updates the product data by transmitting the business data update content information to an EC site management server that manages the EC site, and the EC site management server includes the product data storage unit.
- EC page generation means for generating EC pages constituting the EC site with reference to the product data storage means.
- the server that manages the EC site may be the linkage server, and the server including the product data storage unit may be the linkage server.
- the cooperation program of the present invention links an EC site that sells products on the Internet with reference to product data storage means for storing product data and a core business system that sells products on the EC site.
- a linkage program for controlling the server In the cooperation server provided with the cooperation data storage means for storing the cooperation data configured based on the work data transmitted from the core business system provided with the work data storage means for storing the work data generated in the work, Update content information reception processing for receiving business data update content information indicating the update content of the business data when the business data is updated by the core business system, and the received business data update content information And a process for updating the product data so that the update contents of the business data are reflected when the cooperation data is updated. This is to execute the product data update process for executing
- the EC system of the present invention also includes an EC site for selling products on the Internet with reference to product data storage means for storing product data, a core business system for selling products on the EC site, and the EC site.
- a linkage server that links the mission-critical business system, the mission-critical system includes business data storage means for storing business data generated in business, and the linkage server includes the business data Coordination data storage means for storing cooperation data configured based on the business data transmitted from the core business system comprising storage means, and the business data when the business data is updated by the core business system Update content information for receiving business data update content information indicating data update content from the core business system Receiving means, first cooperation data updating means for updating the cooperation data based on the received business data update content information, and when the cooperation data is updated, the update content of the business data is And product data update processing means for executing processing for updating the product data so as to be reflected.
- an EC system that can be easily constructed can be provided.
- FIG. 1 is a block diagram showing a configuration example of an EC system 500 according to the first embodiment of the present invention.
- the EC system 500 includes a linkage server 10, user terminals 41 to 4N (N is an arbitrary positive integer), a basic business system (system integrated basic business system 100, and integrated basic business system 200). And an integrated core business system 300).
- the linkage server 10 includes an integrated backbone business system 100, an integrated backbone business system 200, an integrated backbone business system 300, user terminals 41 to 4N, and communication networks 51 and 52 such as a LAN (Local Area Network) and a dedicated communication line, respectively. , 53, 54.
- the linkage server 10 of this example refers to a merchandise data storage unit that stores merchandise data, and links an EC site that sells merchandise on the Internet and a core business system that sells merchandise on the EC site. It is a server. A detailed description of the cooperation server will be given later.
- the integrated core business system 100 includes a core business server 110, a data warehouse server (DWH server) 120, a cooperation program DB 130, and a process flow DB 101.
- the integrated core business system 200 includes a DWH server 220, a cooperation program DB 230, and a process flow DB 201.
- the integrated core business system 300 includes a core business server 310, a cooperation program 330, and a process flow DB 301.
- a plurality of integrated core business systems 100, 200, and 300 having different configurations communicate with a predetermined server on which an ERP operates as necessary (that is, according to the functions of each), thereby forming an integrated core business system. Demonstrate the function. That is, in the EC system 500, even if the system 200 does not have a mission-critical server or the system 300 does not have a DWH server, the integrated mission-critical business can be performed by communicating with a predetermined server on which ERP operates. Can function as a system.
- the EC system may be configured such that a predetermined server on which the ERP operates is provided in each of the integrated core business systems 200 and 300.
- each core business system for example, the integrated core business system 100, 200, 300
- components having the same name have the same configuration, and therefore, all the systems in the integrated core business system 100, 200, 300 are included.
- An explanation will be given taking the integrated core business system 100 including the common components as an example.
- the core business server 110 is a server managed by, for example, an administrator of the integrated core business system 100, and has various functions for managing form information related to various business (for example, creation, update, storage, etc. of information). Have.
- the core business server 110 is configured by a general information processing apparatus including an OS (Operating System) and a relational DB.
- OS Operating System
- relational DB relational DB
- the form is data generated in business and is a general term for books and slips.
- 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 110 handles process data indicating only slip data as form data will be described as an example.
- the core business server 110 executes various processes according to the business application program.
- application programs include a sales business management program, a sales business management program, a production management program, a financial accounting management program, and a management accounting management program.
- the DWH server 120 is a server managed by an administrator of the 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.
- the DWH server 120 has a function of registering various data in a predetermined storage area (a business related data DB 101b described later) by converting a CSV file transferred from the core business server 110 into a predetermined data format.
- a predetermined storage area a business related data DB 101b described later
- the DWH server 120 may be configured to extract data corresponding to each storage area from a CSV (CommaparSeparatedsValues) format state without converting the data format.
- CSV CommonSeparatedsValues
- the cooperation program DB 130 is a DB in which a cooperation program for executing processing for reflecting update information on the entire EC system in real time is stored.
- processing executed according to the cooperation program for example, processing for receiving data transmitted from the EC system cooperation server 10, input to a WEB page of an EC site (not shown) that does not belong to the EC system 500 Processing to receive the received data, processing to update the process flow data stored in the process flow DB 101 based on the received data, processing to notify the EC system cooperation server 10 that the process flow data has been updated, and delivery There are a process for sending a shipping instruction to a terminal (not shown) managed by a merchant, a process for receiving a shipping record from a terminal managed by a delivery company, and the like.
- the integrated core business system 100 of this example includes an inventory information storage unit that stores inventory information calculated based on information relating to loading and unloading in the process flow data.
- the inventory information of this example includes an item ID that can uniquely identify an item, an actual stock quantity, and an order-receiving quantity.
- actual stock quantity is information indicating actual stock.
- quantity during order reception is information indicating the quantity before delivery out of the number of orders received.
- the process flow DB 101 includes various process data (or form data) collected and organized by various information processing using various programs stored in an application program DB (not shown) of the core business server 110.
- a storage medium for storing business data In this example, the case where process flow data is handled as business data will be described as an example. Therefore, hereinafter, business data may be referred to as process flow data.
- FIG. 2 is an explanatory diagram illustrating an example of a storage state of process flow data in the process flow DB 101.
- the process flow data in this example is composed of at least one table, and includes a main key part, a reference key part, a type part, a status part, a common data part, and process specific data.
- Each item corresponding to each part of the process flow data indicates the type of process data constituting the process flow data. That is, data (process data) related to each business process constituting the process flow is allocated and stored in each part (each item) constituting the process flow data.
- the process flow data is composed of at least one table, is composed of tables having the same structure, and data in which data relating to one process flow is collected in the same entry in the table.
- data stored as process flow data is the basis of data related to products or services that are subject to electronic commerce. That is, in this example, the process flow data stored in the process flow DB 101 is used as the basis of product data in the EC system 500.
- Process data relating 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. That is, the process flow data has a structure in which data related to one process flow is collected in the same entry in the process flow table. According to such a configuration, it is possible to define the correspondence between the process data.
- 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 process flow data is registered for the first time” means, for example, when process data belonging to a certain process flow and corresponding other process data is not registered is registered. Shall.
- 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 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.
- 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.
- the process flow table shown in FIG. 2 indicates that the business process “order” in the process flow type “inventory sales” indicates that the business of the amounts “1200” and “2600” has been received from the order recipient “T001”.
- the process flow data including the data can be uniquely specified by a 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. Also, it is assumed that which process is required for each type of process flow is determined in advance (that is, the type and number of business processes included in each type of process flow are different). A plurality of other types of process flows will be presented later.
- 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.
- the process flow of “inventory sales”, and the business processes included in the process flow are “order receipt”, “shipment”, “issue”, “exception inspection”, and “sales”.
- process-specific data for example, order date
- 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 a predetermined storage area of the integrated core business system 100 as the status change condition. It shall be remembered.
- 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.
- the “common data portion” in this example includes an image indicating an item ID, a quantity, and an item for uniquely identifying the item.
- 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. That is, in this example, “order received” means a state including not only a case where an order is received from a normal customer but also a case where an order is received from a user of an EC site.
- shipment instruction means a state in which an instruction to ship a product is given to a warehouse company or a logistics person. That is, in this example, it means a state in which a user who has purchased a product at the EC site has been instructed to ship the product.
- shipment means a state in which the goods are shipped from the warehouse and the movement is started. In other words, in this example, it means that a product purchased by a user of the EC site is shipped from the warehouse.
- acceptance means a state in which the acceptance of the customer is completed and the ownership of the product is transferred to the customer.
- the process flow data includes generally used slip data (for example, for the slip data corresponding to the order slip, the order slip header information, the order slip detail information, the delivery date schedule, etc. Is stored in a structure that can be searched based on the key such as the slip number, etc.
- the slip number includes the order number, order number, shipping number, entry / exit number, invoice inquiry, billing number, Account number etc. are included)).
- the EC system 500 of this example is configured such that process flow data is managed by one process flow table as described above.
- the basic business system for example, the integrated core business system 100
- the process flow data is, for example, for each type described later or a part of the content of common data described later (for example, A configuration may be adopted in which, for each item with the same order recipient, etc., management is performed using a plurality of tables.
- the cooperation server 10 is a server for linking an EC site managed by itself with a core business system (integrated core business system 100, 200, 300).
- the cooperation server 10 is configured by an information processing apparatus such as a WWW server, for example, and is managed by an administrator of the EC system 500 or the like.
- FIG. 3 is a block diagram illustrating a configuration example of the cooperation server 10.
- the linkage server 10 includes a control unit 11 that performs various controls, a transaction data DB 14, a linkage DB 15, a product data DB 16, a business application program DB 17, a process flow DB 18, a DWHDB 19, And a DB 10X for storing various data (for example, data used by various programs stored in the business application program DB 17) necessary for realizing a function as a general core business server.
- the control unit 11 includes a communication processing unit 11a, a data update processing unit 11b, a coordination DB update processing unit 11c, and an EC site management processing unit 11d. Each processing unit included in the control unit 11 executes each process based on a program stored in the business application DB 17.
- the communication processing unit 11a has a function of executing processing for transmitting data used in the EC system 500 to other terminals, processing for receiving from other terminals, and the like.
- the data update processing unit 11b has a function of executing processing for updating data used in the EC system 500. Specifically, the data update processing unit 11b executes processing for adding / deleting data, processing for writing data in a predetermined writing area, and the like.
- the EC site management processing unit 11c executes processing for causing the cooperation server to function as an EC site management server for managing the EC site. Specifically, the EC site management processing unit 11d confirms that a process for receiving a purchase request for a product from a user on the EC site, a process for updating linkage data according to the content of the purchase request, and a purchase request are received. A function of executing processing for transmitting the purchase request information shown to the core business system.
- the transaction data DB 14 is a storage medium that stores transaction data including purchase request information transmitted from the user terminals 41 to 4N.
- Transaction data is data constituting an EC site.
- FIG. 4 is an explanatory diagram showing an example of a storage state of transaction data stored in the transaction data DB 14.
- the transaction data is information stored when purchase request information is received from the user terminals 41 to 4N, and includes a user ID, a process flow number, a core business system ID, an item ID, and the like. , Quantity and status information. Note that the status information becomes “in order” when data is added (that is, when a purchase request is accepted), and then updated appropriately according to the progress of the process (for example, “shipped”, etc.) To be updated).
- the core business system ID is ID information for specifying the core business system as the exhibitor. For example, an identifier “K0001” is stored in the product exhibited by the integrated core business system 100.
- the cooperation DB 15 is a storage medium for storing cooperation data for linking the EC site and the core business system (integrated core business system 100, 200, 300).
- the cooperation data is process flow data transmitted from a core business system (for example, the integrated core business systems 100 and 200).
- the linkage server 10 is configured to include one linkage DB 16, but may be configured to include a plurality of DBs in which each replica data is stored.
- FIG. 5 is an explanatory diagram showing an example of the storage state of the cooperation data stored in the cooperation DB 15.
- the link data since the process flow data is integrated as it is without changing the configuration of the process flow data, the link data has the same configuration as the process flow data stored in the process flow DB 101 described above. .
- the product data DB 16 is a storage medium that stores product data for configuring an EC site.
- FIG. 6 is an explanatory diagram showing an example of the storage state of the product data stored in the product data DB.
- the product data is data constituting an EC site, and includes a core business system ID, an item ID, an image, and an inventory quantity.
- the stock quantity is information indicating the stock quantity of the product.
- the inventory quantity managed here is updated by the EC site management processing unit 11d when the cooperation server 10 receives an order from the user terminal. Specifically, it is rewritten to a value obtained by subtracting the order quantity from the current inventory quantity.
- the business application program DB 17 is a storage medium that stores programs used for various businesses.
- the business application program DB 17 stores various programs such as a sales business management program, a sales business management program, a production management program, a financial accounting management program, a management accounting management program, a data update processing program, and a data transmission / reception processing program.
- the process flow DB 18 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 17. is there.
- the process flow data stored in the process flow DB 18 is generated based on information (for example, process flow data) transmitted from each core business system.
- the cooperation server 10 provides various data stored in the process flow DB 18 and other DB 10X in response to a request from a predetermined external device (for example, the integrated core business system 100, 200, 300). It has composition which has. Therefore, the cooperation server 10 has a function as a core business server. In other words, the cooperation server 10 includes an ERP engine.
- the cooperation server 10 can have a function as a DWH server having various functions for realizing a data warehouse.
- the cooperation server 10 includes an ERP engine and a configuration for functioning as a DWH server, the integrated core business system 100 having different configurations (for example, the integrated core business system 100 having both the core business server and the DWH server).
- the integrated mission-critical business system 200 having only the DWH server and the integrated mission-critical business system 300 having only the DWH server).
- Each of the user terminals 41 to 4N is an information processing apparatus such as a portable terminal or a PC including a CPU (Central Processing Unit), a ROM, a RAM, and a display unit.
- the business partners assumed as users include not only final consumers but also companies and public institutions.
- Each user terminal 41 to 4N communicates with the cooperation server 10 via the relay device 20 and the communication network 54.
- Each of the user terminals 41 to 4N includes a storage medium that stores various applications such as a Web browser that can browse EC pages.
- Each of the user terminals 41 to 4N has a function of acquiring product data from the cooperation server 10 in accordance with, for example, an operation input by the user, and displaying the acquired product data.
- FIG. 7 is a conceptual diagram showing the concept of the EC system of this example. More specifically, FIG. 7 is a conceptual diagram showing a flow of building a basic configuration. As shown in FIG. 7, the EC system can be roughly divided into three sections. Specifically, the EC system includes an online shop section that sells products and services, a plurality of core business system sections (main business systems A, B, and C) that manage data generated in business, an online shop section, It consists of a data management section for linking that links with the core business system section.
- the online shop section and the linkage data management section are configured by one server.
- each core business system first generates a replica of its own DB and transmits the generated replica to the cooperation server.
- the linkage server manages a plurality of received DBs of each basic business system as one DB (see “DB integration processing” in FIG. 7).
- a cooperation server manages several DB as 1 DB.
- the cooperation server generates site management data for managing the EC site based on the integrated DB and stores it in the DB. This site management data becomes the product master. In this way, a basic configuration of an EC system is constructed that directly uses each DB managed by a plurality of basic business systems.
- FIG. 8 is a conceptual diagram showing the concept of the EC system of this example. More specifically, FIG. 8 is a conceptual diagram showing a flow of processing for handling real-time information at the EC site.
- the EC system having the basic configuration shown in FIG. 7, when the information is updated in the core business system section, the updated content is transmitted to the cooperation server.
- the cooperation server updates the site management DB based on the transmitted information (see “first update process” in FIG. 8). For example, in the core business system, when product inventory data fluctuates due to the occurrence of a shipping process, the fact is notified to the cooperation server and the site management server, and information relating to the change is reflected in real time.
- the purchase request content is transmitted to the linkage server.
- the cooperation server updates the DB based on the transmitted information (see “second update process” in FIG. 8). Then, the cooperation server transmits the updated content to the core business system side. At this time, the DB is updated based on the purchase request contents in the core business system section, and the update result is notified to the cooperation server.
- the cooperation server updates the site management DB based on the content of the update notification.
- the EC system can easily manage data managed by a plurality of mission-critical systems as one DB. Furthermore, the data managed by the core business system, a part of the data managed by the linkage server, and the data used at the EC site are synchronized almost in real time. In this way, the EC system can realize electronic commerce with a simple configuration, and the electronic commerce site can reflect the update information in the system in the entire EC system in real time. Will be able to provide.
- FIG. 9 is a flowchart showing an example of the coordination DB update process executed by the collaboration server 10 in the system 500 of this example.
- a case will be described as an example where there are a plurality of core business systems (for example, a company or a predetermined group within a company) included in the EC system 500. Further, a case where data transmitted from a plurality of mission-critical systems is integrated as one data will be described as an example.
- the cooperation server 10 receives DB replica data from each of the core business systems (integrated core business systems 100, 200, 300) included in the EC system (step S101).
- the cooperation server 10 receives the replica data of the process flow DB 101 from the integrated core business system 100.
- the cooperation server 10 receives the replica data of the process flow DB 201 from the integrated core business system 200.
- the cooperation server 10 receives the replica data of the process flow DB 301 from the integrated core business system 300.
- the data received in step S101 includes a mission-critical system ID for uniquely identifying the mission-critical business system that is the transmission source.
- the system 500 of this example is configured to transmit DB replica data stored in the mission-critical business system 100.
- the data necessary for the mission-critical business system 100 to configure an EC site is extracted. And may be configured to transmit.
- the cooperation server 10 integrates each received replica data into one data, and updates the cooperation DB based on the integrated data (step S102).
- the process flow data stored in each of the received three DBs is data composed of at least one table, data composed of tables having the same structure, and 1 This is data in which data relating to the process flow is collected in the same entry in the table. Therefore, the cooperation server 10 can generate the data for cooperation by integrating the replica data of the DBs as they are. According to such a configuration, since the number of tables included in the process flow data can be minimized, it is possible to reduce the capacity of data necessary for constructing the EC site. .
- the EC system can be constructed with a simple configuration.
- the cooperation server 10 generates one cooperation DB 15 by receiving a replica of the DB managed by each basic business system from each of a plurality of basic business systems included in the EC system. It is configured. However, the system 500 of this example is not limited to such a configuration.
- the cooperation server 10 may be configured to generate one cooperation DB from a plurality of DBs by receiving replica data of each of a plurality of process flow DBs included in one core business system.
- the cooperation server 10 may be configured to generate one cooperation DB by receiving replica data of one process flow DB included in one core business system.
- the cooperation server 10 when building the cooperation DB, based on the received process flow data, data related to the display item displayed on the EC site is extracted from the data related to the process flow. It is also possible to construct a linkage DB having a structure that is grouped in the same entry.
- the cooperation server 10 includes a storage unit including data indicating display items displayed on the EC site, and displays the data displayed on the EC site among the data relating to the process flow with reference to the data. What is necessary is just to be comprised so that the data regarding the item corresponding to an item may be extracted.
- the cooperation server 10 updates the product data DB based on the cooperation data (step S103). That is, the product data for configuring the EC site is generated based on the cooperation data. Specifically, data corresponding to predetermined items (for example, item ID, basic business system ID, inventory quantity, status) in the cooperation data is extracted, and each extracted item is stored in the product data DB.
- predetermined items for example, item ID, basic business system ID, inventory quantity, status
- the linkage server 10 ends the linkage DB update process.
- the first update process executed by the cooperation server 10 in the system 500 of this example.
- a process of reflecting the update contents of the process flow data on the EC site is executed.
- FIG. 10 is a flowchart showing an example of the first update process executed by the cooperation server 10 in the system 500 of this example.
- various data are transmitted from each core business system.
- data is transmitted from the integrated core business system 100, and the transaction data shown in FIG.
- the case where the data for cooperation shown and the product data shown in FIG. 6 are updated will be described as an example. In this example, it is assumed that the process loops while the cooperation server 10 is operating.
- the cooperation server 10 receives business data update information (process flow data update information) indicating that the integrated core business system 100 has updated the process flow DB 101 from the integrated core business system 100 (steps). S201).
- the business data update information includes the added table and a core business system ID indicating the integrated core business system 100 of the transmission source.
- the business data update including the core business system ID of “K00001”, the process flow data whose “shipping” is “1”, “item ID” is “S00001”, and “order received” is “T001” Information will be described as an example.
- the cooperation server 10 updates the cooperation DB 15 based on the received business data update information (step S202). Specifically, a new table as data received in step S201 is added to the bottom of the cooperation data shown in FIG. That is, the cooperation data shown in FIG. 5 is updated to the cooperation data shown in FIG.
- the cooperation server 10 updates the DB according to the update content (step S203). That is, referring to the status part in the updated linkage data, it is determined which information (DB) is to be changed, and the product data DB is updated according to the determination.
- DB information
- FIG. 11 in this example, since the status of the added table is “issue”, “T001” is identified with reference to “order received” in the added table, and the status is changed to issue. Transaction data is identified. Then, as shown in FIG. 12, the status of the identified location is changed from “pending order” to “shipped”. That is, the transaction data shown in FIG. 4 is updated to the transaction data shown in FIG.
- step S201 the cooperation server 10 proceeds to step S201 and waits until business data update information is received.
- FIG. 13 is a flowchart illustrating an example of the second update process 2 executed by the cooperation server 10 in the system 500 of the present example.
- a purchase request for a product is transmitted from the user terminals 41 to 4N.
- an example in which a purchase request for a product is transmitted from the user terminal 41 will be described. To do.
- a case where a purchase request for a product is transmitted will be described as an example.
- a configuration may be used in which a browsing request such as information regarding the shipment status of a product is transmitted. In this example, it is assumed that the process loops while the cooperation server 10 is operating.
- the cooperation server 10 receives a purchase request from the user terminal 41 (step S301).
- the linkage server 10 stores the purchase request information in the transaction data DB 14 and updates the linkage DB 15 (step S302). Specifically, a new table to which a process flow detail number is assigned based on the process flow number in the purchase request information is added, and other information included in the purchase request information such as the core business system ID is added to the new table.
- the cooperation server 10 updates the product data DB 16 (step S303). Specifically, product data to be updated is specified based on the core business system ID and the item ID. Specifically, in the product data, the same data as the core business system ID and item ID indicated by the purchase request information is specified, and the stock quantity of the specified data is subtracted by the purchase quantity. For example, in the case where the product data shown in FIG. 6 is stored, the purchase request information with “usage business system ID” “00001”, “item ID” “S00001”, and “purchase quantity” “3”. When received, “stock information” is updated from “25” to “22” as in the product data shown in FIG.
- the linkage server 10 identifies the core business system corresponding to the purchase request information (step S304). That is, the core business system that is the merchandise exhibitor is specified.
- the corresponding core business system refers to the core business system that has transmitted the replica data corresponding to the information transmitted from the user terminal to the cooperation server 10 in step S101 described above.
- the cooperation server 10 transmits purchase request information to the identified core business system (step S305).
- the purchase request information is transmitted to the integrated core business system 100.
- the table added in step S302 may be transmitted.
- the cooperation server 10 proceeds to step S301 and waits until the purchase request information is received.
- FIG. 15 is a flowchart showing an example of business data update processing executed by the integrated core business system 100 in the system 500 of this example.
- the business data update process of this example is executed by the cooperation program included in the cooperation program DB 130. Further, in the business data update process, a process of transmitting predetermined data to a terminal managed by the cooperation server 10 or a delivery company or the like is executed with the reception of information that requires process flow data being received as a trigger. In this example, it is assumed that the process loops while the core business system 100 is operating.
- the integrated core business system 100 receives information that requires the process flow DB 101 to be updated (step S401).
- the data received here is, for example, purchase request information indicating that there is a purchase request for a product transmitted from the cooperation server 10, or a new process flow input by direct input by the administrator of the integrated core business system 100 Data (that is, one column in the process flow table shown in FIG. 2), process flow data related to shipment results transmitted from a terminal managed by the delivery company, and the like.
- the integrated core business system 100 updates the process flow DB 101 based on the input data (step S402). Specifically, a new table to which a process flow detail number is assigned based on the process flow number in the purchase request information is added, and other information included in the purchase request information such as the core business system ID is added to the new table.
- the integrated core business system 100 determines whether or not the process flow DB 101 has been updated based on the receipt of the purchase request information (step S403).
- step S403 When it is determined that the process flow DB 101 has been updated based on the receipt of the purchase request information (Y in step S403), the integrated core business system 100 requires other processing for the data received in step S401. It is determined whether or not the information is to be processed (step S405).
- the integrated core business system 100 displays information indicating that the process flow DB 101 has been updated. It transmits to the cooperation server 10 (step S404). That is, the integrated core business system 100 transmits the business data update information to the cooperation server 10.
- the integrated core business system 100 determines whether the data received in step S401 is information that requires other processing (step S405).
- step S401 When it is determined that the data received in step S401 is information that requires other processing (Y in step S405), the integrated core business system 100 executes processing according to the contents of the data (step S405). S406). When the processing according to the content of the data is executed, the integrated core business system 100 returns to step S401 and waits until data requiring update of the process flow DB is input.
- the “information that requires other processing” is, for example, information that requires a shipping instruction to a delivery company, information that indicates that a predetermined product has been issued, and the like.
- the integrated core business system 100 transmits the shipping instruction to a terminal managed by the delivery company that is the shipping source. Execute. For example, when data indicating that a predetermined product has been issued is received in step S401, the integrated core business system 100 updates the inventory quantity in the inventory information by subtracting the number of goods issued.
- the core business system 100 specifies “item ID” and “quantity” with reference to the “common data portion”. Thereafter, the core business system 100 identifies inventory information corresponding to the item ID identified with reference to the inventory information storage unit. Then, the core business system 100 updates the “quantity” specified above by subtracting it from the “real inventory quantity” and “quantity on order” stored in the inventory information. In this way, the process in the case where information indicating that the predetermined product has been issued is received in step S401 is executed.
- step S401 when it is determined that the data input in step S401 is data that does not require other processing (N in step S405), the integrated core business system 100 returns to step S401, and the process flow DB Wait until data that needs to be updated is entered.
- an EC site that sells products on the Internet with reference to a product data storage unit (product data DB 16) that stores product data, and the EC site.
- the linkage server that links the core business system that sells products to the system is transmitted from the core business system (integrated core business system 100) that includes the business data storage unit (process flow DB 101) that stores business data generated in business.
- Business data update content that includes a data storage unit for collaboration (cooperation DB 15) that stores data for collaboration configured based on business data, and indicates business data update content when business data is updated by the core business system Receive information from the core business system, and link data based on the received business data update content information New, when updating linking data, configured to perform a processing for updating the product data as updated contents of the business data is reflected.
- an EC system that can be easily constructed can be provided by using data managed by the core business system.
- the update information on the core business system side can be reflected in the entire EC system in real time, the user browsing the EC site can browse the information with high accuracy.
- the cooperation server when the cooperation server receives a purchase request for a product from a user of the EC site, the cooperation server updates the data for cooperation according to the content of the purchase request, and issues a purchase request. Purchase request information indicating acceptance is transmitted to the core business system. According to such a configuration, since update information generated at the EC site can be reflected in the entire EC system in real time, a user browsing the EC site can browse information with high accuracy.
- the basic business system includes a business data DB (process flow DB 101).
- the business data (process flow data) stored in the business data DB is data composed of at least one table and is composed of tables having the same structure, and each business constituting the process flow.
- Process data indicating process data is configured to be data that is collected in the same entry in the table. According to such a configuration, the number of tables included in the business data can be minimized, so that it is possible to reduce the capacity of data necessary for constructing the EC site.
- the basic business system includes at least two business data DBs, and further receives replica data of each of at least two business data DBs.
- the cooperation DB as the cooperation data storage means is updated based on the data obtained by integrating the received replica data.
- the cooperation server is configured to update the cooperation DB so that data obtained by integrating the received plurality of replica data as it is is used as the cooperation data.
- the EC system when an EC system is constructed by handling a plurality of business data stored in the core business system, the EC system can be constructed with a simple configuration.
- the linkage DB is set so that the linkage server uses, as linkage data, data including at least process data corresponding to display items displayed on the EC site. It may be configured to update. According to such a configuration, since data constituting the table can be reduced, the capacity of data necessary for constructing an EC site can be reduced while system construction is easy. It becomes like this.
- the basic business system in the system includes an item ID that uniquely identifies a product, a basic business system ID that uniquely identifies its core business system, and an inventory.
- An inventory information storage unit that stores inventory information including the quantity and the number of orders may be provided, and the inventory information may be updated when information indicating that the shipment has been received is received as business data update information.
- the core business system determines whether the information that needs to be updated in the process flow data received in step S401 in the business data update process described above is information indicating that a product has been issued, It may be configured to update the stock quantity in the stock information when it is determined that the information indicates that it has been delivered. According to such a configuration, since temporary inventory information indicating temporary inventory information at the time of receiving an order and actual inventory information indicating actual inventory information can be managed separately, accurate information can be obtained. It becomes possible to handle.
- the cooperation server 10 receives actual stock information from the core business system at a predetermined timing, and is included in the received actual stock information and product data. It may be configured to determine whether or not the numerical value matches the provisional inventory information, and to transmit an alert to the core business system when it is determined that the numerical value does not match. Note that the core business system to which the alert is transmitted displays the content of the alert on the display device that the alert is transmitted to. According to such a configuration, it is possible to notify in advance of troubles based on inconsistencies in inventory, and it is possible to take measures for obtaining accurate information on the notified main business system side.
- the linkage server 10 is configured to have a function as a server for managing an EC site.
- a server different from the cooperation server 10 is configured to manage the EC site.
- the EC site management server 30 is configured to function as a server that manages the EC site.
- FIG. 16 is a block diagram showing a configuration example of an EC system 600 according to the second embodiment of the present invention.
- the EC system 600 includes a linkage server 610, an EC site management server 30, a relay device 20, user terminals 41 to 4N (N is an arbitrary positive integer), and an integrated core business system 100. And an integrated core business system 200 and an integrated core business system 300.
- the EC site management server 30 is a server that provides various data via the communication network 56 in response to requests from the user terminals 41 to 4N used by the user.
- the EC site management server 30 is configured by an information processing apparatus such as a WWW server, for example, and is managed by an administrator of the EC site.
- the EC site management server 30 includes a control unit 31 that performs various controls, a product data DB 32, a transaction data DB 33, and a DB that stores a control program for configuring an EC site. That is, the EC site management server 30 according to the second embodiment includes a configuration corresponding to the product DB 16 and the EC site management processing unit 11d included in the cooperation server 10 according to the first embodiment.
- the control unit 31 provided in the EC site management server 30 executes various processes for managing the EC site.
- processing such as processing is executed.
- the product data DB 32 is a storage medium that stores product data for configuring an EC site.
- the product data includes at least information related to inventory.
- the product data includes an item ID, a core business system ID, an inventory quantity, and a status.
- the product data according to the second embodiment is generated by the EC site management server 30 based on the cooperation data transmitted from the cooperation server 610.
- the transaction data DB 33 is a storage medium that stores transaction data constituting the EC site.
- FIG. 17 is a flowchart showing an example of the first update process executed by the cooperation server 610 in the system 600 of this example.
- various data are transmitted from each core business system.
- the first update process described below a case where data is transmitted from the integrated core business system 100 will be described as an example. In this example, it is assumed that the process loops while the cooperation server 610 is operating.
- the cooperation server 610 receives business data update information indicating that the integrated core business system 100 has updated the process flow DB 101 from the integrated core business system 100 (step S501).
- the cooperation server 610 updates the cooperation DB 15 based on the received business data update information (step S502).
- the cooperation server 610 updates the EC site with information for updating a DB (for example, a product data DB or a transaction data DB) managed by the EC site management server 30 in accordance with the update content. It transmits to the management server 30 (step S503).
- a DB for example, a product data DB or a transaction data DB
- information for updating the DB managed by the EC site management server 30 is information for determining which DB is to be changed and how.
- the instruction information indicates an update location based on information (for example, information such as “status” and “order received”) stored in a table added to the cooperation data.
- the cooperation server 610 proceeds to step S501 and waits until business data update information is received.
- the EC site management server 30 executes an update process for the product data DB 32 based on information for updating the DB.
- FIG. 18 is a flowchart illustrating an example of the second update process executed by the cooperation server 610 in the system 600 of this example.
- the second update process a case where a purchase request for a product is transmitted from the EC site management server 30 will be described as an example.
- the cooperation server 610 receives purchase request information from the EC site management server 30 (step S601).
- the EC site management server 30 updates the product data DB 32 based on the purchase request information and transmits the purchase request information to the cooperation server 610. To do.
- the linkage server 610 stores the purchase request information in the transaction data DB 33 and updates the linkage DB according to the content of the purchase request information (step S602).
- the cooperation server 610 identifies the core business system corresponding to the purchase request information (step S603).
- the cooperation server 610 transmits purchase request information to the identified core business system (step S604).
- the linkage server 610 moves to step S601 and waits until the purchase request information is received.
- the EC system of this example includes an EC site management server that manages an EC site that sells products on the Internet with reference to a product data storage unit (product data DB 32) that stores product data.
- the system can be a system composed of a core business system for listing products on the EC site, and a linkage server that links the EC site management server and the core business system.
- cooperation servers 10 and 610 execute the above-described processes according to the processing program stored in the storage times included in the cooperation server 10 or 610.
- transaction data stored in the transaction data DB (14, 33) described above may be configured integrally with the product data stored in the product data DB (15, 32), respectively.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Computing Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Provided is an electronic commerce system that is easy to build. A coordination server that coordinates an electronic commerce site with a core business system that displays products on the electronic commerce site is provided with a coordination data storage unit for storing coordination data that is configured on the basis of business data transmitted from the core business system, said core business system being provided with a business data storage unit for storing business data that is generated as a result of business. When the business data is updated by the core business system, the coordination server receives business data update content information that indicates business data update content from the core business system, updates the coordination data on the basis of the business data update content information that is received, and, when the coordination data is updated, performs processing for updating product data so as to reflect the business data update content.
Description
本発明は、商品のデータを記憶する商品データ記憶手段を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムとを連携する連携サーバ、その連携サーバを機能させるための連携プログラム、およびECシステムに関する。
The present invention relates to a linked server that links an EC site that sells products on the Internet with reference to a product data storage unit that stores product data, and a core business system that displays products on the EC site, and the linked server The present invention relates to a cooperation program for functioning EC and an EC system.
従来から、IT(Information Technology)関連商品の流通卸サービスに関するシステム(EC(electronic commerce)システム)が公知である。
Conventionally, a system (EC (electronic commerce) system) related to a distribution and wholesale service of IT (Information Technology) related products is known.
例えば、IT関連商品をメーカからユーザに流通させる流通卸業務をコンピュータ及び通信ネットワーク上で支援し、ユーザからメーカまでの各流通段階に配置させるクライアントとの間でIT関連商品の取引情報を含む情報を通信手段を介してリアルタイムにやり取りするECシステムが開示されている(特許文献1参照)。
For example, information that includes distribution information for IT-related products with clients that support distribution and wholesale operations for distributing IT-related products from manufacturers to users on computers and communication networks, and that are arranged at each distribution stage from users to manufacturers. An EC system that exchanges information in real time via communication means is disclosed (see Patent Document 1).
しかしながら、上述した特許文献に記載のECシステムにおいては、IT関連商品を用いたサービスを行うメーカ側において、商品データベースのようなECシステム専用のデータを用意する必要があるという課題があった。すなわち、ECシステムを構築する際の設計負担が大きいという課題があった。
However, in the EC system described in the above-mentioned patent document, there is a problem that a maker that provides services using IT-related products needs to prepare data dedicated to the EC system such as a product database. That is, there is a problem that the design burden when constructing the EC system is large.
本発明は、上述した課題を解消し、構築が容易なECシステムを提供することを目的とする。
An object of the present invention is to solve the above-described problems and provide an EC system that can be easily constructed.
本発明の連携サーバは、商品のデータを記憶する商品データ記憶手段を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムとを連携する連携サーバであって、業務上発生する業務データを記憶する業務データ記憶手段を備える前記基幹業務システムから送信された前記業務データに基づいて構成される連携用データを記憶する連携用データ記憶手段と、前記基幹業務システムにより前記業務データが更新されたときに前記業務データの更新内容を示す業務データ更新内容情報を前記基幹業務システムから受信する更新内容情報受信手段と、受信された前記業務データ更新内容情報に基づいて前記連携用データを更新する第1連携用データ更新手段と、前記連携用データが更新されたときに、前記業務データの更新内容が反映されるように前記商品データを更新するための処理を実行する商品データ更新処理手段とを含むことを特徴する。
The linkage server of the present invention is a linkage server that links an EC site that sells products on the Internet with reference to a product data storage unit that stores product data and a core business system that sells products on the EC site. A data storage unit for cooperation that stores data for cooperation configured based on the business data transmitted from the core business system including business data storage means for storing business data generated in business; Update content information receiving means for receiving, from the core business system, business data update content information indicating the update content of the business data when the business data is updated by the business system, and the received business data update content information First linkage data updating means for updating the linkage data based on the update data, and the linkage data is updated. Occasionally, to; and a product data updating processing means for executing processing for updating the product data as updated contents of the operational data is reflected.
上記の構成としたことで、構築が容易なECシステムを提供することができるようになる。
The above configuration makes it possible to provide an EC system that can be easily constructed.
前記ECサイトのユーザから商品の購入要求が受け付けられたときに、当該購入要求の内容に応じて前記連携用データを更新する第2連携用データ更新手段と、当該購入要求を受け付けたことを示す購入要求情報を前記基幹業務システムに送信する購入要求情報送信手段とを含む構成とされていてもよい。
When a purchase request for a product is received from a user of the EC site, second linkage data update means for updating the linkage data according to the content of the purchase request, and indicating that the purchase request has been accepted It may be configured to include purchase request information transmitting means for transmitting purchase request information to the basic business system.
前記基幹業務システムは、前記業務データ記憶手段としての業務データDBを備え、前記業務データDBに格納される前記業務データは、少なくとも1以上のテーブルにより構成されるデータであり、同一構造のテーブルにより構成されるデータであり、プロセスフローを構成する各業務プロセスに関するデータ示すプロセスデータを当該テーブルにおいて同一のエントリにまとめたデータである構成とされていてもよい。
The core business system includes a business data DB as the business data storage means, and the business data stored in the business data DB is data composed of at least one table, and has a table with the same structure. The process data may be configured to be data in which process data indicating data relating to each business process constituting the process flow is collected in the same entry in the table.
前記基幹業務システムは、前記業務データDBを少なくとも2以上備え、さらに、少なくとも2以上の前記業務データDBそれぞれのレプリカデータを受信するレプリカデータ受信手段と、受信されたレプリカデータを統合したデータに基づいて、前記連携用データ記憶手段としての連携用DBを更新する第1連携用DB更新手段とを含む構成とされていてもよい。
The basic business system includes at least two or more business data DBs, and further includes replica data receiving means for receiving replica data of each of the at least two business data DBs and data obtained by integrating the received replica data. In addition, it may be configured to include first cooperation DB update means for updating the cooperation DB as the cooperation data storage means.
前記第1連携用DB更新手段は、受信された複数の前記レプリカデータをそのまま統合したデータを連携用データとするように前記連携用DBを更新する構成とされていてもよい。
The first cooperation DB update means may be configured to update the cooperation DB so that data obtained by integrating the received plurality of replica data as it is is used as cooperation data.
前記ECサイト上で表示される表示項目に対応するプロセスデータを少なくとも含むデータを連携用データとするように前記連携用データ記憶手段としての連携用DBを更新する第2連携用データ更新手段を含む構成とされていてもよい。
Second linkage data update means for updating a linkage DB as the linkage data storage means so that data including at least process data corresponding to display items displayed on the EC site is used as linkage data; It may be configured.
前記商品データ更新処理手段は、前記ECサイト管理するECサイト管理サーバに対して前記業務データ更新内容情報を送信することにより前記商品データを更新させ、前記ECサイト管理サーバは、前記商品データ記憶手段と、前記商品データ記憶手段を参照し、前記ECサイトを構成するECページを生成するECページ生成手段とを有する構成とされていてもよい。
The product data update processing unit updates the product data by transmitting the business data update content information to an EC site management server that manages the EC site, and the EC site management server includes the product data storage unit. And EC page generation means for generating EC pages constituting the EC site with reference to the product data storage means.
前記ECサイトを管理するサーバが前記連携サーバであり、前記商品データ記憶手段を備えるサーバが前記連携サーバである構成とされていてもよい。
The server that manages the EC site may be the linkage server, and the server including the product data storage unit may be the linkage server.
また、本発明の連携プログラムは、商品のデータを記憶する商品データ記憶手段を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムとを連携する連携サーバを制御するための連携プログラムであって、
業務上発生する業務データを記憶する業務データ記憶手段を備える前記基幹業務システムから送信された前記業務データに基づいて構成される連携用データを記憶する連携用データ記憶手段を備える前記連携サーバに、前記基幹業務システムにより前記業務データが更新されたときに前記業務データの更新内容を示す業務データ更新内容情報を前記基幹業務システムから受信する更新内容情報受信処理と、受信した前記業務データ更新内容情報に基づいて前記連携用データを更新する第1連携用DB更新処理と、前記連携用データを更新したときに、前記業務データの更新内容が反映されるように前記商品データを更新するための処理を実行する商品データ更新処理とを実行させるためのものである。 In addition, the cooperation program of the present invention links an EC site that sells products on the Internet with reference to product data storage means for storing product data and a core business system that sells products on the EC site. A linkage program for controlling the server,
In the cooperation server provided with the cooperation data storage means for storing the cooperation data configured based on the work data transmitted from the core business system provided with the work data storage means for storing the work data generated in the work, Update content information reception processing for receiving business data update content information indicating the update content of the business data when the business data is updated by the core business system, and the received business data update content information And a process for updating the product data so that the update contents of the business data are reflected when the cooperation data is updated. This is to execute the product data update process for executing
業務上発生する業務データを記憶する業務データ記憶手段を備える前記基幹業務システムから送信された前記業務データに基づいて構成される連携用データを記憶する連携用データ記憶手段を備える前記連携サーバに、前記基幹業務システムにより前記業務データが更新されたときに前記業務データの更新内容を示す業務データ更新内容情報を前記基幹業務システムから受信する更新内容情報受信処理と、受信した前記業務データ更新内容情報に基づいて前記連携用データを更新する第1連携用DB更新処理と、前記連携用データを更新したときに、前記業務データの更新内容が反映されるように前記商品データを更新するための処理を実行する商品データ更新処理とを実行させるためのものである。 In addition, the cooperation program of the present invention links an EC site that sells products on the Internet with reference to product data storage means for storing product data and a core business system that sells products on the EC site. A linkage program for controlling the server,
In the cooperation server provided with the cooperation data storage means for storing the cooperation data configured based on the work data transmitted from the core business system provided with the work data storage means for storing the work data generated in the work, Update content information reception processing for receiving business data update content information indicating the update content of the business data when the business data is updated by the core business system, and the received business data update content information And a process for updating the product data so that the update contents of the business data are reflected when the cooperation data is updated. This is to execute the product data update process for executing
また、本発明のECシステムは、商品のデータを記憶する商品データ記憶手段を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムと、前記ECサイトと前記基幹業務システムとを連携する連携サーバとを含むECシステムであって、前記基幹業務システムは、業務上発生する業務データを記憶する業務データ記憶手段を含み、前記連携サーバは、前記業務データ記憶手段を備える前記基幹業務システムから送信された前記業務データに基づいて構成される連携用データを記憶する連携用データ記憶手段と、前記基幹業務システムにより前記業務データが更新されたときに前記業務データの更新内容を示す業務データ更新内容情報を前記基幹業務システムから受信する更新内容情報受信手段と、受信された前記業務データ更新内容情報に基づいて前記連携用データを更新する第1連携用データ更新手段と、前記連携用データが更新されたときに、前記業務データの更新内容が反映されるように前記商品データを更新するための処理を実行する商品データ更新処理手段とを含むことを特徴とする。
The EC system of the present invention also includes an EC site for selling products on the Internet with reference to product data storage means for storing product data, a core business system for selling products on the EC site, and the EC site. And a linkage server that links the mission-critical business system, the mission-critical system includes business data storage means for storing business data generated in business, and the linkage server includes the business data Coordination data storage means for storing cooperation data configured based on the business data transmitted from the core business system comprising storage means, and the business data when the business data is updated by the core business system Update content information for receiving business data update content information indicating data update content from the core business system Receiving means, first cooperation data updating means for updating the cooperation data based on the received business data update content information, and when the cooperation data is updated, the update content of the business data is And product data update processing means for executing processing for updating the product data so as to be reflected.
本発明によれば、構築が容易なECシステムを提供することができるようになる。
According to the present invention, an EC system that can be easily constructed can be provided.
[第1の実施の形態]
以下、本発明の第1の実施の形態の例について図面を参照して説明する。図1は、本発明の第1の実施の形態に係るECシステム500の構成例を示すブロック図である。図1に示すように、ECシステム500は、連携サーバ10と、ユーザ端末41~4N(Nは任意の正の整数)と、基幹業務システム(システム統合基幹業務システム100と、統合基幹業務システム200と、統合基幹業務システム300)とを含む。 [First Embodiment]
An example of the first embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing a configuration example of an EC system 500 according to the first embodiment of the present invention. As shown in FIG. 1, the EC system 500 includes alinkage server 10, user terminals 41 to 4N (N is an arbitrary positive integer), a basic business system (system integrated basic business system 100, and integrated basic business system 200). And an integrated core business system 300).
以下、本発明の第1の実施の形態の例について図面を参照して説明する。図1は、本発明の第1の実施の形態に係るECシステム500の構成例を示すブロック図である。図1に示すように、ECシステム500は、連携サーバ10と、ユーザ端末41~4N(Nは任意の正の整数)と、基幹業務システム(システム統合基幹業務システム100と、統合基幹業務システム200と、統合基幹業務システム300)とを含む。 [First Embodiment]
An example of the first embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing a configuration example of an EC system 500 according to the first embodiment of the present invention. As shown in FIG. 1, the EC system 500 includes a
連携サーバ10は、統合基幹業務システム100、統合基幹業務システム200、および統合基幹業務システム300と、ユーザ端末41~4Nと、それぞれLAN(Local Area Network)や専用通信回線などの通信ネットワーク51,52,53,54を介して接続される。本例の連携サーバ10は、商品のデータを記憶する商品データ記憶部を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムとを連携するためのサーバである。なお、連携サーバの詳細な説明は、後で行う。
The linkage server 10 includes an integrated backbone business system 100, an integrated backbone business system 200, an integrated backbone business system 300, user terminals 41 to 4N, and communication networks 51 and 52 such as a LAN (Local Area Network) and a dedicated communication line, respectively. , 53, 54. The linkage server 10 of this example refers to a merchandise data storage unit that stores merchandise data, and links an EC site that sells merchandise on the Internet and a core business system that sells merchandise on the EC site. It is a server. A detailed description of the cooperation server will be given later.
統合基幹業務システム100は、基幹業務サーバ110と、データウェアハウスサーバ(DWHサーバ)120と、連携用プログラムDB130と、プロセスフローDB101とを含む。統合基幹業務システム200は、DWHサーバ220と、連携用プログラムDB230と、プロセスフローDB201とを含む。統合基幹業務システム300は、基幹業務サーバ310と、連携用プログラム330と、プロセスフローDB301とを含む。
The integrated core business system 100 includes a core business server 110, a data warehouse server (DWH server) 120, a cooperation program DB 130, and a process flow DB 101. The integrated core business system 200 includes a DWH server 220, a cooperation program DB 230, and a process flow DB 201. The integrated core business system 300 includes a core business server 310, a cooperation program 330, and a process flow DB 301.
構成が異なる複数の統合基幹業務システム100,200,300は、必要に応じて(すなわち、それぞれが有する機能に応じて)ERPが稼働する所定のサーバと通信を行うことにより、統合基幹業務システムとしての機能を発揮する。すなわち、ECシステム500においては、基幹業務サーバを有さないシステム200や、DWHサーバを有さないシステム300であっても、ERPが稼働する所定のサーバとの通信を行うことにより、統合基幹業務システムとしての機能を発揮することができる。なお、ECシステムにおいては、ERPが稼働する所定のサーバが統合基幹業務システム200,300それぞれに備わっているように構成されていてもよい。各基幹業務システム(例えば、統合基幹業務システム100,200,300)において、同一の名称を有する構成要素は、同様の構成を有するため、統合基幹業務システム100,200,300のうち、全てのシステムに共通する構成要素を含む統合基幹業務システム100を例にして説明を行う。
A plurality of integrated core business systems 100, 200, and 300 having different configurations communicate with a predetermined server on which an ERP operates as necessary (that is, according to the functions of each), thereby forming an integrated core business system. Demonstrate the function. That is, in the EC system 500, even if the system 200 does not have a mission-critical server or the system 300 does not have a DWH server, the integrated mission-critical business can be performed by communicating with a predetermined server on which ERP operates. Can function as a system. The EC system may be configured such that a predetermined server on which the ERP operates is provided in each of the integrated core business systems 200 and 300. In each core business system (for example, the integrated core business system 100, 200, 300), components having the same name have the same configuration, and therefore, all the systems in the integrated core business system 100, 200, 300 are included. An explanation will be given taking the integrated core business system 100 including the common components as an example.
基幹業務サーバ110とDWHサーバ120とは、専用通信回線により接続されているものとする。
It is assumed that the core business server 110 and the DWH server 120 are connected by a dedicated communication line.
基幹業務サーバ110は、例えば統合基幹業務システム100の管理者によって管理されるサーバであり、各種業務に関する帳票情報を管理(例えば、情報の作成や更新、保存など。)するための各種の機能を有する。基幹業務サーバ110は、OS(Operating System)やリレーショナルDBを備えた一般的な情報処理装置によって構成される。
The core business server 110 is a server managed by, for example, an administrator of the integrated core business system 100, and has various functions for managing form information related to various business (for example, creation, update, storage, etc. of information). Have. The core business server 110 is configured by a general information processing apparatus including an OS (Operating System) and a relational DB.
ここで、帳票とは、業務上発生するデータであって、帳簿や伝票などの総称である。また、帳簿とは、金銭や品物の出納に関する事項が記入されるものであり、伝票とは、帳簿を作成する際の基となるデータであり業務上の取引等の証拠となるものである。本例においては、基幹業務サーバ110が、帳票データとして、伝票データのみを示すプロセスデータを扱う場合を例に説明を行なう。
Here, the form is data generated in business and is a general term for books and slips. In addition, a book is a field in which items relating to cash and goods are entered, and a slip is data that is the basis for creating a book and is evidence of business transactions. In this example, the case where the core business server 110 handles process data indicating only slip data as form data will be described as an example.
基幹業務サーバ110は、業務アプリケーションプログラムに従って各種の処理を実行する。アプリケーションプログラムとしては、例えば、販売業務管理プログラム、販売業務管理プログラム、生産管理プログラム、財務会計管理プログラム、管理会計管理プログラムなどがある。
The core business server 110 executes various processes according to the business application program. Examples of application programs include a sales business management program, a sales business management program, a production management program, a financial accounting management program, and a management accounting management program.
DWHサーバ120は、例えば本システムの管理者によって管理されるサーバであり、データウェアハウスを実現するための各種の機能を有する。ここで、データウェアハウスとは、時系列で蓄積された帳票データなどの業務データの中から各項目間の関連性を分析するシステムをいう。また、DWHサーバ120は、基幹業務サーバ110から転送されたCSV形式のファイルを所定のデータ形式に変換するなどして、所定の格納領域(後述する業務関連データDB101b)に各種データを登録する機能を有する。なお、DWHサーバ120は、データ形式の変換を行わず、CSV(Comma Separated Values)形式の状態から各格納領域に応じたデータを抽出する構成とされていてもよい。
The DWH server 120 is a server managed by an administrator of the system, for example, and has various functions for realizing a data warehouse. Here, the data warehouse refers to a system that analyzes the relationship between items from business data such as form data accumulated in time series. Also, the DWH server 120 has a function of registering various data in a predetermined storage area (a business related data DB 101b described later) by converting a CSV file transferred from the core business server 110 into a predetermined data format. Have Note that the DWH server 120 may be configured to extract data corresponding to each storage area from a CSV (CommaparSeparatedsValues) format state without converting the data format.
連携用プログラムDB130は、更新情報をリアルタイムにECシステム全体に反映させる処理を実行するための連携用プログラムが格納されるDBである。ここで、連携用プログラムに従って実行される処理としては、例えば、ECシステム連携用サーバ10から送信されるデータを受信する処理、ECシステム500に属さないECサイト(図示せず)のWEBページに入力されたデータを受信する処理、受信したデータに基づいてプロセスフローDB101に格納されるプロセスフローデータを更新する処理、プロセスフローデータが更新されたことをECシステム連携用サーバ10に通知する処理、配送業者が管理する端末(図示せず)に対して出荷指示を送信する処理、配送業者が管理する端末から出荷実績を受信する処理などがある。
The cooperation program DB 130 is a DB in which a cooperation program for executing processing for reflecting update information on the entire EC system in real time is stored. Here, as processing executed according to the cooperation program, for example, processing for receiving data transmitted from the EC system cooperation server 10, input to a WEB page of an EC site (not shown) that does not belong to the EC system 500 Processing to receive the received data, processing to update the process flow data stored in the process flow DB 101 based on the received data, processing to notify the EC system cooperation server 10 that the process flow data has been updated, and delivery There are a process for sending a shipping instruction to a terminal (not shown) managed by a merchant, a process for receiving a shipping record from a terminal managed by a delivery company, and the like.
なお、特に図示はしないが、本例の統合基幹業務システム100は、プロセスフローデータにおける出入庫に関する情報に基づいて算出された在庫情報を格納する在庫情報記憶部を備える。本例の在庫情報は、品目を一意に特定可能な品目IDと、実在庫数量と、受注中数量とを含む。ここで、「実在庫数量」は、実際の在庫を示す情報である。また、「受注中数量」は、受注数のうち出庫前の数量を示す情報である。
Although not shown in particular, the integrated core business system 100 of this example includes an inventory information storage unit that stores inventory information calculated based on information relating to loading and unloading in the process flow data. The inventory information of this example includes an item ID that can uniquely identify an item, an actual stock quantity, and an order-receiving quantity. Here, “actual stock quantity” is information indicating actual stock. Further, “quantity during order reception” is information indicating the quantity before delivery out of the number of orders received.
プロセスフローDB101は、基幹業務サーバ110のアプリケーションプログラムDB(図示せず)に記憶された各種プログラムを用いた各種情報処理によって収集・整理等された各種のプロセスデータ(または帳票データ)により構成される業務データを記憶する記憶媒体である。本例では、業務データとして、プロセスフローデータが取り扱われる場合を例にして説明を行う。したがって、以下、業務データをプロセスフローデータと呼ぶ場合がある。
The process flow DB 101 includes various process data (or form data) collected and organized by various information processing using various programs stored in an application program DB (not shown) of the core business server 110. A storage medium for storing business data. In this example, the case where process flow data is handled as business data will be described as an example. Therefore, hereinafter, business data may be referred to as process flow data.
図2は、プロセスフローDB101におけるプロセスフローデータの格納状態の例を示す説明図である。図2に示すように、本例におけるプロセスフローデータは、少なくとも1以上のテーブルにより構成され、主キー部と、参照キー部と、タイプ部と、ステータス部と、共通データ部と、プロセス固有データ部とを含む。なお、プロセスフローデータの各部に対応する項目(すなわち、プロセスフローテーブルにおける各列項目)が、それぞれ、プロセスフローデータを構成するプロセスデータの種類を示す。すなわち、プロセスフローを構成する各業務プロセスに関するデータ(プロセスデータ)は、プロセスフローデータを構成する各部(各項目)に割り当てられて格納される。
FIG. 2 is an explanatory diagram illustrating an example of a storage state of process flow data in the process flow DB 101. As shown in FIG. 2, the process flow data in this example is composed of at least one table, and includes a main key part, a reference key part, a type part, a status part, a common data part, and process specific data. Part. Each item corresponding to each part of the process flow data (that is, each column item in the process flow table) indicates the type of process data constituting the process flow data. That is, data (process data) related to each business process constituting the process flow is allocated and stored in each part (each item) constituting the process flow data.
なお、本例のシステム500では、少なくとも1以上のテーブルにより構成され、同一構造のテーブルにより構成され、および1のプロセスフローに関するデータを当該テーブルにおける同一のエントリにまとめられたデータを、プロセスフローデータとして用いる場合を例にして説明を行う。
Note that in the system 500 of this example, the process flow data is composed of at least one table, is composed of tables having the same structure, and data in which data relating to one process flow is collected in the same entry in the table. The case of using as will be described as an example.
なお、本例では、プロセスフローデータとして格納されるデータが、電子的な商取引の対象となる商品またはサービスに関するデータの基礎となる。すなわち、本例では、プロセスフローDB101に格納されるプロセスフローデータが、ECシステム500における商品データの基礎として用いられることとなる。
In this example, data stored as process flow data is the basis of data related to products or services that are subject to electronic commerce. That is, in this example, the process flow data stored in the process flow DB 101 is used as the basis of product data in the EC system 500.
1つのプロセスフロー(例えば、ある企業からの受注から納品までの一連のプロセスフロー)に関するプロセスデータは、プロセスフローテーブルにおいて同一エントリ(すなわち、プロセステーブルPTにおける同一行)に格納される。すなわち、プロセスフローデータは、1のプロセスフローに関するデータをプロセスフローテーブルにおける同一のエントリにまとめた構造を持つ。このような構成によれば、各プロセスデータ間の対応関係を定義することができる。
Process data relating 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. That is, the process flow data has a structure in which data related to one process flow is collected in the same entry in the process flow table. According to such a configuration, it is possible to define the correspondence between the process data.
ここで、「主キー部」とは、プロセスフローデータのうち、プロセスフローデータを一意に特定するためのデータである主キーデータが格納される部分である。本例においては、主キー部は、プロセスフロー番号とプロセスフロー明細番号とにより構成される。すなわち、本例においては、プロセスフロー番号とプロセスフロー明細番号との組み合わせが、各プロセスフローデータの識別子(ID)となる。主キー部は、プロセスフローデータの初回登録時に更新される。なお、ここでの「プロセスフローデータの初回登録時」とは、例えば、あるプロセスフローに属するプロセスデータであって、対応する他のプロセスデータが未登録のプロセスデータが登録されるときを意味するものとする。また、ここでの「更新」とは、データの追加を含むものとする。
Here, 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. In this example, 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. Here, “when process flow data is registered for the first time” means, for example, when process data belonging to a certain process flow and corresponding other process data is not registered is registered. Shall. The “update” here includes addition of data.
なお、「プロセスフロー番号」とは、1つのプロセスフローデータ(すなわち、図2に示すプロセスフローテーブルにおける1列)を特定するための識別子である。プロセスフロー番号は、所定の項目が同じプロセスデータ毎に付与される。本例においては、プロセスフロー番号は、プロセスフローデータにおけるタイプと受注先とが同じプロセスフローデータに対して同一の番号が付与される。
The “process flow number” is an identifier for specifying one process flow data (that is, one column in the process flow table shown in FIG. 2). The process flow number is assigned to each process data having the same predetermined item. In this example, 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.
また、「プロセスフロー明細番号」とは、同一のプロセスフロー番号が付与されたプロセスフローデータの中から特定のプロセスフローデータを特定するための識別子である。例えば、図2に示すプロセスフローテーブルは、プロセスフローのタイプ「在庫売上」における業務プロセス「受注」において、受注先「T001」から金額「1200」と「2600」の業務を受注したことを示すプロセスデータを含むプロセスフローデータを、それぞれプロセスフロー番号「000001」とプロセスフロー明細番号「0010」または「0020」の組み合わせにより一意に特定することができる。
Further, 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. For example, the process flow table shown in FIG. 2 indicates that the business process “order” in the process flow type “inventory sales” indicates that the business of the amounts “1200” and “2600” has been received from the order recipient “T001”. The process flow data including the data can be uniquely specified by a combination of the process flow number “000001” and the process flow detail number “0010” or “0020”, respectively.
次いで、「参照キー部」とは、プロセスフローデータのうち、売上返品に対する元取引など、プロセスフローに関連する他のプロセスフローデータ(または、他のプロセスデータ)を特定するためのデータである参照キーデータが格納される部分である。本例においては、参照キー部は、参照番号と参照明細番号とにより構成される。参照キー部は、プロセスフローデータの初回登録時に更新される。
Next, 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. In this example, 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.
なお、参照番号と参照明細番号には、それぞれ、プロセスフローに関連する他のプロセスフローのプロセスフロー番号とプロセスフロー明細番号とが格納される。ただし、新規取引の場合など、プロセスフローに関連する他のプロセスフローがない場合には、参照キー部には、同一エントリの主キー部と同じ値を示すデータが(すなわち、参照番号にはプロセスフロー番号が、参照明細番号にはプロセスフロー明細番号がそれぞれ)格納される。また、参照キー部が、プロセスフローに関連する他のプロセスデータを示す場合、参照キー部には、プロセスデータの種類を特定するためのデータがさらに設けられる。
It should be noted that 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. However, when there is no other process flow related to the process flow, such as in the case of a new transaction, 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. Further, when 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.
また、「タイプ部」とは、プロセスフローデータのうち、在庫売上やサンプル出荷など、プロセスフローの種類を示すデータであるタイプデータが格納される部分である。タイプ部は、プロセスフローデータの初回登録時に更新される。なお、プロセスフローの種類は、在庫売上やサンプル出荷に限られない。また、プロセスフローの種類毎にどのプロセスが必要なのかが予め決まっているものとする(すなわち、プロセスフローの種類毎に含まれる業務プロセスの種類や数が異なる)。なお、プロセスフローの他の種類については、後で複数提示する。
In addition, 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. Note that the type of process flow is not limited to inventory sales or sample shipment. Also, it is assumed that which process is required for each type of process flow is determined in advance (that is, the type and number of business processes included in each type of process flow are different). A plurality of other types of process flows will be presented later.
また、「ステータス部」とは、プロセスフローデータのうち、プロセスフローの進捗を表すデータ(すなわち、プロセスフローに含まれる複数の業務プロセスそれぞれの進捗状況を示すデータ)であるステータスデータが格納される部分である。本例においては、ステータスデータは、プロセスフローが必要とする業務プロセスに対し、未済のものには「0」、既済のものには「1」が設定されることにより、各業務プロセスの進捗を示す。例えば、図2に示すように、「在庫売上」のプロセスフローであって、プロセスフローに含まれる業務プロセスが「受注」、「出荷」、「出庫」、「出庫検収」、および「売上」である場合に、業務プロセス「受注」に関するプロセス固有データ(例えば、受注日)が登録されたとする。この場合、ステータスデータは、「売上」に対応する部分が「1」になり、その他の部分は初期状態(すなわち、「0」が設定された状態)のままとなる。
In addition, 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. Part. In this example, 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. 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”, “exception inspection”, and “sales”. In some cases, it is assumed that process-specific data (for example, order date) relating 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).
すなわち、本例におけるステータス部は、業務プロセス毎に更新される。言い換えれば、ステータス部は、後述するプロセス固有データの入力のとき、具体的には、所定のステータス変更条件が満たされたことにより各業務プロセスが完了した判定されたときに更新される。なお、ステータス変更条件は特に限定されないが、本例においては、「1つの業務プロセスに対応するプロセス固有データが全て入力されること」がステータス変更条件として統合基幹業務システム100の所定の記憶領域に記憶されているものとする。
That is, the status part in this example is updated for each business process. In other words, 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. Although 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 a predetermined storage area of the integrated core business system 100 as the status change condition. It shall be remembered.
なお、本例においては、異なる種類のプロセスフローが同一のテーブルに格納されるため、テーブルを構成する項目(列項目)のうち、特定のプロセスフローには不要なプロセスデータを格納する部分が生じる場合もある。この場合、プロセスフローテーブルにおいては、不要なプロセスデータを格納する部分が空データとなり、空データに対応するステータスデータには「0」が格納されるものとする。
In this example, since different types of process flows are stored in the same table, a part of the items (column items) constituting the table stores unnecessary process data in a specific process flow. In some cases. In this case, in the process flow table, a part for storing unnecessary process data is empty data, and “0” is stored in status data corresponding to the empty data.
また、「共通データ部」とは、プロセスフローデータのうち、受注先や出荷先など、業務プロセスによらないデータ(すなわち、同一のプロセスフローに含まれる業務プロセス間で共通するデータ)である共通データが格納される部分である。共通データ部は、プロセスフローデータの初回登録時に更新される。本例の「共通データ部」は、品目を一意に特定するための品目ID、数量、および品目を示す画像を含む。
In addition, 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. The “common data portion” in this example includes an image indicating an item ID, a quantity, and an item for uniquely identifying the item.
また、「プロセス固有データ部」とは、プロセスフローデータのうち、受注日や各業務プロセスにおいて登録されるデータ(例えば、「納期必着」や「ワレモノ(割れ物注意)」などの注意事項を示すテキストデータ)など、同一のプロセスフローに含まれる各業務プロセスに固有のデータであるプロセス固有データが格納される部分である。プロセス固有データ部は、業務プロセス毎に更新される。よって、本例においては、プロセスフローデータのうち、業務プロセスによるものが「プロセス固有データ」であり、業務プロセスによらないものが「共通データ」であるといえる。
In addition, the “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”.
以上が本例におけるプロセスフローデータに関する説明となるが、ここで、図2に示す各種用語の定義について簡単に説明する。
The above is the description of the process flow data in this example. Here, the definitions of various terms shown in FIG. 2 will be briefly described.
先ず、「受注」とは、得意先から注文を受け、得意先との契約を結んだ状態を意味する。すなわち、本例で言えば、「受注」とは、通常の取引先からの注文を受けた場合のみならず、ECサイトのユーザから注文を受注した場合を含む状態を意味する。
First, “order received” means a state in which an order is received from a customer and a contract with the customer is concluded. That is, in this example, “order received” means a state including not only a case where an order is received from a normal customer but also a case where an order is received from a user of an EC site.
また、「出荷指示」とは、倉庫業者や物流担当者に商品を出荷する指示を行った状態を意味する。すなわち、本例で言えば、ECサイトにて商品を購入したユーザに対して、当該商品についての出荷指示を行った状態を意味する。
Also, the “shipment instruction” means a state in which an instruction to ship a product is given to a warehouse company or a logistics person. That is, in this example, it means a state in which a user who has purchased a product at the EC site has been instructed to ship the product.
また、「出庫」とは、商品が倉庫から出荷され、移動が開始された状態を意味する。すなわち、本例で言えば、ECサイトのユーザによって購入された商品が倉庫から出荷された状態を意味する。
Also, “shipping” means a state in which the goods are shipped from the warehouse and the movement is started. In other words, in this example, it means that a product purchased by a user of the EC site is shipped from the warehouse.
また、「検収」とは、得意先の検収が完了し、商品の所有権が得意先に移行した状態を意味する。
Also, “acceptance” means a state in which the acceptance of the customer is completed and the ownership of the product is transferred to the customer.
また、「売上」とは、得意先の検収を確認し、得意先に対する債権金額が確定(=債権を計上)した状態を意味する。
Also, “sales” means a state in which the customer's acceptance has been confirmed and the amount of receivables from the customer has been finalized (= accounting for receivables).
また、「検収」の用語は、「納入品やサービスが、注文通りの仕様(=注文通りの数量、色や形、品質)になっているかを検査する業務」や「検収完了時、資産の所有権が移行する」という意味でも用いられる。なお、財務会計上(または、制度会計上)やERPシステム上では、資産の所有権の移行タイミングを明確にするために、「検収」というイベントが出庫と区別して定義される。
In addition, the term “acceptance” means “business to inspect whether the delivered product or service has the specifications as ordered (= quantity, color, shape, quality as ordered)” or “ It is also used to mean “ownership is transferred”. Note that, in financial accounting (or institutional accounting) and the ERP system, in order to clarify the timing of asset ownership transfer, an event “acceptance” is defined separately from shipping.
なお、本例においては、プロセスフローデータには、一般的に用いられている伝票データ(例えば、受注伝票に対応する伝票データについては、受注伝票ヘッダ情報、受注伝票明細情報、および納入日日程などが対応付けされ、伝票番号などのキーを元に検索可能な構造で記憶されたデータ。なお、伝票番号には、受注番号、発注番号、出荷番号、入出庫番号、請求書照会、請求番号、会計番号などが含まれる。)が含まれるものとする。
In this example, the process flow data includes generally used slip data (for example, for the slip data corresponding to the order slip, the order slip header information, the order slip detail information, the delivery date schedule, etc. Is stored in a structure that can be searched based on the key such as the slip number, etc. Note that the slip number includes the order number, order number, shipping number, entry / exit number, invoice inquiry, billing number, Account number etc. are included)).
なお、本例のECシステム500では、上述のようにプロセスフローデータが1つのプロセスフローテーブルにて管理されるように構成されている。しかしながら、このような構成に限られず、基幹業務システム(例えば、統合基幹業務システム100)が、プロセスフローデータを、例えば、後述するタイプ毎に、あるいは後述する共通データの内容の一部(例えば、受注先など)が同じもの毎に、複数のテーブルで管理する構成としてもよい。
Note that the EC system 500 of this example is configured such that process flow data is managed by one process flow table as described above. However, the basic business system (for example, the integrated core business system 100) is not limited to such a configuration, and the process flow data is, for example, for each type described later or a part of the content of common data described later (for example, A configuration may be adopted in which, for each item with the same order recipient, etc., management is performed using a plurality of tables.
連携サーバ10は、自己が管理するECサイトと、基幹業務システム(統合基幹業務システム100,200,300)とを連携させるためのサーバである。連携サーバ10は、例えばWWWサーバなどの情報処理装置によって構成され、ECシステム500の管理者などによって管理される。
The cooperation server 10 is a server for linking an EC site managed by itself with a core business system (integrated core business system 100, 200, 300). The cooperation server 10 is configured by an information processing apparatus such as a WWW server, for example, and is managed by an administrator of the EC system 500 or the like.
図3は、連携サーバ10の構成例を示すブロック図である。図3に示すように、連携サーバ10は、各種制御を行う制御部11と、取引データDB14と、連携用DB15と、商品データDB16と、業務アプリケーションプログラムDB17と、プロセスフローDB18と、DWHDB19と、一般的な基幹業務サーバとしての機能を実現するために必要な各種データ(例えば、業務アプリケーションプログラムDB17に格納される各種プログラムが利用するデータ)を格納するその他DB10Xとを備えている。
FIG. 3 is a block diagram illustrating a configuration example of the cooperation server 10. As shown in FIG. 3, the linkage server 10 includes a control unit 11 that performs various controls, a transaction data DB 14, a linkage DB 15, a product data DB 16, a business application program DB 17, a process flow DB 18, a DWHDB 19, And a DB 10X for storing various data (for example, data used by various programs stored in the business application program DB 17) necessary for realizing a function as a general core business server.
制御部11は、通信処理部11aと、データ更新処理部11bと、と、連携用DB更新処理部11cと、ECサイト管理処理部11dとを含む。制御部11に含まれる各処理部は、業務アプリケーションDB17に格納されるプログラムに基づいて各処理を実行する。
The control unit 11 includes a communication processing unit 11a, a data update processing unit 11b, a coordination DB update processing unit 11c, and an EC site management processing unit 11d. Each processing unit included in the control unit 11 executes each process based on a program stored in the business application DB 17.
通信処理部11aは、ECシステム500で用いられるデータを、他の端末に送信する処理や、他の端末から受信する処理などを実行する機能を有する。
The communication processing unit 11a has a function of executing processing for transmitting data used in the EC system 500 to other terminals, processing for receiving from other terminals, and the like.
データ更新処理部11bは、ECシステム500で用いられるデータを更新する処理を実行する機能を有する。具体的には、データ更新処理部11bは、データを追加・削除する処理や、所定の書込み領域にデータを書き込む処理などを実行する。
The data update processing unit 11b has a function of executing processing for updating data used in the EC system 500. Specifically, the data update processing unit 11b executes processing for adding / deleting data, processing for writing data in a predetermined writing area, and the like.
ECサイト管理処理部11cは、連携サーバを、ECサイトを管理するECサイト管理サーバとして機能させるための処理を実行する。具体的には、ECサイト管理処理部11dは、ECサイトのユーザから商品の購入要求を受け付ける処理や、購入要求の内容に応じて連携用データを更新する処理や、購入要求を受け付けたことを示す購入要求情報を基幹業務システムに送信する処理などを実行する機能を有する。
The EC site management processing unit 11c executes processing for causing the cooperation server to function as an EC site management server for managing the EC site. Specifically, the EC site management processing unit 11d confirms that a process for receiving a purchase request for a product from a user on the EC site, a process for updating linkage data according to the content of the purchase request, and a purchase request are received. A function of executing processing for transmitting the purchase request information shown to the core business system.
取引データDB14は、ユーザ端末41~4Nから送信される購入要求情報を含む取引データを記憶する記憶媒体である。取引データは、ECサイトを構成するデータである。
The transaction data DB 14 is a storage medium that stores transaction data including purchase request information transmitted from the user terminals 41 to 4N. Transaction data is data constituting an EC site.
図4は、取引データDB14に格納される取引データの格納状態の例を示す説明図である。図4に示すように、取引データは、ユーザ端末41~4Nから購入要求情報を受信したときに格納される情報であり、ユーザIDと、プロセスフロー番号と、基幹業務システムIDと、品目IDと、数量と、ステータス情報とを含む。なお、ステータス情報は、データの追加時(つまり、購入要求が受け付けられたとき)には「受注中」となり、その後、プロセスの進捗状況に応じて適宜更新される(例えば、「出庫済」などに更新される)。
FIG. 4 is an explanatory diagram showing an example of a storage state of transaction data stored in the transaction data DB 14. As shown in FIG. 4, the transaction data is information stored when purchase request information is received from the user terminals 41 to 4N, and includes a user ID, a process flow number, a core business system ID, an item ID, and the like. , Quantity and status information. Note that the status information becomes “in order” when data is added (that is, when a purchase request is accepted), and then updated appropriately according to the progress of the process (for example, “shipped”, etc.) To be updated).
ここで、基幹業務システムIDとは、出品元となる基幹業務システムを特定するためのID情報である。例えば、統合基幹業務システム100が出品する商品には、「K0001」という識別子が格納される。
Here, the core business system ID is ID information for specifying the core business system as the exhibitor. For example, an identifier “K0001” is stored in the product exhibited by the integrated core business system 100.
連携用DB15は、ECサイトと基幹業務システム(統合基幹業務システム100,200,300)とを連携させるための連携用データを格納する記憶媒体である。
The cooperation DB 15 is a storage medium for storing cooperation data for linking the EC site and the core business system (integrated core business system 100, 200, 300).
ここで、連携用データは、基幹業務システム(例えば、統合基幹業務システム100および200)から送信されるプロセスフローデータである。本例では、連携サーバ10は、連携用DB16を1つ備える構成としているが、各レプリカデータそれぞれが格納される複数のDBを備えるように構成されていてもよい。
Here, the cooperation data is process flow data transmitted from a core business system (for example, the integrated core business systems 100 and 200). In this example, the linkage server 10 is configured to include one linkage DB 16, but may be configured to include a plurality of DBs in which each replica data is stored.
図5は、連携用DB15に格納される連携用データの格納状態の例を示す説明図である。本例においては、プロセスフローデータの構成を変更することなくそのまま連携用データとして統合することとしているため、連携用データは、上述したプロセスフローDB101に格納されるプロセスフローデータと同様の構成を持つ。
FIG. 5 is an explanatory diagram showing an example of the storage state of the cooperation data stored in the cooperation DB 15. In this example, since the process flow data is integrated as it is without changing the configuration of the process flow data, the link data has the same configuration as the process flow data stored in the process flow DB 101 described above. .
商品データDB16は、ECサイトを構成するための商品データを記憶する記憶媒体である。
The product data DB 16 is a storage medium that stores product data for configuring an EC site.
図6は、商品データDBに格納される商品データの格納状態の例を示す説明図である。図6に示すように、商品データは、ECサイトを構成するデータであり、基幹業務システムID、品目ID、画像、および在庫数量を含む。
FIG. 6 is an explanatory diagram showing an example of the storage state of the product data stored in the product data DB. As shown in FIG. 6, the product data is data constituting an EC site, and includes a core business system ID, an item ID, an image, and an inventory quantity.
ここで、在庫数量とは、商品の在庫の数量を示す情報である。ここで管理される在庫数量は、連携サーバ10がユーザ端末からの受注を受け付けたときにECサイト管理処理部11dにより更新される。具体的には、現在の在庫個数から受注個数を減じた数値に書き換えられる。
Here, the stock quantity is information indicating the stock quantity of the product. The inventory quantity managed here is updated by the EC site management processing unit 11d when the cooperation server 10 receives an order from the user terminal. Specifically, it is rewritten to a value obtained by subtracting the order quantity from the current inventory quantity.
業務アプリケーションプログラムDB17は、各種業務に用いられるプログラムを記憶する記憶媒体である。業務アプリケーションプログラムDB17は、例えば、販売業務管理プログラム、販売業務管理プログラム、生産管理プログラム、財務会計管理プログラム、管理会計管理プログラム、データ更新処理プログラム、およびデータ送受信処理プログラムなどの各種プログラムを記憶する。
The business application program DB 17 is a storage medium that stores programs used for various businesses. The business application program DB 17 stores various programs such as a sales business management program, a sales business management program, a production management program, a financial accounting management program, a management accounting management program, a data update processing program, and a data transmission / reception processing program.
プロセスフローDB18は、業務アプリケーションプログラムDB17に記憶された各種プログラムを用いた各種情報処理によって収集・整理等された各種のプロセスデータ(または帳票データ)により構成されるプロセスフローデータを記憶する記憶媒体である。プロセスフローDB18に格納されるプロセスフローデータは、各基幹業務システムから送信された情報(例えば、プロセスフローデータ)に基づいて生成される。
The process flow DB 18 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 17. is there. The process flow data stored in the process flow DB 18 is generated based on information (for example, process flow data) transmitted from each core business system.
本例においては、連携サーバ10は、プロセスフローDB18およびその他DB10Xに格納された各種データを、所定の外部装置(例えば、統合基幹業務システム100,200,300)からの要求に応じて提供する機能を有する構成としている。したがって、連携サーバ10は、基幹業務サーバとしての機能を有する。言い換えれば、連携サーバ10は、ERPエンジンを備えることとなる。
In this example, the cooperation server 10 provides various data stored in the process flow DB 18 and other DB 10X in response to a request from a predetermined external device (for example, the integrated core business system 100, 200, 300). It has composition which has. Therefore, the cooperation server 10 has a function as a core business server. In other words, the cooperation server 10 includes an ERP engine.
なお、図示しないが、本例においては、連携サーバ10は、データウェアハウスを実現するための各種の機能を有するDWHサーバとしての機能を有するものとすることができる。連携サーバ10が、ERPエンジンと、DWHサーバとして機能するための構成とを備えることにより、構成の異なる統合基幹業務システム(例えば、基幹業務サーバとDWHサーバのうち、両方を有する統合基幹業務システム100と、DWHサーバのみを有する統合基幹業務システム200と、DWHサーバのみを有する統合基幹業務システム300。)に対しても、統合基幹業務システムとして要求される情報の提供を行う構成とすることができる。
Although not shown, in this example, the cooperation server 10 can have a function as a DWH server having various functions for realizing a data warehouse. When the cooperation server 10 includes an ERP engine and a configuration for functioning as a DWH server, the integrated core business system 100 having different configurations (for example, the integrated core business system 100 having both the core business server and the DWH server). And the integrated mission-critical business system 200 having only the DWH server and the integrated mission-critical business system 300 having only the DWH server). .
各ユーザ端末41~4Nは、CPU(中央処理装置)、ROM、RAM、および表示部などを備えた例えば携帯端末やPCなどの情報処理装置である。ここで、ユーザとして想定されている商取引相手は、最終消費者のみならず、企業や公的機関などを含む。
Each of the user terminals 41 to 4N is an information processing apparatus such as a portable terminal or a PC including a CPU (Central Processing Unit), a ROM, a RAM, and a display unit. Here, the business partners assumed as users include not only final consumers but also companies and public institutions.
各ユーザ端末41~4Nは、中継機20及び通信ネットワーク54を介して連携サーバ10と通信する。また、各ユーザ端末41~4Nは、Webブラウザなど、ECページを閲覧可能な各種アプリケーションを記憶する記憶媒体を備える。そして、各ユーザ端末41~4Nは、例えばユーザによる操作入力に応じて、連携サーバ10から商品データを取得し、取得した商品データを表示する機能などを有する。
Each user terminal 41 to 4N communicates with the cooperation server 10 via the relay device 20 and the communication network 54. Each of the user terminals 41 to 4N includes a storage medium that stores various applications such as a Web browser that can browse EC pages. Each of the user terminals 41 to 4N has a function of acquiring product data from the cooperation server 10 in accordance with, for example, an operation input by the user, and displaying the acquired product data.
次に、本例のECシステム500(以下、システム500と呼ぶ場合がある。)の概念について図面を参照して説明する。
Next, the concept of the EC system 500 of this example (hereinafter sometimes referred to as the system 500) will be described with reference to the drawings.
図7は、本例のECシステムの概念を示す概念図である。より具体的に言えば、図7は、基本的な構成が構築される流れを示す概念図である。図7に示すように、ECシステムは、大別すると、3つのセクションに分けて考えることができる。具体的には、ECシステムは、商品やサービスを販売するオンラインショップセクションと、業務上発生するデータを管理する複数の基幹業務システムセクション(基幹業務システムA,B,C)と、オンラインショップセクションと基幹業務システムセクションとを連携させる連携用データ管理セクションとから構成される。ここでは、オンラインショップセクションと連携用データ管理セクションとが、1のサーバにより構成される。
FIG. 7 is a conceptual diagram showing the concept of the EC system of this example. More specifically, FIG. 7 is a conceptual diagram showing a flow of building a basic configuration. As shown in FIG. 7, the EC system can be roughly divided into three sections. Specifically, the EC system includes an online shop section that sells products and services, a plurality of core business system sections (main business systems A, B, and C) that manage data generated in business, an online shop section, It consists of a data management section for linking that links with the core business system section. Here, the online shop section and the linkage data management section are configured by one server.
本例のECシステムでは、まず、各基幹業務システムが、自己のDBのレプリカを生成し、生成したレプリカを連携サーバに送信する。連携サーバは、受信した各基幹業務システムの複数のDBを1つのDBとして管理する(図7中の「DB統合処理」参照)。そして、連携サーバは、複数のDBを1のDBとして管理する。さらに、連携サーバは、統合したDBに基づいてECサイトを管理するサイト管理用データを生成しDBに保存する。このサイト管理用データが商品マスタとなる。このようにして、複数の基幹業務システムで管理されているそれぞれのDBをそのまま利用したECシステムの基本的構成が構築される。
In the EC system of this example, each core business system first generates a replica of its own DB and transmits the generated replica to the cooperation server. The linkage server manages a plurality of received DBs of each basic business system as one DB (see “DB integration processing” in FIG. 7). And a cooperation server manages several DB as 1 DB. Further, the cooperation server generates site management data for managing the EC site based on the integrated DB and stores it in the DB. This site management data becomes the product master. In this way, a basic configuration of an EC system is constructed that directly uses each DB managed by a plurality of basic business systems.
図8は、本例のECシステムの概念を示す概念図である。より具体的に言えば、図8は、ECサイトにてリアルタイムな情報を扱うための処理の流れを示す概念図である。図7に示した基本構成を持つECシステムにおいて、基幹業務システムセクションで情報が更新されると、その更新内容が連携サーバに送信される。連携サーバは、送信された情報に基づいてサイト管理用のDBを更新する(図8中の「第1更新処理」参照)。例えば、基幹業務システムにおいて、出荷プロセスが生じたことにより商品の在庫データが変動したときに、その旨が連携サーバおよびサイト管理サーバに通知されることとなり、変更に関する情報がリアルタイムに反映される。
FIG. 8 is a conceptual diagram showing the concept of the EC system of this example. More specifically, FIG. 8 is a conceptual diagram showing a flow of processing for handling real-time information at the EC site. In the EC system having the basic configuration shown in FIG. 7, when the information is updated in the core business system section, the updated content is transmitted to the cooperation server. The cooperation server updates the site management DB based on the transmitted information (see “first update process” in FIG. 8). For example, in the core business system, when product inventory data fluctuates due to the occurrence of a shipping process, the fact is notified to the cooperation server and the site management server, and information relating to the change is reflected in real time.
一方で、オンラインショップセクションで、商品(またはサービス)購入要求が受け付けられると、その購入要求内容が連携サーバに送信される。連携サーバは、送信された情報に基づいてDBを更新する(図8中の「第2更新処理」参照)。そして、連携サーバは、更新内容を基幹業務システム側に送信する。このとき、基幹業務システムセクションで購入要求内容に基づいたDBの更新が行われ、その更新結果が、連携サーバに通知される。そして、更新の通知を受けた連携サーバは、更新の通知の内容に基づいてサイト管理用のDBを更新する。
On the other hand, when a product (or service) purchase request is accepted in the online shop section, the purchase request content is transmitted to the linkage server. The cooperation server updates the DB based on the transmitted information (see “second update process” in FIG. 8). Then, the cooperation server transmits the updated content to the core business system side. At this time, the DB is updated based on the purchase request contents in the core business system section, and the update result is notified to the cooperation server. Upon receiving the update notification, the cooperation server updates the site management DB based on the content of the update notification.
上述のように、ECシステムは、複数の基幹業務システムでそれぞれ管理されるデータを簡単に1つのDBとして管理することができる。さらに、基幹業務システムで管理するデータと、連携サーバで管理するデータの一部と、ECサイトで用いられるデータとがほぼリアルタイムで同期することとなる。このようにして、ECシステムは、簡単な構成により電子的な商取引を実現することができるようになるとともに、システムおける更新情報をリアルタイムにECシステム全体に反映させることができる電子的な商取引の場を提供することができるようになる。
As described above, the EC system can easily manage data managed by a plurality of mission-critical systems as one DB. Furthermore, the data managed by the core business system, a part of the data managed by the linkage server, and the data used at the EC site are synchronized almost in real time. In this way, the EC system can realize electronic commerce with a simple configuration, and the electronic commerce site can reflect the update information in the system in the entire EC system in real time. Will be able to provide.
次に、本例のシステム500の動作について図面を参照して説明する。なお、本発明に特に関係しない動作や処理については、その内容を省略している場合がある。
Next, the operation of the system 500 of this example will be described with reference to the drawings. Note that the contents of operations and processes not particularly related to the present invention may be omitted.
先ず、本例のシステム500における連携サーバ10が実行する連携用DB更新処理について説明する。
First, the cooperation DB update processing executed by the cooperation server 10 in the system 500 of this example will be described.
図9は、本例のシステム500における連携サーバ10が実行する連携用DB更新処理の例を示すフローチャートである。ここでは、ECシステム500に含まれる基幹業務システム(例えば、企業や、企業内の所定のグループ)が複数存在する場合を例に説明する。さらに、複数の基幹業務システムから送信されるデータを1つのデータとして統合する場合を例にして説明する。
FIG. 9 is a flowchart showing an example of the coordination DB update process executed by the collaboration server 10 in the system 500 of this example. Here, a case will be described as an example where there are a plurality of core business systems (for example, a company or a predetermined group within a company) included in the EC system 500. Further, a case where data transmitted from a plurality of mission-critical systems is integrated as one data will be described as an example.
連携用DB更新処理において、先ず、連携サーバ10は、ECシステムに含まれる基幹業務システム(統合基幹業務システム100,200,300)それぞれから、DBのレプリカデータを受信する(ステップS101)。本例では、3つのDBが、受信される。具体的には、連携サーバ10は、統合基幹業務システム100からプロセスフローDB101のレプリカデータを受信する。また、連携サーバ10は、統合基幹業務システム200からプロセスフローDB201のレプリカデータを受信する。さらに、連携サーバ10は、統合基幹業務システム300からプロセスフローDB301のレプリカデータを受信する。なお、なお、ステップS101で受信されるデータは、送信元となる基幹業務システムを一意に特定するための基幹業務システムIDを含む。
In the cooperation DB update process, first, the cooperation server 10 receives DB replica data from each of the core business systems (integrated core business systems 100, 200, 300) included in the EC system (step S101). In this example, three DBs are received. Specifically, the cooperation server 10 receives the replica data of the process flow DB 101 from the integrated core business system 100. Further, the cooperation server 10 receives the replica data of the process flow DB 201 from the integrated core business system 200. Further, the cooperation server 10 receives the replica data of the process flow DB 301 from the integrated core business system 300. Note that the data received in step S101 includes a mission-critical system ID for uniquely identifying the mission-critical business system that is the transmission source.
なお、本例のシステム500では、基幹業務システム100に格納されるDBのレプリカデータが送信されるように構成されているが、基幹業務システム100がECサイトを構成するために必要なデータを抽出して送信するように構成されていてもよい。
The system 500 of this example is configured to transmit DB replica data stored in the mission-critical business system 100. However, the data necessary for the mission-critical business system 100 to configure an EC site is extracted. And may be configured to transmit.
各基幹業務システムそれぞれからDBのレプリカが受信されると、連携サーバ10は、受信した各レプリカデータを1のデータに統合し、統合したデータに基づいて連携用DBを更新する(ステップS102)。上述のように、本例では、受信した3つのDBそれぞれに格納されるプロセスフローデータは、少なくとも1以上のテーブルにより構成されるデータであり、同一構造のテーブルにより構成されるデータであり、1のプロセスフローに関するデータを当該テーブルにおける同一のエントリにまとめたデータである。そのため、連携サーバ10は、DBのレプリカデータどうしをそのまま統合することで連携用データを生成することができるようになる。このような構成によれば、プロセスフローデータに含まれるテーブル数を最小限に抑えることができるようになるため、ECサイトを構築するために必要なデータの容量を軽減させることができるようになる。本例のような基幹業務システムに格納される複数のプロセスフローデータを取扱うECシステムを構築する場合に、簡単な構成によりECシステムを構築することができるようになる。
When a DB replica is received from each core business system, the cooperation server 10 integrates each received replica data into one data, and updates the cooperation DB based on the integrated data (step S102). As described above, in this example, the process flow data stored in each of the received three DBs is data composed of at least one table, data composed of tables having the same structure, and 1 This is data in which data relating to the process flow is collected in the same entry in the table. Therefore, the cooperation server 10 can generate the data for cooperation by integrating the replica data of the DBs as they are. According to such a configuration, since the number of tables included in the process flow data can be minimized, it is possible to reduce the capacity of data necessary for constructing the EC site. . When an EC system that handles a plurality of process flow data stored in the core business system as in this example is constructed, the EC system can be constructed with a simple configuration.
なお、本例においては、連携サーバ10は、ECシステムに含まれる複数の基幹業務システムそれぞれから、各基幹業務システムそれぞれが管理するDBのレプリカを受信することにより、1の連携用DB15を生成する構成としている。しかしながら、本例のシステム500は、このような構成に限られない。例えば、連携サーバ10が、1の基幹業務システムに含まれる複数のプロセスフローDBそれぞれのレプリカデータを受信することにより、複数のDBから1の連携用DBを生成する構成とされていてもよい。さらには、連携サーバ10が、1の基幹業務システムに含まれる1のプロセスフローDBのレプリカデータを受信することにより、1の連携用DBを生成する構成とされていてもよい。
In this example, the cooperation server 10 generates one cooperation DB 15 by receiving a replica of the DB managed by each basic business system from each of a plurality of basic business systems included in the EC system. It is configured. However, the system 500 of this example is not limited to such a configuration. For example, the cooperation server 10 may be configured to generate one cooperation DB from a plurality of DBs by receiving replica data of each of a plurality of process flow DBs included in one core business system. Furthermore, the cooperation server 10 may be configured to generate one cooperation DB by receiving replica data of one process flow DB included in one core business system.
また、連携用DBを構築するときに、受信したプロセスフローデータに基づいて、プロセスフローに関するデータのうち、ECサイト上で表示される表示項目に対応する項目に関するデータを抽出し、抽出したデータを同一のエントリにまとめた構造を持つ連携用DBを構築する構成とすることもできる。具体的には、連携サーバ10は、ECサイト上で表示される表示項目を示すデータを含む記憶部を備え、当該データを参照してプロセスフローに関するデータのうち、ECサイト上で表示される表示項目に対応する項目に関するデータを抽出するように構成されていればよい。
Also, when building the cooperation DB, based on the received process flow data, data related to the display item displayed on the EC site is extracted from the data related to the process flow. It is also possible to construct a linkage DB having a structure that is grouped in the same entry. Specifically, the cooperation server 10 includes a storage unit including data indicating display items displayed on the EC site, and displays the data displayed on the EC site among the data relating to the process flow with reference to the data. What is necessary is just to be comprised so that the data regarding the item corresponding to an item may be extracted.
1のデータとして統合して連携用DBが更新されると、連携サーバ10は、連携用データに基づいて商品データDBを更新する(ステップS103)。すなわち、ECサイトを構成するための商品データは、連携用データに基づいて生成される。具体的には、連携用データにおける所定の項目(例えば、品目ID、基幹業務システムID、在庫数量、ステータス)に対応するデータを抽出し、抽出した各項目を商品データDBに格納する。
When the cooperation DB is updated by integrating the data as 1 data, the cooperation server 10 updates the product data DB based on the cooperation data (step S103). That is, the product data for configuring the EC site is generated based on the cooperation data. Specifically, data corresponding to predetermined items (for example, item ID, basic business system ID, inventory quantity, status) in the cooperation data is extracted, and each extracted item is stored in the product data DB.
商品データDBが更新されると、連携サーバ10は、連携用DB更新処理を終了する。
When the product data DB is updated, the linkage server 10 ends the linkage DB update process.
次に、本例のシステム500における連携サーバ10が実行する第1更新処理の例を説明する。第1更新処理では、プロセスフローデータの更新内容をECサイトに反映させる処理が実行される。
Next, an example of the first update process executed by the cooperation server 10 in the system 500 of this example will be described. In the first update process, a process of reflecting the update contents of the process flow data on the EC site is executed.
図10は、本例のシステム500における連携サーバ10が実行する第1更新処理の例を示すフローチャートである。第1更新処理では、各基幹業務システムから各種データが送信されるが、以下で説明する第1更新処理では、統合基幹業務システム100からデータが送信され、図4に示す取引データ、図5に示す連携用データ、および図6に示す商品データが更新される場合を例にして説明する。なお、本例では、連携サーバ10が稼働している間においては、処理がループするものとする。
FIG. 10 is a flowchart showing an example of the first update process executed by the cooperation server 10 in the system 500 of this example. In the first update process, various data are transmitted from each core business system. However, in the first update process described below, data is transmitted from the integrated core business system 100, and the transaction data shown in FIG. The case where the data for cooperation shown and the product data shown in FIG. 6 are updated will be described as an example. In this example, it is assumed that the process loops while the cooperation server 10 is operating.
第1更新処理において、先ず、連携サーバ10は、統合基幹業務システム100がプロセスフローDB101を更新したことを示す業務データ更新情報(プロセスフローデータ更新情報)を統合基幹業務システム100から受信する(ステップS201)。なお、業務データ更新情報は、追加したテーブルと、送信元の統合基幹業務システム100を示す基幹業務システムIDとを含む。ここでは、「K00001」という基幹業務システムIDと、「出庫」が「1」、「品目ID」が「S00001」、および「受注先」が「T001」であるプロセスフローデータとを含む業務データ更新情報を例にして説明する。
In the first update process, first, the cooperation server 10 receives business data update information (process flow data update information) indicating that the integrated core business system 100 has updated the process flow DB 101 from the integrated core business system 100 (steps). S201). The business data update information includes the added table and a core business system ID indicating the integrated core business system 100 of the transmission source. Here, the business data update including the core business system ID of “K00001”, the process flow data whose “shipping” is “1”, “item ID” is “S00001”, and “order received” is “T001” Information will be described as an example.
業務データ更新情報が受信されると、連携サーバ10は、受信した業務データ更新情報に基づいて連携用DB15を更新する(ステップS202)。具体的には、ステップS201で受信したデータとしての新たなテーブルが図5に示す連携用データの最下部に追加される。すなわち、図5に示す連携用データは、図11に示す連携用データへと更新される。
When the business data update information is received, the cooperation server 10 updates the cooperation DB 15 based on the received business data update information (step S202). Specifically, a new table as data received in step S201 is added to the bottom of the cooperation data shown in FIG. That is, the cooperation data shown in FIG. 5 is updated to the cooperation data shown in FIG.
連携用DB15が更新されると、連携サーバ10は、当該更新内容に応じてDBを更新する(ステップS203)。すなわち、更新した連携用データにおけるステータス部を参照して、どの情報(DB)をどのように変更するのか決定し、当該決定に応じて商品データDBが更新される。図11に示すように、本例では追加したテーブルのステータスが「出庫」となっているため、追加したテーブルにおける「受注先」を参照して「T001」が特定され、ステータスを出庫に変更する取引データが特定される。そして、図12に示すように特定された箇所のステータスが「受注中」から「出庫済」へと変更される。すなわち、図4に示す取引データは、図12に示す取引データへと更新される。
When the cooperation DB 15 is updated, the cooperation server 10 updates the DB according to the update content (step S203). That is, referring to the status part in the updated linkage data, it is determined which information (DB) is to be changed, and the product data DB is updated according to the determination. As shown in FIG. 11, in this example, since the status of the added table is “issue”, “T001” is identified with reference to “order received” in the added table, and the status is changed to issue. Transaction data is identified. Then, as shown in FIG. 12, the status of the identified location is changed from “pending order” to “shipped”. That is, the transaction data shown in FIG. 4 is updated to the transaction data shown in FIG.
DBが更新されると、連携サーバ10は、ステップS201に移行し、業務データ更新情報を受信するまで待機する。
When the DB is updated, the cooperation server 10 proceeds to step S201 and waits until business data update information is received.
次に、本例のシステム500における連携サーバ10が実行する第2更新処理の例を説明する。図13は、本例のシステム500における連携サーバ10が実行する第2更新処理2の例を示すフローチャートである。第2更新処理では、ユーザ端末41~4Nから商品の購入要求が送信されるが、以下で説明する第2更新処理では、ユーザ端末41から商品の購入要求が送信される場合を例にして説明する。また、本例では、商品の購入要求が送信される場合を例にして説明するが、商品の出荷状況に関する情報などの閲覧要求が送信される構成とされていてもよい。なお、本例では、連携サーバ10が稼働している間においては、処理がループするものとする。
Next, an example of the second update process executed by the cooperation server 10 in the system 500 of this example will be described. FIG. 13 is a flowchart illustrating an example of the second update process 2 executed by the cooperation server 10 in the system 500 of the present example. In the second update process, a purchase request for a product is transmitted from the user terminals 41 to 4N. In the second update process described below, an example in which a purchase request for a product is transmitted from the user terminal 41 will be described. To do. Further, in this example, a case where a purchase request for a product is transmitted will be described as an example. However, a configuration may be used in which a browsing request such as information regarding the shipment status of a product is transmitted. In this example, it is assumed that the process loops while the cooperation server 10 is operating.
第2更新処理において、先ず、連携サーバ10は、ユーザ端末41から購入要求を受信する(ステップS301)。
In the second update process, first, the cooperation server 10 receives a purchase request from the user terminal 41 (step S301).
購入要求情報が受信されると、連携サーバ10は、購入要求情報を取引データDB14に格納するとともに、連携用DB15を更新する(ステップS302)。具体的には、購入要求情報におけるプロセスフロー番号に基づいてプロセスフロー明細番号が割り当てられた新たなテーブルが追加され、基幹業務システムIDなどの購入要求情報に含まれる他の情報が当該新たなテーブルに格納される。
When the purchase request information is received, the linkage server 10 stores the purchase request information in the transaction data DB 14 and updates the linkage DB 15 (step S302). Specifically, a new table to which a process flow detail number is assigned based on the process flow number in the purchase request information is added, and other information included in the purchase request information such as the core business system ID is added to the new table. Stored in
連携用DB15が更新されると、連携サーバ10は、商品データDB16を更新する(ステップS303)。具体的には、基幹業務システムIDと、品目IDとに基づいて、更新すべき商品データが特定される。具体的には、商品データにおいて、購入要求情報により示される基幹業務システムID、および品目IDと同一のデータが特定され、特定したデータの在庫数量が、購入数量分減算される。例えば、図6に示す商品データを格納している場合に、「基幹業務システムID」が「00001」、「品目ID」が「S00001」、および「購入数量」が「3」という購入要求情報を受信した場合には、図14に示す商品データのように「在庫情報」が、「25」から「22」に更新される。
When the cooperation DB 15 is updated, the cooperation server 10 updates the product data DB 16 (step S303). Specifically, product data to be updated is specified based on the core business system ID and the item ID. Specifically, in the product data, the same data as the core business system ID and item ID indicated by the purchase request information is specified, and the stock quantity of the specified data is subtracted by the purchase quantity. For example, in the case where the product data shown in FIG. 6 is stored, the purchase request information with “usage business system ID” “00001”, “item ID” “S00001”, and “purchase quantity” “3”. When received, “stock information” is updated from “25” to “22” as in the product data shown in FIG.
商品データDB16が更新されると、連携サーバ10は、購入要求情報に対応する基幹業務システムを特定する(ステップS304)。すなわち、商品の出品元である基幹業務システムが特定される。なお、対応する基幹業務システムとは、上述したステップS101で連携サーバ10に対して、ユーザ端末から送信された情報に対応するレプリカデータを送信した基幹業務システムのことを示す。
When the product data DB 16 is updated, the linkage server 10 identifies the core business system corresponding to the purchase request information (step S304). That is, the core business system that is the merchandise exhibitor is specified. The corresponding core business system refers to the core business system that has transmitted the replica data corresponding to the information transmitted from the user terminal to the cooperation server 10 in step S101 described above.
購入要求に対応する基幹業務システムが特定されると、連携サーバ10は、特定した基幹業務システムに対して、購入要求情報を送信する(ステップS305)。なお、本例のシステム500では、購入要求情報が統合基幹業務システム100に送信される構成とされているが、ステップS302にて追加したテーブルが送信される構成とされていてもよい。
When the core business system corresponding to the purchase request is identified, the cooperation server 10 transmits purchase request information to the identified core business system (step S305). In the system 500 of this example, the purchase request information is transmitted to the integrated core business system 100. However, the table added in step S302 may be transmitted.
購入要求情報が送信されると、連携サーバ10は、ステップS301に移行し、購入要求情報を受信するまで待機する。
When the purchase request information is transmitted, the cooperation server 10 proceeds to step S301 and waits until the purchase request information is received.
次に、本例のシステム500における基幹業務システム(統合基幹業務システム100,200,300)が実行する業務データ更新処理の例を説明する。なお、本例の業務データ更新処理では、基幹業務システムのうち統合基幹業務システム100が処理を実行する場合を例にして説明を行う。
Next, an example of business data update processing executed by the core business system (integrated core business system 100, 200, 300) in the system 500 of this example will be described. In the business data update processing of this example, the case where the integrated core business system 100 executes processing in the core business system will be described as an example.
図15は、本例のシステム500における統合基幹業務システム100が実行する業務データ更新処理の例を示すフローチャートである。本例の業務データ更新処理は、連携用プログラムDB130に含まれる連携用プログラムにより実行される。また、業務データ更新処理では、プロセスフローデータの更新を要する情報を受信したことをトリガとして、所定のデータを連携サーバ10や配送業者が管理する端末などに送信する処理が実行される。なお、本例では、基幹業務システム100が稼働している間においては、処理がループするものとする。
FIG. 15 is a flowchart showing an example of business data update processing executed by the integrated core business system 100 in the system 500 of this example. The business data update process of this example is executed by the cooperation program included in the cooperation program DB 130. Further, in the business data update process, a process of transmitting predetermined data to a terminal managed by the cooperation server 10 or a delivery company or the like is executed with the reception of information that requires process flow data being received as a trigger. In this example, it is assumed that the process loops while the core business system 100 is operating.
業務データ更新処理では、先ず、統合基幹業務システム100がプロセスフローDB101の更新を要する情報を受信する(ステップS401)。ここで受け付けられるデータは、例えば、連携サーバ10から送信される商品の購入要求があったことを示す購入要求情報や、統合基幹業務システム100の管理者による直接入力により入力された新たなプロセスフローデータ(すなわち、図2に示すプロセスフローテーブルにおける1列)や、配送業者が管理する端末から送信される出荷実績に関するプロセスフローデータなどを含む。
In the business data update process, first, the integrated core business system 100 receives information that requires the process flow DB 101 to be updated (step S401). The data received here is, for example, purchase request information indicating that there is a purchase request for a product transmitted from the cooperation server 10, or a new process flow input by direct input by the administrator of the integrated core business system 100 Data (that is, one column in the process flow table shown in FIG. 2), process flow data related to shipment results transmitted from a terminal managed by the delivery company, and the like.
プロセスフローDB101の更新を要する情報が受信されると、統合基幹業務システム100は、入力されたデータに基づいてプロセスフローDB101を更新する(ステップS402)。具体的には、購入要求情報におけるプロセスフロー番号に基づいてプロセスフロー明細番号が割り当てられた新たなテーブルが追加され、基幹業務システムIDなどの購入要求情報に含まれる他の情報が当該新たなテーブルに格納される。
When the information requiring the update of the process flow DB 101 is received, the integrated core business system 100 updates the process flow DB 101 based on the input data (step S402). Specifically, a new table to which a process flow detail number is assigned based on the process flow number in the purchase request information is added, and other information included in the purchase request information such as the core business system ID is added to the new table. Stored in
プロセスフローDB101が更新されると、統合基幹業務システム100は、購入要求情報を受信したことに基づいてプロセスフローDB101が更新された否かを判定する(ステップS403)。
When the process flow DB 101 is updated, the integrated core business system 100 determines whether or not the process flow DB 101 has been updated based on the receipt of the purchase request information (step S403).
購入要求情報を受信したことに基づいてプロセスフローDB101が更新されたと判定されたとき(ステップS403のY)には、統合基幹業務システム100は、ステップS401で受信したデータがその他の処理を必要とする情報であるか否かを判定する(ステップS405)。
When it is determined that the process flow DB 101 has been updated based on the receipt of the purchase request information (Y in step S403), the integrated core business system 100 requires other processing for the data received in step S401. It is determined whether or not the information is to be processed (step S405).
一方で、プロセスフローDB101の更新が購入要求情報に基づくものではないと判定されたとき(ステップS403のN)には、統合基幹業務システム100は、プロセスフローDB101が更新されたことを示す情報を連携サーバ10に送信する(ステップS404)。すなわち、統合基幹業務システム100は、業務データ更新情報を連携サーバ10に送信する。
On the other hand, when it is determined that the update of the process flow DB 101 is not based on the purchase request information (N in step S403), the integrated core business system 100 displays information indicating that the process flow DB 101 has been updated. It transmits to the cooperation server 10 (step S404). That is, the integrated core business system 100 transmits the business data update information to the cooperation server 10.
プロセスフローデータ更新情報が連携サーバ10に送信されると、統合基幹業務システム100は、ステップS401で受信したデータがその他の処理を必要とする情報であるか否かを判定する(ステップS405)。
When the process flow data update information is transmitted to the linkage server 10, the integrated core business system 100 determines whether the data received in step S401 is information that requires other processing (step S405).
ステップS401で受信したデータがその他の処理を必要とする情報であると判定したとき(ステップS405のY)には、統合基幹業務システム100は、当該データの内容に応じた処理を実行する(ステップS406)。当該データの内容に応じた処理が実行されると、統合基幹業務システム100は、ステップS401に戻り、プロセスフローDBの更新を要するデータが入力されるまで待機する。
When it is determined that the data received in step S401 is information that requires other processing (Y in step S405), the integrated core business system 100 executes processing according to the contents of the data (step S405). S406). When the processing according to the content of the data is executed, the integrated core business system 100 returns to step S401 and waits until data requiring update of the process flow DB is input.
ここで、「その他の処理を必要とする情報」は、例えば、配送業者に対する出荷指示を必要とする情報や、所定の商品が出庫されたことを示す情報などである。例えば、配送業者に対する出荷指示を必要とする情報がステップS401で受信されている場合には、統合基幹業務システム100が、出荷元となる配送業者が管理する端末に対して出荷指示を送信する処理を実行する。また、例えば、所定の商品が出庫されたことを示すデータがステップS401で受信されている場合には、統合基幹業務システム100は、在庫情報における在庫数量から出庫数を減じて更新する。
Here, the “information that requires other processing” is, for example, information that requires a shipping instruction to a delivery company, information that indicates that a predetermined product has been issued, and the like. For example, if information that requires a shipping instruction for the delivery company is received in step S401, the integrated core business system 100 transmits the shipping instruction to a terminal managed by the delivery company that is the shipping source. Execute. For example, when data indicating that a predetermined product has been issued is received in step S401, the integrated core business system 100 updates the inventory quantity in the inventory information by subtracting the number of goods issued.
ここで、その他の処理として実行される「所定の商品が出庫されたことを示す情報がステップS401で受信されている場合の処理」について詳しく説明する。当該処理では、基幹業務システム100が、「共通データ部」を参照して「品目ID」および「数量」を特定する。その後、基幹業務システム100が、在庫情報記憶部を参照して特定した品目IDに対応する在庫情報を特定する。そして、基幹業務システム100は、在庫情報に格納されている「実在庫数量」および「受注中数量」から上記で特定した「数量」を減じて更新する。このようにして、所定の商品が出庫されたことを示す情報がステップS401で受信されている場合の処理が実行される。
Here, the “process in the case where information indicating that a predetermined product has been delivered has been received in step S401” executed as other processing will be described in detail. In the processing, the core business system 100 specifies “item ID” and “quantity” with reference to the “common data portion”. Thereafter, the core business system 100 identifies inventory information corresponding to the item ID identified with reference to the inventory information storage unit. Then, the core business system 100 updates the “quantity” specified above by subtracting it from the “real inventory quantity” and “quantity on order” stored in the inventory information. In this way, the process in the case where information indicating that the predetermined product has been issued is received in step S401 is executed.
一方で、ステップS401で入力されたデータがその他の処理を必要としないデータであると判定したとき(ステップS405のN)には、統合基幹業務システム100は、ステップS401に戻り、プロセスフローDBの更新を要するデータが入力されるまで待機する。
On the other hand, when it is determined that the data input in step S401 is data that does not require other processing (N in step S405), the integrated core business system 100 returns to step S401, and the process flow DB Wait until data that needs to be updated is entered.
以上に説明したように、上述した第1の実施の形態では、商品のデータを記憶する商品データ記憶部(商品データDB16)を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムとを連携する連携サーバが、業務上発生する業務データを記憶する業務データ記憶部(プロセスフローDB101)を備える基幹業務システム(統合基幹業務システム100)から送信された業務データに基づいて構成される連携用データを記憶する連携用データ記憶部(連携用DB15)を備え、基幹業務システムにより業務データが更新されたときに業務データの更新内容を示す業務データ更新内容情報を基幹業務システムから受信し、受信した業務データ更新内容情報に基づいて連携用データを更新し、連携用データを更新したときに、業務データの更新内容が反映されるように商品データを更新するための処理を実行するように構成される。このような構成によれば、基幹業務システムで管理されているデータを利用することにより構築が容易なECシステムを提供することができるようになる。また、基幹業務システム側での更新情報をリアルタイムにECシステム全体に反映させることができるため、ECサイトを閲覧するユーザは精度の高い情報を閲覧することができるようになる。さらに、基幹業務システム側において情報が更新された場合に、ECサイトで表示される情報を変更するための特別な操作を必要としないため、基幹業務システムで管理されている情報に基づいて構築されるECシステムにおいて、基幹業務システム側の管理者の負担を軽減することができるようになる。
As described above, in the first embodiment described above, an EC site that sells products on the Internet with reference to a product data storage unit (product data DB 16) that stores product data, and the EC site. The linkage server that links the core business system that sells products to the system is transmitted from the core business system (integrated core business system 100) that includes the business data storage unit (process flow DB 101) that stores business data generated in business. Business data update content that includes a data storage unit for collaboration (cooperation DB 15) that stores data for collaboration configured based on business data, and indicates business data update content when business data is updated by the core business system Receive information from the core business system, and link data based on the received business data update content information New, when updating linking data, configured to perform a processing for updating the product data as updated contents of the business data is reflected. According to such a configuration, an EC system that can be easily constructed can be provided by using data managed by the core business system. In addition, since the update information on the core business system side can be reflected in the entire EC system in real time, the user browsing the EC site can browse the information with high accuracy. In addition, when information is updated on the core business system side, no special operation is required to change the information displayed on the EC site, so it is built based on information managed by the core business system. In the EC system, the burden on the manager of the core business system side can be reduced.
また、上述した第1の実施の形態では、連携サーバが、ECサイトのユーザから商品の購入要求が受け付けられたときに、当該購入要求の内容に応じて連携用データを更新し、購入要求を受け付けたことを示す購入要求情報を基幹業務システムに送信するように構成される。このような構成によれば、ECサイトで生じた更新情報をリアルタイムにECシステム全体に反映させることができるため、ECサイトを閲覧するユーザは精度の高い情報を閲覧することができるようになる。
In the first embodiment described above, when the cooperation server receives a purchase request for a product from a user of the EC site, the cooperation server updates the data for cooperation according to the content of the purchase request, and issues a purchase request. Purchase request information indicating acceptance is transmitted to the core business system. According to such a configuration, since update information generated at the EC site can be reflected in the entire EC system in real time, a user browsing the EC site can browse information with high accuracy.
また、上述した第1の実施の形態では、基幹業務システムが、業務データDB(プロセスフローDB101)を備える。そして、業務データDBに格納される業務データ(プロセスフローデータ)は、少なくとも1以上のテーブルにより構成されるデータであり、同一構造のテーブルにより構成されるデータであり、プロセスフローを構成する各業務プロセスに関するデータ示すプロセスデータを当該テーブルにおいて同一のエントリにまとめたデータであるように構成される。このような構成によれば、業務データに含まれるテーブル数を最小限に抑えることができるようになるため、ECサイトを構築するために必要なデータの容量を軽減させることができるようになる。
In the first embodiment described above, the basic business system includes a business data DB (process flow DB 101). The business data (process flow data) stored in the business data DB is data composed of at least one table and is composed of tables having the same structure, and each business constituting the process flow. Process data indicating process data is configured to be data that is collected in the same entry in the table. According to such a configuration, the number of tables included in the business data can be minimized, so that it is possible to reduce the capacity of data necessary for constructing the EC site.
また、上述した第1の実施の形態で言及したように、基幹業務システムが、業務データDBを少なくとも2以上備え、さらに、少なくとも2以上の業務データDBそれぞれのレプリカデータを受信するレプリカデータ受信手段と、受信されたレプリカデータを統合したデータに基づいて、連携用データ記憶手段としての連携用DBを更新するように構成される。このような構成によれば、業務データを格納するDBが複数存在する場合でも、複数の業務データを1にまとめられたデータとして管理することで、データ管理のために使用するプログラム数が減ることとなる。したがって、必要データ容量を軽減させることができるとともに、異なる基幹業務システムが含まれるECシステムを構築する場合であっても柔軟に対応可能となる。
Further, as mentioned in the first embodiment, the basic business system includes at least two business data DBs, and further receives replica data of each of at least two business data DBs. And the cooperation DB as the cooperation data storage means is updated based on the data obtained by integrating the received replica data. According to such a configuration, even when there are a plurality of DBs that store business data, the number of programs used for data management is reduced by managing a plurality of business data as data combined into one. It becomes. Therefore, the required data capacity can be reduced, and even when an EC system including different core business systems is constructed, it can be flexibly handled.
また、上述した第1の実施の形態では、連携サーバが、受信された複数のレプリカデータをそのまま統合したデータを連携用データとするように連携用DBを更新するように構成される。このような構成によれば、基幹業務システムに格納される複数の業務データを取扱ってECシステムを構築する場合に、簡単な構成によりECシステムを構築することができるようになる。
In the first embodiment described above, the cooperation server is configured to update the cooperation DB so that data obtained by integrating the received plurality of replica data as it is is used as the cooperation data. According to such a configuration, when an EC system is constructed by handling a plurality of business data stored in the core business system, the EC system can be constructed with a simple configuration.
また、上述した第1の実施の形態で言及したように、連携サーバが、ECサイト上で表示される表示項目に対応するプロセスデータを少なくとも含むデータを連携用データとするように連携用DBを更新するように構成されていてもよい。このような構成によれば、テーブルを構成するデータを少なくすることができるようになるため、システム構築が容易でありながら、ECサイトを構築するために必要なデータの容量を軽減させることができるようになる。
Further, as mentioned in the first embodiment described above, the linkage DB is set so that the linkage server uses, as linkage data, data including at least process data corresponding to display items displayed on the EC site. It may be configured to update. According to such a configuration, since data constituting the table can be reduced, the capacity of data necessary for constructing an EC site can be reduced while system construction is easy. It becomes like this.
なお、上述した第1の実施の形態で言及したように、システムにおける基幹業務システムは、商品を一意に特定する品目IDと、自己の基幹業務システムを一意に特定する基幹業務システムIDと、在庫数量と、受注数とを含む在庫情報を記憶する在庫情報記憶部を備え、業務データ更新情報として出庫したことを示す情報を受信したときに、在庫情報を更新する構成とされていてもよい。具体的には、基幹業務システムは、上述した業務データ更新処理におけるステップS401にて受信したプロセスフローデータの更新を要する情報が商品が出庫されたことを示す情報であるか否かを判定し、出庫されたことを示す情報であると判定したときに、在庫情報における在庫数量を更新するように構成されていてもよい。このような構成によれば、受注したときの仮の在庫情報を示す仮在庫情報と、実際の在庫情報を示す実在庫情報とを分けて管理することができるようになるため、正確な情報を取り扱うことができるようになる。
As mentioned in the first embodiment, the basic business system in the system includes an item ID that uniquely identifies a product, a basic business system ID that uniquely identifies its core business system, and an inventory. An inventory information storage unit that stores inventory information including the quantity and the number of orders may be provided, and the inventory information may be updated when information indicating that the shipment has been received is received as business data update information. Specifically, the core business system determines whether the information that needs to be updated in the process flow data received in step S401 in the business data update process described above is information indicating that a product has been issued, It may be configured to update the stock quantity in the stock information when it is determined that the information indicates that it has been delivered. According to such a configuration, since temporary inventory information indicating temporary inventory information at the time of receiving an order and actual inventory information indicating actual inventory information can be managed separately, accurate information can be obtained. It becomes possible to handle.
なお、上述した第1の実施の形態では特に言及していないが、連携サーバ10が、所定のタイミングで基幹業務システムから実在庫情報を受信し、受信した実在庫情報と、商品データに含まれる仮在庫情報との数値が一致するか否かを判定し、数値が一致しないと判定された場合に、基幹業務システムに対してアラートを送信する構成とされていてもよい。なお、アラートが送信された基幹業務システムは、自己が備える表示装置にアラートの内容を表示する。このような構成によれば、在庫の不一致に基づくトラブルを未然に報知することができ、報知された基幹業務システム側では正確な情報とするための対応が可能となる。
Although not particularly mentioned in the first embodiment described above, the cooperation server 10 receives actual stock information from the core business system at a predetermined timing, and is included in the received actual stock information and product data. It may be configured to determine whether or not the numerical value matches the provisional inventory information, and to transmit an alert to the core business system when it is determined that the numerical value does not match. Note that the core business system to which the alert is transmitted displays the content of the alert on the display device that the alert is transmitted to. According to such a configuration, it is possible to notify in advance of troubles based on inconsistencies in inventory, and it is possible to take measures for obtaining accurate information on the notified main business system side.
以上、第1の実施の形態に係るECシステムについて説明した。次に、第2の実施の形態に係るECシステムについて説明する。
The EC system according to the first embodiment has been described above. Next, an EC system according to the second embodiment will be described.
[第2の実施の形態]
第1の実施の形態におけるECシステム500では、連携サーバ10は、ECサイトを管理するサーバとしての機能を兼ね備えるように構成されていた。第2の実施の形態におけるECシステム600では、連携サーバ10とは別のサーバが、ECサイトを管理するように構成される。具体的には、ECサイト管理サーバ30が、ECサイトを管理するサーバとして機能するように構成される。なお、以下では、上述した第1の実施の形態に係るシステム500で行った説明と同様の構成を有する場合に、同一の符号にて説明を行うことにより、その詳細な説明は省略される。 [Second Embodiment]
In the EC system 500 in the first embodiment, thelinkage server 10 is configured to have a function as a server for managing an EC site. In the EC system 600 according to the second embodiment, a server different from the cooperation server 10 is configured to manage the EC site. Specifically, the EC site management server 30 is configured to function as a server that manages the EC site. In addition, below, when it has the structure similar to the description performed with the system 500 which concerns on 1st Embodiment mentioned above, the detailed description is abbreviate | omitted by performing description by the same code | symbol.
第1の実施の形態におけるECシステム500では、連携サーバ10は、ECサイトを管理するサーバとしての機能を兼ね備えるように構成されていた。第2の実施の形態におけるECシステム600では、連携サーバ10とは別のサーバが、ECサイトを管理するように構成される。具体的には、ECサイト管理サーバ30が、ECサイトを管理するサーバとして機能するように構成される。なお、以下では、上述した第1の実施の形態に係るシステム500で行った説明と同様の構成を有する場合に、同一の符号にて説明を行うことにより、その詳細な説明は省略される。 [Second Embodiment]
In the EC system 500 in the first embodiment, the
図16は、本発明の第2の実施の形態に係るECシステム600の構成例を示すブロック図である。図16に示すように、ECシステム600は、連携サーバ610と、ECサイト管理サーバ30と、中継機20と、ユーザ端末41~4N(Nは任意の正の整数)と、統合基幹業務システム100と、統合基幹業務システム200と,統合基幹業務システム300とを含む。
FIG. 16 is a block diagram showing a configuration example of an EC system 600 according to the second embodiment of the present invention. As shown in FIG. 16, the EC system 600 includes a linkage server 610, an EC site management server 30, a relay device 20, user terminals 41 to 4N (N is an arbitrary positive integer), and an integrated core business system 100. And an integrated core business system 200 and an integrated core business system 300.
ECサイト管理サーバ30は、ユーザが使用するユーザ端末41~4Nからの要求に応じて通信ネットワーク56を介して各種データを提供するサーバである。ECサイト管理サーバ30は、例えばWWWサーバなどの情報処理装置によって構成され、ECサイトの管理者によって管理される。
The EC site management server 30 is a server that provides various data via the communication network 56 in response to requests from the user terminals 41 to 4N used by the user. The EC site management server 30 is configured by an information processing apparatus such as a WWW server, for example, and is managed by an administrator of the EC site.
図16に示すように、ECサイト管理サーバ30は、各種制御を行う制御部31と、商品データDB32と、取引データDB33と、ECサイト構成するための制御プログラムを格納するDBとを含む。すなわち、第2の実施の形態に係るECサイト管理サーバ30は、第1の実施の形態に係る連携サーバ10が備えていた商品DB16や、ECサイト管理処理部11dに相当する構成を含む。
As shown in FIG. 16, the EC site management server 30 includes a control unit 31 that performs various controls, a product data DB 32, a transaction data DB 33, and a DB that stores a control program for configuring an EC site. That is, the EC site management server 30 according to the second embodiment includes a configuration corresponding to the product DB 16 and the EC site management processing unit 11d included in the cooperation server 10 according to the first embodiment.
ECサイト管理サーバ30が備える制御部31は、ECサイトを管理するための各種処理を実行する。特に、第1の実施の形態で連携サーバ10が自己のサーバ内で実行していた各種処理のうち、ユーザ端末41~4Nからの要求を受け受ける処理や、各種データ(例えば、ECページや商品データ)を生成する処理や、各種データ(例えば、商品データ)を更新する処理や、ユーザ端末41~4Nに対して送信する処理や、連携サーバ10に対して各種データ(各種情報)を送信する処理などの処理が実行される。
The control unit 31 provided in the EC site management server 30 executes various processes for managing the EC site. In particular, among the various types of processing that the cooperation server 10 executes in its own server in the first embodiment, processing for receiving requests from the user terminals 41 to 4N and various types of data (for example, EC pages and products) Data), processing for updating various data (for example, product data), processing for transmitting to the user terminals 41 to 4N, and transmitting various data (various information) to the cooperation server 10. Processing such as processing is executed.
商品データDB32は、ECサイトを構成するための商品データを記憶する記憶媒体である。ここで、商品データは、少なくとも、在庫に関する情報を含む。また、特に図示しないが、本例では、商品データは、品目ID、基幹業務システムID、在庫数量と、ステータスとを含む。また、第2の実施の形態に係る商品データは、連携サーバ610から送信された連携用データに基づいてECサイト管理サーバ30により生成される。
The product data DB 32 is a storage medium that stores product data for configuring an EC site. Here, the product data includes at least information related to inventory. Although not particularly illustrated, in this example, the product data includes an item ID, a core business system ID, an inventory quantity, and a status. Further, the product data according to the second embodiment is generated by the EC site management server 30 based on the cooperation data transmitted from the cooperation server 610.
取引データDB33は、ECサイトを構成する取引データを記憶する記憶媒体である。
The transaction data DB 33 is a storage medium that stores transaction data constituting the EC site.
次に、本例のシステム600における連携サーバ610が実行するECサイト更新処理の例を説明する。
Next, an example of EC site update processing executed by the cooperation server 610 in the system 600 of this example will be described.
図17は、本例のシステム600における連携サーバ610が実行する第1更新処理の例を示すフローチャートである。第1更新処理では、各基幹業務システムから各種データが送信されるが、以下で説明する第1更新処理では、統合基幹業務システム100からデータが送信される場合を例にして説明する。なお、本例では、連携サーバ610が稼働している間においては、処理がループするものとする。
FIG. 17 is a flowchart showing an example of the first update process executed by the cooperation server 610 in the system 600 of this example. In the first update process, various data are transmitted from each core business system. In the first update process described below, a case where data is transmitted from the integrated core business system 100 will be described as an example. In this example, it is assumed that the process loops while the cooperation server 610 is operating.
第1更新処理において、先ず、連携サーバ610は、統合基幹業務システム100がプロセスフローDB101を更新したことを示す業務データ更新情報を統合基幹業務システム100から受信する(ステップS501)。
In the first update process, first, the cooperation server 610 receives business data update information indicating that the integrated core business system 100 has updated the process flow DB 101 from the integrated core business system 100 (step S501).
業務データ更新情報が受信されると、連携サーバ610は、受信した業務データ更新情報に基づいて連携用DB15を更新する(ステップS502)。
When the business data update information is received, the cooperation server 610 updates the cooperation DB 15 based on the received business data update information (step S502).
連携用DB15が更新されると、連携サーバ610は、当該更新内容に応じてECサイト管理サーバ30が管理するDB(例えば、商品データDBや取引データDBなど)を更新させるための情報をECサイト管理サーバ30に送信する(ステップS503)。ここで、「ECサイト管理サーバ30が管理するDBを更新させるための情報」とは、どのDBをどのように変更するのかを決定するための情報である。具体的には、連携用データに追加したテーブルに格納される情報(例えば、「ステータス」や「受注先」などの情報)に基づいて更新箇所が示された指示情報である。
When the cooperation DB 15 is updated, the cooperation server 610 updates the EC site with information for updating a DB (for example, a product data DB or a transaction data DB) managed by the EC site management server 30 in accordance with the update content. It transmits to the management server 30 (step S503). Here, “information for updating the DB managed by the EC site management server 30” is information for determining which DB is to be changed and how. Specifically, the instruction information indicates an update location based on information (for example, information such as “status” and “order received”) stored in a table added to the cooperation data.
ECサイト管理サーバ30にDBを更新させるための情報が送信されると、連携サーバ610は、ステップS501に移行し、業務データ更新情報を受信するまで待機する。なお、ECサイト管理サーバ30では、DBを更新させるための情報に基づいて商品データDB32の更新処理が実行される。
When the information for updating the DB is transmitted to the EC site management server 30, the cooperation server 610 proceeds to step S501 and waits until business data update information is received. The EC site management server 30 executes an update process for the product data DB 32 based on information for updating the DB.
次に、本例のシステム600における連携サーバ610が実行する第2更新処理の例を説明する。図18は、本例のシステム600における連携サーバ610が実行する第2更新処理の例を示すフローチャートである。第2更新処理では、ECサイト管理サーバ30から商品の購入要求が送信される場合を例にして説明する。
Next, an example of the second update process executed by the cooperation server 610 in the system 600 of this example will be described. FIG. 18 is a flowchart illustrating an example of the second update process executed by the cooperation server 610 in the system 600 of this example. In the second update process, a case where a purchase request for a product is transmitted from the EC site management server 30 will be described as an example.
第2更新処理において、先ず、連携サーバ610は、ECサイト管理サーバ30から購入要求情報を受信する(ステップS601)。なお、本例では、ECサイト管理サーバ30は、ユーザ端末41から商品の購入要求を受信したときに、購入要求情報に基づいて商品データDB32を更新するとともに、連携サーバ610に購入要求情報を送信する。
In the second update process, first, the cooperation server 610 receives purchase request information from the EC site management server 30 (step S601). In this example, when receiving a purchase request for a product from the user terminal 41, the EC site management server 30 updates the product data DB 32 based on the purchase request information and transmits the purchase request information to the cooperation server 610. To do.
購入要求情報が受信されると、連携サーバ610は、購入要求情報を取引データDB33に格納するとともに、購入要求情報の内容に応じて連携用DBを更新する(ステップS602)。
When the purchase request information is received, the linkage server 610 stores the purchase request information in the transaction data DB 33 and updates the linkage DB according to the content of the purchase request information (step S602).
連携用DBが更新されると、連携サーバ610は、購入要求情報に対応する基幹業務システムを特定する(ステップS603)。
When the cooperation DB is updated, the cooperation server 610 identifies the core business system corresponding to the purchase request information (step S603).
購入要求に対応する基幹業務システムが特定されると、連携サーバ610は、特定した基幹業務システムに対して、購入要求情報を送信する(ステップS604)。
When the core business system corresponding to the purchase request is identified, the cooperation server 610 transmits purchase request information to the identified core business system (step S604).
購入要求情報が送信されると、連携サーバ610は、ステップS601に移行し、購入要求情報を受信するまで待機する。
When the purchase request information is transmitted, the linkage server 610 moves to step S601 and waits until the purchase request information is received.
以上に説明したように、本例のECシステムは、商品のデータを記憶する商品データ記憶部(商品データDB32)を参照してインターネット上で商品を販売するECサイトを管理するECサイト管理サーバと、当該ECサイトに商品を出品する基幹業務システムと、ECサイト管理サーバと基幹業務システムとを連携する連携サーバで構成されるシステムとすることができる。
As described above, the EC system of this example includes an EC site management server that manages an EC site that sells products on the Internet with reference to a product data storage unit (product data DB 32) that stores product data. The system can be a system composed of a core business system for listing products on the EC site, and a linkage server that links the EC site management server and the core business system.
なお、連携サーバ10,610は、自己が備える記憶倍に記憶されている処理プログラムに従って、上述した各処理を実行する。
Note that the cooperation servers 10 and 610 execute the above-described processes according to the processing program stored in the storage times included in the cooperation server 10 or 610.
なお、上述した取引データDB(14,33)に格納される取引データは、それぞれ、商品データDB(15,32)に格納される商品データと一体的に構成されていてもよい。
In addition, the transaction data stored in the transaction data DB (14, 33) described above may be configured integrally with the product data stored in the product data DB (15, 32), respectively.
本発明によれば、基幹業務システムを利用したECシステムを構築するのに有用である。
According to the present invention, it is useful for constructing an EC system using a core business system.
10,610 連携サーバ
20 中継機
30 ECサイト管理サーバ
41~4N ユーザ端末
51~56 通信ネットワーク
100,200,300 統合基幹業務システム
110 基幹業務サーバ
120 DWHサーバ
500,600 ECシステム 10,610Cooperation server 20 Relay machine 30 EC site management server 41-4N User terminal 51-56 Communication network 100, 200, 300 Integrated mission-critical system 110 Mission-critical server 120 DWH server 500, 600 EC system
20 中継機
30 ECサイト管理サーバ
41~4N ユーザ端末
51~56 通信ネットワーク
100,200,300 統合基幹業務システム
110 基幹業務サーバ
120 DWHサーバ
500,600 ECシステム 10,610
Claims (10)
- 商品のデータを記憶する商品データ記憶手段を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムとを連携する連携サーバであって、
業務上発生する業務データを記憶する業務データ記憶手段を備える前記基幹業務システムから送信された前記業務データに基づいて構成される連携用データを記憶する連携用データ記憶手段と、
前記基幹業務システムにより前記業務データが更新されたときに前記業務データの更新内容を示す業務データ更新内容情報を前記基幹業務システムから受信する更新内容情報受信手段と、
受信された前記業務データ更新内容情報に基づいて前記連携用データを更新する第1連携用データ更新手段と、
前記連携用データが更新されたときに、前記業務データの更新内容が反映されるように前記商品データを更新するための処理を実行する商品データ更新処理手段とを含む
ことを特徴とする連携サーバ。 A linkage server that links an EC site that sells products on the Internet with reference to product data storage means for storing product data and a core business system that sells products on the EC site,
Coordination data storage means for storing cooperation data configured based on the business data transmitted from the core business system including business data storage means for storing business data generated in business,
Update content information receiving means for receiving, from the core business system, business data update content information indicating the update content of the business data when the business data is updated by the core business system;
First linkage data updating means for updating the linkage data based on the received business data update content information;
Product data update processing means for executing processing for updating the product data so that the update contents of the business data are reflected when the data for cooperation is updated. . - 前記ECサイトのユーザから商品の購入要求が受け付けられたときに、当該購入要求の内容に応じて前記連携用データを更新する第2連携用データ更新手段と、
当該購入要求を受け付けたことを示す購入要求情報を前記基幹業務システムに送信する購入要求情報送信手段とを含む
請求項1記載の連携サーバ。 Second cooperation data update means for updating the cooperation data according to the content of the purchase request when a purchase request for the product is received from a user of the EC site;
The cooperation server according to claim 1, further comprising purchase request information transmitting means for transmitting purchase request information indicating that the purchase request has been received to the core business system. - 前記基幹業務システムは、前記業務データ記憶手段としての業務データDBを備え、
前記業務データDBに格納される前記業務データは、
少なくとも1以上のテーブルにより構成されるデータであり、
同一構造のテーブルにより構成されるデータであり、
プロセスフローを構成する各業務プロセスに関するデータ示すプロセスデータを当該テーブルにおいて同一のエントリにまとめたデータである
請求項1または請求項2記載の連携サーバ。 The core business system includes a business data DB as the business data storage means,
The business data stored in the business data DB is:
Data composed of at least one table,
Data composed of tables of the same structure,
The linkage server according to claim 1 or 2, wherein process data indicating data related to each business process constituting the process flow is data collected in the same entry in the table. - 前記基幹業務システムは、前記業務データDBを少なくとも2以上備え、
さらに、
少なくとも2以上の前記業務データDBそれぞれのレプリカデータを受信するレプリカデータ受信手段と、
受信されたレプリカデータを統合したデータに基づいて、前記連携用データ記憶手段としての連携用DBを更新する第1連携用DB更新手段とを含む
請求項3記載の連携サーバ。 The core business system includes at least two business data DBs,
further,
Replica data receiving means for receiving replica data of each of at least two business data DBs;
The linkage server according to claim 3, further comprising first linkage DB update means for updating the linkage DB as the linkage data storage means based on data obtained by integrating the received replica data. - 前記第1連携用DB更新手段は、受信された複数の前記レプリカデータをそのまま統合したデータを連携用データとするように前記連携用DBを更新する
請求項4記載の連携サーバ。 The linkage server according to claim 4, wherein the first linkage DB update unit updates the linkage DB so that data obtained by integrating the plurality of received replica data as is is used as linkage data. - 前記ECサイト上で表示される表示項目に対応するプロセスデータを少なくとも含むデータを連携用データとするように前記連携用データ記憶手段としての連携用DBを更新する第2連携用データ更新手段を含む
請求項3記載の連携サーバ。 Second linkage data update means for updating a linkage DB as the linkage data storage means so that data including at least process data corresponding to display items displayed on the EC site is used as linkage data; The cooperation server according to claim 3. - 前記商品データ更新処理手段は、前記ECサイト管理するECサイト管理サーバに対して前記業務データ更新内容情報を送信することにより前記商品データを更新させ、
前記ECサイト管理サーバは、
前記商品データ記憶手段と、
前記商品データ記憶手段を参照し、前記ECサイトを構成するECページを生成するECページ生成手段とを有する
請求項1から請求項6のうち何れかに記載の連携サーバ。 The product data update processing means updates the product data by transmitting the business data update content information to an EC site management server that manages the EC site,
The EC site management server
The product data storage means;
The linkage server according to any one of claims 1 to 6, further comprising an EC page generation unit that references the product data storage unit and generates an EC page constituting the EC site. - 前記ECサイトを管理するサーバが前記連携サーバであり、
前記商品データ記憶手段を備えるサーバが前記連携サーバである
請求項1から請求項6のうち何れかに記載の連携サーバ。 The server that manages the EC site is the linkage server,
The server provided with the said merchandise data storage means is the said cooperation server. The cooperation server in any one of Claims 1-6. - 商品のデータを記憶する商品データ記憶手段を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムとを連携する連携サーバを制御するための連携プログラムであって、
業務上発生する業務データを記憶する業務データ記憶手段を備える前記基幹業務システムから送信された前記業務データに基づいて構成される連携用データを記憶する連携用データ記憶手段を備える前記連携サーバに、
前記基幹業務システムにより前記業務データが更新されたときに前記業務データの更新内容を示す業務データ更新内容情報を前記基幹業務システムから受信する更新内容情報受信処理と、
受信した前記業務データ更新内容情報に基づいて前記連携用データを更新する第1連携用DB更新処理と、
前記連携用データを更新したときに、前記業務データの更新内容が反映されるように前記商品データを更新するための処理を実行する商品データ更新処理とを
実行させるための連携プログラム。 A linked program for controlling a linked server that links an EC site that sells products on the Internet with reference to product data storage means for storing product data and a core business system that sells products on the EC site. There,
In the cooperation server provided with the cooperation data storage means for storing the cooperation data configured based on the work data transmitted from the core business system provided with the work data storage means for storing the work data generated in the work,
Update content information reception processing for receiving business data update content information indicating the update content of the business data when the business data is updated by the core business system;
A first linkage DB update process for updating the linkage data based on the received business data update content information;
A linkage program for executing a product data update process for executing a process for updating the product data so that the update contents of the business data are reflected when the linkage data is updated. - 商品のデータを記憶する商品データ記憶手段を参照してインターネット上で商品を販売するECサイトと、当該ECサイトに商品を出品する基幹業務システムと、前記ECサイトと前記基幹業務システムとを連携する連携サーバとを含むECシステムであって、
前記基幹業務システムは、
業務上発生する業務データを記憶する業務データ記憶手段を含み、
前記連携サーバは、
前記業務データ記憶手段を備える前記基幹業務システムから送信された前記業務データに基づいて構成される連携用データを記憶する連携用データ記憶手段と、
前記基幹業務システムにより前記業務データが更新されたときに前記業務データの更新内容を示す業務データ更新内容情報を前記基幹業務システムから受信する更新内容情報受信手段と、
受信された前記業務データ更新内容情報に基づいて前記連携用データを更新する第1連携用データ更新手段と、
前記連携用データが更新されたときに、前記業務データの更新内容が反映されるように前記商品データを更新するための処理を実行する商品データ更新処理手段とを含む
ことを特徴とするECシステム。 An EC site for selling products on the Internet with reference to product data storage means for storing product data, a core business system for selling products on the EC site, and the EC site and the core business system are linked An EC system including a linkage server,
The core business system is:
Business data storage means for storing business data generated in business,
The linkage server
Cooperation data storage means for storing cooperation data configured based on the business data transmitted from the core business system including the business data storage means;
Update content information receiving means for receiving, from the core business system, business data update content information indicating the update content of the business data when the business data is updated by the core business system;
First linkage data updating means for updating the linkage data based on the received business data update content information;
EC data system comprising: merchandise data update processing means for executing processing for updating the merchandise data so that the update contents of the business data are reflected when the linkage data is updated .
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/JP2014/003362 WO2015198362A1 (en) | 2014-06-23 | 2014-06-23 | Coordination server, coordination program, and electronic commerce system |
US14/423,786 US20160253730A1 (en) | 2014-06-23 | 2014-06-23 | Cooperation server, cooperation program, and ec system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/JP2014/003362 WO2015198362A1 (en) | 2014-06-23 | 2014-06-23 | Coordination server, coordination program, and electronic commerce system |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2015198362A1 true WO2015198362A1 (en) | 2015-12-30 |
Family
ID=54937503
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/JP2014/003362 WO2015198362A1 (en) | 2014-06-23 | 2014-06-23 | Coordination server, coordination program, and electronic commerce system |
Country Status (2)
Country | Link |
---|---|
US (1) | US20160253730A1 (en) |
WO (1) | WO2015198362A1 (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11695853B1 (en) | 2022-04-07 | 2023-07-04 | T-Mobile Usa, Inc. | Content management systems providing zero recovery point objective |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2001344323A (en) | 2000-06-02 | 2001-12-14 | Softbank E-Commerce Corp | Wholesale service service system of information technology-related goods, and method of service and storage medium thereof |
JP2002358349A (en) * | 2001-05-31 | 2002-12-13 | Toray Ind Inc | Generation and reservation system for salable volume |
JP2002366805A (en) * | 2001-06-08 | 2002-12-20 | Yokogawa Electric Corp | Electronic commerce system |
-
2014
- 2014-06-23 WO PCT/JP2014/003362 patent/WO2015198362A1/en active Application Filing
- 2014-06-23 US US14/423,786 patent/US20160253730A1/en not_active Abandoned
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2001344323A (en) | 2000-06-02 | 2001-12-14 | Softbank E-Commerce Corp | Wholesale service service system of information technology-related goods, and method of service and storage medium thereof |
JP2002358349A (en) * | 2001-05-31 | 2002-12-13 | Toray Ind Inc | Generation and reservation system for salable volume |
JP2002366805A (en) * | 2001-06-08 | 2002-12-20 | Yokogawa Electric Corp | Electronic commerce system |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11695853B1 (en) | 2022-04-07 | 2023-07-04 | T-Mobile Usa, Inc. | Content management systems providing zero recovery point objective |
Also Published As
Publication number | Publication date |
---|---|
US20160253730A1 (en) | 2016-09-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP5386639B2 (en) | Database, data management server, and data management program | |
JP5738779B2 (en) | Supply capability estimation system, method, and program | |
US20120310792A1 (en) | Product common object | |
JP6424311B2 (en) | Supply chain management apparatus and method, system and program therefor | |
JP5418084B2 (en) | Distribution integration support system, ordering support apparatus, inventory management support apparatus, shipping operation support apparatus, ordering support apparatus control program, and logistics integration support method | |
KR102345145B1 (en) | Production and logistics ERP automation system by linking and using customer information | |
US20210241357A1 (en) | Customizable and extensible managed integration platform | |
JP2012238301A (en) | Commodity ordering support system | |
WO2015198365A1 (en) | Coordination server, coordination program, and electronic commerce system | |
WO2015198364A1 (en) | Coordination server, coordination program, and electronic commerce system | |
WO2013114438A1 (en) | Mobile terminal management server, and mobile terminal management program | |
WO2015198362A1 (en) | Coordination server, coordination program, and electronic commerce system | |
US20150120355A1 (en) | Mobile terminal management server and mobile terminal management program | |
EP3007118A1 (en) | Cooperation server, non-transitory computer-readable storage medium storing cooperation program, and EC system | |
JP5451885B2 (en) | Database, data management server, and data management program | |
US20160148129A1 (en) | Report data management device, non-transitory computer-readable storage medium storing report data management program, and report data management method | |
WO2015198363A1 (en) | Coordination server, coordination program, and electronic commerce system | |
JP7491627B2 (en) | Information processing system, information processing method, and program | |
JP2017224214A (en) | Multistep sales processing system and wholesaler proxy system | |
JP2003044659A (en) | Enterprise basic operations system and construction method thereof | |
JP2004164324A (en) | Processing system and processing method for order-received commodity | |
KR101603501B1 (en) | System for integrated management in the print | |
JPWO2013114438A1 (en) | Mobile terminal management server and mobile terminal management program | |
JPWO2013114439A1 (en) | Mobile terminal management server and mobile terminal management program | |
JP2002215978A (en) | Delivery determination processing method, system and program |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
WWE | Wipo information: entry into national phase |
Ref document number: 14423786 Country of ref document: US |
|
REEP | Request for entry into the european phase |
Ref document number: 2014837092 Country of ref document: EP |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 14837092 Country of ref document: EP Kind code of ref document: A1 |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
NENP | Non-entry into the national phase |
Ref country code: JP |