LightDB-A Database Administrator Guide

Information about configuring, managing and monitoring LightDB-A Database installations, and administering, monitoring, and working with databases. The guide also contains information about LightDB-A Database architecture and concepts such as parallel processing.

• LightDB-A Database Concepts
  This section provides an overview of LightDB-A Database components and features such as high availability, parallel data loading features, and management utilities.
• Managing a LightDB-A System
  This section describes basic system administration tasks performed by a LightDB-A Database system administrator.
• Managing LightDB-A Database Access
  Securing LightDB-A Database includes protecting access to the database through network configuration, database user authentication, and encryption.
• Defining Database Objects
  This section covers data definition language (DDL) in LightDB-A Database and how to create and manage database objects.
• Distribution and Skew
  LightDB-A Database relies on even distribution of data across segments.
• Inserting, Updating, and Deleting Data
  This section provides information about manipulating data and concurrent access in LightDB-A Database.
• Querying Data
  This topic provides information about using SQL in LightDB-A databases.
• Working with External Data
  Both external and foreign tables provide access to data stored in data sources outside of LightDB-A Database as if the data were stored in regular database tables. You can read data from and write data to external and foreign tables.
• Loading and Unloading Data
  The topics in this section describe methods for loading and writing data into and out of a LightDB-A Database, and how to format data files.
• Managing Performance
  The topics in this section cover LightDB-A Database performance management, including how to monitor performance and how to configure workloads to prioritize resource utilization.