21 October 2017

Sun and Sybase break one trillion row data warehousing benchmark

05 October 2004  |  1695 views  |  0

Sun Microsystems, Inc. (NASDAQ:SUNW) and Sybase, Inc. (NYSE:SY), today announced that they have created the largest, verified data warehouse in the world, according to an independent audit conducted by InfoSizing, Inc.

Larger data warehouses are becoming critical to enterprises that must store, track, and manage a growing volume of data to meet government compliance regulations. The Sun and Sybase iForce Enterprise Data Warehouse (EDW) Reference Architecture -- consisting of Sun Fire servers, Sun StorEdge storage sub-systems and Sybase IQ, a highly scalable analytical engine -- enables customers to set up such highly scalable data warehouses in days instead of months, while also minimizing storage costs.

In addition, the companies are announcing joint customers that include Nielsen Media Research, American Airlines, Bank of Montreal, BizRate.com, Allianz Insurance, U.S. Department of Transportation, Telefonica, Samsung Card, Chohung Bank and LG Card.

Using its patented data compression, Sybase IQ needed less than 55 terabytes on the Sun StorEdge storage sub-systems to store the 155 terabytes of input data, providing proof that Sybase IQ can dramatically reduce storage costs by up to 90 percent over competitors. Additionally, support costs and data center footprint were lower when compared to conventional databases, which would require up to one petabyte (1,000 terabytes) of storage for this example. Sun's Chip Multi-threading (CMT) technology and Sybase IQ showed no slowing in query or data loading speed as query submission rates increased five fold, allowing companies to make split-second decisions as required by financial transactions.

With one trillion rows of data, the Sun and Sybase data warehouse can hold enough data to track the history of all world financial trades on all stock exchanges or hold enough data to track all credit (and debit) card transactions in the entire world over the last seven years.

To reduce the risk and associated costs with implementation and availability of the EDW Reference Architecture, customers can select from several Sun services offerings, such as Sun Preventive Services, Managed Services, and Highly Available service packs. Reference Architectures offer a tested way for customers to build important network computing infrastructures based on best practices.

According to Francois Raab, president, InfoSizing, Inc., "The size of the iForce Enterprise Data Warehouse Reference Architecture is impressive, but size is only a part of the story. Organizations are faced with an exploding volume of enterprise data from online transactions to RFID transmissions. With the EDW Reference Architecture, they are not only able to scale for this volume, but are able to do so with a solution that can easily scale dynamically and reduces overall storage needs."

The impressive results of the new InfoSizing report, follow a pattern of industry recognition for Sun and Sybase IQ. These include:

-- Securing the top ten awards for decision support systems in Winter Corporations' latest Top Ten Program.

-- Leading the industry on the best price-performance ever published on the TPC-H benchmark at 100GB, 300GB and 1TB.

"Our data warehouse is by far one of the largest I've ever seen and it's going to grow considerably every year. This report increases my confidence that the hardware and technology [Sybase IQ and Sun] we have selected will be able to keep up with our demands as we grow it to the 30 terabyte level," said Timothy S. Geary, Data Resource Manager, Information Technology, National Product Group, Nielsen Media Research.

Comments: (0)

Comment on this story (membership required)

Related company news

 

Related blogs

Create a blog about this story (membership required)
visit www.innotribe.comvisit www.atos.netvisit www.fivedegrees.nl

Top topics

Most viewed Most shared
HSBC partners Bud for open banking trialHSBC partners Bud for open banking trial
8841 views comments | 22 tweets | 26 linkedin
satelliteGates Foundation backs Ripple collaboratio...
8633 views comments | 13 tweets | 10 linkedin
IBM uses blockchain to improve cross-border payments processingIBM uses blockchain to improve cross-borde...
7712 views comments | 9 tweets | 17 linkedin
Sibos 2017: API or the highwaySibos 2017: API or the highway
7186 views comments | 10 tweets | 22 linkedin
Eight banks form joint venture to launch blockchain trade platformEight banks form joint venture to launch b...
6791 views comments | 14 tweets | 23 linkedin

Featured job

Find your next job