 |
|
|
|
|
|
| |
| |
|
|
|
|
| |
| |
|
|
> SELECT *
> FROM EventRecord AS X, EventRecord AS Y, EventRecord AS Z
> WHERE
> X.ExperimentID = Y.ExperimentID AND
> Y.ExperimentID = Z.ExperimentID AND
> X.EventID = 0 AND
> Y.EventID = 2 AND
> Z.EventID = 1 AND
> X.EventDateTime < Y.EventDateTime AND
> Y.EventDateTime < Z.EventDateTime;
>
> Or similar. (It's been a while since I did SQL...)
Oh cool that helps a lot, I'm copying and pasting that to a file somewhere
for reference, thanks. I still need to order myself an SQL book...
I guess that's the sort of question they should ask you at an interview :-)
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
scott wrote:
>> SELECT *
>> FROM EventRecord AS X, EventRecord AS Y, EventRecord AS Z
>> WHERE
>> X.ExperimentID = Y.ExperimentID AND
>> Y.ExperimentID = Z.ExperimentID AND
>> X.EventID = 0 AND
>> Y.EventID = 2 AND
>> Z.EventID = 1 AND
>> X.EventDateTime < Y.EventDateTime AND
>> Y.EventDateTime < Z.EventDateTime;
>>
>> Or similar. (It's been a while since I did SQL...)
>
> Oh cool that helps a lot, I'm copying and pasting that to a file
> somewhere for reference, thanks.
It seems so easy when you already know how, eh? ;-)
> I still need to order myself an SQL book...
You wanna know what I have on *my* bookshelf?
http://www.amazon.com/Introduction-Database-Systems-C-Date/dp/0201385902
As I understand it, this is considered one of the "seminal texts" on
relational databases. Take a look at those stats: it's almost a thousand
pages, and weighs over 1.6 Kg. In other words, it's a *tome*.
And I've read it, cover to cover.
Even I cannot comprehend the relational calculus though. Relational
algebra, sure. But relational calculus? Nah.
> I guess that's the sort of question they should ask you at an interview :-)
What, as opposed to "what is the unladen velocity of a swallow?"? 0;-)
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
>>> Maybe a few decades ago, but not anymore.
>>
>> I thought it was more like a few centuries?
>
> Don't think so, ask your dad how what % of the population went to
> University when he was that age.
Mmm, OK. Well I certainly don't know, I just thought that degrees being
rare dated back to the days when reading and writing was uncommon.
BTW, apparently my dad has a qualification in technical drawing. o_O
>> Hey, if *I* can actually get one, it can't be that rare.
>
> What % of people in Milton Keynes do you think can program in a
> functional language, know half of what you know about knot theory, and
> half of what you know about fourier transforms etc? What % would even
> be capable of understanding? I can tell you, not many.
On the other hand, I sat in a room full of about 80 people, and almost
all of them got a Computer Science degree. Most of them *still* don't
know what a "segmentation fault" actually is, but they all got their
degrees.
Hell, most of them weren't even all that interested in computers. (Uh...
WTF?) I never did figure that one out!
Anyway, as to what percentage of the population understand the Fourier
Transform, I wouldn't like to say. I don't meet many people... I'm sure
in any kind of competetive process though, you're going to meet a hell
of a lot of them.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
> What, as opposed to "what is the unladen velocity of a swallow?"? 0;-)
I'd say about 30mph because when driving at that speed sometimes birds
appear to be going about the same speed :-)
Some of the gems I've heard:
Estimate the mass of air in this room.
Would birds be hotter or colder with fur on their legs?
Draw x^infinity + y^infinity = 1
Prove which is bigger, e^pi or pi^e
But the best one was at my university interview, the guy had given me some
quite tricky geometry/trig problem to solve and I think I almost had the
answer, but the equation was a huge mess and I was dreading to try and solve
it for x (or whatever, it had squares and cubes all over the place). But
then at that point he says "great, you seem to have the answer if you just
tidy it up a bit, let's move on". Was the best I could have hoped for!
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 20-2-2009 14:30, Invisible wrote:
>>> The question is: Do you think I should do a PhD?
>>
>> Yes, but not in computer science. I suggest something applied. Not
>> because you like it, but because you could be good at it and it would
>> force you to meet other people.
>
> So, what you're saying is, I'd be doing something I don't want to do,
No I said you would not do the things that you now think that you would
want to. Because I think you have the wrong impression of what you like. ;)
> and being forced to get yelled at by a bunch of people?
Last time somebody yelled at me... let me think... never happened.
Last time I yelled at somebody ... also never happened.
What makes you think working includes yelling?
> And yet you expect me to be "good" at this? Hmm...
If you put it that way: I think you might be an expert at being yelled at.
>>> I seem to vaguely recall somebody (I forget who) claiming to know who
>>> to go to for this kind of thing, and offering to help me arrange it.
>>
>> If you had an MSc I am pretty sure I could have arranged it. With a
>> BSc it may require a bit more work.
>
> Heh, oh well.
But not impossible.
>> Oh, and it would require you to not live with your mother anymore.
>
> Not living with the She Devil sounds dreamy. Having to copy with a whole
> bunch of other stuff sounds less inviting.
Just wait for the full offer ;)
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
> On the other hand, I sat in a room full of about 80 people, and almost all
> of them got a Computer Science degree. Most of them *still* don't know
> what a "segmentation fault" actually is, but they all got their degrees.
That's exactly my point, and is why simply having a degree doesn't really
help you in life, they are too easy for anyone to get.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
>> What, as opposed to "what is the unladen velocity of a swallow?"? 0;-)
>
> I'd say about 30mph because when driving at that speed sometimes birds
> appear to be going about the same speed :-)
Heh. I don't think you can try that on horseback. (Although after
several months I have yet to discover what the typical speed of a horse
actually is.)
> Estimate the mass of air in this room.
3 grams?
> Would birds be hotter or colder with fur on their legs?
Presumably this varies depending on the external temperature?
> Draw x^infinity + y^infinity = 1.
__ __ __ __
|__|__| |__|__|
\ / | \ / /|
\ / | \ / -------- |
\/ ---+--- \/ |
/\ | / -------- |
/ \ | / |
/ \ / --+--
...oh, wait, maybe you meant the *graph* of this?
> Prove which is bigger, e^pi or pi^e
Hmm. Well two cubed is 8, while three squared is 9, so I'm going to go
with pi^e being larger. Presumably "proving" this would simply involve
slightly more arithmetic. :-P
> But the best one was at my university interview, the guy had given me
> some quite tricky geometry/trig problem to solve and I think I almost
> had the answer, but the equation was a huge mess and I was dreading to
> try and solve it for x (or whatever, it had squares and cubes all over
> the place). But then at that point he says "great, you seem to have the
> answer if you just tidy it up a bit, let's move on". Was the best I
> could have hoped for!
Heh, neat.
I remember spending about a week trying to figure out how Euler's
relation allows me to compute the complex exponent of a complex
quantity. I don't know why it took me so long; it's really quite simple
when you look at it. I think I just confused myself too much to see it...
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 20-2-2009 15:18, Invisible wrote:
> Anyway, as to what percentage of the population understand the Fourier
> Transform, I wouldn't like to say.
In my experience very little. Which does not stop them from using it
when a package provides it.
Proposition #6 from my thesis: the use of FFT to extract clinically
relevant parameters should be forbidden in the field of cardiology.
> I don't meet many people... I'm sure
> in any kind of competetive process though, you're going to meet a hell
> of a lot of them.
Then why do have to import our PhD students? After Dutch and English,
Russian is now the third language in our lab. Two years ago it was Italian.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
>> Anyway, as to what percentage of the population understand the Fourier
>> Transform, I wouldn't like to say.
>
> In my experience very little. Which does not stop them from using it
> when a package provides it.
> Proposition #6 from my thesis: the use of FFT to extract clinically
> relevant parameters should be forbidden in the field of cardiology.
Uh... I was under the impression that most of the useful information in
a cardiagram is in the time-domain anyway...? (OTOH, IANAD.)
>> I don't meet many people... I'm sure in any kind of competetive
>> process though, you're going to meet a hell of a lot of them.
>
> Then why do have to import our PhD students? After Dutch and English,
> Russian is now the third language in our lab. Two years ago it was Italian.
No idea.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
On 20-2-2009 15:51, Invisible wrote:
>>> Anyway, as to what percentage of the population understand the
>>> Fourier Transform, I wouldn't like to say.
>>
>> In my experience very little. Which does not stop them from using it
>> when a package provides it.
>> Proposition #6 from my thesis: the use of FFT to extract clinically
>> relevant parameters should be forbidden in the field of cardiology.
>
> Uh... I was under the impression that most of the useful information in
> a cardiagram is in the time-domain anyway...?
Spot on.
I once saw this procedure to find a phenomenon that occurs every other
beat.: Find the time instant in every beat where you expect the change.
Create a time series of that. Do an FFT. look at the amplitude of the
center frequency. Ok, I admit it works and you can include a spectrum in
your paper...
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
|
|
