furia furialog · New Particles · The War Against Silence · Aedliga (songs) · photography · code · other things
8 August 2007 to 30 March 2007
Two of the very bad features of the SQL-based conception of relational data-modeling, I think, are these:  

- one-to-many relationships are significantly harder to handle than one-to-one relationships (and, inversely, many-to-one relationships easiest to handle by defactoring)  

- absence is significantly harder to handle than presence  

It's easy to add an Artist column to an Album table, for example, so we get:  

AlbumArtist
Black OneSunn O)))

But if you want to model the fact that collaboration albums can have multiple artists, you need an Albums table, an Artists table, a join table, and a bunch of IDs:  

Albums
AlbumID
Black One1
Altar2

Artists
ArtistID
Sunn O)))1
Boris2

Authorship
AlbumIDArtistID
11
21
22

This is already a pain in the ass, and thus you get a world filled with cop-outs like this:  

AlbumArtist
Black OneSunn O)))
AltarSunn O))) / Boris

and this:  

AlbumArtist 1Artist 2Artist 3
Black OneSunn O)))FALSEFALSE
AltarSunn O)))BorisFALSE

both of which are tolerable enough to just look at, but awful when you go to try to get the computer to answer even perfectly sensible questions like what albums Boris has done.  

And then, when you want to add a little more detail, you really ought to do this:  

Albums
AlbumID
Black One1
Altar2

Artists
ArtistID
Sunn O)))1
Boris2

Formats
FormatID
CD1
LP2
Download3
Authorship
AlbumIDArtistID
11
21
22
Formatship
AlbumIDFormatID
11
12
13
21
22

but instead you'll probably try to get away with:  

AlbumArtistFormatCode
Black OneSunn O)))CD/LP/D
AltarSunn O))) & BorisCD/LP

or  

AlbumArtist 1Artist 2Artist 3CDLPD
Black OneSunn O)))FALSEFALSETRUETRUETRUE
AltarSunn O)))BorisFALSETRUETRUEFALSE

because if you have the latter, you can do:  

SELECT Album, Artist

FROM Albums
WHERE D=FALSE

which is easy to understand, although it won't work because you forgot you don't have a field called plain "Artist" anymore. Whereas with the five-table form you have to do something like:  

SELECT Albums.Album, Artists.Artist

FROM Albums, Artists, Authorship
WHERE Albums.ID=Authorship.AlbumID
AND Artists.ID=Authorship.ArtistID
AND NOT EXISTS (
SELECT *
FROM Formats, Formatship
WHERE Albums.ID=Formatship.AlbumID
AND Formats.ID=Formatship.FormatID
AND Formats.Format='Download'
)

and that's probably still wrong.  
 

I submit that this is all a colossal mess, and it's a wonder the database-driven software we get driven out of it isn't even more woeful than it is. A better paradigm would embrace the opposites of these two flaws:  

- the modeling of a relationship should be the same whether the relationship is one-to-one, one-to-many, many-to-one or many-to-many, and should be the same no matter how many "many"s you have  

- absence and presence should be equally easy to assess  

And I think a useful rough metric for such a new system is that it allows you to model your data without ever needing to say FALSE.  

And I think this, I think, because I think this is how we think and talk about relationships between things when nobody is getting in our way:  

Black One was recorded by Sunn O))), and was released in CD, LP and Download formats. Altar was recorded by Sunn O))) and Boris, and was released in CD and LP formats. All of these albums were released on CD and LP. Altar is the only one that wasn't released in Download format.  

Take these out of sentence form and make the data-types explicit and everything is still perfectly straightforward:  

Album: [Black One]

Artists: [Sunn O)))]
Formats: [CD] [LP] [Download]  

Album: [Altar]
Artists: [Sunn O)))] [Boris]
Formats: [CD] [LP]

or, looking at the same data from a different perspective:  

Format: [CD]

Albums: [Black One] [Altar]  

Format: [LP]
Albums: [Black One] [Altar]  

Format: [Download]
Albums: [Black One]

and then the old questions are also easier:  

FIND Formats WHOSE Albums INCLUDE 'Black One' and 'Altar'

FIND Albums WHOSE Formats DON'T INCLUDE 'Download'

Subliminating the one/many distinction allows us to talk about albums with 3 or 8 or 0 artists just as readily as we talk about albums with 1 or 2. Fixing the query language to handle absence lets us cope with the introduction of a new edition into our dataset, say, without having to add a new field for it and/or go through asserting that everything we already knew about doesn't have that format. I suspect pretty much every database field headed X and filled with TRUEs and FALSEs could at least be more usefully modeled in my new world as a relationship called "Characteristics" that either does or doesn't include X. And usually, as with formats, there's actually a meaningful label that contains information itself. The point is that things have relationships to their characteristics, or their formats. They don't, except in a very existential sense, have a relationship to falseness. FALSE is a machine thing.  
 

The relationally astute will note that the five-table version is the fully-normalized representation that would support an SQL-based implementation of my new form as a display abstraction, and presumably my pseudo-query-code could be preprocessed into the messy SQL so I'd never see it. But that's my point: SQL is too low an abstraction, which makes it too hard to do things naturally, which makes it too hard to pass along natural behavior to the victims of the system. I'm mainly arguing for a better abstraction. (Although I also expect it's still always going to be bad that there's no better underlying way to represent lists, so I'm also probably arguing for the better abstraction to not merely be layered on top of the bad one.)  
 

The discographically astute will note that Altar is available on iTunes, and that I have vastly undermodeled the rich and complicated space of Sunn O))) release formats. But if I'd done the examples in real detail, I'd still be typing out the bad versions...
 

What Muybridge did for horses galloping, I will become famous by doing for tiny children sneezing.
 

My parents report, and I vaguely remember this myself, that for the first few years of my being allowed to go to movie theaters and see real (i.e., non-"family") movies, I would invariably come home after each one and deliver some epic panegyric insisting that whatever it was was the best movie I had ever seen. The only specific movies I recall thinking this of as an impressionable early movie-goer are The Eagle Has Landed, Capricorn One and Clash of the Titans, and I submit that it is not unreasonable to consider this an ascending order of quality, albeit in the last case maybe only if one was a 14-year-old boy in 1981 and hadn't seen pointedly naked movie-breasts in anything else yet.  

You will eventually get to the age where we begin worrying about how to stage your exposure to adult concepts, too, and before that the age where we start having to negotiate with your own loopily underinformed idea of your personal tastes. But for now your comprehension is blissfully abstract, and pretty much anything is likely to be the greatest thing ever, or close enough for us to amuse ourselves by inferring the nuances of your reactions from the gradually-less-random expressions that flicker across your face.  

I have been taking advantage of this state by attempting to give you a sweepingly unguarded pre-self-consciousness grounding in modern rock music. I realize this might sound suspiciously like me just listening to music while I'm holding you, but your reactions are both surprisingly organized and not what I claimed I thought they were going to be, so I feel like the experiments are at least marginally non-solipsistic. Later, no doubt, you will turn out to mostly like some new kind of music B and I fundamentally fail to grasp, but at least you'll have the benefit of some Manic Street Preachers b-sides buried deep in your psyche.  
 

One of my favorite dopey anticipatory theories, developed a while ago after reading an evocative article about the sonic harshness of the womb, was that babies are naturally intuitive fans of deeply textural black metal. The coursing blood all around you, the sudden tumbling motions, the frantic gnashing hum of your own brain growing. Might as well call it birth metal.  

This idea proves to have some limited sense to it, at least, in that churning noise at high volume has some undeniable visceral effect. There's a long stretch of the middle of Part II of Metal Machine Music that puts you to sleep approximately as effectively as the "ocean" loop on the sound-module that came with your pack-and-play. Likewise a few carefully-selected sections of Aube's Aqua Syndrome. The ocean noises also kind of work on Bethany, though, whereas Reed and Aube kind of make her want to encase her head in cement, so given the open format of our house, and our affection for her head, the ocean sounds usually seem like the better option in practice.  

Little Tiggers do not turn out to like death metal at all, to my mild surprise and pro-forma-ly brooding disappointment. Even the Leviathan and Xasthur pieces I holistically experience as most textural prove to have far too many dynamic and tonal shifts at the second-by-second scale, and you're perpetually either getting restless during a quiet part or being startled when the noise blasts in again. Sad. Statistically this was the most likely age at which you'd appreciate death metal, in that there's not even the outside danger of your accidentally figuring out any of the words. Later you'll realize it's another silly thing that only boys like, and thus yet another thing for which I might as well apologize in advance.  

What you like best, by far, is steady, propulsive, fast, opportunistically rock-inflected pop songs. Four minutes at most, three is better. No long intros or outros. Female singers more than men (but James Bradfield and Paul Smith are OK), and big bonus points for any break where everything drops out except the drums and vocals. B thinks this is all about how I dance with you during those kinds of songs, but you and I know it's more than that. Fefe Dobson's "Rock It Till You Drop It" is, after all, a very fine song about perseverance, or maybe equanimity, and I'm only dancing the way anybody should feel inspired to. The Go-Go's are cultural icons, and give us a way to understand how the Spice Girls embody the dangerous nominality of post-ironic identity. Shakira represents both the emotional vitality of culture and the insistent triumph over it of individuality and hair. Tommy heavenly6 is, I agree, universally charming, and by the time you're old enough to wonder what she's singing, maybe I'll again have enough spare time to translate it.  
 

But in case you're ever really curious, your favorite song for your first two months has been, unquestionably, "U & Ur Hand" by Pink. I don't remember how I discovered this. You like "Who Knew" and "Leave Me Alone (I'm Lonely)" fairly well, too, but "U & Ur Hand" is clearly special. We have a special dance we've invented for it, you and I, and it has never, ever failed to please you. Once you went from beet-red squalling to fast asleep before it even got to the two-minute mark, but usually you just dance with me. Or, anyway, I dance, and you lie in my arms with your head nestled into my left armpit, gazing up at me with love. Or past me towards the nearest skylight, or lamp, or faint diagonal shadow, but I collect the love en passant.  

As you'll appreciate when you're considerably older, "U & Ur Hand" is not exactly intended for children. I usually sing along, anyway. It's a song of aggressive feminine self-affirmation, mostly, so even if its specific defiance and injunctions aren't really age-appropriate for you, or gender-appropriate for me, I think it's healthy for you to be exposed to its energy.  

And if B is right, and it's really only me you're responding to, then you're learning about how my goofy tastes in music and defiance become manifest in my body's movements and my heart's resonances, and although I don't need you to love exactly what I love, I want desperately for you to love what you love at least as jubilantly as I love what I love.  

I've long since seen a lot of movies I liked more than Capricorn One, but more than a few I liked less. "U & Ur Hand" probably won't always be your favorite song, and it'll probably save your mom and me some tense parent-teacher conferences along the way if it isn't. But not everything always has to change, and your first intuitions aren't necessarily wrong. I'll play this for you again someday, when you've forgotten, and we'll see what we think. And, maybe, remember what this felt like, when every next minute with you was so amazingly likely to be the best one yet.
 

B asked me whether, now that I see how much work you are, I'm more appreciative of what my own parents did for me. I definitely understand what they went through more than I ever did before having you, but appreciative isn't exactly right, for either what I feel for my parents or what I expect you to eventually feel for us. I don't remember or identify with myself as an infant. This baby we're bathing in the sink, because it's funny to try once even though you're basically already too big, is not really you. Not yet. So these pictures can't haunt you. This stuff we're doing for you can't exactly be for you. You didn't ask for it, you can't be consulted for your informed consent, and you'll have to live with the countless mistakes we're undoubtably already making. Asking you to be grateful for all this, in any meaningful sense, seems to me to be tantamount to imposing original sin. At most, maybe, one day you'll do this for somebody else who won't really exist yet. But only if you choose to for your own reasons, not because you owe anybody any kind of debt. You do not owe us your life, we are merely holding it for you in trust. Having you makes me more aware than ever that gratitude for one's own birth is a footstep into an emotional minefield. We, your parents, must be able to unequivocally forgive you for whatever it takes to get you to the point where you become you, for everything you require before you are able to take responsibility for your own commitments and responses. Until then, this work we do cannot and must not be measured in any kind of currency, it must be a gift given freely to the world.
I'm afraid to post more pictures. I fear we may have unwittingly unleashed more cuteness than the world can endure.
 

Mostly you sleep. "Mostly" in a statistical sense, at least, although somehow we are mostly not sleeping, so there's something subtly wrong with that term. When you aren't sleeping you are usually eating, or at least circling curiously around the possibility of eating. You have quickly settled on a terse, vigorous vocabulary of two exclamations: "Eh-eh-eh-eh-eh-eh-eh" means that you are hungry; "LLLLA!" means that you are uncomfortable. We are hoping you decide to specialize this latter complaint a little further before too long, because at the moment it is used whether the discomfort is amenable to external correction or not, which leads to your father churning through diapers at an ecologically alarming rate.  

You're sleeping right now, and we're listening to songs we like because the only Mozart we have is violin concertos, and for B's sake we try to avoid pairing violins and sleep deprivation. They aren't sure about those Mozart studies, anyway. Basically, we discover the more we read, "they" aren't really sure about much of anything. So I guess we're mostly going to improvise. B is reading up on Montessori schools, even though she should be sleeping or showering or eating. I am taking nearly forever to write this short, bleary blog entry when I should be sleeping or showering or making us some lunch. It's hard to imagine paying somebody $17k to facilitate your self-directed growth, given that you haven't quite figured out how to self-directedly not smack yourself in the eye while you're trying to eat and poop at the same time. It's hard to say much about the process without violating the rule against describing the consistency of individual poops to anybody who hasn't explicitly enquired.  

I think we are probably going to survive these first few weeks. I might not have said this so confidently six hours ago, but six hours ago I was too incoherent to say much of anything, so that's just a guess. Since then B and I have both slept about an hour. B has fed you twice. I've changed five diapers and washed my hands fourteen times and made breakfast and started some laundry and forgotten about the laundry and washed up from breakfast and looked up the causes of post-cesarian abdominal pain and taken B's temperature and checked the real-estate listings for a bigger house and made cryptic notations on my chart of your inputs and outputs and chased the cats around a little and cleaned up the glass one of them knocked off the table where I forgot it and made a grocery list whose contents and then location I have also subsequently forgotten. So you see that B has the far harder role.  

In some ways, bringing you along into the world is easier than I expected. I had somehow not grasped that you would be so specific, right from the outset. I didn't want to say anything before, but in the ultrasounds you always looked a little generalized. Taking care of an infant abstraction sounded really stressful and difficult. Taking care of an incapacitatingly adorable miniature human is exhausting and mind-emptying, but basically simple. Doing so without sleep, of course, is still really stressful and difficult, but on this little sleep even counting to 24 by 4s is really stressful and difficult. Later, when you learn to count, this will mean something to you.  

In the meantime, we are mostly just watching you learn to exist. "LLLLA!", you object. True enough. But it's worth it. You'll see.
 

My daughter Lyra was born last night, 1 May 2007, at 8:33pm. She weighed 9 lbs 2 oz at birth, and 4140 grams after instinctively going metric as her first official act. Her birthday is exactly 27 days after mine and 27 days before B's, and 27 is three to the third, and she is the third of the three of us, so you see that her well-being is numerologically preordained.  

I have changed the first (two) of a million diapers (and have not quite yet lost count).  

We are no longer waiting.
You're not formally due until Thursday, so you're biologically entitled to spend a little while more inside, but we're ready to meet you, so, you know, don't feel obliged to stick it out just to make the number.  

Meanwhile, people keep giving us "helpful" advice on how to lure you into the world. "Chinese food", they say. You're probably not old enough to understand why that's funny, given that you're not old in a technical sense. And yet, almost old enough to suspect that a billion Chinese people probably aren't all giving birth at 32 weeks.  

Presumably they don't all methodically eat fortune cookies after each routine meal, either, although I admit that I haven't personally verified this. (Nor that they do not, in fact, eat fortune donuts after hamburgers.) (As you'll find out, people have ways of small-mindedly oversimplifying culture, and then of expansively and imaginatively recomplicating it.) (We'll go investigate once you're, you know, eating food without using your navel.)  

Anyway, we got three fortune cookes with our last order. Mine said something about happiness. And fish, I think, or maybe the moon. B's dealt, somewhat evasively, with the subject of change. But yours I quote here verbatim: "If you wish good advice, consult your mother."
B points out that along with her Swedish last name, she's actually contributing more Scottish genes than I am, so in a sense our Scottish-name-less daughter will actually be more Scottish than I am. (And explaining what's mathematically and genetically wrong about that "sense" only emphasizes how imaginary our claimed notions of "lineage" are to begin with...)
My daughter will not have my last name. My sister no longer has my last name, my aunt's daughters and their children never did, and my uncle has no children, so this looks likely to be the end of that streak. There was a solid old Scottish clan somewhere way back in my lineage. Too bad their perfectly good name got hideously co-opted by the misguided belief that food most pressingly needs to be fast.  

When B and I got married, it turned out that we both already had a full set of names we were accustomed to using, both for ourselves and each other, so neither of us changed any of them. At some point later, long before we actually decided to have a child, the question arose of what last name we would give them if we did. I proposed that we give any boys my last name, any girls B's. There's no particular moral logic to this (unless you think gender is inherently moral, which I don't), but it seemed to be both fair and deterministic, and unlike hyphenation it could be adopted as a general social practice without imploding abjectly one generation later. When we found out we were having a girl I quickly reaffirmed my support for the idea, and barring some alternate inspiration in the next week or four, that's what we're going to do.  

While we wait for the new system to sweep the planet, I guess I'm probably in for a few years of patiently explaining that yes, she really is my own daughter, created by my wife and I merging our personal genes using the oldest traditional technique available. Our daughter's merged genes will be whatever they are, no matter what name we give her, or who I have to explain it to. It was always wildly inane to think that anything complex enough to matter is carried in names. My lineage is more Sicilian than any other one thing, and probably more German than Scottish, and certainly none of those things in any culturally meaningful sense.  

My daughter will have everything I can figure out how to give her. Or, more precisely, I will offer my daughter everything I can figure out how to offer. What she takes and rejects and keeps and cultivates will be her decisions, so what she will end up having, I have no idea. I've been to the Clan Donald Centre on the Isle of Skye, and in fact I bought my first Runrig CD there, so there's a fairly literal sense in which I found a piece of myself in Scotland. But I've found bigger pieces of myself on street corners in London, and along leaf-cutter-ant trails in Costa Rican rain-forests, and in scaffolded churches in Barcelona and Paris. Even the most mundane pictures of cats or noodles or wires in Tokyo make me ache wildly like I'm absent from part of my self. I want to learn Korean and relearn Swedish, and I want our daughter to learn Spanish and Chinese, or to at least have the opportunities. I want her to have the opportunity to find pieces of herself at the ends of the sky, or hidden behind the goodnight moon, or in other people or new truths or old trees.  

Nothing is ending. Or a thousand things are ending, both huge and trivial, like they do while you're waiting for anything new. It's weird that we're in charge of picking our daughter's name at all, weird that we're going to be making command decisions about another person's life, weird that it will be so long until she has the powers to which she's inalienably entitled. Weird to be sole guardians of such a tiny, squirmy piece of the future, but I guess no weirder than being stewards of our family histories, or of other people's histories we adopt for our own joys and dismays, or of ourselves. No weirder than the idea still is, even after we've been there ourselves to see, that the sky doesn't end there where it disappears with such an emphatic glow.
Site contents published by glenn mcdonald under a Creative Commons BY/NC/ND License except where otherwise noted.