Abstract The era of Big Data has given rise to a massive amount of data containing spatio-temporal information, such as video data, traffic data, and social media data. Current research on spatio-temporal data mainly focuses on the spatial information, while temporal information is usually processed in an auxiliary manner using simple approaches. In order to solve the existing problems in the current time coding schemes, this paper proposed a new type of integer coding method for the time segments called Multi-scale Time Segment Integer Coding (MTSIC). Based on the tree structures and the sorting of the integers, this method is able to describe various temporal relationships among different scales of time segments, such as the start and end, containment/inclusion, which makes it a uniform integer coding scheme for multiple scales of time information. Furthermore, this paper has studied on the MTSIC-based calculations and conversions, including the hierarchical calculations, the hierarchical regression calculations, the conversion between the conventional time coding schemes, the calculations on temporal relationships, and the conversion of arbitrary time spans. These efforts support highly efficient calculations and queries based on the time segments. Preliminary investigations have also been conducted on the potential applications and prospects of the MTSIC method. The results of experiments demonstrated that the implementation of MTSIC is simple and reliable, and MTSICs are easily converted into conventional expressions of time. Additionally, the MTSIC method also exhibits a very high level of efficiency in terms of the time needed to query and perform computations on time values.
[1]
Siva Ravada,et al.
Applying and Extending Oracle Spatial
,
2013
.
[2]
Tim Gorman,et al.
Beginning Oracle SQL: for Oracle Database 12c
,
2014
.
[3]
Kevin D. Fairbanks.
An analysis of Ext4 for digital forensics
,
2012
.
[4]
Darl Kuhn,et al.
Pro Oracle Database 18c Administration
,
2019,
Apress.
[5]
P. J. Plauger.
The Standard C Library
,
1991
.
[6]
Naiyuan Xiao.
A rapid reveal of periodicities on measure of the civil calendars' dates and its applications.
,
1995
.
[7]
Veljko M. Milutinovic,et al.
Fast file existence checking in archiving systems
,
2011,
TOS.
[8]
Xu Guo-tian.
The Research of File Recovery Method on EXT4 File System
,
2011
.
[9]
Darl Kuhn,et al.
Expert Oracle Database Architecture
,
2014,
Apress.