technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: May 2010
http://technicalkriti.blogspot.com/2010_05_01_archive.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Saturday, May 8, 2010. Concurrent Execution in DBMS Part 4 - View Serializability. Two schedules are said to be View Serializable if -. For any data item, if instruction Ti reads the initial value of Q in first schedule, then in second schedule also Ti should read initial value of Q. Let's look at one example:. Using the conditions above, we can swap W(X) of T1 with W(X) of T2. Below ...
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: sftp without password
http://technicalkriti.blogspot.com/2010/05/sftp-without-password.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Tuesday, May 4, 2010. In today's distributed software environments, many times it is required to send/receive some file from/to a remote server. The utility mostly used for this is FTP. As the communication needs to be secured, Secured FTP or SFTP is used. Without password can be done using public/private keys. Below is the procedure how to do this. For doing password less. Public key wil...
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: June 2010
http://technicalkriti.blogspot.com/2010_06_01_archive.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Saturday, June 5, 2010. Thread Pooling - Efficient way of using Threads. The answer is - NO. Creation and termination of Threads is a performance and resource intensive task. Then what can be done? The answer is - Thread Pooling. Now we need to add required number of Threads in the Thread Pool. This typically is done by having some code that is invoked while creating the Thread Pool o...
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: Concurrent Execution in DBMS Part 2 - Schedules
http://technicalkriti.blogspot.com/2010/05/concurrent-execution-in-dbms-part-2.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Friday, May 7, 2010. Concurrent Execution in DBMS Part 2 - Schedules. For understanding concept of correct concurrent execution of transactions, we need a way to represent the execution sequences of transactions. These are called Schedules. Schedules are execution sequences of transaction in a Database System. Below is one such Schedule:. Below is a more technical definition of Schedules:.
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: Thread Pooling - Efficient way of using Threads
http://technicalkriti.blogspot.com/2010/06/thread-pooling-efficient-way-of-using.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Saturday, June 5, 2010. Thread Pooling - Efficient way of using Threads. The answer is - NO. Creation and termination of Threads is a performance and resource intensive task. Then what can be done? The answer is - Thread Pooling. Now we need to add required number of Threads in the Thread Pool. This typically is done by having some code that is invoked while creating the Thread Pool o...
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: Concurrent Execution in DBMS
http://technicalkriti.blogspot.com/2010/05/concurrent-execution-in-dbms.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Friday, May 7, 2010. Concurrent Execution in DBMS. Improved throughput and resource utilization :. Less waiting time :. Without concurrency, a short transaction might need to wait for a long transaction to finish causing delay in its execution. With multiple transactions running on the system, new transactions have to wait for less time before getting executed. You are Visitor No. Concurr...
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: DBMS_STATS package - Collecting stats for DB Objects
http://technicalkriti.blogspot.com/2010/04/dbmsstats-package-collecting-stats-for.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Wednesday, April 28, 2010. DBMS STATS package - Collecting stats for DB Objects. Oracle provides mechanism for collecting statistics for various database objects. These stats are used by the optimizer while making the execution plan for queries. Oracle provides DBMS STATS package for this purpose. There are many different packages inside the package to perform various functions.
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: April 2010
http://technicalkriti.blogspot.com/2010_04_01_archive.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Wednesday, April 28, 2010. DBMS STATS package - Collecting stats for DB Objects. Oracle provides mechanism for collecting statistics for various database objects. These stats are used by the optimizer while making the execution plan for queries. Oracle provides DBMS STATS package for this purpose. There are many different packages inside the package to perform various functions.
technicalkriti.blogspot.com
TechnicalKriti - A Technical Blog: Concurrent Execution in DBMS Part 3 - Conflict Serializability
http://technicalkriti.blogspot.com/2010/05/concurrent-execution-in-dbms-part-2_08.html
TechnicalKriti - A Technical Blog. Get Electrician, Plumber, Carpeneter, Painter at your home www.serviceplatter.com. Saturday, May 8, 2010. Concurrent Execution in DBMS Part 3 - Conflict Serializability. In my last post, we talked about Schedule equivalence. If a schedule produces the same output as another schedule, the two schedule are called equivalent. We will look at Conflict Serializability in this post and View Serializability in my next post. So we saw that write instruction always conflicts wit...