Read up on the latest ideas and technologies from companies that sell hardware, software and services. An EMC Perspective on Data De-Duplication for Backup
Revolutionising Back-up and Recovery
Optimized Back-up and Recovery for VMWare for VMWare Infrastructure with EMC Avamar
EMC Data Profiling for File System and Exchange Server Environments
Mimosa™ NearPoint™ for Microsoft® Exchange Server: Email Archiving 101
Realizing the Value of Unified Communications
A Guide to Next-Generation Backup, Recovery and Archive
Choices in Storage Architecture for Oracle Environments
Zones provide focussed content from Computerworld and leading technology partners.Newsletter Subscription
Like a muscle car driving 55 mph on the freeway, R.L. Polk & Co.'s new grid-based data warehouse boasts gobs of untapped power under the hood, according to Kevin Vasconi, the company's CIO.
In May, the US-based automotive industry market research company finished moving its main 4TB customer-facing data warehouse to an Oracle 10g grid comprised of Dell PowerEdge servers running Linux.
The move has helped R.L. Polk save money and improve data redundancy, availability and access time. It also supports Polk's new service-oriented architecture, which is improving customer service, Vasconi said.
"We are getting more bang for our buck," he said. The data warehouse is doing 10 million transactions a day "without any issues."
Encouraged by the experience so far, R.L. Polk is bringing onto the grid other databases, both domestic and overseas, that total 2.5 petabytes of actively managed data. It's a process that will take at least 18 months, Vasconi said. And the amount of data is expected to grow 30 percent per year for the foreseeable future.
Founded in 1870 -- the same year the automobile's predecessor, a motorized handcart, was invented in Germany - R.L. Polk started as a publisher of business directories. It became a car information supplier in 1921 and began using computer punch cards in 1951. The company is best known to consumers for its Carfax database of car histories.
Before its recent move to Oracle grid technology, R.L. Polk stored most of its data on Oracle 9 or 10 databases running Sun Solaris servers, connected to EMC gear running in storage-area networks.
Now, R.L. Polk's grid is comprised of 100 two- and four-way servers all running Red Hat Enterprise Linux. It also serves up applications and powers the rule processing engine. It can "easily double" to 200 servers, providing room for growth.
Only a tiny portion of the grid -- four four-way servers -- is apportioned now to the data warehouse. Much of it is devoted to running R.L. Polk's new Web-based applications, which both import data into the data warehouse from 260 discrete sources, such as car dealers or state licensing boards, and streams it out to paying customers, such as carmakers, car dealers and parts suppliers.
The data warehouse serves as R.L. Polk's "single source of truth" on a massive database that includes 500 million individual cars, or almost 85 percent of all cars in the world as of 2002. It also includes data on 250 million households and 3 billion transactions.
R.L. Polk cleanses the names and addresses of all incoming records, adds location data such as latitude and longitude, and, in the case of the 17-digit vehicle identification numbers unique to every car, extrapolates each car's individual features and styling. It's a complicated process, but as his team continues to tweak the Oracle grid engine, Vasconi expects to be able to shorten the importation time to less than 24 hours.
Looking forward, Vasconi said data already stored on vehicles' on-board computers -- such as engine-trouble history, GPS-based location history, average speeds and so on -- will soon be imported into the data warehouse, too, if privacy issues can be resolved.
"The car is a gold mine of consumer information," Vasconi said.
Computerworld Member Login
Prioritizing Services with IT Service Management (ITSM)
Computerworld Live Webinar
Wednesday 20th, August 2008
11:00am EST (Sydney, Australia)
To be repeated on:
Thursday 4th, September 2008
11:00am EST (Sydney Australia)
Sign up and receive a free copy of The Forrester WaveTM Service Desk Management Tools, Q2 2008 at the conclusion of the Webinar.
Attend and discover:
- How to deliver value to your business through ITSM
- Best practice ITSM implementation
- Why emphasis is changing from optimizing IT management processes to better servicing customers and demonstrating real dollar value
- If service-oriented ITSM is best for your business
- +
Computerworld Live Podcast #97: The Future of Enterprise Networking 25/07/2008 09:45:36
This week CW Live chats with Mark Thompson, global sales and marketing manager for HP ProCurve, on the future of the enterprise networking. Mark discusses the trends we can expect to see in the near future and how the right infrastructure can ensure your enterprise network is secure. - +
Computerworld Live Podcast #96: Security at the Edge 11/06/2008 09:22:22
CW Live speaks with Amol Mitra, HP ProCurve Director of Marketing for Asia Pacific and Japan. Today's topic: how enterprises are starting to shift away from simply controlling security via server logins, firewalls and moving to more adaptive security frameworks. - +
Data Management Edition #10: Multi-Petascale Systems 02/05/2008 09:12:33
This week we look at sustainability and the development of multicore technologies to build multi-petascale systems. - +
IT Security Edition #11: How to poison the Storm botnet 01/05/2008 08:51:55
This week CW Live presents a case study on how to poison the notorious Storm botnet . Plus we take a look at Cisco's plans for Ironport. - +
IT Security Edition #10: Cyber-battles fought and won 24/04/2008 11:09:47
Vendors bow to end user pressure to improve product security, and we take a look at the latest concepts shaping the cyber-battlefield of the future.
Viva la Verticals! Key to Vendor Growth is Through Vertical Market Opportunities, Says IDC 2008-09-05 11:05:00+10
F-Secure delivers fastest protection in the online world 2008-09-04 16:50:00+10
NETGEAR expands ProSafe team as business-class products take off in SME market 2008-09-04 16:27:00+10
Rogue security apps dominate Fortinet's Aug 2008 IT threat report 2008-09-04 16:00:00+10
Adaptec Intelligent Power Management Reduces Storage Power Consumption Up to 70 Percent 2008-09-04 11:28:00+10
Microsoft 2008 Mission Critical IT
To help you deploy the new Microsoft '08 technologies into your mission-critical environments, EMC and Microsoft have developed and validated a number of reference architectures. Discover the benefits of leveraging these skills.








