Introduction to DBMS and SQL
https://www.w3schools.com/sql/default.asp
Data Analytics at a Glance!
11/19/19
2
Database Management System (DBMS)
■ Collection of interrelated data
■ Set of programs to access the data
■ DBMS contains information about a particular enterprise
■ DBMS provides an environment that is both convenient and
efficient to use.
■ Database Applications:
★ Banking: all transactions
★
★
★
★
★
Airlines: reservations, schedules
Universities: registration, grades
Sales: customers, products, purchases
Manufacturing: production, inventory, orders, supply chain
Human resources: employee records, salaries, tax deductions
■ Databases touch all aspects of our lives
11/19/19
3
Application Architectures
§Two-tier architecture: E.g. client programs using ODBC/JDBC to
communicate with a database
§Three-tier architecture: E.g. web-based applications, and
applications built using “middleware”
11/19/19
4
A Sample Relational Database
11/19/19
5
The Dangers in a Relational Database
• It looks very easy to use a RDBMS
– learning about normalization, SQL, etc. make for instant “experts.”
– lack of experience with major production systems can create
catastrophic project failures.
• Testing cycles are getting shorter
– newer development tools make software development quicker,
usually systems testing gets shortened.
• Recent college grads...
– least experienced developers usually have more training with
relational database technology.
– veteran developers are busy with older projects.
6
Sharing Knowledge and Success
• The Language of Oracle: SQL
– Structured Query Language, English like query language
– keywords: select, from, where, and order by
– Example query:
select city, temperature
from weather
where temperature > 80
order by temperature;
• Examples of relational databases
– stock tables in newspaper
– sports scores
– 100 year example in book
7
Relational Model
Attributes
■ Example of tabular data in the relational model
Customerid
customername
192-83-7465
Johnson
019-28-3746
Smith
192-83-7465
Johnson
321-12-3123
Jones
019-28-3746
Smith
11/19/19
customerstreet
customercity
accountnumber
Alma
Palo Alto
A-101
North
Rye
A-215
Alma
Palo Alto
A-201
Main
Harrison
A-217
North
Rye
A-201
8
Data Definition Language (DDL)
■ Specification notation for defining the database schema
★ E.g.
create table account (
account-number char(10),
balance
integer)
■ DDL compiler generates a set of tables stored in a data
dictionary
■ Data dictionary contains metadata (i.e., data about data)
★ database schema
★ Data storage and definition language
✔ language in which the storage structure and access methods
used by the database system are specified
✔ Usually an extension of the data definition language
11/19/19
9
Data Manipulation Language (DML)
■ Language for accessing and manipulating the data organized by
the appropriate data model
★ DML also known as query language
■ Two classes of languages
★ Procedural – user specifies what data is required and how to get
those data
★ Nonprocedural – user specifies what data is required without
specifying how to get those data
■ SQL is the most widely used query language
11/19/19
10
SQL
■ SQL: widely used non-procedural language
★ E.g. find the name of the customer with customer-id 192-83-7465
select customer.customer-name
from customer
where customer.customer-id = ‘192-83-7465’
★ E.g. find the balances of all accounts held by the customer with
customer-id 192-83-7465
select account.balance
from depositor, account
where depositor.customer-id = ‘192-83-7465’ and
depositor.account-number = account.account-number
■ Application programs generally access databases through one of
★ Language extensions to allow embedded SQL
★ Application program interface (e.g. ODBC/JDBC) which allow SQL
queries to be sent to a database
11/19/19
11
Database Users
■ Users are differentiated by the way they expect to interact with
the system
■ Application programmers – interact with system through DML
calls
■ Sophisticated users – form requests in a database query
language
■ Specialized users – write specialized database applications that
do not fit into the traditional data processing framework
■ Naïve users – invoke one of the permanent application programs
that have been written previously
★ E.g. people accessing database over the web, bank tellers, clerical
staff
11/19/19
12
Database Administrator
■ Coordinates all the activities of the database system; the
database administrator has a good understanding of the
enterprise’s information resources and needs.
■ Database administrator's duties include:
★ Schema definition
★ Storage structure and access method definition
★ Schema and physical organization modification
★ Granting user authority to access the database
★ Specifying integrity constraints
★ Acting as liaison with users
★ Monitoring performance and responding to changes in
requirements
11/19/19
13
Transaction Management
■ A transaction is a collection of operations that performs a single
logical function in a database application
■ Transaction-management component ensures that the database
remains in a consistent (correct) state despite system failures
(e.g., power failures and operating system crashes) and
transaction failures.
■ Concurrency-control manager controls the interaction among the
concurrent transactions, to ensure the consistency of the
database.
11/19/19
14
Comparing SQL and NoSQL
11/19/19
15
Country
String
Afghanistan
Akrotiri
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua and Barbuda
Argentina
Armenia
Aruba
Ashmore and Cartier Islands
Australia
Austria
Azerbaijan
Bahamas The
Bahrain
Baker Island
Bangladesh
Barbados
Bassas da India
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Bouvet Island
Brazil
British Indian Ocean Territory
British Virgin Islands
Brunei
Bulgaria
Burkina Faso
Burma
Burundi
Area(sq km) Birth rate(births/1000 population)
double
double
647500
47.02
123
28748
15.08
2381740
17.13
199
23.13
468
9
1246700
44.64
102
14.26
14000000
443
17.26
2766890
16.9
29800
11.76
193
11.26
5
7686850
12.26
83870
8.81
86600
20.4
13940
17.87
665
18.1
1
144000
30.01
431
12.83
0
207600
10.83
30528
10.48
22966
29.34
112620
41.99
53
11.6
47000
34.03
1098580
23.76
51129
12.49
600370
23.33
59
8511965
16.83
60
153
14.96
5770
19.01
110910
9.66
274200
44.17
678500
18.11
27830
39.66
Cambodia
Cameroon
Canada
Cape Verde
Cayman Islands
Central African Republic
Chad
Chile
China
Christmas Island
Clipperton Island
Cocos (Keeling) Islands
Colombia
Comoros
Congo Democratic Republic of the
Congo Republic of the
Cook Islands
Costa Rica
Cote d'Ivoire
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Dhekelia
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Europa Island
#European Union
Falkland Islands (Islas Malvinas)
Faroe Islands
Fiji
Finland
France
181040
475440
9984670
4033
262
622984
1284000
756950
9596960
135
6
14
1138910
2170
2345410
342000
240
51100
322460
56542
110860
9250
78866
43094
131
23000
754
48730
15007
283560
1001450
21040
28051
121320
45226
1127127
28
3976372
12173
1399
18270
338145
547030
27.08
34.67
10.84
25.33
12.92
35.17
45.98
15.44
13.14
20.82
37.52
44.38
27.88
18.6
35.51
9.57
12.03
12.57
9.07
11.36
39.98
15.73
23.28
27.19
22.67
23.32
27.04
36.18
38.62
9.91
38.61
10.1
13.97
22.73
10.5
12.15
French Guiana
French Polynesia
French Southern and Antarctic Lands
Gabon
Gambia The
Gaza Strip
Georgia
Germany
Ghana
Gibraltar
Glorioso Islands
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guyana
Haiti
Heard Island and McDonald Islands
Holy See (Vatican City)
Honduras
Hong Kong
Howland Island
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Israel
Italy
Jamaica
Jan Mayen
Japan
Jarvis Island
Jersey
Johnston Atoll
Jordan
91000
4167
7829
267667
11300
360
69700
357021
239460
7
5
131940
2166086
344
1780
549
108890
78
245857
36120
214970
27750
412
0
112090
1092
2
93030
103000
3287590
1919440
1648000
437072
70280
20770
301230
10991
373
377835
5
116
3
92300
20.7
16.93
36.24
39.86
40.03
10.25
8.33
23.97
10.87
9.72
15.93
22.3
15.42
19.03
34.11
9.01
42.03
37.65
18.45
36.59
30.38
7.23
9.76
13.73
22.32
20.71
16.83
32.5
14.47
18.21
8.89
16.56
9.47
9.66
21.76
Juan de Nova Island
Kazakhstan
Kenya
Kingman Reef
Kiribati
Korea North
Korea South
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macau
Macedonia
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Man Isle of
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Micronesia Federated States of
Midway Islands
Moldova
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Namibia
Nauru
4
2717300
582650
1
811
120540
98480
17820
198500
236800
64589
10400
30355
111370
1759540
160
65200
2586
25
25333
587040
118480
329750
300
1240000
316
572
181
1100
1030700
2040
374
1972550
702
6
33843
2
1564116
102
446550
801590
825418
21
15.78
40.13
30.86
16.09
10.08
21.88
22.48
35.99
9.04
18.88
26.53
44.22
26.82
10.41
8.62
12.06
8.04
12
41.66
43.95
23.07
35.43
46.77
10.17
11.18
33.52
14.14
41.43
15.62
41.58
21.01
25.11
15.27
9.26
21.52
17.56
22.29
35.79
25.16
25.14
Navassa Island
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Northern Mariana Islands
Norway
Oman
Pakistan
Palau
Palmyra Atoll
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn Islands
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russia
Rwanda
Saint Helena
Saint Kitts and Nevis
Saint Lucia
Saint Pierre and Miquelon
Saint Vincent and the Grenadines
Samoa
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Serbia and Montenegro
Seychelles
5
140800
41526
960
19060
268680
129494
1267000
923768
260
35
477
324220
212460
803940
458
12
78200
462840
406750
1285220
300000
47
312685
92391
9104
11437
2517
237500
17075200
26338
410
261
616
242
389
2944
61
1001
1960582
196190
102350
455
31.45
11.14
15
18.49
13.9
24.88
48.3
40.65
19.51
11.67
36.73
30.42
18.37
19.96
29.95
29.43
20.87
25.31
10.78
10.82
13.93
15.54
19.26
10.7
9.8
40.6
12.33
18.12
20.05
13.83
16.34
15.95
10.18
40.8
29.56
35.21
12.12
16.22
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Georgia and the South Sandwich Islands
Spain
Spratly Islands
Sri Lanka
Sudan
Suriname
Svalbard
Swaziland
Sweden
Switzerland
Syria
Taiwan
Tajikistan
Tanzania
Thailand
Togo
Tokelau
Tonga
Trinidad and Tobago
Tromelin Island
Tunisia
Turkey
Turkmenistan
Turks and Caicos Islands
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
Uruguay
Uzbekistan
Vanuatu
Venezuela
Vietnam
Virgin Islands
71740
693
48845
20273
28450
637657
1219912
3903
504782
5
65610
2505810
163270
62049
17363
449964
41290
185180
35980
143100
945087
514000
56785
10
748
5128
1
163610
780580
488100
430
26
236040
603700
82880
244820
9631418
176220
447400
12200
912050
329560
352
42.84
9.49
10.62
8.95
30.74
45.62
18.48
10.1
15.63
35.17
18.39
27.72
10.36
9.77
28.29
12.64
32.58
38.16
15.7
33.48
25.18
12.81
15.5
16.83
27.68
22.23
21.91
47.39
10.49
18.78
10.78
14.14
14.09
26.22
23.06
18.91
17.07
14.2
Wake Island
Wallis and Futuna
West Bank
Western Sahara
Yemen
Zambia
Zimbabwe
7
274
5860
266000
527970
752614
390580
32.37
43.07
41.38
29.74
Current account balance Death rate(deaths/1000 population) Debt - external
double
double
double
20.75
8000000000
-504000000
11900000000
5.12
4.6
3.33
6.07
25.9
5.43
1410000000
21900000000
5.44
7.56
8.16
6.57
231000000
1.577E+11
905000000
285000000
7.44
9.7
9.86
8.97
4.08
3.087E+11
15500000000
1832000000
308500000
6215000000
216600000
8.4
9.17
19970000000
668000000
-1119000000
11400000000
-115000000
-159900000
273000000
-2100000000
337000000
14.15
10.22
6.04
13.76
7.63
12.94
7.64
8.44
29.36
600000000
28300000000
1362000000
1600000000
160000000
245000000
5439000000
3000000000
531000000
8000000000
6.15
2.198E+11
682900000
-471700000
-185000000
-59500000
4.42
3.42
14.26
18.86
12.15
17.43
36100000
0
16100000000
1300000000
6752000000
1133000000
-37880000
5473000000
-240400000
-38300000000
-3283000000
-2899000000
586100000
10450000000
8800000
-316200000
-149100000
28200000000
-93760000
8.97
15.4
7.73
6.62
4.81
20.27
16.41
5.76
6.94
2400000000
8460000000
5.7E+11
325000000
70000000
881400000
1100000000
44600000000
2.333E+11
266000000
5.59
8.4
14.43
14.82
-980300000
-421500000
-1925000000
-185100000
-619900000
-5730000000
6529000000
4.33
14.94
11.38
7.19
7.64
10.54
10.43
38700000000
232000000
11600000000
5000000000
141000000
5962000000
11810000000
26400000000
12090000000
7327000000
36280000000
21700000000
330200000
2185000000
30320000000
-1706000000
762200000
261100000
2113000000
-880500000
-578600000
-144900000
-1169000000
-464400000
19.39
6.81
7.35
6.3
4.24
5.26
5.85
12
13.53
13.21
15.06
366000000
161500000
7745000000
16810000000
33750000000
4792000000
248000000
311000000
8373000000
2900000000
10.1
11390000000
-305000000
8.69
5.65
9.79
9.08
64000000
188100000
30000000000
4.85
4.63
1200000000
11.72
11.81
3.87
9.09
10.55
10.84
9.18
3804000000
476000000
108000000
1800000000
67230000000
25000000
196000000
-129400000
-27630000
10.15
7.77
7.17
6.06
4.41
6.81
9.95
15.38
16.53
8.32
12.34
258300000
14850000000
6.87
5.98
5365000000
4.176E+11
-7941000000
-570000000
4897000000
7338000000
2100000000
-560000000
-2881000000
211900000
-21100000000
-830700000
13.19
6.68
8.28
6.25
5.55
5.49
7.85
6.18
10.3
5.37
57000000000
3073000000
1.172E+11
1.415E+11
13400000000
1.25E+11
11000000000
74460000000
9.139E+11
5964000000
1.702E+11
8.95
196800000
-16400000
-632900000
73590000000
83870000
-8000000000
-1381000000
-308300000
7396000000
5969000000
3250000000
941500000
1200000000
1200000000
9.19
203200000
2.63
7320000000
-39020000
-459200000
26780000000
12040000000
-87920000
-80760000
-1251000000
-2389000000
-108300000
9895000000
-1600000000
-311000000
-281900000
-55500000
11810000000
-241000000
284100000
-4113000000
-148400000
765400000
-101200000
234300000
9.46
14.65
26030000000
6792000000
8.37
7.05
6.26
2.42
7.13
11.83
13.7
6.24
25.03
17.87
3.48
7.06
10.92
8.41
4.23
8.73
11.35
23.39
5.06
7.24
19.05
8
11.26
4.88
6.44
12.44
6.83
7.9
4.73
4.87
10000000
12000000000
1.6E+11
15020000000
1970000000
2490000000
7368000000
15840000000
735000000
2100000000
4069000000
0
10010000000
12.79
12.71
7.03
7.17
5.64
20.99
18.36
6.82
1400000000
18000000000
1191000000
8900000
17070000000
966000000
1136000000
33300000
2700000000
1863000000
4600000000
3129000000
53360000000
281000000
3300000000
130000000
86500000
180000000
2500000000
1780000000
1.499E+11
53100000
19900000000
-3647000000
-843100000
5228000000
9.47
8.68
6.41
5.65
7.53
4.49
21.33
17.18
2700000000
1350000000
79000000
47340000000
4573000000
1600000000
30550000000
418000
30520000000
2674000000
1400000000
2.3
9.45
3.86
8.45
6.85
0
4814000000
33970000000
0
-469600000
29150000
-36110000
-30000000
3600000000
6.54
7.37
4.53
6.26
5.47
8780000000
2463000000
3239000000
29790000000
55600000000
-3831000000
-8120000000
10.01
10.43
7.86
4.61
5.48
11.74
14.52
16.32
6.43
8.47
5.12
6.7
6
6.54
8.07
6.68
2.62
10.6
10.49
6.34
99150000000
2.747E+11
5187000000
-3631000000
46040000000
-212500000
-31500000
51500000000
-518800000
-3008000000
-98420000
18620000000
24590000000
1.696E+11
1300000000
171000000
214000000
167200000
197000000
318000000
34350000000
3476000000
12970000000
218100000
-2480000000
20.61
4.16
9.43
10.22
3.98
16.97
21.32
1500000000
19400000000
19540000000
14650000000
180400000
3000000000
27010000000
-30890000000
9.63
7.711E+11
-587300000
-763600000
6.49
9.16
7.16
10850000000
21000000000
321000000
-82400000
24080000000
40950000000
1100000000
21160000000
-52000000
-327400000
6736000000
-125600000
25.26
10.36
8.48
4.88
6.38
8.39
16.71
7.02
11.8
320000000
66500000000
1548000000
5.35
9.37
8800000000
-1400000000
-51640000
71850000
-15300000000
114000000
-590800000
4584000000
6300000000
-33460000000
-6.465E+11
181800000
461900000
14590000000
-2061000000
5.09
5.96
8.78
4.28
7.22
12.8
16.42
4.26
10.18
8.25
9.06
7.95
7.9
4.9
6.2
6.26
4000000000
55500000000
888000000
7321000000
50590000000
1400000000
0
63400000
2940000000
14710000000
16900000000
2400000000
3865000000
16370000000
5900000000
4.71E+12
1.4E+12
12800000000
4351000000
83700000
33290000000
16550000000
369900000
-181400000
-230300000
3.99
108000000
8.53
20.23
24.66
5400000000
5353000000
4086000000
Electricity - consumption(kWh) Electricity - production(kWh) Exports
GDP
double
double
double
double
652200000
540000000
446000000 21500000000
6760000000
23610000000
120900000
1587000000
42600000
5680000000
552400000 17460000000
25760000000 32160000000
2.123E+11
130000000
30000000
500000000
58000000 1900000000
1707000000 12760000000 23170000000
2600000
112000000
103000000
81650000000
5797000000
751200000
110800000
689000000
750000000
81390000000 33780000000
4.835E+11
6492000000
850000000 13650000000
807700000
128000000 1940000000
1.956E+11
55090000000
17370000000
1596000000
6379000000
2.103E+11 86890000000
6.117E+11
58490000000
1.027E+11
2.559E+11
17550000000 3168000000 30010000000
1716000000
636000000 5295000000
6860000000 8205000000 13010000000
15300000000
744000000
16450000000
800000000
34300000000
78820000000
108800000
565200000
598000000
312900000
3848000000
8318000000
1890000000
30000000000 11470000000 70500000000
76580000000
2.557E+11
3.162E+11
117000000
401400000 1778000000
285200000
720900000 8338000000
643000000
879000000 2330000000
2001000000
154000000 2900000000
4132000000 1986000000 22330000000
10040000000 1700000000 26210000000
930000000 2940000000 15050000000
3.519E+11
33740000
2286000000
32710000000
335700000
3484000000
137800000
7478000000
206000000
3.39E+11 95000000000
36280000
2458000000
43070000000
361000000
5068000000
132000000
2.757E+11
4569000000
1.492E+12
25300000 2498000000
7700000000 6842000000
9134000000 61630000000
418600000 15740000000
2137000000 74300000000
31840000 4001000000
100600000
3321000000
4.873E+11
40060000
382100000
98580000
89400000
41800000000
1.63E+12
122000000 2311000000 26990000000
3571000000 2445000000 30170000000
5.489E+11
3.156E+11
1.023E+12
43080000
61110000
600000000
410800000
1200000 1391000000
106000000
172000000 4248000000
96130000
365000000 15660000000
48600000000 29200000000
1.691E+11
1.91E+12
5.831E+11
7.262E+12
41140000000
22170000
4168000000
573600000
25110000
5733000000
2976000000
15200000000
13400000000
602000000
55330000000
31630000000
44870000000 15500000000
2.811E+11
23840000
28000000
441000000
6086000000 1417000000 42740000000
348000000 2224000000 2324000000
27000000
9100000
105000000
6614000000 6184000000 37970000000
4759000000 5124000000 24780000000
12510000000 7845000000 50330000000
14410000000 2104000000 33920000000
4000000000
49300000 4540000000
71750000000 66510000000
1.722E+11
36380000000 73060000000
1.744E+11
167400000
63620000
8912000000
180000000
68410000
9583000000
75580000000
75580000000
4450000000
24820000
229400000
6358000000
1998000000
81270000000
81270000000
4158000000
26690000
246600000
8301000000
2149000000
155000000
39000000
5446000000
8000000
7560000000
11000000000
3249000000
2771000000
64440000
5701000000
562800000
619000000
384000000
55680000000
370000000
49510000000
3.163E+11
32350000000
1270000000
4154000000
19230000000
54890000000
2.661E+12
17720000
204600000
697500000
78580000000
4.147E+11
2.888E+12
1.109E+12
19060000
82000000
220000000
408000000
750000000
609000000
71590000000 61040000000
5.286E+11
4.19E+11
1.165E+13
75000000
1000000000
5173000000
1.512E+11
1.737E+12
427900000
353400000
460100000
380000000
1080000000
83990000
1161000000
90310000
6811000000
5.195E+11
6137000000
96760000
6732000000
5.6E+11
6922000000
104000000
47420000000
227900000
138600000
1079000000
776600000
5760000000
795200000
51150000
751400000
574700000
155000000
244000000
1551000000
4580000000
3710000000 7966000000
114400000 2799000000
205000000
768000000
909400000 14450000000
8.933E+11
2.362E+12
3010000000 48270000000
136000000
769000000
47220000000 15500000000
2.264E+11
245000000
388000000 1100000000
149000000
46000000
440000000
1160000000
140000000 3513000000
835000000
38000000 3200000000
6608000000 2911000000 59470000000
2590000000
855000000
709200000 19500000000
55000000
54000000 1008000000
808000000
570200000 2899000000
618000000
338100000 12050000000
3771000000
38450000000
3626000000
35510000000
1457000000 18790000000
2.681E+11
2.345E+11
35990000000
7692000000
5.101E+11
92350000000
1.199E+11
33700000000
21780000000
38300000000
2.939E+11
5849000000
34070000000
8271000000
5.472E+11
1.102E+11
1.29E+11
32600000000
22880000000
42670000000
2.616E+11
6289000000
54620000000
1.493E+11
2902000000 9373000000
69180000000
3.319E+12
69860000000
8.274E+11
38790000000
5.167E+11
10100000000 89800000000
1.038E+11
1.264E+11
34410000000
1.29E+11
3.364E+11
1.609E+12
1679000000 11130000000
9.71E+11
1.044E+12
630100000
7094000000
5.388E+11
3.745E+12
3600000000
7307000000
3200000000 25500000000
62210000000
4337000000
66820000000 18470000000
1.184E+11
4475000000 2589000000 34680000000
6510000
31260000000
2.936E+11
30160000000
10210000000
3036000000
5829000000
8591000000
308000000
454600000
19430000000
7000000
35000000
79000000
33620000000 1200000000 30880000000
3.225E+11
2.506E+11
9.251E+11
32430000000 27420000000 48000000000
11720000000
646700000 8495000000
3560000000
365500000 11280000000
4547000000 3569000000 26530000000
8066000000 1783000000 18830000000
314000000
484500000 5892000000
488800000 1079000000 2903000000
20890000000 18650000000 37480000000
2470000000
825000000
17930000000 8880000000 45230000000
2511000000 13400000000 27270000000
1719000000 2580000000 9100000000
6273000000 1629000000 14400000000
840200000
868200000 14560000000
1088000000
503400000 7410000000
75330000000
1.235E+11
2.293E+11
124400000
90000000 1250000000
700000000
915000000 11000000000
2150000000 2625000000 7223000000
2113000000
9000000
115000000
1178000000
250000000 6117000000
190200000
541000000 5534000000
1836000000 2012000000 15680000000
3440000
466800000
2.036E+11
1.824E+11
1.006E+12
192000000
22000000
277000000
10170000000
5735000000
1772000000
7216000000
781400000
1012000000
68400000000
115700000
651000000
2000000000
1095000000
176900000
1707000000
1.897E+11
178600000
4605000000
3876000000
1030000000
2209000000
1674000
14240000000
5046000000
1920000000
27900000
2692000000
1800000
13910000000
8859000000
1167000000
30000000
853000000
700000
9754000000
689400000
1356000000
640000
8581000000
870000000
5332000000
29000000
1.346E+11
23380000000
14760000000
60000000
2005000000
1.007E+11
934300000
1471000000
35710000000
2318000000
327600000
18430000000
2790000
1.074E+11
9792000000
52660000000
2054000000
568000000 39530000000
90610000000
2.931E+11
4.811E+11
1005000000 1579000000 2450000000
1581000000
448000000 3158000000
38390000000 19850000000 92510000000
2553000000
750000000 12340000000
266200000
280000000 9716000000
19850000000 33990000000
1.257E+11
3000000
137200
7600000
1500000
900000000
1.259E+11 76640000000
1.83E+11
9896000000 13140000000 38090000000
75270000000 15070000000
3.473E+11
18000000
174000000
4473000000
1561000000
2469000000
20220000000
46050000000
4873000000 5699000000 20570000000
1679000000 2437000000 11990000000
48360000000 2936000000 29930000000
22880000000 12300000000
1.553E+11
52860000000 38630000000
4.306E+11
1.174E+11
42150000000
20540000000
9046000000
1084000000
57500000000
8.943E+11
195000000
4650000
98440000
251300000
40060000
84820000
113500000
1.338E+11
43280000000
22090000000
9727000000
1166000000
56530000000
9.15E+11
166700000
5000000
105800000
270300000
43080000
91200000
122000000
15810000
1.285E+11
1615000000
32330000000
202800000
17000000
1.382E+11
1737000000
31640000000
218000000
75980000000
4.63E+11
37680000000
1.887E+11
46900000000 68950000000
15000000000 19490000000
214000000 4570000000
23540000000
1.715E+11
1.625E+11
1.408E+12
69780000 10430000000
17000000
18000000
70000000
339000000
66000000
866000000
10000000
48300000
38000000
342000000
14000000 1000000000
940000000
6700000
214000000
1.13E+11
3.102E+11
1374000000 18360000000
3245000000 26270000000
256200000
626000000
237400000
32000000000
28890000000
11800000000
29760000
223500000
1.894E+11
255300000
49000000 3335000000
35330000000
1.74E+11
1.209E+11
31150000000 29240000000 78890000000
12490000000 14970000000 39410000000
32000000
74000000
800000000
240300000
79000000 4597000000
2.026E+11 41970000000
4.914E+11
2.184E+11
2.29E+11
6228000000
2400000000
1845000000
6697000000
2581000000
1984000000
1173000000
1.381E+11
54530000000
24320000000
1.474E+11
14410000000
2566000000
1.061E+11
451200000
23060000
5341000000
10050000000
1.179E+11
8908000000
4650000
1401000000
1.32E+11
36510000000
3.374E+11
3.66E+12
5878000000
46660000000
45030000
89300000000
32060000000
962600000
1.725E+11
9.376E+11
5306000000 80580000000
3395000000 76190000000
495000000 1885000000
402000000
900100000 6018000000
1.428E+11
1.217E+11
2.554E+11
63470000000
1.307E+11
2.519E+11
26150000000 6086000000 60440000000
1.585E+11
1.705E+11
5.762E+11
15080000000 1130000000 7950000000
2727000000 1248000000 23710000000
1.189E+11 87910000000
5.248E+11
108800000
663100000 8684000000
98000
1500000
24790000
27000000
244000000
5743000000 6671000000 11480000000
10720000000 9926000000 70880000000
1.397E+11 69460000000
5.087E+11
11410000000 4000000000 27600000000
5000000
169200000
216000000
1000000
12200000
1775000000
621700000 39390000000
1.8E+11 32910000000
2.991E+11
45120000000 69480000000 63670000000
3.959E+11
3.472E+11
1.782E+12
3.839E+12
7.95E+11
1.175E+13
8536000000 2200000000 49270000000
47700000000 3700000000 47590000000
48420000
26600000
580000000
89700000000 35840000000
1.452E+11
34480000000 23720000000
2.272E+11
1035000000
2500000000
250000
205000000
83700000
2827000000
5345000000
11220000000
90000000
3040000000
8167000000
8839000000
60000000
1800000000
4468000000 16250000000
1548000000 9409000000
1409000000 24370000000
GDP - per capita GDP - real growth rate(%) HIV/AIDS - adult prevalence rate(%)
double
double
double
800
7.5
0.01
4900
6600
8000
26800
2100
7500
5.6
6.1
2
11.7
2.8
3.9
11000
12400
4600
28000
3
8.3
9
-1.5
0.7
0.1
30700
31300
3800
17700
19200
3.5
1.9
9.8
3
5.6
0.1
0.3
0.1
3
0.2
2000
16400
4.9
2.3
0.1
1.5
6800
30600
6500
1200
36000
1400
2600
6500
9200
6.4
2.6
3.5
5
2
5.3
3.7
5
3.5
0.3
0.2
2.4
1.9
0.1
0.1
0.1
37.3
8100
5.1
0.7
38500
23600
8200
1200
1700
600
1
3.2
5.3
4.8
-1.3
3
0.1
0.1
4.2
1.2
6
0.1
2000
1900
31500
1400
32300
1100
1600
10700
5600
5.4
4.9
2.4
5
1.7
0.5
38
5.8
9.1
2.6
6.9
0.3
0.04
6600
700
700
800
5000
9600
1500
11200
3000
7135
16800
32200
3.6
2
7.5
3.7
7.1
3.9
-1
3.7
3
2.6
3.7
2.1
0.7
0.12
4.2
4.9
1300
5500
6300
400
3700
4200
4900
2700
900
14300
800
3.5
-1
1.7
1
5.8
4.5
1.8
20
2.5
6
11.6
2.9
26900
25000
22000
5900
29000
28700
2.4
10
3.6
3
2.1
13.5
4.8
0.3
0.1
0.6
7
0.1
0.1
0.1
0.1
0.2
1.7
0.3
0.1
0.7
3.4
2.7
1.1
4.4
0.1
0.1
0.4
8300
17500
5900
1800
600
3100
28700
2300
27900
1.9
6
4.5
9.5
1.7
5.4
8.1
1.2
21300
20000
5000
7900
21000
4200
40000
2100
700
3800
1500
3.7
1.8
2.5
0.2
2.6
3
1
2.6
1.9
-3.5
1.1
2800
34200
4.2
7.9
1.8
0.1
14900
31900
3100
3500
7700
3500
31900
20800
27700
4100
3.9
1.8
6.2
4.9
6.3
52.3
5.1
3.9
1.3
1.9
0.1
0.2
0.9
0.1
0.1
0.1
0.1
0.1
0.5
1.2
29400
2.9
0.1
5.1
0.1
0.1
0.1
3.1
3.2
10
2.5
5.6
40000
4500
7800
1100
9.1
2.2
800
1400
19200
21300
1700
1900
11500
5000
3200
900
6700
25000
12500
58900
19400
7100
800
600
9700
3900
900
18200
28500
1600
14400
1800
12800
2600
9600
2000
1.5
1
4.6
6.8
6
6
7.6
4
3.3
21.8
4.9
11
6.6
2.3
15.6
1.3
5.5
4
7.1
2.3
4
1
1900
27000
1900
3400
4200
1200
7300
5000
0.2
6.7
0.1
0.12
0.1
0.1
0.6
0.1
28.9
5.9
0.3
0.1
0.2
0.1
1.7
14.2
0.4
0.1
1.9
0.2
1
3
4.7
0.6
0.1
4.1
1
0.3
6.8
0.9
10.6
-1
4.4
8.2
4.8
0.2
0.1
0.1
12.2
21.3
1500
29500
11400
15000
23200
2300
900
1000
3600
3
1.2
0.5
0.5
0.2
4.8
4
3.5
6.2
-0.3
0.1
0.2
1.2
5.4
12500
40000
13100
2200
9000
3.3
1.2
6.1
1
0.1
0.1
0.1
6900
2200
4800
5600
5000
6
0.9
2.8
4.5
5.9
0.9
0.6
0.5
0.5
0.1
12000
17900
17700
23200
6000
7700
9800
1300
2500
8800
5400
7000
2900
5600
34600
1200
12000
1700
2400
7800
5.6
1.1
2.7
8.7
2.5
8.1
6.7
0.9
0.1
0.4
0.09
0.1
1.1
5.1
-1.9
3.3
0.7
5
7.5
6
5
3.2
6.5
1.5
0.01
0.8
0.2
600
27800
14500
19600
1700
600
11100
6
8.1
5.3
3.9
5.8
2.8
3.5
1
21.5
23300
2.6
0.7
4000
1900
4300
5.2
6.4
4.2
5100
28400
33800
3400
25300
1100
700
8100
1600
1000
2300
10500
2.5
3.6
1.8
2.3
6
10.5
5.8
6.1
3
0.1
2.3
1.7
0
38.8
0.1
0.4
0.1
7100
7400
5700
11500
1100
1500
6300
25200
29600
40100
14500
1800
2900
5800
2700
17200
5.1
8.2
7.5
4.9
3
5
12
5.7
3.2
4.4
10.2
4.4
1.1
16.8
7.7
2
1.5
5.7
7
0.2
0.1
0.1
0.1
8.8
1.5
4.1
3.2
0.1
0.1
0.1
4.1
1.4
0.18
0.2
0.6
0.3
0.1
0.7
0.4
3800
800
6
800
900
1900
1.9
4.6
-8.2
0.1
16.5
24.6
HIV/AIDS - deaths HIV/AIDS - people living with HIV/AIDS Highways(km) Imports
double
double
double
double
21000 3759000000
500
9100
21000
240000
18000 2076000000
104000 15250000000
185
123000000
269 1077000000
51429 4896000000
105
80900000
1500
200
130000
2600
250
692000000
215471 22060000000
8431 1300000000
800
841000000
100
100
200
200
14000
10000
1400
5600
600
811603 98100000000
200000
1.012E+11
28030 3622000000
2693 1630000000
3459 5870000000
650
200
13000
2500
207486 10030000000
1600 1039000000
1000
100
5800
15000
10000
3600
68000
100
33000
100
4900
900
350000
79990 13570000000
149028
2.35E+11
2872
579900000
6787
934500000
450 5523000000
4007
196000000
60282 1595000000
21846 5200000000
10217 2255000000
15000
660000
1724929 61000000000
200
346
300000
330000
250000
177
187000000
2525 5200000000
37077 12230000000
12506
866300000
28200 1754000000
14480
138200000
200
100
29000
20000
25000
15000
49000
1500
225
170000
560000
56000
775
23000
18000
1400
44000
260000
200000
26000
840000
12323 3129000000
34300 1979000000
1408800
2.561E+11
1100
387300000
785
457400000
23810
136000000
33400
500700000
79605 22530000000
1765222
5.524E+11
240
15
112998
880
157000
12800
320
35303
50400
28344
60858
13943
127204
71847
3600
190000
100000
9700
1100000
90000
900
47000
10
200
10
100
12000
570000
200
3300
1000
2500
5000
690
9100
7900
88000
1700
700
2200
370
6300
200
120000
21000
12000
29000
5900
60000
7800
1500000
2890
665000000
780
98200000
12600 8093000000
3800
167000000
43197 7650000000
64000 19210000000
10029 5968000000
2880 1167000000
4010
622000000
55944 7318000000
33297 2104000000
600
1500
120000
4634810
1.123E+12
440
53000000
463
466000000
3440
835000000
78197 45170000000
893100
4.197E+11
200
100
1000
15340000000
88000000
933000000
749300000
50700000
7842000000
3360000000
16700000000
5296000000
415200000
68190000000
63450000000
817
2590
625000000
1341000000
1225000000
180900000
1900000000
1806000000
7.167E+11
3699000000
1743000000
3000
600
48000
6800
8464
2700
200
1000
30000
3000
43000
350000
20229
230735
46176
29
100
9100
100
5800
78000
9000
1200
1100
24000
140000
17000
11000
280000
30500
4400
7970
4160
641500000
104000000
650100000
1085000000
4100
200
63000
2600
13603
1831
3332000000
2.759E+11
100
100
310000
2400
800
100
100
1000
900
2800
220
5100000
110000
31000
500
2800
3000
140000
22000
159568
13004
2525989
342700
167157
45550
95736
16903
479688
18700
58680000000
3307000000
89330000000
45070000000
31300000000
9900000000
60650000000
36840000000
3.293E+11
3624000000
500
12000
1171647
4.018E+11
117000 54280000000
445000000
1040
208000000
947 1700000000
977
462000000
14118 7770000000
577
500
600
7301
7600000000
200
150000
16500
1200000
200
8300
200
200
500
200
29000
7200
3900
1700
7600
2800
320000
100000
10000
200
100
1300
500
100
7500
84000
2000
12000
100
200
140000
900000
52000
100
140000
500
100
9500
700
5000
160000
300
5500
200
500
110000
16000
15000
1300000
210000
82980 13070000000
63942 4190000000
670
31200
86990
4450
18500
21716
60472
7300
5940
10600
83200
250
77148
5210
341
8684
49827
28400
65877
83000000
2100000000
2.142E+11
11120000000
775100000
579500000
5970000000
8162000000
730900000
5051000000
7224000000
917300000
11020000000
16300000000
2760000000
2677000000
1147000000
521100000
99300000000
392000000
15100
927000000
2222 3407000000
800
65
54000000
2105 2000000000
7660
860000000
2000 2245000000
93
141300000
329532
1.908E+11
240
149000000
12719 1830000000
50
49256 1000000000
227
17000000
57694 15630000000
30400
972900000
42237 1473000000
30
19800000
3100
100
61000
19000
200
4800
310000
1400
6400
70000
3600000
100
200
4900
2100
1300
74000
600
600
4200
500
16000
16000
15000
82000
9000
100
1000
14000
22000
7397
350
9000
22000
6500
860000
250000
3
12
3500
100
44000
10000
13223
116500
600
5432
92382
18712
10100
194394
234
80
362
91852
34965
257683
61
1419000000
2.527E+11
2233000000
1007000000
19770000000
2020000000
400000000
17140000000
2380000
17900000
11643
19600
29500
78230
202124
6
364697
17135
25328
1230
1214
198755
537289
12000
198
320
1210
114
829
790
220
320
152044
14576
45290
373
7164000000
1353000000
3330000000
9600000000
37500000000
45960000000
6373000000
14010000000
99000000
81610000000
52100000000
29100000000
6150000000
2500000000
28430000000
92910000000
260000000
42000000
195000000
267000000
106000000
174000000
113000000
41000000
36210000000
2128000000
9538000000
393400000
11000
200
100
100
170000
4100
200
280
11300
264000000
3130
1.552E+11
42970 29670000000
20250 16070000000
1360
67000000
22100
344000000
275971 39420000000
370000
43000
5300000
1000
140000
664852
2.22E+11
200
23000
500
0
17000
100
100
200
3500
400000
5200
0
220000
3600
13000
500
11650
11900
4492
7265000000
3496000000
604000000
100
160000
58000
10000
200
1600000
570000
110000
1900
29000
200
1000
100
200
78000
20000
530000
360000
500
14000
500
500
51000
950000
6000
11000
4100
9000
110000
220000
3107 1140000000
213237 97970000000
71212
1.211E+11
45697 5042000000
37299
1.654E+11
27767 1300000000
88200 1972000000
57403 80840000000
7520
824900000
323000
680
86000000
8320 4650000000
18997
354421
24000
121
8
27000
169679
1088
392931
6393603
8983
81600
1070
96155
93300
1257
11520000000
94500000000
2850000000
175600000
79000000
1306000000
31450000000
45660000000
4.394E+11
1.476E+12
2071000000
2820000000
138000000
14980000000
26310000000
89000
170000
12000
920000
1800000
120
4500
6200
67000
91440
18338
300000
1500000000
3734000000
1519000000
1599000000
Industrial production growth rate(%) Infant mortality rate(deaths/1000 live births)
double
double
163.07
3.1
6
1
3.1
21.52
31
9.27
4.05
191.19
21.03
6
12
15
19.46
15.18
23.28
5.89
1.9
3.3
4
2
4.69
4.66
81.74
25.21
17.27
6.5
-3.2
62.6
12.5
4
3.5
4.6
8.3
9.3
5.7
5.5
4.4
13.37
4.68
25.69
85
8.53
100.44
53.11
21.05
54.58
6
29.61
5
5.2
14
18
18.05
12.61
20.55
97.57
67.24
69.29
22
4.2
2
3
5
7.8
17.1
4
-2
0
1
3.1
15
2.7
1.4
-0.3
4.7
1.7
3
-10
2
8.5
10
2.5
0.7
30
71.48
68.26
4.75
47.77
8.19
91
93.82
8.8
24.18
20.97
74.93
92.87
92.41
9.95
90.83
6.84
6.33
7.18
3.93
4.56
5
6.7
104.13
14.15
32.38
47.41
23.66
32.59
25.1
85.13
74.87
7.87
95.32
2.4
5.2
8
6.24
12.62
3.57
4.26
2
1.7
12.07
8.44
1.6
3
2.2
3.8
4.1
0.7
4.1
3.2
2.6
7.1
53.64
72.02
22.93
18.59
4.16
51.43
5.13
5.53
15.82
14.62
8.6
6.94
35.93
4.71
90.37
107.17
33.26
73.45
7.7
1
29.32
2.97
9.6
8.8
7.4
10.5
3.5
7
4.5
0.7
-2
8.57
3.31
56.29
35.6
41.58
50.25
5.39
7.03
5.94
12.36
6.6
3.26
5.24
5
17.35
10.6
2.6
29.21
61.47
0.7
48.52
24.04
7.05
9.95
35.64
85.22
9.55
24.52
84.23
128.87
24.6
4.7
6.89
4.81
4.39
10.09
76.83
103.32
17.7
56.52
116.79
3.89
5.93
29.45
7.09
70.89
15.03
62.4
20.91
30.21
10.1
-5
6
9.7
8.5
15.5
12
2.9
0
3
1.4
10.2
4.4
3.2
2
8
3.8
17
4.1
3.4
40.42
5.43
53.79
7.35
41.62
130.79
48.98
9.95
8.7
0.8
-0.6
5.9
4.4
1.8
5.2
-1.2
13.1
5.4
0
5.2
5
10
1.1
10
4
6.4
7
-8.9
-0.9
2.8
6
2.8
4.7
1.7
66.98
5.04
10.03
7.72
5.85
29.11
121.69
98.8
7.11
3.7
19.51
72.44
14.84
20.47
51.45
25.63
31.94
23.51
8.51
5.05
8.24
18.61
7.78
26.43
15.39
91.23
19
14.49
13.53
7.54
14.78
27.71
5.73
43.11
13.24
55.51
12.89
15.53
5.5
143.64
2.29
7.41
4.45
21.29
116.7
61.81
3
4.42
7.1
8.5
6.5
14.35
62.5
23.57
3.7
5.5
4.7
7
12.2
8.2
8.4
8.5
69.27
2.77
4.39
29.53
6.4
110.76
98.54
20.48
66.61
8.6
7.2
12.62
24.31
4.4
16.5
22
24.77
41.04
73.08
15.67
20.03
67.83
20.34
14.51
5.16
6.5
11.95
71.1
55.16
22.2
25.95
8.03
11.1
5.1
3.9
5.6
16.5
4
0.9
4.4
22
6.2
1
12.3
16
19.62
3
6.9
-7.8
61.5
88.29
67.69
Inflation rate (consumer prices)(%) Internet hosts Internet users
double
double
double
10.3
1000
3.2
3.1
455
897
30000
500000
4.3
43.8
2.3
4144
17
24500
41000
3000
0.4
6.1
3.5
3.2
1665
742358
2206
923
10000
4100000
150000
24000
2.3
1.8
4.6
1.2
2.1
2847763
387006
586
302
1334
9472000
3730000
300000
84000
195700
6
-0.5
1
204
243000
100000
17.4
1.9
2.9
2.8
3.3
3
4.9
1.1
7
5308
166799
2613
879
5161
985
7080
6994
1920
1391900
3400000
30000
70000
34500
15000
270000
100000
60000
7.6
3163349
14300000
6409
53421
442
3
22
4000
35000
630000
48000
28000
14000
2.5
0.3
6.1
2.4
17.2
8.5
3.1
1
1.9
1.5
2.8
3.6
8
2.4
4.1
818
479
3210081
118
5.9
3.5
14
1.8
3.2
11.5
1.4
2.5
3.1
2.4
3.2
1.4
115158
11
153
46
6
8
202429
160421
30000
60000
16110000
20400
9909
5000
15000
3575000
94000000
10826
3795
29644
1529
5901
295677
1219925
2732200
5000
50000
15000
3600
800000
90000
1014000
120000
210000
2700000
2756000
2
1
55
4
2
9.5
5.4
8.5
10
3
2.4
702
681
64197
6500
12500
500000
3188
3401
4084
3
1047
82142
9
569700
2700000
550000
1800
9500
444000
75000
2.1
3.6
5.1
1.6
0.7
2.3
22000414
206032067
493
1219173
2396761
25000
55000
2650000
21900000
1.5
1.5
1.5
7
2.2
5.5
1.6
13
1.5
2.9
1.6
2.8
0
7.2
4.9
18
4
4.5
22
7
-0.3
5123
93
568
5160
2686119
407
208977
2642
18
20360
380
2
613
9
1944
591993
383071
122175
86871
62036
5269
3200
35000
35000
25000
60000
150500
39000000
170000
6200
1718400
20000
15000
20000
50000
400000
40000
19000
125000
80000
168600
3212800
7
4
4.2
6.1
15.5
25.4
2.2
0
2.3
12.4
162228
437516
1437511
1480
1600000
195000
18481000
8000000
4300000
25000
1260000
2000000
18500000
600000
-0.1
12962065
57200000
3160
457000
5.3
3.2
6.9
9
21984
8325
2.5
250000
400000
2000
3.6
2.3
3.2
12.3
6
2
5.3
15
2.9
1
1.1
2.4
2
0.4
7.5
12
1.3
1
4.5
2.9
3.6
2
3.9
7
4.5
694206
3437
12299
937
51758
6998
119
14
67
3727
67769
28214
89
3738
773
18
107971
532
187
7156
29220000
567000
152000
15000
936000
400000
21000
1000
160000
20000
695700
165000
120000
100000
70500
36000
8692100
15000
25000
120000
6
1400
40000
10000
150000
5.4
1
1333406
10033000
6000
11.5
1.9
11
2.6
2.1
12.8
4.2
-3.6
11984
533
1000
150000
16000
220000
3627
3249
3164
800000
50000
65000
300
25
3985
2.9
1.4
2.1
-0.6
2.4
9.3
3
16.5
1
917
4518226
119
4449
474395
7094
134
1142
80000
8500000
2000
60000
2110000
90000
15000
750000
700
1.2
1
0.2
4.8
3.4
593850
726
15124
2288000
180000
1500000
2
4.2
5.1
3.8
5.5
7129
389
9243
65868
38440
120000
75000
120000
2850000
3500000
3.4
2.1
6.5
3
804915
346078
9.6
11.5
7
3.2
1.7
3
2.1
-0.4
4
3.3
14
0.8
0.8
8.8
5
50807
560874
1495
51
41
8970000
3600000
600000
126000
150000
4000000
6000000
25000
500
10000
13000
4
8225
1763
1069
15931
672
20207
264
7000
4000
14300
15000
1500000
225000
847000
11700
221
1
1.7
7.5
3.3
10
4.5
277
484825
89592
45491
398
4
288633
8000
2310000
1375800
750000
2200
89000
3100000
3.2
1056950
9789000
5.8
9
23
1882
18
200000
300000
20000
5.4
0.7
0.9
2.1
1.7
8
5.4
2.8
1
1401
945221
667275
11
2777085
69
5534
103700
82
27000
5125000
2556000
220000
13800000
4100
250000
6971500
210000
10.3
3.3
18906
8003
2900
138000
4.1
9.3
9
4
5
3.5
12
3.2
1.4
2.5
7.6
3
3.1
22.4
9.5
2.2
281
355215
524
630000
5500000
8000
2692
94345
56283
3398708
115311958
87630
1040
512
35301
340
1300
125000
3800000
1110200
25000000
159000000
400000
492000
7500
1274400
3500000
30000
900
145000
2.2
12.2
18.3
133
138
1880
4501
100000
68200
500000
Investment (gross fixed)(% of GDP)
double
18.4
26.2
Labor force Life expectancy at birth(years)
double
double
11800000
42.9
1090000
9910000
14000
33000
5410000
6049
77.24
73
75.84
83.51
36.61
77.11
30000
15040000
1400000
41500
71.9
75.91
71.55
79.14
10350000
3450000
5090000
156000
370000
80.39
78.92
63.35
65.54
74.23
23.5
65490000
128500
62.08
71.41
21.8
19.1
33.6
19.3
4305000
4750000
90000
25.5
3800000
1026000
264000
68.72
78.62
67.49
50.51
77.79
54.39
65.5
72.85
33.87
19.8
89000000
71.69
18.6
29.1
10.2
10.7
12770
158000
3398000
5000000
27010000
2990000
76.27
74.8
72.03
43.92
56.22
43.5
34.5
18.3
19.8
25.3
22.6
65.1
12.8
37470
10.4
20.9
16.1
19.4
19.2
7000000
6680000
17370000
19820
24.7
23.9
6200000
46 760800000
15.8
20700000
144500
14510000
25.8
19.2
11.3
28.6
11.2
17.9
29
19.8
8000
1810000
6700000
1710000
4550000
95025
5250000
2870000
282000
25000
18.9
20.6
15.8
16.6
50.8
26.3
28.2
17.8
4530000
20710000
2750000
660000
19.5 215000000
1100
24250
137000
18.3
2660000
19.2 27700000
58.87
47.84
80.1
70.45
79.95
41.01
47.94
76.58
72.27
71.72
61.96
49.35
48.97
76.84
48.62
74.45
77.23
77.65
76.02
77.62
43.1
74.65
67.26
65.9
76.21
71
71.22
55.56
52.16
71.77
48.83
78.2
79.21
69.53
78.35
79.6
58800
70000
77.09
75.9
650000
400000
725000
2100000
42630000
10240000
14800
55.75
55.2
71.79
75.88
78.65
56
79.67
4400000
24500
42300
125900
60000
3680000
32290
3000000
480000
418000
3600000
79.09
69.65
64.53
77.9
78.4
65.14
80.3
49.86
46.97
65.5
52.92
2470000
3540000
65.6
81.39
22.8
4170000
23.8
158100
23.8 482200000
16.6 111500000
31.3 23000000
6700000
23.8
1920000
17.6
2680000
19.3 24270000
32
1140000
72.4
80.19
64.35
69.57
69.96
68.7
77.56
79.32
79.68
76.29
21.8
25.3
18.5
17.6
19.7
27
14.9
21
34.5
24.1
22.7
24
11.6
66970000
81.15
52790
79.24
1410000
78.24
23.9
14.7
28.7
8
17
26.1
26
39.6
9.9
21.9
19.8
17.5
14.7
10.7
21.7
26.4
22.5
19.4
17.1
22.4
47
19.6
7950000
11400000
66.55
47.99
7870
9600000
22900000
1420000
2700000
2600000
1170000
2600000
838000
61.71
71.37
75.82
77.03
68.16
55.08
71.05
72.63
36.68
47.69
76.5
79.55
73.97
78.74
82.03
73.73
56.95
36.97
72.24
64.06
45.09
78.86
78.34
70.01
79.04
52.73
72.38
61.39
75.19
69.75
1590000
29000
1630000
293700
231500
855000
7300000
4500000
10490000
88000
3930000
160000
39690
28700
165900
786000
560000
48800
34730000
1360000
30540
1488000
4521
11020000
9200000
840000
65.18
79.57
64.52
78.71
70.66
40.32
43.93
62.73
19.9
22.4
28
18
17.5
13.5
16.4
25
13.6
18.1
17.8
17
18.4
22.3
22.9
23.3
19.1
20
31.5
17.2
20.1
14.4
39.5
10000000
7530000
89000
79400
2050000
1930000
70000
55670000
59.8
78.81
75.83
74.04
78.66
70.33
42.13
46.74
1345
6006
2380000
920000
45430000
9845
75.88
79.4
73.13
63
70.14
1320000
3320000
2660000
11000000
35860000
15
17020000
5480000
1300000
140000
309900
9660000
71830000
4600000
3500
18170
43800
3261
67000
90000
18500
6620000
4650000
3200000
30900
71.94
64.93
74.89
69.53
69.91
74.41
77.53
77.62
73.67
73.95
71.35
67.1
46.96
77.76
72.15
73.61
78.46
73.62
70.72
81.62
66.99
75.46
56.75
74.73
71.82
16.7
1369000
2180000
2200000
870000
26840
3700000
16630000
42.52
81.62
74.5
76.14
72.66
48.09
43.27
25.4
19330000
79.52
22.4
16
7260000
11000000
104000
73.17
58.54
68.96
23.6
15.8
20.4
16.3
18
22
16.2
22.5
19.1
383200
4460000
3770000
5120000
10220000
3187000
19000000
36430000
1740000
35.65
80.4
80.39
70.03
77.26
64.56
45.24
71.57
52.64
19.4
33910
590000
69.53
68.91
3550000
25300000
2320000
4848
7000
12410000
21110000
2360000
29780000
147400000
1560000
14640000
74.89
72.36
61.39
74.51
68.01
51.59
66.85
75.24
78.38
77.71
76.13
64.19
62.49
74.31
70.61
78.91
27.4
24
24.9
24.5
17.3
29
22.4
18.8
20.8
16.2
15.7
9.6
12.9
36.6
12250000
42980000
48900
16.1
41.4
9.9
364000
12000
5980000
4630000
4230000
73.08
61.75
39.7
36.67
Military expenditures - dollar figure Military expenditures - percent of GDP(%)
double
double
188400000
2.6
56500000
2480000000
1.49
3.2
183580000
10.6
4300000000
135000000
1.3
6.5
1665000000
1497000000
121000000
2.7
0.9
2.6
628900000
6.3
995300000
1.8
176100000
3999000000
18000000
96500000
4030000
13700000
132200000
234300000
338500000
1.4
1.3
2
2.4
0.11
1.8
1.6
4.5
3.9
11000000000
1.8
290700000
356000000
64200000
39000000
38700000
5.1
2.6
1.3
2.1
6
112000000
221100000
9801700000
14100000
3
1.6
1.1
1.5
15500000
101300000
3420000000
67490000000
1
2.1
3.8
4.3
3300000000
11600000
93500000
126500000
3.4
3
1.5
2.8
64200000
180200000
620000000
572300000
384000000
2170000000
3271600000
0.4
1.2
2.39
1.8
3.8
2.02
1.5
28600000
4.4
180000000
4400000
655000000
2440000000
157000000
126200000
151000000
155000000
337100000
1.1
2.2
3.4
1.1
2.5
13.4
2
4.6
36000000
1800000000
45238100000
2.2
2
2.6
184800000
1000000
2
0.3
23000000
35063000000
49200000
0.59
1.5
0.6
5890000000
4.3
201900000
0.8
56700000
8900000
6500000
26000000
1.7
3.1
0.9
0.9
100600000
1.4
1080000000
1.75
16970000000
1300000000
4300000000
1300000000
700000000
9110000000
28182800000
31200000
2.5
3
3.3
45841000000
1
1460000000
14.6
0.9
8.7
1.8
0.4
221800000
177100000
0.9
1.3
5217400000
16180000000
2584500000
19200000
10700000
87000000
540600000
32300000
1500000
1300000000
2.8
5.3
1.4
0.5
1.2
3.1
2.3
0.2
3.9
230800000
231600000
1.9
0.9
200000000
44600000
11100000
1690000000
41100000
22400000
31100000
6
1.2
0.7
2.03
5.5
0.4
0.7
20800000
12500000
1.7
0.2
6043000000
0.9
8700000
0.4
23100000
2.2
2305600000
117300000
168400000
5
2.2
3.1
99200000
9408000000
1.5
1.6
1147000000
32800000
33300000
544600000
1
0.7
1.1
0.8
4033500000
252990000
3848000000
1.9
11.4
4.9
147000000
16900000
53100000
829300000
805500000
1.1
1.4
0.9
1.4
1
3500000000
3497800000
1.71
2.3
723000000
10
985000000
2.47
50100000
3.2
700000
700000
18000000000
107300000
654000000
12300000
0.8
10
1.5
1.8
13200000
4470000000
406000000
370000000
1.7
4.9
1.89
1.7
18900000
3172000000
0.9
1.5
9906500000
1.2
514800000
587000000
7500000
2.6
3
0.7
40500000
5729000000
2548000000
858000000
7574000000
35400000
20600000
1775000000
35500000
1.4
1.7
1
5.9
2.6
3.9
0.2
1.8
1.9
66700000
0.6
356000000
12155000000
90000000
1.5
5.3
3.4
170300000
617900000
1600000000
42836500000
3.707E+11
257500000
200000000
2.2
1.4
3.1
2.4
3.3
2
2
1687000000
650000000
1.5
2.5
885500000
106800000
217000000
7.8
1.8
4.3
Natural gas - consumption(cu m) Natural gas - exports(cu m) Natural gas - imports(cu m)
double
double
double
220000000
0
0
30000000
22320000000
0
57980000000
0
0
530000000
0
0
31100000000
1400000000
6050000000
0
0
1400000000
23330000000
7810000000
6720000000
9744000000
403000000
0
0
6033000000
1000000000
32700000000
0
0
9900000000
29170000
0
0
0
0
18800000000
15500000000
0
0
18500000000
15400000000
1150000000
300000000
2900000000
0
0
300000000
9590000000
0
3640000000
1350000000
5804000000
9000000000
0
0
5800000000
1569000000
8424000000
0
0
55800000000
0
91520000000
0
8730000000
6517000000
29180000000
0
0
5337000000
0
5700000000
0
0
0
0
0
1350000000
2840000000
600000000
0
0
0
0
1080000000
0
9892000000
5280000000
1000000
3100000000
9521000000
0
160000000
21200000000
0
0
0
0
20000000
0
0
1270000000
0
1270000000
4.677E+11
78100000000
2.978E+11
4557000000
42010000000
0
1725000000
4567000000
40260000000
80000000
0
0
1160000000
99550000000
0
7731000000
1100000000
85020000000
2021000000
0
2018000000
680900000
0
680900000
13370000000
4000000
9587000000
22750000000
55300000000
72400000000
2350000000
4199000000
10000000
71180000000
0
39700000000
3400000000
0
0
0
61000000
0
0
4920000000
0
3384000000
0
54780000000
80420000000
0
77730000000
290000000
0
0
14300000000
11010000000
8696000000
20920000000
8700000000
2016000000
0
0
0
21110000000
0
2000000000
1700000000
0
1700000000
5410000000
770000000
0
2760000000
865000000
0
0
2760000000
867000000
31250000000
22410000000
0
55100000000
0
7850000000
2050000000
0
2050000000
50000000
60000000
0
0
0
0
49720000000
49280000000
20780000000
6504000000
0
0
7850000000
7830000000
0
4100000000
6340000000
23400000000
50500000000
7430000000
0
0
0
0
110000000
0
0
910000000
25000000
0
0
0
0
13850000000
2542000000
630000000
15860000000
41000000
0
0
18200000000
8782000000
2553000000
630000000
0
18500000000
4.058E+11
0
1.71E+11
5400000000
32700000000
56400000000
50000000
602000000
0
0
0
0
0
0
2500000000
6800000000
1040000000
0
0
0
2500000000
6600000000
1040000000
1800000000
0
0
17960000000
0
17260000000
949000000
3093000000
5840000000
6640000000
1300000000
0
0
0
410000000
0
968000000
3093000000
0
6300000000
1250000000
23930000000
0
5200000000
13760000000
11790000000
0
3830000000
15940000000
9600000000
0
0
43500000000
1580000000
15750000000
0
79860000000
33700000000
92850000000
6.409E+11
64500000
45200000000
5800000000
7190000000
15750000000
11160000000
0
17900000000
60400000000
0
2700000000
1.141E+11
65000000
0
29400000000
1300000000
0
0
0
0
0
0
0
Natural gas - production(cu m) Natural gas - proved reserves(cu m) Oil - consumption(bbl/day)
double
double
double
220000000
49980000000
3500
30000000
80300000000
3316000000
4.739E+12
7500
209000
3800
530000000
79570000000
31000
3600
486000
5700
6500
37150000000
0
7.68E+11
33080000000
1731000000
5720000000
2.407E+12
24900000000
62300000000
32700000000
46000000000
796500
262400
140000
23000
40000
9900000000
29170000
1.503E+11
70790000
71000
10900
250000000
0
608800000
8440000000
0
7.272E+11
5950000000
2.217E+11
10350000000
4000000
3.15E+11
3724000000
9980000000
2.46E+12
285000
595100
5000
11500
4000
1020
49000
20000
16000
2199000
420
13000
94000
8000
60950
2750
0
1.658E+11
55220000000
1.691E+12
1180000000
35000000000
99050000000
2.23E+12
5700000000
1.32E+11
0
1.048E+11
495500000
1350000000
1760000000
600000000
14870000000
34360000000
42620000000
160000000
8380000000
3057000000
81980000000
7200
22000
2200000
2000
2400
2400
1500
240000
4956000
252000
700
14000
5000
450
37000
32000
89000
163000
49000
175700
218000
11300
600
129000
160000000
21200000000
1.065E+11
1.264E+12
20000000
68530000000
0
12460000000
2.426E+11
3.256E+12
0
1898000000
12860000000
129000
562000
39000
2000
6000
24000
23000
14540000
200
4500
5700
211400
2026000
6500
4750
80000000
60000000
21000000000
35000000
66470000000
2.93E+11
11890000000
254900000
1543000000
13000
1900
31500
2891000
38000
42000
405700
3700
1000
13000
20000
61000
8600
2500
11000
11000
29000
257000
3231000000
50450000000
140700
16300
2130000
1183000
1400000
383000
174400
260000
1866000
66000
22750000000
77600000000
79000000000
2350000000
815000000
10000000
15490000000
5.424E+11
2.549E+12
2.67E+13
3.149E+12
9911000000
20810000000
2.097E+11
2519000000
20020000000
5290000
290000000
3256000000
103000
11600000000
0
8700000000
16000000
1.8E+12
1.548E+12
0
6180000000
1.321E+12
0
0
0
53660000000
2.23E+12
189400
57000
190
85000
2070000
293000
20000
2750
44000
107000
1500
3100
216000
72000
50650
11190
22000
13000
5400
460000
3200
4000
20000
13500
24000
21000
47300000000
4.2E+11
1752000
0
24000
50000000
60000000
11000
400
167000
8500
13000
1000
665400000
63710000000
31150000000
77750000000
1.693E+12
6504000000
58940000000
15680000000
4.007E+12
54600000000
13770000000
23400000000
1.716E+12
8.297E+11
6.956E+11
110000000
3.855E+11
910000000
2500000
2.451E+11
1.076E+11
5471000000
0
0
32400000000
1.544E+11
12600000000
5.786E+11
1.111E+11
4.7E+13
28320000000
56400000000
50000000
602000000
1.441E+13
6.339E+12
24070000000
16000
895300
72000
8750
132700
25770
5000
275000
20
171100
54000
365000
40520
15000
25000
161000
338000
424100
339800
190000
30000
18000
253800
2310000
5300
200
710
2400
600
1250
1000
700
1550000
31000
64000
4000
1800000000
2832000000
14160000000
6500
700000
82000
53300
1250
4000
460000
516000000
254900000
1497000
99110000000
0
75000
70000
14000
0
190000000
0
0
0
5840000000
750000000
50000000
18730000000
7504000000
2.407E+11
38230000000
11330000000
3.682E+11
25000000000
5.89E+11
2250000000
312000000
58570000000
77160000000
8685000000
1.43E+12
19600000000
44400000000
1.059E+11
5.481E+11
0
63100000000
5.607E+11
6.06E+12
7.149E+11
5.195E+12
29400000000
1300000000
4.19E+12
1.926E+11
9.373E+11
3500
328600
290400
240000
988000
20000
17000
785000
10000
1000
24000
87000
619500
63000
0
8750
303000
310000
1692000
19650000
41500
142000
600
500000
185000
66000
0
4.8E+11
1800
78000
11000
23000
Oil - exports(bbl/day) Oil - imports(bbl/day) Oil - production(bbl/day) Oil - proved reserves(bbl)
double
double
double
double
0
0
0
5500
2000
1200000
0
185500000
11870000000
980000
22880000000
0
755000
0
0
523400
35470
530800
262000
29000
14500
450000
360000
1042000
537500
20670
312800
0
44000
3664000000
85690000
589000000
3581
1271
28450000
1254000
36000
0
0
700
0
0
39000
0
0
1788000
199000
3356
49230
2900000000
0
204000
603
0
17550
0
126000000
4105000
458800000
13900000000
1255000000
8100000
3200000000
1370000
987000
0
427800
221500
2414000
0
94000
3110000
0
0
0
200000
18500
3392000
192300
195000
531100
0
24000
227000
0
0
29300
21000
77900
300
7419
346200
129900
0
0
0
26670
332100
387000
5322000
15690000
101000
409600
318300
2281000
80000000
1.789E+11
150000000
17740000000
1700000000
1538000000
93500000
220000000
93600000
532000000
17250000
1230000000
523000
740000
0
350000
0
5100
0
4408000000
2700000000
2648000
0
0
0
0
34920
28210000000
563500000
214000
144300000
0
0
264900
0
12990
2135000
84720
468300
3104
2000
74100
7000
0
5992
0
0
0
0
25000
2022000000
395800000
8255000
4500000
263000000
0
0
0
0
0
0
47180
0
136600
15470
41190
0
780000
971000
3962000
2250000
0
80
79460
0
110700000
5700000000
4900000000
1.308E+11
1.125E+11
0
1920000
586600000
518100
2500000
1490000
27450
370500
456600
2158000
93360
5449000
17330
29290000
0
100000
40
445000
178600
890000
630100
1970000
634
47000
11500
2263000
50700
230200
1200000
0
0
0
0
2319000
2000
0
0
0
0
0
1518000
4594
0
0
0
0
0
785000
0
0
0
26000000000
96500000000
38000000000
0
3200000000
0
0
0
1863000
205000
3460000
18000000000
0
497
11000
542
0
1000
0
0
0
300000000
0
0
1418000
2284000
30220
738
119700
27950
3466000
721000
88870
49000
0
312000
53000
28830
413700
357300
6110000
7920000
0
0
46200
0
0
42160
0
0
2356000
0
3310000
775000
61000
0
46200
0
95500
26000
17180
0
0
790000
0
128000
8420000
0
0
0
0
0
0
0
0
9021000
0
15000
0
88060000
89620000
34000000000
9859000000
5500000000
325500000
170000000
408800000
152000000
116400000
16000000000
1055000000
69000000000
0
2.617E+11
38750000
0
0
1000
20
0
0
196200
135100
275000
1370
203700
10420
285000
2500000
1498000
2100000
0
7840000
1582000
7099
10500000
0
1644
0
345000
12000
1600000000
99000000
553100
289500
0
0
0
525000
500
250
0
225000
0
0
140000
46110
4500000
616500
0
1084000
72580
48000
162500
0
0
72000
2335000
1957000
7800000
0
143300
0
2600000
359400
0
2500000000
2900000
0
600000000
990000000
1700000000
288400000
273000000
395000000
97800000000
25410000000
22450000000
297000000
78000000000
650000000
370300
0
417500
0
0
4000000000
Population Public debt(% of GDP) Railways(km) Reserves of foreign exchange & gold
double
double
double
double
29928987
3563112
32531853
57881
70549
11190786
13254
447
3973
1206000000
43550000000
2761
800000000
118
34091
845
19470000000
555000000
20090437
8184691
7911974
301790
688345
17.4
64.2
18.9
43802
6021
2957
35140000000
12730000000
875000000
144319628
279254
43
2706
3000000000
96.2
5523
3518
578
770200000
14450000000
111100000
839300000
8.6
3519
1021
888
1214000000
2000000000
5700000000
52
29412
52940000000
41.9
4294
622
3955
7526000000
474900000
590000000
76890000
68722
39537943
2982904
71566
10300483
10364388
279457
7460025
65365
2232291
8857870
4025476
1640115
186112794
22643
372361
7450349
13925313
42909464
6370609
37.4
63.8
2141000000
13607069
16380005
32805041
418224
44270
3799897
9826419
15980912
1306313812
361
628
42954279
671247
60085804
3039126
21388
4016173
17298040
4495904
11346670
780133
10241138
5432335
476703
69029
8950034
1040880
13363593
77505756
6704932
535881
4561599
1332893
73053286
457030418
2967
46962
893354
5223442
60656178
69.1
602
1008
48909
997500000
687500000
36270000000
112700000
12.8
31.4
6585
70058
652700000
16020000000
6.099E+11
51.8
3304
11940000000
5138
894
40420000
58
74.8
41.7
74.9
33.5
42.5
950
660
2726
4226
9520
3002
1736000000
1950000000
8563000000
738600000
941600000
32780000000
37980000000
100
61.1
1743
426000000
49.2
102.7
41.7
966
5063
283
5.4
306
958
681
1436000000
14030000000
1888000000
235200000
30870000
1503000000
923100000
222293
46.8
67.7
597
5851
32175
11170000000
70760000000
195506
270485
1389201
1593256
1376289
4677401
82431390
21029853
27884
29.3
814
268600000
113100000
65.8
1612
46039
953
231400000
96840000000
1267000000
10668354
56375
89502
448713
168564
14655189
65228
9467866
1416027
765283
8121622
112
2571
7300000000
32
886
3084000000
837
201700000
187
280600000
80640000
74.1
2.1
699
1464000000
1.236E+11
58.3
35.9
59.7
56.2
27
7937
14800000000
935000000
1.26E+11
35820000000
29870000000
921
6975204
6898686
10006835
296737
1080264388
241973879
68017860
26074906
4015676
6276883
58103033
2731832
31.2
104.5
105.6
146.1
63140
6458
7203
1963
3312
640
19507
272
127417244
164.3
23705
6.646E+11
90812
361
5759732
85.8
505
5457000000
4152000000
28480000000
61500000000
1400000000
15185844
33829590
103092
22912177
48422644
2335648
5146281
6217141
2290237
3826018
1867035
3482211
5765563
33717
3596617
468571
449198
2045262
18040341
12158924
23953136
349106
12291529
398534
75049
59071
432900
3086859
1230602
193633
106202903
108105
4455421
32409
2791272
9341
32725847
19406703
2030692
13048
13.7
74.3
21.3
29.6
13601
2778
5214
3125
470
11.8
177.9
2303
401
14350000000
1500000000
1.991E+11
7333000000
498700000
193100000
1650000000
16300000000
402200000
490
8.8
24180000000
25.2
1998
274
4610000000
20
699
732
797
2418
928000000
500300000
160500000
55270000000
228.3
45.4
729
2865000000
61
29.2
1676000000
23.5
19510
60670000000
63.4
1138
390000000
70.2
1907
3123
2382
15140000000
1206000000
360000000
38.5
27676547
16407491
219958
216494
4035461
5465100
11665937
128771988
2166
1828
80362
4593041
3001583
162419946
20303
3039150
5545268
6347884
27925628
87857473
46
38635144
10566212
3916632
863051
776948
22329977
143420309
8440820
7460
38958
166312
7012
117534
177287
28880
187410
26417599
11126832
10829175
81188
55.8
59
2808
21440000000
22.1
69.5
3898
6
4805000000
670000000
20
3557
14710000000
33.1
10.3
71.4
4077
69.2
59.3
39.2
44.1
74.2
355
49.9
61.5
8163
441
3462
897
23852
2850
96
4144000000
12580000000
1076000000
635800000
1164000000
12700000000
16050000000
41880000000
12300000000
3351000000
23.6
28.2
11385
87157
16210000000
1.245E+11
210900000
50
75
55.2
80
122.8
1392
906
4380
29780000
23620000000
820000000
3550000000
70940000
6017643
4425720
5431363
2011070
538032
8591629
44344136
102.5
46.6
31.5
3661
1201
1.128E+11
14910000000
8493000000
45.9
22298
11680000000
40341462
53.2
14268
19700000000
20064776
40187486
438144
2701
1173900
9001774
7489370
18448752
22894384
7163506
36766356
65444371
5681519
1405
112422
1088644
104.3
79.7
1449
5995
2475000000
1652000000
301
11481
4533
2711
2508
482
3690
4071
568
320500000
19990000000
69580000000
5000000000
2.465E+11
145300000
2175000000
48300000000
267400000
10074951
69660559
4952081
20556
11636
27269482
47425336
2563212
60441457
295734134
3415920
26851195
205754
25375281
83535576
108708
59.2
74.3
2152
8671
2440
3509000000
37100000000
3034000000
73.9
24.7
17.6
39.6
65
1241
22473
41.5
17186
228464
2073
3950
1200000000
11330000000
18640000000
48730000000
85940000000
2362000000
1603000000
43.1
65.9
682
2600
25750000000
6510000000
51.6
57.2
32
32.4
5
47.6
54.4
2927000000
16025
2385615
273008
20727063
11261795
12746990
46.4
127.5
52.3
2173
3077
5300000000
345000000
57000000
Telephones - main lines in use Telephones - mobile cellular
double
double
33100
15000
255000
2199600
15000
35000
96300
6200
0
38000
8009400
562600
37100
1100000
1447310
2377
23500
130000
1800
10815000
3881000
923800
131700
185800
14347000
7094500
870000
121800
443100
740000
134000
1365000
140000
3071300
5120400
33300
66500
56000
25200
600100
938000
142400
1118000
8135500
60400
236200
37873
22000
1401500
1050000
435000
38810000
46373300
11700
90000
2868200
65400
357300
23900
8000
137000
2597500
227000
66500
64000
38200
6500000
114400
53000
35400
110900
19950900
71700
38000
9000
11800
3467000
263000000
380000
1077000
13221800
53300
17000
13000
65000
6445700
269000000
287
8768100
13200
10000
7000
6200
1132000
328000
1825000
574400
86228
3626000
3610100
6186200
2000
1000000
330000
1500
528047
1236000
2553000
17900
143178
9708700
4785300
9500
23700
901800
23000
9400
2120400
1549000
8735700
752600
9600
38100
475000
435000
2394400
5797500
1149800
41500
238763162
2400
23000
102000
2548000
33905400
314644700
0
30700
109900
4700000
41683100
881000
97800
51000
52500
138200
90000
38400
38400
95729
650500
54350000
302300
24512
300000
100000
320000
522300
64800000
799900
9797
5205100
26000
33500
210000
84134
846000
55000
26200
10600
80400
130000
8936200
16747
7600
323500
32600
1577100
31500
111500
1300
87300
140000
322500
3801300
326500
7241400
3666400
190700
48917000
7750000
14571100
675000
1955000
3006000
26596000
444400
6862800
279100
26154400
11700000
3376500
20000
3400000
6334000
55918000
1400000
71149000
86658600
73900
61400
622600
1325300
2081900
328400
1027000
1590800
4500
1100000
22877000
486900
394800
61900
653900
678800
28600
7000
750000
19900
824200
355400
174600
560000
59600
85000
4571600
28700
56600
208300
51000
4500
172000
31500
348200
10000
15958700
10100
500
706900
33700
142300
1219200
83700
127400
1900
33591800
1420000
53100
55200
1219600
775100
92000
2000
100000
11400
2169900
473000
364000
365300
279500
135100
11124100
41900
250000
290000
600
319900
300000
462400
21700
28125000
1800
338200
19300
404400
70
7332800
428900
223700
1500
371800
10004000
81000
52000
1765000
171600
22400
853100
1100
2532
21000
3343000
233900
3982800
6700
50400
12500000
81000
80000
2599000
202800
24000
3149500
400
0
3000
4163400
464900
2624800
1000
386900
62000
273200
1839200
3310900
1
12300000
4278800
1329500
184500
300000
4300000
35500000
23200
2200
23500
51100
4800
27300
11800
20600
7000
3502600
228800
2611700
21700
834000
15000
1770300
2908800
15201000
17401000
9341400
1211111
376500
489800
6900000
17608800
134000
0
5000
14300
0
10000
2700
16800
4800
7238200
575900
3634600
54500
24000
1896100
1294700
812300
6600
100000
4844000
67000
3521800
3678800
1739100
1000
35000
16860000
17567500
37506700
881400
900000
79800
931600
650000
168100
46200
6579200
5419000
2099300
13355000
242100
149100
6617400
60600
300
11200
325100
88000
7949000
6172000
400000
25089600
47600
891200
26500000
220000
0
9000
361900
1163800
18916700
374000
5700
700
61000
10833300
1135800
34898000
181599900
946500
1717100
6500
2841800
4402000
69400
1899900
27887500
52000
1700
0
776200
4200000
2972300
49677000
158722000
652000
320800
7800
6463600
2742000
41000
1900
301600
542200
88400
300900
0
480000
0
411100
241000
379100
Total fertility rate(children born/woman) Unemployment rate(%)
double
double
6.75
2.04
1.92
3.25
1.29
6.27
1.73
14.8
25.4
6
0
2.26
2.19
1.32
1.79
11
14.8
30
0.6
1.76
1.36
2.44
2.2
2.63
5.1
4.4
1.2
10.2
15
3.13
1.65
40
10.7
1.39
1.64
3.68
5.86
1.89
4.81
2.94
1.71
2.85
2
12
12.9
1.93
11.5
1.72
2.3
1.38
6.23
2.01
5.81
3
3.2
12.7
8
5
9.2
44
23.8
5.2
3.44
4.47
1.61
3.48
1.9
4.5
6.32
2.02
1.72
2.56
5.09
6.54
3.54
2.28
4.58
1.39
1.66
1.83
1.2
1.74
2.5
30
7
21
4.1
8
8.5
9.8
60
13.6
20
13
6.6
13
13.8
2.5
3.2
10.6
6.2
5.4
1.96
2.86
3.61
2.72
2.88
3.16
4.62
5.61
1.39
5.33
50
23
17
50
11.1
10.9
6.3
30
1.48
9.5
2.2
2.75
1.73
1.85
1
7.6
8.9
10.1
9.6
3.01
2.04
22
11.8
4.77
5.38
5.91
1.41
1.39
3.02
1.65
21
50
17
10.6
20
2
1.33
2.41
2.37
1.91
2.6
4.53
1.38
5.83
4.93
2.05
5.02
10
10
12.5
27.8
15
7.5
0.5
3.87
0.91
28.5
6.7
1.32
1.92
2.78
2.44
1.82
4.28
1.87
2.44
1.28
1.95
5.9
3.1
9.2
9.2
11.2
25
4.3
10.7
8.6
15
1.39
4.7
1.57
0.9
2.71
15
1.89
4.96
8
40
4.2
2.15
1.26
2.97
2.7
4.77
1.26
1.92
3.35
6.09
3.34
1.51
1.19
1.79
0.93
1.57
5.66
5.98
3.07
5.02
6.5
1.5
1.65
3.93
1.79
5.94
1.96
5.89
2.45
3.25
2
1.81
1.76
2.26
1.78
2.73
4.7
3.18
3.19
3.6
2.2
18
5.7
8.8
18
45
85
30
1.3
8
4.5
4.7
37.7
3
5.3
7
0.6
30.9
27.2
20
10.8
38
3.2
16
8
22
6.7
6
12.1
21
35
90
4.19
1.66
2
2.31
1.79
2.81
6.75
5.53
47
6
15.6
19
4.2
7.8
0
1.27
1.78
5.84
4.14
2.46
4.3
15
8.3
2.3
2.45
3.96
3.93
2.56
3.16
12.6
1.39
1.47
1.91
2.87
2.47
1.36
1.27
5.49
1.54
2.33
2.21
2.03
1.85
3.01
1.33
5.71
4.05
4.75
1.67
1.75
19.5
6.5
12
2.7
36
6.3
8.3
15.1
9.6
11.7
14
4.5
20
9.8
15
2.6
25
48
30
5.72
1.05
1.32
1.24
4.04
6.84
2.24
3.4
13.1
6.4
26.2
1.28
10.4
1.85
4.85
2.34
7.8
18.7
17
3.7
1.66
1.42
3.5
1.57
4.05
5.06
1.88
4.61
34
5.6
3.4
20
4.5
40
3
1.75
13.3
10.4
1.75
1.94
3.41
3.08
3
6.74
1.4
2.94
1.66
2.08
1.91
2.94
2.77
2.26
1.94
2.19
13.8
9.3
60
10
1.5
3.5
2.4
4.8
5.5
13
0.6
17.1
1.9
9.3
4.4
27.2
6.67
5.47
3.54
35
50
70
Business Analytics
IS 335
Fall 2019
Dr. Anil K. Sahai
Business Analytics
IS 335
Fall 2019
Dr. Anil K. Sahai
Data Analytics Overview
• What is Data Analytics?
• Developing Actionable
Decisions/Recommendations
based on Insights Generated
from Historical Data!
• Combination of Computer
Technology, Management
Science and Statistics
Data Analytics: Collect, Analyze, Visualize and Act!
• Data: Collection of Facts
• Structured, Unstructured and Semi-Structured
• Preprocessing, Consolidation, Cleaning, Transformation & Reduction
Regression
Visual Analytics
Dashboard: Data Visualization
Explore and Communicate thru Charts, Graphs, Illustrations, etc.
Data Warehousing
• Integrated Subject-Oriented Database designed to support DSS
• Non-Volatile Data
Data Mining
• DM Extracts Patterns from Data
• Association, Prediction, Cluster and Sequential
• Prediction, Association and Segmentation
DM Taxonomy
Comparing CRISP and SEMMA
Classification: Confusion Matrix
• Part of Machine Learning Family
• Supervised Learning
Cluster Analysis
• Natural Groupings
• Unsupervised Learning
• No Output/Target Variable
• Also known as Segmentation in Marketing
Association Rule Mining: Market Basket Analysis
• Part of Machine Learning Family
• Unsupervised Learning
Text Analytics and Text Mining
• Text Mining
• Extracting Knowledge from Unstructured Data
• Text Analytics
• Information Retrieval and Text Mining
• Corpus
• Large structured set of text
• Concepts
• Features from collection of Documents
• Stemming
• Roots/Origins of Words
Text Mining Process
Sentiment Analysis
Internet Search Engine and Web Mining
Database Management System (DBMS)
•
•
•
•
•
Collection of interrelated data
Set of programs to access the data
DBMS contains information about a particular enterprise
DBMS provides an environment that is both convenient and efficient to use.
Database Applications:
•
•
•
•
•
•
Banking: all transactions
Airlines: reservations, schedules
Universities: registration, grades
Sales: customers, products, purchases
Manufacturing: production, inventory, orders, supply chain
Human resources: employee records, salaries, tax deductions
• Databases touch all aspects of our lives
12/5/19
18
SQL
• SQL: widely used non-procedural language
• E.g. find the name of the customer with customer-id 192-83-7465
select customer.customer-name
from customer
where customer.customer-id = ‘192-83-7465’
• E.g. find the balances of all accounts held by the customer with customer-id 192-837465
select account.balance
from depositor, account
where depositor.customer-id = ‘192-83-7465’ and
depositor.account-number = account.account-number
• Application programs generally access databases through one of
• Language extensions to allow embedded SQL
• Application program interface (e.g. ODBC/JDBC) which allow SQL queries to be sent to a
database
12/5/19
19
Comparing SQL and NoSQL
12/5/19
20
Instructions
• This exam is not designed to test how much you remember - but rather designed to see how much do you
understand; and more so, how well can you research and find answers to problems!
• This is an Open Book, Open Notes, Open Internet and Open Mind Take Home exam. But you cannot talk, call, message
or email to anyone regarding this exam after you have downloaded/looked at the exam. I trust all of you. You all are
awesome and you will not disappoint me in any ways!
• The exam has
2 Short essay/paragraph Questions (15 Points each]
1 Excel/Tableau Question [50 Points]
• 1 Question of your choice [20 Points]
o 1 Bonus Question (Optional] [20 Points]
o Total: 120 Points out of 100!
• Expected Time to Finish this Exam: 3 Hours
o Submit Question with your Answers in a pdf file! Only Canvas submissions will be accepted. No word document
submissions!
Helpful Hints
• No "cut" and "paste" from any source! Again, I repeat: No "cut" and "paste" from any source! Any "cut and pasted"
content will not receive any
• If you find a question ambiguous, please write you assumption, and answer the question. You will be given full credit
for your answers based on all and any reasonable assumptions that you made!
• Enjoy writing this exam!
• Good luck!
Short essay/paragraph Questions (15 Points each]
Question 1: [15 Points] [Guide: Total 2 Pages in Double Space]
• Explain the differences between SQL and NoSQL?
• Why NoSQL was introduced?
• What was your contribution in your term project? Would your team members agree with your own assessment?
Question 2:[15 Points] [Guide: Total 2 Pages in Double Space]
• What are the challenges of Text Mining?
• How do you create a corpus? (Hint: Research about WordNet]
• How can Dr. Sahai use Sentiment Analysis to improve the delivery of his lectures in IS 335?
• How do companies use Search Optimization Engine (SOE) to better/maximize their marketing and adverting
campaigns?
Excel Tableau Question
Question: [50 Points)
Please refer to IS 335 Fall 2019 Final Exam.xlsx
1
• Excel
O A: Sort the data based on GDPs
• Select bottom 10 Countries
Determine the correlation (and its measure R-square) of GDP of these countries with the corresponding
• Electricity Consumption
• HIV Deaths
• Fertility Rate
· Life Expectancy at Birth
· Plot the scatter graphs for the above with trend lines
o B: Sort the data based on number of Internet Users
• Select Middle 10 Countries
Determine the correlation (and its measure R-square) of Internet users in these countries with the
corresponding
• GDP
• Military Expenditure
• Life Expectancy
• Natural Gas Consumption
• Plot the scatter graphs for the above with trend lines
o Submit the 10 graphs with corresponding R-Square Values
Tableau
o Repeat the same exercise for Tableau
o Create a dashboard each for A and B with the graphs generated
o Submit the two dashboards
• Analyze and provide a summary of some interesting findings of your choice!
Note: You only need to submit images of graphs and dashboards in your pdf document. No need to submit Excel or Tableau files!
Question of your Choice
Question: [20 Points] [Guide: You choose, this is your question!
• From all the topics covered in class, pick a topic, frame a question and provide your answer!
• Grade your own answer out of 20 points and a letter grade!
Bonus Question
Question: [20 Points] [Guide: Total 2 Pages in Double Space]
You have graduated from UNLV and are very excited to practice what you have learned in your IS335 class. Lo and
behold, you run into Dr. Sahai at a bar. He shares with you his new startup - an on-line Market Exchange to
buy/sell/rent/barter home maintenance/repair tools/equipments/gadgets which people use sparingly; and majority of the
time they keep "rotting" in garage or a shed, e.g., chainsaw, toolsets, hammer, lawn mower, ladders, and likes. Dr. Sahai is
now a conga player, and has forgotten anything and everything about Data Analytics. The company is about to be
launched and he is concerned that in today's Al and Data Analytics intensive market, he may not be able to compete with
traditional marketing and business development techniques. Knowing that you took IS 335, he offers you to lead head
business analytics in the company. You agree to join for a 50% share in the company. He has asked you to develop a plan
of action for the next 6 months.
Suggest a name for this company - bring some humor here! :-)
• Use your learnings from the class, and outline a data analytics plan (bullet lists with 1-2 liner descriptions are fine!]
• What advantages around the following you can you bring for the company. Briefly explain how!
o Customer Acquisition and Retention
o Advertising
o Marketing
o Market Exchange Design
Purchase answer to see full
attachment