EnglishEdit

EtymologyEdit

Coined by database administrator Jeff Moden.[1][2]

PronunciationEdit

PhraseEdit

RBAR

  1. (database administration, derogatory) Initialism of row by agonizing row; used to describe procedural programming in SQL.
    • [2005 January 10, Jeff Moden, “Calculating Work Days”, in SQLServerCentral[3], Simple Talk Publishing, archived from the original on 2007-10-23:
      All of these methods either employ (what I call) "RBAR" programming (pronounced as "ree-bar" and stands for "Row By Agonizing Row") []]
    • 2007 July 26, Remi Gregoire, “RBAR: ‘Row By Agonizing Row’”, in Redgate[4], retrieved 2021-07-19:
      RBAR is a consequence of coding in a strictly procedural way, rather than in a set-based way. It is different from poor coding; it is the result of adopting a mindset that one always has to tell the computer, step by step []
    • 2019 December 9, Randy Knight, “Rethinking RBAR”, in SQL Solutions Group[5]:
      While RBAR used over twice as much log as the set based operations, the log used per transaction was less than half.

ReferencesEdit

  1. ^ Jeff Moden (2005-01-10), “Calculating Work Days”, in SQLServerCentral[1], Simple Talk Publishing, archived from the original on 2007-10-23: “All of these methods either employ (what I call) "RBAR" programming (pronounced as "ree-bar" and stands for "Row By Agonizing Row") []
  2. ^ Randy Knight (2019-12-09), “Rethinking RBAR”, in SQL Solutions Group[2]: “Much has been written about the performance implications of the dreaded RBAR, a term coined by Jeff Moden many years ago.”

AnagramsEdit