Tablestore is a serverless table storage service for large volumes of structured data. It supports four data models — Wide Column, AI (Agent Memory), TimeSeries, and Timeline — for AI, metadata, messaging, and spatio-temporal workloads. Built-in features include search index, vector search, and SQL query. Tablestore integrates with compute ecosystems such as MaxCompute, Flink, Spark, and Presto, and is compatible with AI frameworks including Dify, LangChain, and LlamaIndex. It also provides the MCP intelligent Agent architecture for AI chat applications and the IoTstore solution for IoT use cases.
Key concepts
Term | Description |
Region | A physical data center where Tablestore is deployed. Regions and zones. |
Read/write throughput | Measured in read capacity units (RCUs) and write capacity units (WCUs). A CU is the smallest billing unit for read and write operations. Read/write throughput. |
Instance | An entity for managing and using Tablestore, equivalent to a database. Access control and resource metering operate at the instance level. See Instances. |
Endpoint | Each instance has an endpoint that applications must specify when performing operations on tables and data. See Endpoints. |
Data lifecycle | Time to live (TTL) is a property of a data table that specifies the data retention period in seconds. Tablestore clears expired data in the background, reducing storage costs. See Data versions and TTL. |
Data storage models
Tablestore provides three data storage models. Select a model based on your use case. For a feature comparison across models, see Features.
Model | Description |
Wide table model | Similar to Bigtable and HBase. Suitable for metadata and big data scenarios. Supports data versions, TTL, auto-increment primary key columns, conditional updates, local transactions, atomic counters, and filters. See Wide Column model. |
TimeSeries model | Designed for time series data from IoT device monitoring, device data collection, and machine monitoring. Supports automatic time series metadata indexes and time series queries. See TimeSeries model. |
Message model | Designed for instant messaging (IM) and feed streams. Provides message ordering, massive storage, real-time synchronization, full-text search, and multi-dimensional composite queries. Timeline model. |
Use cases
Use case | Description |
AI applications | Store and retrieve AI agent memory and contextual data using the AI (Agent Memory) model and vector search. The MCP intelligent Agent architecture supports AI chat applications built with Dify, LangChain, or LlamaIndex. |
IoT data management | Collect and analyze time series data from IoT devices at scale using the TimeSeries model and the IoTstore solution. |
Metadata storage | Store and query large-scale metadata — such as file indexes, user profiles, and product catalogs — using the Wide Column model with search index and SQL query. |
Messaging and social feeds | Build instant messaging systems and feed streams using the Timeline model, with support for message ordering and real-time synchronization across massive data volumes. |
Spatio-temporal data | Query and analyze location and event data with multi-dimensional composite queries and the search index. |
Access methods
Method | Description |
Console | Manage Tablestore through the Tablestore console. |
SDK | Develop applications using SDKs for Java, Go, Python, Node.js, .NET, and PHP. SDK reference. |
Command line interface | Run Tablestore operations using simple commands. Command line interface. |
Quick start
Get started with the Wide Column or TimeSeries model using the console or CLI:
Computing and analytics
Tablestore integrates with multiple compute and analytics engines. Select an engine based on your scenario.
Analytical tool | Applicable model | Description |
MaxCompute | Wide table model | Create a foreign table via the MaxCompute client to access Tablestore data. Use MaxCompute. |
Spark | Wide table model | Access Tablestore through E-MapReduce SQL or DataFrame programming. Use the Spark compute engine. |
Hive or HadoopMR | Wide table model | Access Tablestore data with Hive or Hadoop MapReduce. Use Hive or HadoopMR. |
Function Compute | Wide table model | Run real-time computing on Tablestore incremental data. Use Function Compute. |
Flink | Wide table model, TimeSeries model | Use Real-time Compute Flink to access source, dimension, or sink tables in Tablestore for real-time big data analysis. Use Flink. |
PrestoDB | Wide table model | Query, write, and import Tablestore data using SQL through PrestoDB. Use Tablestore with PrestoDB. |
Tablestore search index | Wide table model | Use inverted indexes and columnar storage for complex multidimensional queries and statistical analysis. Supports non-primary key column queries, multi-column combined queries, fuzzy queries, and aggregations (max/min, count, grouping). Search index. |
Tablestore SQL query | Wide table model, TimeSeries model | Access Tablestore data through a unified SQL interface for complex queries and analysis. Use SQL query. |
Migration and synchronization
Migrate and synchronize heterogeneous data to Tablestore, or export Tablestore data to other services.
Category | Operation | Description |
Data import | Use the Tablestore Sink Connector to batch import data from Apache Kafka into a data table or time series table. | |
Data import | Use Tunnel Service, DataWorks, or DataX to synchronize data between Tablestore tables. | |
Data export | Use DataWorks to export full data from Tablestore to MaxCompute. | |
Data export | Use DataWorks to export full or incremental data to Object Storage Service (OSS). | |
Data export | Use the CLI or DataX to download data to a local file directly, or use DataWorks to export to OSS and then download from OSS. |
Category | Data synchronization | Description |
Data import | Use the Tablestore Sink Connector to batch import data from Apache Kafka into a Tablestore data table or time series table. | |
Use Tunnel Service, DataWorks, or DataX to synchronize data from one Tablestore data table to another. | ||
Data export | Use DataWorks to export full data from Tablestore to MaxCompute. | |
Use DataWorks to export full or incremental data from Tablestore to OSS. | ||
Use the CLI or DataX to download data directly to a local file. Alternatively, use DataWorks to sync data to OSS, then download the data from OSS. |
More features
Feature | Description |
Access control | Configure custom permissions with Resource Access Management (RAM). Grant permissions to a RAM user using a RAM policy. Further restrict access with control policies in a resource directory, Tablestore network ACLs, and instance policies. See Authorization management. |
Security | Protect data at rest and in transit using data table encryption and VPC network access. See Data encryption and Network security management. |
Backup | Back up important data periodically to prevent accidental deletion. Data backup. |
Monitoring and alerts | Configure alert notifications for monitoring metrics using Cloud Monitor. Data monitoring and alerts. |
Visualization | Visualize Tablestore data as charts using DataV or Grafana. See Data visualization. |