2017 double 11 big promotion just past, Suning Tesco trading system's request volume and order volume on the 11th of the day showed an exponential growth, but also achieved the fastest break of 100 million billions of records, Suning Tesco trading system in Smooth operation during the big promotion period, perfect for the double 11. As the person in charge of the Suning Tesco Trading System, I will introduce you to one of the core systems of trading, the evolution and practice of the inventory system architecture, and how the inventory system prepares and responds to the traffic peaks of the Double 11. This article recommends architects, technical managers, development engineers, technical directors and other groups to read, hoping to benefit everyone.
Inventory business introduction and challenges faced inventory system positioning and core business scenario analysisFirstly, it introduces the positioning of the inventory system. It mainly acquires applications for enterprise-level operational available commodity inventory, and is closely related to the platform catalogue. It is positioned as one of Suning's core platforms. Platform-level commodity inventory supports on-line, offline sales channels and marketing activities to query the inventory of operationally available commodities, support platform inventory lock, unlock, increase, reduce and other inventory core services, and provide service support for platform merchants.
As one of the core systems of e-commerce transactions, inventory runs through Suning's entire business value chain, whether it is from the procurement line of procurement, delivery, transfer, exit, warehousing posting, physical inventory, etc., or the browsing of the sales line. Single, delivery, outbound postings, and other big data applications such as customer support, business analysis reports, forecast replenishment, and multi-platform sales support are all closely related to the inventory system.
Inventory is divided into self-operated inventory and C-store inventory from the business model. The self-operated inventory is the stock of Suning self-selling, and the C store inventory is the inventory sold by the platform merchants that have entered through the open platform.
The inventory center focuses on sales inventories, which support all inventory services related to Suning sales and transactions. Suning’s physical inventory is managed on Suning’s logistics platform. The positioning of the two sets of stocks is different, but there is a certain relationship between the two sets of stocks, and through the regular and strict inventory reconciliation mechanism to ensure the consistency of the two sets of inventory data. Figure 1.
Figure 1 system context map inventory business architecture
The inventory system is divided into four parts: inventory trading, inventory management, abnormal management, and operation and maintenance management.
The stock transaction part is divided into sales lock, sales unlock, delivery lock, delivery unlock, quantity inquiry, inventory status inquiry, status release, quantity release, activity pre-lock, activity pre-unlock, activity inventory inquiry, activity management and other functions. Module. The inventory management part is divided into functional modules such as purchasing, transfer, returning, moving, inventory, reconciliation, status calculation, sales posting, inventory synchronization, and multi-platform distribution. The inventory status refers to a status indicator that defines the stock in stock and is out of stock. By implementing the inventory status, the call of the peripheral system to the inventory quantity query interface can be greatly reduced. For example, the product details page only pays attention to whether the goods are in stock or not, and the inventory status is Can be supported. The business architecture is shown in Figure 2.
Figure 2 Business architecture diagram inventory challenges
The inventory system faces several challenges:
Hot spot
For the same commodity, such as spikes, group purchases, discount promotions and other active goods, how to support high concurrent inventory deduction services.
Turnover
How to improve inventory turnover, maximize the use of corporate funds, and maximize sales.
Avoid oversold
Avoiding oversold is the bottom line principle of inventory system architecture design and system implementation.
System scalability
How to build an inventory structure that can be expanded indefinitely. In the process of system expansion, each deployment node needs to have unlimited expansion capabilities, and common bottlenecks such as the number of connections in the database and the number of connections in the queue.
Architectural evolution of the inventory system
The evolution of the architecture of Suning's inventory system is mainly divided into four phases:
Phase 1: 2005-2012, the offline chain era, the initial structure of e-commerce, the system was composed of WCS/POS+SAP, and the inventory belonged to a business module in the SAP system;
Phase 2: 2012-2013, the Internet O2O e-commerce era, when the system was separated from the front office, the middle office, and the back office architecture, and the SAP inventory system was independent;
Phase 3: 2013-2016, multi-platform sales strategy era, Suning settled in Tmall, at that time the system adopted the "go to commercial software, advocating open source" ideas, the new JAVA self-developed inventory system;
Phase 4: 2016-present, the inventory system is more active, the inventory system is deployed in the extension room, and the multi-machine room deployment is realized based on the big data inventory distribution engine.
As shown in Figure 3. The details of each stage inventory structure are expanded in the following sections.
Figure 3 Architecture evolution diagram E-commerce initial architecture
E-commerce early stage - overall architecture
KENNEDE ELECTRONICS MFG CO.,LTD. , https://www.axavape.com