short-paper

Visual Spatial-OLAP for Vehicle Recorder Data on Micro-sized Electric Vehicles

Authors:

Takahiro Komamizu,

Toshiyuki Amagasa,

Hiroyuki KitagawaAuthors Info & Claims

IDEAS '16: Proceedings of the 20th International Database Engineering & Applications Symposium

Pages 358 - 363

https://doi.org/10.1145/2938503.2938532

Published: 11 July 2016 Publication History

Abstract

Analyzing vehicle recorder data of electric vehicles (EVs) reveals how the EVs are used. This paper proposes an OLAP framework to support analyzing trajectories in vehicle recorder data and applies the framework to vehicle recorder data of EVs. The framework consists of ETL (extract, transform, and load) process for trajectory data and visualization for analyzing the data. The ETL process includes hierarchy definitions for spatial and temporal dimensions, as well as aggregation functions for trajectory data. In the subsequent visualization phase, the framework displays results of OLAP operations on map interface. To ensure the applicability of the framework for real applications, we apply the framework to vehicle recorder data of micro-sized EVs (or μEVs), which are smaller EVs with one or two passengers including one driver and can drive at most 100km distance without charging on the way. The application realizes that the framework successfully enables analyses on the trajectory data for real analytic requirements.

References

[1]

G. L. Andrienko, N. V. Andrienko, and S. Wrobel. Visual Analytics Tools for Analysis of Movement Data. SIGKDD Explorations, 9(2):38--46, 2007.

Digital Library

[2]

N. V. Andrienko and G. L. Andrienko. Visual analytics of movement: An overview of methods, tools and procedures. Information Visualization, 12(1):3--24, 2013.

Digital Library

[3]

S. Bimonte, J. Gensel, and M. Bertolotto. Enriching Spatial OLAP with Map Generalization: a Conceptual Multidimensional Model. In Workshops Proceedings of the 8th IEEE International Conference on Data Mining (ICDM 2008), pages 332--341, 2008.

Digital Library

[4]

C. Chen, X. Yan, F. Zhu, J. Han, and P. S. Yu. Graph OLAP: Towards Online Analytical Processing on Graphs. In the 8th IEEE International Conference on Data Mining (ICDM 2008), pages 103--112, 2008.

Digital Library

[5]

C. K. Chui, B. Kao, E. Lo, and R. Cheng. I/O-Efficient Algorithms for Answering Pattern-Based Aggregate Queries in a Sequence OLAP System. In the 20th ACM Conference on Information and Knowledge Management (CIKM 2011), pages 1619--1628, 2011.

Digital Library

[6]

J. Cohen, B. Dolan, M. Dunlap, J. M. Hellerstein, and C. Welton. MAD Skills: New Analysis Practices for Big Data. PVLDB, 2(2):1481--1492, 2009.

Digital Library

[7]

H. Gupta, V. Harinarayan, A. Rajaraman, and J. D. Ullman. Index Selection for OLAP. In the Thirteenth International Conference on Data Engineering, pages 208--219, 1997.

Digital Library

[8]

D. Howe, M. Costanzo, P. Fey, T. Gojobori, L. Hannick, W. Hide, D. P. Hill, R. Kania, M. Schaeffer, S. St Pierre, S. Twiggeri, O. White, and S. Yon Rhee. Big data: The future of biocuration. Nature, 455(7209):47--50, 2008.

[9]

M. Itoh, D. Yokoyama, M. Toyoda, and M. Kitsuregawa. Visual Interface for Exploring Caution Spots from Vehicle Recorder Big Data. In IEEE International Conference on Big Data (Big Data 2015), pages 776--784, 2015.

Digital Library

[10]

M. R. Jensen, T. H. Møller, and T. B. Pedersen. Specifying OLAP Cubes on XML Data. J. Intell. Inf. Syst., 17(2-3):255--280, 2001.

Digital Library

[11]

Y. Li, J. Luo, C. Chow, K. Chan, Y. Ding, and F. Zhang. Growing the charging station network for electric vehicles with trajectory data analytics. In 31st IEEE International Conference on Data Engineering (ICDE 2015), pages 1376--1387, 2015.

[12]

E. Lo, B. Kao, W. Ho, S. D. Lee, C. K. Chui, and D. W. Cheung. OLAP on Sequence Data. In ACM SIGMOD International Conference on Management of Data (SIGMOD 2008), pages 649--660, 2008.

Digital Library

[13]

G. Marketos, E. Frentzos, I. Ntoutsi, N. Pelekis, A. Raffaetà, and Y. Theodoridis. Building Real-World Trajectory Warehouses. In Seventh ACM International Workshop on Data Engineering for Wireless and Mobile Access (MobiDE 2008), pages 8--15, 2008.

Digital Library

[14]

G. Marketos and Y. Theodoridis. Ad-hoc OLAP on Trajectory Data. In Eleventh International Conference on Mobile Data Management (MDM 2010), pages 189--198, 2010.

Digital Library

[15]

A. O. Mendelzon and A. A. Vaisman. Temporal Queries in OLAP. In 26th International Conference on Very Large Data Bases (VLDB 2000), pages 242--253, 2000.

Digital Library

[16]

K. P. Murphy. Machine Learning, a Probabilistic Perspective. MIT press, 2012.

Digital Library

[17]

K. Nakabasami, T. Amagasa, S. A. Shaikh, F. Gass, and H. Kitagawa. An Architecture for Stream OLAP Exploiting SPE and OLAP Engine. In IEEE International Conference on Big Data (Big Data 2015), pages 319--326, 2015.

Digital Library

[18]

S. Orlando, R. Orsini, A. Raffaetà, A. Roncato, and C. Silvestri. Trajectory Data Warehouses: Design and Implementation Issues. JCSE, 1(2):211--232, 2007.

[19]

M. Scotch and B. Parmanto. SOVAT: Spatial OLAP Visualization and Analysis Tool. In 38th Hawaii International Conference on System Sciences (HICSS-38 2005), 2005.

Digital Library

[20]

R. Weibel and G. Dutton. newblock Generalizing Spatial Data and Dealing with Multiple Representations. Geographic Information Systems and Science, 1:125--155, 1999.

[21]

X. Zhou, D. Truffet, and J. Han. Efficient Polygon Amalgamation Methods for Spatial OLAP and Spatial Data Mining. In 6th International Symposium on Advances in Spatial Databases (SSD99), pages 167--187, 1999.

Digital Library

Cited By

Bou SShiokawa HHayase YKitagawa H(2019)StreamingCube-Based Analytical Framework for Environmental Data Analysis2019 IEEE International Conference on Big Data and Smart Computing (BigComp)10.1109/BIGCOMP.2019.8679149(1-8)Online publication date: Feb-2019
https://doi.org/10.1109/BIGCOMP.2019.8679149
Komamizu TAmagasa TShaikh SShiokawa HKitagawa H(2017)SOLAProceedings of the 9th International Conference on Management of Digital EcoSystems10.1145/3167020.3167026(35-41)Online publication date: 7-Nov-2017
https://dl.acm.org/doi/10.1145/3167020.3167026
Komamizu TNakazawa JAmagasa TKitagawa HTokuda H(2017)Analytical toolbox for smart city applications: Garbage collection log use case2017 IEEE International Conference on Big Data (Big Data)10.1109/BigData.2017.8258429(4105-4110)Online publication date: Dec-2017
https://doi.org/10.1109/BigData.2017.8258429
Show More Cited By

Visual Spatial-OLAP for Vehicle Recorder Data on Micro-sized Electric Vehicles
1. Human-centered computing
  1. Visualization
    1. Visualization application domains
2. Information systems
  1. Information systems applications

Recommendations

Hybrid energy storage systems and battery management for electric vehicles
DAC '13: Proceedings of the 50th Annual Design Automation Conference

Electric vehicles (EV) are considered as a strong alternative of internal combustion engine vehicles expecting lower carbon emission. However, their actual benefits are not yet clearly verified while the energy efficiency can be improved in many ways. ...
Mobile Electric Vehicles: Online Charging and Discharging
Hybrid Wind/Electric Powered Vehicle

Hybrid wind/electric powered vehicle is built and demonstrated. The vehicle uses bank of batteries to drive it. The batteries drive 3-phase brushless DC motor which moves the vehicle. The motor can rotate up to 2900 revolution per minute RPM at 3HP. A ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

IDEAS '16: Proceedings of the 20th International Database Engineering & Applications Symposium

July 2016

420 pages

ISBN:9781450341189

DOI:10.1145/2938503

Editor:
Evan Desai
ConfSys
,
General Chair:
Bipin C. Desai
Concordia University
,
Program Chairs:
Motomichi Toyama
Keio University
,
Jorge Bernardino
ISEC

Copyright © 2016 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

In-Cooperation

Keio University: Keio University

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 11 July 2016

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Short-paper
Research
Refereed limited

Conference

IDEAS '16

IDEAS '16: International Database Engineering & Applications Symposium

July 11 - 13, 2016

QC, Montreal, Canada

Acceptance Rates

Overall Acceptance Rate 74 of 210 submissions, 35%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
69
Total Downloads

Downloads (Last 12 months)1
Downloads (Last 6 weeks)0

Reflects downloads up to 09 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

Bou SShiokawa HHayase YKitagawa H(2019)StreamingCube-Based Analytical Framework for Environmental Data Analysis2019 IEEE International Conference on Big Data and Smart Computing (BigComp)10.1109/BIGCOMP.2019.8679149(1-8)Online publication date: Feb-2019
https://doi.org/10.1109/BIGCOMP.2019.8679149
Komamizu TAmagasa TShaikh SShiokawa HKitagawa H(2017)SOLAProceedings of the 9th International Conference on Management of Digital EcoSystems10.1145/3167020.3167026(35-41)Online publication date: 7-Nov-2017
https://dl.acm.org/doi/10.1145/3167020.3167026
Komamizu TNakazawa JAmagasa TKitagawa HTokuda H(2017)Analytical toolbox for smart city applications: Garbage collection log use case2017 IEEE International Conference on Big Data (Big Data)10.1109/BigData.2017.8258429(4105-4110)Online publication date: Dec-2017
https://doi.org/10.1109/BigData.2017.8258429
Komamizu TAmagasa TShaikh SShiokawa HKitagawa H(2016)Towards Real-Time Analysis of Smart City Data: A Case Study on City Facility Utilizations2016 IEEE 18th International Conference on High Performance Computing and Communications; IEEE 14th International Conference on Smart City; IEEE 2nd International Conference on Data Science and Systems (HPCC/SmartCity/DSS)10.1109/HPCC-SmartCity-DSS.2016.0192(1357-1364)Online publication date: Dec-2016
https://doi.org/10.1109/HPCC-SmartCity-DSS.2016.0192

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents