After announcing last week that it will lay off 1,400 employees, Yahoo! managers have birthed a new strategy that could recoup much of its soon-to-be-lost engineering talent: Get somebody else to do the work for free. Today, the Sunnyvale-based stagnant engineer pond officially released what it's calling Yahoo! Open Strategy (Y! …
Wow, this financial meltdown sucks and all...
But is sure is great to see people and companies that you've hated for so long go down in flames. BTW, Great article Ted!
Nice to see ...
... that Yahoo no longer warrants the !bangs! in ElReg subject lines ... Not that they ever did, mind.
Open the management!
fire them and let the community manage Yahoo!.
Simple really, I rather enjoy managing things, and whilst I enjoy coding I am fairly selfish when it comes to giving that away :) But, I am open to managing things for free, that's right you heard I will manage things for free.
I am sure they will find a lot of people who will want to manage Yahoo! for nothing, that's the open strategy they need.
Right first port of business manage the Yahoo home page, I am thinking minimal, with links that start to coalesce into sites the user maybe interested in, perhaps with an 80 20% split of old and new. Oh, I am happy to write the code for that but alas it won't be open, only the management will be open!
'In the rest of the world, we'd call that a JOIN'
No, we'd call it a correlated subquery. Not a join. If anyone cares, really.
Which they don't.
A join? where
>>SELECT * FROM social.profile WHERE guid in
>> (SELECT guid FROM social.connections WHERE owner_guid=me)
>> In the rest of the world, we'd call that a JOIN,
I'd call a join something that joins multiple tables. I'd call that a sub-query, but doubtless there will be DBAs along soon to give us the correct term.
I was thinking more along the lines of:
SELECT * FROM social.profile WHERE guid in (SELECT guid FROM social.connections WHERE owner_personality = 'slutty' and owner_sex = 'female' and owner_age < 50)
@ AC: I was thinking more along the lines of
I'd be interested in the official DBA-approved technical term for that 'JOIN' :-)
I think the point is that a half decent writing of that query would have used a join (in the SQL world).
So they get rid of their engineers and open the servers?
What could possibly go wrong with that?
I hope the sand-boxing is strong enough so that disgruntled ex-employees don't wipe the databases or anything.
Reading this it seems to me that Yahoo are rather desperate - though as long as they make a profit they should be able to stay in business I would have thought, just tell the shareholders that there won't any dividends for a few years.
re: 'In the rest of the world, we'd call that a JOIN'
Correcshun: it is a subquery, but unlike wot I wrote it may or may not be a correlated subquery depending on where the variable 'me' comes from. If it comes from the outer select then it's correlated. Elsewise it isn't. Eitherwayswise it ain't a join.
Does this mean we can swear at Ted now? Really strong swears, too, like his? And call him a Fail?
I don't remember reading that syntax in C J Date's book, which is my only exposure to the relational model and SQL (thus making me an expert :)
IIRC you'd use a JOIN on guid and then filter on guid being me. That's the "proper relational" way to do it, but it's declarative in nature. If you run that JOIN naively (i.e. without a heavy-duty optimizer on the DBMS) it will take about forever.
Seems to me that Yahoo!'s method allows you to do the same thing in a more procedural way. That means a naive implementation will do it fast or that the optimizer works less hard.
It makes sense that you probably wouldn't expose JOIN to the hoi polloi. Otherwise the hoi polloi would regularly crap on your servers.
Or, maybe they aren't using an RDBMS for this, and have their own query engine that simply doesn't support JOIN.
... now all the experienced DBAs can tell me how wrong I am :)
This story was so boring I couldn't finish it. Not bad writing, it's just such a ho-hum subject I couldn't care less. No, really, I tried to care less and found I was already at the absolute limit of apathy.
So I guess yahoo and especially their social site junk has actually reached 0 Kelvin. There's probably jokes there about the LHC or the warmth of women on yahoo social sites, but the sheer lame-ality of yahoo stories have driven the will to try out of me.
The comments were far more interesting. And yes, Correlated sub-query is the proper term.
"IT?" because I'm not sure what yahoo has to do with IT. Please don't explain it to me though.
@What's in a name?, @AC 11:03
It is indeed a non-correlated subquery, but no doubt the query optimiser will promote it to a join. Provided that it isn't fired first.
Of course, we have to hope they are careful about what data is exposed...
Bring! back! the! !!! for! Yahoo! article! titles!
It is a mandatory feature.
Shame on the editor for not catching it.
Yahoo doesn't have a business model, so they may as well join the open sores movement and have a big "we don't have a business" party!
Yahoo had their chance to sell to MS but the didn't, now they can't afford developers and are quickly going to dry up and die. I'm glad. No one really needed them (or social networks) anyway.
without the swearing it's just boringly factual (and possibly factually incorrect, given the learned comments above about joins/subqueries and so on ...).
I for one, felt cheated and so to misquote the master: get back to the swearing, cockbite
- Pic Mars rover 2020: Oxygen generation and 6 more amazing experiments
- Microsoft's Euro cloud darkens: US FEDS can dig into foreign servers
- Plug and PREY: Hackers reprogram USB drives to silently infect PCs
- Review Fiat Panda Cross: 'Interesting-looking' Multipla spawn hits UK
- Analysis PEAK LANDFILL: Why tablet gloom is good news for Windows users