Documenting Oracle Databases Complete Oracle database schema auditing

Authors:Mike Ault
Pages:102
Publisher:Unknow
ISBN13:9780974071664
Description:
Many times the Oracle DBA is hired once the database becomes to much to handle without one, inherits the position or is appointed to it “since they are so good with computers”. In any case, they usually get an undocumented system that follows no conventions and holds many traps for the unwary DBA.
In other situations the DBA may find they have the task of recreating the database for which they are responsible. If export and import can be used, this task is fairly easy to accomplish, however, sometimes the DBA will be required to provide DDL (Data Definition Language) for this purpose. The DBA may also wish to document existing procedures, views, constraints and such other structures as they see fit, with human readable output and a minimum of re-editing.
Download

Read more...

DB2 Universal Database v8 Handbook for Windows, UNIX, and Linux

Authors:Philip K. Gunning
Pages:496
Publisher:Unknow
ISBN13:9780130661111
Description:
Preface I wrote this book to provide you with the necessary knowledge with which to accomplish business objectives with DB2 UDB v8.1 for Windows, UNIX, and Linux. After all, as a developer or DBA, your primary mission is to accomplish business objectives by providing a database environment that provides the requisite performance, availability, and scalability required in today's demanding 24 7 highly competitive business environment. To that end, I have focused this book on key areas of DB2 UDB v8.1 that will enable you to meet those objectives. Some of the features covered are: the new Development Center, multidimensional clustering, online reorganization and online load, Type-2 indexes, tablespace enhancements, block-based bufferpools, tuning bufferpools, new commands and utility options, dynamic configuration parameters, autonomic computing features, write-to-table event monitors, SQL snapshot functions, QUIESCE command, and the database partitioning feature with new partitioning terminology updates. And, almost all new DB2 UDB v8.1 features and enhancements are covered in this book.
Download

Read more...

DB2 Universal Database V8 for Linux, UNIX, and Windows

Authors:George Baklarz, Bill Wong
Pages:912
Publisher:Unknow
ISBN13:9780130463883
Description:
Definitive preparation for Exam 704: DB2 UDB V8.1 Advanced Database Administration for Linux, UNIX, and Windows, which leads to an IBM Certified Advanced Database Administrator certification. Database design, performance monitoring and tuning, scaling for terabytes of data, high availability, enterprise-level security, and more. The appendices contain sample certification exam questions and answers. Whether you're a long-time DB2 UDB professional or an experienced DBA who's migrated from another database platform, there's one sure way to demonstrate the highest level of skills in DB2 Universal Database administration: pass the challenging IBM DB2 Universal Database Advanced Database Administration Exam 704.
Download

Read more...

DB2 Universal Database v8 Application Development

Authors:David Martineau, Steve Sanyal Kevin Gashyna Mich
Pages:432
Publisher:Unknow
ISBN13:9780130463913
Description:
You will find every skill and technique you need to build enterprise, Web, and eBusiness applications with DB2 UDB v8. This book is IBM's official guide to becoming an IBM Certified Application Developer for the DB2 Universal Database v8 Family.

New to the second edition is the inclusion of the information that you will need to prepare for the Fundamentals exam, a prerequisite to the Application Development exam. This section covers information about the DB2 products, tools, connectivity, data objects, manipulation, security, and concurrency.

Download

Read more...

Date on Database Writings 2000–2006

Authors:C. J. Date

Pages:568

Publisher:Apress

ISBN13:9781590597460

Description:

Date on Database: Writings 2000--2006 captures some of the freshest thinking from widely known and respected relational database pioneer C. J. Date. Known for his tenacious defense of relational theory in its purest form, Date tackles many topics that are important to database professionals, including the difference between model and implementation, data integrity, data redundancy, deviations in SQL from the relational model, and much more.

Download

Read more...