SynxDB Documentation

Disclaimer

Greenplum® is a registered trademark of Broadcom Inc. Synx Data Labs and SynxDB are not affiliated with, endorsed by, or sponsored by Broadcom Inc. Any references to Greenplum are for comparative, educational, and interoperability purposes only.

Table of Contents

• Product Overview
  • Feature Overview
  • Product Architecture
  • User Scenarios
  • Comparison with Greenplum Features
  • Releases
• Deployment Guides
  • Deploy on Physical Machines
• Create and Prepare Databases
  • Create and Manage Databases
  • Start and Stop Databases
  • Connect to Databases
• Load Data
  • Data Loading Overview
  • Load Data from Local Files
  • Load External Data Using Foreign Table
  • Load Data from Web Services
  • Load Data Using PXF
  • Load Data from Kafka Using Kafka FDW
  • Load Data from Kafka Using Kafka Connector
  • Load Data from Object Storage and HDFS
  • Load Data from Hive Data Warehouse
  • Load Data from MySQL Server Using MySQL_FDW
  • Custom Multi-Character Delimiters for Reading and Writing External Tables
• Operate with Data
  • Operate with Database Objects
  • SQL Queries
  • Advanced Analytics
  • Auto-Execute SQL commands
  • Use Oracle Compatibility SQL via Orafce
• Optimize Performance
  • Optimize Query Performance
  • Create Indexes Concurrently
  • Create AO/AOCO Tables in Parallel and Refresh Materialized Views
  • Manage Resources Using Resource Groups
  • Use Dynamic Tables to Speed Up Queries and Auto-Refresh Data
• Manage System
  • View Monitoring Data Using the Web Console
  • Configure Security and Permission
  • Backup and Restore
  • Expand and Shrink a Cluster
  • Configure Database System
• Component Guides
  • Using ZomboDB to integrate with Elasticsearch
• Reference Guides
  • SQL Statements
  • System Utilities
  • System Catalogs
  • Configuration Parameters
• Developer Guides
  • Develop Database Extensions Using PGRX