My life as a database
Mar. 18th, 2011 08:40 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
randy_byersI've been walking to work along the Burke-Gilman trail for over twenty years now. (Eventually I'll get there!) Over the years I've tried several times to remember where it was that a certain old friend of mine used to live back in, oh, 1986 or so. It was an apartment with a balcony just up the hill from Lake Union, and we had some crazy good times in that apartment, back when I was still doing my best to live the rock'n'roll life style. Memory said it was on Eastern Avenue, but every time I've looked at the apartment buildings on Eastern Avenue in these past twenty-odd years, none of them have looked familiar. Eventually I concluded it was actually on 1st, because a couple of the apartment buildings on 1st looked more or less the way I remembered the building looking.
So this morning on the walk to work, I was thinking about my little black address book, because I was wondering whether I should take it with me when I leave for Mexico tomorrow morning. The answer to that question was No, but in thinking about the address book I started thinking about how I don't use it as much as I once did, because I now have an address database on my PC that I use more often. And I was thinking about what addresses I have in my address book that aren't in my database, and whether I should transfer them.
Then I got to 1st and went through that whole thought process about my old friend's apartment again, as I have occasionally done in the past. I looked at the apartment buildings, and a couple of them looked like likely candidates, but which one was it? And it suddenly occurred to me, because I had been thinking about it for other reasons, that my little black address book is so old that it might actually have my friend's old address in it. So I pulled it out of my bag, and sure enough there was the old address. It was crossed out (along with four or five subsequent addresses for the same old friend), but I could still see that the address had been on Eastern Avenue after all.
Well. This illustrates the process by which false memories are formed, for one thing, because I really had convinced myself that the apartment had been on 1st. But because my current job is all about databases, it also got me thinking about how if I'd transferred all the current addresses from my little black book into my address database and thrown the book away, all the historical addresses would be lost, and I quite likely never would have gotten rid of my false memory. Not that it matters much, in this particular case! Yet I immediately realized that I'd already overwritten addresses in my address database a number of times, and I began to wonder how I could replicate the historical aspect of my little black book. Well, obviously I would need date ranges on my address records. So I started thinking about the best way to configure the date ranges, and about how to replicate the crossing out of old addresses so that I didn't use them by mistake ...
And I realized that I am sooooooo ready for a vacation in Mexico.
So this morning on the walk to work, I was thinking about my little black address book, because I was wondering whether I should take it with me when I leave for Mexico tomorrow morning. The answer to that question was No, but in thinking about the address book I started thinking about how I don't use it as much as I once did, because I now have an address database on my PC that I use more often. And I was thinking about what addresses I have in my address book that aren't in my database, and whether I should transfer them.
Then I got to 1st and went through that whole thought process about my old friend's apartment again, as I have occasionally done in the past. I looked at the apartment buildings, and a couple of them looked like likely candidates, but which one was it? And it suddenly occurred to me, because I had been thinking about it for other reasons, that my little black address book is so old that it might actually have my friend's old address in it. So I pulled it out of my bag, and sure enough there was the old address. It was crossed out (along with four or five subsequent addresses for the same old friend), but I could still see that the address had been on Eastern Avenue after all.
Well. This illustrates the process by which false memories are formed, for one thing, because I really had convinced myself that the apartment had been on 1st. But because my current job is all about databases, it also got me thinking about how if I'd transferred all the current addresses from my little black book into my address database and thrown the book away, all the historical addresses would be lost, and I quite likely never would have gotten rid of my false memory. Not that it matters much, in this particular case! Yet I immediately realized that I'd already overwritten addresses in my address database a number of times, and I began to wonder how I could replicate the historical aspect of my little black book. Well, obviously I would need date ranges on my address records. So I started thinking about the best way to configure the date ranges, and about how to replicate the crossing out of old addresses so that I didn't use them by mistake ...
And I realized that I am sooooooo ready for a vacation in Mexico.
