database

Install VectorWise DB on RHEL/CENTOS

by

Actian Vector (formerly known as VectorWise) is an SQL relational database management system designed for high performance in analytical database applications. It published record breaking results on the Transaction Processing Performance Council’s TPC-H benchmark for database sizes of 100 GB, 300 GB, 1 TB and 3 TB on non-clustered hardware. For Installing Vectorwise DB, download/Untar vectorwise DB binary file and start … Read more

MySQL Server Time Zone Support

by

This article describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Beginning with MySQL 8.0, time zone offsets are also supported for inserted datetime values; see “The DATE, DATETIME, and TIMESTAMP Types”, … Read more