I'm a bit confused because I'm questioning the definition of 'online' in OLTP and OLAP. I used to think that 'online' here means that we want our answer in bounded time and based on the data available at an instance in time.

But OLAP queries can take a some hours to compute - isn't this offline?

And a quick search indicates offline OLAP which sounds rather confusing (offline online analytical processing)...?

What exactly is 'online'?


1 Answer 1


It is simply a remnant of olden times, when it was used in contrast to batch processing. "Online" here means "interactive", that is, requests to the database are processed as they come and responses are given more or less immediately, or at least as soon as they are available. Batch processing would collect requests into, well, batches, and execute them on schedule; responses would be given after the entire batch execution (e.g. next morning).

Abbreviations OLAP and OLTP hint at another historical artifact: "on-line" used to be the more common spelling until mid-1980s.

  • Thank you. I found this answer wondering how the "online" in olap compared to online algorithms, which so far as I know essentially means operations on data streams. Also confusing is that I think online in a video editing sense means "high definition".
    – Zach Smith
    Jul 9 at 19:48
  • Do you know any examples of databases where queries / processing is NOT done in an online (as in oltp/olap) sense?
    – Zach Smith
    Jul 9 at 19:51
  • Nice example of an especially misleading anachronism
    – Zach Smith
    Jul 9 at 19:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.