This topic describes how JUSHUITAN uses AnalyticDB for PostgreSQL to build enterprise-class cloud-native data warehouses to resolve issues such as excessive business requirements and resource scaling difficulties.
Customer introduction
Shanghai JUSHUITAN Network Technology Co., Ltd. was established in 2014. The company is engaged in the development of software as a service (SaaS) enterprise resource planning (ERP) applications and has completely independent intellectual property rights. Based on open, global, cost-effective, and highly efficient Internet services, the company provides a lightweight, professional e-commerce cloud ERP platform and all-round information technology solutions for small and medium-sized enterprises.
Challenges
Traffic peaks during promotions
As the number of orders significantly increases, traffic peaks may occur during major e-commerce promotions such as Double 11 and the 618 Shopping Festival. In this case, JUSHUITAN wants to upgrade instance specifications in a fast and flexible manner before promotions to handle higher workloads.
High requirements for data analysis
JUSHUITAN SaaS ERP platform intends to provide capabilities such as high-concurrency transactions, real-time multi-dimensional data analysis, and in-depth data processing. In this case, JUSHUITAN requires an architecture that can provide the preceding capabilities.
Elastic resource scaling
As business increases, JUSHUITAN requires a data architecture that provides horizontal scaling capabilities.
Solution
JUSHUITAN provides a SaaS ERP platform that integrates various e-commerce services. During major e-commerce promotions such as Double 11, Double 12, and the 618 Shopping Festival, JUSHUITAN SaaS ERP platform provides various features and rapid response to traffic peaks. During Double 11 in 2019, the platform handled more than 250 million orders every day in an efficient and smooth manner.
JUSHUITAN SaaS ERP platform integrates online e-commerce merchants with physical stores to improve the order forwarding process and commodity attributes. The platform uses algorithms to extract consumer behavior patterns and preferences. This helps merchants and customers communicate in an efficient manner.
JUSHUITAN SaaS ERP platform provides e-commerce users with online report analysis and a series of reporting, analysis, and calculation tools based on financial and business data. The real-time data analysis capability enables multi-dimensional data exploration. This helps users extract data value, obtain insights into business status, and rapidly respond to business changes.
Outcome
JUSHUITAN uses AnalyticDB for PostgreSQL to build enterprise-class cloud-native data warehouses that provide the following benefits:
Highly efficient response to large amounts of data
AnalyticDB for PostgreSQL uses the batch processing and multi-dimensional analysis capabilities to support extract-transform-load (ETL), customer relationship management (CRM), and online report analysis. This provides a powerful analysis support for order management, warehouse management, distribution management, and collaborative supply chain, and a series of reporting, analysis, and calculation tools based on financial and business data. AnalyticDB for PostgreSQL handles up to 200 terabytes of data and runs more than 3.54 million jobs every day, achieving 10 times higher online report query performance than traditional platforms. This way, JUSHUITAN SaaS ERP platform displays reports in real time and helps e-commerce users respond to business changes in a fast manner.
Integrated batch processing with real-time analysis
AnalyticDB for PostgreSQL integrates batch processing with real-time analysis to improve order processing and provide more business categories. This significantly improves the business processing capability of JUSHUITAN SaaS ERP platform and user experience. This way, the platform can handle more volumes of data.