Tech2Tech
Awards
Teradata R&D
Excellence Awards 2010
The R&D Excellence Awards recognize Teradata associates for innovative ideas and achievements that lead to significant advances and improvements for Teradata and its customers. Congratulations to the Outstanding Award winners for 2010!
Character-Based Partitioning
Mark Sirek, Software Engineer
A key feature of Teradata 13.0, character-based partitioning allows customers to take advantage of the grouping capabilities of partitioning for their key values that contain characters (account numbers, part numbers, etc.). Grouping data together in a table can improve query performance.
DBS Infrastructure for Fastpath Functions
Gregory Milby, Software Engineer
User-defined functions (UDFs) are a key facility for delivering new functionality within Teradata systems. Making frequently used UDFs into Fastpath functions will provide a significant performance increase for the applications using them and will allow more of these new applications to be implemented.
Haster Web Services Framework
Haseem Kheiri, Software Engineer
A mechanism was needed to allow Web service connections from partner products to Teradata Relationship Manager. The HASTER Web Services Framework was developed to let Teradata Relationship Manager integrate with partner tools and deliver customers the functionality they required.
No Primary Index (NoPI) Table
Jim Carlson, Software Engineer
Tam Ly,
Software Engineer
Dinesh Chengalpatu, Software Engineer
Teradata tables have always required a primary index whose hash is used to distribute data to all AMPs on the system, and each table has its data ordered by that hash on each AMP. The new NoPI tables break both of those rules and will provide a significant performance advantage for the bigger processes in which the tables will be used.
Optimizing business application Performance
by Leveraging Teradata Extensibility Features
Lorenzo Danesi, Technical Architect
The new architecture for Teradata Demand Chain Management will use the extensibility capabilities of UDFs. This will allow predictive algorithms into the warehouse, where the work can be done directly on the data without having to extract or reload results, thereby significantly improving performance.
Temporal Architecture and Design
Bhashyam Ramesh, Engineering Fellow
Paul Sinclair, Software Engineer
Manjula Koppuravuri, Engineering Manager
Loading and managing time-based data often takes special SQL skills to properly craft queries. This team’s innovation greatly simplifies the process for Teradata users.
XCI—Extreme Compression Initiative
Doug Frazier, Software Engineer
Ever-increasing data volumes strain the storage and I/O capacity of platforms and the budgets of many organizations. Using Teradata’s extensibility features, XCI applies different algorithms to compress data patterns and radically shrink space requirements while working within the customer’s existing environment.
Teradata Fellow Award
Donald Pederson, Software Engineer
The R&D leadership team recognizes Donald for contributing to every technical aspect of the Teradata software and product family for more than two decades. His invaluable contributions helped shape and formulate the Teradata platform and software stack into the finest enterprise data warehouse in the industry. And his innovation, leadership and tireless commitment to quality and performance are examples for all Teradata associates.