Encryption tools enhance 3000 security
Eloquence beefs up data security, encryption

UDALink expands access to 64-bit databases

WinSQLServer08 MB Foster has announced the release of a 64-bit version of its UDALink data access client. The new version will give HP 3000 managers a fast link into the expanded data spaces of SQL Server 2008 and Windows Server 2008, as well as a way to pump 3000 data into the Eloquence 64-bit database.

The versions of the Windows enterprise tools are becoming more common in the strategies of the user base running HP 3000s in homesteading, or those planning to migrate to a Windows environment. While many applications don't need the vast headroom 64 bits provides, CEO Birket Foster said the latest generation Microsoft products represent the future for Windows.

Eloquence-logo-frei  "Microsoft has been pushing toward 64 bits in their operating systems and databases," Foster said. This matters to the MB Foster customers because the most frequently used configuration is having UDALink extracting data from IMAGE for a SQL Server database. The biggest value in using a 64-bit version of the database or the Windows OS is handing much more data in memory. Foster described the capacity as the power to identify "2,000 unique things for every person on the planet.

The new version means the same client can work with Unix, Windows, Linux and the HP 3000. The client talks to IMAGE, but also to Eloquence in both 32-bit and 64-bit versions of that database.

64 bits has provided this kind of prospect for a world that hasn't demanded it yet. Microsoft originally said it would only sell a 64-bit version of the SQL Server 2008 database. But so much of the Microsoft customer base, including HP 3000 sites also employing Windows, is rooted in 32-bit applications that a 32-bit SQL Server '08 was eventually released. A SQL Server Express version is free with limits on database size.

Microsoft is so far out in front of demand on 64 bits that its own Office 2010 isn't completely ready to support the expanded memory space.

But 32-bit versions of the software can only address items in a memory space of up to 4GB. "Part of this is how much application ability can you put together for really fast access inside a database," Foster explained. He added that "99 percent of the world doesn't need it," even though it represents Microsoft's roadmap direction for OS and databases.

Customers who'd be likely to need 64-bits today might be detecting real-time fraud in Visa or phone company transactions. "Or putting together an application that tracked every airline flight's data going forward for a year," Foster said, down to passenger data, on-time arrivals that could add up to more than 4GB of objects.

But he said some customers are buying 64-bit capability and want to employ the UDALink tools with the full capacity of a 64-bit data space. (IMAGE/SQL addressed the 4GB dataset limit with Jumbo datasets at first, then with the Very Large Datasets release.) 64 bits "is good because you get to address very large sets of memory. You can do a lot of transactions without ever writing to disk. The bad news is that unless you've just posted that data to disk, a failure of database memory or power flushes all the transactions sitting in that memory space."

By using the large memory stacks and posting in background, a customer's app can operate at the speed of its memory, rather than the IO speed to disk. "A large number of customers are building 64-bit-ness into their architectures, because the default Microsoft ships you is for the 64-bit database," Foster said. "You can have a trillion-row table and not sweat it. You can sort the whole thing in memory."

The Microsoft changes toward 64 bits "are a big favor for all the hardware vendors," forcing larger storage and more network bandwidth. "It breaks everything again. Lots of these things are done to deliberately break your infrastructure, so you have to buy more. The channel will love Microsoft because they broke it one more time. But we as users are starting to hate that. Unless you're American Airlines trying to track every passenger, you don't have that much data."

But MB Foster must support the customers who take Microsoft's 64-bit defaults, just as the company has kept pace with every other Windows change in database and OS designs. "64 GB of RAM was probably the right amount anyway" for a Windows environment, he added. The churn from bigger memory spaces is pushing software companies everywhere to accomodate Windows that open wider than ever.