Vertica brings higher speeds to ad hoc queries
Post Date: Tue, 19 Feb 2008 09:32:06 -0700
Michael Stonebraker has a history of database breakthroughs. He was a founder of Ingres, Illustra, Cohera and StreamBase Systems. He also served as CTO of Informix and helped develop Postgres. His most recent creation is Vertica, which just launched version 2.o of its database. The claims......
http://blogs.zdnet.com/BTL/?p=8044...
Vertica brings higher speeds to ad hoc queries (Abstract text format)
12279
Vertica brings higher speeds to ad hoc queries | Between the Lines
| ZDNet.com
@import url(http://i.zdnet.com/css/v2/base.css);
@import url(http://i.zdnet.com/css/v2/ads.css);
@import url(http://i.zdnet.com/css/v2/blog.css);
On The Insider:
2009 at the Playboy Mansion
BNET Business Network:
BNET
TechRepublic
ZDNet
ZDNet
all ZDNet
in Blogs
in News
in Downloads
in Reviews
in Whitepapers
in Dictionary
Go!
Members Log In
Newsletters
Site Assistance
RSS Feeds
Home
News & Blogs
Videos
White Papers
Downloads
Reviews
Popular
Between the Lines
Larry Dignan, Sam Diaz, Tom Steinert-Threlkeld
Get BTL via:
Mobile
RSS
Email Alerts
Bios:
Larry’s Bio
Sam’s Bio
Tom’s Bio
Pick a blog category
Adobe
Always On 2006
AlwaysOn
Amazon
AMD
AMD Global Vision
AMD vs. Intel
Apple
AT&T
Between the Lines podcast
BloggerCon IV
Blogging
Broadband
Building Blocks
Business Continuity
Business Intelligence
C3 Expo
Catalyst
Centrino
CES
Churchill Club
Cingular
CIO Sessions
Cisco
Cloud computing
Contributors
Copyright issues
Craigslist
Credit crisis
D4
D5
Datacenter
Dell
Demo
Demo 08
Demo 2006
DEMOfall 07
DEMOfall 2006
Digital ID World
Digital ID World 2006
Digital Media
Digital Restrictions Management
Disaster Recovery
DRM
E-commerce
Earnings
eBay
Economy
EDS
Educa tion
EIC2
EMC
Emergetech
Enterprise 2.0
Entertainment
ERP
ETech
Facebook
Future in Review
Gartner Symposium
Gartner Symposium 2008
Geek Sheet
General
Gnomedex
Google
Government
Green Tech
Hardware Infrastructure
Hewlett-Packard
Hollywood on Demand
IBM
Identity Mashup Conference
Infosys
Innovation
Intel
Intuit
IP Telephony
iPhone
IT Management
IT Matters
JavaOne 2006
Legal
Life Without Google
Links
Linux
LinuxWorld
Macworld
Mashup Camp
Mashup University
Media Juggernaut
Microblogging
Microsoft
Mobile
Mobile Roundup
Motorola
Motorola Q Review
MySpace
MySQL
Net neutrality
NetSuite
News to know
Nokia
Novell
Office 2.0
Offshore outsourcing
OnHollywood
Open Source
Oracle
OSBC
OSCON
Outsourcing
Palm
PC Forum 2006
Personal Technology
Podcasts
Polls
Printers
Real Networks
Red Hat
Research In Motion
Retail
RFID
RIM
SaaS
Salesforce.com
SAP
Sapphire
Science
Search
Second Life
Security
Semantic Web
Semiconductors
Singularity Summit 07
Skype
Social networking
Software 2006
Software Infrastructure
Sprint Nextel
Startup Camp
Storage
Sun
Supernova
Supply chain
Symantec
Syndicate
TechNet
Telecommunications
Twi tter
Utility computing
Verizon
virtualization
Vista
VMware
VOIP
Vona ge
Web 2.0 Expo
Web 2.0 Summit 07
Web Technology
web2con
Wikinomics
WiMax
Windows 7
Wired & Wireless
WWW2006
Yahoo
YouTube
Zune
~ Events ~
~ Special Series ~
February 19th, 2008
Vertica brings higher speeds to ad hoc queries
Posted by Dan Farber @ 8:32 am
Categories: Software Infrastructure, Datacenter, Business Intelligence
Tags: Michael Stonebraker, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Dan Farber
Michael Stonebraker has a history of database breakthroughs. He was a founder of Ingres, Illustra, Cohera and StreamBase Systems. He also served as CTO of Informix and helped develop Postgres. His most recent creation is Vertica, which just launched version 2.o of its database.
The claims around Vertica Analytic Database 2.0 are significant for querying data warehouses and data marts. According to the company, Vertica can access dozens of terabytes at lower cost than other solutions and respond to ad hoc queries based on real-time data in seconds.
The speeds comes from a shared-nothing, column architecture; data compression of up to 90 percent less table space; and concurrent loading and querying. The company claims that queries against terabyte databases are answered 50 to 200 times faster than competing row-oriented databases and specialized hardware.
According to Vertica, organizing data in columns of values from the same attribute, rather than as rows of tabular records results in faster performance for analytic databases. The result is that when a query needs to access just a few columns of a table, it only has to read those columns from the disk. In row-oriented databases, all the values in a table are usually read, consuming bandwidth.
In Vertica’s unique architecture, logical tables are physically stored as columns, and partitioned into segments on several machines and in several different projections. Source: Vertica
Vertica has a few marquee customers so far, including Comcast, Level 3 and JP Morgan.
Stonebraker isn’t done with creating new kinds of databases. He is working with a group of MIT/Brown/Yale scientists to completely rethink the OLTP database concept. Curt Monash has coverage of it in his DBMS2 blog.
Dan Farber, editor-in-chief of CNET News.com, has more than 20 years of experience as an editor and journalist covering technology. See his full profile and disclosure of his industry affiliations.
« Previous postNext post »
Talkback
Most Recent of 2 Talkback(s)
Thread View
Flat View
RE: Vertica brings higher speeds to ad hoc queries
Sybase has filed a patent infringement lawsuit against Vertica. Sybase's patent on the "organization of the columnar structure to support decision support systems" is 10 years old and is i... (Read the rest)
Posted by: BillWalters001 Posted on: 07/10/08
You are currently:
Logged In as: a Guest | Login | Terms of Use
Sybase Lawsuit Against Vertica
BillWalters001 | 07/10/08
RE: Vertica brings higher speeds to ad hoc queries
BillWalters001 | 07/10/08
What do you think?
Subject (max length: 75):
Reply:
No Trackbacks Yet
The URI to TrackBack this entry is:
http://blogs.zdnet.com/BTL/wp-trackback.php?p=8044
Spo nsoredWhite Papers, Webcasts, and Downloads
Adding IP to Small Office PBX Telephone Systems Cisco Systems
Building the Next Generation "Virtual, Cooler and Easier" Data Center with Rackonomics BLADE Network Technologies
Upgrading Your Network for CRM? Six Things to Consider Cisco Systems
Recent Entries
Report: Microsoft in stealth Yahoo takeover?
EMC cuts 2,400 jobs
Verizon picks MSFT search, gets ready for Kindle killers
Satyam fallout: Should customers stick? Full text of chairman’s stunning letter
If iRecord can rip DVDs, why can’t Real?
Top Rated
When Linux fails+53 votesFacebook: Becoming your legal residence on the Web?+30 votesChrome's EULA changes: Feels like Hotel California+23 votesMicrosoft: The top 5 risks; Will it cut 2009 outlook as PC market stumbles?+16 votesCheckFree customers intercepted by hackers+16 votesApple's Macworld saga and Jobs absence: Leadership signals and succession plans+14 votesIntuit's TurboTax printing fees raise users' ire+14 votesMigrating to Amazon Web Services: The blueprint+12 votes
Follow ZDNet on Twitter
Archives
January 2009
December 2008
November 2008
October 2008
September 2008
August 2008
All "Between the Lines" talkbacks
Favorite Links
Blogroll
Ars Technica
Deal Journal
Engadget
Enterprise Irregulars
GigaOm
Google Blogoscoped
Horses for Sources
Mac Rumors
Mashable
Official Google Blog
Read/WriteWeb
Scobleizer
SeekingAlpha
TechCrunch
T echdirt
The Ponderings of Woodrow
The Unofficial Apple Weblog (TUAW)
Valleywag
ZDNet Blogs
A Developer's View
All About Microsoft
The Apple Core
Between the Lines
BriefingsDirect
Collaboration 2.0
Community, Incorporated
CRM 2.0: The Conversation
Dev Connection
Digital Cameras
Ed Bott's Microsoft Report
Emerging Tech
Enterprise Alley
Enterprise Web 2.0
Feeds
Forrester Research
Googling Google
GreenTech Pastures
Hardware 2.0
Home Theater
iGeneration
Irregular Enterprise
IT Facts
The IT Grind
IT Project Failures
Laptops & Desktops
Lawgarithms
Linux and Open Source
Managing L'unix
The Mobile Gadgeteer
On Sustainability
Rational Rants
The Semantic Web
Service Oriented
Smartphones and Cell Phones
Software & Services Safari
Software as Services
SOHO Networking
Storage Bits
Team Think
Tech Broiler
Tom Foremski: IMHO
The ToyBox
The Universal Desktop
Virtually Speaking
The Web Life
ZDNet Education
ZDNet Government
ZDNet Healthcare
Zero Day
SponsoredWhite Papers, Webcasts, and Downloads
IBM BladeCenter S offers big benefits for the small office IBM
Live Webcast: Visibility: The Key to Maximizing Network Resources Blue Coat Systems
Podcast: Smart Technology Equals Productivity Cisco Systems
Gifts for Geeks
Find a gift for your favorite geek in the TechRepublic 2008 Geek Gift Guide.
Flip Mino
Amazon Kindle
Roku Netflix Player
Acer Aspire One
FPS Gaming Vest
Blogs
All About Microsoft
The Apple Core
Between The Lines
Googling Google
Digital Cameras
Hardware 2.0
Laptops and Desktops
SOHO Networking
Storage Bits
Zero Day
Product Reviews
Home Theater
PCs, Software and Peripherals
Smartphone and Cell Phones
Digital Cameras
Videos
CIO Vision Series
At The Whiteboard
News Video
White Papers and Webcasts
Business Management
Career Development
Infrastructure Management
ManageMobile - Wireless Communications
Network Security
Webcasts
Downloads
Internet Tools and Utilities
Spyware Removers
System Optimizers and Diagnostics
System Utilities
More
2008 Holiday Gift Guide
Photo Galleries
Latest News & Blogs
Podcasts
Site Index
ZDNet
ZDNet News & Blogs
Hardware,
IT Management,
Networking,
Operating Systems,
Photo Galleries,
Security,
Software,
Web Technology,
All News,
Dev Connection,
Emerging Technology,
Enterprise Alley,
Googling Google,
GreenTech Pastures,
IT Project Failures,
Linux and Open Source,
Managing Linux,
The Social Web,
Storage Bits,
Virtually Speaking,
The Web Life,
Podcasts
Product Reviews
A/V Receivers,
Cell Phones & Accessories,
Desktop Monitors,
Desktops,
Digital Cameras,
Digital Camcorders,
Flat-panel TVs,
Laptops,
Portable Video Players (PVPs),
PDAs,
Smartphones,
Software,
Storage
Product Blogs
The Toybox,
Digital Cameras,
Laptops and Desktops,
Mobile Gadgeteer,
SOHO Networking,
Smartphones and Cell Phones,
Home Theater
White Papers & Webcasts
Cost Control / Risk Management,
Customer Support Services,
IT HR / Staffing / Training,
Resources Management,
Strategic Planning,
Webcasts
Downloads
Antivirus Software,
File and Disk Management Utilities,
Image Editing,
Privacy Software,
Shell and Desktop Management Enhancements
Site Help & Feedback
Site Map
Popular on CBS sites: CES | Spore | iPhone 3G | Katy Perry | Antivirus Software | GPS | Recipes | Macworld | NFL
BNET | CBS College Sports | CBS Radio | CBS.com | CBSNews.com | CBSSports.com | CHOW | CNET | CNET Content Solutions | GameSpot | International | Last.fm | MaxPreps | Metacritic.com | Moblogic | MP3.com | mySimon | NCAA | Search.com | Shopper.com | TechRepublic | The Insider | TV.com | UrbanBaby.com | UWIRE | Wallstrip | ZDNet
About CBS Interactive |
Jobs |
Advertise
© 2009 CBS Interactive Inc. All rights reserved. |
Privacy Policy |
Terms of Use
0
|
