THE VERTICA DATABASE SYSTEM’S ADVANTAGE

An analytic database is specifically designed to support business intelligence (BI) and analytic applications, typically as part of a data warehouse or data mart. This differentiates it from an operational, transactional or OLTP database, which is used for transaction processing – i.e., order entry and other “run the business” applications.

    • Compatible with major Business Intelligence tools such as Actuate/BIRT, Cognos, Business Objects, Microstrategy, Pentaho, Jaspersoft, Talend and others, and uses the MySQL drivers for ODBC, JDBC etc.
    • Column Architecture.
    • Fast response times for complex analytic queries.
    • Very fast data load: Load TBs per hour with the Distributed Load Processor.
    • Supports all schema designs.
    • High availability without hardware redundancy.

DATA WAREHOUSING

  • Enhances end-user access to a wide variety of data
  • Business decision makers can obtain various kinds of trend reports e.g. the item with the most sales in a particular area / country for the last two years
  • Increased data consistency
  • Additional documentation of the data
  • Potentially lower computing costs and increased productivity
  • Providing a place to combine related data from separate sources
  • Creation of a computing infrastructure that can support changes in computer systems and business structures
  • Empowering end-users to perform any level of ad-hoc queries or reports without impacting the performance of the operational systems