|
Please sign our guestbook! |
|
Putting past failures in Natural Language Processing aside, I decided to play with a version of Access ELF 2000. The product impressed me.
It took less than an hour to create a bunch of select queries and run ELF against those queries by selecting "custom" in the set up. I saved close to 59 developer hours...I got all our queries to work that I thought our users would want. The response time was fast, and ELF even popped up the Access spellchecker when it couldn't understand my bad typing.
Access ELF 2000 is a great product. It gives your users the ability to query your databases without having to learn any SQL at all. As a developer, you can customize Access ELF as you see fit... the "maintenance" that I'm required to do to my existing applications usually consists of creating new reports. With Access ELF, that burden is now much less.
Stephen Forte is a Contributing Editor of Access/VB/Office Advisor Magazine, President of the NYC Access and VB Developers Group, and co-author of both Access 2000 Development Unleashed (SAMS 1999) and the Microsoft Jet Database Programmers Guide (MS Press 1999).
"Review of VB ELF"
--Pete Forde, Dateline: 01/02/98
...Some of today's best selling applications have absolutely terrible user interfaces. My good friend Alan Cooper (the creator of Visual Basic) is full of great suggestions for those who are willing to listen; many of these are encapsulated in his book, About Face. This is probably my favorite book.
Fortunately, some people are willing to listen. Jon Greenblatt, and the folks at ELF Software have come up with an ActiveX server they call (I was shocked) VB-ELF. This truly great product allows a user to type in a question, in natural English, and it will convert it to an SQL query ...
If you are interested in what this concept has to offer, you should really check out the ELF Software website. Both from a developer's point-of-view, as well as that of the end user, this interface is a tremendous step forward, especially if that developer is developing applications for the public, be they kiosk terminals, or even
web pages and intranets.
I like programs that feel very well thought out. This is definately one of those rare programs ... Oh, and did I mention the free tech support?
Originally appeared in http://visualbasic.miningco.com
From the October 1997 review of Access ELF in
*Reflects 1997 introductory pricing
Access ELF...1996 ZDNet/PC Magazine Shareware Awards Finalist
Of the thousands of shareware products published, ZDNet/PC Magazine
chose only 5 finalists in the application category.
ZD Net Software Library: ***** 5 Stars -- their highest rating!
Superior Shareware, August 1996
--Roger Jennings, writing in Visual Basic Programmer's Journal Sept. '95
I gave ELF a try and was impressed by its ease of use and accuracy in
interpreting natural-language input. ELF's ability to generate a series
of complex SQL SELECT statements from a deceptively simple sentence is
uncanny... As an example, the question "Which customers have placed more
orders than average?" produces five sequentially executed queries, most
with complex JOINs and one containing the DAvg() domain aggregate function
to compute the average number of orders. You might be able to write
a more elegant query in Access SQL to return this result set, but I bet
you can't beat ELF's speed: 12 seconds to do the SQL translation, plus
three seconds to execute the five queries...
One of ELF's strongest features is the ease with which it creates Access
graphs for users, making Access truly an end-user query tool. All you need
to do is replace "Show me" (or its equivalent) with "Graph" and
write a query that you expect to return a reasonable number of rows, say
11 or less. Users can activate the chart and change the chart type
themselves.
Access's drag-and-drop query design methodology is pretty quick, but ELF
is even faster. At the current progress rate...it won't be too long until
hands-off natural-language querying becomes the norm.
Last Updated: November, 1998 |