Computer programming hasn't changed much in the last 40 years, but we are only at the beginning of a revolution in the use of business analysis software, says Jim Goodnight, chief executive officer of SAS Institute, which he co-founded in 1976.

At SAS's Canadian headquarters in Toronto, Goodnight briefed ComputerWorld Canada on how business intelligence can help banks and retailers, what Teradata brings to the table, the renaissance of dumb terminals, the sub-prime mortgage crisis and why SAS employees don't have to work in cubicles.

We are in the "early stages" right now of the next "revolution" in computing, Goodnight said. Banks have "more data than they know what to do with" but do not always have up-to-date records of all of a client's dealings, whether that's credit card, chequing account or insurance. "Companies are turning to these vast amounts of data that they have and using analytics to help forecast the future, predict customer behaviour," he said. "We've done some really interesting work in the retail space."

Using software that analyzes databases, companies with hundreds of stores can select the best price for each item the next day, he said.

"If you've got 500 stores in Canada and you price each item each day, how do you do that when you've got 200,000 or 300,000 different items at each store? These are some very large research problems that we're dealing with and the retailers are now all realizing that they need to turn more to analytics to help them with the bottom line."

SAS continues to work with data warehouse vendor Teradata, a former NCR company. Customers can now run SAS software on Teradata warehouses, and Goodnight said the next combined offering will probably be available in 18 months. Using SAS and Teradata, users can send SQL queries to individual nodes on a grid.

"We continue to work with Teradata trying to get them to loosen up on their user-defined functions or UDFs as we call them, this allows us to put our code down on their compute nodes," Goodnight said. "Its target is distributed computing. You have a whole network of computers that you can be using at the same time. The thing that we like about Teradata more than anything else is that each of the nodes on the grid owns its own part of the database. So if you have 16 processors then your database is broken up -- each sixteenth owned by each processor. So when we process data we can send some of our own computational work down to individual nodes and it can be done on the 16th of the database each time and then the results merge back together. " Click here to find out more!

After 40 years in the IT industry, Goodnight says programming really hasn't changed all that much, though virtualization helps companies save energy.

"Not a whole lot has changed since I first started as a programmer back in the late 60s. Programming is still pretty much the same. It's really funny. When the first IBM displays came out -- the 3270s -- we busily worked on making sure our software ran interactively. The 3270s we called dumb terminals. It's funny how we've come almost full circle, we've come from that to the desktop computing and now we're shifting back to the dumb terminal approach, but now we're using laptops that display a browser."

Virtualization lets companies get more users on the same hardware, which lends itself to SAS's efforts to be a greener company. For one thing, the Toronto headquarters uses rainwater collected at the rooftop for its toilets and urinals, a SAS Canada spokesperson said.