Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 11g Performance Tuning Recipes delivers. Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter's domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it's performance-related, you'll probably find a recipe and a solution in this book. Provides proven solutions to real-life Oracle performance problems Offers relevant background and theory to support each solution Written by a team of experienced database administrators successful in their careers

Information systems --- database management

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Expert Indexing in Oracle Database 11g is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer. Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Indexing in Oracle Database 11g helps by bringing together information indexing and how to use it into one, convenient and blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indices available and when each is best applied. Recognize when queries aren't using indices as you intend. Manage your indexing for maximum performance. Let Expert Indexing in Oracle Database 11g be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database. Explains how indices work, how they help, and how they hinder Demystifies the various index choices Describes the database administration chores associated with indices

Information systems --- database management

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Research has deeply investigated several issues related to the use of integrity constraints on relational databases. In particular, a great deal of attention has been devoted to the problem of extracting "reliable" information from databases containing pieces of information inconsistent with regard to some integrity constraints. In this manuscript, the problem of extracting consistent information from relational databases violating integrity constraints on numerical data is addressed. Aggregate constraints defined as linear inequalities on aggregate-sum queries on input data are considered. The notion of repair as consistent set of updates at attribute-value level is exploited, and the characterization of several data-complexity issues related to repairing data and computing consistent query answers is provided. Moreover, a method for computing reasonable  repairs of inconsistent numerical databases is introduced, for a restricted but expressive class of aggregate constraints. An extension of this method for dealing with the data repairing problem in the presence of weak aggregate constraints which are expected to be satisfied, but not required to, is presented. Furthermore, a technique for computing consistent answers of aggregate queries in the presence of a wide form of aggregate constraints is provided. Finally, extensions of the framework as well as several open problems are discussed.

Information systems --- database management

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Pro SQL Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own custom policies to enforce consistent rules across your organization. Provides in-depth treatment of policy-based management in a single source Provides practical usage scenarios for policy-based management Provides guidance to help meet growing regulatory compliance needs

Information systems --- database management

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

ICOODB 2009 was the second in a series of international conferences aimed at promoting the exchange of information and ideas between members of the objectdatabasecommunity. A keyfeatureof the conferencewasits goalto bring together developers, users and researchers. The conference had three di?erent trackso?eredasatutorialday,anindustrydayandaresearchday. Inaddition,a demo sessionwithcontributionsfromallthree communities enabledparticipants to see the latest and on-going developments in object database technologies, supporting tools and also applications. The conference proceedings presented as this volume consist of the papers presentedintheresearchtrack. Bypublishing theseaftertheconference,authors were given an opportunity to revise and extend their papers based on feedback and discussions held during the conference. Six of the papers were selected from submissions based on reviews by at least three members of the Program C- mittee. These papers address a number of classic database issues such as query processing, transaction processing, event models and the coupling of data and services in the context of modern object databases. In addition, the research track included three invited presentations from researchers who were leaders in the ?eld during what might be called the ?rst generation of object databases back in the 1980s and early 1990s. At this time, research in object data models as well as object-oriented databases and p- sistent programming languages was very active. Over the years, this research became less fashionable and many researchers moved into other ?elds. However, somecontinuedand astechnologiesandmarketsevolvedso did their models and systems.

Information systems --- database management