Book:
Advanced Data Management for SQL, NoSQL, Cloud and Distributed Databases

Lena Wiese: ADVANCED DATA MANAGEMENT FOR SQL, NOSQL, CLOUD AND DISTRIBUTED DATABASES DeGruyter/Oldenbourg, 2015 375 pages, 82 figures, 31 tables ISBN 978-3-11-044140-6 e-ISBN (PDF) 978-3-11-044141-3 Download table of contents and index (PDF)

Campus-wide license available: PDF: degruyter.com Find the book on: amazon.com amazon.ca amazon.co.uk amazon.de amazon.fr amazon.es amazon.it amazon.co.jp degruyter.com buchhandel.de thalia.de buecher.de ebook.de mayersche.de

Table of Contents

• Part I: Introduction
• Chapter 1: Background
• Chapter 2: Relational Database Management Systems
• Part II: NOSQL And Non-Relational Databases
• Chapter 3: New Requirements, "Not only SQL" and the Cloud
• Chapter 4: Graph Databases
• Chapter 5: XML Databases
• Chapter 6: Key-value Stores and Document Databases
• Chapter 7: Column Stores
• Chapter 8: Extensible Record Stores
• Chapter 9: Object Databases
• Part III: Distributed Data Management
• Chapter 10: Distributed Database Systems
• Chapter 11: Data Fragmentation
• Chapter 12: Replication and Synchronization
• Chapter 13: Consistency
• Part IV Conclusion
• Chapter 14: Further Database Technologies
• Chapter 15: Concluding Remarks

Lecture summaries on Prezi

Relational Data Model (Lecture 1) Prezi slides

Graph Databases (Lecture 2) Prezi slides

XML Databases (Lecture 3) Prezi slides

Key-Value Stores and Document Databases (Lecture 4) Prezi slides

Extensible Record Stores (Lecture 5) Prezi slides

Column Stores (Lecture 6) Prezi slides

Distributed Databases (Lecture 7 and 8) Prezi slides



Figures from the Book

sorted by chapter

Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Chapter 13
Chapter 14
Chapter 15

-------------------------------------------------------------------------------------------------------------------------


Chapter 1

Page	Figure	Link
5 (Figure 1)	Fig. 1.1.	dbmslayers.pdf
9 (Figure 1)	-	erdiagramentities.pdf
9 (Figure 2)	-	erdiagramsimple.pdf
9 (Figure 3)	-	erdiagramasinglevalued.pdf
9 (Figure 4)	-	erdiagramamultivalued.pdf
9 (Figure 5)	-	erdiagramacomposite.pdf
10 (Figure 1)	-	erdiagrammkey.pdf
10 (Figure 2)	-	erdiagramcardinal.pdf
10 (Figure 3)	-	erdiagramisa.pdf
11 (Figure 1)	Fig. 1.2.	erdiagram.pdf
12 (Figure 1)	-	objclass.pdf
12 (Figure 2)	-	objclass2.pdf
13 (Figure 1)	-	objattrmulti.pdf
13 (Figure 2)	-	objattrcomp.pdf
13 (Figure 3)	-	objassociationclass.pdf
14 (Figure 1)	-	objmultiplicities.pdf
14 (Figure 2)	-	objclassinheritance.pdf
14 (Figure 3)	-	objinterface.pdf
15 (Figure 1)	Fig. 1.3.	objlibrary.pdf




Chapter 2

Page	Figure	Link
24 (Figure 1)	Fig. 2.1.	algebratree.pdf




Chapter 3

Page	Figure	Link
34 (Figure 1)	Fig. 3.1.	erdiagramsimple.pdf




Chapter 4

Page	Figure	Link
41 (Figure 1)	Fig. 4.1.	graphexample.pdf
42 (Figure 1)	Fig. 4.2 .	graphexample2.pdf
42 (Figure 2)	-	graphundirected.pdf
43 (Figure 1)	-	graphdirected.pdf
43 (Figure 2)	-	graphundirectedmulti.pdf
44 (Figure 1)	-	graphdirectedmulti.pdf
44 (Figure 2)	-	graphdirectedmultiweighted.pdf
45 (Figure 1)	-	grapheuler.pdf
45 (Figure 2)	-	graphhamilton.pdf
45 (Figure 3)	-	graphspanningtree.pdf
47 (Figure 1)	-	graphundirected.pdf
47 (Figure 2)	-	graphdirected.pdf
47 (Figure 3)	-	graphundirectedmulti.pdf
47 (Figure 4)	-	graphdirectedmulti.pdf
48 (Figure 1)	-	graphundirected.pdf
48 (Figure 2)	-	graphdirected.pdf
49 (Figure 1)	-	graphundirectedmulti.pdf
49 (Figure 2)	-	graphdirectedmulti.pdf
50 (Figure 1)	-	adjlistundirected.pdf graphundirected.pdf
50 (Figure 2)	-	adjlistdirected.pdf graphdirected.pdf
50 (Figure 3)	-	adjlistundirectedmulti.pdf graphundirectedmulti.pdf
50 (Figure 4)	-	adjlistdirectedmulti.pdf graphdirectedmulti.pdf
51 (Figure 1)	-	inclistundirected.pdf graphundirected.pdf
52 (Figure 1)	-	inclistdirected.pdf graphdirected.pdf
52 (Figure 2)	-	inclistundirectedmulti.pdf graphundirectedmulti.pdf
52 (Figure 3)	-	inclistdirectedmulti.pdf graphdirectedmulti.pdf
55 (Figure 1)	Fig. 4.3.	graphproperty2.pdf
56 (Figure 1)	Fig. 4.4.	graphproperty3.pdf
58 (Figure 1)	Fig. 4.5.	graphhyper1.pdf
59 (Figure 1)	Fig. 4.6.	graphhyper2.pdf
60 (Figure 1)	Fig. 4.7.	graphhyper3.pdf
60 (Figure 2)	Fig. 4.8.	graphproperty4.pdf
62 (Figure 1)	Fig. 4.9.	graphnested.pdf




Chapter 5

Page	Figure	Link
77 (Figure 1)	Fig. 5.1.	xmlnavigation.pdf
78 (Figure 1)	Fig. 5.2.	xmlhoteltree.pdf
79 (Figure 1)	Fig. 5.3.	xmlhoteltreenumbered.pdf
79 (Figure 2)	Fig. 5.4.	xmltreeprepost.pdf xmltreeprepostdiagram.pdf
80 (Figure 1)	Fig. 5.5.	xmltreedewey.pdf
93 (Figure 1)	Fig. 5.6.	xmlchain.pdf
94 (Figure 1)	Fig. 5.7.	xmlpage.pdf
95 (Figure 1)	Fig. 5.8.	xmlpagebtree.pdf
96 (Figure 1)	Fig. 5.9.	xmlpagesplit.pdf
98 (Figure 1)	Fig. 5.10.	xmlconflict.pdf
99 (Figure 1)	Fig. 5.11.	xmllocks.pdf




Chapter 6

Page	Figure	Link
107 (Figure 1)	Fig. 6.1.	mapreduce.pdf
109 (Figure 1)	Fig. 6.2.	mapreducecombine.pdf




Chapter 7

Chapter 8

Page	Figure	Link
162 (Figure 1)	-	columnfamily1.pdf
163 (Figure 1)	-	columnfamily2.pdf
164 (Figure 1)	-	columnfamily3.pdf
165 (Figure 1)	-	columnfamily4.pdf
167 (Figure 1)	Fig. 8.1.	extensiblestorage1.pdf
168 (Figure 1)	Fig. 8.2.	extensiblestorage2.pdf
170 (Figure 1)	Fig. 8.3.	extensiblestorage3.pdf
171 (Figure 1)	Fig. 8.4.	extensiblestorage3a.pdf
172 (Figure 1)	Fig. 8.5.	extensiblestorage4.pdf
173 (Figure 1)	Fig. 8.6.	extensiblestorage5.pdf
175 (Figure 1)	Fig. 8.7.	extensiblestorage5a.pdf
176 (Figure 1)	Fig. 8.8	extensiblestorage6.pdf
178 (Figure 1)	Fig. 8.9.	extensiblestorage6a.pdf
181 (Figure 1)	Fig. 8.10.	extensiblestorage6b.pdf




Chapter 9

Page	Figure	Link
193 (Figure 1)	-	objmethods.pdf
193 (Figure 2)	-	objencaps.pdf
195 (Figure 1)	Fig. 9.1.	objspecialversusabstr.pdf
197 (Figure 1)	Fig. 9.2.	obj0ONF.pdf
198 (Figure 1)	Fig. 9.3.	obj1ONF.pdf
198 (Figure 2)	Fig. 9.4.	obj2ONF.pdf
199 (Figure 1)	Fig. 9.5.	obj3ONF.pdf
200 (Figure 1)	Fig. 9.6.	obj4ONF.pdf
205 (Figure 1)	Fig. 9.7.	objinheritance2.pdf
227 (Figure 1)	Fig. 9.8.	objedgemarkA.pdf objedgemarkA2.pdf objedgemarkA3.pdf
228 (Figure 1)	Fig. 9.9.	objedgemark.pdf objedgemark2.pdf objedgemark3.pdf
228 (Figure 1)	Fig. 9.10	objnodemark.pdf objnodemark2.pdf objnodemark3.pdf




Chapter 10

Page	Figure	Link
238 (Figure 1)	-	networkfailure1.pdf
238 (Figure 2)	-	networkfailure2.pdf
238 (Figure 3)	-	networkfailure3.pdf
242 (Figure 1)	Fig. 10.1.	hashtree.pdf




Chapter 11

Page	Figure	Link
252 (Figure 1)	Fig. 11.1.	xmlproxynode.pdf
253 (Figure 1)	Fig. 11.2	graphshadow.pdf
257 (Figure 1)	Fig. 11.3.	consisthash1.pdf
258 (Figure 1)	Fig. 11.4.	consisthash2.pdf
259 (Figure 1)	Fig. 11.5.	consisthash3.pdf




Chapter 12

Page	Figure	Link
262 (Figure 1)	Fig. 12.1.	masterslave.pdf
263 (Figure 1)	Fig. 12.2.	masterrecord.pdf
263 (Figure 2)	Fig. 12.3.	mastermaster.pdf
264 (Figure 1)	Fig. 12.4.	twowayfail1.pdf
264 (Figure 2)	Fig. 12.5.	twowayfail2.pdf
267 (Figure 1)	Fig. 12.6.	twophasecommit.pdf
268 (Figure 1)	Fig. 12.7.	twophasecommit2.pdf
270 (Figure 1)	Fig. 12.8.	paxos1.pdf
272 (Figure 1)	Fig. 12.9.	paxos2.pdf
273 (Figure 1)	Fig. 12.10.	paxos3.pdf
274 (Figure 1)	Fig. 12.11.	paxos4.pdf
275 (Figure 1)	Fig. 12.12.	paxos5.pdf
279 (Figure 1)	Fig. 12.13.	lamportclock.pdf
279 (Figure 2)	Fig. 12.14.	lamportclock2.pdf
280 (Figure 1)	Fig. 12.15.	lamportclock3.pdf
281 (Figure 1)	Fig. 12.16.	lamportclock4.pdf
283 (Figure 1)	Fig. 12.17.	vectorclock2.pdf
284 (Figure 1)	Fig. 12.18.	vectorclock.pdf
287 (Figure 1)	Fig. 12.19.	versionvector.pdf
288 (Figure 1)	Fig. 12.20.	versionvector2.pdf
291 (Figure 1)	Fig. 12.21.	versionvector3.pdf
292 (Figure 1)	Fig. 12.22.	versionvector4.pdf




Chapter 13

Page	Figure	Link
296 (Figure 1)	Fig. 13.1.	consistinterfere.pdf
297 (Figure 1)	Fig. 13.2.	consistonecopy.pdf
298 (Figure 1)	Fig. 13.3.	quorumrowa.pdf




Chapter 14

Chapter 15

Page	Figure	Link
321 (Figure 1)	Fig. 15.1.	polyglotpersistence.pdf
323 (Figure 1)	Fig. 15.2.	lambdaarchitecture.pdf
324 (Figure 1)	Fig. 15.3.	multimodel.pdf




< Back to homepage