RBAR
English
[edit]Etymology
[edit]Coined by database administrator Jeff Moden.[1][2]
Pronunciation
[edit]Phrase
[edit]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 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[3], 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[4]:
- While RBAR used over twice as much log as the set based operations, the log used per transaction was less than half.
References
[edit]- ^ Jeff Moden (2005 January 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") […]”
- ^ Randy Knight (2019 December 9) “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.”