ApsaraDB RDS

Provides basic and high availability instances that you can choose based on your needs.

• Basic instances: The basic instance supports SQL Server 2012 and is half the cost of a high availability instance. This type of instance supports failover, which ensures the smooth running of your service.
• High availability instances: Each high availability instance consists of a primary instance and a standby instance that are deployed on different servers and automatically synchronize data with each other. When the primary instance is unavailable, the system automatically switches the database connection to the standby instance. The high availability instance currently supports SQL Server 2008 R2/2012SE & EE/2016SE & EE.

ApsaraDB for SQL Server has been certified by and meets the following standards: ISO 20000, SOC, and PCI-DSS.

• Data security prevention: You can use the IP whitelist to control the requests to your SQL Server instance. You can also implement more advanced network access control through the VPC.
• Data transmission protection: ApsaraDB for SQL Server supports SSL encryption to prevent man-in-the-middle attacks. You can also enable Transparent Data Encryption so that data is automatically encrypted when moved to different disks.
• SQL auditing: The SQL auditing feature allows you to record all information about the requests to your database. This ensures that all security issues are traceable.

.

Provides automatic monitoring and alarms. Periodic performance inspections can reduce your maintenance workload by 60%.

• System resource monitoring: Dynamically monitors metrics such as CPU utilization, IOPS, network connections, and disk utilization, and sends alarms based on your settings. This enables you to understand the instance status easily.
• Optimization support: Offers automatic performance inspections and diagnoses. Allows you to create custom metrics and provides professional advice on SQL optimization in performance diagnostic reports.

With PostGIS extensions, the service supports 2D and 3D geographical data modelling, and recognizes the shifts caused by the irregular shape of the Earth to enable precise positioning that meets the OpenGIS standard.

• Spatial data types: Supports spatial data types such as POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, and GEOMETRYCOLLECTION.
• Spatial functions: Supports spatial functions such as Area, Length, and Distance.
• Metadata types and functions: Supports GEOMETRY_COLUMNS and SPATIAL_REF_SYS.
• Binary predicates: Supports binary predicates such as Contains, Within, Overlaps, and Touches.
• Spatial operators: Supports spatial operators such as Union and Difference.

The SQL statements support unstructured data types such as JSON, XML, and Key-Value, which enables a Not Only SQL (NoSQL) solution.

• Create tables using JSON data: For example, CREATE TABLE json_tab(id bigint, data jsonb);Directly save JSON data: For example, INSERT INTO json_tab VALUES (1,'{“”pname””:””Product 1″”,””qty””:50}’)
• Directly query JSON data: For example, SELECT * FROM json_tab WHERE data->>’qty’ > 30
• Index JSON attributes to enhance performance: For example, CREATE INDEX idx_json_tab_data_pname ON json_tab USING btree ((data ->> ‘pname’));
• Perform JOIN queries on existing tables: For example, SELECT * FROM json_tab JOIN product ON (products.pname=json_data.data->>’pname’) WHERE data->>’qty’ > 30;

You can use SQL operations to perform full-text searches and fuzzy queries without the need to create additional search engines.

• Multiple features: Supports Chinese text segmentation and custom word banks, and allows you to continuously process and optimize existing word banks. The service also offers advanced features such as jieba segmenter, similarity analysis, similarity indexing, and regular expression matching. You can use the SQL engine to perform text segmentation smoothly and easily.

Based on the Foreign Data Wrapper (FDW) feature of PostgreSQL, ApsaraDB for PostgreSQL integrates the management of external tables stored in OSS and supports unlimited storage expansion.

• 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. You can also use the standard GZIP algorithm to compress the CSV files stored as external tables in OSS. This effectively shortens the data writing time to OSS and lowers the storage cost by more than 50%.

ApsaraDB for PostgreSQL meets the high availability needs of OLTP applications, and also supports OLAP data warehouses for real-time data analysis.

• OLAP + OLTP = HTAP:Provides the same database driver for online databases and data warehouses, which helps SMEs reduce the development cost. To analyze TB size data, you can use AnalyticDB for PostgreSQL to create OLAP data warehouses that support horizontal scaling, and BI transactions that involve analyzing hundreds of TB or PB size data.