MySQL and the trouble with temporal data

Authors:
Chad Vicknair;Dawn Wilkins;Yixin Chen
Affiliations:
University of Mississippi, University, MS;University of Mississippi, University, MS;University of Mississippi, University, MS
Venue:
Proceedings of the 50th Annual Southeast Regional Conference
Year:
2012

Citing 2
Cited 0

Time Granularities in Databases, Data Mining and Temporal Reasoning

Time Granularities in Databases, Data Mining and Temporal Reasoning
Temporal Data and the Relational Model

Temporal Data and the Relational Model

Quantified Score

Hi-index	0.00

Visualization

Abstract

Storing historical data is not new. Data warehouses are filled with it. However, querying temporal data has only, in the past few years, become a realistic possibility. Yet the SQL standard has not had significant updates in temporal data support since 1992. The demands of the modern world are no longer satisfied by decades-old solutions. MySQL, an open-source database extremely popular in the sciences, has still not yet fully implemented SQL-92. Its approach to temporal needs is lacking. Too many queries are not answerable, and those that are answerable are often answered inconsistently.