poloclub.github.io/#cse6242
 CSE6242/CX4242: Data & Visual Analytics
 Simple Data Storage; SQLite Duen Horng (Polo) Chau
 Associate Professor, College of Computing
 Associate Director, MS Analytics


databases configuration Cloud Explorer tools DBeaver Ultimate User Guide 24.1. Page 4 of 1169. Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan Script management SQL Assist and Auto Complete SQL templates Visual Query builder SQL Formatting Variables panel SQL Terminal AI Smart Assistance Advanced data types SQL Editor tools Query execution and management tools Query development and assistance tools DBeaver Ultimate User Guide 24.1. Page 9 of 1169

configuration Cloud Explorer tools DBeaver Ultimate User Guide 24.2.ea. Page 4 of 1171. Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan Script management SQL Assist and Auto Complete SQL templates Visual Query builder SQL Formatting Variables panel SQL Terminal AI Smart Assistance Advanced data types SQL Editor tools Query execution and management tools Query development and assistance tools DBeaver Ultimate User Guide 24.2.ea. Page 9 of 1171

Cloud Explorer tools DBeaver User Guide 24.2.ea. Page 4 of 1171. Google Cloud Explorer Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Script management SQL Assist and Auto Complete SQL templates Visual Query builder SQL Formatting Variables panel Spelling Advanced data types SQL Editor tools Query execution and management tools import/export and operations DBeaver User Guide 24.2.ea. Page 10 of 1171. Data transfer external storage Data compare Backup and restore Schema compare overview Using Liquibase in DBeaver Search overview

configuration Cloud Explorer tools DBeaver User Guide 24.1. Page 4 of 1171. Google Cloud Explorer Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Script management SQL Assist and Auto Complete SQL templates Visual Query builder SQL Formatting Variables panel Spelling Advanced data types SQL Editor tools Query execution and management tools import/export and operations DBeaver User Guide 24.1. Page 10 of 1171. Data transfer external storage Data compare Backup and restore Schema compare overview Using Liquibase in DBeaver Search overview

Software Dependencies 143 Java 145 Hardware and Network 145 Tanzu Greenplum on DCA Systems 145 Storage 146 Data Domain Boost (Tanzu Greenplum) 146 Tanzu Greenplum Tools and Extensions Compatibility Query Optimizer 153 Cluster Management 153 Data Flow 154 Release 6.19.1 154 Changed Features 154 Resolved Issues 154 Server 154 Query Optimizer 155 Cluster Management 155 Release 6.19.0 155 Features Features 156 Resolved Issues 156 Cluster Management 156 Data Flow 157 Greenplum Installation 157 Query Planner 157 Server 157 Release 6.18 158 Release 6.18.1 158 Resolved Issues 158 Server 158

Features 144 Resolved Issues 145 Server 145 Query Processing 146 Database Utilities 146 Cluster Management 146 Additional Supplied Modules and Extensions 146 Release 6.26 146 Release 6.26.4 146 Server 147 Server 147 Release 6.26.2 147 New Features 148 Query Processing 148 Server 148 Cluster Management 148 VMware Greenplum 6 Documentation VMware by Broadcom 3 Disaster Recovery 148 Data Flow 149 Query Processing 149 Server 149 Cluster Management 150 Release 6.26.0 150 Features 150 Resolved Issues 150 Server 151 Query Processing 151 Cluster Management 151 Data Flow 152 Release 6.25 152 Release

Software Dependencies 142 Java 144 Hardware and Network 144 Tanzu Greenplum on DCA Systems 144 Storage 145 Data Domain Boost (Tanzu Greenplum) 145 Tanzu Greenplum Tools and Extensions Compatibility 149 Upgrading Greenplum 149 Release 6.18 149 Release 6.18.2 149 Resolved Issues 149 Cluster Management 149 Query Planner 150 Server 150 VMware Greenplum v6.18 Documentation VMware, Inc. 3 Greenplum Release 6.18.0 151 Features 151 Resolved Issues 152 Server 152 Query Optimizer 154 Cluster Management 154 Data Loading 155 Release 6.17 155 Release 6.17.7 155 Resolved Issue 155 Server 155 Release

Release 6.25.3 139 Cluster Management 139 Query Processing 139 Server 140 Disaster Recovery 140 Release 6.25.2 140 New and Changed Features 140 Server 140 Cluster Management 141 Resolved Issues 141 141 Server 141 Cluster Management 142 Data Flow 142 Extensions 142 Drivers 143 Query Processing 143 Release 6.25.1 143 Server 143 Data Flow 144 Release 6.25.0 144 Features 144 Resolved Issues 145 Server 145 VMware Greenplum 6 Documentation VMware, Inc. 3 Query Processing 145 Cluster Management 146 Data Flow 146 Upgrade 146 Release 6.24 146 Release 6.24.6 146 Query Processing 146 Server

Software Dependencies 135 Java 137 Hardware and Network 137 Tanzu Greenplum on DCA Systems 137 Storage 137 Data Domain Boost (Tanzu Greenplum) 138 Tanzu Greenplum Tools and Extensions Compatibility Resolved Issues 143 Server 143 Cluster Management 143 Query Optimizer 143 Data Flow 144 Release 6.20.1 144 Resolved Issues 144 Server 144 Cluster Management 144 Query Optimizer 145 Release 6.20 20.0 145 Features 145 Resolved Issues 147 Cluster Management 147 Query Optimizer 147 Server 147 Data Flow 148 Release 6.19 148 Release 6.19.4 148 Resolved Issues 148 Data Flow 148 Server 148