Cost-Based Optimization: Obtaining the Best Execution Plan for Complex Queries*
Sunday, September 18, 2005
8:00am – 12:30pm
Optimizer choices in determining the execution plan for complex queries are a dominant factor in the performance delivery for a data warehouse environment. The goal of this workshop is to de-mystify the inner workings of cost-based optimization for complex query workloads. We will discuss the differences between rule-based optimization and cost-based optimization with a focus on how a cost-based optimization enumerates and selects among possible execution plans for a complex query. The influences of parallelism and hardware configuration on plan selection will be discussed along with the importance of data demographics. Advanced statistics collection will be discussed as the foundational input for decision-making within the cost-based optimizer. Performance characteristics and optimizer selection among different join and indexing opportunities will also be discussed with examples. The inner workings of the query rewrite engine will be described along with the performance implications of various rewrite strategies.
Workshop Leader:
Stephen Brobst
Chief Technical Officer
Teradata, a division of NCR
Stephen Brobst is the Chief Technology Officer for Teradata, a division of NCR Corporation. He is widely regarded as the foremost expert in data warehousing and joined Teradata in October of 1999. Prior to joining Teradata, Brobst successfully launched three start-up companies related to high-end database products and services in the data warehousing and e-business marketplaces: Tanning Technology Corporation (TANN on NASDAQ), Nextek Solutions (acquired by IBM), and Strategic Technologies & Systems (acquired by NCR). Previously, Brobst taught graduate courses at Boston University and the Massachusetts Institute of Technology in both the MBA program at the Sloan School of Management and in the Computer Science departments of both universities. He received the instructor of the year award for two of his last five years in the MET Computer Science department at Boston University and continues to guest lecture frequently at the Massachusetts Institute of Technology and the Kellogg Graduate School of Management. Brobst has authored numerous journal and conference papers in the fields of data management and parallel computing environments and is an internationally recognized practitioner in the area of breakthrough systems implementation. He recently co-authored a book, Building a Data Warehouse for Decision Support. He has published dozens of technical articles. Brobst has been on the faculty of the Data Warehousing Institute since 1996 and teaches courses related to Active Data Warehousing and High Performance Data Warehouse Design.
Accelerating the Value of The Data Warehouse*
Sunday, September 18, 2005
8:00am – 12:30pm
The numerous challenges of today’s dynamic decision-making world require vast amounts of information and support to provide effective business performance and increase profitability. Most data warehouses are quickly maturing into mission-critical or creative decision-making resources. This workshop will provide you with enhanced opportunities and easier methods to gain support for your DW using processes, models and examples.
Learn how leading companies around the world are strategizing, acting upon, and deploying integrated decision support systems to reduce costs, grow their revenues, and gain new knowledge of customer needs.
Join Ron Swift as he describes with business models and frameworks, the actions required to put the theory into practice. Key points to be covered include:
Defining a strategy and framework for both business and technology information management
Understanding the maturation cycles and events that change what you do with information
Managing integration and synchronization of cross-organizational business needs
Understanding the development of essential methods for gaining support
Increasing the value of data mart consolidation
Developing focus points from other companies in your and other industries
Driving more effective financial reporting and decision-making
Workshop Leader:
Ronald S. Swift
Vice President
Teradata, a division of NCR
Ron Swift is an internationally-known consultant, strategist, implementer, and educator with more than 35 years of experience in information-driven business improvements. Swift specializes in the areas of Decision Support, Analytical Systems, Data Warehousing, Customer Relationship Management, and Strategic Enterprise-wide Solutions. Swift is a popular and thought-provoking speaker at conferences and executive management sessions for the world's leading companies. In his role as Vice President, Strategic Customer Relationships for Teradata, Swift provides prescriptive and facilitative strategies and counseling for executives and researchers on information-driven business improvements. Prior to joining AT&T/NCR and Teradata in 1996, Swift was a senior partner with an international consulting firm, following a successful 22-year career at IBM. He has worked with numerous firms which have utilized data warehousing and analytical applications to create and grow measurable business value. He also lectures for several top-rated graduate business schools, and serves on the Board of Trustees for The Marketing Science Institute where his mission is to drive pragmatic insight into academic theories and business disciplines. Ron Swift is the author of a highly-rated and informative CRM-pioneering book, Accelerating Customer Relationships: Using CRM and Relationship Technologies, and writes white papers and articles appearing in high-circulation business and technology publications.
Teradata "101": Building An Enterprise Data Warehouse With Teradata*
Sunday, September 18, 2005
8:00am – 12:30pm
This workshop is intended to provide participants with an understanding of the value of data warehousing, the impact it can have on an organization, what "differentiates" Teradata as the best infrastructure and why Teradata is best suited to be the "intelligence engine" for the enterprise. The workshop is organized in three interlocking sessions:
Learn how leading companies around the world are strategizing, acting upon, and deploying integrated decision support systems to reduce costs, grow their revenues, and gain new knowledge of customer needs.
1. Enterprise Data Warehousing
The first part of the workshop is a vendor-neutral opportunity to learn about the value of enterprise data warehousing, the impact it can have on an organization, and how to successfully build an enterprise data warehouse. An enterprise data warehouse is much more than the sum of its parts. The process of building it includes many other important aspects like aligning the needs and demands of business people and IT people within the organization, or identifying previously unknown or unseen business threats or opportunities. The workshop will provide a list of practical "guiding principles for data warehousing" and a list of "pitfalls" to avoid.
2. Teradata "101"
The second part of the workshop provides details on the unique differentiators that quality Teradata as the "best in class" technology infrastructure for enterprise data warehousing.
3. Enterprise "Fit"
The third and final part of the workshop provides an overview of active data warehousing and how Teradata works within a Services-Oriented Architecture, called Teradata’s Real-Time Enterprise Reference Architecture, to enable an organization to leverage Teradata as the “analytical engine” to support all decision-making throughout the enterprise.
You cannot have an effective knowledge management environment without a robust data warehousing architecture. Come learn how to build a data warehouse with Teradata.
Workshop Leader:
Dan Higgins
Director
Teradata, a division of NCR
Dan Higgins is a Director with Teradata and leads a team of experienced Teradata and data warehousing subject matter experts who provide technical support to Teradata’s field organization. He has had a 30 year career in information technology including numerous data warehouse design and development projects, data modeling, system and software engineering, IT architecture, and IT management roles for Boeing Computer Services, TRW, Lockheed Martin and the former U. S. West Communications. Dan was a customer of Teradata in the late 1980’s, a Senior Teradata Professional Services Consultant and Partner in the early 1990’s and after 4 years with a large telecommunications company returned to Teradata in 1999. Dan is a coauthor of "Evolving Through Action", a book on data warehousing wisdom.
*Workshops—Open to all registered attendees as a value-added benefit.
|
