Analyzing TPS Implementation: The Case of Osaka Flower Coffee Shop

This case study explores the implementation of a Transaction Processing System (TPS) at Osaka Flower Coffee Shop, owned by Duy Tran, to address issues like employee theft and inefficiency. The analysis covers the business context, including seating capacity, customer turnover, and revenue projections. It discusses how TPS can help monitor employee performance, track transactions, and improve internal controls. The study also acknowledges challenges such as the need for skilled labor, potential costs, and the importance of security. Furthermore, the risks associated with scope, timeline, and budget are considered, along with the need for strategies to address competition and internal issues beyond the capabilities of TPS. The conclusion highlights the potential benefits of TPS in enhancing organizational performance and preventing financial losses, while emphasizing the importance of comprehensive business strategies.

Running head: TRANSACTION PROCESSING SYSTEM
TRANSACTION PROCESSING SYSTEM
Name of Student
Name of University
Author’s Note

1TRANSACTION PROCESSING SYSTEM
Table of Contents
Introduction.........................................................................................................................................3
Discussion.............................................................................................................................................4
Conclusion.............................................................................................................................................8
References...........................................................................................................................................10

2TRANSACTION PROCESSING SYSTEM
Executive summary
The features of Transaction Processing System are performance, reliability as well as
consistency. In this system the results of every transaction of provided immediately without
any sort of waiting time. There is no delay even when there are a huge number of requests
that are being processed at the same time. These transaction data are stored as well as
executed. OLAP is considered as one of the most common mode that could be used, it is
comparatively more expensive than batch processing mode. In this particular system, the
database is always kept out of date. The overall processing of the processing of transactions
depending to a particular degree on the individual’s nature. Various elements of transact
processing including the concept of data capture as well as validation, transaction,
maintenance of the database and many more. This assignment discusses regarding the
application of TPS in the Osaka Flower coffee shop. It further presents a business case of the
organization which provides a detailed idea of the overall business.

3TRANSACTION PROCESSING SYSTEM
Introduction
Transaction processing system could be considered as a particular information
processing system for various business transactions, these transactions involve collection,
retrieval and modification of the transaction data. Various characteristics of TPS are
performance, reliability as well as consistency (Peters & Panayi 2016, p. 175). TPS can also
be known as the real time processing. This system along with transaction processing is
contrasted with the batch process system as well as batch processing where numerous
requests get executes at the same time. The initial part requires interaction of users, whereas
the batch processing do not need a particular user involvement (Wei, Shi & Chen 2015, p.
153). In this system the results of every transaction of provided immediately without any sort
of waiting time. There is no delay even when there are a huge number of requests that are
being processed at the same time. These transaction data are stored as well as executed. In
this process the errors are very rare and occur due to some serious issues. For the purpose of
achieving performance, consistency as well as reliability data might be accessible in the data
warehouse (Meehan, Tatbul & Zdonik 2015, p. 86). Various backup procedures must be kept
in proper place and the process of recovery must be in proper place for dealing with systems
failure, computer virus, human failure, natural disasters and software applications. This
assignment discusses regarding the application of TPS in the Osaka Flower coffee shop. It
further represents a business case of the organization which provides a detailed idea of the
overall business of the organization.

4TRANSACTION PROCESSING SYSTEM
Discussion
Coffee shop busies case
Seating
Max
Turn
Days
Open Eat in Take
away
25.0 3.-00 354.0 0.6 0.4
Month
1 Month 2 Month 3 Month 4 Month 5
Revenue projection
passing the footfall per day 5000.0 5000.0 5000.0 5000.0 5000.0
percent customers 1.0 2.0 2.5 2.8 3.0
total number of customers a
day 50.0 100.0 125.0 138.0 150.0
rate of seat turnover 1.2 2.4 3.0 3.3 3.6
Eat in
eat in customers per day 30.0 60.0 75.0 83.0 90.0
cover price 5.6 5.8 6.0 6.1 6.2
revenue per day 170.0 350.0 450.0 505.0 562.0
revenue per month 60109.0 123829.0 159300.0
178735.
0
198806.
0
Take away
take away customers every
day 20.0 40.0 50.0 55.0 60.0
cover price 2.2 4.4 4.5 4.6 4.7
revenue per day 85.0 175.0 225.0 252.0 281.0
revenue per month 30019.0 61878.0 79650.0 89367.0 99403.0
Other revenue
merchandise 600.0 1200.0 1600.0 1800.0 2000.0
sundry 1200.0 2500.0 3200.0 3600.0 4000.0
Other revenue 1800.0 3700.0 4800.0 5400.0 6000.0
Total Costs 99093.0 198846.6 254491.0
284951.
8
316369.
5

5TRANSACTION PROCESSING SYSTEM
Table: Coffee shop busies case
(Source: created by author)
Duy can make the TPS system work along with the infrastructure which he as well as
his staffs are using in this particular business, the TPS could be implemented and a new
group of staffs can be recruited for the purpose of monitoring the performance of the entire
system (Arasu, Eguro & Joglekar 2015, p. 93). Duy can himself monitor the performance of
the staff who are in charge of the implementation of TPS. The staffs can implement s strategy
for the actual purpose of implementation of TPS within this particular system. The strategy
can include various categories in which the systems as well as the performance of the
employees would be monitored (Mahato & Singh 2017, p. 127). Double checking the
transactions is the best way buy which the TPS system can be used. Though the TPS system
would be responsible for carrying out all the transaction that would be carried out within the
organization, but double checking a particular transaction would be a good way by which any
sort of error can be detected, this is because previously few staffs were accused to be stealing
money from the overall transactions that was carried out by the organization, after the
implementation if they attempt to steal money, they would get caught and even after that, if
they are successful in stealing money by any means, they would claim that the system is
defective or it has some technical issues (Yu, Cao & Huang 2017, p. 129). Besides this, the
organization might face issues because of the lack of skilled labours who has the idea of how
the system actually works. For this purpose the organization can provide training to their
employees for the purpose of using the system in an effective manner. In order to accomplish
TPS, two modes can be used, these modes include online mode and batch mode (Mahato,
Singh & Tripathi 2017, p. 95). This system would also help the organization in tracking the
performance of the employees. The employees used to steal money from the revenue of the
organization. Duy would also be able to track which employees are working in an effective

6TRANSACTION PROCESSING SYSTEM
manner and who has arrived in time and left in time. In case any employee tries to clock for
other employee, they would be caught (Sompolinsky & Zohar 2015, p. 174). Every employee
would be provide with a particular unique code, this code would be provided as an input to
the system, the ID card of the employee would be scanned or scan their fingerprint for the
purpose of fingerprint recognition device for the purpose of clocking in as well as out (Li, Ge
& Wu 2017, p. 39). This would help Duy in knowing when the employees actual attended the
employees.
Duy can involve various vendors that provide the advantage of implementing TPS,
these vendors charge on the basis of the usage of the system. These would add up to the cost
that is incurred in the entire system (Chen, Chen & Wei 2017, p. 126). This would result in
increased cost that would be required for the purpose of TPS system. The organization can
also make use of various partners for the purpose of providing security to the system as well
as the transactions that are undertaken within the organization. The contractors can be
involved for the purpose creating some sort of contract with other organizations (Elmore,
Duggan & Stonebraker 2015, p. 116). This would help building in relationship with various
organizations, the proper building of organization relationship can help in providing extended
support to the organization in various aspects.
The risks that must be considered which might have impact on the actual scope,
timeline as well as budget of the implementation are as follows
The main issues that are addressed by the TPS include the necessity of handling
hundreds and thousands of users, the necessity of allowing numerous users for working on
the similar collection of information along with an update that is immediate in nature (Hu,
Zhou & Zhu 2019, p. 135). One more issue that is resolved by TPS include the requirement
of handling various errors in a safe as well as consistent manner. Besides these there are

7TRANSACTION PROCESSING SYSTEM
various challenges that are faced in the process of implementing TPS, these issues are as
follows
Scope: the implementation of TPS might bring about changes within the scope of the
organization this is because when the scope had been stated, there was no existence of the
system, hence it might affect in changing the entire scope of the organization.
Timeline: the timeline of the project of implementation might be affected. Due to
some issues like lack of workers, low budget and some more (Eroshkin, Kameneva &
Kovkov 2017, p. 175). The increase in timeline would result in increased time that would be
required for the purpose of completing the entire project.
Budget: the budget that would be required for this particular project would be high,
apart from implementing the TPS system, the contracts, labour and partnerships that would
be involved in the implementation would also require some amount of investment.
The software alone would not be able to solve all the problems that exists within the
organization. The issues that are faced by the o organization in the financial aspects can be
solved with the usage of TPS to some extent, some more issues that require added attention
include problems regarding competition (Chen, Wiener & Iyer 2016, p. 114). The two of the
coffee shops that are situated nearby the Osaka Flower coffee shop, provide a tough
competition to the organization, this issues could not be resolved with the use of TSP. in
order to mitigate this issue, better business strategies would be required to be implemented
within the organization. Some strategies include better ideas for more and new products that
could be manufactured, some innovation in the beverages which could result in attracting
new customers (Mithani, Salsburg & Rao 2018, p. 193). One more issue the organization
would need to address include internal issues. Internal issues are the major problems that
prevail within the organization. According to Duy, the staff belonging to the morning shift

8TRANSACTION PROCESSING SYSTEM
among the cashiers had stolen money from their revenue, this has been occurring since 5
months. Duy could not accuse him of doing so because there were no documents, receipts or
records which could be used for the purpose of evidence to substantiate the accusation. This
has allowed the cashier in continuing his theft, damaging the profit of the organization in a
significant manner (Yan, Yang & Zhang 2018, p. 93). Besides this one more internal problem
that has been facing by the organization include week internal control. This issue led to a
huge loss for the organization. Along with previously mentioned external problems that could
be explained with the help of its internal control. The employees had slacked off, the
employees as well as supervisors did not perform their activities with utmost loyalty
(Sompolinsky & Zohar 2015, p. 296). He had also reported that there had been numerous
cases when the employees did not come for working in time, or they did not come at all.
Besides this, they had asked other employees to clock their attendance so that they received
complete salary. This situation had a big negative impact on the profits of the shop.
Additional issues that was faced by the organization included theft, employees did not think
regarding the organization as all, this issue could be solved with the use of the TSP system.
Conclusion
Transaction processing systems are usually very helpful for organization in numerous
ways. Osaka Flower Coffee Shop had been planning to implement the TPS for various
purposes, this system would help them in monitoring the performance of the employees along
with tracking if they are stealing form the profit of the organization. Transaction processing
might be achieved in numerous modes, these modes include online mode and batch mode.
Features of online transaction processing include every transaction is completely processed in
an immediate manner upon entry. OLAP is considered as one of the most common mode that
could be used, it is comparatively more expensive than batch processing mode. In this
particular system, the database is always kept out of date. They require the usage of fast as

9TRANSACTION PROCESSING SYSTEM
well as secondary storage like magnetic disks. Overall transaction processing can also be
known as data processing, this reflects the principle activities of the business of a particular
firm. The principal processing subsystems of transactions in a particular firm are the ones that
are supporting like sales, production, inventory, purchasing, shipping, receiving, accounts
payable, billing, accounts receivable, payroll and general ledger. The overall processing of
the processing of transactions depending to a particular degree on the individual’s nature.
Various elements of transact processing including the concept of data capture as well as
validation, transaction, maintenance of the database and many more. The processing steps
that are dependent on transaction as well as on the processing mode, depending on the accrual
nature of various transactions as well as on weather that particular system operated in a
particular on line or a batch mode transaction. The steps that are carried out include
classification, this system tends to classify various incoming transactions for selecting further
steps for processing. One more step includes shorting transaction, these records have been
usually arranged in the format of value of the information which uniquely identifies every
system. Data retrieval is another step that is carried out in the implementation of the system.
This particular described regarding the implementation of TPS into the Osaka Flower Coffee
Shop. The organization has decided in implementing the system for numerous reasons.
Besides providing advantages, the system might also tend to provide various disadvantages,
these are mentioned above in a detailed manner.

10TRANSACTION PROCESSING SYSTEM
References
Arasu, A., Eguro, K., Joglekar, M., Kaushik, R., Kossmann, D. & Ramamurthy, R., 2015,
April. Transaction processing on confidential data using cipherbase. In 2015 IEEE 31st
International Conference on Data Engineering, pp. 435-446. IEEE.
Chen, G.J., Wiener, J.L., Iyer, S., Jaiswal, A., Lei, R., Simha, N., Wang, W., Wilfong, K.,
Williamson, T. & Yilmaz, S., 2016, June. Realtime data processing at Facebook.
In Proceedings of the 2016 International Conference on Management of Data. pp. 1087-
1098. ACM.
Chen, H., Chen, R., Wei, X., Shi, J., Chen, Y., Wang, Z., Zang, B. & Guan, H., 2017. Fast in-
memory transaction processing using rdma and htm. ACM Transactions on Computer
Systems (TOCS), vol 1, no. 35, p.3.
Elmore, A., Duggan, J., Stonebraker, M., Balazinska, M., Cetintemel, U., Gadepally, V.,
Heer, J., Howe, B., Kepner, J., Kraska, T. & Madden, S., 2015. A demonstration of the
BigDAWG polystore system. Proceedings of the VLDB Endowment, vol.12, no. 8, pp.1908-
1911.
Eroshkin, S.Y., Kameneva, N., Kovkov, D. & Sukhorukov, A., 2017. Conceptual system in
the modern information management. Procedia Computer Science, 103, pp.609-612.
Hu, H., Zhou, X., Zhu, T., Qian, W. & Zhou, A., 2019. In-memory transaction processing:
efficiency and scalability considerations. Knowledge and Information Systems, pp.1-32.
Li, J., Ge, Q., Wu, J., Li, Y., Yang, X. & Ma, Z., 2017. Research and implementation of a
distributed transaction processing middleware. Future Generation Computer Systems, 74,
pp.232-240.

11TRANSACTION PROCESSING SYSTEM
Mahato, D.P. & Singh, R.S., 2017. Balanced task allocation in the on‐demand computing‐
based transaction processing system using social spider optimization. Concurrency and
Computation: Practice and Experience, vol. 18, no. 29, p.e4214.
Mahato, D.P., Singh, R.S., Tripathi, A.K. & Maurya, A.K., 2017. On scheduling transactions
in a grid processing system considering load through Ant Colony Optimization. Applied Soft
Computing, 61, pp.875-891.
Meehan, J., Tatbul, N., Zdonik, S., Aslantas, C., Cetintemel, U., Du, J., Kraska, T., Madden,
S., Maier, D., Pavlo, A. & Stonebraker, M., 2015. S-Store: streaming meets transaction
processing. Proceedings of the VLDB Endowment, vol. 13, no. 1, pp.2134-2145.
Mithani, M.F., Salsburg, M.A. & Rao, S., 2018. A decision support system for moving
workloads to public clouds. GSTF Journal on Computing (JoC), vol.1, no. 1.
Peters, G.W. and Panayi, E., 2016. Understanding modern banking ledgers through
blockchain technologies: Future of transaction processing and smart contracts on the internet
of money. In Banking beyond banks and money (pp. 239-278). Springer, Cham.
Sompolinsky, Y. & Zohar, A., 2015, January. Secure high-rate transaction processing in
bitcoin. In International Conference on Financial Cryptography and Data Security. pp. 507-
527. Springer, Berlin, Heidelberg.
Wei, X., Shi, J., Chen, Y., Chen, R. & Chen, H., 2015, October. Fast in-memory transaction
processing using RDMA and HTM. In Proceedings of the 25th Symposium on Operating
Systems Principles. pp. 87-104. ACM.
Yan, X., Yang, L., Zhang, H., Lin, X.C., Wong, B., Salem, K. & Brecht, T., 2018, May.
Carousel: low-latency transaction processing for globally-distributed data. In Proceedings of
the 2018 International Conference on Management of Data, pp. 231-243. ACM.