Kategoria BISAC: Computers >> Database Administration & Management

Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, SQL:1999 - Understanding Relational Language Components, which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant. This handy reference has a modular format so you can explore specific topics with ease. It is...

At 70 terabytes and growing, Wal-Mart's data warehouse is still the world's largest, most ambitious, and arguably most successful commercial database. Written by one of the key figures in its design and construction, Data Warehousing: Using the Wal-Mart Model gives you an insider's view of this enormous project. Continuously drawing from this example, the author teaches you the general principles and specific techniques you need to understand to be a valuable part of your organization's own data warehouse project, however large or small. You'll emerge with a practical...

Happy with your purchases? The retailer certainly is, and if you are too, you both can be said to be the beneficiaries of "customer intimacy" achieved through the transformation of data collected during this visit or stored from previous visits into real business intelligence that can be exercised in real time.

Data Warehousing and Business Intelligence for...

• Provides tutorial-based instruction in key JDBC techniques, complemented by example code.
• Centered...

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these...

-Explains how to model databases with Microsoft(R)...

Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis.This book provides a concise reference to the enormous store of information an...

This concise book contains detailed information about Oracle internals -- information that's not readily available to Oracle customers. It lays a foundation for advanced performance tuning of the Oracle database. Based on Oracle8i release 8.1, the book describes many of the secrets of Oracle's internal services: data structures, algorithms, and undocumented Oracle system statistics. Main topics include:

Waits - how Oracle processes communicate via semaphores, and how to use the Oracle wait statistics to identify the source of performance problems.Latches - how they keep...

This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution.SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL...

SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQLLoader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite...

* Describes the IBM WebSphere versions 4.0 and 5.0 architecture from a nuts and bolts level, giving visibility to the technology and underlying WebSphere platform design

* Describes how to proactively manage the performance of an IBM WebSphere v4 or v5 platform

* Thorough descriptions of tuning WebSphere with performance and robustness in mind

* Teaches the reader how to develop custom IBM WebSphere performance monitoring and management tools

* Presents an innovative, philosophical approach to Oracle database administration, and shows how to think about the whole complex problem of performance tuning, how to break it down, how to root out the cause of performance bottlenecks.

*Covers all practical aspects of Oracle performance tuning.

* Filled with hands-on lessons and accounts.

* Teaches an innovative and effective "Physician to Magician" approach, showing how to understand the problem, uncover the root cause, and choose and implement the most effective solution.