SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Better English Query


A Better English Query

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81859 Visits: 19215
Comments posted to this topic are about the item A Better English Query

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Andy Lennon
Andy Lennon
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1466 Visits: 826
FROM THE INTERVIEW SITE...
Think about that for a minute. It computes the answers. Wolfram Alpha doesn’t simply contain huge amounts of manually entered pairs of questions and answers, nor does it search for answers in a database of facts. Instead, it understands and then computes answers to certain kinds of questions.


This is pure PR, just from the phrasing. Maybe a miracle will happen and this will actually matter to someone, i just can't see that as very likely. "Computing answers to factual questions" sounds like complete nonsense to me. You don't "compute" that the capitol of France is Paris; you look it up. It says it's not a natural language parsing engine, so i don't know what kind of syntax it'll expect.

Maybe i'm missing something major, but this sounds like buzz for it's own sake.
GSquared
GSquared
SSC-Dedicated
SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)

Group: General Forum Members
Points: 30221 Visits: 9730
Considering that I can't even get the Word grammar checker to accept the kind of convoluted sentences I often write, I'm not going to expect much from such a product at this time.

I imagine something like that could, possibly, be made to work with technical writings. Those are usually written to stand pretty much on their own. Anything beyond that, and it takes far too much context and understanding of human foible to get anything from any human communication, whether it be written or spoken.

I can see a computer being able to "compute an answer" to questions like, "what's the freezing point of water, in Kelvin, at sea level?" I can't see one being able to compute "what's the best opening move in chess?", much less "is the US economy up or down?"

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81859 Visits: 19215
Most of our computations are facts. What were the sales last month? That's a fact, however the computation involves looking up rows.

I tend to be skeptical as well, but I'm hopeful that some good technology would come out of this that could be applied elsewhere.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
GSquared
GSquared
SSC-Dedicated
SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)

Group: General Forum Members
Points: 30221 Visits: 9730
Even "what were the sales last month?" is too vague for computer consumption. Are you asking for sales volume, or for what was sold?

If I answered that question with "we sold a toy train on the 1st, and a toy boat on the 3rd, a backgammon set on the 5th, ...(other details)", that would be a valid answer. So would, "we sold six games and two toys". So would, "$125".

Those are all factual questions, and could all be answered by querying a database. But will the computer be smart enough to say, "um, do you mean total volume, or do you want a list of the items sold, or what?", or will it just assume that questions like that always mean total volume, and be really annoying to the guy who wanted something else?

Till computers are smart enough to reply to a question by asking for clarification, and providing some suggestions, they won't be able to handle that kind of situation.

The only reason they work in sci-fi is because of the script. The characters get the data they wanted, because the script writer knows what the intent of the question was, and the voice actor for the computer knows what answer to give, and the actors know that the answer is what they are looking for.


Scene: Command deck of a space battleship, the captain and crew look tense as they watch a screen indicating their enemy's actions. Suddenly, something disappears off the screen.

Captain: Where'd they go?

Computer: To the bathroom, sir.

Captain (looking horribly confused): What?

Computer: The crew members on the dining deck, sir. They went to the bathroom.

Captain: No, you stupid machine, I mean where did the enemy ship go?

Computer: They disappeared, sir.

Captain (veins on his head bulging in frustration): Deck officer, get a DBA in here, NOW! I hate this stupid "verbal query" BS!


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Someguy
Someguy
Old Hand
Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)

Group: General Forum Members
Points: 323 Visits: 579
I would join with Steve in hoping for good things down the road.

For now using specific language for a specific result (SELECT Column FROM specific table) is much quicker and much more useful than working through all of the possibilities of normal colloquial language.

However, if you could add some artificual intelligence and some time to the mix, it might be possible for an executive to have a 'trained' box that knows what the exec wants. 'Total Sales for March' may means 'What is the total that we sold in dollars' for some. It might mean something different for others, but if each person gets their own box the box may be able to figure out what's normally expected.

I often know what my wife wants even if she's stated a request with something less than specificity. I can do that because we've spent a lot of time together. I'm not sure she would have it any other way...

___________________________________________________
“Politicians are like diapers. They both need changing regularly and for the same reason.”
steve.neumann
steve.neumann
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 92
ironically, Steve's English isn't that great...

- "I don't know that anyone every had this built.."

- "If the database or analysis engine can compute answers on it's own," (its)
noeld
noeld
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12314 Visits: 2048
Ahh the PIPE Dreams of English Query ... that's probably why MS throw the towel!


* Noel
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)

Group: General Forum Members
Points: 114855 Visits: 41397
and there will be plenty of model design and development for storing data, performing ETL work,


Shoot... they can't even get it right with simple pretty pictures... DTS, SSIS, and Business Objects Data Integrator are all miserable failures in my eyes.

Besides, you only need one English Query to get along... "Got Beer?" ;-)

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Steve Jones
Steve Jones
SSC Guru
SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)SSC Guru (81K reputation)

Group: Administrators
Points: 81859 Visits: 19215
Is that the query or is it mailto:jeff.moden@supersqlguy.com?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search