SQL and the Problem with Time Series


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 analysi