SQL and the Problem with Time Series
OPEN PLATFORM
SQLisn't keeping pace with the demand to quickly analyze large amounts of data. By Joe Celko, independent consultant, and Arthur Whitney, CTOof Kx Systems
"Time is what keeps everything from happening all at once."
--George Carlin
In the real world, time is a continuum, not a point. But in the digital world of ones and zeros, we pretend time occurs in a series of points. It's a convenient lie, one that enables us to apply digital technologies to all kinds of business operations. In the analysis of
Only users who have a paid subscription or are part of a corporate subscription are able to print or copy content.
To access these options, along with all other subscription benefits, please contact info@waterstechnology.com or view our subscription options here: http://subscriptions.waterstechnology.com/subscribe
You are currently unable to print this content. Please contact info@waterstechnology.com to find out more.
You are currently unable to copy this content. Please contact info@waterstechnology.com to find out more.
Copyright Infopro Digital Limited. All rights reserved.
As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (point 2.4), printing is limited to a single copy.
If you would like to purchase additional rights please email info@waterstechnology.com
Copyright Infopro Digital Limited. All rights reserved.
You may share this content using our article tools. As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (clause 2.4), an Authorised User may only make one copy of the materials for their own personal use. You must also comply with the restrictions in clause 2.5.
If you would like to purchase additional rights please email info@waterstechnology.com
More on Data Management
As the ETF market grows, firms must tackle existing data complexities
Finding reliable reference data is becoming a bigger concern for investors as the ETF market continues to balloon. This led to Big xyt to partner with Trackinsight.
Artificial intelligence, like a CDO, needs to learn from its mistakes
The IMD Wrap: The value of good data professionals isn’t how many things they’ve got right, says Max Bowie, but how many things they got wrong and then fixed.
An inside look: How AI powered innovation in the capital markets in 2024
From generative AI and machine learning to more classical forms of AI, banks, asset managers, exchanges, and vendors looked to large language models, co-pilots, and other tools to drive analytics.
As US options market continued its inexorable climb, ‘plumbing’ issues persisted
Capacity concerns have lingered in the options market, but progress was made in 2024.
Data costs rose in 2024, but so did mitigation tools and strategies
Under pressure to rein in data spend at a time when prices and data usage are increasing, data managers are using a combination of established tactics and new tools to battle rising costs.
In 2025, keep reference data weird
The SEC, ESMA, CFTC and other acronyms provided the drama in reference data this year, including in crypto.
Asset manager Saratoga uses AI to accelerate Ridgeline rollout
The tech provider’s AI assistant helps clients summarize research, client interactions, report generation, as well as interact with the Ridgeline platform.
CDOs evolve from traffic cops to purveyors of rocket fuel
As firms start to recognize the inherent value of data, will CDOs—those who safeguard and control access to data—finally get the recognition they deserve?
