IO: Understanding Random vs Sequential

Posted by VIOLIN SYSTEMS on Aug 15, 2018 10:59:13 AM

 

Read More

Topics: IO Randomization, MySQL, IO scheduling, Storage for DBAs, SQL Server, Extreme Performance

Modernizing vs Revolutionizing

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

SSD’s are like cordless phones and DVD’s.  They made an improvement on an existing technology but didn’t revolutionize its use.  In technology there is a difference between the concept of modernizing and revolutionizing.  Modernizing is finding a way to do the same thing, just a little bit faster or little bit easier.  Revolutionizing is either eliminating or vastly changing how something is done.

Read More

Topics: MySQL, OLTP, Oracle, database, flash, flash storage, reporting, SSD, Sybase, SQL Server, storage architecture, transactional, Virtualization

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