Database Performance Management in Cloud

Navendu Mishra; Jayant Sawarkar; Suraj Dubey

doi:10.31033/ijemr.10.5.11

Navendu Mishra
Jayant Sawarkar
Suraj Dubey

DOI: https://doi.org/10.31033/ijemr.10.5.11

Keywords: AWS Cloud, Database, ERP, Hotels, PL/SQL, S3 Bucket and Query

Abstract

Managing large chain of Hotels and ERP database comprises of core areas such as HRMS & PIP.HRMS (Human Resource Management System), which further includes areas such as Soft Joining, Promotion, Transfer, Confirmation, Leave Attendance and Exit, etc. PIP (Payroll Information Portal), wherein employees can view their individual Salary details, submit investment declaration, Reimbursement claim & CTC structuring, etc. Management of Large Chain of Hotels and ERP Database in AWS Cloud involves continuous monitoring with regards to the areas such as Performance of resource usages and optimization techniques relating to the use of PL/SQL. High Availability (HA) of data is accomplished through the Backup and Recovery mechanism and security of the data by Encryption & Decryption mechanism.

Downloads

Download data is not yet available.

References

Badger, L., Grance, T., Robert, P., & Voas, J. (2012). Computer security. DRAFT cloud computing synopsis and recommendations. NIST Special Publication, pp. 800.

Barbara, J., Jo, A., Cynthia, S., & Adam, T. (2009). Collaboration using cloud computing and traditional systems. Western Carolina University, 10(2), 27-32.

Dykstra, J. & Alan, T. (2012). Acquiring evidence form infrastructure-as-a-service cloud computing: Exploring the evaluation tools, trust and techniques. Digital Investigation, S90-S98.

Hofer, C. & Karagiannis, G. (2011). Cloud computing services: Taxonomy and comparison. Available at: http://link.springer.com/article/10.1007%2Fs13174-011-0027-x.

Lazewski, V., Javier, D., Fugang, W., & Geoffrey, C. (2012). Comparison of multiple cloud frame works. Available at: http://www.academia.edu/2929921/Qualitative_Comparison_of_Multiple_Cloud_Frameworks.

R. Buyya, C. Vecchiola, & S. T. Selvi. (2013). Mastering cloud computing: Foundations and applications programming. Elsevier.

P. K. Paul, K. Kumar, & D. Chaterjee. (2014). Cloud computing emphasizing emerging possibilities to the entire information infrastructure. Trends in Information Management (TRIM), 9(2).

Worldwide cloud computing market shares, strategies, and forecasts, 2009-2015. (2014 Dec). Available at: http://www.researchandmarkets.com/reports/1057978/worldwide_cloud_computing_market_shares.

P. Mell & T. Grance. (2011). The NIST definition of Cloud computing. NIST Special Publication.

J. Harris & A. Alter. (2010). Cloud rise: Rewards and risks at the dawn of cloud computing. Accenture Institute for High Performance Research Report, pp. 5-30.