SQL Summary(3)

SQL Summary(3)

Stored Procedure

     A stored procedure which calls by itself until it reaches some boundary condition. This recursive function or procedure helps programmers to use the same set of code any number of times.Stored procedure can be used as a modular programming – means create once, store and call for several times whenever required. This supports faster execution instead of executing multiple queries. This reduces network traffic and provides better security to the data. However, it can be executed only in the Database and utilizes more memory in the database server.

Online Transaction Processing (OLTP)

     Online Transaction Processing (OLTP) manages transaction based applications which can be used for data entry, data retrieval and data processing. OLTP makes data management simple and efficient. Unlike OLAP systems goal of OLTP systems is serving real-time transactions. An example will be shopping online and use card to pay for it on a transaction webpage.

CLAUSE

     SQL clause is defined to limit the result set by providing condition to the query. This usually filters some rows from the whole set of records.

   I think this three is the most important one and the ones that are the most connected to our daily life. As this three affects online shopping, the storage of the device and also cloud disks.

What I'll be doing tomorrow?

I will be reviewing more SQL summaries tomorrow.