Proceedings of the 50th Annual Southeast Regional Conference 2012
DOI: 10.1145/2184512.2184554
|View full text |Cite
|
Sign up to set email alerts
|

MySQL and the trouble with temporal data

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 n… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
2
1

Citation Types

0
3
0

Year Published

2016
2016
2017
2017

Publication Types

Select...
3

Relationship

0
3

Authors

Journals

citations
Cited by 3 publications
(3 citation statements)
references
References 2 publications
0
3
0
Order By: Relevance
“…Therefore, optimization was proposed to use for the storage of regularly updated data fields with only fixed-length integer without sign (in the MySQL database and a number of other databases such fields have the option "unsigned" [21][22][23][24]). Since the actual data samples can be both positive and negative, and maybe have a fractional part, it is proposed to carry out the normalization of the record with the formula [20]: y = C * x + y 0 .…”
Section: Compression Methods Based On Optimization Of the Data Structurementioning
confidence: 99%
“…Therefore, optimization was proposed to use for the storage of regularly updated data fields with only fixed-length integer without sign (in the MySQL database and a number of other databases such fields have the option "unsigned" [21][22][23][24]). Since the actual data samples can be both positive and negative, and maybe have a fractional part, it is proposed to carry out the normalization of the record with the formula [20]: y = C * x + y 0 .…”
Section: Compression Methods Based On Optimization Of the Data Structurementioning
confidence: 99%
“…While frequently thought to be unseemly for spaces of high security like budgetary organizations or certain territories of the administration. MySQL has turned into the main social database in numerous regions of the scholarly world, including experimental research and instructing understudies [12].…”
Section: B Mysqlmentioning
confidence: 99%
“…While every now and again thought to be raunchy for spaces of high security like budgetary associations or certain domains of the organization. MySQL has transformed into the primary social database in various locales of the academic world, including test investigate and training understudies [12].…”
Section: B Mysqlmentioning
confidence: 99%