Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

using the VA data preparation tool (data query) to manipulate lasr tables

Reply
Contributor
Posts: 59

using the VA data preparation tool (data query) to manipulate lasr tables

my question concerns the amount of memory the results of a data query occupies in lasr as opposed  to the tables being loaded to lasr.

example

i have 2 tables in lasr (customer information,  sales detail data by day)

for example sake, lets say the customer is 500 meg in lasr and the sales detail is 500 meg in memory

 

each of the 2 tables stands alone in lasr and occupies in memory space in lasr ( 1 gig)

if i join these tables using the "Data Preparation Tool" to create a 3rd table of sales by customer, does the 3rd table occupy more than the physical memory space occupied by the individual tables? (at least another gig of memory) 

 

or is this type of join more "logical" whereas this is a virtual join and does not consume lasr memory in proportion to the physical tables.

 

thx

Respected Advisor
Posts: 2,899

Re: using the VA data preparation tool (data query) to manipulate lasr tables

I'm guessing you are asking if it is possible to store an SQL query VIEW in a LASR library. The view takes up virtually no memory but would dynamically join the two input tables when used. This reference confirms that views are possible:

 

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p0ci6glvfbc1kin1ipn3u...

 

I'm not sure what the impact on performance would be using a view - it would be slower than a table. Try it and let us know how you get on.

Esteemed Advisor
Posts: 5,063

Re: using the VA data preparation tool (data query) to manipulate lasr tables

Post a Question
Discussion Stats
  • 2 replies
  • 111 views
  • 2 likes
  • 3 in conversation