Offering regional and national programs, CIO (and CSO) events bring together some of the most respected names and thought leaders in information technology and security. Presented by CIOs and other senior level executives, these invitation-only programs offer timely topics and strong networking. Learn More »
June 17, 11:30 AM - 12:30 PM U.S./ET (GMT-4)
Larry Bonfante, CIO of the U.S. Tennis Association, will discuss the skills and approaches that your rising IT leaders must learn to be effective in an executive capacity.
How to Handle Your New CEO: Managing Turnover at the Top
June 18, 11:00 AM - 12:00 PM U.S./Eastern (GMT-4)
Turbulent times have increased turnover at the top. Find out what Council CIOs have done to "break in" new CEOs—build relationships, set expectations, educate on the role of IT.
Mid-Market CIO Panel: Tips and Techniques for Improving Vendor Relationships
July 15, 4:00 PM - 5:00 PM U.S./Eastern (GMT-4)
We'll highlight relationship priorities and best practices identified in a Council study, and we'll interact with a CIO panel on the approaches they've used to improve strategic vendor partnerships.
Executive Competencies Assessment Tool
Assess Your Business Leadership Skills with the Council's new benchmarking tool. Rate yourself in change leadership, strategy, customer focus and more.
Learn more about the CIO Executive Council »Apply today for a FREE subscription to CIO Magazine!
May 29, 2007 — CIO —
There was just no way to win. Deere & Co. was storing human resources information for more than 12,000 salaried U.S. employees on its mainframe, but only a handful of business users knew enough structured query language (SQL) to pose useful questions. To make data more accessible, Deere installed software that let PC users extract information by clicking on canned queries. But the more information the users got, the more they wanted--far too much to provide simply by adding additional canned queries. Deere went one step further, installing an English language query tool so that nearly 100 executives can enter just about any question they have about the staff of the heavy equipment maker's domestic operations.
"You ask a question in English, it gives you an answer," says James McGlaughlin, a systems analyst and member of the group that runs the HR database at the company's headquarters in Moline, Ill. He doesn't force people to use the product, English Wizard from Linguistic Technology Corp. in Littleton, Mass. Rather the product's use and popularity have spread by word of mouth to vice presidents, executive secretaries and even the CEO. "An executive may be in another executive's office when he sees it being used, and then he wants it," says McGlaughlin.
Corporate America's databases are rich in information that most mortals can't mine because they don't speak the language, typically SQL. English language querying, also known as natural language querying, is one way to solve the problem. Competitive advantage increasingly depends on a company's ability to make better decisions faster, and the old method of calling the systems analyst to pose a query isn't fast enough. The new generation of point-and-click tools with preformed queries is useful, but they require extensive support and make executives thirsty for even more information. They also don't give much flexibility to the executive searching for an unexpected trend.
The Internet also drives demand for easier database access. In companies with Web-based intranets, employees have begun to expect increasing access to information of all kinds. Both of the natural language query tools on the market, English Query from Microsoft Corp. and English Wizard from Linguistic Technology, can access databases from internal or external Web sites.
"Natural language query technology is underused," observes Jackie Fenn, a vice president and research director in advanced technologies at Gartner Group Inc. She says the technology offers its greatest potential when users are highly knowledgeable about the data but don't know the query language. "Someone in a warehouse who has to be concerned with supplies--that's the kind of user ripe for this tool," Fenn says.