How To Put The BI In 64 Bits? - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
9/9/2005
04:17 PM
50%
50%

How To Put The BI In 64 Bits?

The more an analytic tool can hold in virtual memory, the larger its data sets, such as OLAP cubes, can be -- and the faster it can perform.

The more an analytic tool can hold in virtual memory, the larger its data sets, such as OLAP cubes, can be — and the faster it can perform. Extract, transform and load (ETL) operations can bypass bandwidth limitations if they can cache large sets of data in virtual memory. A database infrastructure with ample addressing space can better handle compute-intensive activities like concurrent and complex queries. Optimization and decision models can also perform better. In other words, business intelligence (BI) is a fertile field for 64-bit computing. So why hasn't much cropped up?

Trendspotting

Performance management software once existed almost purely in the financial domain. But now it's increasingly finding a place in departments associated with operations, lines of business and management. Those departments include sales, marketing, customer service, operations and human resources.

Last year, only 30% of the customers of Applix, maker of the TM1 performance management suite, said they were using TM1 for nonfinancial applications. The 2005 poll shows that 53% now do.

Although the finance department usually has a greater affinity for management by numbers than most other departments, business results depend greatly on what happens on the operational level. More businesses seem willing now to exert the extra effort to quantify and track performance in less culturally prepared areas.

The explanation might have something to do with risk aversion on the part of vendors and buyers. For buyers, switching to 64-bit operating systems means accepting the small subset of drivers and security applications available for such environments.

Regardless, BI vendors have been slow to release 64-bit applications particularly to the new price/performance leaders, AMD Opteron and Intel Xeon EM64T. Part of the problem is deciding which 64-bit architecture to support, because each one requires different code compiles and reprogramming. Also there is the question of which operating system (OS) to support on the various architectures. The choice isn't trivial, because each OS has different 64-bit capabilities with regard to maximum memory, virtual memory space, dual core CPUs, virtual systems, and other 64-bit performance components. Finally, 64-bit BI applications may not yet have a large enough buyer base. A representative of BI vendor MicroStrategy recently admitted in an e-mail disclosed to Intelligent Enterprise that its 64-bit applications seem to be available ahead of demand, for example.

All hope is not lost, however. Two software technologies related to BI are leading the charge to 64 bits: compute-intensive analytics and, especially, databases. Databases were ported to 64-bit environments like HP Tru64, HP/PA-RISC and Sparc64 well before x86 hardware and OSs were available. So it's not surprising they're leading x86 64-bit conversions as well. Oracle and IBM have 64-bit Linux versions and Microsoft has recently catapulted into third place in the TPC benchmarks with its 64-bit version of SQL Server 2000 on Windows Server 2003 x64.

The hardware is also becoming more accessible, in terms of both availability and price. 64-bit x86 processors from both AMD and Intel are now making 64-bit computing practical for a much broader range of servers and workstations--and at well under $50,000 for 5GHz (total dual core) CPU, 5GB memory and 5TB disk space.

True, BI applications converted to 64-bit x86 architectures are still hard to find. Even SAS, with its great reputation among the technical elite, has so far limited its 64-bit versions to Itanium and PA-RISC. But SQL Server, IBM DB2 and Oracle 10g all have significant BI capabilities in their databases. Also, the MicroStrategy 8 BI platform has been ported to Red Hat Linux on x86 Xeon processors. And a few small companies such as QlikTech are promising 64-bit versions.

Because demand for 64-bit BI is bound to increase eventually simply because of the tidal wave of data coming from such sources as RFID deployments, business activity monitoring, financial monitoring and compliance monitoring, you have to wonder whether the database vendors will leap ahead of the pure-play BI vendors in the market. Database systems — engineered to be more scalable, secure and reliable than BI platforms — are naturally going to be stronger as organizations work with the larger data sets on 64-bit platforms. In other words, 64-bit computing could introduce a sea change in the BI industry every bit as dramatic as the upcoming entry of Microsoft into the market.

-- Jacques Surveyer

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

News
Becoming a Self-Taught Cybersecurity Pro
Jessica Davis, Senior Editor, Enterprise Apps,  6/9/2021
News
Ancestry's DevOps Strategy to Control Its CI/CD Pipeline
Joao-Pierre S. Ruth, Senior Writer,  6/4/2021
Slideshows
IT Leadership: 10 Ways to Unleash Enterprise Innovation
Lisa Morgan, Freelance Writer,  6/8/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Slideshows
Flash Poll