About Transaction Processing System

About Transaction Processing System

According Dan Matthews and Rick Veague that databases are the integration point where applications that are connected can communicate with each other. Now, Companies are investing for a new technology that eliminates or lessen errors and to gain advantage. This is the integration point that is necessary in building competence in management by investing in database technology to achieve lessen cost. ( Matthews D.& Veague R. (2007). Why Database-agnostic Enterprise Applications Are on the Way Out. Retrieved on September 12,2012, From http://www.technologyevaluation.com/research/ articles/why-databaseagnostic-enterprise-applications-are-on-the-way-out-18920/) According to Arnie Alvarez that networked storage system makes IT managers act like storage specialist and has the ability to meet the needs of future customers. How, by reducing its number of servers, and helping minimize maintenance and operating overheads, while increasing processing capability, storage capacity and ultimately, uptime for the business. Information infrastructure technology gives solutions that enable organizations of all sizes to transform the way they compete and create value from their information.
((2008, October – December) Prime Communications Enhances SME Reach with EMC Information Infrastructure. Business Processing Association Philippines. pAD20)

According to SEARCA that an appropriately networked information technology structure that supports connectivity and access to network resources and internet services increase the reliability and performance that help improve its services. Also, the necessary IT facilities toward an enhanced data recovery strategy and more secure access to internet services were set up. Transaction processing systems (TPS) are the backbone of an organization because they update constantly at any given time because someone may need an inventory balance, an account balance or the total current value of a financial portfolio. Another one is the Online Transaction Processing (OLTP) which is the web-based counterpart of TPS. Computerization of every process reduces human errors and processing time, it can also boost up productivity. There must haves by any computer data storage, therefore, remain constant, able it to varying degrees according to buyers. These are the best means for storage and management of data to serve as huge knowledge base and can be used in different financial transactions.
(SEARCA (2009). SEAMEO SEARCA Annual Reports FY 2008/2009.,37-38)

According to DVLB that you will get better result if you use a specialized data engine rather than using traditional database system. TPS and OLTP are examples of a specialized data engine. Some applications can put their entire data set into the memory of a modern shared-nothing cluster of server machines. An external applications need to be connected first to execute a transaction. Most of the time, they repeatedly execute the same transaction. A transaction is an instance initiated by TPS application that requires parameter values as input.

According to Microsoft that transactions are completed successfully as a group but if any step fails, no other steps can be completed. Most TPS databases are designed to have good data placement, runs on single stored procedure transactions that minimize long-term locks and improve concurrency, can back up a database while it is being used, reduce redundant information, and can handle the large numbers of concurrent users and quick response.
(Online Transaction Processing vs. Decision Support. Retrieved on September 12, 2012, From http://msdn.microsoft.com/en-us/library/ms187669%28v=sql.105%29.aspx) According to Phoebe Magdirila and Rafael Mejia, “Today, any company, regardless of size, has depended on their IT teams as if it were the life and blood of their operations.” Technology is being developed that it evolves so fast that most modern technologies are not limited to companies that small end users can use it. This lead to a big expectation to Information Technology (IT) organizations’ systems that will be develop in the future.
(Magdirila, P. & Mejia, R. (2011). Bringing IT Innovation to Healthcare. Computer World Philippines, December 2011- January 2012, 11- 14.)

According to Gary B. Shelly et al. that TPS is among the first computerize system that process that process business data by using batch processing. Batch processing is where the computer gets all the data or transaction first before processing it. It is commonly use by enterprise-size organizations in calculating paychecks and producing reports where data is presented as table or graphs.
(Shelly, G. B., Vermaat, M. E., Quasney, J. J., Sebok ,S. L., Webb, J. J. (2008). Discovering Computers 2009: Complete. Cengage Learning Inc.