Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (The Morgan Kaufmann Series in Data Management Systems) Review

Average Reviews:

(More customer reviews)Are you looking to buy Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (The Morgan Kaufmann Series in Data Management Systems)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (The Morgan Kaufmann Series in Data Management Systems). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (The Morgan Kaufmann Series in Data Management Systems) ReviewBefore this book was published my primary reference and personal favorite TP book was "Transaction Processing: Concepts and Techniques" by Jim Gray and Andreas Reuter. At over 1100 pages that book thoroughly covered the basics and drilled down into the nuances of transaction processing in a way unmatched by other books on the topic since it was first published in 1993.
This book changes that by going far beyond transaction processing. It starts with the same fundamentals as the older book, and even covers many of the same topics, such as concurrency control, but it addresses each topic from a much wider perspective. For example, the discussion of concurrency goes far beyond the issues of transaction processing as a middleware component. It extends into application, database and search issues. Another indication that this book is more up-to-date is the material on queue managers. While they are at the opposite end of the spectrum from transaction processing monitors, they are integral to any discussion of transactional information systems. More importantly, both transaction processing monitors and queue managers are used in modern enterprise architectures. Having both topics discussed in great detail is a major point in this book's favor.
Personally I intend to keep my copy of the older "Transaction Processing: Concepts and Techniques" because it does cover some of the subject matter more deeply. However, this book has replaced it as my principal reference and if I had to choose between them this is the one I'd go with.Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (The Morgan Kaufmann Series in Data Management Systems) Overview

Want to learn more information about Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (The Morgan Kaufmann Series in Data Management Systems)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Expert Access 2007 Programming (Programmer to Programmer) Review

Average Reviews:

(More customer reviews)Are you looking to buy Expert Access 2007 Programming (Programmer to Programmer)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Expert Access 2007 Programming (Programmer to Programmer). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Expert Access 2007 Programming (Programmer to Programmer) ReviewThis is not the first book on Access to own unless you fairly comfortable with developing applications using another tool. Check out Wrox's Beginning Access 2007 title. But if your goal is to create an application to sell or use within your company this book provides all the info you need to get started and succeed. As a read it I recognized a lot of the tips that I had gathered over years of work and research. Would have been great if I could have just bought this book years ago. Section 4, "Finalizing the Application" covers great material; some knowledge of .Net would be beneficial if you are interested in DLLs (like resource libraries) or the build utility that comes with the book. Next to the Access Developer Handbook series I'd say this is the best book I've read on Access application development and deployment.Expert Access 2007 Programming (Programmer to Programmer) Overview

Want to learn more information about Expert Access 2007 Programming (Programmer to Programmer)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Expert Oracle: Signature Edition (Expert One-On-One) Review

Average Reviews:

(More customer reviews)Are you looking to buy Expert Oracle: Signature Edition (Expert One-On-One)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Expert Oracle: Signature Edition (Expert One-On-One). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Expert Oracle: Signature Edition (Expert One-On-One) ReviewThis book belongs on every developer, team leader, or DBAs desk that works with Oracle. Kyte has written a masterpiece in advanced Oracle knowledge. He does three things very well in this book: tells you what is important in Oracle, why it is important, and what happens if you do things the wrong way.
Kyte starts out giving the foundations for Oracle databases, the architecture, locking schemes, and table and index considerations. He gives a good treatment of the types of tables and indexes that Oracle offers including the appropriate times to use them and the trade-offs to weigh.
Another key topic that he covers is redo and rollback. These features are handled in a unique way in Oracle, and a lack of understanding can lead to inefficient and incorrect databases and applications.
Armed with the foundations, Kyte then takes the reader through performance tuning and optimizing databases. The best advice in this section is that performance cannot be thrown in at the end. The design decisions for a database will determine how it performs and scales. As he says, "There is no fast=true setting in the init parameters."
Then the book tackles some more advanced features, such as autonomous transactions, dynamic sql, and C and Java extensions for stored procedures. Kyte again gives good advice for when these are appropriate over standard PL/SQL stored procedures.
The size of the book can be intimidating at first glance, but it is pleasant to read. Kyte uses a conversational style rather than a lecturing delivery. This book has a lot to offer, and you won't find yourself tired after reading it.Expert Oracle: Signature Edition (Expert One-On-One) Overview

Want to learn more information about Expert Oracle: Signature Edition (Expert One-On-One)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Database Management Systems Review

Average Reviews:

(More customer reviews)Are you looking to buy Database Management Systems? Here is the right place to find the great deals. we can offer discounts of up to 90% on Database Management Systems. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Database Management Systems ReviewIt's tough finding really good database books that provide a broad range of coverage of database related topics, including the internals of how (relational) database systems work. This is one of the best database books (database theory, concepts, internals, and state-of-the-art database topics) that has come along in 20-25 years. Please note that this is a university textbook. You won't learn MS Access programming or Oracle database administration from this book; if this is why you bought the book, you will probably be disappointed. You will, however, learn a lot about database concepts and internals. There are some small errors in the book, but that happens everywhere. The examples are pretty easy to follow, and the sidebars about DB2, Oracle, SQL Server, etc. are really nice.
This is a great book to keep on your reference shelf, whether you are an academic, or have a career in industry. We've been using this book at UBC for both our 3rd and 4th year database courses for several years, and have found it to be particularly good for teaching. Overall, the students seem to be pretty satisfied with it. We also use parts of the Garcia-Molina, Ullman, Widom text ("Database Systems: The Complete Book") for part of our 4th year course. It, too, is a very good book.
Database Management Systems Overview

Want to learn more information about Database Management Systems?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Understanding MySQL Internals Review

Average Reviews:

(More customer reviews)Are you looking to buy Understanding MySQL Internals? Here is the right place to find the great deals. we can offer discounts of up to 90% on Understanding MySQL Internals. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Understanding MySQL Internals ReviewMySQL is assuming increased importance as an enterprise database and has become the de-facto standard with web hosting companies. A number of books have appeared in recent years, covering various aspects of MySQL. In Understanding MySQL Internals, Sasha Pachev, a MySQL-focused consultant and former member of the MySQL development team, takes us on a tour of how MySQL works and how it is built.
Starting with an overview of MySQL history and architecture, the book quickly moves us through working with the source code to build and run the product in a debugger. Drawing on his deep experience with the software, Mr. Pachev explains the coding conventions used to develop MySQL and why you should use them when modifying the software yourself.
The author delineates the different functional "modules" (a term he coined himself to better explain the database, technically speaking there are no defined modules in MySQL's architecture) of MySQL and how they interrelate. Herein lies the key to how this book teaches the reader the vast intricacy of such a complex piece of software. The author recognizes the subject is huge and the source code changing. What he does in the book is serve as our tour guide, driving us through the various areas and explaining as much relevant information as he reasonably can. He constantly illustrates key pieces of source code and data structures; but perhaps more importantly he makes reference to the actual source files utilized by each functional component of the system, while encouraging us to explore further on our own. His approach is very much "top down".
As he takes us on this tour, the author explains many of the design decisions behind the various MySQL components, often imparting the historical perspective behind them. I appreciate how, throughout the book, the author shares some of his "inside information" about MySQL's development. There is also a section where he examines the code stability of each module and speculates on what the future may hold for each module. The author's writing style is clear and easy to read. I found Understanding MySQL Internals interesting and fun, and surprisingly easy to read for a book covering such a sophisticated piece of software. The author also does a good job explaining the engineering trade-offs of different MySQL configurations. Speaking of configuration, the book shows you how to add your own configuration option to the mysqld daemon.
Chapter 7, the largest chapter in the book, is 41 pages long. It covers the MySQL storage engine interface. This chapter explains how to integrate your own custom storage engine into MySQL and contains the source code for two custom storage engine examples (one for MySQL 4.1, the other for version 5.1). You can download this source code from O'Reilly's web site. Despite this one long chapter, the book is surprising short, only 234 pages.
I believe this book has value outside of MySQL. It does a good job showing how MySQL is essentially a well designed piece of software: a high-performance, reliable Unix server. The book also touches on the multi-platform aspects of MySQL design. Those of you designing other types of server software may benefit from studying how MySQL is constructed.
This book isn't for everyone, but if you are serious about MySQL in particular or database software design in general then this title certainly deserves a look.Understanding MySQL Internals Overview

Want to learn more information about Understanding MySQL Internals?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...