Dileep Mohan

Oct 10 2011

New Teradata Products- Teradata Partners Conference 2011

 

This blog is about some (relatively) new products exhibited at the Teradata Conference. These tools add a lot of value a) by eliminating the use of 3rd party tools or manual interventions(Teradata Unity/Data Mover) b) providing better integration (OLAP Connector) c) and providing better performance (Columnar option).

Teradata Unity: Teradata Unity maintains a single view of data across Teradata systems and solves the issue of DDL execution or updates in DEV/QA/PROD or other instances separately.  Teradata Unity also delivers query routing, database synchronization, and data synchronization across multiple Teradata systems through a single product.

Teradata Data Mover: Teradata Data Mover is a utility designed specifically to copy data and objects such as tables and statistics from one Teradata system to another.

Read More

Oct 06 2011

2011 Teradata Partners Conference Day 4 and 5

On day 4 I attended an interesting session  “Enabling the Bank of America Analytical Ecosystem“ by Bob Nicholson, Senior Vice President Technology at Bank of America. Bob talked about the very complex analytical ecosystem at Bank of America with around 6000 databases, 3300 users and greater than 2 petabytes of data. In order to have a strategic approach to disaster recovery a Resilency Hub was created (a backup and archive of production). using Teradata Data Mover. Bank of America had 43 TB data in 2002 and today the ecosystem  has 626 TB of data.  Bob also explained how the data from hub is fed to other systems. After the session I asked Bob whether Bank of America thinks Cloud Storage will play a role in their ecosystem. Bob mentioned that BofA is already having high utilization so he does not forsee cloud storage and was also concerned about security.

Read More

Oct 06 2011

2011 Teradata Partners Conference Day 3

The first session I attended on day 3 of the conference was “How to Identify Inefficient Queries and Fix Them” by Dirk Anderson, Bank of America. Dirk showed different metrics to identify inefficient queries primarily-CPU Skew, IO Skew, Product Joins, spool usage and query execution time journaling. Dirk also talked about Teradata Utlities. BTEQ is okay up to 5,000 rows; TPUMP up to 75,000 (depends on record length); Multiload for bulk-loading; Fastload for loading empty tables with > 10GB. Dirk also provided SQL tuning queries during this session.

The second session I attended was “Taking a Data-Rich Executive Dashboard from Desktop to Mobile” by Jeff Bamhart, Sabre Holdings. Sabre Holdings is a travel technology company which owns Travelocity, Sabre Travel Network and Sabre Airline Solutions. Jeff talked about the airline industry and the ever growing demands of corporate information.

Read More

Oct 04 2011

2011 Teradata Partners Conference Day 2

The second day of the 2011 Teradata Partners Conference started with Teradata business leaders talking about how the company is growing and investing . Mike Koehler, Teradata's CEO, described the new line of products, in particular ClaraView, Aprimo and Asterdata. Mike showed some quick statistics on the explosion in digital data from mobile, social, and sensor. The trends which  really drove his point were the increase in the Teradata’s Peta Byte Club and the 2011 IDC Digital Universe Study (sponsored by EMC) showing that in 2011 1.8 ZettaBytes (1.8 Trillion GigaBytes) of information will be created and replicated.

This was closely followed by Steven Levitt's session. The author of popular books "Freakonomics" and "Superfreakonomics," described his moments of truth in learning calculus and other interesting facts .

Read More

Oct 03 2011

2011 Teradata Partners Conference Day 1

Day 1 of the 2011 Teradata Partners User Group Conference and Expo at San Diego was very educational and I had the opportunity to listen to some very good sessions. During the morning session, I attended a  workshop on “Teradata Live”, an End to End demo by Lance Miller from Teradata. This demo was done on a 8GB Memory,2TB, TD 13.10,4AMP configuration. Lance showed a logical data model for retail customers and the data distribution for 150 million row sales table. He pulled the Teradata Administrator view and showed how the data was evenly distributed on 4 amps. Lance also demonstrated the Teradata Miner 5.0  which is used for data profiling. During this session I asked a question on whether they have any data to support benchmarks against competitors either IBM's Netezza or Oracle Exadata.

Read More

 

Disclaimer

The words and opinions expressed here are those of each article's respective author, and do not necessarily represent the views of CapTech Ventures.