• Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copies
• Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process
• Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse
• Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality

The extract, transform, and load (ETL) phase of the data warehouse development life cycle is far and away the most difficult, time-consuming, and labor-intensive phase of building a data warehouse. Done right, companies can maximize their use of data storage; if not, they can end up wasting millions of dollars storing obsolete and rarely used data. Bestselling author Ralph Kimball, along with Joe Caserta, shows you how a properly designed ETL system extracts the data from the source systems, enforces data quality and consistency standards, conforms the data so that separate sources can be used together, and finally delivers the data in a presentation-ready format.

Serving as a road map for planning, designing, building, and running the back-room of a data warehouse, this book provides complete coverage of proven, timesaving ETL techniques. Beginning with a quick overview of ETL fundamentals, it then looks at ETL data structures, both relational and dimensional. The authors show how to build useful dimensional structures, providing practical examples of techniques.

Along the way you’ll learn how to:

• Plan and design your ETL system
• Choose the appropriate architecture from the many possible options
• Build the development/test/production suite of ETL processes
• Build a comprehensive data cleaning subsystem
• Tune the overall ETL process for optimum performance

Mongan and Suojanen take you step-by-step through the same problems that they were asked on technical interviews. These veterans use their experience with the technical interview process to prepare you for any situation. With their help, you’ll gain critical interviewing skills such as how to ask effective questions, how to best approach a problem, and what to do when you get stuck. Integrated throughout the book are problems

taken from real interviews at top computer companies, followed by an in-depth analysis and explanation of the thought process leading to solutions. By focusing on techniques and not just answers, you’ll be able to apply what you learn to the wide variety of problems you will face during an interview. The problems included in this book will challenge your programming skills and help you ace the programming interview! Problem types include:

• Programming problems with emphasis on data structures and recursion
• Logic puzzles, counting and measuring problems, and spatial reasoning
• Knowledge-based problems that cover today’s most important technologies

Visit our Web site at www.wiley.com/compbooks/

Moore suggests remedies for the problem that can help businesses meet their long-term goals. He coaches marketing professionals on how to move slowly through the gulf, teaching them to create profiles and target specific segments of the population rather than trying to plow right into the mainstream. He cites examples of successful chasm crossings by such companies as Apple, Tandem, Oracle, and Sun, showing what they all had in common and exposing the different weaknesses in their strategies. Moore also assigns responsibility for success to programmers and developers by suggesting they design a "whole product model." Here, because integration tasks are daunting to the mainstream market, all the components of a technological product must be in one package. Moore also describes strategies for competing with rival companies and assessing the best distribution channels for penetrating the target market.

Written not just for marketing specialists but for all employees whose futures ride on the success of a technical product, Crossing the Chasm delivers crucial information in an engaging, readable tone. --This text refers to an out of print or unavailable edition of this title.

Publisher Description
High-Tech marketing Expert Identifies the Greatest Challenge Facing New Ventures and Shows How to Address It

Every year, according to high-tech marketing expert Geoffrey Moore, millions of dollars invested in high-tech entrepreneurial ventures are lost trying to "cross the chasm" from early market success to mainstream market leadership. Moore, President of Geoffrey Moore Consulting, identifies and addresses the key challenges facing such ventures in the long-awaited paperback edition of Crossing the Chasm: How to Win Mainstream Markets for Technology Products

Targeted at venture capitalists, product managers, and tech marketers, Moore's book identifies a fundamental flaw in the standard high-tech marketing model, which postulates smooth sales growth through a series of well-defined, ever-larger markets. In fact, says Moore, there are really two, fundamentally separate phases in the development of any high-tech market: an early phase that builds from a few, highly visible, visionary customers; and a mainstream phase, where the buying decisions fall predominantly to pragmatists. Transitioning between these two phases is anything but smooth, and confidently assuming that success in the early market will translate into mainstream success is the fatal error that causes so many high-flying start-ups to crash into the chasm.

Crossing the Chasm grows from Moore's extensive consulting experience at Regis McKenna and at his own firm, working with hundreds of technology ventures struggling with these problems. The transition, he notes, is always perilous: typically, the new venture commits significant resources to modifications promised to secure its initial base of early market customers. The venture requires continued growth to support these commitments, growth into the lucrative mainstream markets. But these markets require a very different approach from that of the early visionaries; and if a company does not attack them properly, it will quickly fall short of projections and find itself in trouble. Moore's book presents specific strategies in marketing and all other areas of the business to help technology companies cross this critical chasm successfully. --This text refers to an out of print or unavailable edition of this title.

authors Luke Welling and Laura Thomson's technique aims to get readers going on their own projects as soon as possible. They present easily digestible sections on specific technical processes--"Accessing array contents" and "Using encryption with PHP" are two examples. Each section centers on a sample program that strips the task at hand down to its essentials, enabling the reader to fit the process into his or her own solutions as required. Tables that list options and other nuggets of reference material appear as well, but the many examples and the authors' commentary on them take center stage.

For reference material on MySQL, have a look at Paul DuBois's MySQL. On the PHP side, Web Application Development with PHP 4.0 is excellent. --David Wall

Topics covered:

• The MySQL database server (for both Unix and Windows)
• Accessing MySQL databases through PHP scripting (the letters don't really stand for anything)
• Database creation and modification
• PHP tricks in order of increasing complexity--everything from basic SQL queries to secure transactions for commerce
• Authentication
• Network connectivity
• Session management
• Content customization

We've taken the best and made it even better. The third edition of the best-selling PHP and MySQL Web Development has been updated to include material and code on MySQL 5, PHP 5 and on PHPs object model and validation. Through a clear, practical approach, you will learn to develop secure, dynamic websites by integrating and implementing the PHP scripting language and the MySQL database system. Real-world examples and working sample projects will give you a strong foundation on which to start building your own websites, complete with features such as SSL, shopping carts and payment systems. The accompanying CD includes the source code from each example in the book, the entire book in PDF format, and source code and binaries for PHP 5, MySQL 5 and Apache. Readers have called PHP and MySQL Web Development call it the best technical book they've ever read, but don't take their word for it. Find out for yourself!