Do you ever wonder about the history of the systems you rely on every day?
They didn’t teach us database history in school. Instead, we got calculus and art and interpretive dance. Fat lot of good that did us, right?
So from time to time, we’re taking it upon ourselves to bring you the history of some important database concepts and features. You won’t find this stuff in Books Online, no no.
For today’s entry, we need to take you back to the 1800s.
Meet Maurice Gutenberg.
Maurice was the great-great-great-great-great-great-grandson of Johannes Gutenberg, the man who pioneered the mass production of books.
Maurice benefitted greatly from his great-great-…okay, let’s just say benefitted from his ancestor’s invention, living large off the printing press royalties. (Johannes also invented hardware patents.) Maurice built one of the largest libraries in Europe, devouring books from every learning institution he could find. In fact, he was partially responsible for the Great Book Price Bubble of 1899.
As Maurice’s collection grew, he needed a system to track his book inventory and pricing. He turned to computers, naturally – his neighbor happened to be building an early prototype of a machine that would later turn into the Commodore VIC-20.
To Maurice’s astonishment, the computer logged every one of his purchases and sales in single file. The data was continuously added, one row at a time. With each update of an existing row, it was simply added to the end as a new version. This system was modeled after the papyrus rolls of ancient Egypt.
Maurice immediately channeled his gr…ancestor Johannes, pulled out a page from one of his books, and pointed at it. “We should store the data like this!” he exclaimed.
“But it will get out of order!” a neighbor cried out. (Ironically, you might recognize part of that neighbor’s name…Birgitta Hallengren.)
Maurice tired of European life (especially the part about defragmenting his pages.) He later sold off his entire book collection, packed up his remaining belongings, and headed for Seldovia, Alaska’s Best Kept Secret.
But you might just have heard of Maurice’s first database: pubs, short for publications.
Though ne’er the brightest lad, Robert was still the sole inheritor of his dad’s land, which included the largest loch known to both Robert and his dad, Auchbert.
His mother, who pretended to die during childbirth, had seen many much larger lochs.
Left on his own, Robert proceeded to spend the family fortune trying to prove that he indeed had the largest loch. Much to his dismay, he found out that other lads had lochs twice, thrice, and sometimes four-ice the size of his own.
Mad with jealousy, he began painting landscapes of his loch comically out of perspective. Often covered with arrows pointing to “my loch”, and then much smaller arrows pointing to tiny dots noted as “your loch”. Though he unwittingly also invented the poop emoji, that’s not the story we’re here to tell.
When he tried selling his paintings to other nobles, the typical response was “aye that’s nay a loch”, which lead to him being called Robert of Nay Loch.
He turned into such a laughing stock, that many years later when Microsoft needed a way to identify fools, they came up with the eponymous NOLOCK hint. Whenever someone uses this, it’s said that Robert returns from the grave to festoon their data pages with incorrect information as punishment.