Workshop on Self managing Database Systems (SMDB) 2020
Table of Contents (powered by https://videoken.com)
0:18:33 [Workshop on Self Managing Database Systems (SMDB) 2020]
0:22:26 Rethinking Autonomous Databases
0:23:48 Workshop Research Papers
0:24:42 Two Keynotes & One Invited Talk
0:25:51 SMDB Panel
0:26:10 Acknowledgement - Our Esteemed
Program Committee
0:56:40 [Talk: Adaptive Distributed Partitioning in Apachelink]
0:58:55 Motivation - Distributed real-time outlier detection
0:59:47 Motivation - Partitioning (I/2)
1:01:48 Motivation - Partitioning (2/2)
1:02:44 "Adaptive"
1st category
1:03:16 Apache Flink
1:03:56 Architecture
1:04:41 Feedback loop - Redis
1:05:04 Feedback loop - Broadcast stream
1:05:46 Feedback loop - partitioning tasks
1:06:27 Final Architecture
1:06:37 Controller function (I/2)
1:07:51 Controller function (2/2)
1:08:20 Experimental Evaluation (2/3)
1:10:52 Experimental Evaluation (3/3)
1:11:10 Contributions & Future work
1:12:53 Thank you!
1:19:28 [Talk: Towards Self-Adapting Data Migration in the Context of Schema Evolution in NoSQL Databases]
1:20:02 Agenda
1:21:13 Agile Software Development with NoSQL Databases
1:21:41 Excursion: NoSQL Schema Evolution Operations
1:22:35 Big Data Migration
1:23:10 Basic Strategies of Data Migration
1:24:12 Proactive Data Migration Strategies
1:25:03 Characteristics of Data Migration Strategies
1:25:32 Choosing the Right Data Migration Strategy
1:27:40 MigCast: Choosing a Suitable Data Migration Strategy
1:29:18 Self-adaptive Data Migration
1:30:15 Self-adaptive Data Migration Approaches
1:31:07 Self-adaptive Data Migration:
Complexity-adaptive Approach
1:32:27 Self-adaptive Data Migration:
Predictive Requirement-adaptive Approach
1:34:26 Conclusion and Outlook
1:35:16 Q&A
1:36:49 [Talk: PatchIndex- Exploiting Approximate Constraints in Self-managing Databases]
1:37:37 Motivation
1:38:57 An example real world use case
1:40:01 Approximate constraint handling
1:40:26 Contributions
1:41:06 Basic Idea
1:43:10 Constraint discovery - NUC
1:44:04 Constraint discovery - NSC
1:44:50 Index design
1:45:49 Index scan
1:46:27 Integration into query optimization
1:48:30 Evaluation - Microbenchmark
1:50:10 Evaluation - TPC-DS
1:51:03 Conclusion
1:51:55 Ongoing and future work
1:52:13 Q&A
1:59:23 [Talk: START - Self-Tuning Adaptive Radix Tree]
2:00:01 Practical Database Indexes
2:02:10 Self-Tuning ART
2:04:03 Multilevel Nodes
2:04:52 Rewired Memory Nodes
2:08:17 Cost Model for Node Lookup
2:09:58 Bottom-up Optimization
2:12:37 Performance
2:14:08 Conclusion
2:14:58 Q&A
2:30:19 [Keynote Sessions]
2:32:08 [Talk: AlOps with the Oracle Autonomous Database]
2:33:44 Agenda
2:34:46 Data is the new oil
2:35:58 AIOps Cloud Operations - 3 Strategic Pillars
2:37:38 AIOps Architecture
2:39:28 Machine View
2:41:25 Project Examples
2:41:34 Autonomous health - Anomaly Timeline
2:42:56 Log reduction and anomaly timeline
2:49:08 Anomaly Detection- High level
3:09:29 Autonomous Health - Database Performance
3:11:23 Workload anomaly detection
3:14:29 Identify the best indexes
3:16:08 Oracle Machine Learning & Adv. Analytics Algorithms
3:19:57 AutoML in OML4Py
3:21:45 Conclusions
3:24:32 Q&A
3:55:57 [Second Session]
3:56:21 [Talk: Cost Guided cardinality Estimation: Focus Where it Matters]
3:57:10 Cardinality Estimation
3:57:44 Using ML models for
Cardinality Estimation
3:58:25 What is a good Loss
Function?
3:59:52 Plan Cost
4:03:04 How do we optimize for
Plan-Cost?
4:03:49 Training
4:05:22 Dataset
4:06:04 Training Setup
4:06:40 MSCN Results (Test Set)
4:08:21 MSCN Results:
Explanation
4:09:49 Conclusions
4:10:52 Q&A
4:14:28 [Talk: Online Index Selection Using Deep Reinforcement Learning for a Cluster Database]
4:15:27 Outline
4:15:49 Introduction
4:17:40 Objective
4:19:04 Workload Forecaster
4:19:25 Pre-Processing
4:19:47 Pre-processing- Example
4:21:04 DRL-Framework
4:22:46 Environment - State Representation
4:23:48 Environment - Set of Actions
4:24:01 Environment - Reward Function
4:24:12 Reward Function - Workload Processing Cost
4:25:28 Reward Function - Load skew
4:26:26 DRL-Agent
4:27:59 Cost Estimation
4:28:20 Routing
4:29:13 Future Work
4:30:25 Questions?
4:34:47 [Break]
4:36:50 [Panel]
4:44:11 [Last Session: Self-Managing Database Systems]
4:44:41 Data Engineering Workshop on Self Managing Database Systems
4:45:40 TCDE Workgroup on Self-Managing Database Systems
4:46:27 Executive Committee
4:48:02 Self-Managing Database
4:49:24 Questions
5:31:35 Voting
5:34:38 Closing - Concluding Remarks
5:36:44 Acknowledgement - Our Esteemed Program Committee