Simplest-shop.comonline shopping, the simple way |
Welcome | Help  |
| Search for |
|
Home > Books > Refactoring Databases Evolutionary Database Design Addison Wesley Signature Series
This website will be shutdown on 2008-04-01.
|
 Add to shopping cart |
Refactoring Databases: Evolutionary Database Design (Addison-Wesley Signature Series) | |||||||||
 
| 80% Recommended by our customers. Publisher: Addison-Wesley Professional Catalog: Book Release date: 2006-03-13 Media: Hardcover Number of pages: 384 Ean: 9780321293534 Book Isbn: 0321293533  Tip: compare prices with similar booksAuthors:
|
| |||||||
| Top stores | Description | Price | Link to shop |
| amazon.com |
Availability: in 24 hours Current discount:20% off !! |
$47.99 | |
| used | 12 used offers, as low as... | $17.34 | see more used offers |
| all new | 45 thirdParty new offers, as low as... | $19.95 | see more ThirdParty new offers |
| Professional Review: |
| Refactoring has proven its value in a wide range of development projects, helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design -- without changing semantics. You'll learn how to evolve database schemas in step with source code -- and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference covers every fundamental concept underlying database refactoring, and helps you overcome the practical obstacles to refactoring real-world databases. Start-to-finish examples walk you through refactoring both simple standalone database applications and sophisticated multi-application scenarios. You'll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You'll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. The book provides an extensive set of examples, built with Oracle and Java, and easily adaptable for other languages, such as C#, C++, or VB.NET. Using this book's techniques and examples, you can reduce waste, rework, risk, and cost -- and build database systems capable of evolving smoothly, far into the future. |
| User Reviews: |
 Written on April 2, 2006 Summary: a different mindset for maintaining a database? Ambler and Sadalage describe a potentially very useful idea. That you can migrate the idea of code refactoring to databases. This appears to be a relatively new activity. Due in no small part to the database developer community having been separate from programmers using general purpose languages like C++ or Java. If you are in a large company with both types of people, you have probably noticed that the skill sets and interactions between them can be and indeed often are limited. The authors quite reasonably suggest that this caused database developers to miss out on various changes in the programming field since the 90s. Notably in the rise of object oriented programming. Rather different from the dominant SQL relational approaches. The OO mindset in turn led to the rise of code refactoring. In response, this book suggests ways that databases might be refactored. The pragmatic aim is to easily accomodate changing user requirements, by being able to perform relatively small, evolutionary changes. Readers should be warned that applying the lessons of this book may be harder than standard code refactoring. A database might be tightly coupled, both internally and to numerous downstream applications. Nonetheless, many possible refactorings are suggested. Each being easy to understand and perhaps even to implement, in your database. The authors have also tried to suggest refactorings that can be applied across any specific SQL database. Of course, different database vendors means different optimisations, usually for speed of handling queries. So possibly the book's refactorings are best suited for handling changing requirements and code maintenance. But for raw performance improvements, you may have to consult specific texts for your database. Written on March 13, 2006 Summary: Very Cool Book. Must Have for DBAs and Developers This book does an excellent job of pointing you in the right direction for almost anything you can think of database related. One of the best things about it is it uses UML syntax for DB designs, which really helps out if you are using a tool like SPARX EA. He breaks the refactorings down into categories: Structural, Data Quality, Referential Integrity, Architectural, Method, Non-RefactoringTransformation. They dedicate a full chapter to each category. Chapter 3 provides a great process to implement to accomplish Database Refactoring. They provide an Appendix for UML Data Modeling Notation. So you have a reference right there in the book. The author does a great job of thoroughly explaining everything and has a great writing style. Here is the Table of Contents to give you an idea of what is in the book. Preface Why Evolutionary Database Development? Agility in a Nutshell How to Read This Book About the Cover Acknowledgments Chapter 1. Evolutionary Database Development Section 1.1. Database Refactoring Section 1.2. Evolutionary Data Modeling Section 1.3. Database Regression Testing Section 1.4. Configuration Management of Database Artifacts Section 1.5. Developer Sandboxes Section 1.6. Impediments to Evolutionary Database Development Techniques Section 1.7. What You Have Learned Chapter 2. Database Refactoring Section 2.1. Code Refactoring Section 2.2. Database Refactoring Section 2.3. Categories of Database Refactorings Section 2.4. Database Smells Section 2.5. How Database Refactoring Fits In Section 2.6. Making It Easier to Refactor Your Database Schema Section 2.7. What You Have Learned Chapter 3. The Process of Database Refactoring Section 3.1. Verify That a Database Refactoring Is Appropriate Section 3.2. Choose the Most Appropriate Database Refactoring Section 3.3. Deprecate the Original Database Schema Section 3.4. Test Before, During, and After Section 3.5. Modify the Database Schema Section 3.6. Migrate the Source Data Section 3.7. Refactor External Access Program(s) Section 3.8. Run Your Regression Tests Section 3.9. Version Control Your Work Section 3.10. Announce the Refactoring Section 3.11. What You Have Learned Chapter 4. Deploying into Production Section 4.1. Effectively Deploying Between Sandboxes Section 4.2. Applying Bundles of Database Refactorings Section 4.3. Scheduling Deployment Windows Section 4.4. Deploying Your System Section 4.5. Removing Deprecated Schema Section 4.6. What You Have Learned Chapter 5. Database Refactoring Strategies Section 5.1. Smaller Changes Are Easier to Apply Section 5.2. Uniquely Identify Individual Refactorings Section 5.3. Implement a Large Change by Many Small Ones Section 5.4. Have a Database Configuration Table Section 5.5. Prefer Triggers over Views or Batch Synchronization Section 5.6. Choose a Sufficient Transition Period Section 5.7. Simplify Your Database Change Control Board (CCB) Strategy Section 5.8. Simplify Negotiations with Other Teams Section 5.9. Encapsulate Database Access Section 5.10. Be Able to Easily Set Up a Database Environment Section 5.11. Do Not Duplicate SQL Section 5.12. Put Database Assets Under Change Control Section 5.13. Beware of Politics Section 5.14. What You Have Learned Online Resources Chapter 6. Structural Refactorings Common Issues When Implementing Structural Refactorings Drop Column Drop Table Drop View Introduce Calculated Column Introduce Surrogate Key Merge Columns Merge Tables Move Column Rename Column Rename Table Rename View Replace LOB With Table Replace Column Replace One-To-Many With Associative Table Replace Surrogate Key With Natural Key Split Column Split Table Chapter 7. Data Quality Refactorings Common Issues When Implementing Data Quality Refactorings Add Lookup Table Apply Standard Codes Apply Standard Type Consolidate Key Strategy Drop Column Constraint Drop Default Value Drop Non-Nullable Introduce Column Constraint Introduce Common Format Introduce Default Value Make Column Non-Nullable Move Data Replace Type Code With Property Flags Chapter 8. Referential Integrity Refactorings Add Foreign Key Constraint Add Trigger For Calculated Column Access Program Update Mechanics Drop Foreign Key Constraint Introduce Cascading Delete Introduce Hard Delete Introduce Soft Delete Introduce Trigger For History Chapter 9. Architectural Refactorings Add CRUD Methods Add Mirror Table Add Read Method Encapsulate Table With View Introduce Calculation Method Introduce Index Introduce Read-Only Table Migrate Method From Database Migrate Method To Database Replace Method(s) With View Replace View With Method(s) Use Official Data Source Chapter 10. Method Refactorings Section 10.1. Interface Changing Refactorings Section 10.2. Internal Refactorings Chapter 11. Transformations Insert Data Introduce New Column Introduce New Table Introduce View Update Data The UML Data Modeling Notation Glossary References and Recommended Reading List of Refactorings and Transformations Index |
| Comparison map |
| Wondering how the book "Refactoring Databases: Evolutionary Database Design (Addison-Wesley Signature Series)" relates to similar books? Find out at a glance here: |
| Price comparison |
 Refactoring Databases: Evolutionary Database... |
 Agile Database Techniques: Effective Strategies... |
 xUnit Test Patterns: Refactoring Test Code... |
 Patterns of Enterprise Application Architecture... |
 Continuous Integration: Improving Software Quality... |
 Refactoring: Improving the Design of Existing Code... |
| Our price | $47.99 | $26.40 | $42.89 | $50.69 | $37.04 | $46.79 |
| List price | $59.99 | $40.00 | $54.99 | $64.99 | $44.99 | $59.99 |
| Lowest used price | $17.34 | $18.00 | $34.97 | $41.98 | $27.00 | $31.65 |
| Lowest new price | $19.95 | $19.97 | $38.98 | $46.11 | $32.52 | $35.90 |
| Catalog | Book | Book | Book | Book | Book | Book |
| Release date | 2006-03-13 | 2003-10-17 | 2007-05-31 | 2002-11-15 | 2007-07-09 | 1999-07-08 |
| Media | Hardcover | Paperback | Hardcover | Hardcover | Paperback | Hardcover |
| Number of pages | 384 | 480 | 833 | 560 | 336 | 464 |
| Ean | 9780321293534 | 9780471202837 | 9780131495050 | 9780321127426 | 9780321336385 | 9780201485677 |
| Book Isbn | 0321293533 | 0471202835 | 0131495054 | 0321127420 | 0321336380 | 0201485672 |
| Upc | - | 723812098330 | - | 076092019909 | - | 785342485677 |
| Link to shop* (opens in a new window) | BUY IT NOW* | BUY IT NOW* | BUY IT NOW* | BUY IT NOW* | BUY IT NOW* | BUY IT NOW* |
| take one out? |
|
I am here: Home > Books > Refactoring Databases Evolutionary Database Design Addison Wesley Signature Series
This website will be shutdown on 2008-04-01.
|
 E-mail this page |
|
About the Simplest Shop | Help | Term of Use | Privacy Policy
Home | Contact us | Bookmark us | get paid for writing |
|
Copyright Simplest-Shop.com 2004. All rights reserved |