Microsoft SQL Server 2000 Unleashed, 2E offers a variety of
topics for system and database administrators to help them learn new
features of the product and to solve problems they face on a daily
basis. It shows them how to build upon their working knowledge of the
product and take their experience and knowledge to a higher level. This
new edition of Microsoft SQL Server 2000 Unleashed covers the
latest updates and service packs to SQL Server 2000, including full
support for XML, notification services, and SQL Server CE.

MySQL has proved it can compete with the big names in database
management, such as SQL Server and Oracle, and with MySQL 4 this is
truer than ever. Mastering MySQL 4 is your one-stop resource for all
the information you need to create, maintain, use, and extend a MySQL
database. It’s also essential reading for anyone developing database
applications in a MySQL environment. If you’re new to MySQL, this is a
great way to get up and running–fast. If you’re upgrading, it will
help you get all you can out of new features and support. Coverage
includes:
* Installing MySQL
* Adding, removing, and updating records
* Choosing appropriate table types
* Choosing appropriate data types
* Optimizing MySQL queries
* Designing a database
* Normalizing table structure
* Maintaining and repairing databases
* Backing up and replicating data
* Managing user permissions and security
* Optimizing the MySQL server
* Extending MySQL
* Developing database applications

The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is
the only guide with coverage of both the basics and advanced topics,
including reliability, performance, optimization and tuning for MySQL.
This clear, concise and unique source for the most reliable MySQL
performance information will show you how to:

• Deploy the right MySQL product for your performance needs.
• Set up a performance management and monitoring environment using tools from MySQL.
• Implement the right indexing strategy
• Apply good performance strategy when developing software to work with the MySQL database.
• Configure dozens of variable to correctly tune the MySQL engine.

If
you deal with the intricacies and challenges of advanced MySQL
functionality on a daily basis, you will be able to build on your
knowledge with author Robert Schneider’s real-world experiences in MySQL Database Design and Tuning.

Joe Celko’s Trees and Hierarchies in SQL is an intermediate to
advanced-level practitioners guide to mastering the two most
challenging aspects of developing database applications in SQL. In this
book, Celko illustrates several major approaches to representing trees
and hierarchies and related topics that should be of interest to the
working database programmer. These topics include hierarchical encoding
schemes, graphs, IMS, binary trees, and more. This book covers SQL-92
and SQL:1999.

� Includes graph theory and programming techniques.
� Running examples throughout the book help illustrate and tie concepts together.
� Loads of code, available for download from www.mkp.com.

Do you need an introductory book on data and databases? If the book is by Joe Celko, the answer is yes. Data and Databases: Concepts in Practice
is the first introduction to relational database technology written
especially for practicing IT professionals. If you work mostly outside
the database world, this book will ground you in the concepts and
overall framework you must master if your data-intensive projects are
to be successful. If you’re already an experienced database programmer,
administrator, analyst, or user, it will let you take a step back from
your work and examine the founding principles on which you rely every
day-helping you to work smarter, faster, and problem-free.

Whatever
your field or level of expertise, Data and Databases offers you the
depth and breadth of vision for which Celko is famous. No one knows the
topic as well as he, and no one conveys this knowledge as clearly, as
effectively-or as engagingly. Filled with absorbing war stories and
no-holds-barred commentary, this is a book you’ll pick up again and
again, both for the information it holds and for the distinctive style
that marks it as genuine Celko.

* Supports its extensive conceptual information with example code and other practical illustrations.
*
Explains fundamental issues such as the nature of data and data
modeling, and moves to more specific technical questions such as
scales, measurements, and encoding.
* Offers fresh, engaging
approaches to basic and not-so-basic issues of database programming,
including data entities, relationships and values, data structures, set
operations, numeric data, character string data, logical data and
operations, and missing data among others.
* Covers the conceptual foundations of modern RDBMS technology, making it an ideal choice for students.

Improve functionality and develop robust SQL Server applications with
confidence using this collection of pre-written solutions. Best-selling
programming author Greg Buczek brings you the most authoritative and
useful collection of expert techniques and ready-to-use applications
available.

Focused on the latest research on text and document management, this
guide addresses the information management needs of organizations by
providing the most recent findings. How the need for effective
databases to house information is impacting organizations worldwide and
how some organizations that possess a vast amount of data are not able
to use the data in an economic and efficient manner is demonstrated. A
taxonomy for object-oriented databases, metrics for controlling
database complexity, and a guide to accommodating hierarchies in
relational databases are provided. Also covered is how to apply
Java-triggers for X-Link management and how to build signatures.

MySQL is a popular and robust open source database product that
supports key subsets of SQL on both Linux and Unix systems. MySQL is
free for nonprofit use and costs a small amount for commercial use.
Unlike commercial databases, MySQL is affordable and easy to use. This
book includes introductions to SQL and to relational database theory.
If you plan to use MySQL to build web sites or other Linux or Unix
applications, this book teaches you to do that, and it will remain
useful as a reference once you understand the basics. Ample tutorial
material and examples are included throughout. This book has all you
need to take full advantage of this powerful database management
system. It takes you through the whole process from installation and
configuration to programming interfaces and database administration.
This second edition has a greatly enhanced administration chapter that
includes information on administrative tools, server configuration,
server startup and shutdown, log file management, database backup and
restore, and database administration and repair. In addition, a new
chapter on security describes data, server, and client-server security,
while a chapter on extending MySQL provides an overview of MySQL
internals and describes the use of MySQL user-defined functions. If you
know C/C++, Java, Perl, PHP, or Python, you can write programs to
interact with your MySQL database. In addition, you can embed queries
and updates directly in an HTML file so that a web page becomes its own
interface to the database. Managing and Using MySQL includes chapters
on the programming language interfaces, and it also includes a complete
reference section with specific function calls for each language. Also
included in the reference section are references to the SQL language,
and details of the MySQL system variables, programs, and utilities. New
to the second edition is a reference to the internal MySQL tables,
which will be of particular interest to those who want to work
extensively with MySQL security.

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