Why we need WOS instead of ROS

Moderator: NorbertKrupa

Post Reply
chittaranjan
Newbie
Newbie
Posts: 2
Joined: Fri May 15, 2015 7:07 pm

Why we need WOS instead of ROS

Post by chittaranjan » Sun Jul 26, 2015 6:55 am

Hi,

I have a question like why we need to load data to WOS and then ROS instead we can directly load data always to ROS.Anyway in ROS data also stores with encoded and Compressed.Why we need to go through a process and why can't we pass it always direct pointing to ROS.

Thanks

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Why we need WOS instead of ROS

Post by id10t » Sun Jul 26, 2015 12:43 pm

Hi!
chittaranjan wrote:Why we need to go through a process and why can't we pass it always direct pointing to ROS.
Depends on your requirements. Data in WOS is a memory-resident data(ROS - on storage), the WOS stores records without data compression or indexing - it's done to support very fast data load speeds.
So if your requirements is "LOAD DATA" and release resources as much as possible so use in WOS, but if your requirements is "PREPARE DATA" for processing so use in ROS(direct).

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Why we need WOS instead of ROS

Post by NorbertKrupa » Sun Jul 26, 2015 5:48 pm

chittaranjan wrote:Hi,

I have a question like why we need to load data to WOS and then ROS instead we can directly load data always to ROS.Anyway in ROS data also stores with encoded and Compressed.Why we need to go through a process and why can't we pass it always direct pointing to ROS.

Thanks
WOS is primarily used for trickle loading. Vertica will then efficiently consolidate and move data from WOS into ROS. You wouldn't want to load hundreds of single rows directly to disk every 15 seconds.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “New to Vertica”