Аннотация

"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues." -Aki Ratner, President, Precise Software Solutions Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of «performance tuning»– that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system–not just the database. High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system. The book provides practical solutions for: * Choosing physical layout for ease of administration and efficient use of space * Managing indexes, including detecting unused indexes and automating rebuilds * SQL and system tuning using the powerful new features in Oracle9i Release 2 * Improving SQL performance without modifying code * Running Oracle Real Application Clusters (RAC) for performance and availability * Protecting data using Recover Manager (RMAN), and physical and logical standby databases The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.

Аннотация

Packed with more than forty percent new and updated material, this edition shows business managers, marketing analysts, and data mining specialists how to harness fundamental data mining methods and techniques to solve common types of business problems Each chapter covers a new data mining technique, and then shows readers how to apply the technique for improved marketing, sales, and customer support The authors build on their reputation for concise, clear, and practical explanations of complex concepts, making this book the perfect introduction to data mining More advanced chapters cover such topics as how to prepare data for analysis and how to create the necessary infrastructure for data mining Covers core data mining techniques, including decision trees, neural networks, collaborative filtering, association rules, link analysis, clustering, and survival analysis

Аннотация

Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to * Build a layout that works * Create custom triggers and calculated fields * Generate reports automatically * Manage security * Publish your database on the Web * Embed pictures, sound, and video

Аннотация

Refocused and completely rewritten with the needs of business users and FileMaker Pro developers in mind, FileMaker Pro 9 Bible shows you how to design an industrial-strength database, make it intuitive, and automate it with scripts and programming. From the fundamentals to data modeling to writing no-fail code, you'll find the clear, step-by-step procedures, solid techniques, and detailed explanations you need to master this powerful software and build the right solutions for your needs.

Аннотация

If you run a small business, you know how important customer relationship management, or CRM, can be to your bottom line. And you know it can be a bit daunting. Well, not with GoldMine and GoldMine 8 For Dummies! GoldMine is business software designed to help you organize your contacts, track activities, schedule appointments, create reports that tell you how you’re doing, and make accurate business projections. GoldMine 8 is completely revised to make it more useful than ever, once you get the hang of it. That’s where GoldMine For Dummies comes to the rescue! Written by an authorized GoldMine trainer, this guide shows you how to: Set up GoldMine 8 and customize it for your business Create, view, and update customer records Schedule activities and manage leads Monitor your marketing efforts and see what’s working Predict sales based on past results Work with GoldMine’s e-mail system Organize and distribute information Access GoldMine from outside your office Integrate GoldMine with your company Web site Even if you’ve used a previous version of GoldMine, you’ll find some big changes in this newest revision, but GoldMine 8 For Dummies makes it easy to get up to speed. When you’ve read this book and discovered how GoldMine can help you keep track of your clients, reduce costs, and improve efficiency, you’ll think you’ve hit the motherlode!

Аннотация

Create and modify databases and keep them secure Get up to speed on using T-SQL to store and manipulate data SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more. * Create queries to retrieve data * Ensure SQL Server security * Use Visual Studio(r) 2005 with SQL Server * Create tables, views, and indexes * Work with Common Language Runtime * Query XML data

Аннотация

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

Аннотация

This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Server 2005 and SQL Server 2000. These versions are old enough that there is little to no time spent on them except in passing. The book is oriented around developing on SQL server. Most of the concepts are agnostic to what client language you use although the examples that leverage a client language general do so in C#. For those who are migrating from early versions of SQL Server, some “gotchas” that exist any time a product has versions are discussed to the extent that they seem to be a genuinely relevant issue. This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused. While there is a quick reference-oriented appendix, there is very little coverage given to beginner level topics. It is assumed that you already have experience with data manipulation language (DML) statements and know the basics of the mainstream SQL Server objects (views, stored procedures, user defined functions, etc.). If you would like to brush up on your knowledge before diving into this book, the author recommends reading Beginning SQL Server 2008 Programming first. There is very little overlap between the Beginning and Professional books and they are designed to work as a pair.

Аннотация

If you've not programmed with Transact-SQL, this book is for you.It begins with an overview of SQL Server query operations and tools used with T-SQL, and covers both the 2005 and 2008 releases of SQL Server query tools and the query editor. The book then moves to show you how to design and build applications of increasing complexity. Other important tasks covered include full text indexing, optimizing query performance, and application design and security considerations. The companion website also provides all of the code examples from the book.

Аннотация

A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear. Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, it’s so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports you’ll need most often, including how to: Pull specific information from your database, sort and group it, and find the details you need Use dynamic or cascading prompts Troubleshoot and print reports and save time with templates View reports on your LAN Write formulas to retrieve specific information Create and update OLAP reports Format reports, control page breaks, and even add graphics or Flash files Enhance your reports with charts and maps Use Crystal Reports in the enterprise There’s also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side, you’ll soon be able to create reports from simple to spectacular, whenever the need arises.