A user has 10 k means Clusters from a data set and wants to build 10 linear regression models with all these clusters separately. How to do this using loops in R?

Question

Ranjana Admin · Accepted Answer

Yes DML operations (update/insert/ delete) are allowed in the procedure also (DDL: such as create/ alter/drop/ truncate) is also allowed in the procedures.

In case if the procedure will get executed in parallel then DDL on a permanent table is not recommended as there could be chances that one procedure has already created a permanent table and another procedure is trying to create a table then one procedure may fail.

However it is recommended to use DDL statements if they exist and transactions should be used elsewhere there will be a chance of failing a procedure

Myjdw · Answer

DML operations (INSERT, UPDATE, DELETE) are allowed in stored procedures, as well as DDL operations (CREATE, ALTER, DROP, TRUNCATE).

MyJDW

However, when executing procedures in parallel, using DDL on permanent tables is not recommended. If one procedure creates a table while another tries to do the same, it could lead to conflicts and failures.

To avoid issues, it's best to:

Use DDL statements cautiously within procedures.

Implement transactions properly to ensure data consistency.

Consider using temporary tables if necessary to prevent conflicts.

This ensures better reliability and minimizes the risk of failures in stored procedures.

A user has 10 k means Clusters from a data set and wants to build 10 linear regression models with all these clusters separately. How to do this using loops in R?

Your answer

2 Answers

More Data Science discussions

Learn & Explore

Data Science Tutorials

Data Science Interview Q&A

Latest Data Science Blogs

Want answers to more Data Science questions?

Stay in the loop — it’s free

You’re on the list!