Ads by TechWords

See your link here
Receive the latest technology news and information.
Data Management
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
Cloud Computing
View all newsletters




Privacy Policy
 

Teradata beefs up data warehouse

October 1, 2002 12:00 PM ET

Computerworld - Business intelligence software vendor Teradata Corp. is upgrading its data warehouse product so companies can use it as a single enterprisewide data repository to support multiple analytical operations.
The company, a subsidiary of NCR Corp. in Dayton, Ohio, announced Teradata Warehouse Version 7.0 yesterday. Among the product's 150 enhancements are improved performance and a common interface for ease of use. Additionally, the new version will allow end users launching complex searches of a data warehouse to access the application at the same time as users doing more specific, smaller-scale queries, said Vickie Farrell, vice president of Teradata warehouse marketing.
That will allow customers to collapse smaller databases, also known as data marts, into a single Teradata warehouse and cut down on the cost of maintaining and synchronizing various business intelligence applications, she said.
Currently, the application permits a user to run a warehousewide, exhaustive query against historical data. Such "strategic" analytical operations might include an entire sales or marketing campaign. Version 7.0, on the other hand, will let users make more limited queries that could, for instance, be focused on one customer. It also allows current data, along with long-term historical information, to be integrated into a query.
For example, a fraud-detection application at a credit card company might in real time detect a transaction by a user and check that purchase against all other records in the database to determine if it is aberrant and indicative of potential theft, said Farrell.
Other enhancements include a load-balancing feature that can prioritize time-sensitive queries without slowing down the overall performance of the application. It can also partition chunks of related data -- such as monthly or weekly sales records -- and run queries on them on a single-server processor, which speeds performance. Normally, the data has to be distributed across processors equally, which is more time-consuming, Farrell said.
Those performance boosts sound particularly interesting to Dean Cox, manager of network planning and provision support at BellSouth Corp., an Atlanta-based telecommunications company. BellSouth currently runs a customized version R2 V5 of Teradata's warehouse, which helps it predict and avoid system outages during the network's peak usage time. Cox said the new data-joining feature will enable BellSouth to collapse historic, real-time and future predictions into a single query.
Teradata Warehouse Version 7.0 will be available in December. Pricing wasn't disclosed.



Jump to comments

Data Warehousing

Additional Resources

Xerox
By using solid ink technology only from Xerox, you could save up to 65% by printing color for the cost of black and white. Enter for a chance to WIN a PhaserTM 8860 network color printer!
Microsoft
Save time and mitigate security risk. Deploy it now.
Sybase
In this white paper, IDC analyzes the role of next-generation mobile enterprise platforms as organizations seek a more strategic deployment of mobile solutions.

Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.

White Papers & Webcasts

Handling Unpredictable Queries
Row-based DB Limitations  

Gaining the Performance Edge Using a Column-Oriented Database Management System
A Different Approach: Column-Oriented Data Management Systems  

Effectively Implementing Datacenter Automation
Effectively select and deploy the best datacenter automation solution today!

Aligning IT to Business: The Rising Importance of Application Delivery Networks
Application Delivery Networking (ADN) will play a vital role in helping enterprises incorporate strategic technologies to achieve business initiatives.

 

SAS Information Management Kit

SAS is the leader in business intelligence and analytical software and services. Only SAS offers leading data integration, storage, analytics and business intelligence applications within a comprehensive enterprise intelligence platform. SAS gives 97 of the top 100 companies in the 2007 Fortune 500 THE POWER TO KNOW®.

Webcast: The Information Management Roadmap
Imagine high-quality data, cleansed, analyzed and delivered throughout your organization. Join Computerworld, IT visionary Thornton May and a panel of experts to learn how SAS® can help you make it happen.

View this webcast 
Research Report: Information Management Initiatives at Midsize and Large Organizations
See the top-line results of this Computerworld sponsored survey to see how IT and business leaders are handling information management implementation.

Download this report 
White Paper: Information Management: Better Information for Winning Decisions.
This white paper explains how the SAS Information Evolution Model aids companies in assessing how they use this information to make strategic decisions and drive business.

Download this white paper