-
Marketplace
-
Channel Resources
Articles from this Site
Time and Time Again: State Transformations
GoldenGate Software Releases GoldenGate Veridata 2.1
Time and Time Again: Scenario 1, Transaction 4
Time and Time Again: Scenario 1, Transaction 3
Time and Time Again: Scenario 1, Transaction 2
White Papers
Databasing in the 90s: Data and What We're Doing with It!
Constant Replicator DB for MySQL Cluster
eStore Advantage - Extending Microsoft eConnect for MBS Great Plains
Is Your Database Eating Out The Heart of Your IT Infrastructure.
UML for C#
Web Seminars
Master Data Management: Best Practices for Success
Modeling Unstructured Data
Closing the Loop: Real-Time Event Detection and Response
Business Intelligence in a Box: Realize the Dream of Extreme Analytics
Books
Vertica Announces Vertica Analytic Database 2.5
October 14, 2008 - A new version of Vertica's grid-based, column-oriented analytic database lets companies meet more aggressive business intelligence (BI) service level agreements (SLAs) and give more people faster access to larger volumes of data by applying analytic database technology to a wider variety of workloads.
New features of Vertica Analytic Database 2.5 include extensive SQL syntax support, ability to support any type of database schema design, improved compatibility with Oracle and SQLServer SQL dialects as well as new manageability features. These enhancements enable Vertica 2.5 customers to support a wider variety of analytic workloads than was possible with earlier versions.
It also includes a new Intelligent Query Router facility that allows Vertica 2.5 to pass queries to legacy data warehouses containing data that has not yet been migrated to Vertica. This allows customers to deploy the benefits of Vertica faster by moving just their most urgent queries and data to the new database first.
New features in Vertica 2.5 include:
- Query Routing to facilitate migration of applications from existing data warehouses,
- Expanded SQL support, with nested subqueries, new SQL joins and SQL functions, Ability to support any type of schema design,
- Improved compatibility with Oracle and SQLServer SQL dialects and
- Enhanced manageability, including support for hot backups, event monitoring, database profiling and multi-tenant databases.
This piece is brought to you by the DM Review editorial staff.
For more information on related topics, visit the following channels:


