Concurrency Control And Recovery in Database Systems
Concurrency Control And Recovery in Database Systems
Relational Database Index Design and the Optimizers
Improve the performance of relational databases with indexes designed for today's hardware
Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention. Unfortunately, the reality is that the improved hardware hasn't kept pace with the ever-increasing quantity of data processed today. Although disk packing densities have increased enormously, making storage costs extremely low and sequential read very fast, random reads are still painfully slow. Many of the old design recommendations are therefore no longer valid-the optimal point of indexing has come a long way. Consequently many of the old problems haven't actually gone away-they have simply changed their appearance.
This book provides an easy but effective approach to the design of indexes and tables. Using lots of examples and case studies, the authors describe how the DB2, Oracle, and SQL Server optimizers determine how to access data, and how CPU and response times for the resulting access paths can be quickly estimated. This enables comparisons to be made of the various designs, and helps you choose available choices for the most appropriate design.
Database Performance Tuning on AIX
Database Performance Tuning on AIX
Database System Concepts, Fifth Edition
The Fourth edition of Database System Concepts has been extensively revised from the 3rd edition. The new edition provides improved coverage of concepts, extensive coverage of new tools and techniques, and updated coverage of database system internals. This text is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate level. Database System Concepts, 4th ed. offers a complete background in the basics of database design, languages, and system implementations. Concepts are presented using intuitive descriptions, and important theoretical results are covered, but formal proofs are omitted. The fundamental concepts and algorithms covered in Database System Concepts 4th ed. are based on those used in existing commercial or experimental database systems. The authors present these concepts and algorithms in a general setting that is not tied to one particular database system.
Data Transfer Strategies (between XML and RDBM)
Data Transfer Strategies (between XML and RDBM)
Database Programming with Perl
Database Programming with Perl
Foundations of Object-Relational Mapping
Foundations of Object-Relational Mapping
Getting Started with OLE DB
Getting Started with OLE DB
Getting Started with JDBC API
Getting Started with JDBC API
Introduction to Databases for the Web
Introduction to Databases for the Web
Learn SQL - Free eBook Learn SQL - Download ebook Learn SQL free
|
Learn SQL
Visits: 33901 
Rating: 
(4.0)
Rated By: 1045 Users
Added On: 12-Jul-2008
Download Learn SQL
Category: Database
