ApsaraDB RDS for PPAS

Features

• 

  Incremental Data Migration

  With Alibaba Cloud Data Transmission Service, you can incrementally synchronize your on-premise Oracle database to ApsaraDB for PPAS, and shorten the downtime during system migration.

  
  

  Downtime-free migration solution

  The service first synchronizes all Oracle data to the cloud, and then performs incremental synchronization to update the data persistently. Developers can verify data integrity, test query performance in the cloud, and perform optimization tasks. After the integrity of the data has been verified and all system software has passed the debugging tests, you can migrate your service from the on-premise Oracle to ApsaraDB for PPAS in the shortest downtime.

• 

  High performance table partitioning

  Provides high performance when implementing table partitioning and strong compatibility with Oracle. For tables with more than 100 partitions, the performance is 50 times higher than that of native PostgreSQL.

  
  

  50 times better performance and Oracle compatibility

  ApsaraDB for PPAS is built on the open source PostgreSQL database, whose table partitioning feature is based on triggers. You need to manually create triggers. ApsaraDB for PPAS offers a new solution for table partitioning, which supports the Oracle statement CREATE TABLE... PARTITION BY, and provides DBA_TAB_PARTITIONS and DBA_TAB_SUBPARTIONS catalog views.

• 

  Full-text Search and GIS Support

  You can directly perform full-text searches and process GIS data using the same SQL engine. This simplifies the development process and avoids the complexity of interactions among multiple systems.

  
  

  Custom features for the GIS industry

  Full-text search allows you to query and select natural language documents, and sort these documents by relevance. The most common search is to find the documents that contain the specified keywords, sort them by similarity, and return the results. Meanwhile, PPAS also integrates PostGIS extensions, which enable you to easily manage the coordinates in the database, and perform relational queries on production data.

• 

  OSS Storage Expansion

  Removes the storage limit in RDS systems. Provides unlimited OSS storage for external tables.

  
  

  Readable, writeable, and unlimited storage

  With external tables, you can use the CSV files stored in OSS as local data tables. The service also allows you to perform JOIN queries involving local tables, to read and write data directly, and to flexibly increase the database size to meet your needs for the management of hot and cold data lifecycles.

• 

  Data Warehousing

  Supports OSS data exchange with HybridDB for PostgreSQL. Enables data warehousing with PostgreSQL-based OLAP databases.

  
  

  Integration with HybridDB for PostgreSQL

  After you have migrated your Oracle database system to Alibaba Cloud, you can easily integrate OLTP and OLAP systems based on the BI capability of OLAP data warehouses provided by HybridDB for PostgreSQL. This further enhances business performance and enables lower costs.