Why is flash good for data warehousing?

Posted by VIOLIN SYSTEMS on Apr 26, 2013 12:41:10 PM

Flash is about latency and IOPs so why would it be good for Data Warehousing or Business Intelligence?

Excellent question.  Yes, the typical marketing and wow-factor stats around flash are based on latencies and IOPs (Input Output Per Second).  Data warehousing (DW) and Business Intelligence (BI) is normally a throughput game, so what gives?

Read More

Topics: MySQL, Oracle, BI, Big Data, Business Analytics, Business Intelligence, data warehouse, database, ETL, flash, flash storage, reporting, SSD, Sybase, SQL Server

Flash for Transactional Workloads

Posted by VIOLIN SYSTEMS on Apr 26, 2013 12:41:01 PM

Transactional workloads are commonly defined as being small atomic pieces of work.  This is in contrast to decision support, Data Warehouse, Business Intelligence or otherwise labeled reporting systems that require fewer, larger, more sequential workloads.  Updates, inserts, deletes and even small result-set selects are all included in OLTP, transactional efforts.

Read More

Topics: OLTP, Oracle, flash, flash storage, SSD, SQL Server, transactional

OLTP Performance: The Violin Advantage vs. Exadata and SSDs

Posted by VIOLIN SYSTEMS on Feb 14, 2013 12:58:07 PM

Violin's own Ashminder Ubhi, an Oracle expert, recently tested the OLTP (online transaction processing) storage performance of Violin Systems arrays vs. Exadata and SSD-based solutions using the popular SLOB benchmarking tool. Check out Ubhi's blog post on OLTP performance for the full story.
Ubhi's benchmarks highlight how a purpose-built flash memory array can offer benefits over products which are not designed to get the performance benefits of NAND flash technology – especially for an OLTP workload.

Read More

Topics: Oracle, Exadata, SSD

Violin and Dell Showcase Collaborative Database Solution at Dell World

Posted by VIOLIN SYSTEMS on Dec 17, 2012 4:30:37 PM

Violin Systems was a Bronze Sponsor at Dell World 2012 and presented a powerful collaborative solution with Dell at this year’s conference, featuring PowerEdge servers and Violin 6000 Series flash memory arrays.

Read More

Topics: Oracle, Red Hat Linux, VMware vCenter