Question-: What do you mean by in-databse processing?
Answer: In-database is processing which is done in or on the database itself rather than done in the SAS, which has several benefits like - Increased security - Less data transfer over the network - Potential for faster data processing
Question-: Why do you say that in-database processing is secure?
Answer: Increased security is possible because you are not transferring sensitive data over the network and processing in the database itself. If there is no data transfer over the network then man in the middle attack can be avoided.
Question-: Why in-database processing is considered faster?
Answer: In database processing can be considered faster because of following reasons.
- Data is manipulated locally, on the data source, using high-speed secondary storage devices instead of being transported across a relatively slow network connection. - The data source might have more processing resources at its disposal. - The data source might be capable of optimizing a query for execution in a highly parallel and scalable fashion.
Question-: What is CAS processing?
Answer: Since SAS 9.4M5, some BASE SAS procedure are enhanced to process data inside SAS Cloud Analytics Service (CAS) which is known as CAS actions. Which can result in faster processing times.