數(shù)據(jù)庫重構(gòu)

內(nèi)容概要

重構(gòu)技術(shù)已經(jīng)在領(lǐng)域廣泛的開發(fā)項(xiàng)目中證明了自身的價(jià)值——幫助軟件專業(yè)人士改善系統(tǒng)的設(shè)計(jì)、可維護(hù)性、可擴(kuò)展性和性能。本書首次披露了為數(shù)據(jù)庫系統(tǒng)專門設(shè)計(jì)的強(qiáng)大重構(gòu)技術(shù)?！　”緯故玖巳绾卧诓桓淖冋Z義的情況下，對表結(jié)構(gòu)、數(shù)據(jù)、存儲(chǔ)過程及觸發(fā)器等略作改動(dòng)，就可以給數(shù)據(jù)庫設(shè)計(jì)帶來實(shí)質(zhì)上的飛躍?！　∵@是一本內(nèi)容全面的參考、指南書，全面介紹了數(shù)據(jù)庫重構(gòu)涉及的每個(gè)基本觀念，運(yùn)用完整的實(shí)例，帶領(lǐng)讀者學(xué)習(xí)從重構(gòu)簡單的孤立數(shù)據(jù)庫應(yīng)用程序到重構(gòu)復(fù)雜的多應(yīng)用程序環(huán)境的全過程，并講述了數(shù)據(jù)庫重整的五大主要類別。讀者將學(xué)會(huì)如何運(yùn)用重構(gòu)改善數(shù)據(jù)庫結(jié)構(gòu)、數(shù)據(jù)質(zhì)量和參照完整性，如何同時(shí)對結(jié)構(gòu)和方法進(jìn)行重整。本書提供了用Oracle和Java建立的多種實(shí)例，并可以方便地轉(zhuǎn)換成C#、C++、VB.NET等其他語言或DB2、SQL Server、MySQL、Sybase等其他數(shù)據(jù)庫?！　∵\(yùn)用本書的技術(shù)和實(shí)例，讀者可以減少浪費(fèi)和重復(fù)工作，降低風(fēng)險(xiǎn)和成本，建立能夠順利發(fā)展以適應(yīng)未來需求的數(shù)據(jù)庫系統(tǒng)。

作者簡介

Scott W.Ambler，世界一流的軟件過程改進(jìn)咨詢顧問，開創(chuàng)了敏捷建模、敏捷數(shù)據(jù)、企業(yè)統(tǒng)一過程（Enterprise UP）以及敏捷統(tǒng)一過程方法論。曾在軟件開發(fā)、JavaOne、OOPSLA、DAMA等會(huì)議上作主題發(fā)言和演講。

書籍目錄

Chapter 1:Evolutionary Database Development　　1.1　Database Refactoring　　1.2　Evolutionary Data Modeling　　1.3　Database Regression Testing　　1.4　Configuration Management of Database Artifacts　　1.5　Developer Sandboxes　　1.6　Impediments to Evolutionary Database Development Techniques　　1.7　What You Have Learned　Chapter 2:Database Refactoring　　2.1　Code Refactoring　　2.2　Database Refactoring　　2.3　Categories of Database Refactorings　　2.4　Database Smells　　2.5　How Database Refactoring Fits In　　2.6　Making It Easier to Refactor Your Database Schema　　2.7　What You Have Learned　Chapter 3:The Process of Database Refactoring　　3.1　Verify That a Database Refactoring Is Appropriate　　3.2　Choose the Most Appropriate Database Refactoring　　3.3　Deprecate the Original Database Schema　　3.4　Test Before, During, and After　　3.5　Modify the Database Schema　　3.6　Migrate the Source Data　　3.7　Refactor External Access Program(s)　　3.8　Run Your Regression Tests　　3.9　Version Control Your Work　　3.10　Announce the Refactoring　　3.11　What You Have Learned　Chapter 4:Deploying into Production　　4.1　Effectively Deploying Between Sandboxes　　4.2　Applying Bundles of Database Refactorings　　4.3　Scheduling Deployment Windows　　4.4　Deploying Your System　4.5　Removing Deprecated Schema　　4.6　What You Have Learned　Chapter 5:Database Refactoring Strategies　　5.1　Smaller Changes Are Easier to Apply　　5.2　Uniquely Identify Individual Refactorings　　5.3　Implement a Large Change by Many Small Ones　　5.4　Have a Database Configuration Table　　5.5　Prefer Triggers over Views or Batch Synchronization　　5.6　Choose a Sufficient Transition Period　　5.7　Simplify Your Database Change Control Board (CCB) Strategy　　5.8　Simplify Negotiations with Other Teams　　5.9　Encapsulate Database Access　　5.10　Be Able to Easily Set Up a Database Environment　　5.11　Do Not Duplicate SQL　　5.12　Put Database Assets Under Change Control　　5.13　Beware of Politics　　5.14　What You Have Learned　68 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　　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　　10.1　Interface Changing Refactorings　10.2　Internal Refactorings　Chapter 11:Transformations　　Insert Data　　Introduce New Column　　Introduce New Table　　Introduce View　　Update Data　Appendix:The UML Data Modeling Notation　Glossary　References and Recommended Reading　Index

編輯推薦

《數(shù)據(jù)庫重構(gòu)(英文版)》榮獲2007年第17屆Jolt大獎(jiǎng)的生產(chǎn)效率獎(jiǎng)!

圖書封面

圖書標(biāo)簽Tags

無

評論、評分、閱讀與下載

---

    數(shù)據(jù)庫重構(gòu) PDF格式下載

---