Christian Antognini “Troubleshooting Oracle Performance"
Apress | 2008-06-23 | ISBN: 1590599179 | 616 pages | PDF | 6,55 MB

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.
Written for developers by an application developer who has learned by doing
Gives a systematic approach to solving database application performance problems
Helps you plan for performance as you would for any other application requirement
What you’ll learn
See how to treat and plan for performance as a basic application requirement.
Identify performance problems using a systematic and repeatable approach.
Configure your query optimizer to meet your application performance goals.
Optimize table accesses, joins, and physical table layout.
Read and recognize inefficient SQL execution plans.
Reduce inefficiencies from too much procedural code.
Who is this book for?
For application developers and database administrators involved in troubleshooting performance problems of Oracle-based applications

Your in-depth guide to using the new Microsoft data mining standard to solve today's business problems

Concealed inside your data warehouse and data marts is a wealth of valuable information just waiting to be discovered. All you need are the right tools to extract that information and put it to use. Serving as your expert guide, this book shows you how to create and implement data mining applications that will find the hidden patterns from your historical datasets. The authors explore the core concepts of data mining as well as the latest trends. They then reveal the best practices in the field, utilizing the innovative features of SQL Server 2005 so that you can begin building your own successful data mining projects.

You'll learn:

• The principal concepts of data mining
• How to work with the data mining algorithms included in SQL Server data mining
• How to use DMX-the data mining query language
• The XML for Analysis API
• The architecture of the SQL Server 2005 data mining component
• How to extend the SQL Server 2005 data mining platform by plugging in your own algorithms
• How to implement a data mining project using SQL Server Integration Services
• How to mine an OLAP cube
• How to build an online retail site with cross-selling features
• How to access SQL Server 2005 data mining features programmaticall

About the Authors.

Credits.

Foreword.

Chapter 1: Introduction to Data Mining.

Chapter 2: OLE DB for Data Mining.

Chapter 3: Using SQL Server Data Mining.

Chapter 4: Microsoft Naïve Bayes.

Chapter 5: Microsoft Decision Trees.

Chapter 6: Microsoft Time Series.

Chapter 7: Microsoft Clustering.

Chapter 8: Microsoft Sequence Clustering.

Chapter 9: Microsoft Association Rules.

Chapter 10: Microsoft Neural Network.

Chapter 11: Mining OLAP Cubes.

Chapter 12: Data Mining with SQL Server Integration Services.

Chapter 13: SQL Server Data Mining Architecture.

Chapter 14: Programming SQL Server Data Mining.

Chapter 15: Implementing a Web Cross-Selling Application.

Chapter 16: Advanced Forecasting Using Microsoft Excel.

Chapter 17: Extending SQL Server Data Mining.

Chapter 18: Conclusion and Additional Resources.

Appendix A: Importing Datasets.

Appendix B: Supported VBA and Excel Functions.

Index.

Author(s) : Paul Nielsen
Publisher : Wiley
Year : Nov 2006
ISBN 10 : 0764542567
ISBN 13 : 9780764542565
Language : English
Pages : 1293
File type : PDF
Size : 14.9 MB (book + source code)

Like all books in the Bible series, you can expect to find both hands-on tutorials and real-world practical applications, as well as reference and background information that provides a context for what you are learning. However, to cover every minute detail of every command of this very complex product would consume thousands of pages, so it is the second goal of this book to provide a concise yet comprehensive guide to SQL Server 2005 based on the information I have found most useful in my experience as a database developer, consultant, and instructor. By the time you have completed the SQL Server 2005 Bible, you will be well prepared to develop and manage your SQL Server 2005 database.

Whether you are a database developer or a database administrator, whether you are just starting out, have one year of experience or five, this book contains material that will be useful to you. This book is written so that you can learn from my experience and the experience of the co-authors. Each chapter begins with the assumption that you’ve never seen the topic before, and then progresses through the subject, presenting the information that makes a difference.