downloadable book: Database

Showing posts with label Database. Show all posts

Showing posts with label Database. Show all posts

Friday, June 5, 2009

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

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

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

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.

Wednesday, June 3, 2009

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.

Database Programming with JDBC and Java, Second Edition

Authors:George Reese
Pages:328
Publisher:O'Reilly
ISBN13:9781565926165
Description:
This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and includes a set of patterns that separate the functions of the Java application and facilitate the growth and maintenance of an application. Database Programming with JDBC and Java recently won a Reader's Choice Special Mention Award from Visual Basic Programmers Journal. It was the only winner in the category of Java publications.
Download

Database Design Manual

Authors:Norman, Matthew

Pages:224

Publisher:Springer

ISBN13:9781852337162

Description:

MySQL is one of the most commonly used open source relational database management systems (RDBMS). Fully updated to include information on latest versions, this Springer book is becoming one of the most easily understandable texts on MySQL available. Norman does a good job . The text is liberally interspersed with examples of SQL . Windows users who need to set up MySQL will greatly appreciate this Database Design Manual book. The book is a thorough, yet easy to understand resource for beginners.

Database Design for Smarties

Authors:Robert J. Muller

Pages:442

Publisher:Unknow

ISBN13:9781558605152

Description:

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.

Database Design for Mere Mortals

Authors:Hernandez, Michael J.

Pages:611

Publisher:Addison Wesley

ISBN13:9780201752847

Description:

Topics covered: How to design databases that fit business requirements and make software construction easier. In addition to explaining relational database concepts, the author explains data integrity, null values, keys, table relationships (one-to-one, one-to-many, and many-to-many), and data types. He emphasizes processes designers should follow in building a new database or improving an existing one.

Tuesday, April 14, 2009

Advanced DBA Certification Guide and Reference for DB2

Authors:Dwaine R. Snow, Thomas Xuan Phan Dwaine Snow

Pages:600

Publisher:Unknow

ISBN-13: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.

Monday, April 13, 2009

Access Database Design and Programming, Second Edition

Authors:Steven Roman

Pages:429

Publisher:O'Reilly

ISBN-13:9781565926264

Description:

This second edition of the best-selling Access Database Design & Programming covers Access' new VBA Integrated Development Environment used by Word, Excel, and Powerpoint; the VBA language itself; Microsoft's latest data access technology, Active Data Objects (ADO); plus Open Database Connectivity (ODBC).

Access Database Design and Programming, 3rd Edition

Authors:Roman, Steven

Pages:425

Publisher:O'Reilly

ISBN-13:9780596002732

Description:

Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively.

Saturday, April 4, 2009

Oracle Database 11g The Complete Reference

Authors:Kevin Loney
Pages:1368
Publisher:McGraw-Hill Osborne Media
ISBN-13:978-0071598750
Description:
The Definitive Guide to Oracle Database 11g Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.
Install Oracle Database 11g or upgrade from an earlier version
Create database tables, sequences, indexes, views, and user accounts
Construct SQL statements, procedures, queries, and subqueries
Optimize security using virtual private databases and transparent data encryption
Import and export data using SQL*Loader and Oracle Data Pump
Use SQL replay, change management, and result caching
Avoid human errors using flashback and automatic undo management
Build and tune PL/SQL triggers, functions, and packages
Develop database applications using Java, JDBC, and XML
Optimize availability and scalability with Oracle Real Application Clusters

Download

Monday, March 30, 2009

Oracle Database 10g New Features

Authors:Robert G. Freeman
Pages:272
Publisher:Unknow
ISBN13:9780072229479
Description:
Here is an invaluable overview of all the cutting-edge features of Oracle?s latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru J .

Download

Designing Effective Database Systems

Authors:Rebecca M. Riordan
Pages:353
Publisher:Addison Wesley
ISBN13:9780321290939
Description:
Relational databases are tricky beasts. Other kinds of commercial software are infinitely easier to understand. Word processors are really just high-tech typewriters, and it's pretty clear that the backspace key beats that little jar of white stuff cold. Spreadsheets present a familiar enough paradigm, even to non-accountants, and email is close enough to the postal system for the model to be comprehensible. Databases are different. Other kinds of software have a real-world analogy. Sometimes, as in the Windows desktop, the analogy is a little tenuous, but the analogies are close enough; you can get there from here. But relational databases are completely artificial. They're like geometry: They can be used to build models of the real world, but they don't exist in the real world.
Download

Beginning Database Design

Authors:
Pages:
Publisher:
ISBN:
Description:
The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently

* Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle

* Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance

* Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements.

Applied Mathematics for Database Professionals

Authors:Lex de Haan, Toon Koppelaars
Pages:376
Publisher:Apress
ISBN:9781590597453
Description:

Relational databases hold data, right? They indeed do, but to think of a database as nothing more than a container for data is to miss out on the profound power that underlies relational technology. A far more powerful way of thinking lies in relational technology's foundation in the mathematical disciplines of logic and set theory.

Databases contain truths or propositions describing some area of interest such as a business. Those truths are organized into sets. Operations from logic and set theory can be applied to existing sets of truths to derive new sets of truths. Applied Mathematics for Database Professionals introduces you to this way of thinking, to the logic and set theory that underlies relational database technology. All this may sound abstract now, but there are profound benefits from the deeper understanding you'll gain from this book. You'll learn to

Become a better database designer. You'll make fewer mistakes, and your designs will be more flexible in response to changing data needs.
Use the expressive power of mathematics to precisely specify designs and business rules.
Communicate effectively about design using the universal language of mathematics.
Develop and write complex SQL statements with confidence.
Avoid pitfalls and problems from common relational bugaboos such as null values and duplicate rows.

MySQL Database Design and Tuning

Authors: Schneider, Robert D.
Pages: 414
Publisher:Unknow
ISBN: 9780672327650
Description:

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.

Oracle Database 10g SQL

Authors: Jason Price
Pages: 624
Publisher:Unknow
ISBN: 9780072229813
Description:
This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g

Download

The Relational Database Dictionary

Authors: Date, C. J.
Pages: 113
Publisher:O'Reilly
ISBN: 9780596527983
Description:
Avoid misunderstandings that can affect the design, programming, and use of database systems. Whether you're using Oracle, DB2, SQL Server, MySQL, or PostgreSQL, The Relational Database Dictionary will prevent confusion about the precise meaning of database-related terms (e.g., attribute, 3NF, one-to-many correspondence, predicate, repeating group, join dependency), helping to ensure the success of your database projects. Carefully reviewed for clarity, accuracy, and completeness, this authoritative and comprehensive quick-reference contains more than 600 terms, many with examples, covering issues and concepts arising from the relational model of data.
Download

Subscribe to: Posts (Atom)