HP Vertica

The column-oriented Vertica RDBMS is designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. It claims to drastically improve query performance over traditional relational database systems, provide high-availability, and petabyte scalability on commodity enterprise servers. You can download a free, feature-limited copy for local use, or subscribe to their hosted service. For more information, see the Vertica website.

The Connection.Vertica element allows you to connect your Logi applications to the database. Special drivers must be downloaded and installed. For more information, see Working with HP Vertica.

Though you can have success using standard DataLayer.SQL, for best performance with very large datasets, we recommend use of DataLayer.ActiveSQL. Vertica SQL is based on standard SQL syntax but has a number of very important differences that you must be aware of as you design and develop your data warehouse applications. Please refer to the Vertica SQL Reference for more information