As corporate IT and Internet systems develop, they produce increasingly more data. The accumulated data volume enables data applications to become independent of business systems, which is a qualitative leap. A growing number of industries such as logistics, transportation, and new retail use online analytical processing (OLAP) to refine their business operations. They can use OLAP to adjust production guidelines, operation efficiency, and enterprise decisions accordingly.
Typically, business systems use MySQL or PostgreSQL for online transaction processing (OLTP). These relational databases are good at performing transactional processing and support frequent INSERT and UPDATE operations. OLTP systems are inadequate to compute large amounts of data. For example, you need to compute tens of millions of data records or complex computing is required. In this case, you need to use OLAP systems.
AnalyticDB for MySQL is a cloud-based warehouse that can process petabytes of highly concurrent data in real time. It is an OLAP database service. AnalyticDB for MySQL uses relational models to store data and provides SQL statements to compute and analyze data flexibly. No prior data modeling is required. Based on the seamless scaling capability of the cloud, AnalyticDB for MySQL can compute tens of billions of or more data records within milliseconds.
AnalyticDB for MySQL is a SQL-based relational data warehouse. You can manage databases, scale in or out nodes, and flexibly change specifications. It provides various visualization and ETL tools to simplify data processing for enterprises.
AnalyticDB for MySQL is designed to refine business operations, gain an insight into data value in real time, and continuously promote the data-driven transformation of enterprises.
AnalyticDB for MySQL is a PB-level data warehouse hosted in the cloud for massively parallel processing (MPP). Compared with other data warehouses or OLAP solutions in the industry, AnalyticDB for MySQL provides the following benefits as a SQL data warehouse:
- Fast engine
AnalyticDB for MySQL uses the new generation of an ultra-large-scale engine that integrates MPP with directed acyclic graphs (DAGs). Using hybrid row-column storage, automatic indexing, and an intelligent query optimizer, AnalyticDB for MySQL can instantly analyze hundreds of billions of data records from multiple dimensions to quickly find the value of data. If you use complex SQL statements to query data, AnalyticDB for MySQL responds ten times faster than traditional relational databases. In addition, AnalyticDB for MySQL allows you to quickly scale out a cluster to thousands of nodes to further improve the query response speed.
AnalyticDB for MySQL provides an extremely flexible architecture that separates storage resources from computing resources. You can adjust the number of nodes at any time and dynamically change specifications. AnalyticDB for MySQL also enables you to switch between SATA nodes that have a large storage capacity and SSD nodes that deliver high performance. For example, you can increase the number of node groups from 8 C4 node groups to 12 C8 node groups, or decrease the number of node groups from 12 C8 node groups to 8 C4 node groups. This way, enterprises can flexibly control costs.
- Ease of use
As a PB-level SQL data warehouse hosted in the cloud, AnalyticDB for MySQL is fully compatible with MySQL protocols and the SQL:2003 syntax. You can use standard SQL statements, common business intelligence (BI) tools, and ETL tools to access AnalyticDB for MySQL. AnalyticDB for MySQL is designed to simplify real-time data-based operations for enterprises.
- Ultra-large scale
AnalyticDB for MySQL features a fully distributed architecture without standalone design. This allows a database instance to dynamically and linearly scale out the nodes to thousands of nodes. After the scale-out, AnalyticDB for MySQL can significantly speed up the response to SQL queries and process more concurrent SQL queries.
- Highly concurrent write capability
AnalyticDB for MySQL supports quick data write and update in real time, high concurrency queries, interactive analytics, and ETL integration. AnalyticDB for MySQL supports real-time data write on an ultra-large scale in compliance with the Raft consensus protocol. For scenarios that require high concurrency and throughput, you can scale out clusters. For example, the disk space can be increased from GB level to hundreds of PB level. Clusters can be scaled to process tens of millions transactions per second.
- High data compression rate
AnalyticDB for MySQL uses the Full MPP Mode (MPP) technology with hybrid row-column storage and is able to select compression algorithms for different data types. AnalyticDB for MySQL can select the optimal algorithm for different columns or blocks in the same column. The compression algorithms use a combination of encoding algorithms and general data compression. AnalyticDB for MySQL provides more than 10 encoding and compression algorithms at a compression ratio of up to 1:10.