RBAR
English
Etymology
Coined by database administrator Jeff Moden.[1][2]
Pronunciation
Phrase
RBAR
- (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[2], Simple Talk Publishing, archived from the original on 23 October 2007:
- 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[3], retrieved 19 July 2021:
- 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[4]:
- While RBAR used over twice as much log as the set based operations, the log used per transaction was less than half.
References
- ^ Jeff Moden (10 January 2005) “Calculating Work Days”, in SQLServerCentral[1], Simple Talk Publishing, archived from the original on 23 October 2007: “All of these methods either employ (what I call) "RBAR" programming (pronounced as "ree-bar" and stands for "Row By Agonizing Row") […]”
- ^ Randy Knight (9 December 2019) “Rethinking RBAR”, in SQL Solutions Group: “Much has been written about the performance implications of the dreaded RBAR, a term coined by Jeff Moden many years ago.”