Availability: Refactoring databases | Technische Universität München

Refactoring databases: evolutionary database design

Saved in:

Bibliographic Details
Main Authors:	Ambler, Scott W. 1966- (Author), Sadalage, Pramod J. (Author)
Format:	Book
Language:	English
Published:	Upper Saddle River, NJ Addison-Wesley [2006]
Series:	The Addison-Wesley signature series
Subjects:	Banco de dados Bases de données - Conception Engenharia de programas Logiciels - Développement Métodos ágeis Programmation évolutive Database design Computer software > Development Evolutionary programming (Computer science) Datenbankentwurf
Links:	http://www.loc.gov/catdir/toc/ecip063/2005031959.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016361076&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
Item Description:	Includes bibliographical references (p. 327-329) and index
Physical Description:	xxvii, 350 Seiten Illustrationen 25 cm
ISBN:	0321774515 9780321774514 0321293533

Staff View

MARC


LEADER	00000nam a2200000zc 4500
001	BV023174450
003	DE-604
005	20220701
007	t\|
008	080220s2006 xxua\|\|\| \|\|\|\| 00\|\|\| eng d
010			\|a 2005031959
020			\|a 0321774515 \|9 0-321-77451-5
020			\|a 9780321774514 \|c pbk \|9 978-0-321-77451-4
020			\|a 0321293533 \|c hdbk. : alk. paper \|9 0-321-29353-3
035			\|a (OCoLC)254774361
035			\|a (DE-599)BVBBV023174450
040			\|a DE-604 \|b ger \|e aacr
041	0		\|a eng
044			\|a xxu \|c US
049			\|a DE-859 \|a DE-83 \|a DE-898 \|a DE-739 \|a DE-355
050		0	\|a QA76.9.D26
082	0		\|a 005.74
084			\|a ST 270 \|0 (DE-625)143638: \|2 rvk
100	1		\|a Ambler, Scott W. \|d 1966- \|e Verfasser \|0 (DE-588)124448348 \|4 aut
245	1	0	\|a Refactoring databases \|b evolutionary database design \|c Scott W. Ambler, Pramod J. Sadalage
264		1	\|a Upper Saddle River, NJ \|b Addison-Wesley \|c [2006]
300			\|a xxvii, 350 Seiten \|b Illustrationen \|c 25 cm
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
490	0		\|a The Addison-Wesley signature series
500			\|a Includes bibliographical references (p. 327-329) and index
650		7	\|a Banco de dados \|2 larpcal
650		4	\|a Bases de données - Conception
650		7	\|a Engenharia de programas \|2 larpcal
650		4	\|a Logiciels - Développement
650		7	\|a Métodos ágeis \|2 larpcal
650		4	\|a Programmation évolutive
650		4	\|a Database design
650		4	\|a Computer software \|x Development
650		4	\|a Evolutionary programming (Computer science)
650	0	7	\|a Datenbankentwurf \|0 (DE-588)4127613-9 \|2 gnd \|9 rswk-swf
689	0	0	\|a Datenbankentwurf \|0 (DE-588)4127613-9 \|D s
689	0		\|5 DE-604
700	1		\|a Sadalage, Pramod J. \|e Verfasser \|0 (DE-588)131765590 \|4 aut
856	4		\|u http://www.loc.gov/catdir/toc/ecip063/2005031959.html \|3 Table of contents only
856	4	2	\|m GBV Datenaustausch \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016361076&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
943	1		\|a oai:aleph.bib-bvb.de:BVB01-016361076

Record in the Search Index

DE-BY-OTHR_call_number	F 03/ST 270 A493
DE-BY-OTHR_katkey	5780571
DE-BY-OTHR_location	02
DE-BY-OTHR_media_number	067003124388 067003124377
_version_	1831256428238602240
adam_text	CONTENTS ABOUT THE AUTHORS XV FOREWORDS XVU PREFACE XXJ ACKNOWLEDGMENTS XXVII CHAPTER 1: EVOLUTIONARY DATABASE DEVELOPMENT 1 1.1 DATABASE REFACTORING 3 1.2 EVOLUTIONARY DATA MODELING 4 1.3 DATABASE REGRESSION TESTING 6 1.4 CONFIGURATION MANAGEMENT OF DATABASE ARTIFACTS 9 1.5 DEVELOPER SANDBOXES 10 1.6 IMPEDIMENTS TO EVOLUTIONARY DATABASE DEVELOPMENT TECHNIQUES 11 1.7 WHAT YOU HAVE LEARNED 12 CHAPTER 2: DATABASE REFACTORING 13 2.1 CODE REFACTORING 13 2.2 DATABASE REFACTORING 14 2.2.1 SINGLE-APPLICATION DATABASE ENVIRONMENTS 15 2.2.2 MULTI-APPLICATION DATABASE ENVIRONMENTS 18 2.2.3 MAINTAINING SEMANTICS 20 2.3 CATEGORIES OF DATABASE REFACTORINGS 22 2.4 DATABASE SMELLS 22 2.5 HOW DATABASE REFACTORING FITS IN 25 2.6 MAKING IT EASIER TO REFACTOR YOUR DATABASE SCHEMA 27 2.7 WHAT YOU HAVE LEARNED 28 CHAPTER 3: THE PROCESS OF DATABASE REFACTORING 29 3.1 VERIFY THAT A DATABASE REFACTORING IS APPROPRIATE 32 3.2 CHOOSE THE MOST APPROPRIATE DATABASE REFACTORING 33 3.3 DEPRECATE THE ORIGINAL DATABASE SCHEMA 34 IX CONTENTS 3.4 TEST BEFORE, DURING, AND AFTER 37 3.4.1 TESTING YOUR DATABASE SCHEMA 37 3.4.2 VALIDATING YOUR DATA MIGRATION 38 3.4.3 TESTING YOUR EXTERNAL ACCESS PROGRAMS 40 3.5 MODIFY THE DATABASE SCHEMA 40 3.6 MIGRATE THE SOURCE DATA 43 3.7 REFACTOR EXTERNAL ACCESS PROGRAM(S) 44 3.8 RUN YOUR REGRESSION TESTS 45 3.9 VERSION CONTROL YOUR WORK 45 3.10 ANNOUNCE THE REFACTORING 46 3.11 WHAT YOU HAVE LEARNED 47 CHAPTER 4: DEPLOYING INTO PRODUCTION 49 4.1 EFFECTIVELY DEPLOYING BETWEEN SANDBOXES 50 4.2 APPLYING BUNDLES OF DATABASE REFACTORINGS 51 4.3 SCHEDULING DEPLOYMENT WINDOWS 53 4.4 DEPLOYING YOUR SYSTEM 54 4.5 REMOVING DEPRECATED SCHEMA 56 4.6 WHAT YOU HAVE LEARNED 56 CHAPTER 5: DATABASE REFACTORING STRATEGIES 59 5.1 SMALLER CHANGES ARE EASIER TO APPLY 60 5.2 UNIQUELY IDENTIFY INDIVIDUAL REFACTORINGS 60 5.3 IMPLEMENT A LARGE CHANGE BY MANY SMALL ONES 62 5.4 HAVE A DATABASE CONFIGURATION TABLE 63 5.5 PREFER TRIGGERS OVER VIEWS OR BATCH SYNCHRONIZATION 63 5.6 CHOOSE A SUFFICIENT TRANSITION PERIOD 65 5.7 SIMPLIFY YOUR DATABASE CHANGE CONTROL BOARD (CCB) STRATEGY 65 5.8 SIMPLIFY NEGOTIATIONS WITH OTHER TEAMS 65 5.9 ENCAPSULATE DATABASE ACCESS 66 5.10 BE ABLE TO EASILY SET UP A DATABASE ENVIRONMENT 66 5.11 DO NOT DUPLICATE SQL 67 5.12 PUT DATABASE ASSETS UNDER CHANGE CONTROL 67 5.13 BEWARE OF POLITICS 68 5.14 WHAT YOU HAVE LEARNED 68 ONLINE RESOURCES 68 CONTENTS CHAPTER 6: STRUCTURAL REFACTORINGS 69 COMMON ISSUES WHEN IMPLEMENTING STRUCTURAL REFACTORINGS 70 DROP COLUMN DROP TABLE DROP VIEW INTRODUCE CALCULATED COLUMN 81 INTRODUCE SURROGATE KEY 8 - MERGE COLUMNS 99 MERGE TABLES MOVE COLUMN , 1 * RENAME COLUMN 0 LOEY RENAME TABLE . RENAME VIEW REPLACE LOB WITH TABLE 120 REPLACE COLUMN 1 _ , N . IZ6 REPLACE ONE-TO-MANY WITH ASSOCIATIVE TABLE 130 REPLACE SURROGATE KEY WITH NATURAL KEY . ... 135 SPLIT COLUMN . SPUETTABLE *****.... ^ .....!.. . ^. .145 CHAPTER 7: DATA QUALITY REFACTORINGS M COMMON ISSUES WHEN IMPLEMENTING DATA QUALITY REFACTORINGS . . 152 ADD LOOKUP TABLE ~ . -, APPLY STANDARD CODES 157 APPLY STANDARD TYPE 162 CONSOLIDATE KEY STRATEGY 168 DROP COLUMN CONSTRAINT 172 DROP DEFAULT VALUE 174 DROP NON-NULLABLE . 77 INTRODUCE COLUMN CONSTRAINT 180 INTRODUCE COMMON FORMAT JN, INTRODUCE DEFAULT VALUE 186 MAKE COLUMN NON-NULLABLE 189 MOVE DATA REPLACE TYPE CODE WITH PROPERTY FLAGS 196 CONTENTS CHAPTER 8: REFERENTIAL INTEGRITY REFACTORINGS 203 ADD FOREIGN KEY CONSTRAINT 204 ADD TRIGGER FOR CALCULATED COLUMN 209 DROP FOREIGN KEY CONSTRAINT 213 INTRODUCE CASCADING DELETE INTRODUCE HARD DELETE INTRODUCE SOFT DELETE INTRODUCE TRIGGER FOR HISTORY 227 CHAPTER 9: ARCHITECTURAL REFACTORINGS 231 ADD CRUD METHODS ADD MIRROR TABLE . . 2 O ADD READ METHOD ^AO ENCAPSULATE TABLE WITH VIEW ** INTRODUCE CALCULATION METHOD 24 ^ INTRODUCE INDEX . . 248 INTRODUCE READ-ONLY TABLE MIGRATE METHOD FROM DATABASE 2 5 ? MIGRATE METHOD TO DATABASE ... [. 261 REPLACE METHOD(S) WITH VIEW ] [ [ ] 265 REPLACE VIEW WITH METHOD(S) 268 USE OFFICIAL DATA SOURCE . . . 2 _ CHAPTER 10: METHOD REFACTORINGS »***#» # ,^// 10.1 INTERFACE CHANGING REFACTORINGS 277 10.1.1 ADD PARAMETER ~ 7 10.1.2 PARAMETERIZE METHOD 27S 10.1.3 REMOVE PARAMETER 279 10.1.4 RENAME METHOD 27 * 10.1.5 REORDER PARAMETERS ?S1 10.1.6 REPLACE PARAMETER WITH EXPLICIT METHODS 282 10.2 INTERNAL REFACTORINGS 283 10.2.1 CONSOLIDATE CONDITIONAL EXPRESSION 2 83 10.2.2 DECOMPOSE CONDITIONAL 284 10.2.3 EXTRACTMETHOD 285 10.2.4 INTRODUCE VARIABLE 2S7 10.2.5 REMOVE CONTROL FLAG 289 O YO CHAPTER 11: TRANSFORMATIONS 295 INSERT DATA 296 INTRODUCE NEW COLUMN 301 INTRODUCE NEW TABLE 304 INTRODUCE VIEW 306 UPDATE DATA 310 APPENDIX: THE UML DATA MODELING NOTATION 315 GLOSSARY ^I REFERENCES AND RECOMMENDED READING 327 INDEX . , *.
any_adam_object	1
author	Ambler, Scott W. 1966- Sadalage, Pramod J.
author_GND	(DE-588)124448348 (DE-588)131765590
author_facet	Ambler, Scott W. 1966- Sadalage, Pramod J.
author_role	aut aut
author_sort	Ambler, Scott W. 1966-
author_variant	s w a sw swa p j s pj pjs
building	Verbundindex
bvnumber	BV023174450
callnumber-first	Q - Science
callnumber-label	QA76
callnumber-raw	QA76.9.D26
callnumber-search	QA76.9.D26
callnumber-sort	QA 276.9 D26
callnumber-subject	QA - Mathematics
classification_rvk	ST 270
ctrlnum	(OCoLC)254774361 (DE-599)BVBBV023174450
dewey-full	005.74
dewey-hundreds	000 - Computer science, information, general works
dewey-ones	005 - Computer programming, programs, data, security
dewey-raw	005.74
dewey-search	005.74
dewey-sort	15.74
dewey-tens	000 - Computer science, information, general works
discipline	Informatik
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02180nam a2200541zc 4500</leader><controlfield tag="001">BV023174450</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20220701 </controlfield><controlfield tag="007">t\|</controlfield><controlfield tag="008">080220s2006 xxua\|\|\| \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2005031959</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0321774515</subfield><subfield code="9">0-321-77451-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780321774514</subfield><subfield code="c">pbk</subfield><subfield code="9">978-0-321-77451-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0321293533</subfield><subfield code="c">hdbk. : alk. paper</subfield><subfield code="9">0-321-29353-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)254774361</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV023174450</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-859</subfield><subfield code="a">DE-83</subfield><subfield code="a">DE-898</subfield><subfield code="a">DE-739</subfield><subfield code="a">DE-355</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D26</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Ambler, Scott W.</subfield><subfield code="d">1966-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)124448348</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Refactoring databases</subfield><subfield code="b">evolutionary database design</subfield><subfield code="c">Scott W. Ambler, Pramod J. Sadalage</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Upper Saddle River, NJ</subfield><subfield code="b">Addison-Wesley</subfield><subfield code="c">[2006]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xxvii, 350 Seiten</subfield><subfield code="b">Illustrationen</subfield><subfield code="c">25 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">The Addison-Wesley signature series</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references (p. 327-329) and index</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Banco de dados</subfield><subfield code="2">larpcal</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données - Conception</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Engenharia de programas</subfield><subfield code="2">larpcal</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Logiciels - Développement</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Métodos ágeis</subfield><subfield code="2">larpcal</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Programmation évolutive</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer software</subfield><subfield code="x">Development</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Evolutionary programming (Computer science)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Sadalage, Pramod J.</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)131765590</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/toc/ecip063/2005031959.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">GBV Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016361076&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016361076</subfield></datafield></record></collection>
id	DE-604.BV023174450
illustrated	Illustrated
indexdate	2024-12-20T13:09:53Z
institution	BVB
isbn	0321774515 9780321774514 0321293533
language	English
lccn	2005031959
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-016361076
oclc_num	254774361
open_access_boolean
owner	DE-859 DE-83 DE-898 DE-BY-UBR DE-739 DE-355 DE-BY-UBR
owner_facet	DE-859 DE-83 DE-898 DE-BY-UBR DE-739 DE-355 DE-BY-UBR
physical	xxvii, 350 Seiten Illustrationen 25 cm
publishDate	2006
publishDateSearch	2006
publishDateSort	2006
publisher	Addison-Wesley
record_format	marc
series2	The Addison-Wesley signature series
spellingShingle	Ambler, Scott W. 1966- Sadalage, Pramod J. Refactoring databases evolutionary database design Banco de dados larpcal Bases de données - Conception Engenharia de programas larpcal Logiciels - Développement Métodos ágeis larpcal Programmation évolutive Database design Computer software Development Evolutionary programming (Computer science) Datenbankentwurf (DE-588)4127613-9 gnd
subject_GND	(DE-588)4127613-9
title	Refactoring databases evolutionary database design
title_auth	Refactoring databases evolutionary database design
title_exact_search	Refactoring databases evolutionary database design
title_full	Refactoring databases evolutionary database design Scott W. Ambler, Pramod J. Sadalage
title_fullStr	Refactoring databases evolutionary database design Scott W. Ambler, Pramod J. Sadalage
title_full_unstemmed	Refactoring databases evolutionary database design Scott W. Ambler, Pramod J. Sadalage
title_short	Refactoring databases
title_sort	refactoring databases evolutionary database design
title_sub	evolutionary database design
topic	Banco de dados larpcal Bases de données - Conception Engenharia de programas larpcal Logiciels - Développement Métodos ágeis larpcal Programmation évolutive Database design Computer software Development Evolutionary programming (Computer science) Datenbankentwurf (DE-588)4127613-9 gnd
topic_facet	Banco de dados Bases de données - Conception Engenharia de programas Logiciels - Développement Métodos ágeis Programmation évolutive Database design Computer software Development Evolutionary programming (Computer science) Datenbankentwurf
url	http://www.loc.gov/catdir/toc/ecip063/2005031959.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016361076&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT amblerscottw refactoringdatabasesevolutionarydatabasedesign AT sadalagepramodj refactoringdatabasesevolutionarydatabasedesign

Availability

‌

Order via interlibrary loan Table of Contents