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
Why we need WOS instead of ROS
Moderator: NorbertKrupa
Re: Why we need WOS instead of ROS
Hi!
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).
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.chittaranjan wrote:Why we need to go through a process and why can't we pass it always direct pointing to ROS.
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).
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Why we need WOS instead of ROS
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.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
Checkout vertica.tips for more Vertica resources.