How to help users manage cloud ledgers? Alibaba Cloud database helps collect money!

Introduction to money and get 1 million in the account" has become the most desired voice for ordinary businesses.

How long have you not touched cash?

Data from the 47th "Statistical Report on China's Internet Development Status" released by the China Internet Network Information Center shows that as of December 2020, the number of mobile payment users in my country has reached 854 million; data released by the People's Bank of China shows that by the end of 2020 , my country’s mobile payment services amounted to 123.220 billion, with an amount of 432.16 trillion yuan.

These data are closely related to each of us. Breakfast on the way to work, parking fees in the community, a movie on a holiday, a supper at a late night food stall...Mobile payment has long become an important social infrastructure and constitutes the streets and lanes. There is fireworks in the world, you must have heard the sound of the machine 160ec0ba1535af "Come to the account X yuan" .

Shouqianba was established in 2013 and is the pioneer of the aggregate payment industry. It has now penetrated millions of offline merchants and empowered hundreds of millions of people.

With the gradual maturity of mobile payment, Collect Money has accumulated a large amount of store transaction data. Receiving Money uses these data efficiently and launches mobile payment collection, marketing management software, advertising, supply chain, shared power bank, merchant community and other services for merchants. Today, Shouqian Bar has evolved from an early aggregation payment service provider to a comprehensive service provider for digital stores, enabling millions of small and medium-sized businesses to achieve the most basic digital transformation.

Faced with a data volume of hundreds of billions and an increase in data of more than 32 million transactions per day, how to realize mass storage and bill query? Let's walk into collecting money together and explore the story behind it.

The following is the fourth issue of "Super Visit"-"Alibaba Cloud Database Help Collect Money. How to help hundreds of millions of users manage their books? Excerpts from the dialogue.

1. hundreds of millions of users manage the books

Zhang Yijia: currently serve and what is the scale of users?

CTO/Senior Vice President Chang Jianlong: Service Network has covered 660 cities in China, serving 4 million offline brick-and-mortar businesses, serving an average of 32 million people per day, and serving a total of 20 billion people, from individuals Consumers go to mom-and-pop stores to international chain brands, and they can all see the cashier bar.

Zhang Yijia: store and manage the massive bills generated?

*Mao Yu- : *There are two keys to this. First, a data center that centrally stores and manages payment bills is needed.

Secondly, the collection bar covers different types of customers, and we need to find ways to meet the differentiated needs of different users.

Therefore, Shouqianba independently developed a hierarchical account system, which can make detailed statistics on the collection data of each brand, each branch, and each cashier, clearly record each account, and customize the statement according to financial requirements to solve the pain points of customers’ concerns. .

Zhang Yijia: payment is a very sensitive business, merchants and consumers are very concerned about their books. How does Receiving Money guarantee the safety of users' property and solve the worries of users?

*Mao Yu-Development Director of : *For property security, Cashier emphasizes management and control. The boss can master the details without going to the store-remote account management, store management, and person management. Receiving Money App provides daily bills, monthly bills and all collection records for easy reconciliation. The APP can check all transaction information anytime and anywhere, which is convenient for cashiers and bosses.

Zhang Yijia: is the biggest challenge 160ec0ba153786 encountered when developing this system?

*Mao Yu-Development Director : *There are three main challenges. The first is storage reliability, the second is storage cost, and the third is real-time query of multi-dimensional combinations under massive data.

Storage reliability is undoubtedly very important. Imagine if the bill is lost, customer bills, bank bills, merchant bills, etc. cannot be checked and inquired at all. This is unacceptable.

Regarding storage costs, we have stored hundreds of billions of data, and 32 million new data are added every day. This data increase is very large, and the challenge to storage costs is also very large.

In addition, different customers have different dimensions of data query requirements. The B-side query volume is relatively small, but the query dimensions are complex; the C-side user query volume is relatively large, but the business logic is relatively simple.

For chain merchants, it is necessary to support random combination queries of multiple dimensions such as brand, store, cashier, and time; for consumers, it is necessary to support bill query based on time range. Through the summary, the cashier bar needs to support random combination queries of 30+ dimensions in order to meet the current query needs of various types of users.

Zhang Yijia: How to solve these problems?

*Mao Yu-Development Director of Bar 160ec0ba1538c7: After extensive research, analysis and testing and verification, and comparing different technologies and products, we finally chose to use Cloud's cloud native multi-mode database Lindorm * as storage The center builds a complete billing system, and the system has been online for more than a year.

There are three main considerations for choosing Lindorm: Lindorm is based on multi-copy technology, providing 99.99999999% of data reliability, a total of 10 9s;

Lindorm has a maximum compression ratio of 10:1, combined with the ability to separate hot and cold, to convert historical bills from 6 months ago into cold data for storage, reducing comprehensive storage costs by 2/3;

Lindorm provides an integrated bill retrieval solution, which can automatically create a suitable index for bill data, and supports real-time query of random combinations of more than 30 dimensions.

Zhang Yijia: The historical bills from 6 months ago are highly compressed, can they still be retrieved?

*Mao Yu- : *Yes. With the guarantee of Alibaba Cloud Lindorm, mass storage and real-time query are no longer a contradiction.

2. Mass data to assist decision-making for resumption of work

Zhang Yijia: Due to the epidemic in 2020, offline stores have more or less encountered operating difficulties. As an enterprise that serves offline merchants, what kind of help does it provide to merchants?

Bar Development Director: Bar is committed to helping offline merchants operate their businesses with the power of network and data. Based on the original traffic generated after payment, it launched the "National Offline Business Consumption Index Tracking Data", It can reflect the activity of offline commercial production in real time.

On the one hand, this data is provided to the government to assist the government in formulating policies to support the resumption of work and production of small, medium and micro enterprises; on the other hand, it is open to our business users to help businesses effectively formulate reasonable resumption plans.

Zhang Yijia: calculated and how to ensure the accuracy and real-time performance of the data?

Bar Development Director: Bar's business covers all industries of offline consumption. Based on the massive consumption data stored in Lindorm, we calculate the business consumption index in real time according to certain economic measurement models.

Zhang Yijia: Lindorm still plays an important role in this system?

Bar Development Director: Yes, the storage and calculation of the entire system are built around Lindorm. All our data is stored on Lindorm. Based on the integrated storage and computing solution it provides, it can easily connect to the computing ecosystem, help us quickly build a set of data processing architecture, and support application services to go online.

Lindorm also provides wide table storage with kv structure, compatible with HDFS file storage, SQL query and data retrieval functions. Our source data and dimension tables are stored on Lindorm, and the calculated result table is also written back to Lindorm and provided to the upper layer. Use for business queries. Effectively avoid data migration and simplify the system architecture.

Based on the scheme built by Lindorm, the development and launch time has been reduced by half than expected.

3. you want to get rich in the digital age, do a good job in the database

Zhang Yijia: Cloud released Lindorm in 2020. What are its characteristics?

Cloud Intelligence Senior Technical Expert/Lindorm R&D Leader Shen Chunhui: Lindorm is the first self-developed NoSQL product released by Alibaba Cloud. It is based on a cloud-native architecture with separation of storage and computing and multi-mode sharing and integration, supporting the low cost of massive data Storage and processing, support rich data retrieval capabilities, support one-click docking of computing ecology, perform interactive, batch processing, stream processing and other computing processing, help users quickly build a set of data processing architecture, which is in rigid demand in Internet and Internet of Things scenarios .

At the same time, although Lindorm is self-developed, it firmly embraces the open source ecosystem. The data access interface supports open source standards such as SQL, HDFS, HBase, CQL, and OpenTSDB. It is simple and easy to use without additional learning costs.

Zhang Yijia: self-developed database is based on the needs of its own e-commerce business. From its own business to to B services, how does Alibaba Cloud maintain a keen insight into the needs?

Cloud Intelligence Senior Technical Expert/Lindorm R&D Leader Shen Chunhui: from users and goes to users. This is the unchanging logic of the continuous iteration of the product. In the to B service process, in addition to stability and cost requirements, it is difficult for us to hear customers directly tell you what they want. This is a big challenge. However, a large number of requirements exist for the direct connection of the database to the business.

To this end, we mainly rely on two methods: one is on-site visits. The database department has an expert service team that regularly visits customers for business and technical exchanges, keeps abreast of product usage and demands, and discusses efficiency optimization solutions for remote communication and collaboration;

The other is trend prediction, including industry trends and technological trends. For example, Lindorm has pre-invested a lot of technology research and development in the direction of the Internet of Things. The goal is to increase the processing efficiency of the time series data and location data of the terminal equipment by orders of magnitude. There is a certain degree of predictability in advance, and it will make timely adjustments along with industry development and application feedback.

Copyright Notice: content of this article is contributed spontaneously by Alibaba Cloud real-name registered users. The copyright belongs to the original author. The Alibaba Cloud Developer Community does not own its copyright and does not assume corresponding legal responsibilities. For specific rules, please refer to the "Alibaba Cloud Developer Community User Service Agreement" and the "Alibaba Cloud Developer Community Intellectual Property Protection Guidelines". If you find suspected plagiarism in this community, fill in the infringement complaint form to report it. Once verified, the community will immediately delete the suspected infringing content.