Question-101: 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-102: 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-103: 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-104: 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.

Question-105: What is the reason that processing using the CAS is faster?

Answer: There are following reason because of which CAS is considered faster

• The CAS server processes the in-memory tables instead of transferring the data across a relatively slow network connection between the server and the SAS client machine.
• The hardware for a CAS server typically has greater processing resources at its disposal.
• The majority of CAS actions are scalable for multithreaded processing. For large data volumes, distributed servers use multiple hosts to perform massively parallel processing.