NoSQL Schema Design for Time-Dependent Workloads
Authors:
Yusuke Wakuta,
Michael Mior,
Teruyoshi Zenmyo,
Yuya Sasaki,
Makoto Onizuka
Abstract:
In this paper, we propose a schema optimization method for time-dependent workloads for NoSQL databases. In our proposed method, we migrate schema according to changing workloads, and the estimated cost of execution and migration are formulated and minimized as a single integer linear programming problem. Furthermore, we propose a method to reduce the number of optimization candidates by iterating…
▽ More
In this paper, we propose a schema optimization method for time-dependent workloads for NoSQL databases. In our proposed method, we migrate schema according to changing workloads, and the estimated cost of execution and migration are formulated and minimized as a single integer linear programming problem. Furthermore, we propose a method to reduce the number of optimization candidates by iterating over the time dimension abstraction and optimizing the workload while updating constraints.
△ Less
Submitted 29 March, 2023;
originally announced March 2023.
Smart City Data Analysis via Visualization of Correlated Attribute Patterns
Authors:
Yuya Sasaki,
Keizo Hori,
Daiki Nishihara,
Sora Ohashi,
Yusuke Wakuta,
Kei Harada,
Makoto Onizuka,
Yuki Arase,
Shinji Shimojo,
Kenji Doi,
He Hongdi,
Zhong-Ren Peng
Abstract:
Urban conditions are monitored by a wide variety of sensors that measure several attributes, such as temperature and traffic volume. The correlations of sensors help to analyze and understand the urban conditions accurately. The correlated attribute pattern (CAP) mining discovers correlations among multiple attributes from the sets of sensors spatially close to each other and temporally correlated…
▽ More
Urban conditions are monitored by a wide variety of sensors that measure several attributes, such as temperature and traffic volume. The correlations of sensors help to analyze and understand the urban conditions accurately. The correlated attribute pattern (CAP) mining discovers correlations among multiple attributes from the sets of sensors spatially close to each other and temporally correlated in their measurements. In this paper, we develop a visualization system for CAP mining and demonstrate analysis of smart city data. Our visualization system supports an intuitive understanding of mining results via sensor locations on maps and temporal changes of their measurements. In our demonstration scenarios, we provide four smart city datasets collected from China and Santander, Spain. We demonstrate that our system helps interactive analysis of smart city data.
△ Less
Submitted 14 April, 2021;
originally announced April 2021.
