DATA ANALYTICS USING DEEP LEARNING
GT 8803 // FALL 2018 // JACOB LOGAS
L E C T U R E # 0 9 : DATA VO C A L I Z AT I O N : O P T I M I Z I N G VO I C E O U T P U T O F R E L AT I O N A L DATA
USING DEEP LEARNING GT 8803 // FALL 2018 // JACOB LOGAS L E C T U - - PowerPoint PPT Presentation
DATA ANALYTICS USING DEEP LEARNING GT 8803 // FALL 2018 // JACOB LOGAS L E C T U R E # 0 9 : DATA VO C A L I Z AT I O N : O P T I M I Z I N G VO I C E O U T P U T O F R E L AT I O N A L DATA TODAYS PAPER Data Vocalization:
L E C T U R E # 0 9 : DATA VO C A L I Z AT I O N : O P T I M I Z I N G VO I C E O U T P U T O F R E L AT I O N A L DATA
GT 8803 // Fall 2018
2
GT 8803 // Fall 2018
3
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Restaurants with Traditional American cuisine and four to five stars user average rating: Upstate. John’s. The View. Restaurants with three to four stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine. La Masseria with Italian cuisine.
GT 8803 // Fall 2018
4
GT 8803 // Fall 2018
5
GT 8803 // Fall 2018
6
This Photo by Unknown Author is licensed under CC BY-SA This Photo by Unknown Author is licensed under CC BY-SA-NC This Photo by Unknown Author is licensed under CC BY
GT 8803 // Fall 2018
6
This Photo by Unknown Author is licensed under CC BY-SA This Photo by Unknown Author is licensed under CC BY-SA-NC This Photo by Unknown Author is licensed under CC BY
GT 8803 // Fall 2018
6
This Photo by Unknown Author is licensed under CC BY-SA This Photo by Unknown Author is licensed under CC BY-SA-NC This Photo by Unknown Author is licensed under CC BY
GT 8803 // Fall 2018
6
This Photo by Unknown Author is licensed under CC BY-SA This Photo by Unknown Author is licensed under CC BY-SA-NC This Photo by Unknown Author is licensed under CC BY
GT 8803 // Fall 2018
7
GT 8803 // Fall 2018
8
This Photo by Unknown Author is licensed under CC BY-SA
GT 8803 // Fall 2018
9
GT 8803 // Fall 2018
10
Miller, G. A. (1956). The magical number seven, plus or minus two: some limits on our capacity for processing information. Psychological Review, 63(2), 81-97. http://dx.doi.org/10.1037/h0043158
GT 8803 // Fall 2018
11
GT 8803 // Fall 2018
12
GT 8803 // Fall 2018
13
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Upstate with Traditional American cuisine and four point seven five stars user average rating. Thai Castle with Thai cuisine and three point three stars user average rating. John’s with Traditional American cuisine and four point seven stars user average rating. Paris with French cuisine and three point three stars user average rating. The View with Traditional American cuisine and four point nine stars user average rating. La Masseria with Italian cuisine and three point two stars average rating.
This Photo by Unknown Author is licensed under CC BY-ND
GT 8803 // Fall 2018
13
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Upstate with Traditional American cuisine and four point seven five stars user average rating. Thai Castle with Thai cuisine and three point three stars user average rating. John’s with Traditional American cuisine and four point seven stars user average rating. Paris with French cuisine and three point three stars user average rating. The View with Traditional American cuisine and four point nine stars user average rating. La Masseria with Italian cuisine and three point two stars average rating.
502 Characters
This Photo by Unknown Author is licensed under CC BY-ND
GT 8803 // Fall 2018
13
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Upstate with Traditional American cuisine and four point seven five stars user average rating. Thai Castle with Thai cuisine and three point three stars user average rating. John’s with Traditional American cuisine and four point seven stars user average rating. Paris with French cuisine and three point three stars user average rating. The View with Traditional American cuisine and four point nine stars user average rating. La Masseria with Italian cuisine and three point two stars average rating.
502 Characters
This Photo by Unknown Author is licensed under CC BY-ND
GT 8803 // Fall 2018
13
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Upstate with Traditional American cuisine and four point seven five stars user average rating. Thai Castle with Thai cuisine and three point three stars user average rating. John’s with Traditional American cuisine and four point seven stars user average rating. Paris with French cuisine and three point three stars user average rating. The View with Traditional American cuisine and four point nine stars user average rating. La Masseria with Italian cuisine and three point two stars average rating.
502 Characters
This Photo by Unknown Author is licensed under CC BY-ND
GT 8803 // Fall 2018
13
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Upstate with Traditional American cuisine and four point seven five stars user average rating. Thai Castle with Thai cuisine and three point three stars user average rating. John’s with Traditional American cuisine and four point seven stars user average rating. Paris with French cuisine and three point three stars user average rating. The View with Traditional American cuisine and four point nine stars user average rating. La Masseria with Italian cuisine and three point two stars average rating.
502 Characters
This Photo by Unknown Author is licensed under CC BY-ND
GT 8803 // Fall 2018
14
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
La Masseria with Italian cuisine and three point two stars average rating. Restaurants with Traditional American cuisine: Upstate with four point seven five stars user average rating. John’s with four point seven stars user average rating. The View with four point nine stars user average rating. Restaurants with three point three stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine.
GT 8803 // Fall 2018
Contexts
14
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
La Masseria with Italian cuisine and three point two stars average rating. Restaurants with Traditional American cuisine: Upstate with four point seven five stars user average rating. John’s with four point seven stars user average rating. The View with four point nine stars user average rating. Restaurants with three point three stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine.
GT 8803 // Fall 2018
14
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
La Masseria with Italian cuisine and three point two stars average rating. Restaurants with Traditional American cuisine: Upstate with four point seven five stars user average rating. John’s with four point seven stars user average rating. The View with four point nine stars user average rating. Restaurants with three point three stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine.
Scopes
GT 8803 // Fall 2018
14
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
La Masseria with Italian cuisine and three point two stars average rating. Restaurants with Traditional American cuisine: Upstate with four point seven five stars user average rating. John’s with four point seven stars user average rating. The View with four point nine stars user average rating. Restaurants with three point three stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine.
502 → 416 Characters
GT 8803 // Fall 2018
14
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
La Masseria with Italian cuisine and three point two stars average rating. Restaurants with Traditional American cuisine: Upstate with four point seven five stars user average rating. John’s with four point seven stars user average rating. The View with four point nine stars user average rating. Restaurants with three point three stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine.
502 → 416 Characters
GT 8803 // Fall 2018
14
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
La Masseria with Italian cuisine and three point two stars average rating. Restaurants with Traditional American cuisine: Upstate with four point seven five stars user average rating. John’s with four point seven stars user average rating. The View with four point nine stars user average rating. Restaurants with three point three stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine.
502 → 416 Characters
GT 8803 // Fall 2018
15
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Restaurants with Traditional American cuisine and four to five stars user average rating: Upstate. John’s. The View. Restaurants with three to four stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine. La Masseria with Italian cuisine.
GT 8803 // Fall 2018
15
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Restaurants with Traditional American cuisine and four to five stars user average rating: Upstate. John’s. The View. Restaurants with three to four stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine. La Masseria with Italian cuisine. 416 → 267 Characters
GT 8803 // Fall 2018
15
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 John’s Traditional American 4.7 Paris French 3.3 The View Traditional American 4.9 La Masseria Italian 3.2
Restaurants with Traditional American cuisine and four to five stars user average rating: Upstate. John’s. The View. Restaurants with three to four stars user average rating: Thai Castle with Thai cuisine. Paris with French cuisine. La Masseria with Italian cuisine. 416 → 267 Characters
GT 8803 // Fall 2018
𝐷𝑝𝑜𝑢𝑓𝑦𝑢 𝑇𝑗𝑨𝑓 ≤ 𝑇 – Categorical value domain: 𝐸𝑝𝑛𝑏𝑗𝑜 𝑇𝑗𝑨𝑓 ≤ 𝐷 – Numerical value domains: 𝑉𝑞𝑞𝑓𝑠 𝐶𝑝𝑣𝑜𝑒 ≤ 𝑀𝑝𝑥𝑓𝑠 𝐶𝑝𝑣𝑜𝑒 ∗ 𝑋
16
Memory Precision Precision
GT 8803 // Fall 2018
𝐷𝑝𝑜𝑢𝑓𝑦𝑢 𝑇𝑗𝑨𝑓 ≤ 𝑇 – Categorical value domain: 𝐸𝑝𝑛𝑏𝑗𝑜 𝑇𝑗𝑨𝑓 ≤ 𝐷 – Numerical value domains: 𝑉𝑞𝑞𝑓𝑠 𝐶𝑝𝑣𝑜𝑒 ≤ 𝑀𝑝𝑥𝑓𝑠 𝐶𝑝𝑣𝑜𝑒 ∗ 𝑋
16
Memory Precision Precision NP Hard
GT 8803 // Fall 2018
17
Photo by Fschwarzentruber / CC BY
GT 8803 // Fall 2018
18
GT 8803 // Fall 2018
19
Image used with permission of Immanuel Trummer from VLDB 2017 slide deck (http://www.itrummer.org/slides/Vocalization5.pdf)
GT 8803 // Fall 2018
19
Image used with permission of Immanuel Trummer from VLDB 2017 slide deck (http://www.itrummer.org/slides/Vocalization5.pdf)
GT 8803 // Fall 2018
20 Input relation Precision constraints Memory constraints
GT 8803 // Fall 2018
20 Input relation Precision constraints Memory constraints Transformation to ILP
GT 8803 // Fall 2018
20 Input relation Precision constraints Memory constraints Transformation to ILP ILP Solver Integer Linear Program Variables Linear Constraints Linear Objective
GT 8803 // Fall 2018
20 Input relation Precision constraints Memory constraints Transformation to ILP ILP Solver Solution Integer Linear Program Variables Linear Constraints Linear Objective
GT 8803 // Fall 2018
20 Input relation Precision constraints Memory constraints Transformation to ILP ILP Solver Voice Output Solution Integer Linear Program Variables Linear Constraints Linear Objective
GT 8803 // Fall 2018
21
GT 8803 // Fall 2018
21
Variables
GT 8803 // Fall 2018
21
Variables
GT 8803 // Fall 2018
21
Variables
GT 8803 // Fall 2018
21
Variables
GT 8803 // Fall 2018
21
Variables
GT 8803 // Fall 2018
21
Constraints
GT 8803 // Fall 2018
21
1 1
Constraints
GT 8803 // Fall 2018
21
1 1
Constraints
Row [1…n]
GT 8803 // Fall 2018
21
1 1
Constraints
Row [1…n]
GT 8803 // Fall 2018
21
1 1
Constraints
Row [1…n] Bounded Bounded
GT 8803 // Fall 2018
21
1 1
Constraints
Row [1…n] Sufficiently Small Δ Sufficiently Small Δ Bounded Bounded
GT 8803 // Fall 2018
21
1 1
Constraints
Row [1…n] Sufficiently Small Δ Sufficiently Small Δ Bounded Bounded
Optimal Slow
GT 8803 // Fall 2018
22
Phase 1: Generate Context Candidates Phase 2: Map Rows to Candidates
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 Extract 4 to 5 stars Traditional American cuisine Traditional American cuisine and 4 to 5 stars Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 4 to 5 stars Traditional American cuisine Traditional American cuisine and 4 to 5 stars Mapping
GT 8803 // Fall 2018
22
Phase 1: Generate Context Candidates Phase 2: Map Rows to Candidates
Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 Extract 4 to 5 stars Traditional American cuisine Traditional American cuisine and 4 to 5 stars Restaurant Cuisine Rating Upstate Traditional American 4.75 Thai Castle Thai 3.3 4 to 5 stars Traditional American cuisine Traditional American cuisine and 4 to 5 stars Mapping
Fast No guarantee
GT 8803 // Fall 2018
23
Figure used with permission of Immanuel Trummer from Optimizing voice-based output
GT 8803 // Fall 2018
24
GT 8803 // Fall 2018
25
GT 8803 // Fall 2018
26 Find Optimal Voice Output Optimal Exponential
GT 8803 // Fall 2018
26 Find Optimal Context Set Find Optimal Voice Output Optimal Optimal Exponential Polynomial
GT 8803 // Fall 2018
Greedily Construct Context Set
26 Find Optimal Context Set Find Optimal Voice Output Optimal Optimal Exponential Polynomial ? Polynomial
GT 8803 // Fall 2018
Greedily Construct Context Set
26 Find Optimal Context Set Find Optimal Voice Output Optimal Optimal Exponential Polynomial ? Polynomial T({context}) Properties that hold:
GT 8803 // Fall 2018
Greedily Construct Context Set
26 Find Optimal Context Set Find Optimal Voice Output Optimal Optimal Exponential Polynomial Polynomial T({context}) Properties that hold:
Near-Optimal
GT 8803 // Fall 2018
Greedily Construct Context Set
26 Find Optimal Context Set Find Optimal Context Set Find Optimal Voice Output Optimal Polynomial Polynomial T({context}) Properties that hold:
Near-Optimal ? Polynomial
GT 8803 // Fall 2018
Greedily Construct Context Set
26 Find Optimal Context Set Find Optimal Context Set Find Optimal Voice Output Optimal Polynomial Polynomial T({context}) Properties that hold:
Near-Optimal ? T(assignments) Properties that hold:
Polynomial
GT 8803 // Fall 2018
Greedily Construct Context Set
26 Find Optimal Context Set Find Optimal Context Set Find Optimal Voice Output Optimal Polynomial Polynomial T({context}) Properties that hold:
Near-Optimal T(assignments) Properties that hold:
Polynomial Near-Optimal
GT 8803 // Fall 2018
Greedily Construct Context Set
26 Find Optimal Context Set Find Optimal Context Set Find Optimal Voice Output Optimal Polynomial Polynomial T({context}) Properties that hold:
Near-Optimal T(assignments) Properties that hold:
Polynomial Near-Optimal
Polynomial Optimal
GT 8803 // Fall 2018
27
GT 8803 // Fall 2018
28
GT 8803 // Fall 2018
29
GT 8803 // Fall 2018
30
GT 8803 // Fall 2018
31
Image used with permission of Immanuel Trummer from VLDB 2017 slide deck (http://www.itrummer.org/slides/Vocalization5.pdf)
GT 8803 // Fall 2018
32 Precision Complexity High Low Medium Low Low Low High Medium Medium Medium Low Medium
Normalized Length # Rows
GT 8803 // Fall 2018
33 Precision Complexity High Low Medium Low Low Low High Medium Medium Medium Low Medium
Normalized Length # Rows
GT 8803 // Fall 2018
34
GT 8803 // Fall 2018
35
GT 8803 // Fall 2018
36