Search
Navigation
OakieTags
Who's online
Affiliations
Books
-
Applied Mathematics for Database Professionals
Book Cover:
This book is about the mathematical foundation of relational databases; it demonstrates how logic and set theory can be used as tools to formally specify database designs, including the data integrity constraints (a main topic of this book). Don't let this scare you of; the book explains the required mathematical concepts with many examples and should be accessible for the regular database professional. It does assume that you are familiar with designing a database.
You'll find three parts in this book:
- Part 1 provides the mathematics. It covers those parts of logic and set theory that are both necessary and sufficient to formally specify database designs and their constraints.
- Part 2 demonstrates the application of these subjects. It gradually develops the formal specification of a ten-table database design that includes over seventy data integrity constraints. You'll also find a treatment of formal query and transaction specification in this part.
- Part 3 is the Oracle specific part. You'll discover that due to poor support of declarative constraints, implementing these in today's SQL DBMS's still poses quite a few challenges. It demonstrates a method—based on database triggers—to implement (multi-row) constraints procedurally. This method has evolved for over 12 years; it is an efficient one and one that cannot be subverted.
It is important to understand the mathematical foundation of our database profession. The knowledge contained in this book will, in the end, enable you to better design and implement databases -
PeopleSoft for the Oracle DBA
Book Cover:
A PeopleSoft Survival Guide for DBAs and other technicians
A part of the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. It provides answers to common questions that arise when using PeopleSoft on an Oracle database.
The book begins with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Subsequent chapters explain database structures, connectivity, keys and indexing, the PeopleSoft DDL generation, tablespaces organisation, performance metrics, performance monitoring utilities, and SQL optimization techniques.
-
Troubleshooting Oracle Performance
Book Cover:
What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.
This book shows you how to do the following:- Identify performance problems using a systematic and repeatable approach.
- Configure the query optimizer to meet your application performance goals.
- Obtain and interpret execution plans as well as assess whether they are inefficient.
- Apply SQL tuning techniques such as hints, SQL profiles, stored outlines and SQL plan baselines.
- Minimize the impact of parsing without jeopardizing performance.
- Optimize data access, joins and the physical design.
- Improve performance through parallel processing, materialized views, and result caching.
This book is intended for performance analysts, application developers and database administrators who are involved in troubleshooting performance problems of applications based on the Oracle database engine.
No specific knowledge in optimization is required. However, readers are expected to have a working knowledge of the Oracle database engine and to be proficient with SQL.
-
Mastering Oracle PL/SQL: Practical Solutions
Book Cover:
This the first book of many to be published under the OakTable Press Label. The lead author, Connor McDonald is a respected member of the OakTable and is a well-known personality both on the Oracle speaker circuit and in online Oracle forums. This book is targeted primarily toward the DBA or developer charged with the implementation of effective data handling, security, and database administration mechanisms in the Oracle database. However, it will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL effectively.If you’re brand new to PL/SQL, then you’ll want to take some time to get familiar with the language before tackling this book
-
Expert One-on-One Oracle
Book Cover:
Tom Kyte's first book is packed with lots of Oracle insider knowledge including, among other topics, what the various Oracle server processes and files do, what's happening inside the database during a transaction, and the real meaning of the various options available in Oracle's DML and DDL SQL statements. The likely impact of design decisions on application behaviour and performance is also discussed, particularly where this relates to using, or not using, a database feature.
-
Effective Oracle by Design
Book Cover:
Tom Kyte has produced an excellent guide to building and designing high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. The tools required, optimizing database processes, statement processing and designing an effective schema are all covered.
-
Perl for Oracle DBAs
Book Cover:
Co written by Jared Still, Perl for Oracle DBA's is a must for your any DBA. Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable resource.
-
Oracle Backup & Recovery 101
Book Cover:
Co written by Stephan Haisley, Oracle Backup and Recovery 101 is ideal for anyone who is new to Oracle technoloy. New DBAs will see various methods for backup and recovery--including Recovery Manager (RMAN). There are hands-on exercises and end of chapter reviews.The book also teaches you how to perform server-managed backup and recovery using Oracle Recovery Manager (RMAN). Officially authorized by Oracle Corporation, this hands-on guide shows you everything you need to know to implement a basic backup and recovery plan for your Oracle database and includes full details on setting up a small sample database so you can practice the tasks covered throughout the book.
-
Oracle8: SQL Statement Tuning Workshop Student Guide
Book Cover:
This is a Dutch language book, and so here's a Dutch synopsis: Dit Leerboek Oracle SQL is in eerste instantie bedoeld voor het onderwijs op HBO-niveau; het is bestemd voor alle studierichtingen die Oracle als software-omgeving gebruiken voor het leren omgaan met relationele informatiesystemen en SQL. Het is met name geschikt als ondersteuning bij zelfstudie en/of practicum, en als zodanig ook heel goed individueel te gebruiken buiten het reguliere onderwijs.
-
Optimizing Oracle Performance
Book Cover:
Cary Millsap, lead author of Optimising Oracle Performance, dispenses with database-centric metrics and instead shows how to use Oracle's response time statistics to diagnose performance problems in an Oracle application system. Former VP of Oracle's System Performance Group, Cary Millsap, clearly shows how eliminating requests for unneeded work improves performance dramatically. He also shows how the mathematical discipline of queueing theory can be combined with response time metrics to accurately predict the impact of system changes and upgrades. This is the timesaving method Oracle DBAs and developers have been waiting for.
.png){kind=small}
TweetsPopular content
Today's:
Monthly archive
- September 2010 (35)
- August 2010 (140)
- July 2010 (91)
- June 2010 (93)
- May 2010 (96)
- April 2010 (145)
- March 2010 (155)
- February 2010 (44)
- January 2010 (71)
- December 2009 (52)
- November 2009 (38)
- October 2009 (41)
- September 2009 (30)
- August 2009 (14)
- July 2009 (14)
- June 2009 (17)
- May 2009 (20)
- April 2009 (24)
- March 2009 (31)
- February 2009 (15)
- January 2009 (14)
- December 2008 (5)
- November 2008 (7)
- October 2008 (6)
- September 2008 (5)
- August 2008 (6)
- July 2008 (5)
- June 2008 (6)
- May 2008 (4)
- April 2008 (3)
Recent comments
6 days 12 min ago
6 days 6 hours ago
3 weeks 5 days ago
11 weeks 5 days ago
14 weeks 5 days ago
19 weeks 1 day ago
19 weeks 1 day ago
19 weeks 3 days ago