Best Practices for OEM Customers
Welcome to Best Practices for Vertica OEM Customers. This guide describes best practices and tips for Vertica OEM customers who embed their Vertica database with their own application and deliver it as an on-the-premises solution. Typically, the end users of the application do not interact with the Vertica database directly but rather through the application.
The information in this guide describes technical issues for two types of tasks that OEM customers must perform to optimize the database in their application:
Developing and testing the Vertica database:
- Running Database Designer and designing projections
- Managing your system resources
- Managing data load
- Optimizing delete and update operations
- Dropping partitions to save disk space
Packaging the Vertica database with your application:
- Installing Vertica silently
- Configuring the Vertica database using parameters defined during the development phase
- Using the Administration Tools command-line interface to create, start, and connect to the Vertica database