Get critical business insights from data sourced from multiple locations, instantly processed in a highly concurrent and multi-dimensional analysis system with Alibaba Cloud AnalyticDB. AnalyticDB is a real-time Online Analytical Processing (OLAP) managed database cloud service that can crunch enormous amounts of data. As a fast and flexible database service, AnalyticDB is compatible with MySQL protocol, including metadata information.
The AnalyticDB service easily integrates into your business ecosystem to equip you with the power to discover new trends and enable business transformation based on data analysis.
“AnalyticDB helps us solve the difficulties of storing massive data and performing quick and precise queries. It gives us the capability to provide customers with complex analysis and responsive services.”
Processes massive amounts of data and delivers high performance through SQL multi-dimensional analysis and data filtering.
Performs flexible computing analysis with built-in data modeling.
Fast Response Time
Allows quick real-time analysis of massive amounts of data.
Provides exceptional processing performance by supporting large table calculations.
Supports standard SQL database queries such as DDL, DML and DCL.
Compatible with MySQL standard protocol including JDBC and ODBC.
Built-in support for rapid data access from multiple data storage sources.
Automatic indexing without requiring schema or secondary indexes.
Quickly exports massive amounts of data at high speed.
Built-in functions such as spatial computing and segmentation.
Here is a comparison of AnalyticDB with other traditional OLAP engines:
|Parameter||AnalyticDB||Traditional OLAP Engines|
|Data usage||Supports business-driven in-depth data exploration and interactive data analysis.||Most engines primarily support data-driven computing modes for fixed report-type presentations.|
|Data scale||The high-performance computing engine supports computing and analysis of massive data.||The low-performance computing engine is able to support only a portion of the data for computation.|
|Engine capabilities||Powered by distributed computing technology. Results can be computed quickly allowing free data exploration. Usually, no advance modeling is required.||In most situations either query speeds are slow, or you must establish a cube or other models in advance and analyze the data based on this model.|
|Cost||Under the Pay-As-You-Go model, you are only charged for the resources you actually use.||Works on one-time payment or license purchase models.|
1. Ready for use right after you apply.
2. Provides multi-tenant flexibility.
3. Database provisioning with a few clicks instantly.
|Traditional software delivery methods with long purchase cycle and delayed provisioning.|
With its advanced analytics, built-in security and optimized query processing, AnalyticDB enables you to achieve complex business objectives. The fast query response time of AnalyticDB allows you to compute data in billions of milliseconds. AnalyticDB is more scalable than standard databases—ideal for deploying business analytics, big data cloud solutions for projects, reporting and advanced analytics.
As a Pay-As-You-Go solution, you can easily integrate AnalyticDB with your application to quickly analyse large amounts of data without making any huge upfront investment.
High Power Computing Capabilities
Compatible with SQL to provide multi-dimensional analysis, data pivot, and data filtering.
Supports data definition, operations and control by standard SQL. For example: DDL, DML, and DCL.
Supports functions such as JOIN, HAVING, DISTINCT, etc.
Performs combined queries for any fields.
Supports conventional aggregation functions, as well as personalized segmentation, sampling, and other statistical functions.
Supports fast dump to transfer massive volumes of data to another system in the cloud.
Offers high dump speed of over 1 million lines per second.
Pivots billions of data bytes in multiple dimensions.
Supports contextual computing for multiple large tables within milliseconds.
Creates most suitable index format for each data column using fully automated functions.
The computing engine intelligently optimizes user queries to enhance performance and reduce cost.
Provides high availability and redundancy with multi copy data storage options, and dynamic resource management mechanisms.
Implements permission management mechanism to ensure data security.
Utilizes public/private key mechanism to enhance data security.
Compatible with MySQL
Fully compatible with MySQL protocol (including data element information).
Provides inherent compatibility with commercial analysis tools and applications.
Offers built-in support for fast access to data source for various types of data.
Reduces cost to access service systems and business software.
Offers easy-to-use graphical management console, comprehensive documentation, manuals and quick start guides.
Flexible billing methods where you only pay for the resources used.
You can use the geographic LBI function to circle geographic coordinate data without depending on spatial indexes.
Offers built-in dynamic segmentation, rapid aggregation and other functions to facilitate the development of OLAP server based applications.
AnalyticDB is a real-time online analytical processing service (OLAP) that enables you to process and analyze several hundred billion bytes of data from different dimensions within milliseconds. Below we describe a few common use case scenarios.
Traditional Enterprise Business Intelligence (BI) Engines
This is suitable for enterprises which require business intelligence solutions for data which is in the cloud. You can migrate massive volumes of data to AnalyticDB, a cloud based data analytics service to analyze your business operations.
Recommended Configuration: AnalyticDB + Object Storage Service + Data Integration
Provides super-fast Relational Online Analytical Processing (ROLAP) solutions
Compatible with traditional BI report tools
Reduces extra costs for enterprise migration and procurement
Big Data Driven Service Systems
This is suitable for frontend service systems in which big data queries can be directly embedded to get insightful data for business processes. You can use this with Alibaba Cloud MaxCompute (Big Data processing engine) for offline computing or MaxCompute streaming for stream computing.
Recommended Configuration: AnalyticDB + MaxCompute
You can process data to get business-critical insights.
Provides a range of analysis functions which can be called by the service system.
For Centralized, Low-latency Business Intelligence Model
Supports enterprises systems such as Business Intelligence systems (BI), Customer Relationship Management (CRM) systems, Data Management Platforms (DMP), data report products and other SaaS projects.
Recommended Configuration: AnalyticDB + ODPS
Supports stable product operation.
Delivers excellent user experience even as data continues to grow.
With its advanced analytics and data mining solutions, built-in security and optimized query processing, AnalyticDB enables you to achieve complex business objectives. The fast query response time of AnalyticDB allows you to calculate data in billions of milliseconds. AnalyticDB is more scalable than standard databases—ideal for deploying business analytics, big data cloud solutions for projects, reporting and advanced analytics.
You can access AnalyticDB, a cloud based data analytics service via Alibaba Cloud Management Console, CLI, APIs and SDKs to provision and manage your databases.
Using Alibaba Cloud AnalyticDB through Management Console
The Alibaba Cloud Management Console provides a simple web-based user interface to access and configure the AnalyticDB resources. You can create and modify database instances, change the capacity of the resources and take various backups. The Quick Start Guide provides a step-by-step direction on how to get started with a few clicks.
Using Alibaba Cloud AnalyticDB via CLI
AnalyticDB CLI gives you the flexibility to use AnalyticDB resources and manage them programmatically through a command line interface. You can download and install the AnalyticDB CLI package to enable the service.
Alibaba Cloud AnalyticDB is a real-time Online Analytical Processing (OLAP) managed database service in the cloud which can crunch enormous amounts of data. AnalyticDB is more scalable than standard databases—ideal for deploying business analytics, big data projects and data mining solutions, reporting and advanced analytics.
Leverage the benefits of AnalyticDB using Alibaba Cloud Management Console and documentation. Below are the links to the documentation, SDKs, and other resources.
1. Is Alibaba Cloud AnalyticDB a highly available service?
Every component of Alibaba Cloud AnalyticDB always has, at least, two sets of workable versions. Hence, AnalyticDB is always available even if a single machine fails or during the release of new AnalyticDB version.
2. How can I use Alibaba Cloud AnalyticDB while running my service on cloud?
Your frontend service systems hosted on Alibaba Cloud (such as websites on ECS) can be easily connected to AnalyticDB for data query through standard MySQL client. Use MaxCompute to import data into AnalyticDB. From MaxCompute, you can easily import data into AnalyticDB through built-in data pipeline function.
3. What are the differences between Alibaba Cloud AnalyticDB, MaxCompute and Relational Database Services?
|On-demand cloud database.||Offline mass data operation service applicable to offline computing.||RDS is an OLTP (On-line Transaction Processing) database.|
|Can be directly connected to your analytic systems.||Not directly connected to your service.||Can be connected to your services.|
|Capacity to process large amounts of data (10 billion pieces, a maximum of dozens of TB) within milliseconds.||Capacity to process large volumes of data (PB level, trillions of pieces) or complex algorithm models that do not have real-time processing requirements.||Does not handle large volumes of data. Mainly used for transaction processing (CRUD, create, retrieve, update, and delete) .|
4. How does Alibaba Cloud AnalyticDB keep my data secure?
Alibaba Cloud AnalyticDB supports authorization at the table or column level, which can be controlled at each level. AnalyticDB adheres to the advanced security technology standards designed and maintained within Alibaba Cloud, so your data is safe and cannot be viewed by anyone without authorization.