The complete guide to building tomorrow’s CRM-focused data warehouses. A complete methodology for building CRM-focused data warehouses Planning, ROI, conceptual and logical models, physical implementation, project management, and beyond For database developers, architects, consultants, project managers, and decision-makers Today’s next-generation data warehouses are being built with a clear goal: to maximize the power of Customer Relationship Management. To make CRM-focused data warehousing work, you need new techniques, and new methodologies. In this book, Dr. Chris Todman one of the world’s leading data warehouse consultants delivers the first start-to-finish
methodology for defining, designing, and implementing CRM-focused data warehouses. Todman covers all this, and more: Critical design challenges unique to CRM-focused data warehousing A new look at data warehouse conceptual models, logical models, and physical implementation The crucial implications of time in data warehouse modeling and querying Project management: deliverables, assumptions, risks, and team-building including a full breakdown of work Estimating the ROI of CRM-focused data warehouses up front Choosing software for loading, extraction, transformation, querying, data mining, campaign management, personalization, and metadata DW futures: temporal databases, OLAP SQL extensions, active decision support, integrating external and unstructured data, search agents, and more If you want to leverage the full power of your CRM system, you need a data warehouse designed for the purpose. One book shows you exactly how to build one: Designing Data Warehouses by Dr. Chris Todman.

“For the novice, this book gives sage advice on the performance issues
of SQL-level logical database design that cuts across all systems. For
me at least, the physical database design was particularly interesting,
because the book presents the implications of design choices on IBM,
Oracle, and Microsoft systems. These systems are quite different
internally, and the book’s example will surprise even the systems’
implementers.”
�Jim Gray, Microsoft

“Shasha
and Bonnet prove the value of applying timeless principles to
everchanging technology. The unique wealth of practical ideas, facts,
and examples equip database practitioners “in the trenches” like no
other resource. Chapter 2 alone is worth the price of the book.”
�Bob Badour, Online Curmudgeon

Database Management Systems provides comprehensive and up-to-date
coverage of the fundamentals of database systems. Coherent explanations
and practical examples have made this one of the leading texts in the
field. The third edition continues in this tradition, enhancing it with
more practical material. The new edition has been reorganized to allow
more flexibility in the way the course is taught. Now, instructors can
easily choose whether they would like to teach a course which
emphasizes database application development or a course that emphasizes
database systems issues. New overview chapters at the beginning of
parts make it possible to skip other chapters in the part if you don’t
want the detail. More applications and examples have been added
throughout the book, including SQL and Oracle examples. The applied
flavor is further enhanced by the two new database applications
chapters.

Databases are now an integral part of the internet and many web sites
use databases in the background to control their content. MySQL is one
of the most commonly used open source database management systems. Due
to itas bundling with PHP, MySQL has proved a popular choice for many
sites as it enables a database driven, content managed website to be
set up with little or no software costs. This book will show you how to
design and use databases for the web using MySQL as a tool to learn
SQL. Key Topics Installing and testing MySQL SQL basics, and using SQL
to communicate with databases Database design techniques and concepts
Using MySQL with PHP, Apache and Perl How to make other products
communicate with MySQL Features and Benefits. Gives an insight into how
databases work in relation to the web. Introduces general SQL
techniques by means of MySQL. Explains the concepts behind a structured
query language and how it can be used to communicate with databases.
Provides an introduction to database design and how an efficiently
designed database can improve the performance of MySQL.

With more than three million users, MySQL is the most popular open-source
database server in the world, providing an extremely fast, reliable, and inexpensive
alternative to commercial database management systems
Gives corporate users a complete guide to building enterprise-level database
applications with MySQL
Covers the pros and cons of adopting MySQL and installing, testing, and
configuring the MySQL server
Written by one of the lead programmers of the MySQL product and reviewed
by Monty Widenius, the creator of MySQL
Companion Web site includes all code examples as well as links to useful
online resources

Whether building a relational, object-relational, or object-oriented
database, database developers are increasingly relying on an
object-oriented design approach as the best way to meet user needs and
performance criteria. This book teaches you how to use the Unified
Modeling Language-the official standard of the Object Management
Group-to develop and implement the best possible design for your
database.

Inside, the author leads you step by step
through the design process, from requirements analysis to schema
generation. You’ll learn to express stakeholder needs in UML use cases
and actor diagrams, to translate UML entities into database components,
and to transform the resulting design into relational,
object-relational, and object-oriented schemas for all major DBMS
products.

* Teaches you everything you need to know to design, build, and test databases using an OO model.
* Shows you how to use UML, the accepted standard for database design according to OO principles.
* Explains how to transform your design into a conceptual schema for relational, object-relational, and object-oriented DBMSs.
*
Offers practical examples of design for Oracle, SQL Server, Sybase,
Informix, Object Design, POET, and other database management systems.
*
Focuses heavily on re-using design patterns for maximum productivity
and teaches you how to certify completed designs for re-use.

MySQL: Designing User Interfaces starts by introducing the
functionality of GTK+ and how to migrate from Microsoft’s Visual Basic.
It then introduces MySQL as a simple, fast, reliable database for
corporate applications.

The book then flows into the how-to of
combining GTK+ and MySQL through the coverage of the C API for MySQL
because it is the “backend” to a GTK+ application. It then expands its
coverage and teaches about heterogeneous network and deployment issues,
as well as migration from existing systems to MySQL.

Relational databases are powerful tools for organizing data, but learning to use them effectively can be painful. Relational Database Design for Mere Mortals
explains the concepts of relational-database design in an
easy-to-digest fashion that covers both the theoretical underpinnings
and their practical implications. Hernandez covers all the
basics–table and field structure, keys, relationships, business rules,
and more–but always keeps his feet on the ground with advice for
real-world implementations and a particularly strong section on
analyzing your current database infrastructure.

25 proven patterns for improving data access and application
performance Efficient, high-quality data access code is crucial to the
performance and usability of virtually any enterprise application–and
there’s no better way to improve an existing system than to optimize
its data access code. Regardless of database engine, platform,
language, or application, developers repeatedly encounter the same
relational database access challenges. In Data Access Patterns, Clifton
Nock identifies 25 proven solutions, presenting each one in the form of
a clear, easy-to-use pattern.

These patterns solve an
exceptionally wide range of problems including creating efficient
database-independent applications, hiding obscure database semantics
from users, speeding database resource initialization, simplifying
development and maintenance, improving support for concurrency and
transactions, and eliminating data access bottlenecks.

Every
pattern is illustrated with fully commented Java/JDBC code examples, as
well as UML diagrams representing interfaces, classes, and
relationships. The patterns are organized into five categories:

• Decoupling Patterns: Build cleaner, more reliable systems by decoupling data access code from other application logic
• Resource Patterns: Manage relational database resources more efficiently
• Input/Output
  Patterns: Simplify I/O operations by translating consistently between
  “physical” relational data and domain object representations of that
  data
• Cache Patterns: Use caching strategically, to optimize the tradeoffs between data access optimization and cache overhead
• Concurrency Patterns: Implement concurrency and transactions more effectively and reliably

Applied ADO.NET: Building Data-Driven Solutions provides extensive coverage of ADO.NET technology including ADO.NET internals, namespaces, classes, and interfaces. Where most books cover only SQL and OLE DB data providers, Mahesh Chand and David Talbot cover SQL, OLE DB, ODBC data providers and the latest additions to ADO.NET: Oracle, MySQL, and XML .NET data providers. Chand and Talbot also cover internals of data binding and they provide detailed coverage on both Windows Forms and Web Forms data binding and data-bound controls. Since XML plays a major role in .NET development, the authors also provide a comprehensive look at XML namespaces and classes, and how to integrate both with ADO.NET.

Applied ADO.NET: Building Data-Driven Solutions begins with the basics of ASP.NET and data-bound controls. It then delves into internals of data binding and shows how to use DataGrid, DataList, and other data-bound controls in real-world applications. Chand and Talbot also discuss the ASP.NET guest book, database XML Web services, and even an online bookstore site development and design process.

Advanced developers will learn from the coverage of ADO.NET architecture, related design issues, and how ADO.NET data
providers are designed. The authors also show how to create a Custom Data Provider. Event handling, server side programming, data relations and constraints, Active Directory, messaging, exception and error handling, and object relational model are other topics covered in detail.