................................................................. 5 3.7. Limitations of SQLite virtual tables .......................................................................... 5 3.7.1. Indexes doing just three things: 1. To create a Zumero table instead of a regular table, do this: CREATE VIRTUAL TABLE foo USING zumero (...); 2. To create indexes on a Zumero table, prefix the table name with 4 Chapter 3. Zumero tables vs. regular SQLite tables Zumero tables are implemented as SQLite virtual tables1. This is the same mechanism which is used to implement SQLite's full-text search module2

Requirements 263 Operating System 263 Storage 263 Security 264 Amazon Web Services (AWS) 264 Virtual Machine Type 264 Compute 264 Memory 264 Network 264 Storage 264 Elastic Block Storage (EBS) Ephemeral 265 AWS Recommendations 265 Master 265 Segments 265 Google Compute Platform (GCP) 266 Virtual Machine Type 266 VMware Greenplum 6 Documentation VMware, Inc 11 Compute 266 Memory 266 Network Network 266 Storage 266 GCP Recommendations 267 Master and Segment Instances 267 Azure 267 Virtual Machine Type 268 Compute 268 Memory 268 Network 268 Storage 268 Azure Recommendations 269 Master

Recommendations 251 Operating System 251 Storage 252 Security 252 Amazon Web Services (AWS) 252 Virtual Machine Type 252 Compute 252 Memory 252 Network 253 Storage 253 Elastic Block Storage (EBS) Compute Platform (GCP) 254 Virtual Machine Type 254 Compute 254 Memory 254 Network 254 Storage 254 GCP Recommendations 255 Master and Segment Instances 255 Azure 255 Virtual Machine Type 256 Compute vSphere Architecture 292 Layered Architecture 292 Provider Layer 293 Infrastructure Layer 293 Virtual Machine Cluster Layer 293 Greenplum Layer 294 Planning VMware vSphere with Greenplum 294 Calculating

Recommendations 255 Operating System 255 Storage 255 Security 256 Amazon Web Services (AWS) 256 Virtual Machine Type 256 Compute 256 Memory 256 Network 256 Storage 256 Elastic Block Storage (EBS) Compute Platform (GCP) 258 Virtual Machine Type 258 Compute 258 Memory 258 Network 258 Storage 258 GCP Recommendations 259 Master and Segment Instances 259 Azure 259 Virtual Machine Type 260 Compute vSphere Architecture 297 Layered Architecture 297 Provider Layer 297 Infrastructure Layer 297 Virtual Machine Cluster Layer 298 Greenplum Layer 298 Planning VMware vSphere with Greenplum 299 Calculating

Requirements 281 Operating System 281 Storage 282 Security 282 Amazon Web Services (AWS) 282 Virtual Machine Type 282 Compute 282 Memory 282 Network 283 Storage 283 Elastic Block Storage (EBS) Compute Platform (GCP) 284 Virtual Machine Type 284 Compute 284 Memory 284 Network 284 Storage 284 GCP Recommendations 285 Master and Segment Instances 285 Azure 285 Virtual Machine Type 286 Compute VMware Greenplum 6 Documentation VMware, Inc. 15 Provider Layer 326 Infrastructure Layer 326 Virtual Machine Cluster Layer 326 Greenplum Layer 327 Planning VMware vSphere with Greenplum 327 Calculating

Recommendations 228 Operating System 228 Storage 228 Security 229 Amazon Web Services (AWS) 229 Virtual Machine Type 229 Compute 229 Memory 229 Network 229 Storage 229 Elastic Block Storage (EBS) Compute Platform (GCP) 230 Virtual Machine Type 230 Compute 231 Memory 231 Network 231 Storage 231 GCP Recommendations 231 Master and Segment Instances 232 Azure 232 Virtual Machine Type 232 Compute vSphere Architecture 266 Layered Architecture 266 Provider Layer 266 Infrastructure Layer 266 Virtual Machine Cluster Layer 266 Greenplum Layer 267 Planning VMware vSphere with Greenplum 268 Calculating

Public Cloud Requirements 295 Operating System 295 Storage 295 Amazon Web Services (AWS) 295 Virtual Machine Type 295 Compute 296 Memory 296 Network 296 Storage 296 Elastic Block Storage (EBS) Compute Platform (GCP) 297 Virtual Machine Type 297 Compute 297 Memory 298 Network 298 Storage 298 GCP Recommendations 298 Master and Segment Instances 299 Azure 299 Virtual Machine Type 299 Compute VMware by Broadcom 16 Layered Architecture 339 Provider Layer 340 Infrastructure Layer 340 Virtual Machine Cluster Layer 340 Greenplum Layer 341 High Availability 341 Planning VMware vSphere with

Objects 48 Connections 48 Queries 48 Models 48 Snippets 49 Charts Workspaces 49 Virtual Groups 50 Chapter 8 – Commands 51 On-Prem Server Commands 51 Chapter 9 - Troubleshooting Cloud account, and manage the objects (connections, queries, snippets, models, workspaces and virtual groups) that are synchronized to Navicat Cloud. Here are some highlights of Navicat Cloud Portal: environment for storing Navicat objects (connection settings, queries, snippets, models, workspaces, and virtual groups) internally at your location. Here are some highlights of Navicat On-Prem Server: •

a Java Installation Create a Column Family 2 Cassandra is a Java program and requires a Java Virtual Machine (JVM) to be installed before you can start the server. For production deployments, you will datastax $ cd datastax 2. In the datastax directory download the Cassandra package (required), plus the OpsCenter package (optional). For example, on Linux to get version 1.0.7 of DataStax Community CASSANDRA_HOME=$HOME/datastax/package_name> export DSCDEMO_HOME=$HOME/datastax/dsc-1.0.1/demos/portfolio_manager export OPSC_HOME=$HOME/datastax/package_name> export PATH="$PATH:$CASSAND

5.11. PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215 5.11.1. CREATE PACKAGE. . . . 11.2. ALTER PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218 5.11.3. CREATE OR ALTER PACKAGE . . . . . . 5.11.4. DROP PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 5.11.5. RECREATE PACKAGE . . . . . . .