RDBMS to MongoDB Migration Guide
A@E;67D3F;A@E3@67EF*D35F;57E
74DG3DK
'A@9A1:;F7*3B7D
Table of Contents
#@FDA6G5F;A@
)D93@;L;@98AD-G557EE
!7FF;@9-F3DF76-5:7?37E;9@
DA?,;9;6.34>7EFA >7J;4>73@6K@3?;5-)(
A5G?7@FE
'A67>;@9,7>3F;A@E:;BEI;F:?4766;@93@6
,787D7@5;@9
#@67J;@9
-5:7?3HA>GF;A@3@6F:7#?B35FA@-5:7?37E;9@
BB>;53F;A@#@F79D3F;A@
'A@9AD;H7DE3@6F:7*#
'3BB;@9-+&FA'A@9A-K@F3J
'A@9A99D793F;A@ D3?7IAD=
#3@60;EG3>;L3F;A@
'G>F;,75AD6#.D3@E35F;A@3>'A67>
'3;@F3;@;@9-FDA@9A@E;EF7@5K
1D;F7GD34;>;FK
#?B>7?7@F;@903>;63F;A@A@EFD3;@FE
';9D3F;@93F3FA'A@9A
)B7D3F;A@3>9;>;FK3F-53>7
@34>;@92AGD.73?E
A@5>GE;A@
#@FDA6G5F;A@
.:7D7>3F;A@3>63F343E7:3E477@F:78AG@63F;A@A8
7@F7DBD;E763F3?3@397?7@F8AD8ADFKK73DEGFF:7I3K
I74G;>63@6DG@3BB>;53F;A@EFA63K5AGB>76I;F:
G@D7>7@F;@99DAIF:;@@7I63F3EAGD57E3@6GE7D>A36E3D7
BGE:;@9D7>3F;A@3>63F343E7E47KA@6F:7;D>;?;FE.:;E53@
;@:;4;F4GE;@7EE39;>;FK>;?;FE53>34;>;FK3@6EFD3;@4G697FE
5A?B7>>;@9?AD73@6?AD7AD93@;L3F;A@EFA?;9D3F7FA
3>F7D@3F;H7E
DAG@6A83>>'A@9ABDA<75FE3D7@AI?;9D3F;A@E
8DA?D7>3F;A@3>63F343E7E'A@9A;E67E;9@76FA?77F
F:767?3@6EA8?A67D@3BBEI;F:3F75:@A>A9K8AG@63F;A@
F:3F7@34>7EKAGF:DAG9:
 .:76A5G?7@F63F3?A67>SBD7E7@F;@9KAG the bestthe best
way to work with datway to work with dataa
 6;EFD;4GF76EKEF7?E67E;9@S3>>AI;@9KAGFA
intelligently put datintelligently put data whera where you want ite you want it
 G@;U767JB7D;7@57F:3F9;H7EKAGF:7 frfreedom to runeedom to run
anywheranywheree S3>>AI;@9KAGFA8GFGD7BDAA8KAGDIAD=3@6
7>;?;@3F7H7@6AD>A5=;@
E;>>GEFD3F76;@ ;9GD77@F7DBD;E7E8DA?3H3D;7FKA8
;@6GEFD;7E:3H7?;9D3F76EG557EE8G>>K8DA?D7>3F;A@3>
63F343E7?3@397?7@FEKEF7?E,'-FA'A@9A8AD
?KD;363BB>;53F;A@E
.:;E9G;67;E67E;9@768ADBDA<75FF73?EF:3FI3@FFA=@AI
:AIFA?;9D3F78DA?3@,'-FA'A@9A17BDAH;67
3EF7B4KEF7BDA36?3B67B;5F76;@ ;9GD7
'3@K>;@=E3D7BDAH;676F:DAG9:AGFF:;E6A5G?7@FFA:7>B
9G;67GE7DEFAF:73BBDABD;3F7D7EAGD57EA@>;@7 ADF:7
?AEF5GDD7@F3@667F3;>76;@8AD?3F;A@A@B3DF;5G>3DFAB;5E
B>73E7E77F:7 A@>;@76A5G?7@F3F;A@
)D93@;L;@98AD-G557EE
BB>;53F;A@'A67D@;L3F;A@
35FADK
'3@KGE7DE:3H7EG557EE8G>>K7J75GF76?;9D3F;A@E8DA?
D7>3F;A@3>63F343E7EFA'A@9AGE;@9F:7;DAI@;@F7D@3>
D7EAGD57E#@366;F;A@'A@9A:3EIAD=76I;F:?3@K
5A?B3@;7EFAEGBBADF>3D97DE53>7?AD7EFD3F79;5
OrOrganizationganization Migrated FMigrated Frromom ApplicApplicationation
;E5A A??7D;53>,'- 7A??7D57*>3F8AD?
7"3D?A@K )D35>7*AEF9D7E GEFA?7D3F3'3@397?7@F@3>KF;5E
-:GFF7DVK )D35>7 1743@6'A4;>7-7DH;57E
-793 'K-+& !3?;@9*>3F8AD?E
/@67DD?AGD ';5DAEA8F-+&-7DH7D 7A??7D57
3;6G 'K-+& 174'A4;>7-7DH;57
'.0(7FIAD=E 'G>F;B>7,'- 7@FD3>;L76A@F7@F'3@397?7@F
.7>78A@;53 )D35>7 GEFA?7D55AG@F'3@397?7@F
07D;LA@ )D35>7 -;@9>70;7I?B>AK77-KEF7?E
.:7173F:7D:3@@7> )D35>7'K-+& 'A4;>7(7FIAD=;@9*>3F8AD?E
FigurFigure 1:e 1: 3E7-FG6;7E
?;9D3F;A@EA8F:7;D3BB>;53F;A@7EF3F7.:7BB>;53F;A@
'A67D@;L3F;A@ 35FADK' ;E3BDA87EE;A@3>E7DH;57E
7@9397?7@FF:3FBDAH;67E36H;EADK5A@EG>F;@9BDA9D3?
9AH7D@3@573@63BB>;53F;A@>;875K5>77JB7DF;E7
1AD=;@9I;F:'A@9A5A@EG>F3@FEF:7UDEFEF7B;@F:7
' BDA57EE;EFA;67@F;8K3BB>;53F;A@EF3=7:A>67DE3@6
F:7@4G;>63@;@H7@FADK3@65:3D35F7D;L3F;A@A87J;EF;@9
3BBE478AD7;67@F;8K;@9F:747EFUF53@6;63F7E8AD
?A67D@;L3F;A@ DA?F:7D7I7E5AB7F:7BDA<75FCG3@F;8K
F:775A@A?;5H3>G7A85:3@973@6BDAH;673DA36?3B8AD
67>;H7DK
17EGBBADFF:7?A67D@;L3F;A@A83BB>;53F;A@EF:DAG9:AGF
F:7EA8FI3D767H7>AB?7@F>;875K5>7:3D@7EE;@9B3FF7D@E
3@6F75:@A>A9;7EEG5:3E39;>73@67H)BE?;5DAE7DH;57E
5>AG65A?BGF;@93@6'A@9A47EFBD35F;57E17B3DF@7D
I;F:KAGDF73?EFA3557>7D3F7F:73EE7EE?7@F
BD;AD;F;L3F;A@3@6D767E;9@A8>7935K3BBE3@6IAD=I;F:
F:7?F:DAG9:F:7?A67D@;L3F;A@788ADFEA8D767H7>AB?7@F
5A@EA>;63F;A@3@6ABF;?;L3F;A@ .A>73D@?AD7D7H;7IF:7
'A@9A&7935K'A67D@;L3F;A@B397
!7FF;@9-F3DF76-5:7?37E;9@
.:7?AEF8G@63?7@F3>5:3@97;@?;9D3F;@98DA?3
D7>3F;A@3>63F343E7FA'A@9A;EF:7I3K;@I:;5:F:7
63F3;E?A67>76
EI;F:3@K63F3?A67>;@97J7D5;E7735:GE753E7I;>>47
6;887D7@F4GFF:7D73D7EA?797@7D3>5A@E;67D3F;A@EF:3F
KAG3BB>KFA?AEFE5:7?3?;9D3F;A@BDA<75FE
78AD77JB>AD;@9E5:7?367E;9@ ;9GD7BDAH;67E3
GE78G>D787D7@578ADFD3@E>3F;@9F7D?;@A>A9K8DA?F:7
D7>3F;A@3>FA'A@9AIAD>6
FigurFigure 2:e 2: 'A@9ABB>;53F;A@'A67D@;L3F;A@ 35FADK3557>7D3F;@93@667D;E=;@9,'-';9D3F;A@
RRDBDBMMSS MongoDBMongoDB
3F343E7 3F343E7
.34>7 A>>75F;A@
,AI A5G?7@F
A>G?@ ;7>6
#@67J #@67J
$)#( ?4766766A5G?7@F6A5G?7@F
D787D7@57EAD $lookup FA5A?4;@763F3
8DA?6;887D7@F5A>>75F;A@E
'3F7D;3>;L76
0;7I
)@67?3@6'3F7D;3>;L760;7I
#
.D3@E35F;A@E
'G>F;6A5G?7@F#.D3@E35F;A@EF:3F
53@476;EFD;4GF7635DAEEE53>7AGF
5>GEF7DE
FigurFigure 3:e 3: .7D?;@A>A9K.D3@E>3F;A@
-5:7?367E;9@D7CG;D7E35:3@97;@B7DEB75F;H78AD63F3
3D5:;F75FE67H7>AB7DE3@6E
R DA?F:7>7935KD7>3F;A@3>63F3?A67>F:3FV3FF7@E63F3
;@FAD;9;66;?7@E;A@3>F34G>3DEFDG5FGD7EA8DAIE3@6
5A>G?@E
R .A3D;5:3@66K@3?;56A5G?7@F63F3?A67>I;F:
7?476676EG46A5G?7@FE3@63DD3KE
DA?,;9;6.34>7EFA >7J;4>73@6
K@3?;5-)(A5G?7@FE
'G5:A8F:763F3I7GE7FA63K:3E5A?B>7JEFDG5FGD7EF:3F
53@47?A67>763@6D7BD7E7@F76?AD778U5;7@F>KGE;@9
$-)($3H3-5D;BF)4<75F(AF3F;A@6A5G?7@FED3F:7DF:3@
F34>7E
'A@9AEFAD7E$-)(6A5G?7@FE;@34;@3DK
D7BD7E7@F3F;A@53>>76-)(;@3DK$-)(-)(
7@5A6;@97JF7@6EF:7BABG>3D$-)(D7BD7E7@F3F;A@FA
;@5>G67366;F;A@3>63F3FKB7EEG5:3E;@F675;?3>>A@93@6
VA3F;@9BA;@F
1;F:EG46A5G?7@FE3@63DD3KE$-)(6A5G?7@FE3>EA
3>;9@I;F:F:7EFDG5FGD7A8A4<75FE3FF:73BB>;53F;A@>7H7>
.:;E?3=7E;F73EK8AD67H7>AB7DEFA?3BF:763F3GE76;@
F:73BB>;53F;A@FA;FE3EEA5;3F766A5G?7@F;@F:763F343E7
K5A@FD3EFFDK;@9FA?3BF:7A4<75FD7BD7E7@F3F;A@A8F:7
63F3FAF:7F34G>3DD7BD7E7@F3F;A@A83@,'-E>AIE
6AI@67H7>AB?7@F66;@9)4<75F,7>3F;A@3>'3BB7DE
),'E53@5D73F7366;F;A@3>5A?B>7J;FK4KD76G5;@9F:7
V7J;4;>;FKFA7HA>H7E5:7?3E3@6FAABF;?;L7CG7D;7EFA
?77F@7I3BB>;53F;A@D7CG;D7?7@FE
.:7BDA<75FF73?E:AG>6EF3DFF:7E5:7?367E;9@BDA57EE
4K5A@E;67D;@9F:73BB>;53F;A@OED7CG;D7?7@FE#FE:AG>6
?A67>F:763F3;@3I3KF:3FF3=7E36H3@F397A8F:7
6A5G?7@F?A67>OEV7J;4;>;FK#@E5:7?3?;9D3F;A@E;F?3K
4773EKFA?;DDADF:7D7>3F;A@3>63F343E7OEV3FE5:7?3FA
F:76A5G?7@F?A67>"AI7H7DF:;E3BBDA35:@793F7EF:7
36H3@F397E7@34>764KF:76A5G?7@F?A67>OED;5:
7?47667663F3EFDG5FGD7E AD7J3?B>763F3F:3F47>A@9E
FA3B3D7@F5:;>6D7>3F;A@E:;B;@FIA,'-F34>7EIAG>6
5A??A@>K475A>>3BE767?476676;@FA3E;@9>7
6A5G?7@F;@'A@9A
FigurFigure 4:e 4: ,7>3F;A@3>-5:7?3 >3F.34>7E
#@ ;9GD7F:7,'-GE7EF:7 Pers_ID U7>6FA$)#(
F:7 Person F34>7I;F:F:7 Car F34>7FA7@34>7F:7
3BB>;53F;A@FAD7BADF735:53DOEAI@7D/E;@9F:76A5G?7@F
?A67>7?476676EG46A5G?7@FE3@63DD3KE78875F;H7>K
BD7$)#(63F34K5A?4;@;@9D7>3F76U7>6E;@3E;@9>763F3
EFDG5FGD7,AIE3@65A>G?@EF:3FI7D7FD36;F;A@3>>K
@AD?3>;L763@66;EFD;4GF7635DAEEE7B3D3F7F34>7E53@@AI
47EFAD76FA97F:7D;@3E;@9>76A5G?7@F7>;?;@3F;@9F:7
@776FA$)#(E7B3D3F7F34>7EI:7@F:73BB>;53F;A@:3EFA
D7FD;7H75A?B>7F7D75AD6E
'A67>;@9F:7E3?763F3;@'A@9A7@34>7EGEFA5D73F7
3E5:7?3;@I:;5:I77?4763@3DD3KA8EG46A5G?7@FE
8AD735:53D6;D75F>KI;F:;@F:7*7DEA@6A5G?7@F
{
first_name: “Paul”,
surname: “Miller”,
city: “London”,
location: [45.123,47.232],
cars: [
{ model: “Bentley”,
year: 1973,
value: 100000, ….},
{ model: “Rolls Royce”,
year: 1965,
value: 330000, ….},
]
}
#@F:;EE;?B>77J3?B>7F:7D7>3F;A@3>?A67>5A@E;EFEA8A@>K
FIAF34>7E#@D73>;FK?AEF3BB>;53F;A@EI;>>@776F7@E
:G@6D76EAD7H7@F:AGE3@6EA8F34>7E.:;E3BBDA35:6A7E
@AFD7V75FF:7I3K3D5:;F75FEF:;@=34AGF63F3@ADF:7I3K
;@I:;5:67H7>AB7DEID;F73BB>;53F;A@E
FigurFigure 5:e 5: 'A67>;@935GEFA?7DI;F:F:7D7>3F;A@3>
63F343E763F3;EEB>;F35DAEE?G>F;B>7F34>7E
.A8GDF:7D;>>GEFD3F7F:76;887D7@57E47FI77@F:7D7>3F;A@3>
3@66A5G?7@F?A67>E5A@E;67D3E>;9:F>K?AD75A?B>7J
7J3?B>7GE;@935GEFA?7DA4<75F3EE:AI@;@ ;9GD7
.:75GEFA?7D63F3;E@AD?3>;L7635DAEE?G>F;B>7F34>7E
I;F:F:73BB>;53F;A@D7>K;@9A@F:7,'-FA<A;@E7H7@
E7B3D3F7F34>7E;@AD67DFA4G;>6F:75GEFA?7DBDAU>71;F:
'A@9A3>>A8F:75GEFA?7D63F3;E5A@F3;@76I;F:;@3
E;@9>7D;5:6A5G?7@F5A>>3BE;@9F:75:;>6F34>7E;@FA
7?476676EG46A5G?7@FE3@63DD3KE
{
"_id": "5ad88534e3632e1a35a58d00",
"customerID": 12345,
"name": {
"first": "John",
"last": "Doe" },
"address": [
{ "location": "work",
"address": {
"street": "16 Hatfields",
"city": "London",
"postal_code": "SE1 8DJ"},
"country": "United Kingdom",
"geo": { "type": "Point", "coord": [
51.5065752,-0.109081]}}
],
"email": "[email protected]",`
"phone": [
{ "location": "work",
"number": "+44-1234567890"}
],
"dob": "1977-04-01T05:00:00Z",
"interests": [
"devops",
"data science"
],
"annualSpend": 1292815.75
}
A5G?7@FE3D73?G5:?AD7@3FGD3>I3KFA67E5D;4763F3
.:;E3>>AIE6A5G?7@FEFA475>AE7>K3>;9@76FAF:7
EFDG5FGD7A8A4<75FE;@F:7BDA9D3??;@9>3@9G397E3
D7EG>F;FOEE;?B>7D3@683EF7D8AD67H7>AB7DEFA?A67>:AI
63F3;@F:73BB>;53F;A@I;>>?3BFA63F3EFAD76;@F:7
63F343E7
)F:7D6H3@F397EA8F:7A5G?7@F'A67>
#@366;F;A@FA?3=;@9;F?AD7@3FGD3>FAD7BD7E7@F63F33F
F:763F343E7>7H7>F:76A5G?7@F?A67>3>EABDAH;67E
B7D8AD?3@573@6E53>34;>;FK36H3@F397E
R .:75A?B>7F76A5G?7@F53@473557EE76I;F:3E;@9>7
53>>FAF:763F343E7D3F:7DF:3@:3H;@9FA$)#(?G>F;B>7
F34>7EFAD7EBA@6FA3CG7DK.:7'A@9A6A5G?7@F
;EB:KE;53>>KEFAD763E3E;@9>7A4<75FD7CG;D;@9A@>K3
E;@9>7D7368DA??7?ADKAD6;E=)@F:7AF:7D:3@6
,'-$)#(ED7CG;D7?G>F;B>7D736E8DA??G>F;B>7
B:KE;53>>A53F;A@E
R E6A5G?7@FE3D7E7>85A@F3;@766;EFD;4GF;@9F:7
63F343E735DAEE?G>F;B>7@A67E3BDA57EE53>>76
E:3D6;@9475A?7EE;?B>7D3@6?3=7E;FBAEE;4>7FA
35:;7H7:AD;LA@F3>E53>34;>;FKA@5A??A6;FK:3D6I3D7
.:7@A>A@97D@776EFAIADDK34AGFF:7
B7D8AD?3@57B7@3>FKA87J75GF;@95DAEE@A67$)#(E
E:AG>6F:7K7H7@47BAEE;4>7;@F:77J;EF;@9,'-
FA5A>>75F63F38DA?6;887D7@FF34>7E
$A;@;@9A>>75F;A@E
.KB;53>>K;F;E?AEF36H3@F397AGEFAF3=7367@AD?3>;L76
63F3?A67>;@93BBDA35:8ADAB7D3F;A@3>63F343E7ESF:7
78U5;7@5KA8D736;@9ADID;F;@93@7@F;D7D75AD6;@3E;@9>7
AB7D3F;A@AGFI7;9:;@93@K?A67EF;@5D73E7;@EFAD397
D7CG;D7?7@FE"AI7H7DF:7D73D77J3?B>7EI:7D7
@AD?3>;L;@963F353@4747@7U5;3>7EB75;3>>KI:7@63F3
8DA??G>F;B>7EAGD57E@776EFA474>7@6768AD3@3>KE;ES
F:;E53@476A@7GE;@9F:7 $lookup EF397;@F:7
'A@9A99D793F;A@ D3?7IAD=
.:799D793F;A@ D3?7IAD=;E3B;B7>;@78AD63F3
399D793F;A@?A67>76A@F:75A@57BFA863F3BDA57EE;@9
B;B7>;@7EA5G?7@FE7@F7D3?G>F;EF397B;B7>;@7F:3F
FD3@E8AD?EF:76A5G?7@FE;@FA399D793F76D7EG>FE.:7
B;B7>;@75A@E;EFEA8EF397E735:EF397FD3@E8AD?EF:7
6A5G?7@FE3EF:7KB3EEF:DAG9:
.:7 >AA=GB 399D793F;A@B;B7>;@7EF397BDAH;67E$)#(
53B34;>;F;7E;@'A@9AEGBBADF;@9F:77CG;H3>7@FA8-+&
EG4CG7D;7E3@6@A@7CG;<A;@E
E3@7J3?B>7;8F:7>78F5A>>75F;A@5A@F3;@E order
6A5G?7@FE8DA?3E:ABB;@953DF3BB>;53F;A@F:7@F:7
$lookup AB7D3FAD53@?3F5:F:7 product_id D787D7@57E
8DA?F:AE76A5G?7@FEFA7?476F:7?3F5:;@9BDA6G5F
67F3;>E8DA?F:7 products 5A>>75F;A@
'A@9A3>EAA887DEF:7 $graphLookup 399D793F;A@
EF39753>>76FAD75GDE;H7>K>AA=GB3E7FA86A5G?7@FEI;F:
3EB75;U567U@76D7>3F;A@E:;BFA3EF3DF;@96A5G?7@F
7H7>AB7DE53@EB75;8KF:7?3J;?G?67BF:8ADF:7
D75GDE;A@3@63BB>K366;F;A@3>U>F7DEFAA@>KE73D5:@A67E
F:3F?77FEB75;U5CG7DKBD76;53F7E $graphLookup 53@
D75GDE;H7>KCG7DKI;F:;@3E;@9>75A>>75F;A@AD35DAEE
?G>F;B>75A>>75F;A@E
7U@;@9F:7A5G?7@F-5:7?3
.:73BB>;53F;A@OE63F33557EEB3FF7D@EE:AG>66D;H7E5:7?3
67E;9@I;F:3EB75;U58A5GEA@
R .:7D736ID;F7D3F;AA863F343E7AB7D3F;A@E3@6
I:7F:7D;F;E?AD7;?BADF3@FFAABF;?;L7B7D8AD?3@57
ApplicApplicationation RRDBDBMMS ActionS Action
MongoDBMongoDB
ActionAction
D73F7
*DA6G5F
,75AD6
INSERT FA (n)
F34>7EBDA6G5F
67E5D;BF;A@BD;57
?3@G835FGD7D7F5
insert() FA
6A5G?7@F
;EB>3K
*DA6G5F
,75AD6
SELECT 3@6 JOIN
(n) BDA6G5FF34>7E
find() E;@9>7
6A5G?7@F
66
*DA6G5F
,7H;7I
INSERT FAPD7H;7IQ
F34>78AD7;9@=7K
FABDA6G5FD75AD6
insert() FA
PD7H;7IQ
5A>>75F;A@
D787D7@57FA
BDA6G5F
6A5G?7@F
'AD7
5F;A@EM
MM MM
FigurFigure 6:e 6: @3>KL;@9+G7D;7EFA7E;9@F:7)BF;?G?
-5:7?3
8ADA@7AH7DF:7AF:7D
R .:7FKB7EA8CG7D;7E3@6GB63F7EB7D8AD?764KF:7
63F343E7
R .:7>;875K5>7A8F:763F33@69DAIF:D3F7A86A5G?7@FE
E3UDEFEF7BF:7BDA<75FF73?E:AG>66A5G?7@FF:7
AB7D3F;A@EB7D8AD?76A@F:73BB>;53F;A@OE63F35A?B3D;@9
 "AIF:7E73D75GDD7@F>K;?B>7?7@F764KF:7D7>3F;A@3>
63F343E7
 "AI'A@9A5AG>6;?B>7?7@FF:7?
;9GD7D7BD7E7@FE3@7J3?B>7A8F:;E7J7D5;E7
.:;E3@3>KE;E:7>BEFA;67@F;8KF:7;673>6A5G?7@FE5:7?3
3@6;@67J7E8ADF:73BB>;53F;A@63F33@6IAD=>A3643E76
A@F:7CG7D;7E3@6AB7D3F;A@EFA47B7D8AD?76393;@EF;F
.:7BDA<75FF73?53@3>EA;67@F;8KF:77J;EF;@93BB>;53F;A@E
?AEF5A??A@CG7D;7E4K3@3>KL;@9F:7>A9E?3;@F3;@764K
F:7,'-.:;E3@3>KE;E;67@F;U7EF:763F3F:3F;E?AEF
8D7CG7@F>K3557EE76FA97F:7D3@653@F:7D78AD7BAF7@F;3>>K
47EFAD76FA97F:7DI;F:;@3E;@9>7'A@9A6A5G?7@F
'A67>;@9,7>3F;A@E:;BEI;F:?4766;@9
3@6,787D7@5;@9
75;6;@9I:7@FA7?47636A5G?7@FAD;@EF7365D73F73
D787D7@5747FI77@E7B3D3F76A5G?7@FE;@6;887D7@F
5A>>75F;A@E;E3@3BB>;53F;A@EB75;U55A@E;67D3F;A@.:7D7
3D7:AI7H7DEA?797@7D3>5A@E;67D3F;A@EFA9G;67F:7
675;E;A@6GD;@9E5:7?367E;9@
?4766;@9
3F3I;F:3AD?3@KD7>3F;A@E:;BI:7D7F:7P?3@KQ
A4<75FE3>I3KE3BB73DI;F:AD3D7H;7I76;@F:75A@F7JFA8
F:7;DB3D7@F6A5G?7@FE3D7@3FGD3>53@6;63F7E8AD
7?4766;@9I;F:;@3E;@9>76A5G?7@F.:75A@57BFA863F3
AI@7DE:;B3@65A@F3;@?7@F53@3>EA47?A67>76I;F:
7?4766;@9/E;@9F:7BDA6G5F63F37J3?B>734AH7
BDA6G5FBD;5;@9S4AF:5GDD7@F3@6:;EFAD;53>SE:AG>647
7?476676I;F:;@F:7BDA6G5F6A5G?7@FE;@57;F;EAI@76
4K3@65A@F3;@76I;F:;@F:3FEB75;U5BDA6G5F#8F:7BDA6G5F
;E67>7F76F:7BD;5;@9475A?7E;DD7>7H3@F
"AI7H7D@AF3>>3@6?3@KD7>3F;A@E:;BE3D7EG;F34>7
8AD7?4766;@9;@3E;@9>76A5G?7@F,787D7@5;@947FI77@
6A5G?7@FE;@6;887D7@F5A>>75F;A@EE:AG>647GE76I:7@
R 6A5G?7@F;E8D7CG7@F>KD7364GF5A@F3;@E63F3F:3F;E
D3D7>K3557EE76?4766;@9F:;E63F3A@>K;@5D73E7EF:7
;@?7?ADKD7CG;D7?7@FEF:7IAD=;@9E7FA8F:7
5A>>75F;A@
R )@7B3DFA836A5G?7@F;E8D7CG7@F>KGB63F763@6
5A@EF3@F>K9DAI;@9;@E;L7I:;>7F:7D7?3;@67DA8F:7
6A5G?7@F;ED7>3F;H7>KEF3F;5
R .:75A?4;@766A5G?7@FE;L7IAG>67J5776'A@9AOE
'6A5G?7@F>;?;F8AD7J3?B>7I:7@?A67>;@9
?3@KD7>3F;A@E:;BEEG5:3EBDA6G5FD7H;7IEFA
BDA6G5F
,787D7@5;@9
,787D7@5;@953@:7>B366D7EEF:75:3>>7@97E5;F7634AH7
3@6;E3>EAFKB;53>>KGE76I:7@?A67>;@9?3@K?3@K
D7>3F;A@E:;BE"AI7H7DF:73BB>;53F;A@I;>>@776FA;EEG7
8A>>AIGBCG7D;7EFAD7EA>H7F:7D787D7@57D7CG;D;@9
366;F;A@3>DAG@6FD;BEFAF:7E7DH7DADD7CG;D73P<A;@;@9Q
AB7D3F;A@GE;@9'A@9AOE >AA=GB 399D793F;A@B;B7>;@7
EF397
;887D7@F7E;9@!A3>E
A?B3D;@9F:7E7FIA67E;9@ABF;A@ES7?4766;@9
EG46A5G?7@FEH7DEGED787D7@5;@947FI77@6A5G?7@FES
:;9:>;9:FE38G@63?7@F3>6;887D7@5747FI77@D7>3F;A@3>3@6
6A5G?7@F63F343E7E
R .:7,'-ABF;?;L7E63F3EFAD39778U5;7@5K3E;F
I3E5A@57;H763F3F;?7I:7@EFAD397I3EF:7?AEF
7JB7@E;H75A?BA@7@FA8F:7EKEF7?
R 'A@9AOE6A5G?7@F?A67>;EABF;?;L768AD:AIF:7
3BB>;53F;A@3557EE7E63F33EB7D8AD?3@5767H7>AB7D
F;?73@6EB776FA?3D=7F3D7@AI?AD7;?BADF3@FF:3@
EFAD397HA>G?7E
3F3?A67>;@9;E3@7JB3@E;H7FAB;5.A:7>BKAG?3=7F:7
D;9:F675;E;A@E:7D7;E3EG??3DKA8F:7=7KD7EAGD57EKAG
E:AG>6D7H;7I
R .:7'A@9A6A5G?7@F3F;A@BDAH;67E3@7JF7@E;H7
E75F;A@A@ 63F3?A67>;@9EF3DF;@98DA?:;9:>7H7>
5A@57BFEA8F:76A5G?7@F63F3?A67>478AD7
BDA9D7EE;@9FABD35F;53>7J3?B>7E3@667E;9@B3FF7D@E
;@5>G6;@9?AD767F3;>A@D787D7@5;@93@67?4766;@9
R 2AGE:AG>63>EAD7H;7IAGD G;>6;@9I;F:*3FF7D@E4>A9
E7D;7E FA>73D@?AD734AGFEB75;U5E5:7?367E;9@47EF
BD35F;57E8AD6;887D7@FGE753E7E;@5>G6;@953F3>A93@6
5A@F7@F?3@397?7@F#A.?A4;>73BBE3@3>KF;5E3@6
E;@9>7H;7I;75GEFA?7D#FAH7D>3KEF:7E7GE7
53E7EI;F:EB75;U5E5:7?367E;9@B3FF7D@EEG5:3E
H7DE;A@;@94G5=7F;@9D787D7@5;@93@69D3B:E
R 'A@9A/@;H7DE;FKA887DE3@A5AEFI7443E76
FD3;@;@95AGDE7A@63F3?A67>;@9.:;E;E39D73FI3KFA
=;5=EF3DFKAGD>73D@;@9A@E5:7?367E;9@I;F:F:7
6A5G?7@F63F3?A67>
#@67J;@9
#@3@K63F343E7;@67J7E3D7F:7E;@9>74;997EFFG@34>7
B7D8AD?3@57835FAD3@63D7F:7D78AD7;@F79D3>FAE5:7?3
67E;9@
#@67J7E;@'A@9A>3D97>K5ADD7EBA@6FA;@67J7E;@3
D7>3F;A@3>63F343E7'A@9AGE7E.D77;@67J7E3@6
@3F;H7>KEGBBADFEE75A@63DK;@67J7EEEG5:;FI;>>47
;??76;3F7>K83?;>;3DFAF:AE75A?;@98DA?3-+&
435=9DAG@6
.:7FKB73@68D7CG7@5KA8F:73BB>;53F;A@OECG7D;7EE:AG>6
;@8AD?;@67JE7>75F;A@EI;F:3>>63F343E7E;@67J;@96A7E
@AF5A?78D77;F;?BAE7EAH7D:736A@ID;F7E3@6D7EAGD57
6;E=3@6?7?ADKGE397
#@67J.KB7E
'A@9A:3E3D;5:CG7DK?A67>F:3FBDAH;67EV7J;4;>;FK;@
:AI63F3;E3557EE76K6783G>F'A@9A5D73F7E3@
;@67JA@F:76A5G?7@FOE _id BD;?3DK=7KU7>6
>>GE7D67U@76;@67J7E3D7E75A@63DK;@67J7E#@67J7E
53@475D73F76A@3@KB3DFA8F:7$-)(6A5G?7@FS
;@5>G6;@9;@E;67EG46A5G?7@FE3@63DD3K7>7?7@FES
?3=;@9F:7??G5:?AD7BAI7D8G>F:3@F:AE7A887D764K
D7>3F;A@3>63F343E7E
#@67JABF;A@E8AD'A@9A;@5>G67
R Compound Indexes.Compound Indexes. E;@9>7;@67JEFDG5FGD7F:3F
?3;@F3;@ED787D7@57EFA?G>F;B>7U7>6E AD7J3?B>7
5A@E;67D3@3BB>;53F;A@F:3FEFAD7E63F334AGF
5GEFA?7DE.:73BB>;53F;A@?3K@776FAU@65GEFA?7DE
43E76A@>3EF@3?7UDEF@3?73@6EF3F7A8D7E;67@57
1;F:35A?BAG@6;@67JA@>3EF@3?7UDEF@3?73@6
EF3F7A8D7E;67@57CG7D;7E5AG>678U5;7@F>K>A53F7
B7AB>7I;F:3>>F:D77A8F:7E7H3>G7EEB75;U76@
366;F;A@3>47@7UFA835A?BAG@6;@67J;EF:3F3@K
>736;@9U7>6EI;F:;@F:7;@67J53@47GE76EA87I7D
;@67J7EA@E;@9>7U7>6E?3K47@757EE3DKF:;E
5A?BAG@6;@67JIAG>63>EAABF;?;L7CG7D;7E>AA=;@98AD
5GEFA?7DE4K>3EF@3?7AD>3EF@3?73@6UDEF@3?7
R Unique Indexes.Unique Indexes. KEB75;8K;@93@;@67J3EG@;CG7
'A@9AI;>>D7<75F;@E7DFEA8@7I6A5G?7@FEAD
GB63F7EFA7J;EF;@96A5G?7@FEI:;5:IAG>6:3H7
D7EG>F76;@6GB>;53F7H3>G7E8ADF:7;@67J76U7>6#83
5A?BAG@6;@67J;EEB75;U763EG@;CG7F:75A?4;@3F;A@
A8H3>G7E?GEF47G@;CG7
R Array Indexes.Array Indexes. ADU7>6EF:3F5A@F3;@3@3DD3K735:
3DD3KH3>G7;EEFAD763E3E7B3D3F7;@67J7@FDK AD
7J3?B>76A5G?7@FEF:3F67E5D;473BDA6G5F?;9:F
;@5>G673@3DD3K5A@F3;@;@9;FE?3;@3FFD;4GF7E#8F:7D7;E
3@;@67JA@F:73FFD;4GF7EU7>6735:3FFD;4GF7;E;@67J76
3@6CG7D;7EA@F:73FFD;4GF7U7>653@47ABF;?;L764K
F:;E;@67J.:7D7;E@AEB75;3>EK@F3JD7CG;D768AD
5D73F;@93DD3K;@67J7ES;8F:7U7>65A@F3;@E3@3DD3K;F
I;>>47;@67J763E3@3DD3K;@67J
R TTTL Indexes.TL Indexes. #@EA?753E7E63F3E:AG>67JB;D7
3GFA?3F;53>>K.;?7FA&;H7..&;@67J7E3>>AIF:7GE7D
FAEB75;8K3B7D;A6A8F;?738F7DI:;5:F:763F343E7I;>>
3GFA?3F;53>>K67>7F7F:763F35A??A@GE7A8..&
;@67J7E;E3BB>;53F;A@EF:3F?3;@F3;@3DA>>;@9I;@6AIA8
:;EFADK79?AEFD757@F63KE8ADGE7D35F;A@E
EG5:3E5>;5=EFD73?E
R Geospatial Indexes.Geospatial Indexes. 'A@9ABDAH;67E97AEB3F;3>
;@67J7EFAABF;?;L7CG7D;7ED7>3F76FA>A53F;A@I;F:;@3
FIA6;?7@E;A@3>EB357EG5:3EBDA<75F;A@EKEF7?E8AD
F:773DF:.:7E7;@67J7E3>>AI'A@9AFAABF;?;L7
CG7D;7E8AD6A5G?7@FEF:3F5A@F3;@3BA>K9A@ADBA;@FE
F:3F3D75>AE7EFFA39;H7@BA;@FAD>;@7F:3F3D7I;F:;@3
5;D5>7D75F3@9>7ADBA>K9A@ADF:3F;@F7DE75F35;D5>7
D75F3@9>7ADBA>K9A@
R WWildcildcarard Indexes.d Indexes. ADIAD=>A36EI;F:?3@K36:A5
CG7DKB3FF7D@EADF:3F:3@6>7:;9:>KBA>K?ADB:;5
6A5G?7@FEFDG5FGD7E I;>653D6;@67J7E 9;H7KAG3>AFA8
7JFD3V7J;4;>;FK2AG53@67U@73U>F7DF:3F3GFA?3F;53>>K
;@67J7E3>>?3F5:;@9U7>6EEG46A5G?7@FE3@63DD3KE;@
35A>>75F;A@EI;F:3@K;@67JF:7K3>EA@776FA47
EFAD763@6?3;@F3;@76EAI;>>366AH7D:736FAF:7
63F343E7#8KAGD3BB>;53F;A@OECG7DKB3FF7D@E3D7=@AI@
;@36H3@57F:7@KAGE:AG>6GE7?AD7E7>75F;H7;@67J7E
A@F:7EB75;U5U7>6E3557EE764KF:7CG7D;7E
R Partial Indexes.Partial Indexes. *3DF;3>#@67J7E53@47H;7I763E3
?AD7V7J;4>77HA>GF;A@A8-B3DE7#@67J7EI:7D7F:7
53@EB75;8K3@7JBD7EE;A@F:3FI;>>475:75=76FA
67F7D?;@7I:7F:7D36A5G?7@FE:AG>647;@5>G676;@3
B3DF;5G>3D;@67J798AD3@AD67DE5A>>75F;A@3@;@67J
A@EF3F73@667>;H7DK5A?B3@K?;9:FA@>K47@776768AD
35F;H7AD67DE3@6EAF:7;@67J5AG>647?367
5A@6;F;A@3>A@ {orderState: "active"} SF:7D74K
D76G5;@9F:7;?B35FFA?7?ADKEFAD3973@6ID;F7
B7D8AD?3@57I:;>7EF;>>ABF;?;L;@9E73D5:7EAH7DF:7
35F;H7AD67DE
R Hash Indexes.Hash Indexes. "3E:;@67J7E5A?BGF73:3E:A8F:7
H3>G7A83U7>63@6;@67JF:7:3E:76H3>G7.:7BD;?3DK
GE7A8F:;E;@67J;EFA7@34>7:3E:43E76E:3D6;@93
E;?B>73@6G@;8AD?6;EFD;4GF;A@A86A5G?7@FE35DAEE
E:3D6E
R TText Searext Searcch Indexes.h Indexes. 'A@9ABDAH;67E3EB75;3>;L76
;@67J8ADF7JFE73D5:F:3FGE7E36H3@576
>3@9G397EB75;U5>;@9G;EF;5DG>7E8ADEF7??;@9
FA=7@;L3F;A@3@6EFABIAD6E+G7D;7EF:3FGE7F:7F7JF
E73D5:;@67JD7FGD@6A5G?7@FE;@D7>7H3@57AD67D35:
5A>>75F;A@?3K:3H73F?AEFA@7F7JF;@67J4GF;F?3K
;@5>G67?G>F;B>7U7>6E#8KAG3D7DG@@;@9'A@9A;@
F:78G>>K?3@3976F>3E9>A43>5>AG663F343E7E7DH;57
5A@E;67DGE;@9 F>3E-73D5: I:;5:BDAH;67E3&G57@7
;@67J;@F79D3F76I;F:F:7'A@9A63F343E7 .-
BDAH;67E:;9:7DB7D8AD?3@573@69D73F7DV7J;4;>;FKFA
U>F7DD3@=3@6EADFF:DAG9:KAGD63F343E7FACG;5=>K
EGD8357F:7?AEFD7>7H3@FD7EG>FEFAKAGDGE7DE
)BF;?;L;@9*7D8AD?3@571;F:#@67J7E
'A@9AOECG7DKABF;?;L7DE7>75FEF:7;@67J7?B;D;53>>K4K
A553E;A@3>>KDG@@;@93>F7D@3F7CG7DKB>3@E3@6E7>75F;@9
F:7B>3@I;F:F:747EFD7EBA@E7F;?7.:7CG7DKABF;?;L7D
53@47AH7DD;667@GE;@9F:7 cursor.hint() ?7F:A6
'A@9AOE 7JB>3;@?7F:A6 7@34>7EKAGFAF7EFCG7D;7E
8DA?KAGD3BB>;53F;A@E:AI;@9;@8AD?3F;A@34AGF:AI3
CG7DKI;>>47ADI3ED7EA>H76;@5>G6;@9
R 1:;5:;@67J7EI7D7GE76
R 1:7F:7DF:7CG7DKI3E5AH7D764KF:7;@67JAD@AF
R 1:7F:7D3@;@?7?ADKEADFI3EB7D8AD?76I:;5:
;@6;53F7E3@;@67JIAG>64747@7U5;3>
R .:7@G?47DA8;@67J7@FD;7EE53@@76
R .:7@G?47DA86A5G?7@FED7FGD@763@6F:7@G?47D
D736
R "AI>A@9F:7CG7DKFAA=FAD7EA>H7;@?;>>;E75A@6E
R 1:;5:3>F7D@3F;H7CG7DKB>3@EI7D7D7<75F76I:7@
GE;@9F:7 allPlansExecution ?A67
.:77JB>3;@B>3@I;>>E:AI?;>>;E75A@6E;8F:7CG7DKI3E
D7EA>H76;@>7EEF:3@?EI:;5:;EFKB;53>8ADI7>>FG@76
CG7D;7E
.:7 'A@9AA?B3EE!/# H;EG3>;L7E7JB>3;@AGFBGF
?3=;@9;F7H7@73E;7D8ADKAGFA;67@F;8K3@6D7EA>H7
B7D8AD?3@57;EEG7E
.:7 'A@9A+G7DK*DAU>7D :7>BE7JBAE7B7D8AD?3@57
;EEG7E4K6;EB>3K;@9E>AIDG@@;@9CG7D;7E4K6783G>F
CG7D;7EF:3F7J5776?E3@6F:7;D=7KB7D8AD?3@57
EF3F;EF;5E6;D75F>K;@F:7/#
FigurFigure 7:e 7: 'A@9AF>3E+G7DK*DAU>;@9
5:3DFBDAH;67E3:;9:>7H7>H;7IA8F:3F;@8AD?3F;A@F:3F
?3=7E;F73EKFACG;5=>K;67@F;8KAGF>;7DE3@697@7D3>
FD7@6EI:;>73F34>7A887DEAB7D3F;A@EF3F;EF;5E4K
@3?7EB35763F343E73@65A>>75F;A@3@6AB7D3F;A@FKB7
2AG53@5:AAE7I:;5:?7FD;5FAU>F7D3@6>;EFAB7D3F;A@E
.:;E;@5>G67EAB7D3F;A@7J75GF;A@F;?76A5G?7@FE
E53@@76FAD7FGD@76D3F;AI:7F:7D3@;@67JI3EGE76
I:7F:7D3@;@?7?ADKEADFA55GDD763@6?AD72AG53@
E7>75F3EB75;U5F;?78D3?78ADF:7AB7D3F;A@E6;EB>3K76
8DA?F:7B3EF?;@GF7EFAF:7B3EF:AGDE
)@57KAG:3H7;67@F;U76I:;5:AB7D3F;A@E3D7BAF7@F;3>>K
BDA4>7?3F;5F:7+G7DK*DAU>7D3>>AIEKAGFA6;9677B7D
;@FAAB7D3F;A@>7H7>EF3F;EF;5EFA93;@?AD7;@E;9:F;@FA
I:3FOE:3BB7@;@92AG53@H;7I9D3@G>3D;@8AD?3F;A@A@3
EB75;U5AB7D3F;A@;@F:75A@F7JFA8E;?;>3DAB7D3F;A@E
I:;5:53@:7>BKAG;67@F;8KI:3F97@7D3>ABF;?;L3F;A@E
@776FA47?367FA;?BDAH7B7D8AD?3@57.:7'A@9A
F>3E+G7DK*DAU>7D;E3H3;>34>7I;F:AGF366;F;A@3>5AEFAD
B7D8AD?3@57AH7D:736
#8KAG3D7DG@@;@9'A@9AA@BD7?;E7E )BE'3@397D S
B3DFA8'A@9A@F7DBD;E76H3@576S3>EA;@5>G67E3
CG7DKBDAU>7D
H7@I;F:3>>A8F:7F7>7?7FDKBDAH;6764K'A@9AOEFAA>E
KAG3D7EF;>>D7EBA@E;4>78ADBG>>;@93@63@3>KL;@9F:7
D7CG;D7663F3FA?3=7675;E;A@EA@I:;5:;@67J7EFA366
'A@9AF>3E3@6)BE'3@397D7>;?;@3F7EF:;E788ADF
I;F:F:7 *7D8AD?3@576H;EAD I:;5:?A@;FADECG7D;7EF:3F
FAA=?AD7F:3@?EFA7J75GF73@63GFA?3F;53>>K
EG997EFE@7I;@67J7EFA;?BDAH7B7D8AD?3@57
,75A??7@676;@67J7E3D7355A?B3@;764KE3?B>7
CG7D;7E9DAGB764KCG7DKE:3B7;7CG7D;7EI;F:3E;?;>3D
BD76;53F7EFDG5FGD7EADF3@6BDA<75F;A@F:3FI7D7DG@
393;@EF35A>>75F;A@F:3FIAG>647@7UF8DA?F:7366;F;A@A8
EG997EF76;@67J.:7*7D8AD?3@576H;EAD6A7E@AF
@793F;H7>K38875FF:7B7D8AD?3@57A8KAGDF>3E5>GEF7DE
#8KAG3D7:3BBKI;F:F:7D75A??7@63F;A@KAG53@F:7@
DA>>AGFF:7@7I;@67J7E3GFA?3F;53>>KI;F:AGF;@5GDD;@93@K
3BB>;53F;A@6AI@F;?7
AD3>>B7D8AD?3@5747EFBD35F;57E5AH7D;@9E5:7?3
67E;9@;@67J;@9BDAU>;@9E:3D6;@9E;L;@93@6?AD75:75=
AGFF:7 'A@9AB7D8AD?3@5747EFBD35F;57E4>A9E7D;7E
#@67J7E3@6-53>;@9)GF
1:;>7;F?3K@AF47@757EE3DKFAE:3D6B3DF;F;A@F:7
63F343E73FF:7AGFE7FA8F:7BDA<75F;F;E3>I3KE9AA6
BD35F;57FA3EEG?7F:3F8GFGD7E53>34;>;FKI;>>47@757EE3DK
796G7FA63F39DAIF:ADF:7BABG>3D;FKA8F:7
3BB>;53F;A@7U@;@9;@67J=7KE6GD;@9F:7E5:7?367E;9@
B:3E73>EA:7>BE;67@F;8K=7KEF:3F53@47GE76I:7@
;?B>7?7@F;@9'A@9AOE@3F;H7E:3D6;@98AD
3BB>;53F;A@FD3@EB3D7@FE53>7AGF
-5:7?3HA>GF;A@3@6F:7#?B35FA@
-5:7?37E;9@
'A@9AOE6K@3?;5E5:7?3BDAH;67E3?3<AD36H3@F397
H7DEGED7>3F;A@3>63F343E7E
A>>75F;A@E53@475D73F76I;F:AGFUDEF67U@;@9F:7;D
EFDG5FGD7;76A5G?7@FU7>6E3@6F:7;D63F3FKB7E
A5G?7@FE;@39;H7@5A>>75F;A@@776@AF3>>:3H7F:7
E3?7E7FA8U7>6E)@753@5:3@97F:7EFDG5FGD7A8
6A5G?7@FE<GEF4K366;@9@7IU7>6EAD67>7F;@97J;EF;@9
A@7E
A@E;67DF:77J3?B>7A835GEFA?7DD75AD6
R -A?75GEFA?7DEI;>>:3H7?G>F;B>7A8U57>A53F;A@E3@6
>;@7EA84GE;@7EE3@6EA?7I;>>@AF
R .:7@G?47DA85A@F35F?7F:A6EI;F:;@735:5GEFA?7D
53@476;887D7@F
R .:7;@8AD?3F;A@EFAD768AD735:A8F:7E75A@F35F
?7F:A6E53@H3DK AD;@EF3@57EA?7?3K:3H7BG4>;5
EA5;3>?76;38776EI:;5:5AG>647GE78G>FA?A@;FAD
3@6EA?7I;>>@AF
R 35:5GEFA?7D?3K4GKADEG4E5D;47FA6;887D7@F
E7DH;57E8DA?F:7;DH7@6AD735:I;F:F:7;DAI@E7FEA8
5A@FD35FE
'A67>;@9F:;ED73>IAD>6H3D;3@57;@F:7D;9;6
FIA6;?7@E;A@3>E5:7?3A83D7>3F;A@3>63F343E7;E
5A?B>7J3@65A@HA>GF76#@'A@9AEGBBADF;@9H3D;3@57
47FI77@6A5G?7@FE;E38G@63?7@F3>E73?>7EE873FGD7A8
-)(6A5G?7@FE
'A@9AOEV7J;4>73@66K@3?;5E5:7?3E?73@F:3F
E5:7?367H7>AB?7@F3@6A@9A;@97HA>GF;A@3D7
EFD3;9:F8ADI3D6 AD7J3?B>7F:767H7>AB7D3@6
IAD=;@9A@3@7I67H7>AB?7@FBDA<75FGE;@93D7>3F;A@3>
63F343E7?GEFUDEFEF3DF4KEB75;8K;@9F:763F343E7
E5:7?3478AD73@K5A67;EID;FF7@F3?;@;?G?F:;EI;>>
F3=763KE;FA8F7@F3=7EI77=EAD?A@F:E
'A@9A7@34>7E67H7>AB7DEFA7HA>H7F:7E5:7?3
F:DAG9:3@;F7D3F;H73@639;>73BBDA35:7H7>AB7DE53@
EF3DFID;F;@95A673@6B7DE;EFF:7A4<75FE3EF:7K3D7
5D73F76@6I:7@F:7K366?AD7873FGD7E'A@9AI;>>
5A@F;@G7FAEFAD7F:7GB63F76A4<75FEI;F:AGFF:7@7768AD
B7D8AD?;@95AEF>K ALTER TABLE AB7D3F;A@EADD767E;9@;@9
F:7E5:7?38DA?E5D3F5:
.:7E747@7UFE3>EA7JF7@6FA?3;@F3;@;@9F:73BB>;53F;A@
;@BDA6G5F;A@1:7@GE;@93D7>3F;A@3>63F343E73@
3BB>;53F;A@GB9D367?3KD7CG;D7F:7FA366AD?A6;8K
U7>6E;@F:763F343E7.:7E75:3@97ED7CG;D7B>3@@;@9
35DAEE67H7>AB?7@FE3@6AB7D3F;A@EF73?EFA
EK@5:DA@;L73BB>;53F;A@3@663F343E7GB9D367E39D77;@9
A@I:7@FAE5:76G>7F:7@757EE3DK ALTER TABLE
AB7D3F;A@EH7@FD;H;3>5:3@97EFA3@7J;EF;@9D7>3F;A@3>
63F3?A67>D7EG>F;@35A?B>7J67B7@67@5K5:3;@S8DA?
GB63F;@9),'5>3EEF34>7?3BB;@9EFABDA9D3??;@9
>3@9G3975>3EE7EF:3F:3H7FA47D75A?B;>763@65A67
5:3@976355AD6;@9>K
E'A@9A3>>AIEE5:7?3EFA7HA>H76K@3?;53>>KEG5:
AB7D3F;A@ED7CG;D7EGB9D36;@9<GEFF:73BB>;53F;A@I;F:
FKB;53>>K@A35F;A@D7CG;D768AD'A@9AHA>H;@9
3BB>;53F;A@E;EE;?B>73@6BDA<75FF73?E53@;?BDAH7
39;>;FK3@6F;?7FA?3D=7F
FF:7BA;@FF:3FF:7AD67H7>AB7D67F7D?;@7EF:3F
EA?75A@EFD3;@FEE:AG>6477@8AD576A@F:76A5G?7@F
EFDG5FGD7-5:7?303>;63F;A@DG>7E53@4736676S8GDF:7D
67F3;>E3D7BDAH;676>3F7D;@F:;E9G;67
BB>;53F;A@#@F79D3F;A@
1;F:F:7E5:7?367E;9@76F:7BDA<75F53@?AH7FAI3D6E
;@F79D3F;@9F:73BB>;53F;A@I;F:F:763F343E7GE;@9
'A@9A6D;H7DE3@6FAA>E
OE53@3>EA5A@U9GD7'A@9AFA?77FF:7
3BB>;53F;A@OED7CG;D7?7@FE8AD63F35A@E;EF7@5K3@6
6GD34;>;FK35:A8F:7E73D73E3D76;E5GEE7647>AI
'A@9AD;H7DE3@6F:7*#
3E7A8GE73@667H7>AB7DBDA6G5F;H;FK3D7FIAA8
'A@9AOE5AD767E;9@9A3>E
)@78G@63?7@F3>6;887D7@5747FI77@3-+&43E76
,'-3@6'A@9A;EF:3FF:7'A@9A;@F7D8357;E
;?B>7?7@F763E?7F:A6EAD8G@5F;A@EI;F:;@F:7*#A83
EB75;U5BDA9D3??;@9>3@9G3973EABBAE76FA3
5A?B>7F7>KE7B3D3F7F7JF43E76>3@9G397>;=7-+&.:;E
5AGB>76I;F:F:738U@;FK47FI77@'A@9AOE-)(
6A5G?7@F?A67>3@6F:763F3EFDG5FGD7EGE76;@?A67D@
BDA9D3??;@9>3@9G397E?3=7E3BB>;53F;A@;@F79D3F;A@
E;?B>7
'A@9A:3E ;6;A?3F;56D;H7DE8ADF:7?AEFBABG>3D
>3@9G397E;@5>G6;@936AL7@67H7>AB763@6EGBBADF764K
'A@9A79$3H3$3H3-5D;BF*KF:A@(.!A3@6
?AD7F:3@5A??G@;FKEGBBADF766D;H7DE
'A@9AOE;6;A?3F;56D;H7DE?;@;?;L7A@4A3D6;@9F;?78AD
@7I67H7>AB7DE3@6E;?B>;8K3BB>;53F;A@67H7>AB?7@F AD
;@EF3@57$3H367H7>AB7DE53@E;?B>K5A67393;@EF
'A@9A@3F;H7>K;@$3H3>;=7I;E78AD*KF:A@67H7>AB7DE
!A67H7>AB7DE3@6EAA@.:76D;H7DE3D75D73F764K
67H7>AB?7@FF73?EF:3F3D77JB7DFE;@F:7;D9;H7@>3@9G397
3@6=@AI:AIBDA9D3??7DEBD787DFAIAD=I;F:;@F:AE7
>3@9G397E
'3BB;@9-+&FA'A@9A-K@F3J
AD67H7>AB7DE83?;>;3DI;F:-+&;F;EGE78G>FAG@67DEF3@6
:AI5AD7-+&EF3F7?7@FEEG5:3E CREATE ALTER
INSERT SELECT UPDATE3@6 DELETE ?3BFAF:7
'A@9A*#.:76A5G?7@F3F;A@;@5>G67E3 5A?B3D;EA@
5:3DF I;F:7J3?B>7EFA3EE;EF;@F:7FD3@E;F;A@FA'A@9A
+G7DK&3@9G397EFDG5FGD73@6E7?3@F;5E#@366;F;A@
'A@9AA887DE3@7JF7@E;H73DD3KA8 36H3@576CG7DK
AB7D3FADE
'A@9A99D793F;A@*;B7>;@7
99D793F;@963F3I;F:;@3@K63F343E7;E3@;?BADF3@F
53B34;>;FK3@63EFD7@9F:A8F:7,'-'3@K(A-+&
63F343E7E6A@AF:3H7399D793F;A@53B34;>;F;7EE3D7EG>F
?;9D3F;@9FA(A-+&63F343E7E:3EFD36;F;A@3>>K8AD576
67H7>AB7DEFA67H7>ABIAD=3DAG@6EEG5:3E
 G;>6;@9399D793F;A@EI;F:;@F:7;D3BB>;53F;A@5A67
;@5D73E;@95A?B>7J;FK3@65A?BDA?;E;@9B7D8AD?3@57
 JBADF;@963F3FA"36AABAD363F3I3D7:AGE7FADG@
5A?B>7JCG7D;7E393;@EFF:763F3.:;E3>EA6D3EF;53>>K
;@5D73E7E5A?B>7J;FK6GB>;53F7E63F335DAEE?G>F;B>7
63F3EFAD7E3@66A7E@AF3>>AI8ADD73>F;?73@3>KF;5E
 #83H3;>34>7ID;F;@9@3F;H7'3B,76G57AB7D3F;A@EI;F:;@
F:7(A-+&63F343E7;FE7>8
'A@9ABDAH;67EF:7 99D793F;A@*;B7>;@7 @3F;H7>K
I;F:;@F:763F343E7I:;5:67>;H7DEE;?;>3D8G@5F;A@3>;FKFA
F:7 GROUP BY JOIN'3F7D;3>;L760;7I3@6D7>3F76-+&
873FGD7E
1:7@GE;@9F:7399D793F;A@B;B7>;@76A5G?7@FE;@3
5A>>75F;A@B3EEF:DAG9:3BDA57EE;@9I:7D7F:7K3D7
BDA57EE76;@EF397EJBD7EE;A@EBDA6G57AGFBGF
6A5G?7@FE43E76A@53>5G>3F;A@EB7D8AD?76A@F:7;@BGF
6A5G?7@FE.:7355G?G>3FAD7JBD7EE;A@EGE76;@F:7
$group EF397?3;@F3;@EF3F779FAF3>E?3J;?G?E
?;@;?G?E3H7D397EEF3@63D667H;3F;A@E3@6D7>3F7663F3
3E6A5G?7@FEBDA9D7EEF:DAG9:F:7B;B7>;@7
66;F;A@3>>KF:7399D793F;A@B;B7>;@753@?3@;BG>3F73@6
5A?4;@76A5G?7@FEGE;@9BDA<75F;A@EU>F7DED7635F;A@
>AA=GBE$)#(E3@6D75GDE;H79D3B:>AA=GBE#F;E3>EA
BAEE;4>7FAFD3@E8AD?63F3I;F:;@F:763F343E7S8AD
7J3?B>7GE;@9F:7 5A@H7DFAB7D3FAD FA5>73@E763F3FKB7E
;@FAEF3@63D6;L768AD?3FE
.:7 -+&FA99D793F;A@'3BB;@9:3DF E:AIE3@G?47D
A87J3?B>7E67?A@EFD3F;@9:AICG7D;7E;@-+&3D7
:3@6>76;@'A@9AOE399D793F;A@B;B7>;@7
GE;@7EE#@F7>>;97@57#@F79D3F;A@S
'A@9AA@@75FAD8AD#
D;H7@4K9DAI;@9D7CG;D7?7@FE8ADE7>8E7DH;573@3>KF;5E
83EF7D6;E5AH7DK3@6BD76;5F;A@43E76A@D73>F;?7
AB7D3F;A@3>63F33@6F:7@776FA;@F79D3F7?G>F;EFDG5FGD76
3@6EFD73?;@963F3E7FE#3@63@3>KF;5EB>3F8AD?E3D7A@7
A8F:783EF7EF9DAI;@9EA8FI3D7?3D=7FE
.A366D7EEF:7E7D7CG;D7?7@FE?A67D@3BB>;53F;A@63F3
EFAD76;@'A@9A53@4773E;>K7JB>AD76I;F:
;@6GEFDKEF3@63D6-+&43E76#3@63@3>KF;5EB>3F8AD?E
/E;@9F:7 #A@@75FAD3@3>KEFE63F3E5;7@F;EFE3@6
FigurFigure 8:e 8: D73F;@9D;5:9D3B:E3@663E:4A3D6E6;D75F>K8DA?F:7:3DFE/#
4GE;@7EEGE7DE53@E73?>7EE>KH;EG3>;L7E7?;EFDG5FGD76
3@6G@EFDG5FGD7663F3?3@3976;@'A@9A3>A@9E;67
FD36;F;A@3>63F3;@F:7;D-+&63F343E7EGE;@9F:7E3?7#
FAA>E67B>AK76I;F:;@?;>>;A@EA87@F7DBD;E7E
-+&43E76#FAA>EEG5:3E.34>73G7JB75FFA5A@@75FFA3
63F3EAGD57I;F:3UJ76E5:7?3BD7E7@F;@9F34G>3D63F3
.:;EBD7E7@FE35:3>>7@97I:7@IAD=;@9I;F:'A@9AOE
6K@3?;5E5:7?33@6D;5:?G>F;6;?7@E;A@3>6A5G?7@FE#@
AD67D8AD#FAA>EFACG7DK'A@9A3E363F3EAGD57F:7
#A@@75FAD6A7EF:78A>>AI;@9
R *DAH;67EF:7#FAA>I;F:F:7E5:7?3A8F:7'A@9A
5A>>75F;A@EFA47H;EG3>;L76/E7DE53@D7H;7IF:7
E5:7?3AGFBGFFA7@EGD763F3FKB7EEG46A5G?7@FE
3@63DD3KE3D75ADD75F>KD7BD7E7@F76
R .D3@E>3F7E-+&EF3F7?7@FE;EEG764KF:7#FAA>;@FA
7CG;H3>7@F'A@9ACG7D;7EF:3F3D7F:7@E7@FFA
'A@9A8ADBDA57EE;@9
R A@H7DFEF:7D7FGD@76D7EG>FE;@FAF:7F34G>3D8AD?3F
7JB75F764KF:7#FAA>I:;5:53@F:7@H;EG3>;L7F:7
63F343E76A@GE7DD7CG;D7?7@FE
'A@9A:3DFE
'A@9A:3DFE;EF:7CG;5=7EF3@673E;7EFI3K5D73F7
3@6E:3D7H;EG3>;E3F;A@EA8KAGD'A@9A63F3;@D73>F;?7
I;F:AGF@776;@9FA?AH7KAGD63F3;@FAAF:7DEKEF7?EAD
>7H7D397F:;D6B3DFKFAA>E753GE7:3DFE@3F;H7>K
G@67DEF3@6EF:7'A@9A6A5G?7@F?A67>KAG53@
5D73F75:3DFE8DA?63F3F:3FH3D;7E;@E:3B7AD5A@F3;@E
@7EF766A5G?7@FE3@63DD3KEI;F:AGF@776;@9FAUDEF?3B
F:763F3;@FA3V3FF34G>3DEFDG5FGD7
/E;@9:3DFEKAG53@B>357?G>F;B>7H;EG3>;E3F;A@EA@FA3
E;@9>763E:4A3D63@6F:7@E:3D7;FI;F:=7KEF3=7:A>67DE
FAEGBBADF5A>>34AD3F;H73@3>KE;E3@6675;E;A@?3=;@9AD
KAG53@7?476F:7?6;D75F>K;@KAGD3BB>;53F;A@E1:7@
KAG5A@@75FFA3>;H763F3EAGD57'A@9A:3DFEI;>>
=77BKAGDH;EG3>;L3F;A@E3@663E:4A3D6EGBFA63F7I;F:
F:7?AEFD757@F63F3:3DFEI;>>3GFA?3F;53>>K97@7D3F73@
399D793F;A@B;B7>;@78DA?KAGD5:3DF67E;9@I:;5:;EF:7@
7J75GF76A@KAGD'A@9AE7DH7D1;F:'A@9AOE
IAD=>A36;EA>3F;A@53B34;>;F;7ES7@34>;@9KAGFAE7B3D3F7
KAGDAB7D3F;A@3>8DA?3@3>KF;53>IAD=>A36E;@F:7E3?7
5>GEF7DSKAG53@GE7:3DFE8AD3D73>F;?7H;7I withoutwithout
having any impact on prhaving any impact on production workloadsoduction workloads
2AG53@97FEF3DF764KFDK;@9AGF 'A@9A:3DFE
'G>F;,75AD6#.D3@E35F;A@3>'A67>
753GE76A5G?7@FE53@4D;@9FA97F:7DD7>3F7663F3F:3F
IAG>6AF:7DI;E747?A67>>7635DAEEE7B3D3F7B3D7@F5:;>6
F34>7E;@3F34G>3DE5:7?3'A@9AOE3FA?;5
E;@9>76A5G?7@FAB7D3F;A@EBDAH;67FD3@E35F;A@E7?3@F;5E
F:3F?77FF:763F3;@F79D;FK@776EA8F:7?3<AD;FKA8
3BB>;53F;A@E)@7AD?AD7U7>6E?3K47ID;FF7@;@3E;@9>7
AB7D3F;A@;@5>G6;@9GB63F7EFA?G>F;B>7EG46A5G?7@FE
3@67>7?7@FEA83@3DD3K.:79G3D3@F77EBDAH;6764K
'A@9A7@EGD75A?B>7F7;EA>3F;A@3E36A5G?7@F;E
GB63F763@K7DDADE53GE7F:7AB7D3F;A@FADA>>435=EAF:3F
5>;7@FED757;H735A@E;EF7@FH;7IA8F:76A5G?7@F
'A@9A36676EGBBADF8AD?G>F;6A5G?7@F#
FD3@E35F;A@E;@F:7D7>73E73@67JF7@676F:7?;@
I;F:;EFD;4GF76.D3@E35F;A@EF:3FAB7D3F735DAEE
E53>76AGFE:3D6765>GEF7DE'G>F;6A5G?7@FFD3@E35F;A@E
?3=7;F7H7@73E;7D8AD67H7>AB7DEFA366D7EE35A?B>7F7
D3@97A8GE753E7EI;F:'A@9A.:7K877><GEF>;=7F:7
FD3@E35F;A@E67H7>AB7DE3D783?;>;3DI;F:8DA?D7>3F;A@3>
63F343E7ES?G>F;EF3F7?7@FE;?;>3DEK@F3J3@673EKFA
366FA3@K3BB>;53F;A@.:DAG9:E@3BE:AF;EA>3F;A@
FD3@E35F;A@EBDAH;6735A@E;EF7@FH;7IA863F37@8AD57
3>>AD@AF:;@97J75GF;A@3@66A@AF;?B35FB7D8AD?3@57
8ADIAD=>A36EF:3F6A@AFD7CG;D7F:7? ADF:AE7
AB7D3F;A@EF:3F6AD7CG;D7?G>F;6A5G?7@FFD3@E35F;A@E
F:7D73D7E7H7D3>47EFBD35F;57EF:3F67H7>AB7DEE:AG>6
A4E7DH7
2AG53@D7H;7I3>>47EFBD35F;57E;@F:7 'A@9A
6A5G?7@F3F;A@8AD?G>F;6A5G?7@FFD3@E35F;A@E
'3;@F3;@;@9-FDA@9A@E;EF7@5K
E36;EFD;4GF76EKEF7?'A@9A:3@6>7EF:75A?B>7J;FK
A8?3;@F3;@;@9?G>F;B>75AB;7EA863F3H;3 D7B>;53F;A@,736
3@6ID;F7AB7D3F;A@E3D76;D75F76FAF:7BD;?3DKD7B>;534K
6783G>F8ADEFDA@95A@E;EF7@5K4GFGE7DE53@5:AAE7FA
D7368DA?E75A@63DKD7B>;53E8ADD76G576@7FIAD=>3F7@5K
7EB75;3>>KI:7@GE7DE3D797A9D3B:;53>>K6;EB7DE76AD8AD
;EA>3F;@9AB7D3F;A@3>3@63@3>KF;53>IAD=>A36EDG@@;@9;@3
E;@9>75>GEF7D
1:7@D736;@963F38DA?3@K5>GEF7D?7?47DGE7DE53@
FG@7'A@9AOE5A@E;EF7@5K?A67>FA?3F5:3BB>;53F;A@
D7CG;D7?7@FE6AI@FAF:7>7H7>A8;@6;H;6G3>CG7D;7EI;F:;@
3@3BB1:7@3E;FG3F;A@?3@63F7EF:7EFD;5F7EF>;@73D;L34>7
AD53GE3>5A@E;EF7@5K'A@9AI;>>7@8AD57;F;83@
3BB>;53F;A@@776EFAA@>KD73663F3F:3F:3E477@
5A??;FF76FA3?3<AD;FKA8@A67E3@6F:7D78AD753@OF47
DA>>76435=;@F:77H7@FA83BD;?3DK7>75F;A@AD7H7@<GEF
FA3E;@9>7D7B>;53'A@9A53@475A@U9GD768ADF:;EK
BDAH;6;@9F:;E>7H7>A8FG@34;>;FK'A@9A53@E3F;E8KF:7
8G>>D3@97A85A@E;EF7@5KB7D8AD?3@573@697A>A53>;FK
D7CG;D7?7@FEA8?A67D@3BBE
1D;F7GD34;>;FK
'A@9AGE7EID;F75A@57D@EFA5A@FDA>F:7>7H7>A8ID;F7
9G3D3@F77E8AD63F36GD34;>;FKA@U9GD34>7ABF;A@E7JF7@6
8DA?E;?B>7NUD73@68AD97FOAB7D3F;A@EFAI3;F;@98AD
35=@AI>769?7@FE8DA??G>F;B>79>A43>>K6;EFD;4GF76
D7B>;53E
#8ABF;@98ADF:7?AEFD7>3J76ID;F75A@57D@F:73BB>;53F;A@
53@E7@63ID;F7AB7D3F;A@FA'A@9AF:7@5A@F;@G7
BDA57EE;@9366;F;A@3>D7CG7EFEI;F:AGFI3;F;@98AD3
D7EBA@E78DA?F:763F343E79;H;@9F:7?3J;?G?
B7D8AD?3@57.:;EABF;A@;EGE78G>8AD3BB>;53F;A@E>;=7
>A99;@9I:7D7GE7DE3D7FKB;53>>K3@3>KL;@9FD7@6E;@F:7
63F3D3F:7DF:3@6;E5D7F77H7@FE
1;F:F:76783G>FEFDA@97DID;F75A@57D@EID;F7AB7D3F;A@E
I3;FG@F;>'A@9A3BB>;7E3@635=@AI>7697EF:7
AB7D3F;A@.:747:3H;AD53@478GDF:7DF;9:F7@764K3>EA
ABF;@9FAI3;F8ADD7B>;53F;A@A8F:7ID;F7FA
R E;@9>7E75A@63DK
R ?3<AD;FKA8E75A@63D;7E
R EB75;U76@G?47DA8E75A@63D;7E
R >>A8F:7E75A@63D;7ES7H7@;8F:7K3D767B>AK76;@
6;887D7@F63F357@F7DEGE7DEE:AG>67H3>G3F7F:7
;?B35FEA8@7FIAD=>3F7@5K53D78G>>K;@F:;EE57@3D;A
FigurFigure 9:e 9: A@U9GD7GD34;>;FKB7D)B7D3F;A@
.:7ID;F75A@57D@53@3>EA47GE76FA9G3D3@F77F:3FF:7
5:3@97:3E477@B7DE;EF76FA6;E=478AD7;F;E
35=@AI>76976
.:7ID;F75A@57D@;E5A@U9GD76F:DAG9:F:76D;H7D3@6;E
:;9:>K9D3@G>3DS;F53@47E7FB7DAB7D3F;A@B7D5A>>75F;A@
AD8ADF:77@F;D763F343E7/E7DE53@>73D@?AD734AGF
ID;F75A@57D@E;@F:7 6A5G?7@F3F;A@
'A@9AGE7EID;F73:736>A99;@9FA3@A@6;E=<AGD@3>
FA9G3D3@F77ID;F7AB7D3F;A@6GD34;>;FK3@6FABDAH;675D3E:
D7E;>;7@5778AD73BB>K;@935:3@97FAF:763F343E7S
I:7F:7D;F;E3ID;F7AB7D3F;A@AD3@;@67J?A6;U53F;A@S
'A@9AID;F7EF:75:3@97AB7D3F;A@FAF:7<AGD@3>#83
E7DH7D83;>GD7A55GDEAD'A@9A7@5AG@F7DE3@7DDAD
478AD7;F53@ID;F7F:75:3@97E8DA?F:7<AGD@3>FAF:7
63F343E7F:7<AGD@3>76AB7D3F;A@53@47D73BB>;76F:7D74K
?3;@F3;@;@935A@E;EF7@FEF3F7I:7@F:7E7DH7D;E
D75AH7D76
#?B>7?7@F;@903>;63F;A@A@EFD3;@FE
AD7;9@%7KE
AD7;9@=7KE3D7@757EE3DKFA?3;@F3;@D787D7@F;3>;@F79D;FK
;@F34G>3DE5:7?3?A67>EF:3FEB>;FGB63F33@6;FE
D7>3F;A@E:;BE35DAEE6;887D7@FF34>7E
1;F:F:76A5G?7@F?A67>D787D7@F;3>;@F79D;FK;E;@4G;>FFA
F:7D;5::;7D3D5:;53>EFDG5FGD7A8F:763F3?A67>1:7@
?A67>;@93B3D7@F5:;>6AD?3@KD7>3F;A@E:;BI;F:
EG46A5G?7@FEAD3DD3KEF:7D7;E@AI3KKAG53@:3H73@
ADB:3@D75AD6SD7>3F7663F3;E7?476676;@E;673
6A5G?7@FEAKAG=@AIF:7B3D7@F7J;EFE
@AF:7DGE7A88AD7;9@=7KE;EFAH7D;8KF:3FF:7H3>G7A83
EB75;U5U7>65A@8AD?EFA3D3@97A8B7D?;EE;4>7H3>G7ES
795AG@FDK@3?7EADGE7DEF3FGE2AG53@6AF:;EI;F:
'A@9AOEE5:7?3H3>;63F;A@3E63F3;EID;FF7@FAF:7
63F343E73HA;6;@9F:7@776FAD7H7D;8KF:763F3I:7@7H7D
KAGD7FD;7H7;F
-5:7?3!AH7D@3@57
1:;>7'A@9AOEV7J;4>7E5:7?3;E3BAI7D8G>873FGD78AD
?3@KGE7DEF:7D73D7E;FG3F;A@EI:7D7EFD;5F9G3D3@F77EA@
63F3EFDG5FGD73@65A@F7@F3D7D7CG;D76/E;@9 -5:7?3
03>;63F;A@67H7>AB7DE3@6E53@67U@73BD7E5D;476
6A5G?7@FEFDG5FGD78AD735:5A>>75F;A@I:;5:53@D7<75F
3@K6A5G?7@FEF:3F6A@AF5A@8AD?FA;F1;F:E5:7?3
H3>;63F;A@'A@9A7@8AD57EEFD;5F5A@FDA>EAH7D$-)(
63F3
R Complete scComplete schema governancehema governance6?;@;EFD3FADE53@
67U@7I:7@366;F;A@3>U7>6E3D73>>AI76FA4736676FA
36A5G?7@F3@6EB75;8K3E5:7?3A@3DD3K7>7?7@FE
;@5>G6;@9@7EF763DD3KE
R TTunable contrunable controlsols6?;@;EFD3FADE:3H7F:7V7J;4;>;FKFA
FG@7E5:7?3H3>;63F;A@355AD6;@9FAGE753E7S8AD
7J3?B>7;836A5G?7@F83;>EFA5A?B>KI;F:F:767U@76
EFDG5FGD7;F53@477;F:7D47D7<75F76ADEF;>>ID;FF7@FA
F:75A>>75F;A@I:;>7>A99;@93I3D@;@9?7EE397
-FDG5FGD753@47;?BAE76A@<GEF3EG4E7FA8U7>6ES
8AD7J3?B>7D7CG;D;@93H3>;65GEFA?7D3@3?73@6
366D7EEI:;>7AF:7DEU7>6E53@478D778AD?EG5:3E
EA5;3>?76;3:3@6>73@657>>B:A@7@G?47D@6A8
5AGDE7H3>;63F;A@53@47FGD@76A887@F;D7>K3>>AI;@9
5A?B>7F7E5:7?3V7J;4;>;FKI:;5:;E7EB75;3>>KGE78G>
6GD;@9F:767H7>AB?7@FB:3E7A8F:73BB>;53F;A@
R QueryableQueryable.:7E5:7?367U@;F;A@53@47GE764K3@K
CG7DKFA;@EB75F6A5G?7@FEFDG5FGD73@65A@F7@F AD
7J3?B>7E53@;67@F;8K3>>6A5G?7@FEF:3F6A@AF
5A@8AD?FA3BD7E5D;476E5:7?3
E3@7J3?B>7KAG53@3663$-)(-5:7?3FA7@8AD57
F:7E7DG>7E
R 35:6A5G?7@F?GEF5A@F3;@3U7>6@3?76 lineItems
R .:76A5G?7@F?3KABF;A@3>>K5A@F3;@AF:7DU7>6E
R lineItems ?GEF473@3DD3KI:7D7735:7>7?7@F
◦ 'GEF5A@F3;@3 title EFD;@9 price @G?47D@AE?3>>7D
F:3@
◦ '3KABF;A@3>>K5A@F3;@34AA>73@@3?76 purchased
◦ 'GEF5A@F3;@@A8GDF:7DU7>6E
db.createCollection( "orders",
{validator: {$jsonSchema:
{
properties: {
lineItems:
{type: "array",
items:{
properties: {
title: {type: "string"},
price: {type: "number",
minimum: 0.0},
purchased: {type: "boolean"}
},
required: ["_id", "title", "price"],
additionalProperties: false
}
}
},
required: ["lineItems"]
}}
})
@8AD5;@9A@EFD3;@FE1;F:#@67J7E
E6;E5GEE76;@F:7-5:7?37E;9@E75F;A@'A@9A
EGBBADFEG@;CG7;@67J7E@3F;H7>KI:;5:67F75F3@6D3;E73@
7DDADFA3@K;@E7DFAB7D3F;A@F:3F3FF7?BFEFA>A363
6GB>;53F7H3>G7;@FA35A>>75F;A@ FGFAD;3>;E3H3;>34>7 F:3F
67E5D;47E:AIFA5D73F7G@;CG7;@67J7E3@67>;?;@3F7
6GB>;53F77@FD;7E8DA?7J;EF;@95A>>75F;A@E
)@7?3@6'3F7D;3>;L760;7IE
'3F7D;3>;L76H;7IE3D735A??A@873FGD7;@D7>3F;A@3>
63F343E7E9;H;@9KAGF:734;>;FKFABD75A?BGF73@6EFAD7
F:7D7EG>FEA85A??A@3@3>KF;5ECG7D;7E.KB;53>GE753E7E
8ADF:7?;@'A@9A;@5>G67,A>>;@9GB3EG??3DKA8
E3>7E63F37H7DK:AGDE99D793F;@93H7D397EA8
E7@EAD7H7@FE7H7DK:AGD;@3@#A.3BB'7D9;@9@7I
43F5:7EA85>73@E76?3D=7FFD36;@963F3I;F:357@FD3>;L76
'A@9A43E7663F3I3D7:AGE7EAFD367DE97FD78D7E:76
?3D=7FH;7IE35DAEEF:7;DBADF8A>;AE
/E;@9F:7?7D97EF397AGFBGFE8DA?399D793F;A@B;B7>;@7
CG7D;7E53@@AI47?7D976I;F:7J;EF;@9EFAD76D7EG>FE7FE
I:7@7H7DKAGDG@F:7B;B7>;@77@34>;@9KAGFA5D73F7
?3F7D;3>;L76H;7IE F:3F3D7D78D7E:76A@67?3@6,3F:7D
F:3@38G>>EFABD7B>357?7@FA8F:77J;EF;@95A>>75F;A@OE
5A@F7@FKAG53@;@5D7?7@F3@67@D;5:H;7IEA8KAGDD7EG>F
E7FE3E@7I63F3;EBDA57EE764KF:7399D793F;A@B;B7>;@7
1;F:'A@9AOE'3F7D;3>;L760;7IEKAG:3H7F:7V7J;4;>;FK
FAAGFBGFD7EG>FEFAE:3D6765A>>75F;A@ES7@34>;@9KAGFA
E53>7AGFKAGDH;7IE3E63F3HA>G?7E9DAI2AG53@3>EA
ID;F7F:7AGFBGFFA5A>>75F;A@E;@6;887D7@F63F343E7E
8GDF:7D;EA>3F;@9AB7D3F;A@3>3@63@3>KF;53>IAD=>A36E8DA?
A@73@AF:7DEF:7?3F7D;3>;L76H;7IE3D7EFAD76;@3
D79G>3D'A@9A5A>>75F;A@KAG53@3BB>K;@67J7EFA735:
H;7I7@34>;@9KAGFAABF;?;L7CG7DK3557EEB3FF7D@E3@6
DG@677B7D3@3>KE;E393;@EFF:7?GE;@9'A@9A:3DFE
ADF:7#3@6B35:7-B3D=5A@@75FADE
)@7?3@6'3F7D;3>;L760;7IED7BD7E7@F3BAI7D8G>
366;F;A@FAF:73@3>KF;5E53B34;>;F;7EA887D764KF:7
'A@9A63F343E7S7@34>;@9KAGDGE7DEFA97F83EF7D
;@E;9:FE8DA?>;H7AB7D3F;A@3>63F3I;F:AGFF:77JB7@E7
3@65A?B>7J;FKA8?AH;@963F3F:DAG9:8D39;>7.&
BDA57EE7E;@FA676;53F7663F3I3D7:AGE7E
';9D3F;@93F3FA'A@9A
*DA<75FF73?E:3H7?G>F;B>7ABF;A@E8AD;?BADF;@963F38DA?
7J;EF;@9D7>3F;A@3>63F343E7EFA'A@9A.:7FAA>A8
5:A;57E:AG>667B7@6A@F:7EF397A8F:7BDA<75F3@6F:7
7J;EF;@97@H;DA@?7@F
FigurFigure 1e 10:0: 'G>F;B>7)BF;A@E8AD3F3';9D3F;A@
'3@KGE7DE5D73F7F:7;DAI@E5D;BFEI:;5:FD3@E8AD?
EAGD5763F3;@FA3:;7D3D5:;53>$-)(EFDG5FGD7F:3F53@47
;?BADF76;@FA'A@9AGE;@9F:7 mongoimport FAA>
JFD35F.D3@E8AD?&A36.&FAA>E3D73>EA5A??A@>K
GE76I:7@?;9D3F;@963F38DA?D7>3F;A@3>63F343E7EFA
'A@9A@G?47DA8.&H7@6ADE;@5>G6;@9#@8AD?3F;53
*7@F3:A3@6.3>7@6:3H767H7>AB76'A@9A5A@@75FADE
F:3F7@34>73IAD=VAI;@I:;5:63F3;E7JFD35F768DA?F:7
EAGD5763F343E7FD3@E8AD?76;@FAF:7F3D97F'A@9A
E5:7?3EF39763@6F:7@>A3676;@FA5A>>75F;A@E
'3@K?;9D3F;A@E;@HA>H7DG@@;@9F:77J;EF;@9,'-;@
B3D3>>7>I;F:F:7@7I'A@9A63F343E7;@5D7?7@F3>>K
FD3@E87DD;@9BDA6G5F;A@63F3
R ED75AD6E3D7D7FD;7H768DA?F:7,'-F:7
3BB>;53F;A@ID;F7EF:7?435=AGFFA'A@9A;@F:7
D7CG;D766A5G?7@FE5:7?3
R A@E;EF7@5K5:75=7DE8AD7J3?B>7GE;@9'
5:75=EG?E53@47GE76FAH3>;63F7F:7?;9D3F7663F3
R >>@7I>K5D73F76ADGB63F7663F3;EID;FF7@FA
'A@9AA@>K
-:GFF7DVKGE76F:;E;@5D7?7@F3>3BBDA35:FA?;9D3F7F:7
?7F363F3A84;>>;A@;?397E3@6.A863F38DA?)D35>7
FA'A@9A
#@5D7?7@F3>?;9D3F;A@53@47GE76I:7@@7I3BB>;53F;A@
873FGD7E3D7;?B>7?7@F76I;F:'A@9AADI:7D7
?G>F;B>73BB>;53F;A@E3D7DG@@;@9393;@EFF:7>7935K
,'-';9D3F;@9A@>KF:AE73BB>;53F;A@EF:3F3D747;@9
?A67D@;L767@34>7EF73?EFA6;H;67BDA<75FE;@FA?AD7
?3@39734>73@639;>767H7>AB?7@FEBD;@FE
#@5D7?7@F3>?;9D3F;A@7>;?;@3F7E6;EDGBF;A@FAE7DH;57
3H3;>34;>;FKI:;>73>EABDAH;6;@983;>435=E:AG>6;F47
@757EE3DKFAD7H7DF435=FAF:7>7935K63F343E7
'3@KAD93@;L3F;A@E5D73F78776E8DA?F:7;DEAGD57
EKEF7?E6G?B;@963;>KGB63F7E8DA?3@7J;EF;@9,'-
FA'A@9AFADG@B3D3>>7>AB7D3F;A@EADFAB7D8AD?
3BB>;53F;A@67H7>AB?7@F3@6>A36F7EF;@91:7@GE;@9F:;E
3BBDA35:;F;E;?BADF3@FFA5A@E;67D:AIFA:3@6>767>7F7E
FA63F3;@F:7EAGD57EKEF7?)@7EA>GF;A@;EFA5D73F7PQ
3@6PQF3D97F63F343E7E;@'A@9A3@6F:7@3>F7D@3F7
63;>K8776E47FI77@F:7?#@F:;EE57@3D;A3F343E7
D757;H7EA@763;>K8776F:7@F:73BB>;53F;A@EI;F5:7EF:7
@7JF63KA88776EFA3F343E7'73@I:;>7F:77J;EF;@9
3F343E7;E6DABB76EAI:7@F:7@7JF8776E3D7?367
FA3F343E73I:A>7@7I;@EF3@57A8F:7EAGD57
63F343E7;E5D73F767@EGD;@9EK@5:DA@;L3F;A@A867>7F;A@E
FAF:7EAGD5763F3
)B7D3F;A@3>9;>;FK3F-53>7
'A@9AF>3E
.:75A@E;67D3F;A@E6;E5GEE76F:GE83D83>>;@FAF:76A?3;@
A8F:763F33D5:;F75FE67H7>AB7DE3@6E"AI7H7D@A
?3FF7D:AI7>793@FF:763F3?A67>AD:AI78U5;7@FF:7
;@67J7E@A@7A8F:;E?3FF7DE;8F:763F343E783;>EFA
B7D8AD?D7>;34>K3FE53>7AD53@@AF47?3@397678U5;7@F>K
@;@5D73E;@9@G?47DA85A?B3@;7E3D7?AH;@9FAF:7
BG4>;55>AG6FA@AFA@>KD76G57F:7AB7D3F;A@3>AH7D:736A8
?3@39;@9;@8D3EFDG5FGD74GF3>EABDAH;67F:7;DF73?EI;F:
3557EEFAA@67?3@6E7DH;57EF:3F9;H7F:7?F:739;>;FK
F:7K@776FA?77F83EF7D3BB>;53F;A@67H7>AB?7@F5K5>7E
.:;E?AH78DA?4G;>6;@9#.FA5A@EG?;@9#.3E3E7DH;57;E
I7>>3>;9@76I;F:B3D3>>7>AD93@;L3F;A@3>E:;8FE;@5>G6;@9
39;>73@67H)BE?7F:A6A>A9;7E3@6?;5DAE7DH;57E
3D5:;F75FGD7EA>>75F;H7>KF:7E7E7;E?;5E:;8FE;@#.:7>B
5A?B3@;7EBD;AD;F;L767H7>AB7D39;>;FKBDA6G5F;H;FK3@6F;?7
FA?3D=7F
'A@9AA887DEF:78G>>K?3@3976A@67?3@63@69>A43>
'A@9AF>3E E7DH;57;@F:7BG4>;55>AG6F>3E7@34>7E
KAGFAF3=736H3@F397A8'A@9AOE53B34;>;F;7EA@1-
LGD7AD!*I;F:AGF@776;@9FA67B>AKAB7D3F73@6
E53>7F:7EA8FI3D7ADG@67D>K;@9;@8D3EFDG5FGD7KAGDE7>8
'A@9AF>3E;E3H3;>34>7F:DAG9:3B3K3EKAG9A
?A67>3@64;>>76A@3@:AGD>K43E;E#FOE73EKFA97FEF3DF76
SGE73E;?B>7!/#ADBDA9D3??3F;5*#53>>EFAE7>75FF:7
BG4>;55>AG6BDAH;67DD79;A@;@EF3@57E;L73@6873FGD7E
KAG@776S3>>5A@U9GD76I;F:AB7D3F;A@3>47EFBD35F;57E
F:3F>73H7KAG8D77FA5A@57@FD3F7A@KAGD3BBD3F:7DF:3@
435=7@663F343E7AB7D3F;A@E'A@9AF>3EBDAH;67E
R GFA?3F7663F343E73@6;@8D3EFDG5FGD7BDAH;E;A@;@9
3>A@9I;F:3GFAE53>;@9EAF73?E53@97FF:763F343E7
D7EAGD57EF:7K@776I:7@F:7K@776F:7?3@653@
E53>77>3EF;53>>K;@D7EBA@E7FA3BB>;53F;A@67?3@6E
R -75GD;FK873FGD7EFABDAF75FKAGD63F3I;F:@7FIAD=
;EA>3F;A@U@79D3;@763557EE5A@FDA>3G6;F;@93@6
7@6FA7@67@5DKBF;A@A863F3;@?AF;A@;@GE73@6
3FD7EF
R 7DF;U53F;A@E393;@EF9>A43>EF3@63D6EFA:7>BKAG
35:;7H7KAGD5A?B>;3@57D7CG;D7?7@FE;@5>G6;@9#-)
-)3@6?AD7F>3E53@47GE768AD
IAD=>A36EEG4<75FFAD79G>3FADKEF3@63D6EEG5:3E
"#**#--3@6!*,
R 'G>F;D79;A@,7B>;53F;A@3@6!>A43>>GEF7DEFA5D73F7
97A9D3B:;53>>K6;EFD;4GF7667B>AK?7@FEA887D;@9
D7E;>;7@57E53>73@663F3D7E;67@5K5A?B>;3@57
R G>>K?3@3976435=GBEI;F:BA;@F;@F;?7D75AH7DKFA
BDAF75F393;@EF63F35ADDGBF;A@3@6F:734;>;FKFACG7DK
435=GBE;@B>357I;F:AGF8G>>D7EFAD7E
R ;@79D3;@76?A@;FAD;@93@65GEFA?;L34>73>7DFE8AD
5A?BD7:7@E;H7B7D8AD?3@57H;E;4;>;FKFAKAGD67H7>AB7DE
3@636?;@;EFD3FADE
R GFA?3F76B3F5:;@93@6E;@9>75>;5=GB9D367E8AD@7I
?3<ADH7DE;A@EA8F:763F343E77@34>;@9KAGFAF3=7
36H3@F397A8F:7>3F7EF'A@9A873FGD7E
R 557EEFAF:7 'A@9A,73>? 3BB>;53F;A@B>3F8AD?
I;F:+G7DK@KI:7D7 G@5F;A@E3@6-F3F;5"AEF;@9
67>;H7D76;@35A?B>7F7>KE7DH7D>7EE?A67>
R .:7 G>>.7JF-73D5:E7DH;57BDAH;6;@9D;5:E73D5:
53B34;>;F;7E393;@EFKAGD8G>>K?3@397663F343E7EI;F:
@A366;F;A@3>;@8D3EFDG5FGD7FABDAH;E;A@?3@397AD
E53>7
R &;H7?;9D3F;A@FA?AH7KAGDE7>8?3@3976'A@9A
5>GEF7DE;@FAF:7F>3EE7DH;57ADFA?AH7F>3E5>GEF7DE
47FI77@5>AG6BDAH;67DE
'A@9AF>3E;EE7DH;@93H3EFD3@97A8IAD=>A36E8AD
EF3DFGBE ADFG@75A?B3@;7E3@69AH7D@?7@F
397@5;7E;@5>G6;@9?;EE;A@5D;F;53>3BB>;53F;A@E:3@6>;@9
:;9:>KE7@E;F;H763F3;@D79G>3F76;@6GEFD;7E.:767H7>AB7D
7JB7D;7@5735DAEE'A@9AF>3E3@6E7>8?3@3976
'A@9A;E5A@E;EF7@F7@EGD;@9F:3FKAG73E;>K?AH7
8DA?A@BD7?;E7EFAF:7BG4>;55>AG63@647FI77@
BDAH;67DE3EKAGD@776E7HA>H7
#8KAGBD787DFADG@'A@9AA@;@8D3EFDG5FGD7KAG
?3@397F:7@5:75=AGFAGD *DA6G5F;A@(AF7E 3>A@9I;F:
F:7 )B7D3F;A@E:75=>;EF
@34>;@9KAGD.73?E'A@9A
/@;H7DE;FK
.D3;@;@95AGDE7E3D73H3;>34>78AD4AF:67H7>AB7DE3@6
E
R FFrree, web-based classes,ee, web-based classes, 67>;H7D76AH7DI77=E
EGBBADF764K>75FGD7E:A?7IAD=3@68ADG?EFA;@F7D35F
I;F:;@EFDG5FADE3@6AF:7DEFG67@FE)H7D?;>>;A@
EFG67@FE:3H73>D736K7@DA>>76;@F:7E75>3EE7E
R Public training eventsPublic training events :7>63F'A@9A835;>;F;7E
R Private trainingPrivate training 5GEFA?;L76FA3@AD93@;L3F;A@OE
EB75;U5D7CG;D7?7@FE67>;H7D763FF:7;DE;F7
&73D@?AD7
A@5>GE;A@
A>>AI;@9F:747EFBD35F;57EAGF>;@76;@F:;E9G;6753@:7>B
BDA<75FF73?ED76G57F:7F;?73@6D;E=A863F343E7
?;9D3F;A@EI:;>77@34>;@9F:7?FAF3=736H3@F397A8F:7
47@7UFEA8'A@9A3@6F:76A5G?7@F?A67>#@6A;@9
EAF:7K53@CG;5=>KEF3DFFAD73>;L73?AD739;>7E53>34>7
3@65AEF78875F;H7;@8D3EFDG5FGD7;@@AH3F;@9A@3BB>;53F;A@E
F:3FI7D7@7H7D478AD7BAEE;4>7
173@"7>B
173D7F:75A?B3@KF:3F4G;>6E3@6DG@E'A@9A)H7D
AD93@;L3F;A@ED7>KA@AGD5A??7D5;3>BDA6G5FE17
A887DEA8FI3D73@6E7DH;57EFA?3=7KAGD>;8773E;7D
'A@9AF>3E ;EF:763F343E73E3E7DH;578AD'A@9A
3H3;>34>7A@1-LGD73@6!*#F>7FEKAG8A5GEA@
3BBE;@EF736A8ABE1;F:'A@9AF>3EKAGA@>KB3K8AD
I:3FKAGGE7I;F:35A@H7@;7@F:AGD>K4;>>;@9?A67>F>3E
3GFAE53>7E;@D7EBA@E7FA3BB>;53F;A@67?3@6I;F:@A
6AI@F;?7A887D;@98G>>E75GD;FKD7E;>;7@573@6:;9:
B7D8AD?3@57
'A@9A@F7DBD;E76H3@576 ;EF:747EFI3KFADG@
'A@9AA@KAGDAI@;@8D3EFDG5FGD7#FE3U@7>KFG@76
B35=397A836H3@576EA8FI3D7EGBBADF57DF;U53F;A@E3@6
AF:7DE7DH;57E67E;9@768ADF:7I3KKAG6A4GE;@7EE
'A@9AF>3E3F3&3=7 3>>AIEKAGFACG;5=>K3@673E;>K
CG7DK63F3;@3@K8AD?3FA@?3LA@-GE;@9F:7
'A@9A+G7DK&3@9G3973@6FAA>E2AG6A@OF:3H7FA
?AH763F33@KI:7D7KAG53@IAD=I;F:5A?B>7J63F3
;??76;3F7>K;@;FE@3F;H78AD?3@6I;F:;FE8G>>K?3@3976
E7DH7D>7EE3D5:;F75FGD7KAG5A@FDA>5AEFE3@6D7?AH7F:7
AB7D3F;A@3>4GD67@
'A@9A:3DFE ;EF:747EFI3KFA5D73F7H;EG3>;L3F;A@EA8
'A@9A63F33@KI:7D7G;>6H;EG3>;L3F;A@ECG;5=>K3@6
73E;>KFA3@3>KL75A?B>7J@7EF7663F3?476;@6;H;6G3>
5:3DFE;@FA3@KI743BB>;53F;A@AD3EE7?4>7F:7?;@FA>;H7
63E:4A3D6E8ADE:3D;@9
'A@9A-F;F5: ;E3E7DH7D>7EEB>3F8AD?I:;5:3557>7D3F7E
3BB>;53F;A@67H7>AB?7@FI;F:E;?B>7E75GD73557EEFA63F3
3@6E7DH;57E8DA?F:75>;7@FS97FF;@9KAGD3BBEFA?3D=7F
83EF7DI:;>7D76G5;@9AB7D3F;A@3>5AEFE3@6788ADF
'A@9A,73>? I;>>5A?4;@7,73>?F:7BABG>3D?A4;>7
63F343E73@663F3EK@5:DA@;L3F;A@F75:@A>A9K3@6
'A@9A-F;F5:F:7E7DH7D>7EEB>3F8AD?8AD'A@9A
;@FA3G@;U76EA>GF;A@F:3F?3=7E;F73EK8ADKAGFA4G;>6
BAI7D8G>3@67@939;@97JB7D;7@57EA@?AD767H;57E
'A@9A>AG6'3@397D ;E35>AG643E76FAA>F:3F:7>BE
KAG?3@397'A@9AA@KAGDAI@;@8D3EFDG5FGD71;F:
3GFA?3F76BDAH;E;A@;@9U@79D3;@76?A@;FAD;@93@6
5A@F;@GAGE435=GBEKAG97F38G>>?3@397?7@FEG;F7F:3F
D76G57EAB7D3F;A@3>AH7D:736I:;>7?3;@F3;@;@98G>>5A@FDA>
AH7DKAGD63F343E7E
'A@9AA@EG>F;@9 B35=397E97FKAGFABDA6G5F;A@
83EF7D:7>BKAGFG@7B7D8AD?3@57;@BDA6G5F;A@:7>BKAG
E53>73@68D77KAGGBFA8A5GEA@KAGD@7JFD7>73E7
'A@9A.D3;@;@9 :7>BEKAG475A?73'A@9A7JB7DF
8DA?67E;9@FAAB7D3F;@9?;EE;A@5D;F;53>EKEF7?E3FE53>7
1:7F:7DKAGD7367H7>AB7DAD3D5:;F75FI753@
?3=7KAG47FF7D3F'A@9A
,7EAGD57E
AD?AD7;@8AD?3F;A@B>73E7H;E;F ?A@9A645A? AD5A@F35F
GE3F E3>7E?A@9A645A?
3E7-FG6;7E?A@9A645A?5GEFA?7DE
*D7E7@F3F;A@E?A@9A645A?BD7E7@F3F;A@E
D77)@>;@7.D3;@;@9G@;H7DE;FK?A@9A645A?
174;@3DE3@6H7@FE?A@9A645A?7H7@FE
A5G?7@F3F;A@6A5E?A@9A645A?
'A@9AF>3E63F343E73E3E7DH;578AD'A@9A
?A@9A645A?5>AG6
'A@9A@F7DBD;E7AI@>A36?A@9A645A?6AI@>A36
'A@9A-F;F5:-7DH7D>7EE*>3F8AD??A@9A645A?
5>AG6EF;F5:
'A@9A,73>??A@9A645A?D73>?
/-R#(.&R;@8A?A@9A645A?
T'A@9A#@5>>D;9:FED7E7DH76